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.FEM_XGL_POST_ENGINE_PKG dependencies on FEM_XGL_POST_ENGINE_PKG

Line 1: PACKAGE BODY FEM_XGL_POST_ENGINE_PKG AS

1: PACKAGE BODY FEM_XGL_POST_ENGINE_PKG AS
2: /* $Header: fem_xgl_post_eng.plb 120.6 2007/06/27 19:11:57 ghall ship $ */
3:
4: /***********************************************************************
5: * PACKAGE VARIABLES *

Line 54: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Finish_Condition_String',

50: p_module => 'fem.plsql.xgl_eng.fcs.' || pv_process_slice,
51: p_app_name => 'FEM',
52: p_msg_name => 'FEM_GL_POST_201',
53: p_token1 => 'FUNC_NAME',
54: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Finish_Condition_String',
55: p_token2 => 'TIME',
56: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
57:
58: x_condition_string := x_condition_string ||

Line 90: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Finish_Condition_String',

86: p_module => 'fem.plsql.xgl_eng.fcs.' || pv_process_slice,
87: p_app_name => 'FEM',
88: p_msg_name => 'FEM_GL_POST_202',
89: p_token1 => 'FUNC_NAME',
90: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Finish_Condition_String',
91: p_token2 => 'TIME',
92: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
93:
94: END Finish_Condition_String;

Line 126: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Mark_Rows_For_Process',

122: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
123: p_app_name => 'FEM',
124: p_msg_name => 'FEM_GL_POST_201',
125: p_token1 => 'FUNC_NAME',
126: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Mark_Rows_For_Process',
127: p_token2 => 'TIME',
128: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
129:
130: x_completion_code := 0;

Line 247: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Mark_Rows_For_Process',

243: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
244: p_app_name => 'FEM',
245: p_msg_name => 'FEM_GL_POST_202',
246: p_token1 => 'FUNC_NAME',
247: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Mark_Rows_For_Process',
248: p_token2 => 'TIME',
249: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
250:
251: COMMIT;

Line 280: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Mark_Rows_For_Process',

276: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,
277: p_app_name => 'FEM',
278: p_msg_name => 'FEM_GL_POST_203',
279: p_token1 => 'FUNC_NAME',
280: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Mark_Rows_For_Process',
281: p_token2 => 'TIME',
282: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
283:
284: END Mark_Rows_For_Process;

Line 347: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Validate_Interface_Data',

343: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
344: p_app_name => 'FEM',
345: p_msg_name => 'FEM_GL_POST_201',
346: p_token1 => 'FUNC_NAME',
347: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Validate_Interface_Data',
348: p_token2 => 'TIME',
349: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
350:
351: -- Initialize variable

Line 664: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Validate_Interface_Data',

660: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
661: p_app_name => 'FEM',
662: p_msg_name => 'FEM_GL_POST_202',
663: p_token1 => 'FUNC_NAME',
664: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Validate_Interface_Data',
665: p_token2 => 'TIME',
666: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
667:
668: EXCEPTION

Line 690: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Validate_Interface_Data',

686: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
687: p_app_name => 'FEM',
688: p_msg_name => 'FEM_GL_POST_203',
689: p_token1 => 'FUNC_NAME',
690: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Validate_Interface_Data',
691: p_token2 => 'TIME',
692: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
693:
694: WHEN OTHERS THEN

Line 720: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Validate_Interface_Data',

716: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
717: p_app_name => 'FEM',
718: p_msg_name => 'FEM_GL_POST_203',
719: p_token1 => 'FUNC_NAME',
720: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Validate_Interface_Data',
721: p_token2 => 'TIME',
722: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
723:
724: END Validate_Interface_Data;

Line 781: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_To_Interim',

777: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
778: p_app_name => 'FEM',
779: p_msg_name => 'FEM_GL_POST_201',
780: p_token1 => 'FUNC_NAME',
781: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_To_Interim',
782: p_token2 => 'TIME',
783: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
784:
785: -- Initialize all output counters for this load set

Line 1237: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_To_Interim',

1233: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1234: p_app_name => 'FEM',
1235: p_msg_name => 'FEM_GL_POST_202',
1236: p_token1 => 'FUNC_NAME',
1237: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_To_Interim',
1238: p_token2 => 'TIME',
1239: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1240:
1241: EXCEPTION

Line 1268: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_To_Interim',

1264: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1265: p_app_name => 'FEM',
1266: p_msg_name => 'FEM_GL_POST_203',
1267: p_token1 => 'FUNC_NAME',
1268: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_To_Interim',
1269: p_token2 => 'TIME',
1270: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1271:
1272: END Post_To_Interim;

Line 1327: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_Cycle_Handler',

1323: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1324: p_app_name => 'FEM',
1325: p_msg_name => 'FEM_GL_POST_201',
1326: p_token1 => 'FUNC_NAME',
1327: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_Cycle_Handler',
1328: p_token2 => 'TIME',
1329: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1330:
1331: x_completion_code := 0;

Line 1488: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_Cycle_Handler',

1484: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1485: p_app_name => 'FEM',
1486: p_msg_name => 'FEM_GL_POST_202',
1487: p_token1 => 'FUNC_NAME',
1488: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_Cycle_Handler',
1489: p_token2 => 'TIME',
1490: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1491:
1492: EXCEPTION

Line 1524: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_Cycle_Handler',

1520: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1521: p_app_name => 'FEM',
1522: p_msg_name => 'FEM_GL_POST_202',
1523: p_token1 => 'FUNC_NAME',
1524: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_Cycle_Handler',
1525: p_token2 => 'TIME',
1526: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1527:
1528: WHEN FEMXGL_fatal_err THEN

Line 1540: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_Cycle_Handler',

1536: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1537: p_app_name => 'FEM',
1538: p_msg_name => 'FEM_GL_POST_203',
1539: p_token1 => 'FUNC_NAME',
1540: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Post_Cycle_Handler',
1541: p_token2 => 'TIME',
1542: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1543:
1544: WHEN OTHERS THEN

Line 1570: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.post_cycle_handler',

1566: p_module => 'fem.plsql.xgl_eng.pch.' || pv_process_slice,
1567: p_app_name => 'FEM',
1568: p_msg_name => 'FEM_GL_POST_203',
1569: p_token1 => 'FUNC_NAME',
1570: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.post_cycle_handler',
1571: p_token2 => 'TIME',
1572: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1573:
1574: END Post_Cycle_Handler;

Line 1852: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',

1848: p_module => 'fem.plsql.xgl_eng.main',
1849: p_app_name => 'FEM',
1850: p_msg_name => 'FEM_GL_POST_201',
1851: p_token1 => 'FUNC_NAME',
1852: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',
1853: p_token2 => 'TIME',
1854: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
1855:
1856: FEM_ENGINES_PKG.User_Message

Line 2031: P_ENG_PRG => 'FEM_XGL_POST_ENGINE_PKG.PROCESS_DATA_SLICE',

2027: P_ENG_SQL => '{{table_partition}}',
2028: P_TABLE_ALIAS => NULL,
2029: P_RUN_NAME => 'XGL Integration ' ||
2030: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),
2031: P_ENG_PRG => 'FEM_XGL_POST_ENGINE_PKG.PROCESS_DATA_SLICE',
2032: P_CONDITION => v_slices_condition,
2033: P_FAILED_REQ_ID => FEM_GL_POST_PROCESS_PKG.pv_prev_req_id,
2034: P_REUSE_SLICES => v_reuse_slices,
2035: P_ARG1 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_req_id),

Line 2326: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',

2322: p_module => 'fem.plsql.xgl_eng.main',
2323: p_app_name => 'FEM',
2324: p_msg_name => 'FEM_GL_POST_202',
2325: p_token1 => 'FUNC_NAME',
2326: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',
2327: p_token2 => 'TIME',
2328: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2329:
2330: v_ret_status := FND_CONCURRENT.Set_Completion_Status

Line 2350: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',

2346: p_module => 'fem.plsql.xgl_eng.main',
2347: p_app_name => 'FEM',
2348: p_msg_name => 'FEM_GL_POST_203',
2349: p_token1 => 'FUNC_NAME',
2350: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',
2351: p_token2 => 'TIME',
2352: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2353:
2354: v_ret_status := FND_CONCURRENT.Set_Completion_Status

Line 2395: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',

2391: p_module => 'fem.plsql.xgl_eng.main',
2392: p_app_name => 'FEM',
2393: p_msg_name => 'FEM_GL_POST_202',
2394: p_token1 => 'FUNC_NAME',
2395: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',
2396: p_token2 => 'TIME',
2397: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2398:
2399: v_ret_status := FND_CONCURRENT.Set_Completion_Status

Line 2513: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',

2509: p_module => 'fem.plsql.xgl_eng.main',
2510: p_app_name => 'FEM',
2511: p_msg_name => 'FEM_GL_POST_202',
2512: p_token1 => 'FUNC_NAME',
2513: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',
2514: p_token2 => 'TIME',
2515: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2516:
2517: COMMIT;

Line 2547: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',

2543: p_module => 'fem.plsql.xgl_eng.main',
2544: p_app_name => 'FEM',
2545: p_msg_name => 'FEM_GL_POST_203',
2546: p_token1 => 'FUNC_NAME',
2547: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',
2548: p_token2 => 'TIME',
2549: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2550:
2551: v_ret_status := FND_CONCURRENT.Set_Completion_Status

Line 2588: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',

2584: p_module => 'fem.plsql.xgl_eng.main',
2585: p_app_name => 'FEM',
2586: p_msg_name => 'FEM_GL_POST_203',
2587: p_token1 => 'FUNC_NAME',
2588: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Main',
2589: p_token2 => 'TIME',
2590: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2591:
2592: v_ret_status := FND_CONCURRENT.Set_Completion_Status

Line 2620: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Log_Package_Variables',

2616: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2617: p_app_name => 'FEM',
2618: p_msg_name => 'FEM_GL_POST_201',
2619: p_token1 => 'FUNC_NAME',
2620: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Log_Package_Variables',
2621: p_token2 => 'TIME',
2622: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2623:
2624: FEM_ENGINES_PKG.Tech_Message

Line 2801: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Log_Package_Variables',

2797: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2798: p_app_name => 'FEM',
2799: p_msg_name => 'FEM_GL_POST_202',
2800: p_token1 => 'FUNC_NAME',
2801: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Log_Package_Variables',
2802: p_token2 => 'TIME',
2803: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2804:
2805: END Log_Pkg_Variables;

Line 2935: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Process_Data_Slice',

2931: p_module => 'fem.plsql.xgl_eng.pds.' || pv_process_slice,
2932: p_app_name => 'FEM',
2933: p_msg_name => 'FEM_GL_POST_201',
2934: p_token1 => 'FUNC_NAME',
2935: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Process_Data_Slice',
2936: p_token2 => 'TIME',
2937: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
2938:
2939: FEM_ENGINES_PKG.Tech_Message

Line 3378: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Process_Data_Slice',

3374: p_module => 'fem.plsql.xgl_eng.pds',
3375: p_app_name => 'FEM',
3376: p_msg_name => 'FEM_GL_POST_202',
3377: p_token1 => 'FUNC_NAME',
3378: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Process_Data_Slice',
3379: p_token2 => 'TIME',
3380: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
3381:
3382: EXCEPTION

Line 3414: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Process_Data_Slice',

3410: pv_process_slice || '.fatal_err',
3411: p_app_name => 'FEM',
3412: p_msg_name => 'FEM_GL_POST_203',
3413: p_token1 => 'FUNC_NAME',
3414: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Process_Data_Slice',
3415: p_token2 => 'TIME',
3416: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
3417:
3418: WHEN OTHERS THEN

Line 3466: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Process_Data_Slice',

3462: pv_process_slice || '.unexpected_exception',
3463: p_app_name => 'FEM',
3464: p_msg_name => 'FEM_GL_POST_203',
3465: p_token1 => 'FUNC_NAME',
3466: p_value1 => 'FEM_XGL_POST_ENGINE_PKG.Process_Data_Slice',
3467: p_token2 => 'TIME',
3468: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
3469:
3470: END Process_Data_Slice;

Line 3473: END FEM_XGL_POST_ENGINE_PKG;

3469:
3470: END Process_Data_Slice;
3471: -- =======================================================================
3472:
3473: END FEM_XGL_POST_ENGINE_PKG;