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 FND_MESSAGE

Line 288: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');

284: Debug_Conc_Log( 'Err_null_ssxref_ssid - Started inserting Errors' );
285: -- MSII
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

Line 289: l_msg_text := FND_MESSAGE.GET;

285: -- MSII
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

Line 305: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

301: ,'INV_IOI_ERR_SSXREF_IS_NULL_01' --bug 11894684, replace INV_IOI_ERR
302: ,l_err_text);
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

Line 306: l_msg_text := FND_MESSAGE.GET;

302: ,l_err_text);
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

Line 326: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');

322:
323: -- MIRI
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

Line 327: l_msg_text := FND_MESSAGE.GET;

323: -- MIRI
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

Line 342: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

338: ,'MTL_ITEM_REVISIONS_INTERFACE'
339: ,'INV_IOI_ERR_SSXREF_IS_NULL_02'--bug 11894684, replace INV_IOI_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

Line 343: l_msg_text := FND_MESSAGE.GET;

339: ,'INV_IOI_ERR_SSXREF_IS_NULL_02'--bug 11894684, replace INV_IOI_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

Line 363: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');

359:
360: -- MICI
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

Line 364: l_msg_text := FND_MESSAGE.GET;

360: -- MICI
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

Line 379: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

375: ,'MTL_ITEM_CATEGORIES_INTERFACE'
376: ,'INV_IOI_ERR_SSXREF_IS_NULL_03'--bug 11894684, replace INV_IOI_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

Line 380: l_msg_text := FND_MESSAGE.GET;

376: ,'INV_IOI_ERR_SSXREF_IS_NULL_03'--bug 11894684, replace INV_IOI_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

Line 400: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');

396:
397: -- EIUAI
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

Line 401: l_msg_text := FND_MESSAGE.GET;

397: -- EIUAI
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

Line 416: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

412: ,'EGO_ITM_USR_ATTR_INTRFC'
413: ,'INV_IOI_ERR_SSXREF_IS_NULL_04'--bug 11894684, replace INV_IOI_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

Line 417: l_msg_text := FND_MESSAGE.GET;

413: ,'INV_IOI_ERR_SSXREF_IS_NULL_04'--bug 11894684, replace INV_IOI_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

Line 437: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');

433:
434: -- EIPI
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

Line 438: l_msg_text := FND_MESSAGE.GET;

434: -- EIPI
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

Line 453: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

449: ,'EGO_ITEM_PEOPLE_INTF'
450: ,'INV_IOI_ERR_SSXREF_IS_NULL_05'--bug 11894684, replace INV_IOI_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

Line 454: l_msg_text := FND_MESSAGE.GET;

450: ,'INV_IOI_ERR_SSXREF_IS_NULL_05'--bug 11894684, replace INV_IOI_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

Line 474: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');

470:
471: -- EAI
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

Line 475: l_msg_text := FND_MESSAGE.GET;

471: -- EAI
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

Line 490: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

486: ,'EGO_AML_INTF'
487: ,'INV_IOI_ERR_SSXREF_IS_NULL_06'--bug 11894684, replace INV_IOI_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

Line 491: l_msg_text := FND_MESSAGE.GET;

487: ,'INV_IOI_ERR_SSXREF_IS_NULL_06'--bug 11894684, replace INV_IOI_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

Line 511: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXREF_IS_NULL');

507:
508: -- R12C:BEGIN
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

Line 512: l_msg_text := FND_MESSAGE.GET;

508: -- R12C:BEGIN
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

Line 527: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

523: ,'EGO_ITEM_ASSOCIATIONS_INTF'
524: ,'INV_IOI_ERR_SSXREF_IS_NULL_07'--bug 11894684, replace INV_IOI_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

Line 528: l_msg_text := FND_MESSAGE.GET;

524: ,'INV_IOI_ERR_SSXREF_IS_NULL_07'--bug 11894684, replace INV_IOI_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

Line 2458: FND_MESSAGE.Set_Name('EGO', 'EGO_IMPORT_DUPLICATE_ITEMS');

2454: VALUES l_merged_rows( row_index );
2455:
2456: --Bug 13505630
2457: For i in 1..l_merged_rows.COUNT loop
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(

Line 2459: FND_MESSAGE.Set_Token('ITEM_NUMBER', l_merged_rows(i).ITEM_NUMBER);

2455:
2456: --Bug 13505630
2457: For i in 1..l_merged_rows.COUNT loop
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

Line 2460: FND_MESSAGE.Set_Token('ORG_ID', l_merged_rows(i).ORGANIZATION_ID);

2456: --Bug 13505630
2457: For i in 1..l_merged_rows.COUNT loop
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

Line 2461: l_msg_text := FND_MESSAGE.GET;

2457: For i in 1..l_merged_rows.COUNT loop
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

Line 5152: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

5148: l_priv := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_ITEM_XREFS', 'EGO_ITEM', i.INVENTORY_ITEM_ID, i.ORGANIZATION_ID, NULL, NULL, NULL, l_party_name);
5149:
5150: IF NVL(l_priv, 'F') <> 'T' THEN
5151: Debug_Conc_Log('No Edit Cross Reference Privilege on item');
5152: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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:

Line 5153: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);

5149:
5150: IF NVL(l_priv, 'F') <> 'T' THEN
5151: Debug_Conc_Log('No Edit Cross Reference Privilege on item');
5152: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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(

Line 5154: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);

5150: IF NVL(l_priv, 'F') <> 'T' THEN
5151: Debug_Conc_Log('No Edit Cross Reference Privilege on item');
5152: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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

Line 5155: l_msg_text := FND_MESSAGE.GET;

5151: Debug_Conc_Log('No Edit Cross Reference Privilege on item');
5152: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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

Line 5183: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_NOT_NUMBER');

5179: BEGIN
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

Line 5203: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_LENGTH_NOT_CORRECT');

5199:
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

Line 5223: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_CHECKDIGIT_INVALID');

5219:
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

Line 5243: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_LEADING_ZERO_INVALID');

5239:
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

Line 5264: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_THIRD_DIGIT_INVALID');

5260: -- 5. 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
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

Line 5285: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_7TO9DIGIT_INVALID');

5281: -- 6. If a GTIN in a RCI message has six leading zeros, digits 7-9 must be between 301-968
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

Line 5305: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_0TO4_DIGIT_INVALID');

5301:
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

Line 5326: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET_STRING('EGO', 'EGO_GTIN_2TO3_DIGIT_INVALID');

5322: -- 8. GTINs submitted in RCI messages cannot contain values 02, 04, 05, and 10-29 in the second and third digits from the left
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

Line 5357: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_EXISTS_WITH_PACKITEM');

5353: AND mcr.UOM_CODE = msik.PRIMARY_UOM_CODE
5354: AND ROWNUM = 1;
5355:
5356: Debug_Conc_Log('Validation Failed - duplicate GTIN');
5357: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_EXISTS_WITH_PACKITEM');
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;

Line 5358: FND_MESSAGE.Set_Token('GTIN', i.GLOBAL_TRADE_ITEM_NUMBER);

5354: AND ROWNUM = 1;
5355:
5356: Debug_Conc_Log('Validation Failed - duplicate GTIN');
5357: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_EXISTS_WITH_PACKITEM');
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(

Line 5359: FND_MESSAGE.Set_Token('PACK_ITEM', l_existing_gtin);

5355:
5356: Debug_Conc_Log('Validation Failed - duplicate GTIN');
5357: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_EXISTS_WITH_PACKITEM');
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

Line 5360: FND_MESSAGE.Set_Token('UOM', i.PRIMARY_UOM_CODE);

5356: Debug_Conc_Log('Validation Failed - duplicate GTIN');
5357: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_EXISTS_WITH_PACKITEM');
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

Line 5361: l_msg_text := i.GLOBAL_TRADE_ITEM_NUMBER ||' - '||FND_MESSAGE.GET;

5357: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_EXISTS_WITH_PACKITEM');
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

Line 5454: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_NOT_UPDATEABLE');

5450:
5451: -- BUG 5549140 - Adding validation that existing GTIN can not be changed
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

Line 5455: l_msg_text := FND_MESSAGE.GET;

5451: -- BUG 5549140 - Adding validation that existing GTIN can not be changed
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

Line 7670: FND_MESSAGE.SET_NAME('EGO', 'EGO_EF_IDENTICAL_ROWS_ERR');

7666: CLOSE c_unmerged_rows;
7667:
7668: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Logging errors for Errored out unmerged rows');
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

Line 7671: FND_MESSAGE.SET_TOKEN('AG_NAME', i.ATTR_GROUP_INT_NAME);

7667:
7668: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Logging errors for Errored out unmerged rows');
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

Line 7672: l_msg_text := FND_MESSAGE.GET;

7668: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Logging errors for Errored out unmerged rows');
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

Line 7872: FND_MESSAGE.SET_NAME('EGO', 'EGO_EF_IDENTICAL_ROWS_ERR');

7868: CLOSE c_unmerged_rows;
7869:
7870: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Logging errors for Errored out unmerged rows');
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

Line 7873: FND_MESSAGE.SET_TOKEN('AG_NAME', i.ATTR_GROUP_INT_NAME);

7869:
7870: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Logging errors for Errored out unmerged rows');
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

Line 7874: l_msg_text := FND_MESSAGE.GET;

7870: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Logging errors for Errored out unmerged rows');
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

Line 8218: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

8214:
8215: Debug_Conc_Log( 'Resolve_Child_Entities - After checking security on new item link where old link and new link are not the same' );
8216:
8217: FOR i IN c_no_privilege_rows LOOP
8218: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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:

Line 8219: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);

8215: Debug_Conc_Log( 'Resolve_Child_Entities - After checking security on new item link where old link and new link are not the same' );
8216:
8217: FOR i IN c_no_privilege_rows LOOP
8218: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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(

Line 8220: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);

8216:
8217: FOR i IN c_no_privilege_rows LOOP
8218: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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

Line 8221: l_msg_text := FND_MESSAGE.GET;

8217: FOR i IN c_no_privilege_rows LOOP
8218: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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

Line 8240: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

8236:
8237: END LOOP;
8238:
8239: FOR i IN c_old_xref_no_priv_row LOOP
8240: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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:

Line 8241: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);

8237: END LOOP;
8238:
8239: FOR i IN c_old_xref_no_priv_row LOOP
8240: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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(

Line 8242: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);

8238:
8239: FOR i IN c_old_xref_no_priv_row LOOP
8240: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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

Line 8243: l_msg_text := FND_MESSAGE.GET;

8239: FOR i IN c_old_xref_no_priv_row LOOP
8240: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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

Line 8549: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

8545:
8546: Debug_Conc_Log( 'Resolve_Child_Entities - After updating records without privilege to status 33390' );
8547:
8548: FOR i IN c_no_privilege_rows LOOP
8549: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
8550: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8551: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8552: l_msg_text := FND_MESSAGE.GET;
8553:

Line 8550: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);

8546: Debug_Conc_Log( 'Resolve_Child_Entities - After updating records without privilege to status 33390' );
8547:
8548: FOR i IN c_no_privilege_rows LOOP
8549: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
8550: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8551: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8552: l_msg_text := FND_MESSAGE.GET;
8553:
8554:

Line 8551: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);

8547:
8548: FOR i IN c_no_privilege_rows LOOP
8549: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
8550: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8551: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8552: l_msg_text := FND_MESSAGE.GET;
8553:
8554:
8555:

Line 8552: l_msg_text := FND_MESSAGE.GET;

8548: FOR i IN c_no_privilege_rows LOOP
8549: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
8550: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8551: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8552: l_msg_text := FND_MESSAGE.GET;
8553:
8554:
8555:
8556: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 8572: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

8568: ,l_err_text);
8569: END LOOP;
8570:
8571: FOR i IN c_old_xref_no_priv_row LOOP
8572: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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:

Line 8573: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);

8569: END LOOP;
8570:
8571: FOR i IN c_old_xref_no_priv_row LOOP
8572: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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(

Line 8574: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);

8570:
8571: FOR i IN c_old_xref_no_priv_row LOOP
8572: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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

Line 8575: l_msg_text := FND_MESSAGE.GET;

8571: FOR i IN c_old_xref_no_priv_row LOOP
8572: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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

Line 9919: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

9915: -- old xref and new xref are not same, so check privilege on old item
9916: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_xref_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9917: IF 'T' <> l_priv_exists THEN
9918: -- no privileges, logging error
9919: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9920: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9921: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9922: l_msg_text := FND_MESSAGE.GET;
9923: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

Line 9920: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);

9916: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_xref_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9917: IF 'T' <> l_priv_exists THEN
9918: -- no privileges, logging error
9919: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9920: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9921: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9922: l_msg_text := FND_MESSAGE.GET;
9923: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9924: SET PROCESS_FLAG = 3

Line 9921: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);

9917: IF 'T' <> l_priv_exists THEN
9918: -- no privileges, logging error
9919: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9920: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9921: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9922: l_msg_text := FND_MESSAGE.GET;
9923: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9924: SET PROCESS_FLAG = 3
9925: WHERE ROWID = p_target_rowid;

Line 9922: l_msg_text := FND_MESSAGE.GET;

9918: -- no privileges, logging error
9919: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9920: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9921: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9922: l_msg_text := FND_MESSAGE.GET;
9923: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9924: SET PROCESS_FLAG = 3
9925: WHERE ROWID = p_target_rowid;
9926: x_return_code := G_NEED_TO_LOG_ERROR;

Line 9934: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

9930: -- privilege exists on old item. Check privilege on new item
9931: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9932: IF 'T' <> l_priv_exists THEN
9933: -- no privileges, logging error
9934: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9935: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9936: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9937: l_msg_text := FND_MESSAGE.GET;
9938:

Line 9935: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);

9931: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9932: IF 'T' <> l_priv_exists THEN
9933: -- no privileges, logging error
9934: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9935: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9936: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9937: l_msg_text := FND_MESSAGE.GET;
9938:
9939: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

Line 9936: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);

9932: IF 'T' <> l_priv_exists THEN
9933: -- no privileges, logging error
9934: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9935: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9936: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9937: l_msg_text := FND_MESSAGE.GET;
9938:
9939: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9940: SET PROCESS_FLAG = 3

Line 9937: l_msg_text := FND_MESSAGE.GET;

9933: -- no privileges, logging error
9934: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9935: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9936: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9937: l_msg_text := FND_MESSAGE.GET;
9938:
9939: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9940: SET PROCESS_FLAG = 3
9941: WHERE ROWID = p_target_rowid;

Line 9953: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

9949: -- New and Old link are same, but description is different, so check privilege on item
9950: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9951: IF 'T' <> l_priv_exists THEN
9952: -- no privileges, logging error
9953: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9954: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9955: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9956: l_msg_text := FND_MESSAGE.GET;
9957:

Line 9954: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);

9950: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9951: IF 'T' <> l_priv_exists THEN
9952: -- no privileges, logging error
9953: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9954: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9955: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9956: l_msg_text := FND_MESSAGE.GET;
9957:
9958: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

Line 9955: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);

9951: IF 'T' <> l_priv_exists THEN
9952: -- no privileges, logging error
9953: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9954: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9955: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9956: l_msg_text := FND_MESSAGE.GET;
9957:
9958: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9959: SET PROCESS_FLAG = 3

Line 9956: l_msg_text := FND_MESSAGE.GET;

9952: -- no privileges, logging error
9953: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9954: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9955: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9956: l_msg_text := FND_MESSAGE.GET;
9957:
9958: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9959: SET PROCESS_FLAG = 3
9960: WHERE ROWID = p_target_rowid;

Line 9973: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

9969: -- check privilege only for new item
9970: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9971: IF 'T' <> l_priv_exists THEN
9972: -- no privileges, logging error
9973: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9974: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9975: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9976: l_msg_text := FND_MESSAGE.GET;
9977:

Line 9974: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);

9970: l_priv_exists := EGO_DATA_SECURITY.CHECK_FUNCTION(1.0, 'EGO_EDIT_SS_ITEM_XREFS', 'EGO_ITEM', l_item_id, l_org_id, NULL, NULL, NULL, l_party_name);
9971: IF 'T' <> l_priv_exists THEN
9972: -- no privileges, logging error
9973: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9974: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9975: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9976: l_msg_text := FND_MESSAGE.GET;
9977:
9978: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

Line 9975: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);

9971: IF 'T' <> l_priv_exists THEN
9972: -- no privileges, logging error
9973: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9974: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9975: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9976: l_msg_text := FND_MESSAGE.GET;
9977:
9978: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9979: SET PROCESS_FLAG = 3

Line 9976: l_msg_text := FND_MESSAGE.GET;

9972: -- no privileges, logging error
9973: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9974: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9975: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9976: l_msg_text := FND_MESSAGE.GET;
9977:
9978: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9979: SET PROCESS_FLAG = 3
9980: WHERE ROWID = p_target_rowid;