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

Line 84: x_return_status := fnd_api.g_ret_sts_success;

80: l_dummy NUMBER;
81: sum_qty_zero EXCEPTION;
82: step_closed_err EXCEPTION;
83: BEGIN
84: x_return_status := fnd_api.g_ret_sts_success;
85:
86: -- fetch batch status
87: OPEN cur_get_batch_status (p_batch_header_rec.batch_id);
88:

Line 159: x_return_status := fnd_api.g_ret_sts_error;

155: x_material_tbl => x_material_tbl
156: ,x_return_status => x_return_status);
157: EXCEPTION
158: WHEN sum_qty_zero OR step_closed_err THEN
159: x_return_status := fnd_api.g_ret_sts_error;
160: WHEN OTHERS THEN
161: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
162: x_return_status := fnd_api.g_ret_sts_unexp_error;
163: END scale_batch;

Line 162: x_return_status := fnd_api.g_ret_sts_unexp_error;

158: WHEN sum_qty_zero OR step_closed_err THEN
159: x_return_status := fnd_api.g_ret_sts_error;
160: WHEN OTHERS THEN
161: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
162: x_return_status := fnd_api.g_ret_sts_unexp_error;
163: END scale_batch;
164:
165: /* This procedure is over-loaded, so that user can
166: either call it with Just the batch_header or

Line 302: x_return_status := fnd_api.g_ret_sts_success;

298: WHERE EXISTS (SELECT 1
299: FROM gme_batch_step_charges
300: WHERE batch_id = v_batch_id);
301: BEGIN
302: x_return_status := fnd_api.g_ret_sts_success;
303:
304: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
305: gme_debug.put_line ('Scale factor is ' || p_scale_factor);
306: END IF;

Line 511: IF x_return_status = fnd_api.g_ret_sts_success THEN

507: ,x_scale_tab => x_scale_tab
508: ,x_return_status => x_return_status);
509: l_total_prim_prod_qty := 0;
510:
511: IF x_return_status = fnd_api.g_ret_sts_success THEN
512: FOR l_row_number IN 1 .. l_row_count LOOP
513: /* Check that scaled quantity is within validity rules */
514: IF l_enforce_vldt_check = 'T' THEN
515: IF p_material_tbl (l_row_number).inventory_item_id =

Line 592: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

588: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Relieve_Prod_Supply_Resv returns '||x_return_status);
590: END IF;
591:
592: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
593: RAISE reduce_reservation_fail;
594: END IF;
595: END IF;
596: -- 4944024 END

Line 665: IF x_return_status <> fnd_api.g_ret_sts_success THEN

661: (x_return_status => x_return_status
662: ,x_rsc_row_count => l_rsc_row_count
663: ,p_batch_row => p_batch_header_rec);
664:
665: IF x_return_status <> fnd_api.g_ret_sts_success THEN
666: RAISE load_trans_failed;
667: END IF;
668:
669: /* Update POC Data if steps are associated to a material line */

Line 711: IF x_return_status <> fnd_api.g_ret_sts_success THEN

707: (p_batch_id => l_batch_header.batch_id
708: ,p_routing_scale_factor => l_routing_scale_factor
709: ,x_return_status => x_return_status);
710:
711: IF x_return_status <> fnd_api.g_ret_sts_success THEN
712: RAISE scale_step_and_rsrc_error;
713: END IF;
714: END IF; /* automatic_step_calculation */
715: END IF; /* for new batch*/

Line 718: IF x_return_status <> fnd_api.g_ret_sts_success THEN

714: END IF; /* automatic_step_calculation */
715: END IF; /* for new batch*/
716:
717: /* Handling return status */
718: IF x_return_status <> fnd_api.g_ret_sts_success THEN
719: RAISE trans_qty_err;
720: END IF;
721:
722: FOR line_index IN 1 .. x_material_tbl.COUNT LOOP

Line 771: IF l_return_status <> fnd_api.g_ret_sts_success THEN

767: , -- Navin
768: x_return_status => l_return_status);
769:
770: /* Handling return status */
771: IF l_return_status <> fnd_api.g_ret_sts_success THEN
772: RAISE scale_phant_fail;
773: END IF;
774: END IF;
775: /* IF NVL (x_material_tbl (line_index).phantom_id, 0) > 0 AND */

Line 778: ELSE /* IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN */

774: END IF;
775: /* IF NVL (x_material_tbl (line_index).phantom_id, 0) > 0 AND */
776: END LOOP; /* FOR line_index IN 1 .. x_material_tbl.COUNT */
777: END IF; /* IF l_batch_header.batch_id IS NOT NULL THEN */
778: ELSE /* IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN */
779: RAISE scale_batch_failed;
780: END IF;
781:
782: /****

Line 790: AND p_use_workday_cal = fnd_api.g_true THEN

786: IF p_recalc_dates = 'T' THEN
787: l_use_workday_cal := p_use_workday_cal;
788:
789: IF gme_common_pvt.g_calendar_code IS NULL
790: AND p_use_workday_cal = fnd_api.g_true THEN
791: gme_common_pvt.log_message ('GME_NO_WORKDAY_CAL_ASSOCIATED');
792: -- Navin: PENDING: NEW MESSAGE TO BE REGISTERED. Workday calendar is not associated to the organization.
793: l_use_workday_cal := fnd_api.g_false;
794: -- workday_cal cannot be used.

Line 793: l_use_workday_cal := fnd_api.g_false;

789: IF gme_common_pvt.g_calendar_code IS NULL
790: AND p_use_workday_cal = fnd_api.g_true THEN
791: gme_common_pvt.log_message ('GME_NO_WORKDAY_CAL_ASSOCIATED');
792: -- Navin: PENDING: NEW MESSAGE TO BE REGISTERED. Workday calendar is not associated to the organization.
793: l_use_workday_cal := fnd_api.g_false;
794: -- workday_cal cannot be used.
795: END IF;
796: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
797: gme_debug.put_line('calling reschedule_batch'||p_batch_header_rec.batch_id);

Line 820: IF l_return_status <> fnd_api.g_ret_sts_success THEN

816: ,x_batch_header_rec => x_batch_header_rec
817: ,x_return_status => l_return_status);
818:
819: -- Check return status and raise error if needed.
820: IF l_return_status <> fnd_api.g_ret_sts_success THEN
821: RAISE reschedule_batch_fail;
822: END IF;
823: END IF; /* parentline_id IS NOT NULL THEN */
824: END IF; /* IF P_recalc_dates = 1 THEN */

Line 948: x_return_status := fnd_api.g_ret_sts_error;

944: END IF;
945: END IF; -- IF p_batch_header_rec.batch_status = 0
946: EXCEPTION
947: WHEN invalid_status OR expected_error THEN
948: x_return_status := fnd_api.g_ret_sts_error;
949: WHEN invalid_validity_rule OR scale_step_and_rsrc_error THEN
950: x_return_status := fnd_api.g_ret_sts_error;
951: WHEN batch_fetch_error THEN
952: x_return_status := fnd_api.g_ret_sts_error;

Line 950: x_return_status := fnd_api.g_ret_sts_error;

946: EXCEPTION
947: WHEN invalid_status OR expected_error THEN
948: x_return_status := fnd_api.g_ret_sts_error;
949: WHEN invalid_validity_rule OR scale_step_and_rsrc_error THEN
950: x_return_status := fnd_api.g_ret_sts_error;
951: WHEN batch_fetch_error THEN
952: x_return_status := fnd_api.g_ret_sts_error;
953: WHEN scale_phant_fail THEN
954: x_return_status := l_return_status;

Line 952: x_return_status := fnd_api.g_ret_sts_error;

948: x_return_status := fnd_api.g_ret_sts_error;
949: WHEN invalid_validity_rule OR scale_step_and_rsrc_error THEN
950: x_return_status := fnd_api.g_ret_sts_error;
951: WHEN batch_fetch_error THEN
952: x_return_status := fnd_api.g_ret_sts_error;
953: WHEN scale_phant_fail THEN
954: x_return_status := l_return_status;
955: WHEN scale_batch_failed OR load_trans_failed OR error_upd_default_tran OR error_updating_steps OR batch_step_fetch_err OR material_save_failed THEN
956: x_return_status := fnd_api.g_ret_sts_error;

Line 956: x_return_status := fnd_api.g_ret_sts_error;

952: x_return_status := fnd_api.g_ret_sts_error;
953: WHEN scale_phant_fail THEN
954: x_return_status := l_return_status;
955: WHEN scale_batch_failed OR load_trans_failed OR error_upd_default_tran OR error_updating_steps OR batch_step_fetch_err OR material_save_failed THEN
956: x_return_status := fnd_api.g_ret_sts_error;
957: WHEN clear_chg_error THEN
958: x_return_status := fnd_api.g_ret_sts_error;
959: WHEN reduce_reservation_fail THEN -- 4944024
960: x_return_status := fnd_api.g_ret_sts_error; -- 4944024

Line 958: x_return_status := fnd_api.g_ret_sts_error;

954: x_return_status := l_return_status;
955: WHEN scale_batch_failed OR load_trans_failed OR error_upd_default_tran OR error_updating_steps OR batch_step_fetch_err OR material_save_failed THEN
956: x_return_status := fnd_api.g_ret_sts_error;
957: WHEN clear_chg_error THEN
958: x_return_status := fnd_api.g_ret_sts_error;
959: WHEN reduce_reservation_fail THEN -- 4944024
960: x_return_status := fnd_api.g_ret_sts_error; -- 4944024
961: WHEN trans_qty_err THEN
962: gme_common_pvt.log_message ('GME_SCALE_UNMATCH_ALLOC');

Line 960: x_return_status := fnd_api.g_ret_sts_error; -- 4944024

956: x_return_status := fnd_api.g_ret_sts_error;
957: WHEN clear_chg_error THEN
958: x_return_status := fnd_api.g_ret_sts_error;
959: WHEN reduce_reservation_fail THEN -- 4944024
960: x_return_status := fnd_api.g_ret_sts_error; -- 4944024
961: WHEN trans_qty_err THEN
962: gme_common_pvt.log_message ('GME_SCALE_UNMATCH_ALLOC');
963: WHEN uom_conversion_error THEN
964: OPEN cur_item_no (l_item_id, p_batch_header_rec.organization_id);

Line 980: x_return_status := fnd_api.g_ret_sts_unexp_error;

976: WHEN reschedule_batch_fail THEN
977: x_return_status := 'C';
978: WHEN OTHERS THEN
979: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: END scale_batch;
982:
983: PROCEDURE theoretical_yield_batch (
984: p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 1061: x_return_status := fnd_api.g_ret_sts_success;

1057: ,l_batch_header) ) THEN
1058: RAISE batch_fetch_error;
1059: END IF;
1060:
1061: x_return_status := fnd_api.g_ret_sts_success;
1062:
1063: OPEN cur_batch_materials (p_batch_header_rec.batch_id);
1064:
1065: FETCH cur_batch_materials

Line 1130: IF x_return_status = fnd_api.g_ret_sts_success THEN

1126: ,x_scale_tab => l_scale_tab
1127: ,p_scale_factor => l_scale_factor
1128: ,x_return_status => x_return_status);
1129:
1130: IF x_return_status = fnd_api.g_ret_sts_success THEN
1131: x_material_details := l_material_details;
1132:
1133: FOR i IN 1 .. l_material_details.COUNT LOOP
1134: IF l_batch_header.batch_status = 1 THEN

Line 1166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1162: ,x_msg_count => l_message_count
1163: ,x_msg_data => l_message_list
1164: ,x_return_status => x_return_status);
1165:
1166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1167: RAISE reduce_reservation_fail;
1168: END IF;
1169: END IF;
1170: -- 4944024 END

Line 1225: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1221: (p_batch_id => l_batch_header.batch_id
1222: ,p_routing_scale_factor => l_routing_scale_factor
1223: ,x_return_status => x_return_status);
1224:
1225: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1226: RAISE scale_step_and_rsrc_error;
1227: END IF;
1228: END IF; /* automatic_step_calculation */
1229: END IF; /* for new batch*/

Line 1231: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1227: END IF;
1228: END IF; /* automatic_step_calculation */
1229: END IF; /* for new batch*/
1230:
1231: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1232: RAISE trans_qty_err;
1233: END IF;
1234: END IF;
1235:

Line 1277: x_return_status := fnd_api.g_ret_sts_error;

1273: END 17Feb05 Navin Sinha Made changes for GME_Scale_Batch_Theoretical_Yield_TD.
1274: *****/
1275: EXCEPTION
1276: WHEN batch_fetch_error OR material_fetch_err OR material_save_failed OR batch_step_fetch_err THEN
1277: x_return_status := fnd_api.g_ret_sts_error;
1278: WHEN step_closed_err OR scale_step_and_rsrc_error OR error_updating_steps THEN
1279: x_return_status := fnd_api.g_ret_sts_error;
1280: WHEN trans_qty_err THEN
1281: gme_common_pvt.log_message ('GME_THEOYLD_UNMATCH_ALLOC');

Line 1279: x_return_status := fnd_api.g_ret_sts_error;

1275: EXCEPTION
1276: WHEN batch_fetch_error OR material_fetch_err OR material_save_failed OR batch_step_fetch_err THEN
1277: x_return_status := fnd_api.g_ret_sts_error;
1278: WHEN step_closed_err OR scale_step_and_rsrc_error OR error_updating_steps THEN
1279: x_return_status := fnd_api.g_ret_sts_error;
1280: WHEN trans_qty_err THEN
1281: gme_common_pvt.log_message ('GME_THEOYLD_UNMATCH_ALLOC');
1282: WHEN reduce_reservation_fail THEN -- 4944024
1283: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

Line 1288: x_return_status := fnd_api.g_ret_sts_unexp_error;

1284: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Failure after relieve_prod_supply_resv ');
1285: END IF;
1286: WHEN OTHERS THEN
1287: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1288: x_return_status := fnd_api.g_ret_sts_unexp_error;
1289: END theoretical_yield_batch;
1290:
1291: FUNCTION get_total_qty (
1292: p_material_tab IN gme_common_pvt.material_details_tab

Line 1326: x_return_status := fnd_api.g_ret_sts_success;

1322: l_um_type sy_uoms_typ.um_type%TYPE;
1323: bad_yield_type EXCEPTION;
1324: l_batch_header gme_batch_header%ROWTYPE;
1325: BEGIN
1326: x_return_status := fnd_api.g_ret_sts_success;
1327: --l_um_type := fnd_profile.VALUE ('FM_YIELD_TYPE');
1328: l_batch_header := p_batch_header_rec;
1329:
1330: OPEN get_rout_uom (l_batch_header.batch_id);

Line 1466: x_return_status := fnd_api.g_ret_sts_success;

1462: l_cur_get_all_steps cur_get_all_steps%ROWTYPE;
1463: l_cur_get_res cur_get_res%ROWTYPE;
1464: l_cur_get_res_txns cur_get_res_txns%ROWTYPE;
1465: BEGIN
1466: x_return_status := fnd_api.g_ret_sts_success;
1467:
1468: OPEN cur_get_batch_info;
1469:
1470: FETCH cur_get_batch_info

Line 1605: x_return_status := fnd_api.g_ret_sts_error;

1601: END IF; /* IF l_batch_step.step_status = 1 THEN */
1602: END LOOP;
1603: EXCEPTION
1604: WHEN error_updating_steps OR activity_rsrc_fetch_error OR update_res_error OR batch_step_fetch_err THEN
1605: x_return_status := fnd_api.g_ret_sts_error;
1606: WHEN error_updating_step_qty OR update_res_txn_error THEN
1607: x_return_status := l_return_status;
1608: WHEN OTHERS THEN
1609: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1615: x_return_status := fnd_api.g_ret_sts_unexp_error;

1611: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1612: gme_debug.put_line (SQLERRM);
1613: END IF;
1614:
1615: x_return_status := fnd_api.g_ret_sts_unexp_error;
1616: END scale_step_and_rsrc;
1617: END gme_scale_batch_pvt;