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_PUB_WS_UTIL dependencies on FND_MESSAGE

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

1841: -- for all entities of the batch provide common message conveying
1842: -- to run concurrent import program manually
1843:
1844: IF (l_trigger_import = 'N' OR l_trigger_import = 'FALSE') THEN
1845: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_AUTO_IMPORT_ON_TARGET');
1846: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
1847:
1848: FOR ent IN c_pub_ws_entities(p_session_id)
1849: LOOP

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

1842: -- to run concurrent import program manually
1843:
1844: IF (l_trigger_import = 'N' OR l_trigger_import = 'FALSE') THEN
1845: FND_MESSAGE.SET_NAME('EGO', 'EGO_NO_AUTO_IMPORT_ON_TARGET');
1846: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
1847:
1848: FOR ent IN c_pub_ws_entities(p_session_id)
1849: LOOP
1850:

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

1948:
1949: -- if the system is invalid
1950: -- insert records for invalid system with error message
1951: IF (l_invld_sys_cnt > 0) THEN
1952: FND_MESSAGE.SET_NAME('EGO', 'EGO_SYS_CODE_NO_CONTEXT');
1953: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
1954: FOR ent IN c_pub_ws_entities(p_session_id)
1955: LOOP
1956:

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

1949: -- if the system is invalid
1950: -- insert records for invalid system with error message
1951: IF (l_invld_sys_cnt > 0) THEN
1952: FND_MESSAGE.SET_NAME('EGO', 'EGO_SYS_CODE_NO_CONTEXT');
1953: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
1954: FOR ent IN c_pub_ws_entities(p_session_id)
1955: LOOP
1956:
1957: --DBMS_OUTPUT.PUT_LINE('ent.pk1_value: ' || to_char(ent.pk1_value));

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

2058:
2059: IF (instr(err.ERR_CODE, '_ERROR') <> 0) THEN
2060: IF ((l_error_rec_count > 1) AND (err.ERR_CODE <> 'EGO_SYNC_MIB_STAT_1_ERROR')) THEN
2061:
2062: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2063: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2064: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2065: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2066:

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

2059: IF (instr(err.ERR_CODE, '_ERROR') <> 0) THEN
2060: IF ((l_error_rec_count > 1) AND (err.ERR_CODE <> 'EGO_SYNC_MIB_STAT_1_ERROR')) THEN
2061:
2062: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2063: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2064: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2065: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2066:
2067: UPDATE EGO_PUBLICATION_BATCH_GT

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

2060: IF ((l_error_rec_count > 1) AND (err.ERR_CODE <> 'EGO_SYNC_MIB_STAT_1_ERROR')) THEN
2061:
2062: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2063: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2064: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2065: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2066:
2067: UPDATE EGO_PUBLICATION_BATCH_GT
2068: SET STATUS = 'F', MESSAGE = l_message

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

2061:
2062: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2063: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2064: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2065: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2066:
2067: UPDATE EGO_PUBLICATION_BATCH_GT
2068: SET STATUS = 'F', MESSAGE = l_message
2069: WHERE BATCH_ID = l_batch_id

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

2083: AND SYSTEM_CODE = l_system_code;
2084: END IF;
2085: IF (l_error_rec_count = 1) THEN
2086:
2087: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2088: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2089: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2090: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2091:

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

2084: END IF;
2085: IF (l_error_rec_count = 1) THEN
2086:
2087: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2088: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2089: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2090: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2091:
2092: --DBMS_OUTPUT.PUT_LINE('l_batch_id: ' || to_char(l_batch_id));

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

2085: IF (l_error_rec_count = 1) THEN
2086:
2087: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2088: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2089: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2090: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2091:
2092: --DBMS_OUTPUT.PUT_LINE('l_batch_id: ' || to_char(l_batch_id));
2093: --DBMS_OUTPUT.PUT_LINE('ip.PK1_VALUE: ' || to_char(ip.PK1_VALUE));

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

2086:
2087: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2088: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2089: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2090: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2091:
2092: --DBMS_OUTPUT.PUT_LINE('l_batch_id: ' || to_char(l_batch_id));
2093: --DBMS_OUTPUT.PUT_LINE('ip.PK1_VALUE: ' || to_char(ip.PK1_VALUE));
2094: --DBMS_OUTPUT.PUT_LINE('ip.SYSTEM_CODE: ' || to_char(ip.SYSTEM_CODE));

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

2115: END IF;
2116:
2117: IF (instr(err.ERR_CODE, '_WARNING') <> 0) THEN
2118:
2119: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2120: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2121: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2122: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2123:

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

2116:
2117: IF (instr(err.ERR_CODE, '_WARNING') <> 0) THEN
2118:
2119: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2120: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2121: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2122: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2123:
2124: UPDATE EGO_PUBLICATION_BATCH_GT

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

2117: IF (instr(err.ERR_CODE, '_WARNING') <> 0) THEN
2118:
2119: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2120: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2121: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2122: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2123:
2124: UPDATE EGO_PUBLICATION_BATCH_GT
2125: SET STATUS = 'W', MESSAGE = l_message

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

2118:
2119: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2120: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2121: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2122: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2123:
2124: UPDATE EGO_PUBLICATION_BATCH_GT
2125: SET STATUS = 'W', MESSAGE = l_message
2126: WHERE BATCH_ID = l_batch_id

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

2307: LOOP
2308:
2309: IF (instr(err.ERR_CODE, '_ERROR') <> 0) THEN
2310:
2311: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2312: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2313: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2314: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2315:

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

2308:
2309: IF (instr(err.ERR_CODE, '_ERROR') <> 0) THEN
2310:
2311: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2312: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2313: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2314: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2315:
2316: --DBMS_OUTPUT.PUT_LINE('l_batch_id: ' || to_char(l_batch_id));

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

2309: IF (instr(err.ERR_CODE, '_ERROR') <> 0) THEN
2310:
2311: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2312: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2313: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2314: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2315:
2316: --DBMS_OUTPUT.PUT_LINE('l_batch_id: ' || to_char(l_batch_id));
2317: --DBMS_OUTPUT.PUT_LINE('ip.PK1_VALUE: ' || to_char(ip.PK1_VALUE));

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

2310:
2311: FND_MESSAGE.SET_NAME('EGO', err.ERR_CODE);
2312: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2313: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2314: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2315:
2316: --DBMS_OUTPUT.PUT_LINE('l_batch_id: ' || to_char(l_batch_id));
2317: --DBMS_OUTPUT.PUT_LINE('ip.PK1_VALUE: ' || to_char(ip.PK1_VALUE));
2318: --DBMS_OUTPUT.PUT_LINE('ip.SYSTEM_CODE: ' || to_char(ip.SYSTEM_CODE));

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

2329: END IF;
2330:
2331: IF (instr(err.ERR_CODE, '_WARNING') <> 0) THEN
2332:
2333: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2334: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2335: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2336: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2337:

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

2330:
2331: IF (instr(err.ERR_CODE, '_WARNING') <> 0) THEN
2332:
2333: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2334: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2335: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2336: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2337:
2338: -- Update Err_Message in EGO_PUB_WS_ERROR table

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

2331: IF (instr(err.ERR_CODE, '_WARNING') <> 0) THEN
2332:
2333: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2334: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2335: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2336: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2337:
2338: -- Update Err_Message in EGO_PUB_WS_ERROR table
2339:

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

2332:
2333: FND_MESSAGE.SET_NAME ('EGO', err.ERR_CODE);
2334: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2335: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2336: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2337:
2338: -- Update Err_Message in EGO_PUB_WS_ERROR table
2339:
2340: UPDATE EGO_PUB_WS_ERRORS