DBA Data[Home] [Help]

APPS.GME_TERMINATE_STEP_PVT dependencies on GME_DEBUG

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

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

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

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

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

154: FOR j IN 1 .. l_resource_txns_tab.COUNT LOOP
155: IF l_resource_txns_tab (j).completed_ind = 0 THEN
156: l_resource_txns_tab (j).action_code := 'DEL';
157:
158: IF (g_debug <= gme_debug.g_log_procedure) THEN
159: gme_debug.put_line
160: ( g_pkg_name
161: || '.'
162: || l_api_name

Line 159: gme_debug.put_line

155: IF l_resource_txns_tab (j).completed_ind = 0 THEN
156: l_resource_txns_tab (j).action_code := 'DEL';
157:
158: IF (g_debug <= gme_debug.g_log_procedure) THEN
159: gme_debug.put_line
160: ( g_pkg_name
161: || '.'
162: || l_api_name
163: || ':'

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

194: IF x_batch_step_rec.actual_volume_qty IS NULL THEN
195: x_batch_step_rec.actual_volume_qty := 0;
196: END IF;
197:
198: IF (g_debug <= gme_debug.g_log_procedure) THEN
199: gme_debug.put_line ( g_pkg_name
200: || '.'
201: || l_api_name
202: || ':'

Line 199: gme_debug.put_line ( g_pkg_name

195: x_batch_step_rec.actual_volume_qty := 0;
196: END IF;
197:
198: IF (g_debug <= gme_debug.g_log_procedure) THEN
199: gme_debug.put_line ( g_pkg_name
200: || '.'
201: || l_api_name
202: || ':'
203: || ' Calling batch step update_row');

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

206: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step => x_batch_step_rec) ) THEN
207: RAISE batch_step_upd_err;
208: END IF;
209:
210: IF (g_debug <= gme_debug.g_log_procedure) THEN
211: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
212: || 'Exiting');
213: END IF;
214: EXCEPTION

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

207: RAISE batch_step_upd_err;
208: END IF;
209:
210: IF (g_debug <= gme_debug.g_log_procedure) THEN
211: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
212: || 'Exiting');
213: END IF;
214: EXCEPTION
215: WHEN resource_txns_gtmp_del_err THEN

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

212: || 'Exiting');
213: END IF;
214: EXCEPTION
215: WHEN resource_txns_gtmp_del_err THEN
216: IF (g_debug <= gme_debug.g_log_procedure) THEN
217: gme_debug.put_line ( g_pkg_name
218: || '.'
219: || l_api_name
220: || ':'

Line 217: gme_debug.put_line ( g_pkg_name

213: END IF;
214: EXCEPTION
215: WHEN resource_txns_gtmp_del_err THEN
216: IF (g_debug <= gme_debug.g_log_procedure) THEN
217: gme_debug.put_line ( g_pkg_name
218: || '.'
219: || l_api_name
220: || ':'
221: || 'RESOURCE_TXNS_GTMP_DEL_ERR.');

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

223:
224: ROLLBACK TO SAVEPOINT terminate_batch_step;
225: x_return_status := fnd_api.g_ret_sts_error;
226: WHEN resource_upd_err THEN
227: IF (g_debug <= gme_debug.g_log_procedure) THEN
228: gme_debug.put_line ( g_pkg_name
229: || '.'
230: || l_api_name
231: || ':'

Line 228: gme_debug.put_line ( g_pkg_name

224: ROLLBACK TO SAVEPOINT terminate_batch_step;
225: x_return_status := fnd_api.g_ret_sts_error;
226: WHEN resource_upd_err THEN
227: IF (g_debug <= gme_debug.g_log_procedure) THEN
228: gme_debug.put_line ( g_pkg_name
229: || '.'
230: || l_api_name
231: || ':'
232: || 'RESOURCE_UPD_ERR.');

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

234:
235: ROLLBACK TO SAVEPOINT terminate_batch_step;
236: x_return_status := fnd_api.g_ret_sts_error;
237: WHEN activity_upd_err THEN
238: IF (g_debug <= gme_debug.g_log_procedure) THEN
239: gme_debug.put_line ( g_pkg_name
240: || '.'
241: || l_api_name
242: || ':'

Line 239: gme_debug.put_line ( g_pkg_name

235: ROLLBACK TO SAVEPOINT terminate_batch_step;
236: x_return_status := fnd_api.g_ret_sts_error;
237: WHEN activity_upd_err THEN
238: IF (g_debug <= gme_debug.g_log_procedure) THEN
239: gme_debug.put_line ( g_pkg_name
240: || '.'
241: || l_api_name
242: || ':'
243: || 'ACTIVITY_UPD_ERR.');

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

245:
246: ROLLBACK TO SAVEPOINT terminate_batch_step;
247: x_return_status := fnd_api.g_ret_sts_error;
248: WHEN batch_step_upd_err THEN
249: IF (g_debug <= gme_debug.g_log_procedure) THEN
250: gme_debug.put_line
251: ( g_pkg_name
252: || '.'
253: || l_api_name

Line 250: gme_debug.put_line

246: ROLLBACK TO SAVEPOINT terminate_batch_step;
247: x_return_status := fnd_api.g_ret_sts_error;
248: WHEN batch_step_upd_err THEN
249: IF (g_debug <= gme_debug.g_log_procedure) THEN
250: gme_debug.put_line
251: ( g_pkg_name
252: || '.'
253: || l_api_name
254: || ':'

Line 256: ,gme_debug.g_log_error

252: || '.'
253: || l_api_name
254: || ':'
255: || ' terminate_step, error : BATCH_STEP_UPD_ERR.'
256: ,gme_debug.g_log_error
257: ,'terminate_step');
258: END IF;
259:
260: ROLLBACK TO SAVEPOINT terminate_batch_step;

Line 263: IF g_debug <= gme_debug.g_log_unexpected THEN

259:
260: ROLLBACK TO SAVEPOINT terminate_batch_step;
261: x_return_status := fnd_api.g_ret_sts_error;
262: WHEN OTHERS THEN
263: IF g_debug <= gme_debug.g_log_unexpected THEN
264: gme_debug.put_line ( 'When others exception in '
265: || g_pkg_name
266: || '.'
267: || l_api_name

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

260: ROLLBACK TO SAVEPOINT terminate_batch_step;
261: x_return_status := fnd_api.g_ret_sts_error;
262: WHEN OTHERS THEN
263: IF g_debug <= gme_debug.g_log_unexpected THEN
264: gme_debug.put_line ( 'When others exception in '
265: || g_pkg_name
266: || '.'
267: || l_api_name
268: || ' Error is '