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 5091: dumm_status := INVPUOPI.mtl_log_interface_err(

5087: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
5088: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
5089: l_msg_text := FND_MESSAGE.GET;
5090:
5091: dumm_status := INVPUOPI.mtl_log_interface_err(
5092: i.ORGANIZATION_ID
5093: ,l_user_id
5094: ,l_login_id
5095: ,l_prog_appid

Line 5118: dumm_status := INVPUOPI.mtl_log_interface_err(

5114: l_gtin := TO_NUMBER(i.GLOBAL_TRADE_ITEM_NUMBER);
5115: EXCEPTION WHEN VALUE_ERROR THEN
5116: Debug_Conc_Log('Validation Failed - GTIN is not a Number');
5117: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_NOT_NUMBER');
5118: dumm_status := INVPUOPI.mtl_log_interface_err(
5119: i.ORGANIZATION_ID
5120: ,l_user_id
5121: ,l_login_id
5122: ,l_prog_appid

Line 5138: dumm_status := INVPUOPI.mtl_log_interface_err(

5134: --2. validating the length of GTIN to be 14
5135: IF LENGTH(i.GLOBAL_TRADE_ITEM_NUMBER) <> 14 THEN
5136: Debug_Conc_Log('Validation Failed - Length is not 14 chars');
5137: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_LENGTH_NOT_CORRECT');
5138: dumm_status := INVPUOPI.mtl_log_interface_err(
5139: i.ORGANIZATION_ID
5140: ,l_user_id
5141: ,l_login_id
5142: ,l_prog_appid

Line 5158: dumm_status := INVPUOPI.mtl_log_interface_err(

5154: --3. validating the check digit of GTIN to be valid
5155: IF (NOT l_error) AND EGO_GTIN_ATTRS_PVT.Is_Check_Digit_Invalid(i.GLOBAL_TRADE_ITEM_NUMBER) THEN
5156: Debug_Conc_Log('Validation Failed - Check digit is not valid');
5157: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_CHECKDIGIT_INVALID');
5158: dumm_status := INVPUOPI.mtl_log_interface_err(
5159: i.ORGANIZATION_ID
5160: ,l_user_id
5161: ,l_login_id
5162: ,l_prog_appid

Line 5178: dumm_status := INVPUOPI.mtl_log_interface_err(

5174: --4. gtin can not contain more than six leading zeros
5175: IF SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 1, 7) = '0000000' THEN
5176: Debug_Conc_Log('Validation Failed - gtin can not contain more than six leading zeros');
5177: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_LEADING_ZERO_INVALID');
5178: dumm_status := INVPUOPI.mtl_log_interface_err(
5179: i.ORGANIZATION_ID
5180: ,l_user_id
5181: ,l_login_id
5182: ,l_prog_appid

Line 5199: dumm_status := INVPUOPI.mtl_log_interface_err(

5195: IF SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 2, 1) = '0' AND
5196: SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 3, 1) NOT IN ('0', '1', '3', '6', '7', '8', '9') THEN
5197: 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 ');
5198: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_THIRD_DIGIT_INVALID');
5199: dumm_status := INVPUOPI.mtl_log_interface_err(
5200: i.ORGANIZATION_ID
5201: ,l_user_id
5202: ,l_login_id
5203: ,l_prog_appid

Line 5220: dumm_status := INVPUOPI.mtl_log_interface_err(

5216: IF (NOT l_error) AND SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 1, 6) = '000000' AND
5217: TO_NUMBER(SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 7, 3)) NOT BETWEEN 301 AND 968 THEN
5218: Debug_Conc_Log('Validation Failed - If a GTIN in a RCI message has six leading zeros, digits 7-9 must be between 301-968');
5219: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_7TO9DIGIT_INVALID');
5220: dumm_status := INVPUOPI.mtl_log_interface_err(
5221: i.ORGANIZATION_ID
5222: ,l_user_id
5223: ,l_login_id
5224: ,l_prog_appid

Line 5240: dumm_status := INVPUOPI.mtl_log_interface_err(

5236: -- 7. GTINs submitted in RCI messages cannot contain values 0980-0989 or 099 in the first 4 digits
5237: IF SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 1, 3) IN ('098', '099') THEN
5238: Debug_Conc_Log('Validation Failed - GTINs submitted in RCI messages cannot contain values 0980-0989 or 099 in the first 4 digits');
5239: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_0TO4_DIGIT_INVALID');
5240: dumm_status := INVPUOPI.mtl_log_interface_err(
5241: i.ORGANIZATION_ID
5242: ,l_user_id
5243: ,l_login_id
5244: ,l_prog_appid

Line 5261: dumm_status := INVPUOPI.mtl_log_interface_err(

5257: IF (NOT l_error) AND (SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 2, 2) IN ('02', '04', '05') OR
5258: TO_NUMBER(SUBSTR(i.GLOBAL_TRADE_ITEM_NUMBER, 2, 2)) BETWEEN 10 AND 29) THEN
5259: 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');
5260: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_2TO3_DIGIT_INVALID');
5261: dumm_status := INVPUOPI.mtl_log_interface_err(
5262: i.ORGANIZATION_ID
5263: ,l_user_id
5264: ,l_login_id
5265: ,l_prog_appid

Line 5296: dumm_status := INVPUOPI.mtl_log_interface_err(

5292: FND_MESSAGE.Set_Token('GTIN', i.GLOBAL_TRADE_ITEM_NUMBER);
5293: FND_MESSAGE.Set_Token('PACK_ITEM', l_existing_gtin);
5294: FND_MESSAGE.Set_Token('UOM', i.PRIMARY_UOM_CODE);
5295: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET;
5296: dumm_status := INVPUOPI.mtl_log_interface_err(
5297: i.ORGANIZATION_ID
5298: ,l_user_id
5299: ,l_login_id
5300: ,l_prog_appid

Line 5390: dumm_status := INVPUOPI.mtl_log_interface_err(

5386: IF i.EXISTING_GTIN <> i.GLOBAL_TRADE_ITEM_NUMBER THEN
5387: Debug_Conc_Log('GTIN can not be updated');
5388: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_NOT_UPDATEABLE');
5389: l_msg_text := FND_MESSAGE.GET;
5390: dumm_status := INVPUOPI.mtl_log_interface_err(
5391: i.ORGANIZATION_ID
5392: ,l_user_id
5393: ,l_login_id
5394: ,l_prog_appid

Line 5421: dumm_status := INVPUOPI.mtl_log_interface_err(

5417: Debug_Conc_Log('Done Raising business event with status - '||l_return_status);
5418: Debug_Conc_Log('Done Raising business event with message - '||SUBSTR(l_msg_data, 3950));
5419: IF l_return_status <> 'S' THEN
5420: l_msg_text := SUBSTR('Error in raising business event for GTIN Cross References - '||l_msg_data, 4000);
5421: dumm_status := INVPUOPI.mtl_log_interface_err(
5422: l_org_id
5423: ,l_user_id
5424: ,l_login_id
5425: ,l_prog_appid

Line 5885: dumm_status := INVPUOPI.mtl_log_interface_err(

5881: Debug_Conc_Log('Done Raising business event with status - '||l_return_status);
5882: Debug_Conc_Log('Done Raising business event with message - '||SUBSTR(l_msg_data, 3950));
5883: IF l_return_status <> 'S' THEN
5884: l_msg_text := SUBSTR('Error in raising business event for Source System Item Cross References - '||l_msg_data, 4000);
5885: dumm_status := INVPUOPI.mtl_log_interface_err(
5886: l_org_id
5887: ,l_user_id
5888: ,l_login_id
5889: ,l_prog_appid

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

6300: l_ret_code INTEGER;
6301: BEGIN
6302: IF p_is_pdh_batch = FND_API.G_TRUE THEN
6303: FOR item_record IN c_pdh_items_table LOOP
6304: l_ret_code := INVPUOPI.MTL_PR_PARSE_ITEM_SEGMENTS ( p_row_id =>item_record.rid
6305: , item_number =>l_item_number
6306: , item_id =>l_item_id
6307: , ERR_TEXT =>l_err_text
6308: );

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

6308: );
6309: END LOOP;
6310: ELSE
6311: FOR item_record IN c_ss_items_table LOOP
6312: l_ret_code := INVPUOPI.MTL_PR_PARSE_ITEM_SEGMENTS ( p_row_id =>item_record.rid
6313: , item_number =>l_item_number
6314: , item_id =>l_item_id
6315: , ERR_TEXT =>l_err_text
6316: );

Line 6360: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER

6356: l_item_id := NULL;
6357:
6358: IF item_record.inventory_item_id IS NULL THEN
6359: IF item_record.item_number IS NOT NULL THEN
6360: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER
6361: ( ITEM_NUMBER =>item_record.item_number
6362: , ITEM_ID =>item_record.inventory_item_id
6363: , TRANS_ID =>item_record.transaction_id
6364: , ORG_ID =>item_record.organization_id

Line 7576: dumm_status := INVPUOPI.mtl_log_interface_err(

7572: FOR i IN c_error_case_cursor LOOP
7573: FND_MESSAGE.SET_NAME('EGO', 'EGO_EF_IDENTICAL_ROWS_ERR');
7574: FND_MESSAGE.SET_TOKEN('AG_NAME', i.ATTR_GROUP_INT_NAME);
7575: l_msg_text := FND_MESSAGE.GET;
7576: dumm_status := INVPUOPI.mtl_log_interface_err(
7577: i.ORGANIZATION_ID
7578: ,l_user_id
7579: ,l_login_id
7580: ,l_prog_appid

Line 7774: dumm_status := INVPUOPI.mtl_log_interface_err(

7770: FOR i IN c_error_case_cursor LOOP
7771: FND_MESSAGE.SET_NAME('EGO', 'EGO_EF_IDENTICAL_ROWS_ERR');
7772: FND_MESSAGE.SET_TOKEN('AG_NAME', i.ATTR_GROUP_INT_NAME);
7773: l_msg_text := FND_MESSAGE.GET;
7774: dumm_status := INVPUOPI.mtl_log_interface_err(
7775: i.ORGANIZATION_ID
7776: ,l_user_id
7777: ,l_login_id
7778: ,l_prog_appid

Line 8120: dumm_status := INVPUOPI.mtl_log_interface_err(

8116: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8117: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8118: l_msg_text := FND_MESSAGE.GET;
8119:
8120: dumm_status := INVPUOPI.mtl_log_interface_err(
8121: i.ORGANIZATION_ID
8122: ,l_user_id
8123: ,l_login_id
8124: ,l_prog_appid

Line 8142: dumm_status := INVPUOPI.mtl_log_interface_err(

8138: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8139: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8140: l_msg_text := FND_MESSAGE.GET;
8141:
8142: dumm_status := INVPUOPI.mtl_log_interface_err(
8143: i.ORGANIZATION_ID
8144: ,l_user_id
8145: ,l_login_id
8146: ,l_prog_appid

Line 8453: dumm_status := INVPUOPI.mtl_log_interface_err(

8449: l_msg_text := FND_MESSAGE.GET;
8450:
8451:
8452:
8453: dumm_status := INVPUOPI.mtl_log_interface_err(
8454: i.ORGANIZATION_ID
8455: ,l_user_id
8456: ,l_login_id
8457: ,l_prog_appid

Line 8474: dumm_status := INVPUOPI.mtl_log_interface_err(

8470: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8471: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8472: l_msg_text := FND_MESSAGE.GET;
8473:
8474: dumm_status := INVPUOPI.mtl_log_interface_err(
8475: i.ORGANIZATION_ID
8476: ,l_user_id
8477: ,l_login_id
8478: ,l_prog_appid

Line 9389: dumm_status := INVPUOPI.mtl_log_interface_err(

9385: WHERE ROWID = p_target_rowid
9386: RETURNING ORGANIZATION_ID, TRANSACTION_ID
9387: INTO l_org_id, l_transaction_id;
9388:
9389: dumm_status := INVPUOPI.mtl_log_interface_err(
9390: l_org_id
9391: ,l_user_id
9392: ,l_login_id
9393: ,l_prog_appid

Line 12129: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER(

12125: l_item_id := NULL;
12126:
12127: IF item_record.inventory_item_id IS NULL THEN
12128: IF item_record.item_number IS NOT NULL THEN
12129: l_status := INVPUOPI.MTL_PR_PARSE_ITEM_NUMBER(
12130: ITEM_NUMBER =>item_record.item_number
12131: ,ITEM_ID =>item_record.inventory_item_id
12132: ,TRANS_ID =>item_record.transaction_id
12133: ,ORG_ID =>item_record.organization_id