eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_COMPLETE_BATCH_STEP_PVT dependencies on GME_DEBUG

Line 64: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

60: purge_exception_err EXCEPTION;
61:
62: BEGIN
63:
64: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
65: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
66: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step batchstep_id='||p_batch_step_rec.batchstep_id);
67: END IF;
68:

Line 65: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

61:
62: BEGIN
63:
64: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
65: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
66: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step batchstep_id='||p_batch_step_rec.batchstep_id);
67: END IF;
68:
69: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 66: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step batchstep_id='||p_batch_step_rec.batchstep_id);

62: BEGIN
63:
64: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
65: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
66: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step batchstep_id='||p_batch_step_rec.batchstep_id);
67: END IF;
68:
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:

Line 125: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

121:
122: /* If the step controls batch status profile is set then to complete the batch */
123: /* if all the steps are complete and this is not a phantom batch */
124:
125: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
126: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' step controls batch= '||gme_common_pvt.g_step_controls_batch_sts_ind);
127: END IF;
128:
129: IF (gme_common_pvt.g_step_controls_batch_sts_ind = 1) AND (l_batch_header_rec.parentline_id IS NULL) AND

Line 126: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' step controls batch= '||gme_common_pvt.g_step_controls_batch_sts_ind);

122: /* If the step controls batch status profile is set then to complete the batch */
123: /* if all the steps are complete and this is not a phantom batch */
124:
125: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
126: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' step controls batch= '||gme_common_pvt.g_step_controls_batch_sts_ind);
127: END IF;
128:
129: IF (gme_common_pvt.g_step_controls_batch_sts_ind = 1) AND (l_batch_header_rec.parentline_id IS NULL) AND
130: (l_batch_header_rec.batch_status <> gme_common_pvt.g_batch_completed) THEN

Line 139: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

135: CLOSE Cur_step_count;
136:
137: /* If all the steps are complete or closed in the batch then call complete batch */
138: IF (l_step_count = 0) THEN
139: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
140: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling complete batch because step controls batch and all steps complete');
141: END IF;
142:
143: l_in_batch_header_rec := l_batch_header_rec;

Line 140: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling complete batch because step controls batch and all steps complete');

136:
137: /* If all the steps are complete or closed in the batch then call complete batch */
138: IF (l_step_count = 0) THEN
139: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
140: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling complete batch because step controls batch and all steps complete');
141: END IF;
142:
143: l_in_batch_header_rec := l_batch_header_rec;
144: l_in_batch_header_rec.actual_cmplt_date := x_batch_step_rec.actual_cmplt_date;

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

177: ,p_recursive => 'R'
178: ,x_return_status => l_return_status);
179:
180: IF l_return_status <> fnd_api.g_ret_sts_success THEN
181: IF (g_debug <= gme_debug.g_log_procedure) THEN
182: gme_debug.put_line ( g_pkg_name
183: || '.'
184: || l_api_name
185: || ':'

Line 182: gme_debug.put_line ( g_pkg_name

178: ,x_return_status => l_return_status);
179:
180: IF l_return_status <> fnd_api.g_ret_sts_success THEN
181: IF (g_debug <= gme_debug.g_log_procedure) THEN
182: gme_debug.put_line ( g_pkg_name
183: || '.'
184: || l_api_name
185: || ':'
186: || 'purge_exception_err');

Line 194: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

190: END IF;
191: END IF; /* IF l_step_count = 0 */
192: END IF; /* IF (gme_common_pvt.g_step_controls_batch_sts_ind = 'Y') AND */
193:
194: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
195: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
196: END IF;
197:
198: EXCEPTION

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

191: END IF; /* IF l_step_count = 0 */
192: END IF; /* IF (gme_common_pvt.g_step_controls_batch_sts_ind = 'Y') AND */
193:
194: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
195: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
196: END IF;
197:
198: EXCEPTION
199: WHEN error_release_batch OR error_complete_batch OR

Line 208: IF g_debug <= gme_debug.g_log_procedure THEN

204: ,SQLERRM);
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206: WHEN OTHERS THEN
207: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
208: IF g_debug <= gme_debug.g_log_procedure THEN
209: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
210: END IF;
211: x_return_status := FND_API.g_ret_sts_unexp_error;
212: END complete_step;

Line 209: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206: WHEN OTHERS THEN
207: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
208: IF g_debug <= gme_debug.g_log_procedure THEN
209: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
210: END IF;
211: x_return_status := FND_API.g_ret_sts_unexp_error;
212: END complete_step;
213:

Line 241: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

237: gmo_lock_error EXCEPTION;
238: error_quality_status EXCEPTION; --Bug#6348353
239:
240: BEGIN
241: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
242: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
243: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' complete step recursive batch_step_id='||p_batch_step_rec.batchstep_id);
244: END IF;
245:

Line 242: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

238: error_quality_status EXCEPTION; --Bug#6348353
239:
240: BEGIN
241: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
242: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
243: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' complete step recursive batch_step_id='||p_batch_step_rec.batchstep_id);
244: END IF;
245:
246: /* Set the return status to success initially */

Line 243: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' complete step recursive batch_step_id='||p_batch_step_rec.batchstep_id);

239:
240: BEGIN
241: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
242: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
243: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' complete step recursive batch_step_id='||p_batch_step_rec.batchstep_id);
244: END IF;
245:
246: /* Set the return status to success initially */
247: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 254: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

250:
251: /* Exit the recursive loop if the step is already released, completed or closed */
252: IF x_batch_step_rec.step_status IN (gme_common_pvt.g_step_completed
253: ,gme_common_pvt.g_step_closed) THEN
254: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
255: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'step is completed or closed; returning');
256: END IF;
257: RAISE step_cmpl_closed;
258: END IF;

Line 255: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'step is completed or closed; returning');

251: /* Exit the recursive loop if the step is already released, completed or closed */
252: IF x_batch_step_rec.step_status IN (gme_common_pvt.g_step_completed
253: ,gme_common_pvt.g_step_closed) THEN
254: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
255: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'step is completed or closed; returning');
256: END IF;
257: RAISE step_cmpl_closed;
258: END IF;
259:

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

279: IF x_return_status <> fnd_api.g_ret_sts_success THEN
280: RAISE gmo_lock_error;
281: END IF;
282:
283: IF (g_debug <= gme_debug.g_log_procedure) THEN
284: gme_debug.put_line ( g_pkg_name
285: || '.'
286: || l_api_name
287: || ':'

Line 284: gme_debug.put_line ( g_pkg_name

280: RAISE gmo_lock_error;
281: END IF;
282:
283: IF (g_debug <= gme_debug.g_log_procedure) THEN
284: gme_debug.put_line ( g_pkg_name
285: || '.'
286: || l_api_name
287: || ':'
288: || 'from gmo the lock_status='

Line 319: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

315: x_return_status := gme_common_pvt.g_exceptions_err;
316: END IF;
317: END IF; -- IF p_batch_header_rec.batch_status <> gme_common_pvt.g_batch_completed THEN
318:
319: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
320: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'Calling complete step line to create product transactions...');
321: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' for step = '|| x_batch_step_rec.batchstep_id);
322: END IF;
323:

Line 320: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'Calling complete step line to create product transactions...');

316: END IF;
317: END IF; -- IF p_batch_header_rec.batch_status <> gme_common_pvt.g_batch_completed THEN
318:
319: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
320: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'Calling complete step line to create product transactions...');
321: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' for step = '|| x_batch_step_rec.batchstep_id);
322: END IF;
323:
324: --Bug#6348353 Adding the below validation

Line 321: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' for step = '|| x_batch_step_rec.batchstep_id);

317: END IF; -- IF p_batch_header_rec.batch_status <> gme_common_pvt.g_batch_completed THEN
318:
319: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
320: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'Calling complete step line to create product transactions...');
321: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' for step = '|| x_batch_step_rec.batchstep_id);
322: END IF;
323:
324: --Bug#6348353 Adding the below validation
325: -- if quality is not complete cannot complete step

Line 390: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

386: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
387: RAISE update_step_qty_error;
388: END IF;
389:
390: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
391: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
392: END IF;
393:
394: EXCEPTION

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

387: RAISE update_step_qty_error;
388: END IF;
389:
390: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
391: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
392: END IF;
393:
394: EXCEPTION
395: WHEN update_step_qty_error THEN

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

396: x_return_status := l_return_status;
397: WHEN step_cmpl_closed OR cmpl_step_line_error OR cmpl_step_prod_error OR error_process_dep_steps THEN
398: NULL;
399: WHEN gmo_lock_error THEN
400: IF (g_debug <= gme_debug.g_log_procedure) THEN
401: gme_debug.put_line ( g_pkg_name
402: || '.'
403: || l_api_name
404: || ':'

Line 401: gme_debug.put_line ( g_pkg_name

397: WHEN step_cmpl_closed OR cmpl_step_line_error OR cmpl_step_prod_error OR error_process_dep_steps THEN
398: NULL;
399: WHEN gmo_lock_error THEN
400: IF (g_debug <= gme_debug.g_log_procedure) THEN
401: gme_debug.put_line ( g_pkg_name
402: || '.'
403: || l_api_name
404: || ':'
405: || 'GMO_LOCK_ERROR.');

Line 416: IF g_debug <= gme_debug.g_log_procedure THEN

412: ,'BATCH_NO', p_batch_header_rec.batch_no);
413: x_return_status := fnd_api.g_ret_sts_error;
414: WHEN OTHERS THEN
415: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
416: IF g_debug <= gme_debug.g_log_procedure THEN
417: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
418: END IF;
419: x_return_status := FND_API.g_ret_sts_unexp_error;
420: END complete_step_recursive;

Line 417: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

413: x_return_status := fnd_api.g_ret_sts_error;
414: WHEN OTHERS THEN
415: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
416: IF g_debug <= gme_debug.g_log_procedure THEN
417: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
418: END IF;
419: x_return_status := FND_API.g_ret_sts_unexp_error;
420: END complete_step_recursive;
421:

Line 449: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

445:
446: batch_step_upd_err EXCEPTION;
447: BEGIN
448:
449: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
450: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
451: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step line batchstep_id='||p_batch_step_rec.batchstep_id);
452: END IF;
453:

Line 450: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

446: batch_step_upd_err EXCEPTION;
447: BEGIN
448:
449: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
450: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
451: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step line batchstep_id='||p_batch_step_rec.batchstep_id);
452: END IF;
453:
454: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 451: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step line batchstep_id='||p_batch_step_rec.batchstep_id);

447: BEGIN
448:
449: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
450: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
451: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Complete step line batchstep_id='||p_batch_step_rec.batchstep_id);
452: END IF;
453:
454: x_return_status := FND_API.G_RET_STS_SUCCESS;
455:

Line 514: IF g_debug <= gme_debug.g_log_procedure THEN

510: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
511: x_return_status := FND_API.g_ret_sts_unexp_error;
512: WHEN OTHERS THEN
513: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
514: IF g_debug <= gme_debug.g_log_procedure THEN
515: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
516: END IF;
517: x_return_status := FND_API.g_ret_sts_unexp_error;
518: END complete_step_line;

Line 515: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

511: x_return_status := FND_API.g_ret_sts_unexp_error;
512: WHEN OTHERS THEN
513: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
514: IF g_debug <= gme_debug.g_log_procedure THEN
515: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
516: END IF;
517: x_return_status := FND_API.g_ret_sts_unexp_error;
518: END complete_step_line;
519:

Line 547: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

543:
544: error_process_prod EXCEPTION;
545:
546: BEGIN
547: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
548: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
549: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Completing products/byproducts for step_id='||p_batch_step_rec.batchstep_id);
550: END IF;
551:

Line 548: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

544: error_process_prod EXCEPTION;
545:
546: BEGIN
547: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
548: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
549: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Completing products/byproducts for step_id='||p_batch_step_rec.batchstep_id);
550: END IF;
551:
552: /* Set the return status to success initially */

Line 549: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Completing products/byproducts for step_id='||p_batch_step_rec.batchstep_id);

545:
546: BEGIN
547: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
548: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
549: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Completing products/byproducts for step_id='||p_batch_step_rec.batchstep_id);
550: END IF;
551:
552: /* Set the return status to success initially */
553: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 582: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

578: x_return_status := gme_common_pvt.g_exceptions_err;
579: END IF;
580: END LOOP;
581:
582: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
583: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
584: END IF;
585:
586: EXCEPTION

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

579: END IF;
580: END LOOP;
581:
582: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
583: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
584: END IF;
585:
586: EXCEPTION
587: WHEN error_process_prod THEN

Line 591: IF g_debug <= gme_debug.g_log_procedure THEN

587: WHEN error_process_prod THEN
588: NULL;
589: WHEN OTHERS THEN
590: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
591: IF g_debug <= gme_debug.g_log_procedure THEN
592: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
593: END IF;
594: x_return_status := FND_API.g_ret_sts_unexp_error;
595: END complete_step_material;

Line 592: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

588: NULL;
589: WHEN OTHERS THEN
590: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
591: IF g_debug <= gme_debug.g_log_procedure THEN
592: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
593: END IF;
594: x_return_status := FND_API.g_ret_sts_unexp_error;
595: END complete_step_material;
596:

Line 619: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

615: GME_STEP_DEP_COMPLETE EXCEPTION;
616: GME_STEP_DEP_WIP EXCEPTION;
617: INVALID_START_DATE EXCEPTION;
618: BEGIN
619: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
620: gme_debug.g_log_procedure THEN
621: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
622: || l_api_name);
623: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_step_id);

Line 620: gme_debug.g_log_procedure THEN

616: GME_STEP_DEP_WIP EXCEPTION;
617: INVALID_START_DATE EXCEPTION;
618: BEGIN
619: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
620: gme_debug.g_log_procedure THEN
621: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
622: || l_api_name);
623: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_step_id);
624: END IF;

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

617: INVALID_START_DATE EXCEPTION;
618: BEGIN
619: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
620: gme_debug.g_log_procedure THEN
621: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
622: || l_api_name);
623: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_step_id);
624: END IF;
625:

Line 623: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_step_id);

619: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
620: gme_debug.g_log_procedure THEN
621: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
622: || l_api_name);
623: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_step_id);
624: END IF;
625:
626: x_return_status := FND_API.g_ret_sts_success;
627:

Line 656: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

652: END IF;
653: END IF;
654: END LOOP; -- FOR l_dep_step_rec IN Cur_get_dep_steps
655:
656: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
657: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
658: END IF;
659:
660: EXCEPTION

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

653: END IF;
654: END LOOP; -- FOR l_dep_step_rec IN Cur_get_dep_steps
655:
656: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
657: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
658: END IF;
659:
660: EXCEPTION
661: WHEN INVALID_START_DATE THEN

Line 672: IF g_debug <= gme_debug.g_log_procedure THEN

668: gme_common_pvt.log_message('GME_STEP_DEP_COMPLETE');
669: x_return_status := FND_API.G_RET_STS_ERROR ;
670: WHEN OTHERS THEN
671: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
672: IF g_debug <= gme_debug.g_log_procedure THEN
673: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
674: END IF;
675: x_return_status := FND_API.g_ret_sts_unexp_error;
676: END validate_dependent_steps;

Line 673: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

669: x_return_status := FND_API.G_RET_STS_ERROR ;
670: WHEN OTHERS THEN
671: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
672: IF g_debug <= gme_debug.g_log_procedure THEN
673: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
674: END IF;
675: x_return_status := FND_API.g_ret_sts_unexp_error;
676: END validate_dependent_steps;
677:

Line 713: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

709:
710: -- Bug 9277115
711: error_actual_start_date EXCEPTION;
712: BEGIN
713: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
714: gme_debug.g_log_procedure THEN
715: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
716: || l_api_name);
717: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);

Line 714: gme_debug.g_log_procedure THEN

710: -- Bug 9277115
711: error_actual_start_date EXCEPTION;
712: BEGIN
713: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
714: gme_debug.g_log_procedure THEN
715: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
716: || l_api_name);
717: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);
718: END IF;

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

711: error_actual_start_date EXCEPTION;
712: BEGIN
713: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
714: gme_debug.g_log_procedure THEN
715: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
716: || l_api_name);
717: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);
718: END IF;
719:

Line 717: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);

713: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
714: gme_debug.g_log_procedure THEN
715: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
716: || l_api_name);
717: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);
718: END IF;
719:
720: x_return_status := fnd_api.g_ret_sts_success;
721:

Line 795: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

791: END IF;
792: x_batch_step_rec.actual_cmplt_date := p_batch_step_rec.actual_cmplt_date;
793: END IF;
794:
795: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
796: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'actual_cmplt_date='||to_char(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
797: END IF;
798:
799: --Bug#5109119 check for close period

Line 796: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'actual_cmplt_date='||to_char(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

792: x_batch_step_rec.actual_cmplt_date := p_batch_step_rec.actual_cmplt_date;
793: END IF;
794:
795: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
796: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'actual_cmplt_date='||to_char(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
797: END IF;
798:
799: --Bug#5109119 check for close period
800: IF NOT gme_common_pvt.check_close_period(p_org_id => p_batch_header_rec.organization_id

Line 829: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

825: p_override_quality = fnd_api.g_false) THEN
826: RAISE error_quality_status;
827: END IF;
828:
829: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
830: gme_debug.g_log_procedure THEN
831: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
832: END IF;
833:

Line 830: gme_debug.g_log_procedure THEN

826: RAISE error_quality_status;
827: END IF;
828:
829: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
830: gme_debug.g_log_procedure THEN
831: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
832: END IF;
833:
834: EXCEPTION

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

827: END IF;
828:
829: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
830: gme_debug.g_log_procedure THEN
831: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
832: END IF;
833:
834: EXCEPTION
835: --Bug#5109119 Begin

Line 866: IF g_debug <= gme_debug.g_log_procedure THEN

862: x_return_status := FND_API.G_RET_STS_ERROR;
863: WHEN OTHERS THEN
864: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
865:
866: IF g_debug <= gme_debug.g_log_procedure THEN
867: gme_debug.put_line ( 'Unexpected error: '
868: || g_pkg_name
869: || '.'
870: || l_api_name

Line 867: gme_debug.put_line ( 'Unexpected error: '

863: WHEN OTHERS THEN
864: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
865:
866: IF g_debug <= gme_debug.g_log_procedure THEN
867: gme_debug.put_line ( 'Unexpected error: '
868: || g_pkg_name
869: || '.'
870: || l_api_name
871: || ': '

Line 933: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

929: X_prev_step NUMBER;
930: l_batch_step GME_BATCH_STEPS%ROWTYPE;
931:
932: BEGIN
933: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
934: gme_debug.g_log_procedure THEN
935: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
936: || l_api_name);
937: END IF;

Line 934: gme_debug.g_log_procedure THEN

930: l_batch_step GME_BATCH_STEPS%ROWTYPE;
931:
932: BEGIN
933: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
934: gme_debug.g_log_procedure THEN
935: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
936: || l_api_name);
937: END IF;
938:

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

931:
932: BEGIN
933: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
934: gme_debug.g_log_procedure THEN
935: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
936: || l_api_name);
937: END IF;
938:
939: -- Set the return status to success initially *

Line 1022: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

1018: END LOOP;
1019:
1020: x_batch_start_date := X_prev_start_date;
1021:
1022: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
1023: gme_debug.g_log_procedure THEN
1024: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1025: END IF;
1026: EXCEPTION

Line 1023: gme_debug.g_log_procedure THEN

1019:
1020: x_batch_start_date := X_prev_start_date;
1021:
1022: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
1023: gme_debug.g_log_procedure THEN
1024: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1025: END IF;
1026: EXCEPTION
1027: WHEN BATCH_STEP_FETCH_ERROR THEN

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

1020: x_batch_start_date := X_prev_start_date;
1021:
1022: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
1023: gme_debug.g_log_procedure THEN
1024: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1025: END IF;
1026: EXCEPTION
1027: WHEN BATCH_STEP_FETCH_ERROR THEN
1028: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

Line 1036: IF g_debug <= gme_debug.g_log_procedure THEN

1032: x_return_status := FND_API.G_RET_STS_ERROR;
1033: WHEN OTHERS THEN
1034: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1035:
1036: IF g_debug <= gme_debug.g_log_procedure THEN
1037: gme_debug.put_line ( 'Unexpected error: '
1038: || g_pkg_name
1039: || '.'
1040: || l_api_name

Line 1037: gme_debug.put_line ( 'Unexpected error: '

1033: WHEN OTHERS THEN
1034: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1035:
1036: IF g_debug <= gme_debug.g_log_procedure THEN
1037: gme_debug.put_line ( 'Unexpected error: '
1038: || g_pkg_name
1039: || '.'
1040: || l_api_name
1041: || ': '