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_GL_POST_PROCESS_PKG

Line 60: FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd || '''' ||

56: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
57:
58: x_condition_string := x_condition_string ||
59: ' AND cal_per_dim_grp_display_code = ''' ||
60: FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd || '''' ||
61: ' AND cal_period_end_date = TO_DATE(''' ||
62: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS') ||
63: ''', ''YYYY/MM/DD HH24:MI:SS'')' ||
64: ' AND cal_period_number = TO_NUMBER(''' ||

Line 62: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS') ||

58: x_condition_string := x_condition_string ||
59: ' AND cal_per_dim_grp_display_code = ''' ||
60: FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd || '''' ||
61: ' AND cal_period_end_date = TO_DATE(''' ||
62: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS') ||
63: ''', ''YYYY/MM/DD HH24:MI:SS'')' ||
64: ' AND cal_period_number = TO_NUMBER(''' ||
65: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number) || ''')' ||
66: ' AND ledger_display_code = ''' ||

Line 65: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number) || ''')' ||

61: ' AND cal_period_end_date = TO_DATE(''' ||
62: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS') ||
63: ''', ''YYYY/MM/DD HH24:MI:SS'')' ||
64: ' AND cal_period_number = TO_NUMBER(''' ||
65: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number) || ''')' ||
66: ' AND ledger_display_code = ''' ||
67: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd || '''' ||
68: ' AND ds_balance_type_code = ''' ||
69: FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd || '''';

Line 67: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd || '''' ||

63: ''', ''YYYY/MM/DD HH24:MI:SS'')' ||
64: ' AND cal_period_number = TO_NUMBER(''' ||
65: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number) || ''')' ||
66: ' AND ledger_display_code = ''' ||
67: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd || '''' ||
68: ' AND ds_balance_type_code = ''' ||
69: FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd || '''';
70:
71: IF FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd IS NOT NULL THEN

Line 69: FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd || '''';

65: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number) || ''')' ||
66: ' AND ledger_display_code = ''' ||
67: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd || '''' ||
68: ' AND ds_balance_type_code = ''' ||
69: FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd || '''';
70:
71: IF FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd IS NOT NULL THEN
72:
73: x_condition_string := x_condition_string ||

Line 71: IF FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd IS NOT NULL THEN

67: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd || '''' ||
68: ' AND ds_balance_type_code = ''' ||
69: FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd || '''';
70:
71: IF FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd IS NOT NULL THEN
72:
73: x_condition_string := x_condition_string ||
74: ' AND budget_display_code = ''' ||
75: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd || '''';

Line 75: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd || '''';

71: IF FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd IS NOT NULL THEN
72:
73: x_condition_string := x_condition_string ||
74: ' AND budget_display_code = ''' ||
75: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd || '''';
76:
77: ELSIF FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd IS NOT NULL THEN
78:
79: x_condition_string := x_condition_string ||

Line 77: ELSIF FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd IS NOT NULL THEN

73: x_condition_string := x_condition_string ||
74: ' AND budget_display_code = ''' ||
75: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd || '''';
76:
77: ELSIF FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd IS NOT NULL THEN
78:
79: x_condition_string := x_condition_string ||
80: ' AND encumbrance_type_code = ''' ||
81: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd || '''';

Line 81: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd || '''';

77: ELSIF FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd IS NOT NULL THEN
78:
79: x_condition_string := x_condition_string ||
80: ' AND encumbrance_type_code = ''' ||
81: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd || '''';
82: END IF;
83:
84: FEM_ENGINES_PKG.Tech_Message
85: (p_severity => pc_log_level_procedure,

Line 159: IF FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S' THEN

155: -- LOAD_SET_ID when processing the snapshot rows.
156:
157: pv_marking_sql := pv_marking_sql || 'WHERE load_method_code = ''S'' ';
158:
159: IF FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S' THEN
160:
161: -- For Snapshot mode, we ignore the posting_error_code because
162: -- we will process everything.
163: -- For Incremental and Error Reprocessing modes, we will only pick

Line 183: IF FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'E' THEN

179: pv_marking_sql := pv_marking_sql ||
180: 'WHERE load_set_id = :load_set_id ' ||
181: 'AND load_method_code = ''I'' ';
182:
183: IF FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'E' THEN
184:
185: -- For Error Reprocessing mode, we will only pick up rows
186: -- marked with an error before.
187:

Line 365: IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S')

361: -- 1. Verify that there is only one load_method_code in the given load set.
362: -- (This is only needed for Incremental and Error Reprocessing loads)
363: ---------------------------------------------------------------------------
364:
365: IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S')
366: AND (v_proc_snapshot_rows = 'N') THEN
367: v_sql_stmt :=
368: ' UPDATE fem_bal_interface_t ' ||
369: ' SET posting_error_code = ''FEM_GL_POST_MIX_LOAD_METHOD'' ' ||

Line 409: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num',

405: p_module => 'fem.plsql.xgl_eng.vid.' || pv_process_slice,
406: p_app_name => 'FEM',
407: p_msg_name => 'FEM_GL_POST_204',
408: p_token1 => 'VAR_NAME',
409: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num',
410: p_token2 => 'VAR_VAL',
411: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num);
412:
413: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP

Line 411: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num);

407: p_msg_name => 'FEM_GL_POST_204',
408: p_token1 => 'VAR_NAME',
409: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num',
410: p_token2 => 'VAR_VAL',
411: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num);
412:
413: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP
414:
415: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col IN

Line 413: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP

409: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num',
410: p_token2 => 'VAR_VAL',
411: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num);
412:
413: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP
414:
415: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col IN
416: ('CCTR_ORG_DISPLAY_CODE', 'FINANCIAL_ELEM_DISPLAY_CODE',
417: 'PRODUCT_DISPLAY_CODE', 'NATURAL_ACCOUNT_DISPLAY_CODE',

Line 415: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col IN

411: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num);
412:
413: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP
414:
415: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col IN
416: ('CCTR_ORG_DISPLAY_CODE', 'FINANCIAL_ELEM_DISPLAY_CODE',
417: 'PRODUCT_DISPLAY_CODE', 'NATURAL_ACCOUNT_DISPLAY_CODE',
418: 'CHANNEL_DISPLAY_CODE', 'LINE_ITEM_DISPLAY_CODE', 'CURRENCY_CODE',
419: 'CURRENCY_TYPE_CODE', 'PROJECT_DISPLAY_CODE',

Line 430: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col;

426: 'USER_DIM7_DISPLAY_CODE', 'USER_DIM8_DISPLAY_CODE',
427: 'USER_DIM9_DISPLAY_CODE', 'USER_DIM10_DISPLAY_CODE')) THEN
428:
429: pv_col :=
430: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col;
431:
432: IF v_first_time = 'N' THEN
433: v_key_stmt2 := v_key_stmt2 || ', ';
434: v_key_stmt3 := v_key_stmt3 || ', ';

Line 543: IF (FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code = 'ALL') THEN

539: ' UPDATE fem_bal_interface_t ' ||
540: ' SET posting_error_code = ''FEM_GL_POST_MISSING_BAL_COL'' ';
541:
542: -- Contruct the where clause based on the QTD-YTD parameter specification
543: IF (FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code = 'ALL') THEN
544: v_sql_stmt := v_sql_stmt ||
545: ' WHERE ((currency_type_code = ''ENTERED'' AND ' ||
546: ' (xtd_balance_f IS NULL OR qtd_balance_f IS NULL OR '||
547: ' ytd_balance_f IS NULL)) OR ' ||

Line 553: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code = 'YTD') THEN

549: ':pv_entered_crncy_flag = ''Y'') AND ' ||
550: ' (xtd_balance_e IS NULL OR qtd_balance_e IS NULL OR '||
551: ' ytd_balance_e IS NULL))) ';
552:
553: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code = 'YTD') THEN
554: v_sql_stmt := v_sql_stmt ||
555: ' WHERE ((currency_type_code = ''ENTERED'' AND ' ||
556: ' (xtd_balance_f IS NULL OR ytd_balance_f IS NULL)) OR '||
557: ' ((currency_type_code = ''TRANSLATED'' OR ' ||

Line 561: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code = 'QTD') THEN

557: ' ((currency_type_code = ''TRANSLATED'' OR ' ||
558: ':pv_entered_crncy_flag = ''Y'') AND ' ||
559: ' (xtd_balance_e IS NULL OR ytd_balance_e IS NULL))) ';
560:
561: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code = 'QTD') THEN
562: v_sql_stmt := v_sql_stmt ||
563: ' WHERE ((currency_type_code = ''ENTERED'' AND ' ||
564: ' (xtd_balance_f IS NULL OR qtd_balance_f IS NULL)) OR '||
565: ' ((currency_type_code = ''TRANSLATED'' OR ' ||

Line 569: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code = 'PTD') THEN

565: ' ((currency_type_code = ''TRANSLATED'' OR ' ||
566: ':pv_entered_crncy_flag = ''Y'') AND ' ||
567: ' (xtd_balance_e IS NULL OR qtd_balance_e IS NULL))) ';
568:
569: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code = 'PTD') THEN
570: v_sql_stmt := v_sql_stmt ||
571: ' WHERE ((currency_type_code = ''ENTERED''' ||
572: ' AND xtd_balance_f IS NULL) OR ' ||
573: ' ((currency_type_code = ''TRANSLATED'' OR ' ||

Line 592: USING FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,

588: p_module => 'fem.plsql.xgl_eng.vid.4.' || pv_process_slice,
589: p_msg_text => 'v_sql_stmt: ' || v_sql_stmt);
590:
591: EXECUTE IMMEDIATE v_sql_stmt
592: USING FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,
593: pv_req_id_slice, p_load_set_id,
594: v_proc_snapshot_rows;
595:
596: -- Keep track of how many invalid rows marked

Line 609: IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S') THEN

605: -- (This is only needed for Incremental and Error Reprocessing loads,
606: -- since for Snapshot loads, everything is processed in a single
607: -- shot)
608: ---------------------------------------------------------------------------
609: IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S') THEN
610: v_sql_stmt :=
611: ' UPDATE fem_bal_interface_t u' ||
612: ' SET posting_error_code = ''FEM_GL_POST_PREV_SET_ERROR'' ' ||
613: ' WHERE ( ' || v_key_stmt2 || ') IN' ||

Line 859: FEM_GL_POST_PROCESS_PKG.pv_dataset_code,

855: posting_error_flag)
856: SELECT
857: rowid,
858: bal_post_type_code,
859: FEM_GL_POST_PROCESS_PKG.pv_dataset_code,
860: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id,
861: FEM_GL_POST_PROCESS_PKG.pv_ledger_id,
862: -1,
863: currency_code,

Line 860: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id,

856: SELECT
857: rowid,
858: bal_post_type_code,
859: FEM_GL_POST_PROCESS_PKG.pv_dataset_code,
860: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id,
861: FEM_GL_POST_PROCESS_PKG.pv_ledger_id,
862: -1,
863: currency_code,
864: currency_type_code,

Line 861: FEM_GL_POST_PROCESS_PKG.pv_ledger_id,

857: rowid,
858: bal_post_type_code,
859: FEM_GL_POST_PROCESS_PKG.pv_dataset_code,
860: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id,
861: FEM_GL_POST_PROCESS_PKG.pv_ledger_id,
862: -1,
863: currency_code,
864: currency_type_code,
865: xtd_balance_e,

Line 867: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,

863: currency_code,
864: currency_type_code,
865: xtd_balance_e,
866: xtd_balance_f,
867: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
868: 'PTD', NULL, 'QTD', NULL, ytd_balance_e),
869: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
870: 'PTD', NULL, 'QTD', NULL, ytd_balance_f),
871: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,

Line 869: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,

865: xtd_balance_e,
866: xtd_balance_f,
867: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
868: 'PTD', NULL, 'QTD', NULL, ytd_balance_e),
869: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
870: 'PTD', NULL, 'QTD', NULL, ytd_balance_f),
871: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
872: 'PTD', NULL, 'YTD', NULL, qtd_balance_e),
873: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,

Line 871: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,

867: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
868: 'PTD', NULL, 'QTD', NULL, ytd_balance_e),
869: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
870: 'PTD', NULL, 'QTD', NULL, ytd_balance_f),
871: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
872: 'PTD', NULL, 'YTD', NULL, qtd_balance_e),
873: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
874: 'PTD', NULL, 'YTD', NULL, qtd_balance_e),
875: ptd_debit_balance_e,

Line 873: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,

869: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
870: 'PTD', NULL, 'QTD', NULL, ytd_balance_f),
871: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
872: 'PTD', NULL, 'YTD', NULL, qtd_balance_e),
873: DECODE(FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
874: 'PTD', NULL, 'YTD', NULL, qtd_balance_e),
875: ptd_debit_balance_e,
876: ptd_credit_balance_e,
877: ytd_debit_balance_e,

Line 921: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP

917: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
918: p_msg_text =>
919: 'Looking up member numeric IDs for 5 dimensions at a time...');
920:
921: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP
922:
923: IF (v_dim_count = 1) THEN
924:
925: -- This is the start of a new statement after one execution,

Line 935: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name IN

931: v_join_stmt := 'WHERE i.rowid = g.interface_rowid ';
932:
933: END IF;
934:
935: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name IN
936: ('COMPANY_COST_CENTER_ORG_ID', 'FINANCIAL_ELEM_ID', 'CURRENCY_CODE',
937: 'PRODUCT_ID', 'NATURAL_ACCOUNT_ID', 'CHANNEL_ID', 'LINE_ITEM_ID',
938: 'PROJECT_ID', 'CUSTOMER_ID', 'ENTITY_ID', 'INTERCOMPANY_ID',
939: 'TASK_ID', 'USER_DIM1_ID', 'USER_DIM2_ID', 'USER_DIM3_ID',

Line 972: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name);

968: p_msg_name => 'FEM_GL_POST_204',
969: p_token1 => 'VAR_NAME',
970: p_value1 => 'dim column name',
971: p_token2 => 'VAR_VAL',
972: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name);
973:
974: -- Build the list of columns for updating
975: v_upd_cols := v_upd_cols || 'g.' ||
976: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name || ', ';

Line 976: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name || ', ';

972: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name);
973:
974: -- Build the list of columns for updating
975: v_upd_cols := v_upd_cols || 'g.' ||
976: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name || ', ';
977:
978: -- Build SELECT column lists
979: v_sel_stmt := v_sel_stmt ||
980: 'dm' || TO_CHAR(v_dim_count) || '.' ||

Line 981: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_member_col || ', ';

977:
978: -- Build SELECT column lists
979: v_sel_stmt := v_sel_stmt ||
980: 'dm' || TO_CHAR(v_dim_count) || '.' ||
981: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_member_col || ', ';
982:
983: -- Build table list
984: v_tab_list := v_tab_list ||
985: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_member_b_table_name ||

Line 985: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_member_b_table_name ||

981: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_member_col || ', ';
982:
983: -- Build table list
984: v_tab_list := v_tab_list ||
985: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_member_b_table_name ||
986: ' dm' || v_dim_count || ', ';
987:
988: -- Build related join conditions
989: v_join_stmt :=

Line 992: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_member_disp_code_col ||

988: -- Build related join conditions
989: v_join_stmt :=
990: v_join_stmt ||
991: 'AND dm' || v_dim_count || '.' ||
992: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_member_disp_code_col ||
993: ' = i.' ||
994: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col ||
995: ' AND dm' || v_dim_count || '.' || 'personal_flag = ''N'' ' ||
996: ' AND dm' || v_dim_count || '.' || 'enabled_flag = ''Y'' ';

Line 994: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col ||

990: v_join_stmt ||
991: 'AND dm' || v_dim_count || '.' ||
992: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_member_disp_code_col ||
993: ' = i.' ||
994: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col ||
995: ' AND dm' || v_dim_count || '.' || 'personal_flag = ''N'' ' ||
996: ' AND dm' || v_dim_count || '.' || 'enabled_flag = ''Y'' ';
997:
998: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_vsr_flag = 'Y') THEN

Line 998: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_vsr_flag = 'Y') THEN

994: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_int_disp_code_col ||
995: ' AND dm' || v_dim_count || '.' || 'personal_flag = ''N'' ' ||
996: ' AND dm' || v_dim_count || '.' || 'enabled_flag = ''Y'' ';
997:
998: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_vsr_flag = 'Y') THEN
999: v_join_stmt := v_join_stmt ||
1000: 'AND dm' || v_dim_count || '.value_set_id = ' ||
1001: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_vs_id) || ' ';
1002:

Line 1001: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_vs_id) || ' ';

997:
998: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_vsr_flag = 'Y') THEN
999: v_join_stmt := v_join_stmt ||
1000: 'AND dm' || v_dim_count || '.value_set_id = ' ||
1001: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_vs_id) || ' ';
1002:
1003: END IF;
1004:
1005: v_dim_count := v_dim_count + 1;

Line 1013: IF (v_dim_count = 6 or v = FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num) THEN

1009: -- If 5 dimensions have been built into the statement
1010: -- (i.e. v_dim_count = 6), put the parts together
1011: -- and execute the UPDATE
1012:
1013: IF (v_dim_count = 6 or v = FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num) THEN
1014:
1015: v_sql_stmt := v_sql_stmt ||
1016: RTRIM(v_upd_cols, ', ') || ') = ' ||
1017: RTRIM(v_sel_stmt, ', ') || ' ' ||

Line 1082: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP

1078: 'SET posting_error_flag = ''Y'' ' || 'WHERE ';
1079:
1080: v_dim_count := 1;
1081:
1082: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP
1083:
1084: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name IN
1085: ('COMPANY_COST_CENTER_ORG_ID', 'FINANCIAL_ELEM_ID', 'CURRENCY_CODE',
1086: 'PRODUCT_ID', 'NATURAL_ACCOUNT_ID', 'CHANNEL_ID', 'LINE_ITEM_ID',

Line 1084: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name IN

1080: v_dim_count := 1;
1081:
1082: FOR v IN 1..FEM_GL_POST_PROCESS_PKG.pv_proc_key_dim_num LOOP
1083:
1084: IF (FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name IN
1085: ('COMPANY_COST_CENTER_ORG_ID', 'FINANCIAL_ELEM_ID', 'CURRENCY_CODE',
1086: 'PRODUCT_ID', 'NATURAL_ACCOUNT_ID', 'CHANNEL_ID', 'LINE_ITEM_ID',
1087: 'PROJECT_ID', 'CUSTOMER_ID', 'ENTITY_ID', 'INTERCOMPANY_ID',
1088: 'TASK_ID', 'USER_DIM1_ID', 'USER_DIM2_ID', 'USER_DIM3_ID',

Line 1096: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name || ' IS NULL ';

1092:
1093: IF (v_dim_count = 1) THEN
1094:
1095: v_sql_stmt := v_sql_stmt ||
1096: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name || ' IS NULL ';
1097: v_dim_count := 0;
1098:
1099: ELSE
1100:

Line 1102: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name || ' IS NULL ';

1098:
1099: ELSE
1100:
1101: v_sql_stmt := v_sql_stmt || 'OR ' ||
1102: FEM_GL_POST_PROCESS_PKG.pv_proc_keys(v).dim_col_name || ' IS NULL ';
1103:
1104: END IF;
1105:
1106: END IF;

Line 1461: (p_execution_mode => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,

1457: p_app_name => 'FEM',
1458: p_msg_name => 'FEM_GL_POST_214');
1459:
1460: FEM_GL_POST_BAL_PKG.Post_Fem_Balances
1461: (p_execution_mode => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
1462: p_process_slice => pv_process_slice,
1463: x_rows_posted => v_posted_rows,
1464: x_completion_code => v_compl_code);
1465:

Line 1621: AND gvscd.global_vs_combo_id = FEM_GL_POST_PROCESS_PKG.pv_global_vs_combo_id

1617: AND xd.value_set_required_flag = 'Y'
1618: AND d.dimension_id = tc.dimension_id
1619: AND cm.object_type_code = 'XGL_INTEGRATION'
1620: AND cm.target_column_name = tc.column_name
1621: AND gvscd.global_vs_combo_id = FEM_GL_POST_PROCESS_PKG.pv_global_vs_combo_id
1622: AND gvscd.dimension_id = tc.dimension_id
1623: AND vs.dimension_id = gvscd.dimension_id
1624: AND vs.value_set_id = gvscd.value_set_id
1625: ORDER BY 1;

Line 1872: FEM_GL_POST_PROCESS_PKG.Validate_XGL_Eng_Parameters

1868: -- -----------------------------------
1869:
1870: v_warn_flag := 'N';
1871:
1872: FEM_GL_POST_PROCESS_PKG.Validate_XGL_Eng_Parameters
1873: (p_ledger_id => TO_NUMBER(p_ledger_id),
1874: p_cal_period_id => TO_NUMBER(p_cal_period_id),
1875: p_dataset_code => TO_NUMBER(p_dataset_code),
1876: p_xgl_obj_def_id => TO_NUMBER(p_xgl_int_obj_def_id),

Line 1904: FEM_GL_POST_PROCESS_PKG.Register_Process_Execution

1900: -- -----------------------------------
1901: -- *** Register Process Execution ***
1902: -- -----------------------------------
1903:
1904: FEM_GL_POST_PROCESS_PKG.Register_Process_Execution
1905: (x_completion_code => v_compl_code);
1906:
1907: IF v_compl_code = 2 THEN
1908: v_cp_status := 'ERROR';

Line 1978: FEM_GL_POST_PROCESS_PKG.pv_ssc_where := v_slices_condition;

1974: (p_severity => pc_log_level_statement,
1975: p_module => 'fem.plsql.xgl_eng.main',
1976: p_msg_text => 'v_slices_condition: ' || v_slices_condition);
1977:
1978: FEM_GL_POST_PROCESS_PKG.pv_ssc_where := v_slices_condition;
1979:
1980: -- ---------------------------------------------------------------------
1981: -- Get the list of distinct Source System Display Codes from the set
1982: -- of data to be processed. It will be used later by

Line 1986: FEM_GL_POST_PROCESS_PKG.Get_SSC (p_dest_code => 'TBP');

1982: -- of data to be processed. It will be used later by
1983: -- Final_Process_Logging to determine what to log in Data Locations.
1984: -- ---------------------------------------------------------------------
1985:
1986: FEM_GL_POST_PROCESS_PKG.Get_SSC (p_dest_code => 'TBP');
1987:
1988: -- ---------------------------------------------------------------------
1989: -- Call the Multiprocessing Framework master procedure. It will look up
1990: -- the multiprocessing parameters, determine the data slices, and start

Line 2004: IF FEM_GL_POST_PROCESS_PKG.pv_exec_state = 'RESTART' THEN

2000: -- MP parameters set for the INCREMENTAL step.
2001: v_eng_step := 'INCREMENTAL';
2002: END IF;
2003:
2004: IF FEM_GL_POST_PROCESS_PKG.pv_exec_state = 'RESTART' THEN
2005: -- The MP framework picks up where it left off in the previous
2006: -- attempt, with the next unprocessed data slice.
2007: v_reuse_slices := 'Y';
2008: ELSE

Line 2024: P_RULE_ID => FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id,

2020:
2021: FEM_MULTI_PROC_PKG.Master
2022: (X_PRG_STAT => v_cp_status,
2023: X_EXCEPTION_CODE => v_exception_code,
2024: P_RULE_ID => FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id,
2025: P_ENG_STEP => v_eng_step,
2026: P_DATA_TABLE => 'FEM_BAL_INTERFACE_T',
2027: P_ENG_SQL => '{{table_partition}}',
2028: P_TABLE_ALIAS => NULL,

Line 2033: P_FAILED_REQ_ID => FEM_GL_POST_PROCESS_PKG.pv_prev_req_id,

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),
2036: P_ARG2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2037: P_ARG3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id),

Line 2035: P_ARG1 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_req_id),

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),
2036: P_ARG2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2037: P_ARG3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id),
2038: P_ARG4 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code),
2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),

Line 2036: P_ARG2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,

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),
2036: P_ARG2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2037: P_ARG3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id),
2038: P_ARG4 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code),
2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),
2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),

Line 2037: P_ARG3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id),

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),
2036: P_ARG2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2037: P_ARG3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id),
2038: P_ARG4 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code),
2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),
2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),
2041: P_ARG7 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,

Line 2038: P_ARG4 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code),

2034: P_REUSE_SLICES => v_reuse_slices,
2035: P_ARG1 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_req_id),
2036: P_ARG2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2037: P_ARG3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id),
2038: P_ARG4 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code),
2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),
2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),
2041: P_ARG7 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
2042: P_ARG8 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,

Line 2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),

2035: P_ARG1 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_req_id),
2036: P_ARG2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2037: P_ARG3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id),
2038: P_ARG4 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code),
2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),
2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),
2041: P_ARG7 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
2042: P_ARG8 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,
2043: P_ARG9 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,

Line 2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),

2036: P_ARG2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2037: P_ARG3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id),
2038: P_ARG4 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code),
2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),
2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),
2041: P_ARG7 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
2042: P_ARG8 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,
2043: P_ARG9 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2044: P_ARG10 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,

Line 2041: P_ARG7 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,

2037: P_ARG3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id),
2038: P_ARG4 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code),
2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),
2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),
2041: P_ARG7 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
2042: P_ARG8 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,
2043: P_ARG9 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2044: P_ARG10 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2045: 'YYYY/MM/DD HH24:MI:SS'),

Line 2042: P_ARG8 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,

2038: P_ARG4 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code),
2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),
2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),
2041: P_ARG7 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
2042: P_ARG8 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,
2043: P_ARG9 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2044: P_ARG10 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2045: 'YYYY/MM/DD HH24:MI:SS'),
2046: P_ARG11 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number),

Line 2043: P_ARG9 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,

2039: P_ARG5 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id),
2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),
2041: P_ARG7 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
2042: P_ARG8 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,
2043: P_ARG9 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2044: P_ARG10 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2045: 'YYYY/MM/DD HH24:MI:SS'),
2046: P_ARG11 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number),
2047: P_ARG12 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

Line 2044: P_ARG10 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,

2040: P_ARG6 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id),
2041: P_ARG7 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code,
2042: P_ARG8 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,
2043: P_ARG9 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2044: P_ARG10 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2045: 'YYYY/MM/DD HH24:MI:SS'),
2046: P_ARG11 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number),
2047: P_ARG12 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2048: P_ARG13 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

Line 2046: P_ARG11 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number),

2042: P_ARG8 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag,
2043: P_ARG9 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2044: P_ARG10 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2045: 'YYYY/MM/DD HH24:MI:SS'),
2046: P_ARG11 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number),
2047: P_ARG12 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2048: P_ARG13 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2049: P_ARG14 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
2050: P_ARG15 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,

Line 2047: P_ARG12 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

2043: P_ARG9 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2044: P_ARG10 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2045: 'YYYY/MM/DD HH24:MI:SS'),
2046: P_ARG11 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number),
2047: P_ARG12 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2048: P_ARG13 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2049: P_ARG14 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
2050: P_ARG15 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2051: P_ARG16 => pv_schema_name);

Line 2048: P_ARG13 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

2044: P_ARG10 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2045: 'YYYY/MM/DD HH24:MI:SS'),
2046: P_ARG11 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number),
2047: P_ARG12 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2048: P_ARG13 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2049: P_ARG14 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
2050: P_ARG15 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2051: P_ARG16 => pv_schema_name);
2052:

Line 2049: P_ARG14 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,

2045: 'YYYY/MM/DD HH24:MI:SS'),
2046: P_ARG11 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number),
2047: P_ARG12 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2048: P_ARG13 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2049: P_ARG14 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
2050: P_ARG15 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2051: P_ARG16 => pv_schema_name);
2052:
2053: FEM_ENGINES_PKG.Tech_Message

Line 2050: P_ARG15 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,

2046: P_ARG11 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number),
2047: P_ARG12 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2048: P_ARG13 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2049: P_ARG14 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
2050: P_ARG15 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2051: P_ARG16 => pv_schema_name);
2052:
2053: FEM_ENGINES_PKG.Tech_Message
2054: (p_severity => pc_log_level_statement,

Line 2108: WHERE req_id = FEM_GL_POST_PROCESS_PKG.pv_req_id;

2104:
2105: SELECT SUM(rows_loaded), SUM(rows_processed), SUM(rows_rejected)
2106: INTO v_tot_posted_rows, v_tot_prev_err_rows_reproc, v_tot_cur_data_err_rows
2107: FROM fem_mp_process_ctl_t
2108: WHERE req_id = FEM_GL_POST_PROCESS_PKG.pv_req_id;
2109:
2110: FEM_ENGINES_PKG.Tech_Message
2111: (p_severity => pc_log_level_statement,
2112: p_module => 'fem.plsql.xgl_eng.main',

Line 2153: WHERE req_id = FEM_GL_POST_PROCESS_PKG.pv_req_id

2149:
2150: SELECT DISTINCT(message)
2151: BULK COLLECT INTO v_msg_list
2152: FROM fem_mp_process_ctl_t
2153: WHERE req_id = FEM_GL_POST_PROCESS_PKG.pv_req_id
2154: AND status = 2;
2155:
2156: FEM_ENGINES_PKG.Tech_Message
2157: (p_severity => pc_log_level_statement,

Line 2183: FEM_MULTI_PROC_PKG.Delete_Data_Slices(FEM_GL_POST_PROCESS_PKG.pv_req_id);

2179:
2180: END LOOP;
2181:
2182: -- Delete this process' data slice entries from the data slices table
2183: FEM_MULTI_PROC_PKG.Delete_Data_Slices(FEM_GL_POST_PROCESS_PKG.pv_req_id);
2184:
2185: RAISE FEMXGL_fatal_err;
2186:
2187: END IF;

Line 2190: FEM_MULTI_PROC_PKG.Delete_Data_Slices(FEM_GL_POST_PROCESS_PKG.pv_req_id);

2186:
2187: END IF;
2188:
2189: -- Delete this process' data slice entries from the data slices table
2190: FEM_MULTI_PROC_PKG.Delete_Data_Slices(FEM_GL_POST_PROCESS_PKG.pv_req_id);
2191:
2192: -- -------------------------------------------------------------------
2193: -- At this point, no fatal error has occurred, but there may be error
2194: -- conditions or warnings based on how much data was (or wasn't)

Line 2199: AND FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'S' THEN

2195: -- successfully processed.
2196: -- -------------------------------------------------------------------
2197:
2198: IF v_tot_posted_rows = 0
2199: AND FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'S' THEN
2200:
2201: -- -------------------------------------------------------------------
2202: -- Since No Data to Post has already been trapped, at this point if
2203: -- Rows_Loaded = 0 it means there was data to post but it all had

Line 2217: p_value => FEM_GL_POST_PROCESS_PKG.pv_req_id,

2213: -- -------------------------------------------------------------------
2214:
2215: WF_EVENT.addparametertolist
2216: (p_name => 'REQUEST_ID',
2217: p_value => FEM_GL_POST_PROCESS_PKG.pv_req_id,
2218: p_parameterlist => v_param_list);
2219:
2220: WF_EVENT.addparametertolist
2221: (p_name => 'EXECUTION_MODE',

Line 2313: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging

2309: v_param_list.DELETE;
2310:
2311: -- Perform final process logging, including Data Locations entries
2312:
2313: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging
2314: (p_exec_status => 'SUCCESS',
2315: p_num_data_errors => v_tot_cur_data_err_rows,
2316: p_num_data_errors_reproc => v_tot_prev_err_rows_reproc,
2317: p_num_output_rows => v_tot_posted_rows,

Line 2337: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging

2333: EXCEPTION
2334: WHEN FEMXGL_fatal_err THEN
2335:
2336: -- Perform post-process logging
2337: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging
2338: (p_exec_status => 'ERROR_RERUN',
2339: p_num_data_errors => v_tot_cur_data_err_rows,
2340: p_num_data_errors_reproc => v_tot_prev_err_rows_reproc,
2341: p_num_output_rows => v_tot_posted_rows,

Line 2380: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging

2376: v_param_list.DELETE;
2377:
2378: -- Perform post-process logging, including Data Locations entries
2379:
2380: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging
2381: (p_exec_status => 'SUCCESS',
2382: p_num_data_errors => v_tot_cur_data_err_rows,
2383: p_num_data_errors_reproc => v_tot_prev_err_rows_reproc,
2384: p_num_output_rows => v_tot_posted_rows,

Line 2425: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,

2421: FEM_ENGINES_PKG.User_Message
2422: (p_app_name => 'FEM',
2423: p_msg_name => 'FEM_GL_POST_225',
2424: p_token1 => 'LOAD_METHOD_CODE',
2425: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2426: p_token2 => 'CAL_PER_DIM_GRP_DISPLAY_CODE',
2427: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2428: p_token3 => 'CAL_PERIOD_END_DATE',
2429: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||

Line 2427: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,

2423: p_msg_name => 'FEM_GL_POST_225',
2424: p_token1 => 'LOAD_METHOD_CODE',
2425: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2426: p_token2 => 'CAL_PER_DIM_GRP_DISPLAY_CODE',
2427: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2428: p_token3 => 'CAL_PERIOD_END_DATE',
2429: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||
2430: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2431: p_token4 => 'CAL_PERIOD_NUMBER',

Line 2429: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||

2425: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2426: p_token2 => 'CAL_PER_DIM_GRP_DISPLAY_CODE',
2427: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2428: p_token3 => 'CAL_PERIOD_END_DATE',
2429: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||
2430: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2431: p_token4 => 'CAL_PERIOD_NUMBER',
2432: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2433: p_token5 => 'LEDGER_DISPLAY_CODE',

Line 2430: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),

2426: p_token2 => 'CAL_PER_DIM_GRP_DISPLAY_CODE',
2427: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2428: p_token3 => 'CAL_PERIOD_END_DATE',
2429: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||
2430: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2431: p_token4 => 'CAL_PERIOD_NUMBER',
2432: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2433: p_token5 => 'LEDGER_DISPLAY_CODE',
2434: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

Line 2432: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,

2428: p_token3 => 'CAL_PERIOD_END_DATE',
2429: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||
2430: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2431: p_token4 => 'CAL_PERIOD_NUMBER',
2432: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2433: p_token5 => 'LEDGER_DISPLAY_CODE',
2434: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2435: p_token6 => 'DS_BALANCE_TYPE_CODE',
2436: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,

Line 2434: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

2430: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2431: p_token4 => 'CAL_PERIOD_NUMBER',
2432: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2433: p_token5 => 'LEDGER_DISPLAY_CODE',
2434: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2435: p_token6 => 'DS_BALANCE_TYPE_CODE',
2436: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2437: p_token7 => 'BUDGET_DISPLAY_CODE',
2438: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

Line 2436: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,

2432: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2433: p_token5 => 'LEDGER_DISPLAY_CODE',
2434: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2435: p_token6 => 'DS_BALANCE_TYPE_CODE',
2436: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2437: p_token7 => 'BUDGET_DISPLAY_CODE',
2438: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2439: p_token8 => 'ENCUMBRANCE_TYPE_CODE',
2440: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);

Line 2438: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

2434: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2435: p_token6 => 'DS_BALANCE_TYPE_CODE',
2436: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2437: p_token7 => 'BUDGET_DISPLAY_CODE',
2438: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2439: p_token8 => 'ENCUMBRANCE_TYPE_CODE',
2440: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);
2441:
2442: FEM_ENGINES_PKG.User_Message

Line 2440: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);

2436: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2437: p_token7 => 'BUDGET_DISPLAY_CODE',
2438: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2439: p_token8 => 'ENCUMBRANCE_TYPE_CODE',
2440: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);
2441:
2442: FEM_ENGINES_PKG.User_Message
2443: (p_app_name => 'FEM',
2444: p_msg_name => 'FEM_GL_POST_228',

Line 2458: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,

2454: p_module => 'fem.plsql.xgl_eng.main',
2455: p_app_name => 'FEM',
2456: p_msg_name => 'FEM_GL_POST_225',
2457: p_token1 => 'LOAD_METHOD_CODE',
2458: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2459: p_token2 => 'CAL_PER_DIM_GRP_DISPLAY_CODE',
2460: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2461: p_token3 => 'CAL_PERIOD_END_DATE',
2462: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||

Line 2460: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,

2456: p_msg_name => 'FEM_GL_POST_225',
2457: p_token1 => 'LOAD_METHOD_CODE',
2458: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2459: p_token2 => 'CAL_PER_DIM_GRP_DISPLAY_CODE',
2460: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2461: p_token3 => 'CAL_PERIOD_END_DATE',
2462: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||
2463: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2464: p_token4 => 'CAL_PERIOD_NUMBER',

Line 2462: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||

2458: p_value1 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode,
2459: p_token2 => 'CAL_PER_DIM_GRP_DISPLAY_CODE',
2460: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2461: p_token3 => 'CAL_PERIOD_END_DATE',
2462: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||
2463: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2464: p_token4 => 'CAL_PERIOD_NUMBER',
2465: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2466: p_token5 => 'LEDGER_DISPLAY_CODE',

Line 2463: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),

2459: p_token2 => 'CAL_PER_DIM_GRP_DISPLAY_CODE',
2460: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
2461: p_token3 => 'CAL_PERIOD_END_DATE',
2462: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||
2463: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2464: p_token4 => 'CAL_PERIOD_NUMBER',
2465: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2466: p_token5 => 'LEDGER_DISPLAY_CODE',
2467: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

Line 2465: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,

2461: p_token3 => 'CAL_PERIOD_END_DATE',
2462: p_value3 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date) || ' ' ||
2463: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2464: p_token4 => 'CAL_PERIOD_NUMBER',
2465: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2466: p_token5 => 'LEDGER_DISPLAY_CODE',
2467: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2468: p_token6 => 'DS_BALANCE_TYPE_CODE',
2469: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,

Line 2467: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

2463: TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'HH24:MI:SS'),
2464: p_token4 => 'CAL_PERIOD_NUMBER',
2465: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2466: p_token5 => 'LEDGER_DISPLAY_CODE',
2467: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2468: p_token6 => 'DS_BALANCE_TYPE_CODE',
2469: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2470: p_token7 => 'BUDGET_DISPLAY_CODE',
2471: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

Line 2469: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,

2465: p_value4 => FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
2466: p_token5 => 'LEDGER_DISPLAY_CODE',
2467: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2468: p_token6 => 'DS_BALANCE_TYPE_CODE',
2469: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2470: p_token7 => 'BUDGET_DISPLAY_CODE',
2471: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2472: p_token8 => 'ENCUMBRANCE_TYPE_CODE',
2473: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);

Line 2471: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

2467: p_value5 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
2468: p_token6 => 'DS_BALANCE_TYPE_CODE',
2469: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2470: p_token7 => 'BUDGET_DISPLAY_CODE',
2471: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2472: p_token8 => 'ENCUMBRANCE_TYPE_CODE',
2473: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);
2474:
2475: IF FEM_GL_POST_PROCESS_PKG.pv_exec_mode IN ('I', 'E') THEN

Line 2473: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);

2469: p_value6 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd,
2470: p_token7 => 'BUDGET_DISPLAY_CODE',
2471: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2472: p_token8 => 'ENCUMBRANCE_TYPE_CODE',
2473: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);
2474:
2475: IF FEM_GL_POST_PROCESS_PKG.pv_exec_mode IN ('I', 'E') THEN
2476:
2477: -- For Incremental and Error Reprocessing modes, no data found to

Line 2475: IF FEM_GL_POST_PROCESS_PKG.pv_exec_mode IN ('I', 'E') THEN

2471: p_value7 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
2472: p_token8 => 'ENCUMBRANCE_TYPE_CODE',
2473: p_value8 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);
2474:
2475: IF FEM_GL_POST_PROCESS_PKG.pv_exec_mode IN ('I', 'E') THEN
2476:
2477: -- For Incremental and Error Reprocessing modes, no data found to
2478: -- load may be a common occurrence and is not treated as an error.
2479:

Line 2480: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging

2476:
2477: -- For Incremental and Error Reprocessing modes, no data found to
2478: -- load may be a common occurrence and is not treated as an error.
2479:
2480: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging
2481: (p_exec_status => 'SUCCESS',
2482: p_num_data_errors => 0,
2483: p_num_data_errors_reproc => 0,
2484: p_num_output_rows => 0,

Line 2495: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging

2491:
2492: -- For Snapshot execution mode, no data found to load is treated
2493: -- as an error.
2494:
2495: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging
2496: (p_exec_status => 'ERROR_RERUN',
2497: p_num_data_errors => 0,
2498: p_num_data_errors_reproc => 0,
2499: p_num_output_rows => 0,

Line 2534: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging

2530:
2531: Log_Data_Error_Help_Msgs;
2532:
2533: -- Perform post-process logging
2534: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging
2535: (p_exec_status => 'ERROR_RERUN',
2536: p_num_data_errors => v_tot_cur_data_err_rows,
2537: p_num_data_errors_reproc => v_tot_prev_err_rows_reproc,
2538: p_num_output_rows => v_tot_posted_rows,

Line 2575: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging

2571: p_token1 => 'ERR_MSG',
2572: p_value1 => SQLERRM);
2573:
2574: -- Perform post-process logging
2575: FEM_GL_POST_PROCESS_PKG.Final_Process_Logging
2576: (p_exec_status => 'ERROR_RERUN',
2577: p_num_data_errors => v_tot_cur_data_err_rows,
2578: p_num_data_errors_reproc => v_tot_prev_err_rows_reproc,
2579: p_num_output_rows => v_tot_posted_rows,

Line 2604: -- Log the values of the FEM_GL_POST_PROCESS_PKG package variables

2600: -- =======================================================================
2601: -- Procedure
2602: -- Log_Pkg_Variables
2603: -- Purpose
2604: -- Log the values of the FEM_GL_POST_PROCESS_PKG package variables
2605: -- which have been reset from the last 16 parameters.
2606: -- History
2607: -- 05-05-04 G Hall Bug# 3597527: Created
2608: -- =======================================================================

Line 2640: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_req_id',

2636: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2637: p_app_name => 'FEM',
2638: p_msg_name => 'FEM_GL_POST_204',
2639: p_token1 => 'VAR_NAME',
2640: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_req_id',
2641: p_token2 => 'VAR_VAL',
2642: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_req_id));
2643:
2644: FEM_ENGINES_PKG.Tech_Message

Line 2642: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_req_id));

2638: p_msg_name => 'FEM_GL_POST_204',
2639: p_token1 => 'VAR_NAME',
2640: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_req_id',
2641: p_token2 => 'VAR_VAL',
2642: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_req_id));
2643:
2644: FEM_ENGINES_PKG.Tech_Message
2645: (p_severity => pc_log_level_statement,
2646: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2650: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_exec_mode',

2646: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2647: p_app_name => 'FEM',
2648: p_msg_name => 'FEM_GL_POST_204',
2649: p_token1 => 'VAR_NAME',
2650: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_exec_mode',
2651: p_token2 => 'VAR_VAL',
2652: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode);
2653:
2654: FEM_ENGINES_PKG.Tech_Message

Line 2652: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode);

2648: p_msg_name => 'FEM_GL_POST_204',
2649: p_token1 => 'VAR_NAME',
2650: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_exec_mode',
2651: p_token2 => 'VAR_VAL',
2652: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_exec_mode);
2653:
2654: FEM_ENGINES_PKG.Tech_Message
2655: (p_severity => pc_log_level_statement,
2656: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2660: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id',

2656: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2657: p_app_name => 'FEM',
2658: p_msg_name => 'FEM_GL_POST_204',
2659: p_token1 => 'VAR_NAME',
2660: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id',
2661: p_token2 => 'VAR_VAL',
2662: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id));
2663:
2664: FEM_ENGINES_PKG.Tech_Message

Line 2662: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id));

2658: p_msg_name => 'FEM_GL_POST_204',
2659: p_token1 => 'VAR_NAME',
2660: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id',
2661: p_token2 => 'VAR_VAL',
2662: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id));
2663:
2664: FEM_ENGINES_PKG.Tech_Message
2665: (p_severity => pc_log_level_statement,
2666: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2670: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_dataset_code',

2666: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2667: p_app_name => 'FEM',
2668: p_msg_name => 'FEM_GL_POST_204',
2669: p_token1 => 'VAR_NAME',
2670: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_dataset_code',
2671: p_token2 => 'VAR_VAL',
2672: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code));
2673:
2674: FEM_ENGINES_PKG.Tech_Message

Line 2672: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code));

2668: p_msg_name => 'FEM_GL_POST_204',
2669: p_token1 => 'VAR_NAME',
2670: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_dataset_code',
2671: p_token2 => 'VAR_VAL',
2672: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_dataset_code));
2673:
2674: FEM_ENGINES_PKG.Tech_Message
2675: (p_severity => pc_log_level_statement,
2676: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2680: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_period_id',

2676: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2677: p_app_name => 'FEM',
2678: p_msg_name => 'FEM_GL_POST_204',
2679: p_token1 => 'VAR_NAME',
2680: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_period_id',
2681: p_token2 => 'VAR_VAL',
2682: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id));
2683:
2684: FEM_ENGINES_PKG.Tech_Message

Line 2682: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id));

2678: p_msg_name => 'FEM_GL_POST_204',
2679: p_token1 => 'VAR_NAME',
2680: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_period_id',
2681: p_token2 => 'VAR_VAL',
2682: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_period_id));
2683:
2684: FEM_ENGINES_PKG.Tech_Message
2685: (p_severity => pc_log_level_statement,
2686: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2690: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ledger_id',

2686: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2687: p_app_name => 'FEM',
2688: p_msg_name => 'FEM_GL_POST_204',
2689: p_token1 => 'VAR_NAME',
2690: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ledger_id',
2691: p_token2 => 'VAR_VAL',
2692: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id));
2693:
2694: FEM_ENGINES_PKG.Tech_Message

Line 2692: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id));

2688: p_msg_name => 'FEM_GL_POST_204',
2689: p_token1 => 'VAR_NAME',
2690: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ledger_id',
2691: p_token2 => 'VAR_VAL',
2692: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_ledger_id));
2693:
2694: FEM_ENGINES_PKG.Tech_Message
2695: (p_severity => pc_log_level_statement,
2696: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2700: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code',

2696: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2697: p_app_name => 'FEM',
2698: p_msg_name => 'FEM_GL_POST_204',
2699: p_token1 => 'VAR_NAME',
2700: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code',
2701: p_token2 => 'VAR_VAL',
2702: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code);
2703:
2704: FEM_ENGINES_PKG.Tech_Message

Line 2702: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code);

2698: p_msg_name => 'FEM_GL_POST_204',
2699: p_token1 => 'VAR_NAME',
2700: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code',
2701: p_token2 => 'VAR_VAL',
2702: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code);
2703:
2704: FEM_ENGINES_PKG.Tech_Message
2705: (p_severity => pc_log_level_statement,
2706: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2710: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag',

2706: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2707: p_app_name => 'FEM',
2708: p_msg_name => 'FEM_GL_POST_204',
2709: p_token1 => 'VAR_NAME',
2710: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag',
2711: p_token2 => 'VAR_VAL',
2712: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag);
2713:
2714: FEM_ENGINES_PKG.Tech_Message

Line 2712: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag);

2708: p_msg_name => 'FEM_GL_POST_204',
2709: p_token1 => 'VAR_NAME',
2710: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag',
2711: p_token2 => 'VAR_VAL',
2712: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag);
2713:
2714: FEM_ENGINES_PKG.Tech_Message
2715: (p_severity => pc_log_level_statement,
2716: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2720: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd',

2716: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2717: p_app_name => 'FEM',
2718: p_msg_name => 'FEM_GL_POST_204',
2719: p_token1 => 'VAR_NAME',
2720: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd',
2721: p_token2 => 'VAR_VAL',
2722: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd);
2723:
2724: FEM_ENGINES_PKG.Tech_Message

Line 2722: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd);

2718: p_msg_name => 'FEM_GL_POST_204',
2719: p_token1 => 'VAR_NAME',
2720: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd',
2721: p_token2 => 'VAR_VAL',
2722: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd);
2723:
2724: FEM_ENGINES_PKG.Tech_Message
2725: (p_severity => pc_log_level_statement,
2726: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2730: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date',

2726: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2727: p_app_name => 'FEM',
2728: p_msg_name => 'FEM_GL_POST_204',
2729: p_token1 => 'VAR_NAME',
2730: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date',
2731: p_token2 => 'VAR_VAL',
2732: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2733: 'YYYY/MM/DD HH24:MI:SS'));
2734:

Line 2732: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,

2728: p_msg_name => 'FEM_GL_POST_204',
2729: p_token1 => 'VAR_NAME',
2730: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date',
2731: p_token2 => 'VAR_VAL',
2732: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date,
2733: 'YYYY/MM/DD HH24:MI:SS'));
2734:
2735: FEM_ENGINES_PKG.Tech_Message
2736: (p_severity => pc_log_level_statement,

Line 2741: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_gl_per_number',

2737: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2738: p_app_name => 'FEM',
2739: p_msg_name => 'FEM_GL_POST_204',
2740: p_token1 => 'VAR_NAME',
2741: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_gl_per_number',
2742: p_token2 => 'VAR_VAL',
2743: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number));
2744:
2745: FEM_ENGINES_PKG.Tech_Message

Line 2743: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number));

2739: p_msg_name => 'FEM_GL_POST_204',
2740: p_token1 => 'VAR_NAME',
2741: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_gl_per_number',
2742: p_token2 => 'VAR_VAL',
2743: p_value2 => TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_gl_per_number));
2744:
2745: FEM_ENGINES_PKG.Tech_Message
2746: (p_severity => pc_log_level_statement,
2747: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2751: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd',

2747: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2748: p_app_name => 'FEM',
2749: p_msg_name => 'FEM_GL_POST_204',
2750: p_token1 => 'VAR_NAME',
2751: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd',
2752: p_token2 => 'VAR_VAL',
2753: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd);
2754:
2755: FEM_ENGINES_PKG.Tech_Message

Line 2753: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd);

2749: p_msg_name => 'FEM_GL_POST_204',
2750: p_token1 => 'VAR_NAME',
2751: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd',
2752: p_token2 => 'VAR_VAL',
2753: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd);
2754:
2755: FEM_ENGINES_PKG.Tech_Message
2756: (p_severity => pc_log_level_statement,
2757: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2761: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd',

2757: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2758: p_app_name => 'FEM',
2759: p_msg_name => 'FEM_GL_POST_204',
2760: p_token1 => 'VAR_NAME',
2761: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd',
2762: p_token2 => 'VAR_VAL',
2763: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd);
2764:
2765: FEM_ENGINES_PKG.Tech_Message

Line 2763: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd);

2759: p_msg_name => 'FEM_GL_POST_204',
2760: p_token1 => 'VAR_NAME',
2761: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd',
2762: p_token2 => 'VAR_VAL',
2763: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd);
2764:
2765: FEM_ENGINES_PKG.Tech_Message
2766: (p_severity => pc_log_level_statement,
2767: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2771: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd',

2767: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2768: p_app_name => 'FEM',
2769: p_msg_name => 'FEM_GL_POST_204',
2770: p_token1 => 'VAR_NAME',
2771: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd',
2772: p_token2 => 'VAR_VAL',
2773: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);
2774:
2775: FEM_ENGINES_PKG.Tech_Message

Line 2773: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);

2769: p_msg_name => 'FEM_GL_POST_204',
2770: p_token1 => 'VAR_NAME',
2771: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd',
2772: p_token2 => 'VAR_VAL',
2773: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd);
2774:
2775: FEM_ENGINES_PKG.Tech_Message
2776: (p_severity => pc_log_level_statement,
2777: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2781: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd',

2777: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2778: p_app_name => 'FEM',
2779: p_msg_name => 'FEM_GL_POST_204',
2780: p_token1 => 'VAR_NAME',
2781: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd',
2782: p_token2 => 'VAR_VAL',
2783: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd);
2784:
2785: FEM_ENGINES_PKG.Tech_Message

Line 2783: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd);

2779: p_msg_name => 'FEM_GL_POST_204',
2780: p_token1 => 'VAR_NAME',
2781: p_value1 => 'FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd',
2782: p_token2 => 'VAR_VAL',
2783: p_value2 => FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd);
2784:
2785: FEM_ENGINES_PKG.Tech_Message
2786: (p_severity => pc_log_level_statement,
2787: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,

Line 2852: -- Corresponding FEM_GL_POST_PROCESS_PKG

2848: -- XGL engine.
2849: -- The following parameters are the ones passed to the MP Master procedure
2850: -- as P_ARG1 to P_ARG16. The concurrent subrequests pass these parameters
2851: -- positionally to Process_Data_Slice.
2852: -- Corresponding FEM_GL_POST_PROCESS_PKG
2853: -- Package Variable:
2854: -- p_req_id pv_req_id
2855: -- p_exec_mode pv_exec_mode
2856: -- p_rule_obj_id pv_rule_obj_id

Line 2924: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := NULL;

2920: FEMXGL_fatal_err EXCEPTION;
2921:
2922: BEGIN
2923:
2924: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := NULL;
2925:
2926: pv_process_slice := '{p' || TO_CHAR(p_process_number) || ':s' ||
2927: TO_CHAR(p_slice_id) || '}';
2928:

Line 2966: -- Reset the FEM_GL_POST_PROCESS_PKG package variables from the last

2962: v_tot_posted_rows := 0;
2963:
2964: IF NOT pv_pkg_variables_reset THEN
2965:
2966: -- Reset the FEM_GL_POST_PROCESS_PKG package variables from the last
2967: -- 16 parameters to Process_Data_Slice, for use by this procedure and/
2968: -- or the procedures it calls, and populate the processing key info
2969: -- structure. The values will be available for the duration of the
2970: -- calling subrequst's session, i.e. for subsequent invocations of

Line 2979: FEM_GL_POST_PROCESS_PKG.pv_req_id :=

2975: p_module => 'fem.plsql.xgl_eng.lpv.' || pv_process_slice,
2976: p_msg_text => 'First data slice for subrequest; ' ||
2977: 'resetting package variables from input parameters.');
2978:
2979: FEM_GL_POST_PROCESS_PKG.pv_req_id :=
2980: TO_NUMBER(p_req_id);
2981: FEM_GL_POST_PROCESS_PKG.pv_exec_mode :=
2982: p_exec_mode;
2983: FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id :=

Line 2981: FEM_GL_POST_PROCESS_PKG.pv_exec_mode :=

2977: 'resetting package variables from input parameters.');
2978:
2979: FEM_GL_POST_PROCESS_PKG.pv_req_id :=
2980: TO_NUMBER(p_req_id);
2981: FEM_GL_POST_PROCESS_PKG.pv_exec_mode :=
2982: p_exec_mode;
2983: FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id :=
2984: TO_NUMBER(p_rule_obj_id);
2985: FEM_GL_POST_PROCESS_PKG.pv_dataset_code :=

Line 2983: FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id :=

2979: FEM_GL_POST_PROCESS_PKG.pv_req_id :=
2980: TO_NUMBER(p_req_id);
2981: FEM_GL_POST_PROCESS_PKG.pv_exec_mode :=
2982: p_exec_mode;
2983: FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id :=
2984: TO_NUMBER(p_rule_obj_id);
2985: FEM_GL_POST_PROCESS_PKG.pv_dataset_code :=
2986: TO_NUMBER(p_dataset_code);
2987: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id :=

Line 2985: FEM_GL_POST_PROCESS_PKG.pv_dataset_code :=

2981: FEM_GL_POST_PROCESS_PKG.pv_exec_mode :=
2982: p_exec_mode;
2983: FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id :=
2984: TO_NUMBER(p_rule_obj_id);
2985: FEM_GL_POST_PROCESS_PKG.pv_dataset_code :=
2986: TO_NUMBER(p_dataset_code);
2987: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id :=
2988: TO_NUMBER(p_cal_period_id);
2989: FEM_GL_POST_PROCESS_PKG.pv_ledger_id :=

Line 2987: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id :=

2983: FEM_GL_POST_PROCESS_PKG.pv_rule_obj_id :=
2984: TO_NUMBER(p_rule_obj_id);
2985: FEM_GL_POST_PROCESS_PKG.pv_dataset_code :=
2986: TO_NUMBER(p_dataset_code);
2987: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id :=
2988: TO_NUMBER(p_cal_period_id);
2989: FEM_GL_POST_PROCESS_PKG.pv_ledger_id :=
2990: TO_NUMBER(p_ledger_id);
2991: FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code :=

Line 2989: FEM_GL_POST_PROCESS_PKG.pv_ledger_id :=

2985: FEM_GL_POST_PROCESS_PKG.pv_dataset_code :=
2986: TO_NUMBER(p_dataset_code);
2987: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id :=
2988: TO_NUMBER(p_cal_period_id);
2989: FEM_GL_POST_PROCESS_PKG.pv_ledger_id :=
2990: TO_NUMBER(p_ledger_id);
2991: FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code :=
2992: p_qtd_ytd_code;
2993: FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag :=

Line 2991: FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code :=

2987: FEM_GL_POST_PROCESS_PKG.pv_cal_period_id :=
2988: TO_NUMBER(p_cal_period_id);
2989: FEM_GL_POST_PROCESS_PKG.pv_ledger_id :=
2990: TO_NUMBER(p_ledger_id);
2991: FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code :=
2992: p_qtd_ytd_code;
2993: FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag :=
2994: p_entered_crncy_flag;
2995: FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd :=

Line 2993: FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag :=

2989: FEM_GL_POST_PROCESS_PKG.pv_ledger_id :=
2990: TO_NUMBER(p_ledger_id);
2991: FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code :=
2992: p_qtd_ytd_code;
2993: FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag :=
2994: p_entered_crncy_flag;
2995: FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd :=
2996: p_cal_per_dim_grp_dsp_cd;
2997: FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date :=

Line 2995: FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd :=

2991: FEM_GL_POST_PROCESS_PKG.pv_qtd_ytd_code :=
2992: p_qtd_ytd_code;
2993: FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag :=
2994: p_entered_crncy_flag;
2995: FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd :=
2996: p_cal_per_dim_grp_dsp_cd;
2997: FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date :=
2998: TO_DATE(p_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS');
2999: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number :=

Line 2997: FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date :=

2993: FEM_GL_POST_PROCESS_PKG.pv_entered_crncy_flag :=
2994: p_entered_crncy_flag;
2995: FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd :=
2996: p_cal_per_dim_grp_dsp_cd;
2997: FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date :=
2998: TO_DATE(p_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS');
2999: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number :=
3000: TO_NUMBER(p_gl_per_number);
3001: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd :=

Line 2999: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number :=

2995: FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd :=
2996: p_cal_per_dim_grp_dsp_cd;
2997: FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date :=
2998: TO_DATE(p_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS');
2999: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number :=
3000: TO_NUMBER(p_gl_per_number);
3001: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd :=
3002: p_ledger_dsp_cd;
3003: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd :=

Line 3001: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd :=

2997: FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date :=
2998: TO_DATE(p_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS');
2999: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number :=
3000: TO_NUMBER(p_gl_per_number);
3001: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd :=
3002: p_ledger_dsp_cd;
3003: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd :=
3004: p_budget_dsp_cd;
3005: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd :=

Line 3003: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd :=

2999: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number :=
3000: TO_NUMBER(p_gl_per_number);
3001: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd :=
3002: p_ledger_dsp_cd;
3003: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd :=
3004: p_budget_dsp_cd;
3005: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd :=
3006: p_enc_type_dsp_cd;
3007: FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd :=

Line 3005: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd :=

3001: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd :=
3002: p_ledger_dsp_cd;
3003: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd :=
3004: p_budget_dsp_cd;
3005: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd :=
3006: p_enc_type_dsp_cd;
3007: FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd :=
3008: p_ds_balance_type_cd;
3009:

Line 3007: FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd :=

3003: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd :=
3004: p_budget_dsp_cd;
3005: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd :=
3006: p_enc_type_dsp_cd;
3007: FEM_GL_POST_PROCESS_PKG.pv_ds_balance_type_cd :=
3008: p_ds_balance_type_cd;
3009:
3010: pv_schema_name := p_schema_name;
3011:

Line 3016: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := NULL;

3012: Log_Pkg_Variables;
3013:
3014: -- Get the Processing Key information
3015:
3016: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := NULL;
3017:
3018: FEM_GL_POST_PROCESS_PKG.Get_Proc_Key_Info
3019: (p_process_slice => pv_process_slice,
3020: x_completion_code => v_compl_code);

Line 3018: FEM_GL_POST_PROCESS_PKG.Get_Proc_Key_Info

3014: -- Get the Processing Key information
3015:
3016: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := NULL;
3017:
3018: FEM_GL_POST_PROCESS_PKG.Get_Proc_Key_Info
3019: (p_process_slice => pv_process_slice,
3020: x_completion_code => v_compl_code);
3021:
3022: IF v_compl_code = 2 THEN

Line 3154: IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S') THEN

3150: -- Now for Incremental or Error Reprocessing loads, start
3151: -- posting records one load set at a time
3152: -- ---------------------------------------------------------
3153:
3154: IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S') THEN
3155:
3156: -- -------------------------------------------------------------------
3157: -- Open the appropriate cursor based on execution mode to get load
3158: -- sets for processing.

Line 3176: IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'I') THEN

3172: -- -------------------------------------------------------------------
3173:
3174: -- IF (NOT GetLoadSet_Cursor%ISOPEN) THEN Why do we need this?
3175:
3176: IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'I') THEN
3177:
3178: v_incr_cursor_stmt :=
3179: 'SELECT DISTINCT load_set_id ' ||
3180: 'FROM fem_bal_interface_t ' ||

Line 3204: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,

3200: p_token2 => 'VAR_VAL',
3201: p_value2 => v_incr_cursor_stmt);
3202:
3203: OPEN GetLoadSet_Cursor FOR v_incr_cursor_stmt
3204: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
3205: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3206: 'YYYY/MM/DD HH24:MI:SS'),
3207: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3208: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

Line 3205: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),

3201: p_value2 => v_incr_cursor_stmt);
3202:
3203: OPEN GetLoadSet_Cursor FOR v_incr_cursor_stmt
3204: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
3205: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3206: 'YYYY/MM/DD HH24:MI:SS'),
3207: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3208: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3209: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

Line 3207: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,

3203: OPEN GetLoadSet_Cursor FOR v_incr_cursor_stmt
3204: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
3205: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3206: 'YYYY/MM/DD HH24:MI:SS'),
3207: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3208: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3209: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3210: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3211: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,

Line 3208: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

3204: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
3205: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3206: 'YYYY/MM/DD HH24:MI:SS'),
3207: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3208: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3209: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3210: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3211: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3212: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;

Line 3209: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

3205: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3206: 'YYYY/MM/DD HH24:MI:SS'),
3207: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3208: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3209: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3210: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3211: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3212: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;
3213:

Line 3210: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

3206: 'YYYY/MM/DD HH24:MI:SS'),
3207: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3208: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3209: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3210: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3211: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3212: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;
3213:
3214: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'E') THEN

Line 3211: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,

3207: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3208: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3209: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3210: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3211: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3212: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;
3213:
3214: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'E') THEN
3215:

Line 3212: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;

3208: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3209: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3210: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3211: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3212: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;
3213:
3214: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'E') THEN
3215:
3216: v_err_cursor_stmt :=

Line 3214: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'E') THEN

3210: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3211: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3212: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;
3213:
3214: ELSIF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode = 'E') THEN
3215:
3216: v_err_cursor_stmt :=
3217: 'SELECT DISTINCT load_set_id ' ||
3218: 'FROM fem_bal_interface_t ' ||

Line 3238: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,

3234: pv_process_slice || '.err_crs_stmt',
3235: p_msg_text => 'v_err_cursor_stmt: ' || v_err_cursor_stmt);
3236:
3237: OPEN GetLoadSet_Cursor FOR v_err_cursor_stmt
3238: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
3239: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3240: 'YYYY/MM/DD HH24:MI:SS'),
3241: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3242: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

Line 3239: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),

3235: p_msg_text => 'v_err_cursor_stmt: ' || v_err_cursor_stmt);
3236:
3237: OPEN GetLoadSet_Cursor FOR v_err_cursor_stmt
3238: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
3239: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3240: 'YYYY/MM/DD HH24:MI:SS'),
3241: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3242: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3243: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

Line 3241: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,

3237: OPEN GetLoadSet_Cursor FOR v_err_cursor_stmt
3238: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
3239: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3240: 'YYYY/MM/DD HH24:MI:SS'),
3241: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3242: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3243: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3244: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3245: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,

Line 3242: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,

3238: USING FEM_GL_POST_PROCESS_PKG.pv_cal_per_dim_grp_dsp_cd,
3239: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3240: 'YYYY/MM/DD HH24:MI:SS'),
3241: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3242: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3243: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3244: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3245: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3246: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;

Line 3243: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

3239: TO_DATE(TO_CHAR(FEM_GL_POST_PROCESS_PKG.pv_cal_per_end_date, 'YYYY/MM/DD HH24:MI:SS'),
3240: 'YYYY/MM/DD HH24:MI:SS'),
3241: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3242: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3243: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3244: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3245: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3246: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;
3247: END IF;

Line 3244: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,

3240: 'YYYY/MM/DD HH24:MI:SS'),
3241: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3242: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3243: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3244: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3245: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3246: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;
3247: END IF;
3248:

Line 3245: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,

3241: FEM_GL_POST_PROCESS_PKG.pv_gl_per_number,
3242: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3243: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3244: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3245: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3246: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;
3247: END IF;
3248:
3249: -- END IF; If cursor is open -- why needed?

Line 3246: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;

3242: FEM_GL_POST_PROCESS_PKG.pv_ledger_dsp_cd,
3243: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3244: FEM_GL_POST_PROCESS_PKG.pv_budget_dsp_cd,
3245: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd,
3246: FEM_GL_POST_PROCESS_PKG.pv_enc_type_dsp_cd;
3247: END IF;
3248:
3249: -- END IF; If cursor is open -- why needed?
3250:

Line 3343: END IF; -- IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S')...

3339: END LOOP; -- For Load set looping
3340:
3341: CLOSE GetLoadSet_Cursor;
3342:
3343: END IF; -- IF (FEM_GL_POST_PROCESS_PKG.pv_exec_mode <> 'S')...
3344:
3345: x_slice_errors_reprocessed := v_tot_prev_err_rows_reproc;
3346: x_slice_output_rows := v_tot_posted_rows;
3347: x_slice_errors_reported := v_tot_cur_data_err_rows;

Line 3393: x_slice_msg := FEM_GL_POST_PROCESS_PKG.pv_sqlerrm;

3389:
3390: x_slice_errors_reprocessed := v_tot_prev_err_rows_reproc;
3391: x_slice_output_rows := v_tot_posted_rows;
3392: x_slice_errors_reported := v_tot_cur_data_err_rows;
3393: x_slice_msg := FEM_GL_POST_PROCESS_PKG.pv_sqlerrm;
3394: x_slice_status_cd := 2;
3395:
3396: -- Reset error code for remaing rows not processed which were
3397: -- errors before, so they'll be reprocessed by the next run.

Line 3420: IF FEM_GL_POST_PROCESS_PKG.pv_sqlerrm IS NULL THEN

3416: p_value2 => TO_CHAR(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS'));
3417:
3418: WHEN OTHERS THEN
3419:
3420: IF FEM_GL_POST_PROCESS_PKG.pv_sqlerrm IS NULL THEN
3421: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := SQLERRM;
3422: END IF;
3423:
3424: ROLLBACK;

Line 3421: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := SQLERRM;

3417:
3418: WHEN OTHERS THEN
3419:
3420: IF FEM_GL_POST_PROCESS_PKG.pv_sqlerrm IS NULL THEN
3421: FEM_GL_POST_PROCESS_PKG.pv_sqlerrm := SQLERRM;
3422: END IF;
3423:
3424: ROLLBACK;
3425:

Line 3433: p_msg_text => FEM_GL_POST_PROCESS_PKG.pv_sqlerrm);

3429: FEM_ENGINES_PKG.Tech_Message
3430: (p_severity => pc_log_level_unexpected,
3431: p_module => 'fem.plsql.xgl_eng.pds.' ||
3432: pv_process_slice || '.unexpected_exception',
3433: p_msg_text => FEM_GL_POST_PROCESS_PKG.pv_sqlerrm);
3434:
3435: -- Log the Oracle error message to the Concurrent Request Log.
3436:
3437: FEM_ENGINES_PKG.User_Message

Line 3438: (p_msg_text => FEM_GL_POST_PROCESS_PKG.pv_sqlerrm);

3434:
3435: -- Log the Oracle error message to the Concurrent Request Log.
3436:
3437: FEM_ENGINES_PKG.User_Message
3438: (p_msg_text => FEM_GL_POST_PROCESS_PKG.pv_sqlerrm);
3439:
3440: -- Set the OUT parameters
3441:
3442: x_slice_errors_reprocessed := v_tot_prev_err_rows_reproc;

Line 3445: x_slice_msg := FEM_GL_POST_PROCESS_PKG.pv_sqlerrm;

3441:
3442: x_slice_errors_reprocessed := v_tot_prev_err_rows_reproc;
3443: x_slice_output_rows := v_tot_posted_rows;
3444: x_slice_errors_reported := v_tot_cur_data_err_rows;
3445: x_slice_msg := FEM_GL_POST_PROCESS_PKG.pv_sqlerrm;
3446: x_slice_status_cd := 2;
3447:
3448: -- Reset error code for remaing rows not processed which were
3449: -- errors before, so they'll be reprocessed by the next run.