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 77: x_return_status := fnd_api.g_ret_sts_success;

73: || 'Entering');
74: END IF;
75:
76: /* Set the success staus to success inititally*/
77: x_return_status := fnd_api.g_ret_sts_success;
78: x_batch_header_rec := p_batch_header_rec;
79: -- Now Examine the ingredient material rows :
80: l_material_details_rec.batch_id := x_batch_header_rec.batch_id;
81:

Line 123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

119: || ':'
120: || ' Return from delete_prod_supply_resv indicates '
121: || x_return_status);
122: END IF;
123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
124: RAISE reservation_delete_err;
125: END IF;
126: END IF;
127: -- 4944024 END

Line 162: IF l_return_status <> fnd_api.g_ret_sts_success THEN

158: (p_batch_header_rec => l_ph_batch_header_rec
159: ,x_batch_header_rec => l_batch_header_rec
160: ,x_return_status => l_return_status);
161:
162: IF l_return_status <> fnd_api.g_ret_sts_success THEN
163: RAISE phantom_batch_cancel_error;
164: END IF;
165: END IF;
166: END LOOP;

Line 186: IF l_return_status <> fnd_api.g_ret_sts_success THEN

182: ,p_delete_reservations => 'T'
183: ,p_delete_trans_pairs => 'T'
184: ,x_return_status => l_return_status);
185:
186: IF l_return_status <> fnd_api.g_ret_sts_success THEN
187: RAISE purge_exception_err;
188: END IF;
189: END IF;
190:

Line 241: IF l_return_status <> fnd_api.g_ret_sts_success THEN

237: ,p_update_inventory_ind => x_batch_header_rec.update_inventory_ind
238: ,x_return_status => l_return_status
239: ,x_batch_step_rec => l_batch_step_rec);
240:
241: IF l_return_status <> fnd_api.g_ret_sts_success THEN
242: RAISE batch_step_cancel_error;
243: END IF;
244: END LOOP;
245: END IF;

Line 312: x_return_status := fnd_api.g_ret_sts_error;

308: || ':'
309: || 'MATERIAL_FETCH_ERROR');
310: END IF;
311:
312: x_return_status := fnd_api.g_ret_sts_error;
313: WHEN batch_header_fetch_failure THEN
314: IF (g_debug <= gme_debug.g_log_procedure) THEN
315: gme_debug.put_line ( g_pkg_name
316: || '.'

Line 322: x_return_status := fnd_api.g_ret_sts_error;

318: || ':'
319: || 'BATCH_FETCH_ERROR');
320: END IF;
321:
322: x_return_status := fnd_api.g_ret_sts_error;
323: WHEN phantom_batch_cancel_error THEN
324: IF (g_debug <= gme_debug.g_log_procedure) THEN
325: gme_debug.put_line ( g_pkg_name
326: || '.'

Line 342: x_return_status := fnd_api.g_ret_sts_error;

338: || ':'
339: || 'BATCH_HEADER_UPD_ERR');
340: END IF;
341:
342: x_return_status := fnd_api.g_ret_sts_error;
343: gme_common_pvt.log_message ('GME_API_BATCH_HEADER_UPD_ERROR');
344: WHEN batch_hist_insert_err THEN
345: IF (g_debug <= gme_debug.g_log_procedure) THEN
346: gme_debug.put_line ( g_pkg_name

Line 353: x_return_status := fnd_api.g_ret_sts_error;

349: || ':'
350: || 'BATCH_HIST_INSERT_ERR.');
351: END IF;
352:
353: x_return_status := fnd_api.g_ret_sts_error;
354: WHEN batch_step_fetch_err THEN
355: IF (g_debug <= gme_debug.g_log_procedure) THEN
356: gme_debug.put_line ( g_pkg_name
357: || '.'

Line 363: x_return_status := fnd_api.g_ret_sts_error;

359: || ':'
360: || ' BATCH_STEP_FETCH_ERR.');
361: END IF;
362:
363: x_return_status := fnd_api.g_ret_sts_error;
364: WHEN batch_step_cancel_error THEN
365: IF (g_debug <= gme_debug.g_log_procedure) THEN
366: gme_debug.put_line ( g_pkg_name
367: || '.'

Line 394: x_return_status := fnd_api.g_ret_sts_unexp_error;

390: || ' Error is '
391: || SQLERRM);
392: END IF;
393:
394: x_return_status := fnd_api.g_ret_sts_unexp_error;
395: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
396: END cancel_batch;
397:
398:

Line 423: x_return_status := fnd_api.g_ret_sts_success;

419: batch_header_fetch_failure EXCEPTION;
420: l_return_status VARCHAR2(1);
421: BEGIN
422: -- Initially let us assign the return status to success
423: x_return_status := fnd_api.g_ret_sts_success;
424:
425: IF (g_debug <= gme_debug.g_log_statement) THEN
426: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
427: || 'Entering');

Line 478: IF l_return_status <> fnd_api.g_ret_sts_success THEN

474: ,p_batch_id => l_batch_header_rec.batch_id
475: ,p_delete_invis => p_delete_invis_mo
476: ,x_return_status => l_return_status);
477:
478: IF l_return_status <> fnd_api.g_ret_sts_success THEN
479: RAISE delete_move_order_err;
480: END IF;
481:
482: IF p_delete_reservations = fnd_api.g_true THEN

Line 482: IF p_delete_reservations = fnd_api.g_true THEN

478: IF l_return_status <> fnd_api.g_ret_sts_success THEN
479: RAISE delete_move_order_err;
480: END IF;
481:
482: IF p_delete_reservations = fnd_api.g_true THEN
483: -- delete all reservations
484: IF (g_debug <= gme_debug.g_log_statement) THEN
485: gme_debug.put_line ( g_pkg_name
486: || '.'

Line 498: IF l_return_status <> fnd_api.g_ret_sts_success THEN

494: (p_organization_id => l_batch_header_rec.organization_id
495: ,p_batch_id => l_batch_header_rec.batch_id
496: ,x_return_status => l_return_status);
497:
498: IF l_return_status <> fnd_api.g_ret_sts_success THEN
499: RAISE delete_reservations_err;
500: END IF;
501: END IF;
502: IF p_delete_trans_pairs = fnd_api.g_true THEN

Line 502: IF p_delete_trans_pairs = fnd_api.g_true THEN

498: IF l_return_status <> fnd_api.g_ret_sts_success THEN
499: RAISE delete_reservations_err;
500: END IF;
501: END IF;
502: IF p_delete_trans_pairs = fnd_api.g_true THEN
503: IF (g_debug <= gme_debug.g_log_statement) THEN
504: gme_debug.put_line ( g_pkg_name
505: || '.'
506: || l_api_name

Line 516: IF l_return_status <> fnd_api.g_ret_sts_success THEN

512: gme_transactions_pvt.purge_trans_pairs
513: (p_batch_id => l_batch_header_rec.batch_id
514: ,x_return_status => l_return_status);
515:
516: IF l_return_status <> fnd_api.g_ret_sts_success THEN
517: RAISE delete_trans_pair_err;
518: END IF;
519: END IF;
520: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 532: IF l_return_status <> fnd_api.g_ret_sts_success THEN

528:
529: delete_pending_lots (p_batch_id => l_batch_header_rec.batch_id
530: ,x_return_status => l_return_status);
531:
532: IF l_return_status <> fnd_api.g_ret_sts_success THEN
533: RAISE delete_pend_prod_lots_err;
534: END IF;
535:
536: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 554: x_return_status := fnd_api.g_ret_sts_error;

550: || ':'
551: || 'MATERIAL_FETCH_ERROR');
552: END IF;
553:
554: x_return_status := fnd_api.g_ret_sts_error;
555: WHEN batch_header_fetch_failure THEN
556: IF (g_debug <= gme_debug.g_log_procedure) THEN
557: gme_debug.put_line ( g_pkg_name
558: || '.'

Line 564: x_return_status := fnd_api.g_ret_sts_error;

560: || ':'
561: || 'BATCH_FETCH_ERROR');
562: END IF;
563:
564: x_return_status := fnd_api.g_ret_sts_error;
565: WHEN phantom_batch_purge_error THEN
566: IF (g_debug <= gme_debug.g_log_procedure) THEN
567: gme_debug.put_line ( g_pkg_name
568: || '.'

Line 615: WHEN fnd_api.g_exc_error THEN

611: || 'delete_pend_prod_lots_err');
612: END IF;
613:
614: x_return_status := l_return_status;
615: WHEN fnd_api.g_exc_error THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617: WHEN fnd_api.g_exc_unexpected_error THEN
618: x_return_status := fnd_api.g_ret_sts_unexp_error;
619: WHEN OTHERS THEN

Line 616: x_return_status := fnd_api.g_ret_sts_error;

612: END IF;
613:
614: x_return_status := l_return_status;
615: WHEN fnd_api.g_exc_error THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617: WHEN fnd_api.g_exc_unexpected_error THEN
618: x_return_status := fnd_api.g_ret_sts_unexp_error;
619: WHEN OTHERS THEN
620: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 617: WHEN fnd_api.g_exc_unexpected_error THEN

613:
614: x_return_status := l_return_status;
615: WHEN fnd_api.g_exc_error THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617: WHEN fnd_api.g_exc_unexpected_error THEN
618: x_return_status := fnd_api.g_ret_sts_unexp_error;
619: WHEN OTHERS THEN
620: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
621: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 618: x_return_status := fnd_api.g_ret_sts_unexp_error;

614: x_return_status := l_return_status;
615: WHEN fnd_api.g_exc_error THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617: WHEN fnd_api.g_exc_unexpected_error THEN
618: x_return_status := fnd_api.g_ret_sts_unexp_error;
619: WHEN OTHERS THEN
620: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
621: x_return_status := fnd_api.g_ret_sts_unexp_error;
622:

Line 621: x_return_status := fnd_api.g_ret_sts_unexp_error;

617: WHEN fnd_api.g_exc_unexpected_error THEN
618: x_return_status := fnd_api.g_ret_sts_unexp_error;
619: WHEN OTHERS THEN
620: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
621: x_return_status := fnd_api.g_ret_sts_unexp_error;
622:
623: IF g_debug <= gme_debug.g_log_unexpected THEN
624: gme_debug.put_line ( 'When others exception in '
625: || g_pkg_name

Line 632: x_return_status := fnd_api.g_ret_sts_unexp_error;

628: || ' Error is '
629: || SQLERRM);
630: END IF;
631:
632: x_return_status := fnd_api.g_ret_sts_unexp_error;
633: END purge_batch_exceptions;
634:
635: PROCEDURE delete_pending_lots (
636: p_batch_id IN NUMBER

Line 646: x_return_status := fnd_api.g_ret_sts_success;

642: l_api_name CONSTANT VARCHAR2 (30) := 'delete_pending_lots';
643: l_return_status VARCHAR2 (1);
644: BEGIN
645: -- Initially let us assign the return status to success
646: x_return_status := fnd_api.g_ret_sts_success;
647:
648: IF (g_debug <= gme_debug.g_log_statement) THEN
649: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
650: || 'Entering');

Line 658: RAISE fnd_api.g_exc_error;

654: -- may use required message
655: gme_common_pvt.log_message ('GME_INVALID_FIELD'
656: ,'FIELD'
657: ,'p_batch_id');
658: RAISE fnd_api.g_exc_error;
659: END IF;
660:
661: l_batch_id := p_batch_id;
662: l_material_detail_id := p_material_detail_id;

Line 691: WHEN fnd_api.g_exc_error THEN

687: WHERE batch_id = l_batch_id
688: AND material_detail_id = l_material_detail_id;
689: END IF;
690: EXCEPTION
691: WHEN fnd_api.g_exc_error THEN
692: x_return_status := fnd_api.g_ret_sts_error;
693: WHEN fnd_api.g_exc_unexpected_error THEN
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: WHEN OTHERS THEN

Line 692: x_return_status := fnd_api.g_ret_sts_error;

688: AND material_detail_id = l_material_detail_id;
689: END IF;
690: EXCEPTION
691: WHEN fnd_api.g_exc_error THEN
692: x_return_status := fnd_api.g_ret_sts_error;
693: WHEN fnd_api.g_exc_unexpected_error THEN
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: WHEN OTHERS THEN
696: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 693: WHEN fnd_api.g_exc_unexpected_error THEN

689: END IF;
690: EXCEPTION
691: WHEN fnd_api.g_exc_error THEN
692: x_return_status := fnd_api.g_ret_sts_error;
693: WHEN fnd_api.g_exc_unexpected_error THEN
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: WHEN OTHERS THEN
696: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
697: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 694: x_return_status := fnd_api.g_ret_sts_unexp_error;

690: EXCEPTION
691: WHEN fnd_api.g_exc_error THEN
692: x_return_status := fnd_api.g_ret_sts_error;
693: WHEN fnd_api.g_exc_unexpected_error THEN
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: WHEN OTHERS THEN
696: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
697: x_return_status := fnd_api.g_ret_sts_unexp_error;
698:

Line 697: x_return_status := fnd_api.g_ret_sts_unexp_error;

693: WHEN fnd_api.g_exc_unexpected_error THEN
694: x_return_status := fnd_api.g_ret_sts_unexp_error;
695: WHEN OTHERS THEN
696: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
697: x_return_status := fnd_api.g_ret_sts_unexp_error;
698:
699: IF g_debug <= gme_debug.g_log_unexpected THEN
700: gme_debug.put_line ( 'When others exception in '
701: || g_pkg_name