Sample script for assigning one item to an organization
DECLARE
g_user_id fnd_user.user_id%TYPE :=NULL;
l_appl_id fnd_application.application_id%TYPE;
l_resp_id fnd_responsibility_tl.responsibility_id%TYPE;
l_api_version NUMBER := 1.0;
l_init_msg_list VARCHAR2(2) := fnd_api.g_false;
l_commit VARCHAR2(2) := FND_API.G_FALSE;
x_message_list error_handler.error_tbl_type;
x_return_status VARCHAR2(2);
x_msg_count NUMBER := 0;
BEGIN
SELECT fa.application_id
INTO l_appl_id
FROM fnd_application fa
WHERE fa.application_short_name = 'INV';
SELECT fr.responsibility_id
INTO l_resp_id
FROM fnd_application fa, fnd_responsibility_tl fr
WHERE fa.application_short_name = 'INV'
AND fa.application_id = fr.application_id
AND UPPER (fr.responsibility_name) = 'INVENTORY';
fnd_global.apps_initialize (g_user_id, l_resp_id, l_appl_id);
EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG(
P_API_VERSION => l_api_version
, P_INIT_MSG_LIST => l_init_msg_list
, P_COMMIT => l_commit
, P_INVENTORY_ITEM_ID => 1003
, p_item_number => 000000000001035
, p_organization_id => 11047
, P_ORGANIZATION_CODE => 'DXN'
, P_PRIMARY_UOM_CODE => 'EA'
, X_RETURN_STATUS => x_return_status
, X_MSG_COUNT => x_msg_count
);
DBMS_OUTPUT.PUT_LINE('Status: '||x_return_status);
IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
DBMS_OUTPUT.PUT_LINE('Error Messages :');
Error_Handler.GET_MESSAGE_LIST(x_message_list=>x_message_list);
FOR j IN 1..x_message_list.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(x_message_list(j).message_text);
END LOOP;
END IF;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('Exception Occured :');
DBMS_OUTPUT.PUT_LINE(SQLCODE ||':'||SQLERRM);
END;
分享到:
相关推荐
压缩包里有英文原版,还有本人经过两天不懈奋斗才翻译出来的中文版。谦虚使人进步,我承认里面会有些须错误,但不影响阅读。望谅解
Shows how to assign controls to different forms at run time.
Unlike a multiplexer that selects one individual data input line and then sends that data to a single output line or switch, an Encoder takes all the data inputs one at a time and converts them to a ...
这里的key就是Android的testkey文件,很方便使用哦。 SignApk.jar is a tool included with the Android ... To use SignApk.jar you have to create a private key with it’s corresponding certificate/public key
Attempted to assign to readonly property报错 起因:项目中写了个点击事件,增加动态效果,类似于转一转,rotate(360)。很简单的一个特效。 设置元素的transition:transform 1s。 然后动态改变元素的transfrom:...
Classifying an object means to assign an object to one of several available classes. When working with images, the objects usually are pixels or regions. Objects are described by features, which ...
test
Uncaught TypeError: Cannot assign to read only property 'exports' of object '#<Object>' 点开错误的文件,标注错误的地方是这样的一段代码: import {normalTime} from './timeFormat'; module....
问题描述: 当想替换字符串内的部分习惯表述时报错,源码如下: num1 = int(input(请输入起始序数n1:)) num2 = int(input(请输入结束序数n2:)) fuc = input(请输入以n为变量的通项公式(eg:2*n+1):) ...
Section 4.5.2.4.2 Assign Cable SOP* State is incorrect. Passive cables never respond on SOP” per USB PD. The change is to remove the sentence “If two eMarkers are powered at the same time in a ...
对于Retain和Assign属性的理解
retain和copy还有assign的区别
针对iOS 对象的属性的关键字(retain/assign/readonly等)的区别。彻底解决您的疑惑。
Using MSI to EXE Creator you can even assign customer icon to your installer. Created EXE setups or installer are fully compatible and easily work with Windows 98/2000/XP/2003/Vista. Features of ...
多线程TCP通信 界面是qml写的
详细讲解了ios中常用关键字的使用方法的区别,着重讲解了assign,retain,copy之间的区别
Micopi allows you to assign an image to every person in your telephone's contact list. So if you do not happen to have a (decent) photo of them, you can use the app to simply generate one. Micopi does...
从服务端收到的json中有中文 然后JsonData jd = JsonMapper.ToObject(strJson); json中如有中文 会出现\uXXXX\uXXXX等 我改了下 上传了能解决此问题的litjson版本
SyntaxError: can't assign to conditional expression expression是表达式,就是加减乘除等各种运算符号连接起来的式子(statement是语句,如if语句,while,复制语句等); 三目运算中表达式只能作为左值 修改后:...
Cannot assign configuration entry 'pluginArtifacts' with value '${plugin.artifacts}' of type java.ut