DBA Data[Home] [Help]

APPS.GME_BATCH_STEP_ITEMS_DBL dependencies on GME_DEBUG

Line 76: IF g_debug <= gme_debug.g_log_procedure THEN

72: RETURN BOOLEAN
73: IS
74: l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';
75: BEGIN
76: IF g_debug <= gme_debug.g_log_procedure THEN
77: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
78: || l_api_name);
79: END IF;
80:

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

73: IS
74: l_api_name CONSTANT VARCHAR2 (30) := 'insert_row';
75: BEGIN
76: IF g_debug <= gme_debug.g_log_procedure THEN
77: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
78: || l_api_name);
79: END IF;
80:
81: x_batch_step_items := p_batch_step_items;

Line 172: IF g_debug <= gme_debug.g_log_unexpected THEN

168:
169: RETURN TRUE;
170: EXCEPTION
171: WHEN OTHERS THEN
172: IF g_debug <= gme_debug.g_log_unexpected THEN
173: gme_debug.put_line ( 'When others exception in '
174: || g_pkg_name
175: || '.'
176: || l_api_name

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

169: RETURN TRUE;
170: EXCEPTION
171: WHEN OTHERS THEN
172: IF g_debug <= gme_debug.g_log_unexpected THEN
173: gme_debug.put_line ( 'When others exception in '
174: || g_pkg_name
175: || '.'
176: || l_api_name
177: || ' Error is '

Line 226: IF g_debug <= gme_debug.g_log_procedure THEN

222: RETURN BOOLEAN
223: IS
224: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';
225: BEGIN
226: IF g_debug <= gme_debug.g_log_procedure THEN
227: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
228: || l_api_name);
229: END IF;
230:

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

223: IS
224: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';
225: BEGIN
226: IF g_debug <= gme_debug.g_log_procedure THEN
227: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
228: || l_api_name);
229: END IF;
230:
231: IF p_batch_step_items.material_detail_id IS NOT NULL THEN

Line 337: IF g_debug <= gme_debug.g_log_unexpected THEN

333: ,'TABLE_NAME'
334: ,g_table_name);
335: RETURN FALSE;
336: WHEN OTHERS THEN
337: IF g_debug <= gme_debug.g_log_unexpected THEN
338: gme_debug.put_line ( 'When others exception in '
339: || g_pkg_name
340: || '.'
341: || l_api_name

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

334: ,g_table_name);
335: RETURN FALSE;
336: WHEN OTHERS THEN
337: IF g_debug <= gme_debug.g_log_unexpected THEN
338: gme_debug.put_line ( 'When others exception in '
339: || g_pkg_name
340: || '.'
341: || l_api_name
342: || ' Error is '

Line 388: IF g_debug <= gme_debug.g_log_procedure THEN

384: locked_by_other_user EXCEPTION;
385: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
386: l_api_name CONSTANT VARCHAR2 (30) := 'delete_row';
387: BEGIN
388: IF g_debug <= gme_debug.g_log_procedure THEN
389: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
390: || l_api_name);
391: END IF;
392:

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

385: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
386: l_api_name CONSTANT VARCHAR2 (30) := 'delete_row';
387: BEGIN
388: IF g_debug <= gme_debug.g_log_procedure THEN
389: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
390: || l_api_name);
391: END IF;
392:
393: IF p_batch_step_items.material_detail_id IS NOT NULL THEN

Line 449: IF g_debug <= gme_debug.g_log_unexpected THEN

445: ,'KEY'
446: ,TO_CHAR (p_batch_step_items.material_detail_id) );
447: RETURN FALSE;
448: WHEN OTHERS THEN
449: IF g_debug <= gme_debug.g_log_unexpected THEN
450: gme_debug.put_line ( 'When others exception in '
451: || g_pkg_name
452: || '.'
453: || l_api_name

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

446: ,TO_CHAR (p_batch_step_items.material_detail_id) );
447: RETURN FALSE;
448: WHEN OTHERS THEN
449: IF g_debug <= gme_debug.g_log_unexpected THEN
450: gme_debug.put_line ( 'When others exception in '
451: || g_pkg_name
452: || '.'
453: || l_api_name
454: || ' Error is '

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) := 'update_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) := 'update_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_items.material_detail_id IS NOT NULL THEN

Line 605: IF g_debug <= gme_debug.g_log_unexpected THEN

601: ,'KEY'
602: ,TO_CHAR (p_batch_step_items.material_detail_id) );
603: RETURN FALSE;
604: WHEN OTHERS THEN
605: IF g_debug <= gme_debug.g_log_unexpected THEN
606: gme_debug.put_line ( 'When others exception in '
607: || g_pkg_name
608: || '.'
609: || l_api_name

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

602: ,TO_CHAR (p_batch_step_items.material_detail_id) );
603: RETURN FALSE;
604: WHEN OTHERS THEN
605: IF g_debug <= gme_debug.g_log_unexpected THEN
606: gme_debug.put_line ( 'When others exception in '
607: || g_pkg_name
608: || '.'
609: || l_api_name
610: || ' Error is '

Line 653: IF g_debug <= gme_debug.g_log_procedure THEN

649: IS
650: l_dummy NUMBER;
651: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';
652: BEGIN
653: IF g_debug <= gme_debug.g_log_procedure THEN
654: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
655: || l_api_name);
656: END IF;
657:

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

650: l_dummy NUMBER;
651: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';
652: BEGIN
653: IF g_debug <= gme_debug.g_log_procedure THEN
654: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
655: || l_api_name);
656: END IF;
657:
658: IF p_batch_step_items.material_detail_id IS NOT NULL THEN

Line 679: IF g_debug <= gme_debug.g_log_unexpected THEN

675: ,'KEY'
676: ,TO_CHAR (p_batch_step_items.material_detail_id) );
677: RETURN FALSE;
678: WHEN OTHERS THEN
679: IF g_debug <= gme_debug.g_log_unexpected THEN
680: gme_debug.put_line ( 'When others exception in '
681: || g_pkg_name
682: || '.'
683: || l_api_name

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

676: ,TO_CHAR (p_batch_step_items.material_detail_id) );
677: RETURN FALSE;
678: WHEN OTHERS THEN
679: IF g_debug <= gme_debug.g_log_unexpected THEN
680: gme_debug.put_line ( 'When others exception in '
681: || g_pkg_name
682: || '.'
683: || l_api_name
684: || ' Error is '