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

Line 73: x_return_status := fnd_api.g_ret_sts_success;

69: || p_batch_header_rec.batch_id);
70: END IF;
71:
72: /* Set the return status to success initially */
73: x_return_status := fnd_api.g_ret_sts_success;
74:
75: -- set output structure
76: x_batch_header_rec := p_batch_header_rec;
77:

Line 92: gme_common_pvt.g_batch_status_check := fnd_api.g_false;

88: CLOSE cur_get_and_lock_mtls;
89:
90: -- set batch status
91: x_batch_header_rec.batch_status := gme_common_pvt.g_batch_pending;
92: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
93: -- set actual start date to NULL...
94: x_batch_header_rec.actual_start_date := NULL;
95:
96: -- Update the batch header

Line 116: IF x_return_status <> fnd_api.g_ret_sts_success THEN

112: ,p_create_resv_pend_lots => p_create_resv_pend_lots
113: ,p_from_batch => TRUE
114: ,x_return_status => x_return_status);
115:
116: IF x_return_status <> fnd_api.g_ret_sts_success THEN
117: RAISE error_unrelease_matl;
118: END IF;
119: END LOOP;
120:

Line 155: IF x_return_status <> fnd_api.g_ret_sts_success THEN

151: ,p_from_unrelease_batch => 1
152: ,x_batch_step_rec => l_batch_step_rec
153: ,x_return_status => x_return_status);
154:
155: IF x_return_status <> fnd_api.g_ret_sts_success THEN
156: RAISE error_unrelease_step;
157: END IF;
158: END LOOP; -- FOR i IN 1 .. l_batch_step_tbl.COUNT LOOP
159:

Line 166: p_init_msg_list => FND_API.G_FALSE,

162: -- Bug 5903208 - GMF Call to delete batch requirements
163: --
164: GMF_VIB.Delete_Batch_Requirements
165: ( p_api_version => 1.0,
166: p_init_msg_list => FND_API.G_FALSE,
167: p_batch_id => x_batch_header_rec.batch_id,
168: x_return_status => x_return_status,
169: x_msg_count => l_message_count,
170: x_msg_data => l_message_list);

Line 172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

168: x_return_status => x_return_status,
169: x_msg_count => l_message_count,
170: x_msg_data => l_message_list);
171:
172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
173: THEN
174: RAISE gmf_cost_failure;
175: END IF;
176: -- End Bug 5903208

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: END IF;
195: EXCEPTION
196: WHEN gmf_cost_failure THEN
197: -- Bug 5043868
198: x_return_status := FND_API.G_RET_STS_ERROR;
199:
200: WHEN error_mtls_locked THEN
201: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
202: x_return_status := FND_API.G_RET_STS_ERROR;

Line 202: x_return_status := FND_API.G_RET_STS_ERROR;

198: x_return_status := FND_API.G_RET_STS_ERROR;
199:
200: WHEN error_mtls_locked THEN
201: gme_common_pvt.log_message ('GME_API_BATCH_LINES_LOCKED');
202: x_return_status := FND_API.G_RET_STS_ERROR;
203: WHEN error_update_row THEN
204: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
205: ,SQLERRM);
206: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 206: x_return_status := fnd_api.g_ret_sts_unexp_error;

202: x_return_status := FND_API.G_RET_STS_ERROR;
203: WHEN error_update_row THEN
204: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
205: ,SQLERRM);
206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207: WHEN error_unrelease_matl OR error_unrelease_step THEN
208: NULL;
209: WHEN OTHERS THEN
210: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 221: x_return_status := fnd_api.g_ret_sts_unexp_error;

217: || ': '
218: || SQLERRM);
219: END IF;
220:
221: x_return_status := fnd_api.g_ret_sts_unexp_error;
222: END unrelease_batch;
223:
224: PROCEDURE unrelease_material (
225: p_material_detail_rec IN gme_material_details%ROWTYPE

Line 258: x_return_status := fnd_api.g_ret_sts_success;

254: || p_material_detail_rec.material_detail_id);
255: END IF;
256:
257: -- Set the return status to success initially
258: x_return_status := fnd_api.g_ret_sts_success;
259: l_material_detail_rec := p_material_detail_rec;
260:
261: IF l_material_detail_rec.phantom_id IS NOT NULL THEN
262: -- phantom -> unrelease the phantom batch

Line 287: IF x_return_status <> fnd_api.g_ret_sts_success THEN

283: ,p_create_resv_pend_lots => p_create_resv_pend_lots
284: ,x_batch_header_rec => l_phantom_batch_rec
285: ,x_return_status => x_return_status);
286:
287: IF x_return_status <> fnd_api.g_ret_sts_success THEN
288: RAISE error_unrelease_batch;
289: END IF;
290: END IF;
291: -- IF l_phantom_batch_rec.batch_status = gme_common_pvt.g_batch_wip THEN

Line 301: IF x_return_status <> fnd_api.g_ret_sts_success THEN

297: ,p_item_id => l_material_detail_rec.inventory_item_id
298: ,x_item_rec => l_item_rec
299: ,x_return_status => x_return_status);
300:
301: IF x_return_status <> fnd_api.g_ret_sts_success THEN
302: RAISE error_get_item;
303: END IF;
304:
305: IF p_update_inventory_ind = 'Y'

Line 324: IF x_return_status <> fnd_api.g_ret_sts_success THEN

320: -- return status and raise an exception; also, l_exception_material_tbl won't
321: -- contain anything because of same reason; if the transactions can't be reversed,
322: -- it's an error here
323:
324: IF x_return_status <> fnd_api.g_ret_sts_success THEN
325: RAISE error_revert_material;
326: END IF;
327: END IF; -- IF x_batch_header_rec.update_inventory_ind = 'Y' AND
328: END IF; -- IF l_material_detail_rec.phantom_id IS NOT NULL THEN

Line 348: x_return_status := fnd_api.g_ret_sts_unexp_error;

344: EXCEPTION
345: WHEN error_update_row OR error_fetch_batch THEN
346: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
347: ,SQLERRM);
348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349: WHEN error_get_item OR error_unrelease_batch OR error_revert_material THEN
350: NULL;
351: WHEN OTHERS THEN
352: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 363: x_return_status := fnd_api.g_ret_sts_unexp_error;

359: || ': '
360: || SQLERRM);
361: END IF;
362:
363: x_return_status := fnd_api.g_ret_sts_unexp_error;
364: END unrelease_material;
365:
366: PROCEDURE revert_material_full (
367: p_material_detail_rec IN gme_material_details%ROWTYPE

Line 418: x_return_status := fnd_api.g_ret_sts_success;

414: END IF;
415: END IF;
416:
417: -- Set the return status to success initially
418: x_return_status := fnd_api.g_ret_sts_success;
419: gme_transactions_pvt.get_mat_trans
420: (p_mat_det_id => p_material_detail_rec.material_detail_id
421: ,p_batch_id => p_material_detail_rec.batch_id
422: ,x_mmt_tbl => l_mmt_tbl

Line 425: IF x_return_status <> fnd_api.g_ret_sts_success THEN

421: ,p_batch_id => p_material_detail_rec.batch_id
422: ,x_mmt_tbl => l_mmt_tbl
423: ,x_return_status => x_return_status);
424:
425: IF x_return_status <> fnd_api.g_ret_sts_success THEN
426: RAISE error_get_trans;
427: END IF;
428:
429: -- Bug 13017256 - Let's initialize the variable with the user entered date.

Line 454: IF x_return_status <> fnd_api.g_ret_sts_success THEN

450: gme_transactions_pvt.get_lot_trans
451: (p_transaction_id => l_mmt_rec.transaction_id
452: ,x_mmln_tbl => l_mmln_tbl
453: ,x_return_status => x_return_status);
454: IF x_return_status <> fnd_api.g_ret_sts_success THEN
455: RAISE error_get_trans;
456: END IF;
457: END IF;
458:

Line 466: RAISE fnd_api.g_exc_error;

462: IF (NVL(p_material_detail_rec.phantom_line_id, 0) = 0) THEN
463: IF check_inv_negative(p_mmt_rec => l_mmt_rec,
464: p_mmln_tbl => l_mmln_tbl,
465: p_item_no => l_item_rec.concatenated_segments) THEN
466: RAISE fnd_api.g_exc_error;
467: END IF;
468: END IF;
469: END IF;
470:

Line 536: RAISE fnd_api.g_exc_error;

532: ,p_token1_value => l_item_rec.concatenated_segments
533: ,p_token2_name => 'LPN_NO'
534: ,p_token2_value => l_lpn_no
535: );
536: RAISE fnd_api.g_exc_error;
537: END IF;
538:
539: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
540: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name||

Line 554: IF x_return_status <> fnd_api.g_ret_sts_success THEN

550: ,p_trans_date => l_trans_date
551: ,p_txns_pair => NULL
552: ,x_return_status => x_return_status);
553:
554: IF x_return_status <> fnd_api.g_ret_sts_success THEN
555: IF x_return_status = gme_common_pvt.g_not_transactable AND p_ignore_transactable THEN
556: -- don't do anything... move to the next...
557: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
558: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name

Line 628: ,p_force_unconsumed => fnd_api.g_true

624: ,p_pending_move_order_ind => NULL
625: ,p_pending_rsrv_ind => NULL
626: ,p_transacted_qty => p_material_detail_rec.actual_qty - x_actual_qty
627: ,p_exception_qty => x_actual_qty
628: ,p_force_unconsumed => fnd_api.g_true
629: ,x_exception_material_tbl => x_exception_material_tbl
630: ,x_return_status => x_return_status);
631: END IF;
632:

Line 638: WHEN fnd_api.g_exc_error THEN

634: gme_debug.g_log_procedure THEN
635: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return_status = '||x_return_status||' and x_actual_qty='||x_actual_qty);
636: END IF;
637: EXCEPTION
638: WHEN fnd_api.g_exc_error THEN
639: x_return_status := fnd_api.g_ret_sts_error;
640: WHEN error_get_trans OR error_del_trans THEN
641: NULL;
642: WHEN OTHERS THEN

Line 639: x_return_status := fnd_api.g_ret_sts_error;

635: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return_status = '||x_return_status||' and x_actual_qty='||x_actual_qty);
636: END IF;
637: EXCEPTION
638: WHEN fnd_api.g_exc_error THEN
639: x_return_status := fnd_api.g_ret_sts_error;
640: WHEN error_get_trans OR error_del_trans THEN
641: NULL;
642: WHEN OTHERS THEN
643: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 654: x_return_status := fnd_api.g_ret_sts_unexp_error;

650: || ': '
651: || SQLERRM);
652: END IF;
653:
654: x_return_status := fnd_api.g_ret_sts_unexp_error;
655: END revert_material_full;
656:
657: -- nsinghi bug#5176319. Created this proc. It will create ingredient reservation during batch/step unrelease.
658: -- Bug 6997483 01-May-2008 Archana Mundhe Added parameter transaction_id.

Line 684: x_return_status := fnd_api.g_ret_sts_success;

680: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
681: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
682: END IF;
683:
684: x_return_status := fnd_api.g_ret_sts_success;
685:
686: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
687: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'p_material_dtl_id = '
688: ||p_material_dtl_id);

Line 711: RAISE fnd_api.g_exc_error;

707:
708: IF NOT gme_material_details_dbl.fetch_row
709: (p_material_detail => l_mat_dtl_rec
710: ,x_material_detail => l_mat_dtl_rec) THEN
711: RAISE fnd_api.g_exc_error;
712: END IF;
713:
714: gme_transactions_pvt.get_mmt_transactions (
715: p_transaction_id => gme_common_pvt.g_mat_txn_hdr_tbl(cnt).txn_header_id

Line 775: x_return_status := fnd_api.g_ret_sts_success;

771: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
772: END IF;
773:
774: -- Set the return status to success initially
775: x_return_status := fnd_api.g_ret_sts_success;
776:
777: l_mmt_rec := p_mmt_rec;
778: l_mmln_tbl := p_mmln_tbl;
779: l_material_detail_rec := p_material_detail_rec;

Line 797: IF l_return_status <> fnd_api.g_ret_sts_success THEN

793: ,p_locator_id => l_mmt_rec.locator_id
794: ,p_lpn_id => l_mmt_rec.lpn_id -- Bug 6437252
795: ,p_lot_number => l_mmln_tbl (j).lot_number
796: ,x_return_status => l_return_status);
797: IF l_return_status <> fnd_api.g_ret_sts_success THEN
798: x_return_status := l_return_status;
799: -- don't error out if the reservation was not created... just set the return status
800: END IF;
801: END IF;

Line 814: IF l_return_status <> fnd_api.g_ret_sts_success THEN

810: ,p_subinventory => l_mmt_rec.subinventory_code
811: ,p_locator_id => l_mmt_rec.locator_id
812: ,p_lot_number => NULL
813: ,x_return_status => l_return_status);
814: IF l_return_status <> fnd_api.g_ret_sts_success THEN
815: x_return_status := l_return_status;
816: -- don't error out if the reservation was not created... just set the return status
817: END IF;
818: END IF;

Line 849: IF l_return_status <> fnd_api.g_ret_sts_success THEN

845: gme_pending_product_lots_pvt.create_pending_product_lot
846: (p_pending_product_lots_rec => l_pplot_rec
847: ,x_pending_product_lots_rec => l_out_pplot_rec
848: ,x_return_status => l_return_status);
849: IF l_return_status <> fnd_api.g_ret_sts_success THEN
850: x_return_status := l_return_status;
851: -- don't error out if the reservation was not created... just set the return status
852: END IF;
853: END LOOP;

Line 873: x_return_status := fnd_api.g_ret_sts_unexp_error;

869: || ': '
870: || SQLERRM);
871: END IF;
872:
873: x_return_status := fnd_api.g_ret_sts_unexp_error;
874: END create_resv_pplot;
875:
876: PROCEDURE validate_batch_for_unrelease
877: (p_batch_hdr_rec IN gme_batch_header%ROWTYPE

Line 929: x_return_status := FND_API.G_RET_STS_ERROR;

925: END IF;
926: EXCEPTION
927: WHEN error_phantom THEN
928: gme_common_pvt.log_message ('PM_INVALID_PHANTOM_ACTION');
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: WHEN error_batch_type OR error_batch_status THEN
931: gme_common_pvt.log_message('GME_API_INVALID_BATCH_UNREL');
932: x_return_status := fnd_api.g_ret_sts_error;
933: WHEN error_step_status THEN

Line 932: x_return_status := fnd_api.g_ret_sts_error;

928: gme_common_pvt.log_message ('PM_INVALID_PHANTOM_ACTION');
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: WHEN error_batch_type OR error_batch_status THEN
931: gme_common_pvt.log_message('GME_API_INVALID_BATCH_UNREL');
932: x_return_status := fnd_api.g_ret_sts_error;
933: WHEN error_step_status THEN
934: gme_common_pvt.log_message('GME_API_INVALID_STEP_UNREL');
935: x_return_status := fnd_api.g_ret_sts_error;
936: WHEN OTHERS THEN

Line 935: x_return_status := fnd_api.g_ret_sts_error;

931: gme_common_pvt.log_message('GME_API_INVALID_BATCH_UNREL');
932: x_return_status := fnd_api.g_ret_sts_error;
933: WHEN error_step_status THEN
934: gme_common_pvt.log_message('GME_API_INVALID_STEP_UNREL');
935: x_return_status := fnd_api.g_ret_sts_error;
936: WHEN OTHERS THEN
937: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
938:
939: IF g_debug <= gme_debug.g_log_procedure THEN

Line 948: x_return_status := fnd_api.g_ret_sts_unexp_error;

944: || ': '
945: || SQLERRM);
946: END IF;
947:
948: x_return_status := fnd_api.g_ret_sts_unexp_error;
949: END validate_batch_for_unrelease;
950:
951: /* Bug 5021522 added function RETURNS TRUE if inv will go negative and org control does not allow it */
952: FUNCTION check_inv_negative(p_mmt_rec IN mtl_material_transactions%ROWTYPE,