eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_IMPORT_PVT dependencies on INVPUOPI

Line 290: dumm_status := INVPUOPI.mtl_log_interface_err(

286: FOR i IN c_ssxref_null_msii LOOP
287: IF i.PROCESS_FLAG = 33379 THEN
288: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');
289: l_msg_text := FND_MESSAGE.GET;
290: dumm_status := INVPUOPI.mtl_log_interface_err(
291: i.ORGANIZATION_ID
292: ,l_user_id
293: ,l_login_id
294: ,l_prog_appid

Line 307: dumm_status := INVPUOPI.mtl_log_interface_err(

303:
304: ELSIF i.PROCESS_FLAG = 33389 THEN
305: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');
306: l_msg_text := FND_MESSAGE.GET;
307: dumm_status := INVPUOPI.mtl_log_interface_err(
308: i.ORGANIZATION_ID
309: ,l_user_id
310: ,l_login_id
311: ,l_prog_appid

Line 328: dumm_status := INVPUOPI.mtl_log_interface_err(

324: FOR i IN c_ssxref_null_miri LOOP
325: IF i.PROCESS_FLAG = 33379 THEN
326: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');
327: l_msg_text := FND_MESSAGE.GET;
328: dumm_status := INVPUOPI.mtl_log_interface_err(
329: i.ORGANIZATION_ID
330: ,l_user_id
331: ,l_login_id
332: ,l_prog_appid

Line 344: dumm_status := INVPUOPI.mtl_log_interface_err(

340: ,l_err_text);
341: ELSIF i.PROCESS_FLAG = 33389 THEN
342: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');
343: l_msg_text := FND_MESSAGE.GET;
344: dumm_status := INVPUOPI.mtl_log_interface_err(
345: i.ORGANIZATION_ID
346: ,l_user_id
347: ,l_login_id
348: ,l_prog_appid

Line 365: dumm_status := INVPUOPI.mtl_log_interface_err(

361: FOR i IN c_ssxref_null_mici LOOP
362: IF i.PROCESS_FLAG = 33379 THEN
363: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');
364: l_msg_text := FND_MESSAGE.GET;
365: dumm_status := INVPUOPI.mtl_log_interface_err(
366: i.ORGANIZATION_ID
367: ,l_user_id
368: ,l_login_id
369: ,l_prog_appid

Line 381: dumm_status := INVPUOPI.mtl_log_interface_err(

377: ,l_err_text);
378: ELSIF i.PROCESS_FLAG = 33389 THEN
379: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');
380: l_msg_text := FND_MESSAGE.GET;
381: dumm_status := INVPUOPI.mtl_log_interface_err(
382: i.ORGANIZATION_ID
383: ,l_user_id
384: ,l_login_id
385: ,l_prog_appid

Line 402: dumm_status := INVPUOPI.mtl_log_interface_err(

398: FOR i IN c_ssxref_null_eiuai LOOP
399: IF i.PROCESS_STATUS = 33379 THEN
400: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');
401: l_msg_text := FND_MESSAGE.GET;
402: dumm_status := INVPUOPI.mtl_log_interface_err(
403: i.ORGANIZATION_ID
404: ,l_user_id
405: ,l_login_id
406: ,l_prog_appid

Line 418: dumm_status := INVPUOPI.mtl_log_interface_err(

414: ,l_err_text);
415: ELSIF i.PROCESS_STATUS = 33389 THEN
416: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');
417: l_msg_text := FND_MESSAGE.GET;
418: dumm_status := INVPUOPI.mtl_log_interface_err(
419: i.ORGANIZATION_ID
420: ,l_user_id
421: ,l_login_id
422: ,l_prog_appid

Line 439: dumm_status := INVPUOPI.mtl_log_interface_err(

435: FOR i IN c_ssxref_null_eipi LOOP
436: IF i.PROCESS_STATUS = 33379 THEN
437: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');
438: l_msg_text := FND_MESSAGE.GET;
439: dumm_status := INVPUOPI.mtl_log_interface_err(
440: i.ORGANIZATION_ID
441: ,l_user_id
442: ,l_login_id
443: ,l_prog_appid

Line 455: dumm_status := INVPUOPI.mtl_log_interface_err(

451: ,l_err_text);
452: ELSIF i.PROCESS_STATUS = 33389 THEN
453: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');
454: l_msg_text := FND_MESSAGE.GET;
455: dumm_status := INVPUOPI.mtl_log_interface_err(
456: i.ORGANIZATION_ID
457: ,l_user_id
458: ,l_login_id
459: ,l_prog_appid

Line 476: dumm_status := INVPUOPI.mtl_log_interface_err(

472: FOR i IN c_ssxref_null_eai LOOP
473: IF i.PROCESS_FLAG = 33379 THEN
474: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');
475: l_msg_text := FND_MESSAGE.GET;
476: dumm_status := INVPUOPI.mtl_log_interface_err(
477: i.ORGANIZATION_ID
478: ,l_user_id
479: ,l_login_id
480: ,l_prog_appid

Line 492: dumm_status := INVPUOPI.mtl_log_interface_err(

488: ,l_err_text);
489: ELSIF i.PROCESS_FLAG = 33389 THEN
490: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');
491: l_msg_text := FND_MESSAGE.GET;
492: dumm_status := INVPUOPI.mtl_log_interface_err(
493: i.ORGANIZATION_ID
494: ,l_user_id
495: ,l_login_id
496: ,l_prog_appid

Line 513: dumm_status := INVPUOPI.mtl_log_interface_err(

509: FOR i IN c_ssxref_null_assocs LOOP
510: IF i.PROCESS_FLAG = 33379 THEN
511: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');
512: l_msg_text := FND_MESSAGE.GET;
513: dumm_status := INVPUOPI.mtl_log_interface_err(
514: i.ORGANIZATION_ID
515: ,l_user_id
516: ,l_login_id
517: ,l_prog_appid

Line 529: dumm_status := INVPUOPI.mtl_log_interface_err(

525: ,l_err_text);
526: ELSIF i.PROCESS_FLAG = 33389 THEN
527: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');
528: l_msg_text := FND_MESSAGE.GET;
529: dumm_status := INVPUOPI.mtl_log_interface_err(
530: i.ORGANIZATION_ID
531: ,l_user_id
532: ,l_login_id
533: ,l_prog_appid

Line 2462: dumm_status := INVPUOPI.mtl_log_interface_err(

2458: FND_MESSAGE.Set_Name('EGO', 'EGO_IMPORT_DUPLICATE_ITEMS');
2459: FND_MESSAGE.Set_Token('ITEM_NUMBER', l_merged_rows(i).ITEM_NUMBER);
2460: FND_MESSAGE.Set_Token('ORG_ID', l_merged_rows(i).ORGANIZATION_ID);
2461: l_msg_text := FND_MESSAGE.GET;
2462: dumm_status := INVPUOPI.mtl_log_interface_err(
2463: l_merged_rows(i).ORGANIZATION_ID
2464: ,l_user_id
2465: ,l_login_id
2466: ,l_prog_appid

Line 5157: dumm_status := INVPUOPI.mtl_log_interface_err(

5153: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
5154: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
5155: l_msg_text := FND_MESSAGE.GET;
5156:
5157: dumm_status := INVPUOPI.mtl_log_interface_err(
5158: i.ORGANIZATION_ID
5159: ,l_user_id
5160: ,l_login_id
5161: ,l_prog_appid

Line 5184: dumm_status := INVPUOPI.mtl_log_interface_err(

5180: l_gtin := TO_NUMBER(i.GLOBAL_TRADE_ITEM_NUMBER);
5181: EXCEPTION WHEN VALUE_ERROR THEN
5182: Debug_Conc_Log('Validation Failed - GTIN is not a Number');
5183: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_NOT_NUMBER');
5184: dumm_status := INVPUOPI.mtl_log_interface_err(
5185: i.ORGANIZATION_ID
5186: ,l_user_id
5187: ,l_login_id
5188: ,l_prog_appid

Line 5204: dumm_status := INVPUOPI.mtl_log_interface_err(

5200: --2. validating the length of GTIN to be 14
5201: IF LENGTH(i.GLOBAL_TRADE_ITEM_NUMBER) <> 14 THEN
5202: Debug_Conc_Log('Validation Failed - Length is not 14 chars');
5203: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_LENGTH_NOT_CORRECT');
5204: dumm_status := INVPUOPI.mtl_log_interface_err(
5205: i.ORGANIZATION_ID
5206: ,l_user_id
5207: ,l_login_id
5208: ,l_prog_appid

Line 5224: dumm_status := INVPUOPI.mtl_log_interface_err(

5220: --3. validating the check digit of GTIN to be valid
5221: IF (NOT l_error) AND EGO_GTIN_ATTRS_PVT.Is_Check_Digit_Invalid(i.GLOBAL_TRADE_ITEM_NUMBER) THEN
5222: Debug_Conc_Log('Validation Failed - Check digit is not valid');
5223: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_CHECKDIGIT_INVALID');
5224: dumm_status := INVPUOPI.mtl_log_interface_err(
5225: i.ORGANIZATION_ID
5226: ,l_user_id
5227: ,l_login_id
5228: ,l_prog_appid

Line 5244: dumm_status := INVPUOPI.mtl_log_interface_err(

5240: --4. gtin can not contain more than six leading zeros
5241: IF SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 1, 7) = '0000000' THEN
5242: Debug_Conc_Log('Validation Failed - gtin can not contain more than six leading zeros');
5243: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_LEADING_ZERO_INVALID');
5244: dumm_status := INVPUOPI.mtl_log_interface_err(
5245: i.ORGANIZATION_ID
5246: ,l_user_id
5247: ,l_login_id
5248: ,l_prog_appid

Line 5265: dumm_status := INVPUOPI.mtl_log_interface_err(

5261: IF SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 2, 1) = '0' AND
5262: SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 3, 1) NOT IN ('0', '1', '3', '6', '7', '8', '9') THEN
5263: Debug_Conc_Log('Validation Failed - The third digit from the left contained in a GTIN must be 0,1,3,6,7,8,9 when the second digit from the left is 0 ');
5264: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_THIRD_DIGIT_INVALID');
5265: dumm_status := INVPUOPI.mtl_log_interface_err(
5266: i.ORGANIZATION_ID
5267: ,l_user_id
5268: ,l_login_id
5269: ,l_prog_appid

Line 5286: dumm_status := INVPUOPI.mtl_log_interface_err(

5282: IF (NOT l_error) AND SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 1, 6) = '000000' AND
5283: TO_NUMBER(SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 7, 3)) NOT BETWEEN 301 AND 968 THEN
5284: Debug_Conc_Log('Validation Failed - If a GTIN in a RCI message has six leading zeros, digits 7-9 must be between 301-968');
5285: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_7TO9DIGIT_INVALID');
5286: dumm_status := INVPUOPI.mtl_log_interface_err(
5287: i.ORGANIZATION_ID
5288: ,l_user_id
5289: ,l_login_id
5290: ,l_prog_appid

Line 5306: dumm_status := INVPUOPI.mtl_log_interface_err(

5302: -- 7. GTINs submitted in RCI messages cannot contain values 0980-0989 or 099 in the first 4 digits
5303: IF SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 1, 3) IN ('098', '099') THEN
5304: Debug_Conc_Log('Validation Failed - GTINs submitted in RCI messages cannot contain values 0980-0989 or 099 in the first 4 digits');
5305: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_0TO4_DIGIT_INVALID');
5306: dumm_status := INVPUOPI.mtl_log_interface_err(
5307: i.ORGANIZATION_ID
5308: ,l_user_id
5309: ,l_login_id
5310: ,l_prog_appid

Line 5327: dumm_status := INVPUOPI.mtl_log_interface_err(

5323: IF (NOT l_error) AND (SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 2, 2) IN ('02', '04', '05') OR
5324: TO_NUMBER(SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 2, 2)) BETWEEN 10 AND 29) THEN
5325: Debug_Conc_Log('Validation Failed - GTINs submitted in RCI messages cannot contain values 02, 04, 05, and 10-29 in the second and third digits from the left');
5326: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_2TO3_DIGIT_INVALID');
5327: dumm_status := INVPUOPI.mtl_log_interface_err(
5328: i.ORGANIZATION_ID
5329: ,l_user_id
5330: ,l_login_id
5331: ,l_prog_appid

Line 5362: dumm_status := INVPUOPI.mtl_log_interface_err(

5358: FND_MESSAGE.Set_Token('GTIN', i.GLOBAL_TRADE_ITEM_NUMBER);
5359: FND_MESSAGE.Set_Token('PACK_ITEM', l_existing_gtin);
5360: FND_MESSAGE.Set_Token('UOM', i.PRIMARY_UOM_CODE);
5361: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET;
5362: dumm_status := INVPUOPI.mtl_log_interface_err(
5363: i.ORGANIZATION_ID
5364: ,l_user_id
5365: ,l_login_id
5366: ,l_prog_appid

Line 5456: dumm_status := INVPUOPI.mtl_log_interface_err(

5452: IF i.EXISTING_GTIN <> i.GLOBAL_TRADE_ITEM_NUMBER THEN
5453: Debug_Conc_Log('GTIN can not be updated');
5454: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_NOT_UPDATEABLE');
5455: l_msg_text := FND_MESSAGE.GET;
5456: dumm_status := INVPUOPI.mtl_log_interface_err(
5457: i.ORGANIZATION_ID
5458: ,l_user_id
5459: ,l_login_id
5460: ,l_prog_appid

Line 5487: dumm_status := INVPUOPI.mtl_log_interface_err(

5483: Debug_Conc_Log('Done Raising business event with status - '||l_return_status);
5484: Debug_Conc_Log('Done Raising business event with message - '||SUBSTR(l_msg_data, 3950));
5485: IF l_return_status <> 'S' THEN
5486: l_msg_text := SUBSTR('Error in raising business event for GTIN Cross References - '||l_msg_data, 4000);
5487: dumm_status := INVPUOPI.mtl_log_interface_err(
5488: l_org_id
5489: ,l_user_id
5490: ,l_login_id
5491: ,l_prog_appid

Line 5951: dumm_status := INVPUOPI.mtl_log_interface_err(

5947: Debug_Conc_Log('Done Raising business event with status - '||l_return_status);
5948: Debug_Conc_Log('Done Raising business event with message - '||SUBSTR(l_msg_data, 3950));
5949: IF l_return_status <> 'S' THEN
5950: l_msg_text := SUBSTR('Error in raising business event for Source System Item Cross References - '||l_msg_data, 4000);
5951: dumm_status := INVPUOPI.mtl_log_interface_err(
5952: l_org_id
5953: ,l_user_id
5954: ,l_login_id
5955: ,l_prog_appid

Line 6386: l_ret_code := INVPUOPI.MTL_PR_PARSE_ITEM_SEGMENTS ( p_row_id =>item_record.rid

6382: l_ret_code INTEGER;
6383: BEGIN
6384: IF p_is_pdh_batch = FND_API.G_TRUE THEN
6385: FOR item_record IN c_pdh_items_table LOOP
6386: l_ret_code := INVPUOPI.MTL_PR_PARSE_ITEM_SEGMENTS ( p_row_id =>item_record.rid
6387: , item_number =>l_item_number
6388: , item_id =>l_item_id
6389: , ERR_TEXT =>l_err_text
6390: );

Line 6394: l_ret_code := INVPUOPI.MTL_PR_PARSE_ITEM_SEGMENTS ( p_row_id =>item_record.rid

6390: );
6391: END LOOP;
6392: ELSE
6393: FOR item_record IN c_ss_items_table LOOP
6394: l_ret_code := INVPUOPI.MTL_PR_PARSE_ITEM_SEGMENTS ( p_row_id =>item_record.rid
6395: , item_number =>l_item_number
6396: , item_id =>l_item_id
6397: , ERR_TEXT =>l_err_text
6398: );

Line 6442: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER

6438: l_item_id := NULL;
6439:
6440: IF item_record.inventory_item_id IS NULL THEN
6441: IF item_record.item_number IS NOT NULL THEN
6442: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER
6443: ( ITEM_NUMBER =>item_record.item_number
6444: , ITEM_ID =>item_record.inventory_item_id
6445: , TRANS_ID =>item_record.transaction_id
6446: , ORG_ID =>item_record.organization_id

Line 7673: dumm_status := INVPUOPI.mtl_log_interface_err(

7669: FOR i IN c_error_case_cursor LOOP
7670: FND_MESSAGE.SET_NAME('EGO', 'EGO_EF_IDENTICAL_ROWS_ERR');
7671: FND_MESSAGE.SET_TOKEN('AG_NAME', i.ATTR_GROUP_INT_NAME);
7672: l_msg_text := FND_MESSAGE.GET;
7673: dumm_status := INVPUOPI.mtl_log_interface_err(
7674: i.ORGANIZATION_ID
7675: ,l_user_id
7676: ,l_login_id
7677: ,l_prog_appid

Line 7875: dumm_status := INVPUOPI.mtl_log_interface_err(

7871: FOR i IN c_error_case_cursor LOOP
7872: FND_MESSAGE.SET_NAME('EGO', 'EGO_EF_IDENTICAL_ROWS_ERR');
7873: FND_MESSAGE.SET_TOKEN('AG_NAME', i.ATTR_GROUP_INT_NAME);
7874: l_msg_text := FND_MESSAGE.GET;
7875: dumm_status := INVPUOPI.mtl_log_interface_err(
7876: i.ORGANIZATION_ID
7877: ,l_user_id
7878: ,l_login_id
7879: ,l_prog_appid

Line 8223: dumm_status := INVPUOPI.mtl_log_interface_err(

8219: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8220: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8221: l_msg_text := FND_MESSAGE.GET;
8222:
8223: dumm_status := INVPUOPI.mtl_log_interface_err(
8224: i.ORGANIZATION_ID
8225: ,l_user_id
8226: ,l_login_id
8227: ,l_prog_appid

Line 8245: dumm_status := INVPUOPI.mtl_log_interface_err(

8241: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8242: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8243: l_msg_text := FND_MESSAGE.GET;
8244:
8245: dumm_status := INVPUOPI.mtl_log_interface_err(
8246: i.ORGANIZATION_ID
8247: ,l_user_id
8248: ,l_login_id
8249: ,l_prog_appid

Line 8556: dumm_status := INVPUOPI.mtl_log_interface_err(

8552: l_msg_text := FND_MESSAGE.GET;
8553:
8554:
8555:
8556: dumm_status := INVPUOPI.mtl_log_interface_err(
8557: i.ORGANIZATION_ID
8558: ,l_user_id
8559: ,l_login_id
8560: ,l_prog_appid

Line 8577: dumm_status := INVPUOPI.mtl_log_interface_err(

8573: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8574: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8575: l_msg_text := FND_MESSAGE.GET;
8576:
8577: dumm_status := INVPUOPI.mtl_log_interface_err(
8578: i.ORGANIZATION_ID
8579: ,l_user_id
8580: ,l_login_id
8581: ,l_prog_appid

Line 9492: dumm_status := INVPUOPI.mtl_log_interface_err(

9488: WHERE ROWID = p_target_rowid
9489: RETURNING ORGANIZATION_ID, TRANSACTION_ID
9490: INTO l_org_id, l_transaction_id;
9491:
9492: dumm_status := INVPUOPI.mtl_log_interface_err(
9493: l_org_id
9494: ,l_user_id
9495: ,l_login_id
9496: ,l_prog_appid

Line 12249: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER(

12245: l_item_id := NULL;
12246:
12247: IF item_record.inventory_item_id IS NULL THEN
12248: IF item_record.item_number IS NOT NULL THEN
12249: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER(
12250: ITEM_NUMBER =>item_record.item_number
12251: ,ITEM_ID =>item_record.inventory_item_id
12252: ,TRANS_ID =>item_record.transaction_id
12253: ,ORG_ID =>item_record.organization_id