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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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 5086: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');

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

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

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

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

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

Line 5089: l_msg_text := FND_MESSAGE.GET;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5287: AND mcr.UOM_CODE = msik.PRIMARY_UOM_CODE
5288: AND ROWNUM = 1;
5289:
5290: Debug_Conc_Log('Validation Failed - duplicate GTIN');
5291: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_EXISTS_WITH_PACKITEM');
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;

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

5288: AND ROWNUM = 1;
5289:
5290: Debug_Conc_Log('Validation Failed - duplicate GTIN');
5291: FND_MESSAGE.Set_Name('EGO', 'EGO_GTIN_EXISTS_WITH_PACKITEM');
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(

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

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

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

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

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

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

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

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

Line 5389: l_msg_text := FND_MESSAGE.GET;

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

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

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

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

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

Line 7575: l_msg_text := FND_MESSAGE.GET;

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

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

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

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

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

Line 7773: l_msg_text := FND_MESSAGE.GET;

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

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

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

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

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

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

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

Line 8118: l_msg_text := FND_MESSAGE.GET;

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

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

8133:
8134: END LOOP;
8135:
8136: FOR i IN c_old_xref_no_priv_row LOOP
8137: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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:

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

8134: END LOOP;
8135:
8136: FOR i IN c_old_xref_no_priv_row LOOP
8137: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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(

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

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

Line 8140: l_msg_text := FND_MESSAGE.GET;

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

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

8442:
8443: Debug_Conc_Log( 'Resolve_Child_Entities - After updating records without privilege to status 33390' );
8444:
8445: FOR i IN c_no_privilege_rows LOOP
8446: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
8447: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8448: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8449: l_msg_text := FND_MESSAGE.GET;
8450:

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

8443: Debug_Conc_Log( 'Resolve_Child_Entities - After updating records without privilege to status 33390' );
8444:
8445: FOR i IN c_no_privilege_rows LOOP
8446: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
8447: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8448: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8449: l_msg_text := FND_MESSAGE.GET;
8450:
8451:

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

8444:
8445: FOR i IN c_no_privilege_rows LOOP
8446: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
8447: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8448: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8449: l_msg_text := FND_MESSAGE.GET;
8450:
8451:
8452:

Line 8449: l_msg_text := FND_MESSAGE.GET;

8445: FOR i IN c_no_privilege_rows LOOP
8446: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
8447: FND_MESSAGE.SET_TOKEN('ITEM', i.ITEM_NUMBER);
8448: FND_MESSAGE.SET_TOKEN('ORG', i.ORGANIZATION_CODE);
8449: l_msg_text := FND_MESSAGE.GET;
8450:
8451:
8452:
8453: dumm_status := INVPUOPI.mtl_log_interface_err(

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

8465: ,l_err_text);
8466: END LOOP;
8467:
8468: FOR i IN c_old_xref_no_priv_row LOOP
8469: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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:

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

8466: END LOOP;
8467:
8468: FOR i IN c_old_xref_no_priv_row LOOP
8469: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
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(

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

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

Line 8472: l_msg_text := FND_MESSAGE.GET;

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

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

9812: -- old xref and new xref are not same, so check privilege on old item
9813: 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);
9814: IF 'T' <> l_priv_exists THEN
9815: -- no privileges, logging error
9816: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9817: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9818: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9819: l_msg_text := FND_MESSAGE.GET;
9820: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

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

9813: 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);
9814: IF 'T' <> l_priv_exists THEN
9815: -- no privileges, logging error
9816: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9817: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9818: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9819: l_msg_text := FND_MESSAGE.GET;
9820: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9821: SET PROCESS_FLAG = 3

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

9814: IF 'T' <> l_priv_exists THEN
9815: -- no privileges, logging error
9816: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9817: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9818: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9819: l_msg_text := FND_MESSAGE.GET;
9820: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9821: SET PROCESS_FLAG = 3
9822: WHERE ROWID = p_target_rowid;

Line 9819: l_msg_text := FND_MESSAGE.GET;

9815: -- no privileges, logging error
9816: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9817: FND_MESSAGE.SET_TOKEN('ITEM', l_xref_item_number);
9818: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9819: l_msg_text := FND_MESSAGE.GET;
9820: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9821: SET PROCESS_FLAG = 3
9822: WHERE ROWID = p_target_rowid;
9823: x_return_code := G_NEED_TO_LOG_ERROR;

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

9827: -- privilege exists on old item. Check privilege on new item
9828: 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);
9829: IF 'T' <> l_priv_exists THEN
9830: -- no privileges, logging error
9831: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9832: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9833: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9834: l_msg_text := FND_MESSAGE.GET;
9835:

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

9828: 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);
9829: IF 'T' <> l_priv_exists THEN
9830: -- no privileges, logging error
9831: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9832: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9833: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9834: l_msg_text := FND_MESSAGE.GET;
9835:
9836: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

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

9829: IF 'T' <> l_priv_exists THEN
9830: -- no privileges, logging error
9831: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9832: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9833: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9834: l_msg_text := FND_MESSAGE.GET;
9835:
9836: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9837: SET PROCESS_FLAG = 3

Line 9834: l_msg_text := FND_MESSAGE.GET;

9830: -- no privileges, logging error
9831: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9832: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9833: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9834: l_msg_text := FND_MESSAGE.GET;
9835:
9836: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9837: SET PROCESS_FLAG = 3
9838: WHERE ROWID = p_target_rowid;

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

9846: -- New and Old link are same, but description is different, so check privilege on item
9847: 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);
9848: IF 'T' <> l_priv_exists THEN
9849: -- no privileges, logging error
9850: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9851: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9852: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9853: l_msg_text := FND_MESSAGE.GET;
9854:

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

9847: 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);
9848: IF 'T' <> l_priv_exists THEN
9849: -- no privileges, logging error
9850: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9851: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9852: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9853: l_msg_text := FND_MESSAGE.GET;
9854:
9855: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

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

9848: IF 'T' <> l_priv_exists THEN
9849: -- no privileges, logging error
9850: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9851: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9852: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9853: l_msg_text := FND_MESSAGE.GET;
9854:
9855: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9856: SET PROCESS_FLAG = 3

Line 9853: l_msg_text := FND_MESSAGE.GET;

9849: -- no privileges, logging error
9850: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9851: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9852: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9853: l_msg_text := FND_MESSAGE.GET;
9854:
9855: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9856: SET PROCESS_FLAG = 3
9857: WHERE ROWID = p_target_rowid;

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

9866: -- check privilege only for new item
9867: 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);
9868: IF 'T' <> l_priv_exists THEN
9869: -- no privileges, logging error
9870: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9871: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9872: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9873: l_msg_text := FND_MESSAGE.GET;
9874:

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

9867: 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);
9868: IF 'T' <> l_priv_exists THEN
9869: -- no privileges, logging error
9870: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9871: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9872: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9873: l_msg_text := FND_MESSAGE.GET;
9874:
9875: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

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

9868: IF 'T' <> l_priv_exists THEN
9869: -- no privileges, logging error
9870: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9871: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9872: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9873: l_msg_text := FND_MESSAGE.GET;
9874:
9875: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9876: SET PROCESS_FLAG = 3

Line 9873: l_msg_text := FND_MESSAGE.GET;

9869: -- no privileges, logging error
9870: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_EDIT_XREF_PRIV');
9871: FND_MESSAGE.SET_TOKEN('ITEM', l_item_number);
9872: FND_MESSAGE.SET_TOKEN('ORG', l_org_code);
9873: l_msg_text := FND_MESSAGE.GET;
9874:
9875: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
9876: SET PROCESS_FLAG = 3
9877: WHERE ROWID = p_target_rowid;