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_CANCEL_BATCH_PVT dependencies on FND_API

Line 107: x_return_status := fnd_api.g_ret_sts_success;

103: || 'Entering');
104: END IF;
105:
106: /* Set the success staus to success inititally*/
107: x_return_status := fnd_api.g_ret_sts_success;
108: x_batch_header_rec := p_batch_header_rec;
109: -- Now Examine the ingredient material rows :
110: l_material_details_rec.batch_id := x_batch_header_rec.batch_id;
111:

Line 153: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

149: || ':'
150: || ' Return from delete_prod_supply_resv indicates '
151: || x_return_status);
152: END IF;
153: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
154: RAISE reservation_delete_err;
155: END IF;
156: END IF;
157: -- 4944024 END

Line 193: IF l_return_status <> fnd_api.g_ret_sts_success THEN

189: (p_batch_header_rec => l_ph_batch_header_rec
190: ,x_batch_header_rec => l_batch_header_rec
191: ,x_return_status => l_return_status);
192:
193: IF l_return_status <> fnd_api.g_ret_sts_success THEN
194: RAISE phantom_batch_cancel_error;
195: END IF;
196: END IF;
197:

Line 231: IF l_return_status <> fnd_api.g_ret_sts_success THEN

227: ,p_delete_reservations => 'T'
228: ,p_delete_trans_pairs => 'T'
229: ,x_return_status => l_return_status);
230:
231: IF l_return_status <> fnd_api.g_ret_sts_success THEN
232: RAISE purge_exception_err;
233: END IF;
234: END IF;
235:

Line 287: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

283: gme_trans_engine_util.load_rsrc_trans(p_batch_row => x_batch_header_rec
284: ,x_rsc_row_count => l_rsrc_cnt
285: ,x_return_status => l_return_status);
286:
287: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
288: RAISE batch_step_cancel_error;
289: END IF;
290:
291: FOR i IN 1 .. l_batch_step_tab.COUNT LOOP

Line 311: IF l_return_status <> fnd_api.g_ret_sts_success THEN

307: ,p_update_inventory_ind => x_batch_header_rec.update_inventory_ind
308: ,x_return_status => l_return_status
309: ,x_batch_step_rec => l_batch_step_rec);
310:
311: IF l_return_status <> fnd_api.g_ret_sts_success THEN
312: RAISE batch_step_cancel_error;
313: END IF;
314: END LOOP;
315: END IF;

Line 382: x_return_status := fnd_api.g_ret_sts_error;

378: || ':'
379: || 'MATERIAL_FETCH_ERROR');
380: END IF;
381:
382: x_return_status := fnd_api.g_ret_sts_error;
383: WHEN batch_header_fetch_failure THEN
384: IF (g_debug <= gme_debug.g_log_procedure) THEN
385: gme_debug.put_line ( g_pkg_name
386: || '.'

Line 392: x_return_status := fnd_api.g_ret_sts_error;

388: || ':'
389: || 'BATCH_FETCH_ERROR');
390: END IF;
391:
392: x_return_status := fnd_api.g_ret_sts_error;
393: WHEN phantom_batch_cancel_error THEN
394: IF (g_debug <= gme_debug.g_log_procedure) THEN
395: gme_debug.put_line ( g_pkg_name
396: || '.'

Line 412: x_return_status := fnd_api.g_ret_sts_error;

408: || ':'
409: || 'BATCH_HEADER_UPD_ERR');
410: END IF;
411:
412: x_return_status := fnd_api.g_ret_sts_error;
413: gme_common_pvt.log_message ('GME_API_BATCH_HEADER_UPD_ERROR');
414: WHEN batch_hist_insert_err THEN
415: IF (g_debug <= gme_debug.g_log_procedure) THEN
416: gme_debug.put_line ( g_pkg_name

Line 423: x_return_status := fnd_api.g_ret_sts_error;

419: || ':'
420: || 'BATCH_HIST_INSERT_ERR.');
421: END IF;
422:
423: x_return_status := fnd_api.g_ret_sts_error;
424: WHEN batch_step_fetch_err THEN
425: IF (g_debug <= gme_debug.g_log_procedure) THEN
426: gme_debug.put_line ( g_pkg_name
427: || '.'

Line 433: x_return_status := fnd_api.g_ret_sts_error;

429: || ':'
430: || ' BATCH_STEP_FETCH_ERR.');
431: END IF;
432:
433: x_return_status := fnd_api.g_ret_sts_error;
434: WHEN batch_step_cancel_error THEN
435: IF (g_debug <= gme_debug.g_log_procedure) THEN
436: gme_debug.put_line ( g_pkg_name
437: || '.'

Line 464: x_return_status := fnd_api.g_ret_sts_unexp_error;

460: || ' Error is '
461: || SQLERRM);
462: END IF;
463:
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
466: END cancel_batch;
467:
468:

Line 506: x_return_status := fnd_api.g_ret_sts_success;

502: l_delete_invis_mo VARCHAR2(1);
503:
504: BEGIN
505: -- Initially let us assign the return status to success
506: x_return_status := fnd_api.g_ret_sts_success;
507:
508: IF (g_debug <= gme_debug.g_log_statement) THEN
509: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
510: || 'Entering');

Line 583: IF l_return_status <> fnd_api.g_ret_sts_success THEN

579: ,p_delete_reservations => p_delete_reservations
580: ,p_delete_trans_pairs => p_delete_trans_pairs
581: ,x_return_status => l_return_status);
582:
583: IF l_return_status <> fnd_api.g_ret_sts_success THEN
584: RAISE phantom_batch_purge_error;
585: END IF;
586: END IF;
587: END LOOP;

Line 616: IF l_return_status <> fnd_api.g_ret_sts_success THEN

612: ,p_batch_id => l_batch_header_rec.batch_id
613: ,p_delete_invis => l_delete_invis_mo
614: ,x_return_status => l_return_status);
615:
616: IF l_return_status <> fnd_api.g_ret_sts_success THEN
617: RAISE delete_move_order_err;
618: END IF;
619:
620: IF p_delete_reservations = fnd_api.g_true THEN

Line 620: IF p_delete_reservations = fnd_api.g_true THEN

616: IF l_return_status <> fnd_api.g_ret_sts_success THEN
617: RAISE delete_move_order_err;
618: END IF;
619:
620: IF p_delete_reservations = fnd_api.g_true THEN
621: -- delete all reservations
622: IF (g_debug <= gme_debug.g_log_statement) THEN
623: gme_debug.put_line ( g_pkg_name
624: || '.'

Line 636: IF l_return_status <> fnd_api.g_ret_sts_success THEN

632: (p_organization_id => l_batch_header_rec.organization_id
633: ,p_batch_id => l_batch_header_rec.batch_id
634: ,x_return_status => l_return_status);
635:
636: IF l_return_status <> fnd_api.g_ret_sts_success THEN
637: RAISE delete_reservations_err;
638: END IF;
639: END IF;
640:

Line 641: IF p_delete_trans_pairs = fnd_api.g_true THEN

637: RAISE delete_reservations_err;
638: END IF;
639: END IF;
640:
641: IF p_delete_trans_pairs = fnd_api.g_true THEN
642: IF (g_debug <= gme_debug.g_log_statement) THEN
643: gme_debug.put_line ( g_pkg_name
644: || '.'
645: || l_api_name

Line 655: IF l_return_status <> fnd_api.g_ret_sts_success THEN

651: gme_transactions_pvt.purge_trans_pairs
652: (p_batch_id => l_batch_header_rec.batch_id
653: ,x_return_status => l_return_status);
654:
655: IF l_return_status <> fnd_api.g_ret_sts_success THEN
656: RAISE delete_trans_pair_err;
657: END IF;
658: END IF;
659: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 671: IF l_return_status <> fnd_api.g_ret_sts_success THEN

667:
668: delete_pending_lots (p_batch_id => l_batch_header_rec.batch_id
669: ,x_return_status => l_return_status);
670:
671: IF l_return_status <> fnd_api.g_ret_sts_success THEN
672: RAISE delete_pend_prod_lots_err;
673: END IF;
674:
675: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 693: x_return_status := fnd_api.g_ret_sts_error;

689: || ':'
690: || 'MATERIAL_FETCH_ERROR');
691: END IF;
692:
693: x_return_status := fnd_api.g_ret_sts_error;
694: WHEN batch_header_fetch_failure THEN
695: IF (g_debug <= gme_debug.g_log_procedure) THEN
696: gme_debug.put_line ( g_pkg_name
697: || '.'

Line 703: x_return_status := fnd_api.g_ret_sts_error;

699: || ':'
700: || 'BATCH_FETCH_ERROR');
701: END IF;
702:
703: x_return_status := fnd_api.g_ret_sts_error;
704: WHEN phantom_batch_purge_error THEN
705: IF (g_debug <= gme_debug.g_log_procedure) THEN
706: gme_debug.put_line ( g_pkg_name
707: || '.'

Line 754: WHEN fnd_api.g_exc_error THEN

750: || 'delete_pend_prod_lots_err');
751: END IF;
752:
753: x_return_status := l_return_status;
754: WHEN fnd_api.g_exc_error THEN
755: x_return_status := fnd_api.g_ret_sts_error;
756: WHEN fnd_api.g_exc_unexpected_error THEN
757: x_return_status := fnd_api.g_ret_sts_unexp_error;
758: WHEN OTHERS THEN

Line 755: x_return_status := fnd_api.g_ret_sts_error;

751: END IF;
752:
753: x_return_status := l_return_status;
754: WHEN fnd_api.g_exc_error THEN
755: x_return_status := fnd_api.g_ret_sts_error;
756: WHEN fnd_api.g_exc_unexpected_error THEN
757: x_return_status := fnd_api.g_ret_sts_unexp_error;
758: WHEN OTHERS THEN
759: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 756: WHEN fnd_api.g_exc_unexpected_error THEN

752:
753: x_return_status := l_return_status;
754: WHEN fnd_api.g_exc_error THEN
755: x_return_status := fnd_api.g_ret_sts_error;
756: WHEN fnd_api.g_exc_unexpected_error THEN
757: x_return_status := fnd_api.g_ret_sts_unexp_error;
758: WHEN OTHERS THEN
759: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
760: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 757: x_return_status := fnd_api.g_ret_sts_unexp_error;

753: x_return_status := l_return_status;
754: WHEN fnd_api.g_exc_error THEN
755: x_return_status := fnd_api.g_ret_sts_error;
756: WHEN fnd_api.g_exc_unexpected_error THEN
757: x_return_status := fnd_api.g_ret_sts_unexp_error;
758: WHEN OTHERS THEN
759: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
760: x_return_status := fnd_api.g_ret_sts_unexp_error;
761:

Line 760: x_return_status := fnd_api.g_ret_sts_unexp_error;

756: WHEN fnd_api.g_exc_unexpected_error THEN
757: x_return_status := fnd_api.g_ret_sts_unexp_error;
758: WHEN OTHERS THEN
759: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
760: x_return_status := fnd_api.g_ret_sts_unexp_error;
761:
762: IF g_debug <= gme_debug.g_log_unexpected THEN
763: gme_debug.put_line ( 'When others exception in '
764: || g_pkg_name

Line 771: x_return_status := fnd_api.g_ret_sts_unexp_error;

767: || ' Error is '
768: || SQLERRM);
769: END IF;
770:
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772: END purge_batch_exceptions;
773:
774: PROCEDURE delete_pending_lots (
775: p_batch_id IN NUMBER

Line 785: x_return_status := fnd_api.g_ret_sts_success;

781: l_api_name CONSTANT VARCHAR2 (30) := 'delete_pending_lots';
782: l_return_status VARCHAR2 (1);
783: BEGIN
784: -- Initially let us assign the return status to success
785: x_return_status := fnd_api.g_ret_sts_success;
786:
787: IF (g_debug <= gme_debug.g_log_statement) THEN
788: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
789: || 'Entering');

Line 797: RAISE fnd_api.g_exc_error;

793: -- may use required message
794: gme_common_pvt.log_message ('GME_INVALID_FIELD'
795: ,'FIELD'
796: ,'p_batch_id');
797: RAISE fnd_api.g_exc_error;
798: END IF;
799:
800: l_batch_id := p_batch_id;
801: l_material_detail_id := p_material_detail_id;

Line 830: WHEN fnd_api.g_exc_error THEN

826: WHERE batch_id = l_batch_id
827: AND material_detail_id = l_material_detail_id;
828: END IF;
829: EXCEPTION
830: WHEN fnd_api.g_exc_error THEN
831: x_return_status := fnd_api.g_ret_sts_error;
832: WHEN fnd_api.g_exc_unexpected_error THEN
833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834: WHEN OTHERS THEN

Line 831: x_return_status := fnd_api.g_ret_sts_error;

827: AND material_detail_id = l_material_detail_id;
828: END IF;
829: EXCEPTION
830: WHEN fnd_api.g_exc_error THEN
831: x_return_status := fnd_api.g_ret_sts_error;
832: WHEN fnd_api.g_exc_unexpected_error THEN
833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834: WHEN OTHERS THEN
835: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 832: WHEN fnd_api.g_exc_unexpected_error THEN

828: END IF;
829: EXCEPTION
830: WHEN fnd_api.g_exc_error THEN
831: x_return_status := fnd_api.g_ret_sts_error;
832: WHEN fnd_api.g_exc_unexpected_error THEN
833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834: WHEN OTHERS THEN
835: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
836: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 833: x_return_status := fnd_api.g_ret_sts_unexp_error;

829: EXCEPTION
830: WHEN fnd_api.g_exc_error THEN
831: x_return_status := fnd_api.g_ret_sts_error;
832: WHEN fnd_api.g_exc_unexpected_error THEN
833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834: WHEN OTHERS THEN
835: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:

Line 836: x_return_status := fnd_api.g_ret_sts_unexp_error;

832: WHEN fnd_api.g_exc_unexpected_error THEN
833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834: WHEN OTHERS THEN
835: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: IF g_debug <= gme_debug.g_log_unexpected THEN
839: gme_debug.put_line ( 'When others exception in '
840: || g_pkg_name