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_BAL_INTERFACE_T

Line 101: -- This routine will mark all records in FEM_BAL_INTERFACE_T to be

97: -- ======================================================================
98: -- Procedure
99: -- Mark_Rows_For_Process
100: -- Purpose
101: -- This routine will mark all records in FEM_BAL_INTERFACE_T to be
102: -- processed by this posting run based on the execution mode.
103: -- History
104: -- 11-03-03 S Kung Created
105: -- 05-05-04 G Hall Bug# 3597527: Implemented changes for

Line 144: 'UPDATE fem_bal_interface_t ' || pv_partition_clause ||

140:
141: IF (NOT pv_snapshot_rows_done) OR (NOT pv_incr_marking_sql_done) THEN
142:
143: pv_marking_sql :=
144: 'UPDATE fem_bal_interface_t ' || pv_partition_clause ||
145: ' SET posting_request_id = :req_id_slice, ' ||
146: 'previous_error_flag = ' ||
147: 'DECODE(posting_error_code, NULL, NULL, ''Y''), ' ||
148: 'posting_error_code = NULL ';

Line 239: p_value2 => 'FEM_BAL_INTERFACE_T');

235: p_msg_name => 'FEM_GL_POST_217',
236: p_token1 => 'NUM',
237: p_value1 => TO_CHAR(x_row_count_in_set),
238: p_token2 => 'TABLE',
239: p_value2 => 'FEM_BAL_INTERFACE_T');
240:
241: FEM_ENGINES_PKG.Tech_Message
242: (p_severity => pc_log_level_procedure,
243: p_module => 'fem.plsql.xgl_eng.mrfp.' || pv_process_slice,

Line 368: ' UPDATE fem_bal_interface_t ' ||

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'' ' ||
370: ' WHERE EXISTS ( SELECT 1 ' ||
371: ' FROM fem_bal_interface_t ' ||
372: ' WHERE posting_request_id = :pv_req_id_slice '||

Line 371: ' FROM fem_bal_interface_t ' ||

367: v_sql_stmt :=
368: ' UPDATE fem_bal_interface_t ' ||
369: ' SET posting_error_code = ''FEM_GL_POST_MIX_LOAD_METHOD'' ' ||
370: ' WHERE EXISTS ( SELECT 1 ' ||
371: ' FROM fem_bal_interface_t ' ||
372: ' WHERE posting_request_id = :pv_req_id_slice '||
373: ' AND load_set_id = :p_load_set_id ' ||
374: ' HAVING COUNT (DISTINCT load_method_code) > 1 ) ' ||
375: ' AND posting_request_id = :pv_req_id_slice ' ||

Line 468: ' UPDATE fem_bal_interface_t ' ||

464: ---------------------------------------------------------------------------
465: IF v_proc_snapshot_rows = 'Y' THEN
466:
467: v_sql_stmt :=
468: ' UPDATE fem_bal_interface_t ' ||
469: ' SET posting_error_code = ''FEM_GL_POST_DUP_PROC_KEYS'' ' ||
470: ' WHERE ( ' || v_key_stmt2 || ') IN' ||
471: ' ( SELECT ' || v_key_stmt2 ||
472: ' FROM fem_bal_interface_t ' ||

Line 472: ' FROM fem_bal_interface_t ' ||

468: ' UPDATE fem_bal_interface_t ' ||
469: ' SET posting_error_code = ''FEM_GL_POST_DUP_PROC_KEYS'' ' ||
470: ' WHERE ( ' || v_key_stmt2 || ') IN' ||
471: ' ( SELECT ' || v_key_stmt2 ||
472: ' FROM fem_bal_interface_t ' ||
473: ' WHERE posting_request_id = :pv_req_id_slice ' ||
474: ' GROUP BY ' || v_key_stmt2 ||
475: ' HAVING COUNT(*) > 1) ' ||
476: ' AND posting_error_code IS NULL ' ||

Line 502: ' UPDATE fem_bal_interface_t ' ||

498: -- Valid values for BAL_POST_TYPE_CODE are R and A,
499: -- valid values for CURRENCY_TYPE_CODE are ENTERED and TRANSLATED
500: ---------------------------------------------------------------------------
501: v_sql_stmt :=
502: ' UPDATE fem_bal_interface_t ' ||
503: ' SET posting_error_code = ' ||
504: ' DECODE(currency_type_code, ' ||
505: ' ''ENTERED'', ' ||
506: ' DECODE(bal_post_type_code, ''A'', NULL, ' ||

Line 539: ' UPDATE fem_bal_interface_t ' ||

535: -- Also, check for missing _E data if pv_entered_crncy_flag is set to
536: -- Y.
537: ---------------------------------------------------------------------------
538: v_sql_stmt :=
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

Line 611: ' UPDATE fem_bal_interface_t u' ||

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' ||
614: ' ( SELECT ' || v_key_stmt3 ||
615: ' FROM fem_bal_interface_t s' ||

Line 615: ' FROM fem_bal_interface_t s' ||

611: ' UPDATE fem_bal_interface_t u' ||
612: ' SET posting_error_code = ''FEM_GL_POST_PREV_SET_ERROR'' ' ||
613: ' WHERE ( ' || v_key_stmt2 || ') IN' ||
614: ' ( SELECT ' || v_key_stmt3 ||
615: ' FROM fem_bal_interface_t s' ||
616: ' WHERE s.posting_error_code IS NOT NULL ' ||
617: ' AND s.posting_request_id = :pv_req_id_slice ' ||
618: ' AND s.load_set_id < :p_load_set_id ) ' ||
619: ' AND u.posting_error_code IS NULL ' ||

Line 881: FROM fem_bal_interface_t

877: ytd_debit_balance_e,
878: ytd_credit_balance_e,
879: previous_error_flag,
880: 'N'
881: FROM fem_bal_interface_t
882: WHERE (v_proc_snapshot_rows = 'Y' OR load_set_id = p_load_set_id)
883: AND posting_request_id = pv_req_id_slice
884: AND posting_error_code is NULL;
885:

Line 930: v_tab_list := 'FROM fem_bal_interface_t i, ';

926: -- so re-initialize all buffers
927: v_sql_stmt := 'UPDATE fem_bal_post_interim_gt g SET ';
928: v_upd_cols := '(';
929: v_sel_stmt := '(SELECT ';
930: v_tab_list := 'FROM fem_bal_interface_t i, ';
931: v_join_stmt := 'WHERE i.rowid = g.interface_rowid ';
932:
933: END IF;
934:

Line 1178: -- Update corresponding error code column in FEM_BAL_INTERFACE_T

1174: p_msg_text => 'Invalid records are found in the snapshot pass');
1175:
1176: END IF;
1177:
1178: -- Update corresponding error code column in FEM_BAL_INTERFACE_T
1179: -- based on FEM_BAL_POST_INTERIM_GT
1180:
1181: FEM_ENGINES_PKG.Tech_Message
1182: (p_severity => pc_log_level_event,

Line 1186: UPDATE fem_bal_interface_t

1182: (p_severity => pc_log_level_event,
1183: p_module => 'fem.plsql.xgl_eng.pti.' || pv_process_slice,
1184: p_msg_text => 'Updating interface table with error codes...');
1185:
1186: UPDATE fem_bal_interface_t
1187: SET posting_error_code = 'FEM_GL_POST_INVALID_DIM_MEMBER'
1188: WHERE rowid IN
1189: (SELECT interface_rowid
1190: FROM fem_bal_post_interim_gt

Line 1201: p_value2 => 'FEM_BAL_INTERFACE_T');

1197: p_msg_name => 'FEM_GL_POST_217',
1198: p_token1 => 'NUM',
1199: p_value1 => TO_CHAR(SQL%ROWCOUNT),
1200: p_token2 => 'TABLE',
1201: p_value2 => 'FEM_BAL_INTERFACE_T');
1202:
1203: COMMIT;
1204:
1205: END IF;

Line 2026: P_DATA_TABLE => 'FEM_BAL_INTERFACE_T',

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,
2029: P_RUN_NAME => 'XGL Integration ' ||
2030: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),

Line 3113: -- FEM_BAL_INTERFACE_T.

3109: v_tot_cur_data_err_rows + v_cur_data_err_rows;
3110:
3111: -- ------------------------------------------------------------
3112: -- Delete successfully posted rows (snapshot) from
3113: -- FEM_BAL_INTERFACE_T.
3114: -- ------------------------------------------------------------
3115:
3116: DELETE FROM fem_bal_interface_t
3117: WHERE posting_request_id = pv_req_id_slice

Line 3116: DELETE FROM fem_bal_interface_t

3112: -- Delete successfully posted rows (snapshot) from
3113: -- FEM_BAL_INTERFACE_T.
3114: -- ------------------------------------------------------------
3115:
3116: DELETE FROM fem_bal_interface_t
3117: WHERE posting_request_id = pv_req_id_slice
3118: AND posting_error_code is NULL
3119: AND load_method_code = 'S';
3120:

Line 3130: p_value2 => 'FEM_BAL_INTERFACE_T');

3126: p_msg_name => 'FEM_GL_POST_218',
3127: p_token1 => 'NUM',
3128: p_value1 => TO_CHAR(SQL%ROWCOUNT),
3129: p_token2 => 'TABLE',
3130: p_value2 => 'FEM_BAL_INTERFACE_T');
3131:
3132: -- ------------------------------------------------------------
3133: -- Truncate FEM_BAL_POST_INTERIM_GT for the next set
3134: -- ------------------------------------------------------------

Line 3180: 'FROM fem_bal_interface_t ' ||

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 ' ||
3181: 'WHERE load_method_code = ''I'' ' ||
3182: 'AND cal_per_dim_grp_display_code = :cal_per_dim_grp_dsp_cd ' ||
3183: 'AND cal_period_end_date = :cal_per_end_date ' ||
3184: 'AND cal_period_number = :cal_gl_per_num ' ||

Line 3218: 'FROM fem_bal_interface_t ' ||

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 ' ||
3219: 'WHERE posting_error_code is NOT NULL ' ||
3220: 'AND load_method_code = ''I'' ' ||
3221: 'AND cal_per_dim_grp_display_code = :cal_per_dim_grp_dsp_cd ' ||
3222: 'AND cal_period_end_date = :cal_per_end_date ' ||

Line 3303: -- FEM_BAL_INTERFACE_T.

3299: v_tot_cur_data_err_rows + v_cur_data_err_rows;
3300:
3301: -- ------------------------------------------------------------
3302: -- Delete successfully posted rows (incremental) from
3303: -- FEM_BAL_INTERFACE_T.
3304: -- ------------------------------------------------------------
3305:
3306: DELETE FROM fem_bal_interface_t
3307: WHERE posting_request_id = pv_req_id_slice

Line 3306: DELETE FROM fem_bal_interface_t

3302: -- Delete successfully posted rows (incremental) from
3303: -- FEM_BAL_INTERFACE_T.
3304: -- ------------------------------------------------------------
3305:
3306: DELETE FROM fem_bal_interface_t
3307: WHERE posting_request_id = pv_req_id_slice
3308: AND posting_error_code is NULL
3309: AND load_method_code = 'I'
3310: AND load_set_id = v_curr_load_set_id;

Line 3321: p_value2 => 'FEM_BAL_INTERFACE_T');

3317: p_msg_name => 'FEM_GL_POST_218',
3318: p_token1 => 'NUM',
3319: p_value1 => TO_CHAR(SQL%ROWCOUNT),
3320: p_token2 => 'TABLE',
3321: p_value2 => 'FEM_BAL_INTERFACE_T');
3322:
3323: -- ------------------------------------------------------------
3324: -- Truncate FEM_BAL_POST_INTERIM_GT for the next set
3325: -- ------------------------------------------------------------

Line 3399: UPDATE fem_bal_interface_t

3395:
3396: -- Reset error code for remaing rows not processed which were
3397: -- errors before, so they'll be reprocessed by the next run.
3398:
3399: UPDATE fem_bal_interface_t
3400: SET posting_error_code = 'FEM_GL_POST_TO_BE_REPROCESSED'
3401: WHERE posting_request_id = pv_req_id_slice
3402: AND posting_error_code is NULL
3403: AND previous_error_flag = 'Y';

Line 3451: UPDATE fem_bal_interface_t

3447:
3448: -- Reset error code for remaing rows not processed which were
3449: -- errors before, so they'll be reprocessed by the next run.
3450:
3451: UPDATE fem_bal_interface_t
3452: SET posting_error_code = 'FEM_GL_POST_TO_BE_REPROCESSED'
3453: WHERE posting_request_id = pv_req_id_slice
3454: AND posting_error_code is NULL
3455: AND previous_error_flag = 'Y';