57: --=============================================
58: -- GLOBAL VARIABLES
59: --=============================================
60:
61: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
62: g_proc_level NUMBER := fnd_log.level_procedure;
63: --g_unexp_level NUMBER := fnd_log.level_unexpected;
64: g_excep_level NUMBER := fnd_log.level_exception;
65:
58: -- GLOBAL VARIABLES
59: --=============================================
60:
61: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
62: g_proc_level NUMBER := fnd_log.level_procedure;
63: --g_unexp_level NUMBER := fnd_log.level_unexpected;
64: g_excep_level NUMBER := fnd_log.level_exception;
65:
66: --========================================================================
59: --=============================================
60:
61: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
62: g_proc_level NUMBER := fnd_log.level_procedure;
63: --g_unexp_level NUMBER := fnd_log.level_unexpected;
64: g_excep_level NUMBER := fnd_log.level_exception;
65:
66: --========================================================================
67: -- PROCEDURE : spr_load_subcontracting_po PUBLIC
60:
61: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
62: g_proc_level NUMBER := fnd_log.level_procedure;
63: --g_unexp_level NUMBER := fnd_log.level_unexpected;
64: g_excep_level NUMBER := fnd_log.level_exception;
65:
66: --========================================================================
67: -- PROCEDURE : spr_load_subcontracting_po PUBLIC
68: -- PARAMETERS: p_ou_id operating unit id
359: AND pt.task_id(+) = sub.task_id;
360:
361:
362: BEGIN
363: -- g_debug_level := fnd_log.g_current_runtime_level;
364:
365: IF (g_proc_level >= g_debug_level)
366: THEN
367: fnd_log.STRING(g_proc_level
363: -- g_debug_level := fnd_log.g_current_runtime_level;
364:
365: IF (g_proc_level >= g_debug_level)
366: THEN
367: fnd_log.STRING(g_proc_level
368: ,g_module_prefix || l_api_name || '.begin'
369: ,NULL);
370: END IF;
371:
622: EXCEPTION
623: WHEN no_data_found THEN
624: IF (g_excep_level >= g_debug_level)
625: THEN
626: fnd_log.STRING(g_excep_level
627: ,g_module_prefix || l_api_name || '.exception'
628: ,'no_data_found');
629: END IF;
630: WHEN OTHERS THEN
632: ROLLBACK;
633:
634: IF (g_excep_level >= g_debug_level)
635: THEN
636: fnd_log.STRING(g_excep_level
637: ,g_module_prefix || l_api_name || '.exception'
638: ,SQLERRM);
639: END IF;
640: