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

Line 130: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

126: l_mat_row_count NUMBER := 0;
127: l_rsc_row_count NUMBER := 0;
128: l_inv_exists NUMBER := 0;
129: l_doc_type VARCHAR2 (4);
130: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
131: l_match_rev_id NUMBER;
132: BEGIN
133: x_return_status := fnd_api.g_ret_sts_success;
134:

Line 133: x_return_status := fnd_api.g_ret_sts_success;

129: l_doc_type VARCHAR2 (4);
130: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
131: l_match_rev_id NUMBER;
132: BEGIN
133: x_return_status := fnd_api.g_ret_sts_success;
134:
135: /* Check that we have at least a BATCH ID */
136: IF ( (p_batch_row.batch_id IS NULL)
137: OR (p_batch_row.batch_id = fnd_api.g_miss_num) ) THEN

Line 137: OR (p_batch_row.batch_id = fnd_api.g_miss_num) ) THEN

133: x_return_status := fnd_api.g_ret_sts_success;
134:
135: /* Check that we have at least a BATCH ID */
136: IF ( (p_batch_row.batch_id IS NULL)
137: OR (p_batch_row.batch_id = fnd_api.g_miss_num) ) THEN
138: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
139:
140: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
141: gme_debug.put_line ( g_pkg_name

Line 173: RAISE fnd_api.g_exc_error;

169:
170: gme_common_pvt.log_message ('GME_BATCH_NON_INVENTORY'
171: ,'BATCH_NO'
172: ,p_batch_row.batch_no);
173: RAISE fnd_api.g_exc_error;
174: END IF;
175:
176: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
177: gme_debug.put_line ( g_pkg_name

Line 201: RAISE fnd_api.g_exc_error;

197: || 'No BATCH TYPE loaded');
198: END IF;
199:
200: gme_common_pvt.log_message ('INPUT_PARMS_MISS', 'PROC', l_api_name);
201: RAISE fnd_api.g_exc_error;
202: END IF;
203:
204: /* Now Validate Transactions */
205: /* Have Been Loaded */

Line 562: IF l_return_status <> fnd_api.g_ret_sts_success THEN

558: set_default_lot_for_new_batch (x_return_status => l_return_status);
559: END IF;
560:
561: --END BUG#3528006
562: IF l_return_status <> fnd_api.g_ret_sts_success THEN
563: RAISE fnd_api.g_exc_error;
564: END IF;
565: END IF; /* l_inv_exists > 0 */
566:

Line 563: RAISE fnd_api.g_exc_error;

559: END IF;
560:
561: --END BUG#3528006
562: IF l_return_status <> fnd_api.g_ret_sts_success THEN
563: RAISE fnd_api.g_exc_error;
564: END IF;
565: END IF; /* l_inv_exists > 0 */
566:
567: load_rsrc_trans (p_batch_row => p_batch_row

Line 571: IF l_return_status <> fnd_api.g_ret_sts_success THEN

567: load_rsrc_trans (p_batch_row => p_batch_row
568: ,x_rsc_row_count => l_rsc_row_count
569: ,x_return_status => l_return_status);
570:
571: IF l_return_status <> fnd_api.g_ret_sts_success THEN
572: RAISE fnd_api.g_exc_error;
573: END IF;
574:
575: /* Set Default Values for Return Parameters */

Line 572: RAISE fnd_api.g_exc_error;

568: ,x_rsc_row_count => l_rsc_row_count
569: ,x_return_status => l_return_status);
570:
571: IF l_return_status <> fnd_api.g_ret_sts_success THEN
572: RAISE fnd_api.g_exc_error;
573: END IF;
574:
575: /* Set Default Values for Return Parameters */
576: x_return_status := l_return_status;

Line 580: WHEN fnd_api.g_exc_error THEN

576: x_return_status := l_return_status;
577: x_mat_row_count := l_mat_row_count;
578: x_rsc_row_count := l_rsc_row_count;
579: EXCEPTION
580: WHEN fnd_api.g_exc_error THEN
581: x_return_status := fnd_api.g_ret_sts_error;
582: WHEN fnd_api.g_exc_unexpected_error THEN
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: WHEN OTHERS THEN

Line 581: x_return_status := fnd_api.g_ret_sts_error;

577: x_mat_row_count := l_mat_row_count;
578: x_rsc_row_count := l_rsc_row_count;
579: EXCEPTION
580: WHEN fnd_api.g_exc_error THEN
581: x_return_status := fnd_api.g_ret_sts_error;
582: WHEN fnd_api.g_exc_unexpected_error THEN
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: WHEN OTHERS THEN
585: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 582: WHEN fnd_api.g_exc_unexpected_error THEN

578: x_rsc_row_count := l_rsc_row_count;
579: EXCEPTION
580: WHEN fnd_api.g_exc_error THEN
581: x_return_status := fnd_api.g_ret_sts_error;
582: WHEN fnd_api.g_exc_unexpected_error THEN
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: WHEN OTHERS THEN
585: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
586: gme_debug.put_line ('sqlerrm=' || SQLERRM);

Line 583: x_return_status := fnd_api.g_ret_sts_unexp_error;

579: EXCEPTION
580: WHEN fnd_api.g_exc_error THEN
581: x_return_status := fnd_api.g_ret_sts_error;
582: WHEN fnd_api.g_exc_unexpected_error THEN
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: WHEN OTHERS THEN
585: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
586: gme_debug.put_line ('sqlerrm=' || SQLERRM);
587: END IF;

Line 589: x_return_status := fnd_api.g_ret_sts_unexp_error;

585: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
586: gme_debug.put_line ('sqlerrm=' || SQLERRM);
587: END IF;
588:
589: x_return_status := fnd_api.g_ret_sts_unexp_error;
590: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
591: END load_mat_and_rsc_trans;
592:
593: FUNCTION build_trans_rec (

Line 681: x_return_status := fnd_api.g_ret_sts_success;

677: resrc_revs c_get_reversal_resources%ROWTYPE;
678: mtch_resrc_revs c_get_match_reversal_resources%ROWTYPE;
679: l_return_status VARCHAR2 (1);
680: BEGIN
681: x_return_status := fnd_api.g_ret_sts_success;
682:
683: -- Detemine Transactional Doc Type
684: -- 0 - PROD 10 - FPO
685: IF (p_batch_row.batch_type = 0) THEN

Line 703: RAISE fnd_api.g_exc_error;

699: || ':'
700: || 'This should RETURN AN Expected Error');
701: END IF;
702:
703: RAISE fnd_api.g_exc_error;
704: END IF;
705:
706: OPEN c_check_rsc_transactions (p_batch_row.batch_id);
707:

Line 807: WHEN fnd_api.g_exc_error THEN

803: ELSE
804: x_rsc_row_count := l_rsc_exists;
805: END IF;
806: EXCEPTION
807: WHEN fnd_api.g_exc_error THEN
808: x_return_status := fnd_api.g_ret_sts_error;
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811: WHEN OTHERS THEN

Line 808: x_return_status := fnd_api.g_ret_sts_error;

804: x_rsc_row_count := l_rsc_exists;
805: END IF;
806: EXCEPTION
807: WHEN fnd_api.g_exc_error THEN
808: x_return_status := fnd_api.g_ret_sts_error;
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811: WHEN OTHERS THEN
812: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 809: WHEN fnd_api.g_exc_unexpected_error THEN

805: END IF;
806: EXCEPTION
807: WHEN fnd_api.g_exc_error THEN
808: x_return_status := fnd_api.g_ret_sts_error;
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811: WHEN OTHERS THEN
812: x_return_status := fnd_api.g_ret_sts_unexp_error;
813: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 810: x_return_status := fnd_api.g_ret_sts_unexp_error;

806: EXCEPTION
807: WHEN fnd_api.g_exc_error THEN
808: x_return_status := fnd_api.g_ret_sts_error;
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811: WHEN OTHERS THEN
812: x_return_status := fnd_api.g_ret_sts_unexp_error;
813: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
814: END load_rsrc_trans;

Line 812: x_return_status := fnd_api.g_ret_sts_unexp_error;

808: x_return_status := fnd_api.g_ret_sts_error;
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811: WHEN OTHERS THEN
812: x_return_status := fnd_api.g_ret_sts_unexp_error;
813: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
814: END load_rsrc_trans;
815:
816: PROCEDURE set_default_lot_for_batch (

Line 833: x_return_status := fnd_api.g_ret_sts_success;

829: l_return_status VARCHAR2 (1);
830: l_api_name CONSTANT VARCHAR2 (30) := 'SET_DEFAULT_LOT_FOR_BATCH';
831: error_fetch_def_lot_id EXCEPTION;
832: BEGIN
833: x_return_status := fnd_api.g_ret_sts_success;
834:
835: FOR get_matl_rec IN cur_get_matl (p_batch_row.batch_id) LOOP
836: get_default_lot (get_matl_rec.material_detail_id
837: ,l_def_trans_id

Line 853: x_return_status := fnd_api.g_ret_sts_unexp_error;

849: EXCEPTION
850: WHEN error_fetch_def_lot_id THEN
851: x_return_status := l_return_status;
852: WHEN OTHERS THEN
853: x_return_status := fnd_api.g_ret_sts_unexp_error;
854: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
855: END set_default_lot_for_batch;
856:
857: PROCEDURE deduce_transaction_warehouse (

Line 878: x_return_status := fnd_api.g_ret_sts_success;

874: ORDER BY whse_item_id, whse_code;
875:
876: l_api_name CONSTANT VARCHAR2 (30) := 'DEDUCE_TRANSACTION_WAREHOUSE';
877: BEGIN
878: x_return_status := fnd_api.g_ret_sts_success;
879:
880: OPEN cur_eff_whse (p_transaction.orgn_code
881: ,p_item_master.whse_item_id
882: ,p_transaction.line_type);

Line 895: x_return_status := fnd_api.g_ret_sts_unexp_error;

891: CLOSE cur_eff_whse;
892: EXCEPTION
893: WHEN OTHERS THEN
894: x_whse_code := NULL;
895: x_return_status := fnd_api.g_ret_sts_unexp_error;
896: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
897: END deduce_transaction_warehouse;
898:
899: PROCEDURE get_default_lot (

Line 952: x_return_status := fnd_api.g_ret_sts_success;

948: l_cnt NUMBER;
949: error_deduce_trans_whse EXCEPTION;
950: -- corrupt_batch EXCEPTION;
951: BEGIN
952: x_return_status := fnd_api.g_ret_sts_success;
953: l_def_lot_found := FALSE;
954: x_def_trans_id := NULL;
955:
956: SELECT *

Line 1072: --x_return_status := fnd_api.g_ret_sts_error;

1068: EXCEPTION
1069: WHEN error_deduce_trans_whse THEN
1070: x_return_status := l_return_status;
1071: --WHEN corrupt_batch THEN
1072: --x_return_status := fnd_api.g_ret_sts_error;
1073: WHEN OTHERS THEN
1074: x_return_status := fnd_api.g_ret_sts_unexp_error;
1075: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1076: END get_default_lot;

Line 1074: x_return_status := fnd_api.g_ret_sts_unexp_error;

1070: x_return_status := l_return_status;
1071: --WHEN corrupt_batch THEN
1072: --x_return_status := fnd_api.g_ret_sts_error;
1073: WHEN OTHERS THEN
1074: x_return_status := fnd_api.g_ret_sts_unexp_error;
1075: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1076: END get_default_lot;
1077:
1078: /*===========================================================================================

Line 1096: x_return_status := fnd_api.g_ret_sts_success;

1092: PROCEDURE set_default_lot_for_new_batch (x_return_status OUT NOCOPY VARCHAR2)
1093: IS
1094: l_api_name CONSTANT VARCHAR2 (30) := 'SET_DEFAULT_LOT_FOR_NEW_BATCH';
1095: BEGIN
1096: x_return_status := fnd_api.g_ret_sts_success;
1097:
1098: UPDATE gme_inventory_txns_gtmp g
1099: SET def_trans_ind = 1
1100: WHERE trans_id = (SELECT MIN (trans_id)

Line 1105: x_return_status := fnd_api.g_ret_sts_unexp_error;

1101: FROM gme_inventory_txns_gtmp
1102: WHERE material_detail_id = g.material_detail_id);
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: x_return_status := fnd_api.g_ret_sts_unexp_error;
1106: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1107: END set_default_lot_for_new_batch;
1108: END gme_trans_engine_util;