APPS.CZ_RULE_IMPORT dependencies on DBMS_APPLICATION_INFO

Line 2522: DBMS_APPLICATION_INFO.SET_MODULE(CZRI_MODULE_NAME,'');

2518: WHEN NO_DATA_FOUND THEN
2519:
2520: --Set the application module name.
2521:
2522: DBMS_APPLICATION_INFO.SET_MODULE(CZRI_MODULE_NAME,'');
2523: END;
2524:
2525: --Default the parameters.
2526:

Line 2634: DBMS_APPLICATION_INFO.SET_MODULE('','');

2630: IF(v_error_flag = 0)THEN RAISE CZRI_ERR_DATA_INCORRECT; END IF;
2631:
2632: --Reset the application module name.
2633:
2634: DBMS_APPLICATION_INFO.SET_MODULE('','');
2635:
2636: EXCEPTION
2637: WHEN CZRI_ERR_ACTIVE_SESSIONS THEN
2638: x_msg_data := cz_utils.get_text('CZRI_IMP_ACTIVESESSION', 'RUNID', p_run_id);

Line 2642: DBMS_APPLICATION_INFO.SET_MODULE('','');

2638: x_msg_data := cz_utils.get_text('CZRI_IMP_ACTIVESESSION', 'RUNID', p_run_id);
2639: x_msg_count := 1;
2640: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2642: DBMS_APPLICATION_INFO.SET_MODULE('','');
2643: WHEN CZRI_ERR_RUNID_EXISTS THEN
2644: x_msg_data := cz_utils.get_text('CZRI_IMP_RUNID_EXISTS', 'RUNID', p_run_id);
2645: x_msg_count := 1;
2646: report(x_msg_data, p_run_id, 'rule_import', v_debug);

Line 2648: DBMS_APPLICATION_INFO.SET_MODULE('','');

2644: x_msg_data := cz_utils.get_text('CZRI_IMP_RUNID_EXISTS', 'RUNID', p_run_id);
2645: x_msg_count := 1;
2646: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: DBMS_APPLICATION_INFO.SET_MODULE('','');
2649: WHEN CZRI_ERR_RUNID_INCORRECT THEN
2650: x_msg_data := cz_utils.get_text('CZRI_ERR_RUNID_INCORRECT', 'RUNID', p_run_id);
2651: x_msg_count := 1;
2652: report(x_msg_data, p_run_id, 'rule_import', v_debug);

Line 2654: DBMS_APPLICATION_INFO.SET_MODULE('','');

2650: x_msg_data := cz_utils.get_text('CZRI_ERR_RUNID_INCORRECT', 'RUNID', p_run_id);
2651: x_msg_count := 1;
2652: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2654: DBMS_APPLICATION_INFO.SET_MODULE('','');
2655: WHEN CZRI_ERR_DATA_INCORRECT THEN
2656: x_msg_data := cz_utils.get_text('CZRI_ERR_DATA_INCORRECT', 'RUNID', p_run_id);
2657: x_msg_count := 1;
2658: report(x_msg_data, p_run_id, 'rule_import', v_debug);

Line 2660: DBMS_APPLICATION_INFO.SET_MODULE('','');

2656: x_msg_data := cz_utils.get_text('CZRI_ERR_DATA_INCORRECT', 'RUNID', p_run_id);
2657: x_msg_count := 1;
2658: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660: DBMS_APPLICATION_INFO.SET_MODULE('','');
2661: WHEN CZRI_ERR_FATAL_ERROR THEN
2662: --hard errors occurred in underlying procedures, already logged.
2663: DBMS_APPLICATION_INFO.SET_MODULE('','');
2664: WHEN OTHERS THEN

Line 2663: DBMS_APPLICATION_INFO.SET_MODULE('','');

2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660: DBMS_APPLICATION_INFO.SET_MODULE('','');
2661: WHEN CZRI_ERR_FATAL_ERROR THEN
2662: --hard errors occurred in underlying procedures, already logged.
2663: DBMS_APPLICATION_INFO.SET_MODULE('','');
2664: WHEN OTHERS THEN
2665: --unexpected errors occurred in the procedure.
2666: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2667: x_msg_count := 1;

Line 2670: DBMS_APPLICATION_INFO.SET_MODULE('','');

2666: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2667: x_msg_count := 1;
2668: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2670: DBMS_APPLICATION_INFO.SET_MODULE('','');
2671: END;
2672:
2673: -----------------------
2674: --------------procedures for lock, unlock