DBA Data[Home] [Help]

APPS.EGO_PUB_WS_ICC dependencies on FND_MESSAGE

Line 2212: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_AUTO_IMPORT_ON_TARGET');

2208: -- to run concurrent import program manually
2209:
2210: IF (l_trigger_import = 'N' OR l_trigger_import = 'FALSE') THEN
2211: --debug(L_PROC_NAME||' when l_trigger_import is N/FALSE : '||l_trigger_import);
2212: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_AUTO_IMPORT_ON_TARGET');
2213: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2214:
2215: FOR ent IN c_pub_ws_entities(p_session_id)
2216: LOOP

Line 2213: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);

2209:
2210: IF (l_trigger_import = 'N' OR l_trigger_import = 'FALSE') THEN
2211: --debug(L_PROC_NAME||' when l_trigger_import is N/FALSE : '||l_trigger_import);
2212: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_AUTO_IMPORT_ON_TARGET');
2213: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2214:
2215: FOR ent IN c_pub_ws_entities(p_session_id)
2216: LOOP
2217: --debug(L_PROC_NAME||' entered first For Loop on c_pub_ws_entities, ');

Line 2326: FND_MESSAGE.SET_NAME('EGO', 'EGO_SYS_CODE_NO_CONTEXT');

2322: -- insert records for invalid system with error message
2323: IF (l_invld_sys_cnt > 0) THEN
2324: --debug(L_PROC_NAME||' if l_invld_sys_cnt > 0 '||l_invld_sys_cnt);
2325:
2326: FND_MESSAGE.SET_NAME('EGO', 'EGO_SYS_CODE_NO_CONTEXT');
2327: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2328: FOR ent IN c_pub_ws_entities(p_session_id)
2329: LOOP
2330: --debug(L_PROC_NAME||' entered third For Loop on c_pub_ws_entities ');

Line 2327: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);

2323: IF (l_invld_sys_cnt > 0) THEN
2324: --debug(L_PROC_NAME||' if l_invld_sys_cnt > 0 '||l_invld_sys_cnt);
2325:
2326: FND_MESSAGE.SET_NAME('EGO', 'EGO_SYS_CODE_NO_CONTEXT');
2327: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2328: FOR ent IN c_pub_ws_entities(p_session_id)
2329: LOOP
2330: --debug(L_PROC_NAME||' entered third For Loop on c_pub_ws_entities ');
2331: --debug('ent.pk1_value: ' || to_char(ent.pk1_value));

Line 2450: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);

2446: --debug(L_PROC_NAME||' entered ERROR scenario');
2447: IF ((l_error_rec_count > 1) AND (err.ERR_CODE <> 'EGO_SYNC_MIB_STAT_1_ERROR')) THEN
2448:
2449: --debug(L_PROC_NAME||' entered if on l_error_rec_count > 1 AND err.ERR_CODE <> EGO_SYNC_MIB_STAT_1_ERROR');
2450: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2451: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2452: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2453: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2454:

Line 2451: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);

2447: IF ((l_error_rec_count > 1) AND (err.ERR_CODE <> 'EGO_SYNC_MIB_STAT_1_ERROR')) THEN
2448:
2449: --debug(L_PROC_NAME||' entered if on l_error_rec_count > 1 AND err.ERR_CODE <> EGO_SYNC_MIB_STAT_1_ERROR');
2450: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2451: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2452: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2453: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2454:
2455: /* ip.PK2_VALUE is NULL implies that the ip record is for the additional ICC alone record.

Line 2452: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);

2448:
2449: --debug(L_PROC_NAME||' entered if on l_error_rec_count > 1 AND err.ERR_CODE <> EGO_SYNC_MIB_STAT_1_ERROR');
2450: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2451: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2452: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2453: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2454:
2455: /* ip.PK2_VALUE is NULL implies that the ip record is for the additional ICC alone record.
2456: Note that in create_entities_icc procedure, for every ICC Ver record, we inserted an

Line 2453: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);

2449: --debug(L_PROC_NAME||' entered if on l_error_rec_count > 1 AND err.ERR_CODE <> EGO_SYNC_MIB_STAT_1_ERROR');
2450: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2451: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2452: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2453: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2454:
2455: /* ip.PK2_VALUE is NULL implies that the ip record is for the additional ICC alone record.
2456: Note that in create_entities_icc procedure, for every ICC Ver record, we inserted an
2457: additional ICC alone record for syncing up the non-versioned info like Pages, AGs etc.

Line 2508: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);

2504: EGO_SYNC_MIB_STAT_1_ERROR or EGO_SYNC_MIB_STAT_ERROR */
2505: IF (l_error_rec_count = 1) THEN
2506: --debug(L_PROC_NAME||' entered if l_error_rec_count=1');
2507:
2508: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2509: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2510: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2511: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2512:

Line 2509: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);

2505: IF (l_error_rec_count = 1) THEN
2506: --debug(L_PROC_NAME||' entered if l_error_rec_count=1');
2507:
2508: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2509: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2510: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2511: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2512:
2513: --debug(L_PROC_NAME||'l_batch_id: ' || to_char(l_batch_id));

Line 2510: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);

2506: --debug(L_PROC_NAME||' entered if l_error_rec_count=1');
2507:
2508: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2509: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2510: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2511: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2512:
2513: --debug(L_PROC_NAME||'l_batch_id: ' || to_char(l_batch_id));
2514: --debug(L_PROC_NAME||'ip.PK1_VALUE: ' || to_char(ip.PK1_VALUE));

Line 2511: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);

2507:
2508: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2509: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2510: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2511: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2512:
2513: --debug(L_PROC_NAME||'l_batch_id: ' || to_char(l_batch_id));
2514: --debug(L_PROC_NAME||'ip.PK1_VALUE: ' || to_char(ip.PK1_VALUE));
2515: --debug(L_PROC_NAME||'ip.SYSTEM_CODE: ' || to_char(ip.SYSTEM_CODE));

Line 2557: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);

2553:
2554: IF (instr(err.ERR_CODE, '_WARNING') <> 0) THEN
2555: --debug(L_PROC_NAME||' entered WARNING scenario');
2556:
2557: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2558: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2559: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2560: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2561:

Line 2558: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);

2554: IF (instr(err.ERR_CODE, '_WARNING') <> 0) THEN
2555: --debug(L_PROC_NAME||' entered WARNING scenario');
2556:
2557: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2558: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2559: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2560: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2561:
2562: --debug(L_PROC_NAME||' ip.PARAM_NAME: '||ip.PARAM_NAME||' ip.PK2_VALUE: '||To_Char(ip.PK2_VALUE));

Line 2559: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);

2555: --debug(L_PROC_NAME||' entered WARNING scenario');
2556:
2557: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2558: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2559: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2560: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2561:
2562: --debug(L_PROC_NAME||' ip.PARAM_NAME: '||ip.PARAM_NAME||' ip.PK2_VALUE: '||To_Char(ip.PK2_VALUE));
2563: IF ( (ip.PARAM_NAME=G_ENTITY_TYPE_ICC) AND (ip.PK2_VALUE IS NULL) ) THEN

Line 2560: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);

2556:
2557: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2558: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2559: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2560: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2561:
2562: --debug(L_PROC_NAME||' ip.PARAM_NAME: '||ip.PARAM_NAME||' ip.PK2_VALUE: '||To_Char(ip.PK2_VALUE));
2563: IF ( (ip.PARAM_NAME=G_ENTITY_TYPE_ICC) AND (ip.PK2_VALUE IS NULL) ) THEN
2564: --debug(L_PROC_NAME||' entered if on param_name=ICC AND PK2_VALUE IS NULL - third time');