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

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

Line 153: x_return_status := fnd_api.g_ret_sts_error;

149: x_material_tbl => x_material_tbl
150: ,x_return_status => x_return_status);
151: EXCEPTION
152: WHEN sum_qty_zero OR step_closed_err THEN
153: x_return_status := fnd_api.g_ret_sts_error;
154: WHEN OTHERS THEN
155: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
156: x_return_status := fnd_api.g_ret_sts_unexp_error;
157: END scale_batch;

Line 156: x_return_status := fnd_api.g_ret_sts_unexp_error;

152: WHEN sum_qty_zero OR step_closed_err THEN
153: x_return_status := fnd_api.g_ret_sts_error;
154: WHEN OTHERS THEN
155: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
156: x_return_status := fnd_api.g_ret_sts_unexp_error;
157: END scale_batch;
158:
159: /* This procedure is over-loaded, so that user can
160: either call it with Just the batch_header or

Line 296: x_return_status := fnd_api.g_ret_sts_success;

292: WHERE EXISTS (SELECT 1
293: FROM gme_batch_step_charges
294: WHERE batch_id = v_batch_id);
295: BEGIN
296: x_return_status := fnd_api.g_ret_sts_success;
297:
298: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
299: gme_debug.put_line ('Scale factor is ' || p_scale_factor);
300: END IF;

Line 505: IF x_return_status = fnd_api.g_ret_sts_success THEN

501: ,x_scale_tab => x_scale_tab
502: ,x_return_status => x_return_status);
503: l_total_prim_prod_qty := 0;
504:
505: IF x_return_status = fnd_api.g_ret_sts_success THEN
506: FOR l_row_number IN 1 .. l_row_count LOOP
507: /* Check that scaled quantity is within validity rules */
508: IF l_enforce_vldt_check = 'T' THEN
509: IF p_material_tbl (l_row_number).inventory_item_id =

Line 586: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

582: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
583: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Relieve_Prod_Supply_Resv returns '||x_return_status);
584: END IF;
585:
586: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
587: RAISE reduce_reservation_fail;
588: END IF;
589: END IF;
590: -- 4944024 END

Line 659: IF x_return_status <> fnd_api.g_ret_sts_success THEN

655: (x_return_status => x_return_status
656: ,x_rsc_row_count => l_rsc_row_count
657: ,p_batch_row => p_batch_header_rec);
658:
659: IF x_return_status <> fnd_api.g_ret_sts_success THEN
660: RAISE load_trans_failed;
661: END IF;
662:
663: /* Update POC Data if steps are associated to a material line */

Line 705: IF x_return_status <> fnd_api.g_ret_sts_success THEN

701: (p_batch_id => l_batch_header.batch_id
702: ,p_routing_scale_factor => l_routing_scale_factor
703: ,x_return_status => x_return_status);
704:
705: IF x_return_status <> fnd_api.g_ret_sts_success THEN
706: RAISE scale_step_and_rsrc_error;
707: END IF;
708: END IF; /* automatic_step_calculation */
709: END IF; /* for new batch*/

Line 712: IF x_return_status <> fnd_api.g_ret_sts_success THEN

708: END IF; /* automatic_step_calculation */
709: END IF; /* for new batch*/
710:
711: /* Handling return status */
712: IF x_return_status <> fnd_api.g_ret_sts_success THEN
713: RAISE trans_qty_err;
714: END IF;
715:
716: FOR line_index IN 1 .. x_material_tbl.COUNT LOOP

Line 765: IF l_return_status <> fnd_api.g_ret_sts_success THEN

761: , -- Navin
762: x_return_status => l_return_status);
763:
764: /* Handling return status */
765: IF l_return_status <> fnd_api.g_ret_sts_success THEN
766: RAISE scale_phant_fail;
767: END IF;
768: END IF;
769: /* IF NVL (x_material_tbl (line_index).phantom_id, 0) > 0 AND */

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

768: END IF;
769: /* IF NVL (x_material_tbl (line_index).phantom_id, 0) > 0 AND */
770: END LOOP; /* FOR line_index IN 1 .. x_material_tbl.COUNT */
771: END IF; /* IF l_batch_header.batch_id IS NOT NULL THEN */
772: ELSE /* IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN */
773: RAISE scale_batch_failed;
774: END IF;
775:
776: /****

Line 784: AND p_use_workday_cal = fnd_api.g_true THEN

780: IF p_recalc_dates = 'T' THEN
781: l_use_workday_cal := p_use_workday_cal;
782:
783: IF gme_common_pvt.g_calendar_code IS NULL
784: AND p_use_workday_cal = fnd_api.g_true THEN
785: gme_common_pvt.log_message ('GME_NO_WORKDAY_CAL_ASSOCIATED');
786: -- Navin: PENDING: NEW MESSAGE TO BE REGISTERED. Workday calendar is not associated to the organization.
787: l_use_workday_cal := fnd_api.g_false;
788: -- workday_cal cannot be used.

Line 787: l_use_workday_cal := fnd_api.g_false;

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

Line 810: IF l_return_status <> fnd_api.g_ret_sts_success THEN

806: ,x_batch_header_rec => x_batch_header_rec
807: ,x_return_status => l_return_status);
808:
809: -- Check return status and raise error if needed.
810: IF l_return_status <> fnd_api.g_ret_sts_success THEN
811: RAISE reschedule_batch_fail;
812: END IF;
813: END IF; /* parentline_id IS NOT NULL THEN */
814: END IF; /* IF P_recalc_dates = 1 THEN */

Line 938: x_return_status := fnd_api.g_ret_sts_error;

934: END IF;
935: END IF; -- IF p_batch_header_rec.batch_status = 0
936: EXCEPTION
937: WHEN invalid_status OR expected_error THEN
938: x_return_status := fnd_api.g_ret_sts_error;
939: WHEN invalid_validity_rule OR scale_step_and_rsrc_error THEN
940: x_return_status := fnd_api.g_ret_sts_error;
941: WHEN batch_fetch_error THEN
942: x_return_status := fnd_api.g_ret_sts_error;

Line 940: x_return_status := fnd_api.g_ret_sts_error;

936: EXCEPTION
937: WHEN invalid_status OR expected_error THEN
938: x_return_status := fnd_api.g_ret_sts_error;
939: WHEN invalid_validity_rule OR scale_step_and_rsrc_error THEN
940: x_return_status := fnd_api.g_ret_sts_error;
941: WHEN batch_fetch_error THEN
942: x_return_status := fnd_api.g_ret_sts_error;
943: WHEN scale_phant_fail THEN
944: x_return_status := l_return_status;

Line 942: x_return_status := fnd_api.g_ret_sts_error;

938: x_return_status := fnd_api.g_ret_sts_error;
939: WHEN invalid_validity_rule OR scale_step_and_rsrc_error THEN
940: x_return_status := fnd_api.g_ret_sts_error;
941: WHEN batch_fetch_error THEN
942: x_return_status := fnd_api.g_ret_sts_error;
943: WHEN scale_phant_fail THEN
944: x_return_status := l_return_status;
945: 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
946: x_return_status := fnd_api.g_ret_sts_error;

Line 946: x_return_status := fnd_api.g_ret_sts_error;

942: x_return_status := fnd_api.g_ret_sts_error;
943: WHEN scale_phant_fail THEN
944: x_return_status := l_return_status;
945: 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
946: x_return_status := fnd_api.g_ret_sts_error;
947: WHEN clear_chg_error THEN
948: x_return_status := fnd_api.g_ret_sts_error;
949: WHEN reduce_reservation_fail THEN -- 4944024
950: x_return_status := fnd_api.g_ret_sts_error; -- 4944024

Line 948: x_return_status := fnd_api.g_ret_sts_error;

944: x_return_status := l_return_status;
945: 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
946: x_return_status := fnd_api.g_ret_sts_error;
947: WHEN clear_chg_error THEN
948: x_return_status := fnd_api.g_ret_sts_error;
949: WHEN reduce_reservation_fail THEN -- 4944024
950: x_return_status := fnd_api.g_ret_sts_error; -- 4944024
951: WHEN trans_qty_err THEN
952: gme_common_pvt.log_message ('GME_SCALE_UNMATCH_ALLOC');

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

946: x_return_status := fnd_api.g_ret_sts_error;
947: WHEN clear_chg_error THEN
948: x_return_status := fnd_api.g_ret_sts_error;
949: WHEN reduce_reservation_fail THEN -- 4944024
950: x_return_status := fnd_api.g_ret_sts_error; -- 4944024
951: WHEN trans_qty_err THEN
952: gme_common_pvt.log_message ('GME_SCALE_UNMATCH_ALLOC');
953: WHEN uom_conversion_error THEN
954: OPEN cur_item_no (l_item_id, p_batch_header_rec.organization_id);

Line 970: x_return_status := fnd_api.g_ret_sts_unexp_error;

966: WHEN reschedule_batch_fail THEN
967: x_return_status := 'C';
968: WHEN OTHERS THEN
969: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
970: x_return_status := fnd_api.g_ret_sts_unexp_error;
971: END scale_batch;
972:
973: PROCEDURE theoretical_yield_batch (
974: p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 1051: x_return_status := fnd_api.g_ret_sts_success;

1047: ,l_batch_header) ) THEN
1048: RAISE batch_fetch_error;
1049: END IF;
1050:
1051: x_return_status := fnd_api.g_ret_sts_success;
1052:
1053: OPEN cur_batch_materials (p_batch_header_rec.batch_id);
1054:
1055: FETCH cur_batch_materials

Line 1120: IF x_return_status = fnd_api.g_ret_sts_success THEN

1116: ,x_scale_tab => l_scale_tab
1117: ,p_scale_factor => l_scale_factor
1118: ,x_return_status => x_return_status);
1119:
1120: IF x_return_status = fnd_api.g_ret_sts_success THEN
1121: x_material_details := l_material_details;
1122:
1123: FOR i IN 1 .. l_material_details.COUNT LOOP
1124: IF l_batch_header.batch_status = 1 THEN

Line 1156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1152: ,x_msg_count => l_message_count
1153: ,x_msg_data => l_message_list
1154: ,x_return_status => x_return_status);
1155:
1156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1157: RAISE reduce_reservation_fail;
1158: END IF;
1159: END IF;
1160: -- 4944024 END

Line 1215: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1211: (p_batch_id => l_batch_header.batch_id
1212: ,p_routing_scale_factor => l_routing_scale_factor
1213: ,x_return_status => x_return_status);
1214:
1215: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1216: RAISE scale_step_and_rsrc_error;
1217: END IF;
1218: END IF; /* automatic_step_calculation */
1219: END IF; /* for new batch*/

Line 1221: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1217: END IF;
1218: END IF; /* automatic_step_calculation */
1219: END IF; /* for new batch*/
1220:
1221: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1222: RAISE trans_qty_err;
1223: END IF;
1224: END IF;
1225:

Line 1267: x_return_status := fnd_api.g_ret_sts_error;

1263: END 17Feb05 Navin Sinha Made changes for GME_Scale_Batch_Theoretical_Yield_TD.
1264: *****/
1265: EXCEPTION
1266: WHEN batch_fetch_error OR material_fetch_err OR material_save_failed OR batch_step_fetch_err THEN
1267: x_return_status := fnd_api.g_ret_sts_error;
1268: WHEN step_closed_err OR scale_step_and_rsrc_error OR error_updating_steps THEN
1269: x_return_status := fnd_api.g_ret_sts_error;
1270: WHEN trans_qty_err THEN
1271: gme_common_pvt.log_message ('GME_THEOYLD_UNMATCH_ALLOC');

Line 1269: x_return_status := fnd_api.g_ret_sts_error;

1265: EXCEPTION
1266: WHEN batch_fetch_error OR material_fetch_err OR material_save_failed OR batch_step_fetch_err THEN
1267: x_return_status := fnd_api.g_ret_sts_error;
1268: WHEN step_closed_err OR scale_step_and_rsrc_error OR error_updating_steps THEN
1269: x_return_status := fnd_api.g_ret_sts_error;
1270: WHEN trans_qty_err THEN
1271: gme_common_pvt.log_message ('GME_THEOYLD_UNMATCH_ALLOC');
1272: WHEN reduce_reservation_fail THEN -- 4944024
1273: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

Line 1278: x_return_status := fnd_api.g_ret_sts_unexp_error;

1274: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Failure after relieve_prod_supply_resv ');
1275: END IF;
1276: WHEN OTHERS THEN
1277: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1278: x_return_status := fnd_api.g_ret_sts_unexp_error;
1279: END theoretical_yield_batch;
1280:
1281: FUNCTION get_total_qty (
1282: p_material_tab IN gme_common_pvt.material_details_tab

Line 1316: x_return_status := fnd_api.g_ret_sts_success;

1312: l_um_type sy_uoms_typ.um_type%TYPE;
1313: bad_yield_type EXCEPTION;
1314: l_batch_header gme_batch_header%ROWTYPE;
1315: BEGIN
1316: x_return_status := fnd_api.g_ret_sts_success;
1317: --l_um_type := fnd_profile.VALUE ('FM_YIELD_TYPE');
1318: l_batch_header := p_batch_header_rec;
1319:
1320: OPEN get_rout_uom (l_batch_header.batch_id);

Line 1456: x_return_status := fnd_api.g_ret_sts_success;

1452: l_cur_get_all_steps cur_get_all_steps%ROWTYPE;
1453: l_cur_get_res cur_get_res%ROWTYPE;
1454: l_cur_get_res_txns cur_get_res_txns%ROWTYPE;
1455: BEGIN
1456: x_return_status := fnd_api.g_ret_sts_success;
1457:
1458: OPEN cur_get_batch_info;
1459:
1460: FETCH cur_get_batch_info

Line 1595: x_return_status := fnd_api.g_ret_sts_error;

1591: END IF; /* IF l_batch_step.step_status = 1 THEN */
1592: END LOOP;
1593: EXCEPTION
1594: WHEN error_updating_steps OR activity_rsrc_fetch_error OR update_res_error OR batch_step_fetch_err THEN
1595: x_return_status := fnd_api.g_ret_sts_error;
1596: WHEN error_updating_step_qty OR update_res_txn_error THEN
1597: x_return_status := l_return_status;
1598: WHEN OTHERS THEN
1599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1605: x_return_status := fnd_api.g_ret_sts_unexp_error;

1601: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1602: gme_debug.put_line (SQLERRM);
1603: END IF;
1604:
1605: x_return_status := fnd_api.g_ret_sts_unexp_error;
1606: END scale_step_and_rsrc;
1607: END gme_scale_batch_pvt;