DBA Data[Home] [Help]

APPS.GME_BATCH_STEP_RESOURCES_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_resources := p_batch_step_resources;

Line 256: IF g_debug <= gme_debug.g_log_unexpected THEN

252: RETURN FALSE;
253: END IF;
254: EXCEPTION
255: WHEN OTHERS THEN
256: IF g_debug <= gme_debug.g_log_unexpected THEN
257: gme_debug.put_line ( 'When others exception in '
258: || g_pkg_name
259: || '.'
260: || l_api_name

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

253: END IF;
254: EXCEPTION
255: WHEN OTHERS THEN
256: IF g_debug <= gme_debug.g_log_unexpected THEN
257: gme_debug.put_line ( 'When others exception in '
258: || g_pkg_name
259: || '.'
260: || l_api_name
261: || ' Error is '

Line 306: IF g_debug <= gme_debug.g_log_procedure THEN

302: RETURN BOOLEAN
303: IS
304: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';
305: BEGIN
306: IF g_debug <= gme_debug.g_log_procedure THEN
307: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
308: || l_api_name);
309: END IF;
310:

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

303: IS
304: l_api_name CONSTANT VARCHAR2 (30) := 'fetch_row';
305: BEGIN
306: IF g_debug <= gme_debug.g_log_procedure THEN
307: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
308: || l_api_name);
309: END IF;
310:
311: IF p_batch_step_resources.batchstep_resource_id IS NOT NULL THEN

Line 656: IF g_debug <= gme_debug.g_log_unexpected THEN

652: ,'TABLE_NAME'
653: ,g_table_name);
654: RETURN FALSE;
655: WHEN OTHERS THEN
656: IF g_debug <= gme_debug.g_log_unexpected THEN
657: gme_debug.put_line ( 'When others exception in '
658: || g_pkg_name
659: || '.'
660: || l_api_name

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

653: ,g_table_name);
654: RETURN FALSE;
655: WHEN OTHERS THEN
656: IF g_debug <= gme_debug.g_log_unexpected THEN
657: gme_debug.put_line ( 'When others exception in '
658: || g_pkg_name
659: || '.'
660: || l_api_name
661: || ' Error is '

Line 708: IF g_debug <= gme_debug.g_log_procedure THEN

704: locked_by_other_user EXCEPTION;
705: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
706: l_api_name CONSTANT VARCHAR2 (30) := 'delete_row';
707: BEGIN
708: IF g_debug <= gme_debug.g_log_procedure THEN
709: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
710: || l_api_name);
711: END IF;
712:

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

705: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
706: l_api_name CONSTANT VARCHAR2 (30) := 'delete_row';
707: BEGIN
708: IF g_debug <= gme_debug.g_log_procedure THEN
709: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
710: || l_api_name);
711: END IF;
712:
713: IF p_batch_step_resources.batchstep_resource_id IS NOT NULL THEN

Line 772: IF g_debug <= gme_debug.g_log_unexpected THEN

768: ,'KEY'
769: ,TO_CHAR (p_batch_step_resources.batchstep_resource_id) );
770: RETURN FALSE;
771: WHEN OTHERS THEN
772: IF g_debug <= gme_debug.g_log_unexpected THEN
773: gme_debug.put_line ( 'When others exception in '
774: || g_pkg_name
775: || '.'
776: || l_api_name

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

769: ,TO_CHAR (p_batch_step_resources.batchstep_resource_id) );
770: RETURN FALSE;
771: WHEN OTHERS THEN
772: IF g_debug <= gme_debug.g_log_unexpected THEN
773: gme_debug.put_line ( 'When others exception in '
774: || g_pkg_name
775: || '.'
776: || l_api_name
777: || ' Error is '

Line 824: IF g_debug <= gme_debug.g_log_procedure THEN

820: locked_by_other_user EXCEPTION;
821: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
822: l_api_name CONSTANT VARCHAR2 (30) := 'update_row';
823: BEGIN
824: IF g_debug <= gme_debug.g_log_procedure THEN
825: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
826: || l_api_name);
827: END IF;
828:

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

821: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
822: l_api_name CONSTANT VARCHAR2 (30) := 'update_row';
823: BEGIN
824: IF g_debug <= gme_debug.g_log_procedure THEN
825: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
826: || l_api_name);
827: END IF;
828:
829: IF p_batch_step_resources.batchstep_resource_id IS NOT NULL THEN

Line 1074: IF g_debug <= gme_debug.g_log_unexpected THEN

1070: ,'KEY'
1071: ,TO_CHAR (p_batch_step_resources.batchstep_resource_id) );
1072: RETURN FALSE;
1073: WHEN OTHERS THEN
1074: IF g_debug <= gme_debug.g_log_unexpected THEN
1075: gme_debug.put_line ( 'When others exception in '
1076: || g_pkg_name
1077: || '.'
1078: || l_api_name

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

1071: ,TO_CHAR (p_batch_step_resources.batchstep_resource_id) );
1072: RETURN FALSE;
1073: WHEN OTHERS THEN
1074: IF g_debug <= gme_debug.g_log_unexpected THEN
1075: gme_debug.put_line ( 'When others exception in '
1076: || g_pkg_name
1077: || '.'
1078: || l_api_name
1079: || ' Error is '

Line 1123: IF g_debug <= gme_debug.g_log_procedure THEN

1119: IS
1120: l_dummy NUMBER;
1121: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';
1122: BEGIN
1123: IF g_debug <= gme_debug.g_log_procedure THEN
1124: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1125: || l_api_name);
1126: END IF;
1127:

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

1120: l_dummy NUMBER;
1121: l_api_name CONSTANT VARCHAR2 (30) := 'lock_row';
1122: BEGIN
1123: IF g_debug <= gme_debug.g_log_procedure THEN
1124: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1125: || l_api_name);
1126: END IF;
1127:
1128: IF p_batch_step_resources.batchstep_resource_id IS NOT NULL THEN

Line 1159: IF g_debug <= gme_debug.g_log_unexpected THEN

1155: ,'KEY'
1156: ,TO_CHAR (p_batch_step_resources.batchstep_resource_id) );
1157: RETURN FALSE;
1158: WHEN OTHERS THEN
1159: IF g_debug <= gme_debug.g_log_unexpected THEN
1160: gme_debug.put_line ( 'When others exception in '
1161: || g_pkg_name
1162: || '.'
1163: || l_api_name

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

1156: ,TO_CHAR (p_batch_step_resources.batchstep_resource_id) );
1157: RETURN FALSE;
1158: WHEN OTHERS THEN
1159: IF g_debug <= gme_debug.g_log_unexpected THEN
1160: gme_debug.put_line ( 'When others exception in '
1161: || g_pkg_name
1162: || '.'
1163: || l_api_name
1164: || ' Error is '