APPS.GME_CANCEL_STEP_PVT dependencies on GME_DEBUG

Line 63: IF (g_debug <= gme_debug.g_log_procedure) THEN

59: BEGIN
60: /* Set the save point before processing */
61: SAVEPOINT cancel_batch_step;
62:
63: IF (g_debug <= gme_debug.g_log_procedure) THEN
64: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
65: || 'Entering');
66: END IF;
67:

Line 64: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

60: /* Set the save point before processing */
61: SAVEPOINT cancel_batch_step;
62:
63: IF (g_debug <= gme_debug.g_log_procedure) THEN
64: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
65: || 'Entering');
66: END IF;
67:
68: -- Set the return status to success initially

Line 94: IF (g_debug <= gme_debug.g_log_procedure) THEN

90: -- Delete the resource transactions
91: FOR j IN 1 .. l_resource_txns_tab.COUNT LOOP
92: l_resource_txns_tab (j).action_code := 'DEL';
93:
94: IF (g_debug <= gme_debug.g_log_procedure) THEN
95: gme_debug.put_line ( g_pkg_name
96: || '.'
97: || l_api_name
98: || ':'

Line 95: gme_debug.put_line ( g_pkg_name

91: FOR j IN 1 .. l_resource_txns_tab.COUNT LOOP
92: l_resource_txns_tab (j).action_code := 'DEL';
93:
94: IF (g_debug <= gme_debug.g_log_procedure) THEN
95: gme_debug.put_line ( g_pkg_name
96: || '.'
97: || l_api_name
98: || ':'
99: || ' Calling resource delete_row');

Line 114: IF (g_debug <= gme_debug.g_log_procedure) THEN

110:
111: -- Update the Batch Step Status to Cancel
112: x_batch_step_rec.step_status := 5;
113:
114: IF (g_debug <= gme_debug.g_log_procedure) THEN
115: gme_debug.put_line ( g_pkg_name
116: || '.'
117: || l_api_name
118: || ':'

Line 115: gme_debug.put_line ( g_pkg_name

111: -- Update the Batch Step Status to Cancel
112: x_batch_step_rec.step_status := 5;
113:
114: IF (g_debug <= gme_debug.g_log_procedure) THEN
115: gme_debug.put_line ( g_pkg_name
116: || '.'
117: || l_api_name
118: || ':'
119: || ' Calling step update_row');

Line 126: IF (g_debug <= gme_debug.g_log_procedure) THEN

122: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step => x_batch_step_rec) ) THEN
123: RAISE batch_step_upd_err;
124: END IF;
125:
126: IF (g_debug <= gme_debug.g_log_procedure) THEN
127: gme_debug.put_line ('Exiting ' || g_pkg_name || '.' || l_api_name);
128: END IF;
129: EXCEPTION
130: WHEN resource_txns_gtmp_del_err THEN

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

123: RAISE batch_step_upd_err;
124: END IF;
125:
126: IF (g_debug <= gme_debug.g_log_procedure) THEN
127: gme_debug.put_line ('Exiting ' || g_pkg_name || '.' || l_api_name);
128: END IF;
129: EXCEPTION
130: WHEN resource_txns_gtmp_del_err THEN
131: IF (g_debug <= gme_debug.g_log_procedure) THEN

Line 131: IF (g_debug <= gme_debug.g_log_procedure) THEN

127: gme_debug.put_line ('Exiting ' || g_pkg_name || '.' || l_api_name);
128: END IF;
129: EXCEPTION
130: WHEN resource_txns_gtmp_del_err THEN
131: IF (g_debug <= gme_debug.g_log_procedure) THEN
132: gme_debug.put_line
133: ( g_pkg_name
134: || '.'
135: || l_api_name

Line 132: gme_debug.put_line

128: END IF;
129: EXCEPTION
130: WHEN resource_txns_gtmp_del_err THEN
131: IF (g_debug <= gme_debug.g_log_procedure) THEN
132: gme_debug.put_line
133: ( g_pkg_name
134: || '.'
135: || l_api_name
136: || ':'

Line 142: IF (g_debug <= gme_debug.g_log_procedure) THEN

138: END IF;
139:
140: ROLLBACK TO SAVEPOINT cancel_batch_step;
141: WHEN batch_step_upd_err THEN
142: IF (g_debug <= gme_debug.g_log_procedure) THEN
143: gme_debug.put_line ( g_pkg_name
144: || '.'
145: || l_api_name
146: || ':'

Line 143: gme_debug.put_line ( g_pkg_name

139:
140: ROLLBACK TO SAVEPOINT cancel_batch_step;
141: WHEN batch_step_upd_err THEN
142: IF (g_debug <= gme_debug.g_log_procedure) THEN
143: gme_debug.put_line ( g_pkg_name
144: || '.'
145: || l_api_name
146: || ':'
147: || ' cancel_step, error : BATCH_STEP_UPD_ERR.');

Line 152: IF g_debug <= gme_debug.g_log_unexpected THEN

148: END IF;
149:
150: ROLLBACK TO SAVEPOINT cancel_batch_step;
151: WHEN OTHERS THEN
152: IF g_debug <= gme_debug.g_log_unexpected THEN
153: gme_debug.put_line ( 'When others exception in '
154: || g_pkg_name
155: || '.'
156: || l_api_name

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

149:
150: ROLLBACK TO SAVEPOINT cancel_batch_step;
151: WHEN OTHERS THEN
152: IF g_debug <= gme_debug.g_log_unexpected THEN
153: gme_debug.put_line ( 'When others exception in '
154: || g_pkg_name
155: || '.'
156: || l_api_name
157: || ' Error is '