[Home] [Help]
1438: fem_engines_pkg.tech_message ( p_severity => g_log_level_2
1439: ,p_module => G_BLOCK||'.'||l_api_name
1440: ,p_msg_text => 'BEGIN');
1441:
1442: --Query the fem_mp_process_ctl_t table to get the number of rows
1443: --processed per request
1444: SELECT NVL(SUM(rows_processed),0), NVL(SUM(rows_rejected),0), NVL(SUM(rows_loaded),0)
1445: INTO x_rows_processed, x_rows_rejected, x_rows_loaded
1446: FROM fem_mp_process_ctl_t t
1442: --Query the fem_mp_process_ctl_t table to get the number of rows
1443: --processed per request
1444: SELECT NVL(SUM(rows_processed),0), NVL(SUM(rows_rejected),0), NVL(SUM(rows_loaded),0)
1445: INTO x_rows_processed, x_rows_rejected, x_rows_loaded
1446: FROM fem_mp_process_ctl_t t
1447: WHERE t.req_id = p_request_id
1448: AND t.process_num > 0;
1449:
1450: IF (x_rows_processed = 0) THEN
1500: ,p_module => G_BLOCK||'.'||l_api_name
1501: ,p_msg_text => 'BEGIN');
1502:
1503: IF (p_exe_status_code = g_exec_status_success) THEN
1504: -- query table fem_mp_process_ctl_t to get the number of rows processed
1505:
1506: Get_Nbr_RowsTable_Request(l_nbr_output_rows,
1507: l_nbr_loaded_rows,
1508: l_nbr_rejected_rows,
1685: l_src_tab_name VARCHAR2(30);
1686: l_aggregation_method NUMBER;
1687:
1688: TYPE v_msg_list_type IS VARRAY(20) OF
1689: fem_mp_process_ctl_t.message%TYPE;
1690: v_msg_list v_msg_list_type;
1691:
1692: e_process_single_rule_error EXCEPTION;
1693: e_register_rule_error EXCEPTION;
2004: v_msg_list := v_msg_list_type();
2005:
2006: SELECT DISTINCT(message)
2007: BULK COLLECT INTO v_msg_list
2008: FROM fem_mp_process_ctl_t
2009: WHERE req_id = p_param_rec.request_id
2010: AND status = 2;
2011:
2012: fem_engines_pkg.tech_message(p_severity => g_log_level_1