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_ICC dependencies on EGO_PUB_WS_ERRORS

Line 2129: -- Get ERROR_CODE, ERROR_MESSAGE from EGO_PUB_WS_ERRORS

2125: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2126: WHERE SESSION_ID = l_session_id
2127: AND SYSTEM_CODE = l_system_code;
2128:
2129: -- Get ERROR_CODE, ERROR_MESSAGE from EGO_PUB_WS_ERRORS
2130: CURSOR c_pub_ws_error(l_session_id NUMBER, l_input_id NUMBER, l_system_code VARCHAR2)
2131: IS
2132: SELECT SESSION_ID,
2133: INPUT_ID,

Line 2137: FROM EGO_PUB_WS_ERRORS

2133: INPUT_ID,
2134: SYSTEM_CODE,
2135: ERR_CODE,
2136: ERR_MESSAGE
2137: FROM EGO_PUB_WS_ERRORS
2138: WHERE SESSION_ID = l_session_id
2139: AND INPUT_ID = l_input_id
2140: AND SYSTEM_CODE = l_system_code;
2141:

Line 2182: -- invalid system stored in EGO_PUB_WS_ERRORS for the p_session_id

2178: l_system_code := sys.CHAR_VALUE;
2179: l_invld_sys_cnt := 0;
2180: --debug(L_PROC_NAME||' l_system_code: '||sys.CHAR_VALUE);
2181:
2182: -- invalid system stored in EGO_PUB_WS_ERRORS for the p_session_id
2183: -- get count for the l_system_code
2184: -- if it is equal to zero then only for that system code
2185: -- send the status back to batch fwk table EGO_PUB_BAT_STATUS_B
2186:

Line 2190: FROM EGO_PUB_WS_ERRORS

2186:
2187: BEGIN
2188: SELECT count(1)
2189: INTO l_invld_sys_cnt
2190: FROM EGO_PUB_WS_ERRORS
2191: WHERE SESSION_ID = p_session_id
2192: AND ERR_CODE = 'D'
2193: AND SYSTEM_CODE = l_system_code;
2194: EXCEPTION

Line 2379: -- For each record in EGO_PUB_WS_ERRORS , join with EGO_PUB_WS_INPUT_IDENTIFIERS

2375: --debug(L_PROC_NAME||' end of if on invalid sys - 2 ');
2376: END LOOP; /* end of loop on systems*/
2377: --debug(L_PROC_NAME||' end of Loop on c_system_codes ');
2378:
2379: -- For each record in EGO_PUB_WS_ERRORS , join with EGO_PUB_WS_INPUT_IDENTIFIERS
2380: -- using INPUT_ID, SESSION_ID, and SYSTEM_CODE
2381: -- to retrieve PKs from EGO_PUB_WS_INPUT_IDENTIFIERS, and ERR_CODE and ERR_MESSAGE from EGO_PUB_WS_ERRORS
2382: -- and update records in global temporary table accordingly using PKs.
2383:

Line 2381: -- to retrieve PKs from EGO_PUB_WS_INPUT_IDENTIFIERS, and ERR_CODE and ERR_MESSAGE from EGO_PUB_WS_ERRORS

2377: --debug(L_PROC_NAME||' end of Loop on c_system_codes ');
2378:
2379: -- For each record in EGO_PUB_WS_ERRORS , join with EGO_PUB_WS_INPUT_IDENTIFIERS
2380: -- using INPUT_ID, SESSION_ID, and SYSTEM_CODE
2381: -- to retrieve PKs from EGO_PUB_WS_INPUT_IDENTIFIERS, and ERR_CODE and ERR_MESSAGE from EGO_PUB_WS_ERRORS
2382: -- and update records in global temporary table accordingly using PKs.
2383:
2384: IF (l_trigger_import = 'Y' OR l_trigger_import = 'TRUE') THEN
2385: --debug(L_PROC_NAME||' entered second l_trigger_import = Y/TRUE ');

Line 2393: -- invalid system stored in EGO_PUB_WS_ERRORS for the p_session_id

2389: --debug(L_PROC_NAME||' entered second For Loop on c_system_codes, l_system_code: '||sys.CHAR_VALUE);
2390: l_system_code := sys.CHAR_VALUE;
2391: l_invld_sys_cnt := 0;
2392:
2393: -- invalid system stored in EGO_PUB_WS_ERRORS for the p_session_id
2394: -- get count for the l_system_code
2395: -- if it is equal to zero then only for that system code
2396: -- send the status back to batch fwk table EGO_PUB_BAT_STATUS_B
2397:

Line 2401: FROM EGO_PUB_WS_ERRORS

2397:
2398: BEGIN
2399: SELECT count(1)
2400: INTO l_invld_sys_cnt
2401: FROM EGO_PUB_WS_ERRORS
2402: WHERE SESSION_ID = p_session_id
2403: AND ERR_CODE = 'D'
2404: AND SYSTEM_CODE = l_system_code;
2405: EXCEPTION

Line 2428: FROM EGO_PUB_WS_ERRORS

2424:
2425: BEGIN
2426: SELECT count(1)
2427: INTO l_error_rec_count
2428: FROM EGO_PUB_WS_ERRORS
2429: WHERE session_id = p_session_id
2430: AND system_code = l_system_code
2431: AND input_id = l_input_id;
2432: EXCEPTION

Line 2442: /*Note that for every entity, ego_pub_ws_errors will either have an Error or a Warning

2438:
2439: FOR err IN c_pub_ws_error(p_session_id, l_input_id, l_system_code)
2440: LOOP
2441: --debug(L_PROC_NAME||' entered For Loop on c_pub_ws_error');
2442: /*Note that for every entity, ego_pub_ws_errors will either have an Error or a Warning
2443: but not both. This is ensured in the ODI interface EGO_LOG_ICC_ERROR_MSGS.
2444: It marks an entity as a warning, only if it is not already marked as an error.*/
2445: IF (instr(err.ERR_CODE, '_ERROR') <> 0) THEN
2446: --debug(L_PROC_NAME||' entered ERROR scenario');

Line 2494: UPDATE EGO_PUB_WS_ERRORS

2490: AND SYSTEM_CODE = ip.SYSTEM_CODE;
2491: END IF; /*end of if ip.param_name = G_ENTITY_ICC*/
2492: -- Update Err_Message in EGO_PUB_WS_ERROR table
2493:
2494: UPDATE EGO_PUB_WS_ERRORS
2495: SET ERR_MESSAGE = l_message
2496: WHERE SESSION_ID = p_session_id
2497: AND INPUT_ID = l_input_id
2498: AND SYSTEM_CODE = l_system_code;

Line 2499: --debug(L_PROC_NAME||' updated EGO_PUB_WS_ERRORS with ERR_MESSAGE - first time');

2495: SET ERR_MESSAGE = l_message
2496: WHERE SESSION_ID = p_session_id
2497: AND INPUT_ID = l_input_id
2498: AND SYSTEM_CODE = l_system_code;
2499: --debug(L_PROC_NAME||' updated EGO_PUB_WS_ERRORS with ERR_MESSAGE - first time');
2500:
2501: END IF; /*end of if on l_error_rec_count > 1*/
2502:
2503: /*if l_error_rec_count=1 implies that it can be either be

Line 2541: UPDATE EGO_PUB_WS_ERRORS

2537: END IF; /*end of if ip.param_name = G_ENTITY_ICC*/
2538:
2539: -- Update Err_Message in EGO_PUB_WS_ERROR table
2540:
2541: UPDATE EGO_PUB_WS_ERRORS
2542: SET ERR_MESSAGE = l_message
2543: WHERE SESSION_ID = p_session_id
2544: AND INPUT_ID = l_input_id
2545: AND SYSTEM_CODE = l_system_code;

Line 2546: --debug(L_PROC_NAME||' updated EGO_PUB_WS_ERRORS with ERR_MESSAGE - second time');

2542: SET ERR_MESSAGE = l_message
2543: WHERE SESSION_ID = p_session_id
2544: AND INPUT_ID = l_input_id
2545: AND SYSTEM_CODE = l_system_code;
2546: --debug(L_PROC_NAME||' updated EGO_PUB_WS_ERRORS with ERR_MESSAGE - second time');
2547:
2548: END IF; /*end of if on l_error_rec_count=1*/
2549: --debug(L_PROC_NAME||' end of if on l_error_rec_count=1');
2550:

Line 2591: UPDATE EGO_PUB_WS_ERRORS

2587: END IF; /*end of if ip.param_name = G_ENTITY_ICC*/
2588:
2589: -- Update Err_Message in EGO_PUB_WS_ERROR table
2590:
2591: UPDATE EGO_PUB_WS_ERRORS
2592: SET ERR_MESSAGE = l_message
2593: WHERE SESSION_ID = p_session_id
2594: AND INPUT_ID = l_input_id
2595: AND SYSTEM_CODE = l_system_code;

Line 2596: --debug(L_PROC_NAME||' updated EGO_PUB_WS_ERRORS with ERR_MESSAGE - third time');

2592: SET ERR_MESSAGE = l_message
2593: WHERE SESSION_ID = p_session_id
2594: AND INPUT_ID = l_input_id
2595: AND SYSTEM_CODE = l_system_code;
2596: --debug(L_PROC_NAME||' updated EGO_PUB_WS_ERRORS with ERR_MESSAGE - third time');
2597:
2598: END IF; /*end of if on (instr(err.ERR_CODE, '_WARNING') <> 0)*/
2599: --debug(L_PROC_NAME||' end of if on (instr(err.ERR_CODE, _WARNING) <> 0');
2600: END LOOP; /*end of loop on c_pub_ws_error*/