DBA Data[Home] [Help]

APPS.GME_BATCH_STEPS_DBL dependencies on GME_DEBUG

Line 83: IF g_debug <= gme_debug.g_log_procedure THEN

79: RETURN BOOLEAN
80: IS
81: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
82: BEGIN
83: IF g_debug <= gme_debug.g_log_procedure THEN
84: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
85: || l_api_name);
86: END IF;
87:

Line 84: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

80: IS
81: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
82: BEGIN
83: IF g_debug <= gme_debug.g_log_procedure THEN
84: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
85: || l_api_name);
86: END IF;
87:
88: x_batch_step := p_batch_step;

Line 190: IF g_debug <= gme_debug.g_log_procedure THEN

186: ,x_batch_step.volume_ref_um)
187: RETURNING batchstep_id
188: INTO x_batch_step.batchstep_id;
189:
190: IF g_debug <= gme_debug.g_log_procedure THEN
191: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
192: END IF;
193:
194: IF SQL%FOUND THEN

Line 191: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

187: RETURNING batchstep_id
188: INTO x_batch_step.batchstep_id;
189:
190: IF g_debug <= gme_debug.g_log_procedure THEN
191: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
192: END IF;
193:
194: IF SQL%FOUND THEN
195: RETURN TRUE;

Line 247: IF g_debug <= gme_debug.g_log_procedure THEN

243: RETURN BOOLEAN
244: IS
245: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';
246: BEGIN
247: IF g_debug <= gme_debug.g_log_procedure THEN
248: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
249: || l_api_name);
250: END IF;
251:

Line 248: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

244: IS
245: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';
246: BEGIN
247: IF g_debug <= gme_debug.g_log_procedure THEN
248: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
249: || l_api_name);
250: END IF;
251:
252: IF p_batch_step.batchstep_id IS NOT NULL THEN

Line 447: IF g_debug <= gme_debug.g_log_procedure THEN

443: ,g_table_name);
444: RETURN FALSE;
445: END IF;
446:
447: IF g_debug <= gme_debug.g_log_procedure THEN
448: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
449: END IF;
450:
451: RETURN TRUE;

Line 448: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

444: RETURN FALSE;
445: END IF;
446:
447: IF g_debug <= gme_debug.g_log_procedure THEN
448: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
449: END IF;
450:
451: RETURN TRUE;
452: EXCEPTION

Line 503: IF g_debug <= gme_debug.g_log_procedure THEN

499: locked_by_other_user EXCEPTION;
500: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
501: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_ROW';
502: BEGIN
503: IF g_debug <= gme_debug.g_log_procedure THEN
504: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
505: || l_api_name);
506: END IF;
507:

Line 504: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

500: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
501: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_ROW';
502: BEGIN
503: IF g_debug <= gme_debug.g_log_procedure THEN
504: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
505: || l_api_name);
506: END IF;
507:
508: IF p_batch_step.batchstep_id IS NOT NULL THEN

Line 562: IF g_debug <= gme_debug.g_log_unexpected THEN

558: ,'KEY'
559: ,TO_CHAR (p_batch_step.batchstep_no) );
560: RETURN FALSE;
561: WHEN OTHERS THEN
562: IF g_debug <= gme_debug.g_log_unexpected THEN
563: gme_debug.put_line ( 'When others exception in '
564: || g_pkg_name
565: || '.'
566: || l_api_name

Line 563: gme_debug.put_line ( 'When others exception in '

559: ,TO_CHAR (p_batch_step.batchstep_no) );
560: RETURN FALSE;
561: WHEN OTHERS THEN
562: IF g_debug <= gme_debug.g_log_unexpected THEN
563: gme_debug.put_line ( 'When others exception in '
564: || g_pkg_name
565: || '.'
566: || l_api_name
567: || ' Error is '

Line 616: IF g_debug <= gme_debug.g_log_procedure THEN

612: locked_by_other_user EXCEPTION;
613: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
614: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ROW';
615: BEGIN
616: IF g_debug <= gme_debug.g_log_procedure THEN
617: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
618: || l_api_name);
619: END IF;
620:

Line 617: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

613: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
614: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ROW';
615: BEGIN
616: IF g_debug <= gme_debug.g_log_procedure THEN
617: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
618: || l_api_name);
619: END IF;
620:
621: IF p_batch_step.batchstep_id IS NOT NULL THEN

Line 816: IF g_debug <= gme_debug.g_log_unexpected THEN

812: ,'KEY'
813: ,TO_CHAR (p_batch_step.batchstep_no) );
814: RETURN FALSE;
815: WHEN OTHERS THEN
816: IF g_debug <= gme_debug.g_log_unexpected THEN
817: gme_debug.put_line ( 'When others exception in '
818: || g_pkg_name
819: || '.'
820: || l_api_name

Line 817: gme_debug.put_line ( 'When others exception in '

813: ,TO_CHAR (p_batch_step.batchstep_no) );
814: RETURN FALSE;
815: WHEN OTHERS THEN
816: IF g_debug <= gme_debug.g_log_unexpected THEN
817: gme_debug.put_line ( 'When others exception in '
818: || g_pkg_name
819: || '.'
820: || l_api_name
821: || ' Error is '

Line 837: IF g_debug <= gme_debug.g_log_procedure THEN

833: IS
834: l_dummy NUMBER;
835: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';
836: BEGIN
837: IF g_debug <= gme_debug.g_log_procedure THEN
838: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
839: || l_api_name);
840: END IF;
841:

Line 838: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

834: l_dummy NUMBER;
835: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';
836: BEGIN
837: IF g_debug <= gme_debug.g_log_procedure THEN
838: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
839: || l_api_name);
840: END IF;
841:
842: IF p_batch_step.batchstep_id IS NOT NULL THEN

Line 862: IF g_debug <= gme_debug.g_log_unexpected THEN

858: ,'KEY'
859: ,TO_CHAR (p_batch_step.batchstep_no) );
860: RETURN FALSE;
861: WHEN OTHERS THEN
862: IF g_debug <= gme_debug.g_log_unexpected THEN
863: gme_debug.put_line ( 'When others exception in '
864: || g_pkg_name
865: || '.'
866: || l_api_name

Line 863: gme_debug.put_line ( 'When others exception in '

859: ,TO_CHAR (p_batch_step.batchstep_no) );
860: RETURN FALSE;
861: WHEN OTHERS THEN
862: IF g_debug <= gme_debug.g_log_unexpected THEN
863: gme_debug.put_line ( 'When others exception in '
864: || g_pkg_name
865: || '.'
866: || l_api_name
867: || ' Error is '