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

Line 103: x_return_status := fnd_api.g_ret_sts_success;

99: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
100: gme_debug.put_line ('assigning all values to x_pregen_fpo_row');
101: END IF;
102:
103: x_return_status := fnd_api.g_ret_sts_success;
104: x_pregen_fpo_row.qty_per_batch := p_batch_size;
105: x_pregen_fpo_row.batch_size_uom := p_batch_size_uom;
106: x_pregen_fpo_row.num_batches := p_num_batches;
107: x_pregen_fpo_row.validity_rule_id := p_validity_rule_id;

Line 136: x_return_status := fnd_api.g_ret_sts_error;

132: END IF;
133: EXCEPTION
134: WHEN no_null_dates THEN
135: gme_common_pvt.log_message ('GME_NO_NULL_DATES');
136: x_return_status := fnd_api.g_ret_sts_error;
137: WHEN no_populate_both_dates THEN
138: gme_common_pvt.log_message ('GME_NO_POPULATE_BOTH_DATES');
139: x_return_status := fnd_api.g_ret_sts_error;
140: WHEN invalid_batch_status THEN

Line 139: x_return_status := fnd_api.g_ret_sts_error;

135: gme_common_pvt.log_message ('GME_NO_NULL_DATES');
136: x_return_status := fnd_api.g_ret_sts_error;
137: WHEN no_populate_both_dates THEN
138: gme_common_pvt.log_message ('GME_NO_POPULATE_BOTH_DATES');
139: x_return_status := fnd_api.g_ret_sts_error;
140: WHEN invalid_batch_status THEN
141: gme_common_pvt.log_message ('GME_INV_FPO_STATUS');
142: x_return_status := fnd_api.g_ret_sts_error;
143: WHEN plan_qty_zero_err THEN

Line 142: x_return_status := fnd_api.g_ret_sts_error;

138: gme_common_pvt.log_message ('GME_NO_POPULATE_BOTH_DATES');
139: x_return_status := fnd_api.g_ret_sts_error;
140: WHEN invalid_batch_status THEN
141: gme_common_pvt.log_message ('GME_INV_FPO_STATUS');
142: x_return_status := fnd_api.g_ret_sts_error;
143: WHEN plan_qty_zero_err THEN
144: gme_common_pvt.log_message ('PM_GT_ZERO_ERR');
145: x_return_status := fnd_api.g_ret_sts_error;
146: WHEN invalid_item_item_um THEN

Line 145: x_return_status := fnd_api.g_ret_sts_error;

141: gme_common_pvt.log_message ('GME_INV_FPO_STATUS');
142: x_return_status := fnd_api.g_ret_sts_error;
143: WHEN plan_qty_zero_err THEN
144: gme_common_pvt.log_message ('PM_GT_ZERO_ERR');
145: x_return_status := fnd_api.g_ret_sts_error;
146: WHEN invalid_item_item_um THEN
147: gme_common_pvt.log_message ('GME_INVALID_ITEM_OR_ITEM_UM');
148: x_return_status := fnd_api.g_ret_sts_error;
149: WHEN no_batches THEN

Line 148: x_return_status := fnd_api.g_ret_sts_error;

144: gme_common_pvt.log_message ('PM_GT_ZERO_ERR');
145: x_return_status := fnd_api.g_ret_sts_error;
146: WHEN invalid_item_item_um THEN
147: gme_common_pvt.log_message ('GME_INVALID_ITEM_OR_ITEM_UM');
148: x_return_status := fnd_api.g_ret_sts_error;
149: WHEN no_batches THEN
150: gme_common_pvt.log_message ('PM_INV_NO_BATCHES');
151: x_return_status := fnd_api.g_ret_sts_error;
152: WHEN neg_validity_rule_id THEN

Line 151: x_return_status := fnd_api.g_ret_sts_error;

147: gme_common_pvt.log_message ('GME_INVALID_ITEM_OR_ITEM_UM');
148: x_return_status := fnd_api.g_ret_sts_error;
149: WHEN no_batches THEN
150: gme_common_pvt.log_message ('PM_INV_NO_BATCHES');
151: x_return_status := fnd_api.g_ret_sts_error;
152: WHEN neg_validity_rule_id THEN
153: gme_common_pvt.log_message ('GME_NO_NEG_VALIDITY_RULE_ID');
154: x_return_status := fnd_api.g_ret_sts_error;
155: WHEN leadtime_err THEN

Line 154: x_return_status := fnd_api.g_ret_sts_error;

150: gme_common_pvt.log_message ('PM_INV_NO_BATCHES');
151: x_return_status := fnd_api.g_ret_sts_error;
152: WHEN neg_validity_rule_id THEN
153: gme_common_pvt.log_message ('GME_NO_NEG_VALIDITY_RULE_ID');
154: x_return_status := fnd_api.g_ret_sts_error;
155: WHEN leadtime_err THEN
156: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
157: x_return_status := fnd_api.g_ret_sts_error;
158: WHEN batch_offset_err THEN

Line 157: x_return_status := fnd_api.g_ret_sts_error;

153: gme_common_pvt.log_message ('GME_NO_NEG_VALIDITY_RULE_ID');
154: x_return_status := fnd_api.g_ret_sts_error;
155: WHEN leadtime_err THEN
156: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
157: x_return_status := fnd_api.g_ret_sts_error;
158: WHEN batch_offset_err THEN
159: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
160: x_return_status := fnd_api.g_ret_sts_error;
161: WHEN offset_type_err THEN

Line 160: x_return_status := fnd_api.g_ret_sts_error;

156: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
157: x_return_status := fnd_api.g_ret_sts_error;
158: WHEN batch_offset_err THEN
159: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
160: x_return_status := fnd_api.g_ret_sts_error;
161: WHEN offset_type_err THEN
162: gme_common_pvt.log_message ('PM_OFFSET_TYPE_ERR');
163: x_return_status := fnd_api.g_ret_sts_error;
164: WHEN OTHERS THEN

Line 163: x_return_status := fnd_api.g_ret_sts_error;

159: gme_common_pvt.log_message ('PM_LESSTHAN_ZERO_ERR');
160: x_return_status := fnd_api.g_ret_sts_error;
161: WHEN offset_type_err THEN
162: gme_common_pvt.log_message ('PM_OFFSET_TYPE_ERR');
163: x_return_status := fnd_api.g_ret_sts_error;
164: WHEN OTHERS THEN
165: x_return_status := fnd_api.g_ret_sts_unexp_error;
166: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'validation');
167: END VALIDATION;

Line 165: x_return_status := fnd_api.g_ret_sts_unexp_error;

161: WHEN offset_type_err THEN
162: gme_common_pvt.log_message ('PM_OFFSET_TYPE_ERR');
163: x_return_status := fnd_api.g_ret_sts_error;
164: WHEN OTHERS THEN
165: x_return_status := fnd_api.g_ret_sts_unexp_error;
166: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'validation');
167: END VALIDATION;
168:
169: --*************************************************************

Line 253: x_return_status := fnd_api.g_ret_sts_success;

249: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
250: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
251: || l_api_name);
252: END IF;
253: x_return_status := fnd_api.g_ret_sts_success;
254: l_pregen_fpo_row := p_pregen_fpo_row;
255: --Retrieve fpo_header into local fpo_header_rec structure.
256: l_return :=
257: gme_batch_header_dbl.fetch_row (p_fpo_header_row, x_fpo_header_row);

Line 406: x_return_status := fnd_api.g_ret_sts_error;

402: gme_debug.put_line ('no fetch material_details');
403: END IF;
404:
405: gme_common_pvt.log_message ('PM_NO_MATL_DTL');
406: x_return_status := fnd_api.g_ret_sts_error;
407: WHEN batch_fetch_error THEN
408: x_return_status := fnd_api.g_ret_sts_error;
409: WHEN OTHERS THEN
410: gme_debug.put_line ('Exception in api ' || g_pkg_name || '.' || l_api_name);

Line 408: x_return_status := fnd_api.g_ret_sts_error;

404:
405: gme_common_pvt.log_message ('PM_NO_MATL_DTL');
406: x_return_status := fnd_api.g_ret_sts_error;
407: WHEN batch_fetch_error THEN
408: x_return_status := fnd_api.g_ret_sts_error;
409: WHEN OTHERS THEN
410: gme_debug.put_line ('Exception in api ' || g_pkg_name || '.' || l_api_name);
411: x_return_status := fnd_api.g_ret_sts_unexp_error;
412: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'retrieve_fpo_data');

Line 411: x_return_status := fnd_api.g_ret_sts_unexp_error;

407: WHEN batch_fetch_error THEN
408: x_return_status := fnd_api.g_ret_sts_error;
409: WHEN OTHERS THEN
410: gme_debug.put_line ('Exception in api ' || g_pkg_name || '.' || l_api_name);
411: x_return_status := fnd_api.g_ret_sts_unexp_error;
412: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'retrieve_fpo_data');
413: END retrieve_fpo_data;
414:
415: --*************************************************************

Line 431: x_return_status := fnd_api.g_ret_sts_success;

427: || l_api_name);
428: END IF;
429:
430: x_pregen_fpo_row := p_pregen_fpo_row;
431: x_return_status := fnd_api.g_ret_sts_success;
432:
433: IF ( p_pregen_fpo_row.variable_leadtime = 0
434: OR p_pregen_fpo_row.std_qty = 0) THEN
435: x_pregen_fpo_row.leadtime := p_pregen_fpo_row.fixed_leadtime;

Line 450: x_return_status := fnd_api.g_ret_sts_unexp_error;

446: END IF;
447: EXCEPTION
448: WHEN OTHERS THEN
449: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
450: x_return_status := fnd_api.g_ret_sts_unexp_error;
451: --End Bug2804440
452: END calculate_leadtime;
453:
454: --*************************************************************

Line 773: x_return_status := fnd_api.g_ret_sts_success;

769: ,'MM/DD/YYYY hh24:mi:ss') );
770: END IF;
771:
772: x_generated_pre_batch_tab (i) := l_generated_pre_batch_tab (i);
773: x_return_status := fnd_api.g_ret_sts_success;
774: END LOOP;
775:
776: IF x_return_status <> fnd_api.g_ret_sts_success THEN
777: RAISE generate_pre_batch_err;

Line 776: IF x_return_status <> fnd_api.g_ret_sts_success THEN

772: x_generated_pre_batch_tab (i) := l_generated_pre_batch_tab (i);
773: x_return_status := fnd_api.g_ret_sts_success;
774: END LOOP;
775:
776: IF x_return_status <> fnd_api.g_ret_sts_success THEN
777: RAISE generate_pre_batch_err;
778: END IF;
779:
780: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 791: x_return_status := fnd_api.g_ret_sts_error;

787: ('problem generateing the pre_batch-header recs');
788: END IF;
789:
790: gme_common_pvt.log_message ('GEN_PRE_BATCH_HEADER_ERR');
791: x_return_status := fnd_api.g_ret_sts_error;
792: WHEN OTHERS THEN
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
795: ,'generate_pre_batch_header_recs');

Line 793: x_return_status := fnd_api.g_ret_sts_unexp_error;

789:
790: gme_common_pvt.log_message ('GEN_PRE_BATCH_HEADER_ERR');
791: x_return_status := fnd_api.g_ret_sts_error;
792: WHEN OTHERS THEN
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
795: ,'generate_pre_batch_header_recs');
796: END generate_pre_batch_header_recs;
797:

Line 808: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false

804: ,x_generated_pre_batch_tab OUT NOCOPY generated_pre_batch_tab
805: ,x_return_status OUT NOCOPY VARCHAR2
806: ,x_arr_rtn_sts OUT NOCOPY return_array_sts
807: ,p_process_row IN NUMBER DEFAULT 0
808: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
809: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
810: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
811: ,p_fpo_validity_rule_id IN NUMBER --BUG#3185748 Sastry
812: )

Line 809: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true

805: ,x_return_status OUT NOCOPY VARCHAR2
806: ,x_arr_rtn_sts OUT NOCOPY return_array_sts
807: ,p_process_row IN NUMBER DEFAULT 0
808: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
809: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
810: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
811: ,p_fpo_validity_rule_id IN NUMBER --BUG#3185748 Sastry
812: )
813: IS

Line 857: x_return_status := fnd_api.g_ret_sts_success;

853: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
854: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
855: || l_api_name);
856: END IF;
857: x_return_status := fnd_api.g_ret_sts_success;
858: dummy := 0;
859: l_validation_level := gme_common_pvt.g_max_errors;
860: l_api_version := 2.0;
861: l_generated_pre_batch_tab := p_generated_pre_batch_tab;

Line 1000: IF l_return_status <> fnd_api.g_ret_sts_success THEN

996: l_api_name ||
997: ' create_batch returns status of '||
998: l_return_status );
999: END IF;
1000: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1001: x_arr_rtn_sts (i).return_status := l_return_status;
1002:
1003: -- Pawan Kumar ADDED code for bug 2398719
1004: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN

Line 1012: END IF; /* l_return_status <> FND_API.G_RET_STS_SUCCESS */

1008: x_exception_material_tbl (i) :=
1009: l_exception_material_tbl (j);
1010: END LOOP;
1011: END IF;
1012: END IF; /* l_return_status <> FND_API.G_RET_STS_SUCCESS */
1013:
1014: --Swapna Kommineni bug#3565971 13/08/2004 Assigning the planned start and end dates of
1015: --batch that are calculated from the create_batch api
1016: l_prev_start_date := l_pre_batch_row.plan_start_date;

Line 1040: x_return_status := fnd_api.g_ret_sts_error;

1036:
1037: --BEGIN BUG#3185748 Sastry
1038: EXCEPTION
1039: WHEN batch_creation_failure OR validation_failure THEN
1040: x_return_status := fnd_api.g_ret_sts_error;
1041: ROLLBACK TO SAVEPOINT create_batch;
1042:
1043: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1044: gme_debug.put_line ('batch creation_fail');

Line 1079: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1075: l_return_status||
1076: ' current return status '||
1077: x_return_status);
1078: END IF;
1079: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1080: x_arr_rtn_sts (p_process_row).return_status := l_return_status;
1081:
1082: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN
1083: RAISE batch_creation_failure;

Line 1116: x_return_status := fnd_api.g_ret_sts_error;

1112: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1113: gme_debug.put_line ('batch creation_fail');
1114: END IF;
1115:
1116: x_return_status := fnd_api.g_ret_sts_error;
1117:
1118: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1119: gme_debug.put_line ('x_return_status = ' || x_return_status);
1120: END IF;

Line 1122: x_return_status := fnd_api.g_ret_sts_unexp_error;

1118: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1119: gme_debug.put_line ('x_return_status = ' || x_return_status);
1120: END IF;
1121: WHEN OTHERS THEN
1122: x_return_status := fnd_api.g_ret_sts_unexp_error;
1123: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
1124: ,'CONVERT_FPO_TO_BATCH');
1125: END convert_fpo_to_batch;
1126:

Line 1134: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true

1130: p_fpo_header_row IN gme_batch_header%ROWTYPE
1131: ,p_prim_prod_row IN gme_material_details%ROWTYPE
1132: ,p_pregen_fpo_row IN pregen_fpo_row
1133: ,p_fpo_material_details_tab IN fpo_material_details_tab
1134: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
1135: ,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE
1136: ,x_return_status OUT NOCOPY VARCHAR2)
1137: IS
1138: CURSOR get_phantom_fpo (v_batch_id NUMBER)

Line 1184: x_return_status := fnd_api.g_ret_sts_success;

1180: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1181: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1182: || l_api_name);
1183: END IF;
1184: x_return_status := fnd_api.g_ret_sts_success;
1185:
1186: l_fpo_header_row := p_fpo_header_row;
1187: l_batch_status := l_fpo_header_row.batch_status;
1188: l_fpo_material_details_tab := p_fpo_material_details_tab;

Line 1201: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1197: gme_trans_engine_util.load_rsrc_trans (p_batch_row => l_fpo_header_row
1198: ,x_rsc_row_count => l_rsc_row_count
1199: ,x_return_status => l_return_status);
1200:
1201: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1202: RAISE load_rsrc_trans_err;
1203: END IF;
1204:
1205: --Fetch all Pending transactions for original FPO

Line 1216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1212: l_tran_tab,
1213: l_return_status
1214: );
1215:
1216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1217: RAISE gme_fetch_all_trans_err;
1218: END IF;
1219: GME CONV */
1220:

Line 1285: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1281: l_tran_row,
1282: l_return_status
1283: );
1284:
1285: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1286: RAISE update_pending_trans;
1287: END IF;
1288: END LOOP;
1289: GME CONV */

Line 1299: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1295: (p_resource_rec => l_resource_txns
1296: ,x_resource_tbl => l_resource_tab
1297: ,x_return_status => l_return_status);
1298:
1299: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1300: RAISE gme_fetch_all_trans_err;
1301: END IF; /* IF l_return_status <> x_return_status */
1302:
1303: FOR i IN 1 .. l_resource_tab.COUNT LOOP

Line 1316: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1312: gme_resource_engine_pvt.delete_resource_trans
1313: (p_tran_rec => l_resource_txns
1314: ,x_return_status => l_return_status);
1315:
1316: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1317: RAISE update_row_err;
1318: END IF;
1319: END LOOP; /* FOR i IN 1..l_resource_tab.COUNT */
1320:

Line 1342: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1338: (p_batch_header_rec => l_batch_header
1339: ,x_batch_header_rec => x_batch_header
1340: ,x_return_status => x_return_status);
1341:
1342: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1343: RAISE cancel_batch_err;
1344: END IF;
1345: END LOOP;
1346: ELSE

Line 1379: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1375: ,x_return_status => l_return_status
1376: ,x_batch_header_rec => x_fpo_header_row
1377: ,x_exception_material_tbl => l_exception_material_tbl);
1378:
1379: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1380: RAISE scale_batch_err;
1381: END IF;
1382:
1383: -- Bug 14348159

Line 1396: ,p_use_workday_cal => fnd_api.g_false

1392: IF l_fpo_header_row.parentline_id IS NULL THEN
1393:
1394: gme_reschedule_batch_pvt.reschedule_batch
1395: (p_batch_header_rec => l_fpo_header_row
1396: ,p_use_workday_cal => fnd_api.g_false
1397: ,p_contiguity_override => fnd_api.g_true
1398: ,x_batch_header_rec => x_fpo_header_row
1399: ,x_return_status => l_return_status);
1400:

Line 1397: ,p_contiguity_override => fnd_api.g_true

1393:
1394: gme_reschedule_batch_pvt.reschedule_batch
1395: (p_batch_header_rec => l_fpo_header_row
1396: ,p_use_workday_cal => fnd_api.g_false
1397: ,p_contiguity_override => fnd_api.g_true
1398: ,x_batch_header_rec => x_fpo_header_row
1399: ,x_return_status => l_return_status);
1400:
1401: -- Check return status and raise error if needed.

Line 1402: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1398: ,x_batch_header_rec => x_fpo_header_row
1399: ,x_return_status => l_return_status);
1400:
1401: -- Check return status and raise error if needed.
1402: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1403: RAISE reschedule_batch_fail;
1404: END IF;
1405:
1406: l_fpo_header_row := x_fpo_header_row ;

Line 1421: x_return_status := fnd_api.g_ret_sts_error;

1417: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1418: gme_debug.put_line ('load_rsrc_trans_err_fail');
1419: END IF;
1420:
1421: x_return_status := fnd_api.g_ret_sts_error;
1422: -- Bug 14348159
1423: WHEN reschedule_batch_fail THEN
1424: x_return_status := 'C';
1425:

Line 1431: x_return_status := fnd_api.g_ret_sts_error;

1427: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1428: gme_debug.put_line ('Cancel_FPO_PHANTOM_fail');
1429: END IF;
1430:
1431: x_return_status := fnd_api.g_ret_sts_error;
1432: WHEN gme_fetch_all_trans_err THEN
1433: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1434: gme_debug.put_line ('fetch_alltrans_err_fail');
1435: END IF;

Line 1437: x_return_status := fnd_api.g_ret_sts_error;

1433: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1434: gme_debug.put_line ('fetch_alltrans_err_fail');
1435: END IF;
1436:
1437: x_return_status := fnd_api.g_ret_sts_error;
1438: --FPBug#4941012
1439: WHEN fetch_batch_err THEN
1440: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1441: gme_debug.put_line ('fetch batch header fail');

Line 1444: x_return_status := fnd_api.g_ret_sts_error;

1440: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1441: gme_debug.put_line ('fetch batch header fail');
1442: END IF;
1443:
1444: x_return_status := fnd_api.g_ret_sts_error;
1445: WHEN update_row_err THEN
1446: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1447: gme_debug.put_line ('update_row _fail');
1448: END IF;

Line 1450: x_return_status := fnd_api.g_ret_sts_error;

1446: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1447: gme_debug.put_line ('update_row _fail');
1448: END IF;
1449:
1450: x_return_status := fnd_api.g_ret_sts_error;
1451: WHEN delete_pending_trans_err THEN
1452: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1453: gme_debug.put_line ('delete_pending_trans _fail');
1454: END IF;

Line 1456: x_return_status := fnd_api.g_ret_sts_error;

1452: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1453: gme_debug.put_line ('delete_pending_trans _fail');
1454: END IF;
1455:
1456: x_return_status := fnd_api.g_ret_sts_error;
1457: WHEN scale_batch_err THEN
1458: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1459: gme_debug.put_line ('scale_batch _fail');
1460: END IF;

Line 1462: x_return_status := fnd_api.g_ret_sts_error;

1458: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1459: gme_debug.put_line ('scale_batch _fail');
1460: END IF;
1461:
1462: x_return_status := fnd_api.g_ret_sts_error;
1463: WHEN update_pending_trans THEN
1464: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1465: gme_debug.put_line ('update_pending_trans _fail');
1466: END IF;

Line 1468: x_return_status := fnd_api.g_ret_sts_error;

1464: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1465: gme_debug.put_line ('update_pending_trans _fail');
1466: END IF;
1467:
1468: x_return_status := fnd_api.g_ret_sts_error;
1469: WHEN OTHERS THEN
1470: x_return_status := fnd_api.g_ret_sts_unexp_error;
1471: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
1472: ,'UPDATE_ORIGINAL_FPO');

Line 1470: x_return_status := fnd_api.g_ret_sts_unexp_error;

1466: END IF;
1467:
1468: x_return_status := fnd_api.g_ret_sts_error;
1469: WHEN OTHERS THEN
1470: x_return_status := fnd_api.g_ret_sts_unexp_error;
1471: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
1472: ,'UPDATE_ORIGINAL_FPO');
1473: END update_original_fpo;
1474:

Line 1482: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true

1478: ,p_batch_size IN NUMBER
1479: ,p_num_batches IN NUMBER
1480: ,p_validity_rule_id IN NUMBER
1481: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab
1482: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
1483: ,p_leadtime IN NUMBER
1484: ,p_batch_offset IN NUMBER
1485: ,p_offset_type IN NUMBER
1486: ,

Line 1490: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false

1486: ,
1487: -- p_schedule_method IN VARCHAR2,
1488: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
1489: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1490: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1491: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1492: ,x_return_status OUT NOCOPY VARCHAR2
1493: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
1494: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)

Line 1491: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true

1487: -- p_schedule_method IN VARCHAR2,
1488: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
1489: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1490: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1491: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1492: ,x_return_status OUT NOCOPY VARCHAR2
1493: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
1494: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)
1495: IS

Line 1494: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)

1490: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1491: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1492: ,x_return_status OUT NOCOPY VARCHAR2
1493: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
1494: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)
1495: IS
1496: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_MAIN';
1497: /* Cursor definitions */
1498: --KYH GME Convergence - replace ic_item_mst with mtl_system_items

Line 1543: x_return_status := fnd_api.g_ret_sts_success;

1539: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1540: || l_api_name);
1541: END IF;
1542:
1543: x_return_status := fnd_api.g_ret_sts_success;
1544: -- Pawan Kumar ADDED code for bug 2398719
1545: l_batch_header.batch_id := p_batch_header.batch_id;
1546: /* Bug2403042: Added following code to identify the
1547: FPO based on batch_no, and plant_code */

Line 1622: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1618:
1619: l_pregen_fpo_row := x_pregen_fpo_row;
1620: l_fpo_header_row := l_batch_header;
1621:
1622: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1623: RAISE validation_failure;
1624: END IF;
1625:
1626: l_in_fpo_header_row := l_fpo_header_row;

Line 1652: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1648: ' retrieve_fpo_data returns status of '||
1649: x_return_status);
1650: END IF;
1651:
1652: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1653: RAISE fpo_retrieval_failure;
1654: END IF;
1655:
1656: l_item_um := l_prim_prod_row.dtl_um;

Line 1658: IF p_use_for_all = fnd_api.g_true THEN

1654: END IF;
1655:
1656: l_item_um := l_prim_prod_row.dtl_um;
1657:
1658: IF p_use_for_all = fnd_api.g_true THEN
1659: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1660: gme_debug.put_line (g_pkg_name ||
1661: '.' ||
1662: l_api_name ||

Line 1734: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1730: ' generate_pre_batch_header_recs returns '||
1731: x_return_status );
1732: END IF;
1733:
1734: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1735: RAISE batch_generation_failure;
1736: END IF;
1737:
1738: --Swapna Kommineni bug#3565971 13/08/2004 Start

Line 1794: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1790: ' convert_fpo_to_batch returns '||
1791: x_return_status);
1792: END IF;
1793:
1794: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1795: RAISE create_batch_failure;
1796: END IF;
1797:
1798: --BEGIN BUG#3185748 Sastry

Line 1818: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1814: gme_debug.put_line ( 'in private convert_fpo-after update'
1815: || x_return_status);
1816: END IF;
1817:
1818: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1819: RAISE update_original_fpo_failure;
1820: END IF;
1821:
1822: -- Bug 3185748 Use l_generated_pre_batch_tab.FIRST and l_generated_pre_batch_tab.LAST

Line 1855: x_return_status := fnd_api.g_ret_sts_error;

1851: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1852: gme_debug.put_line ('in validiation fail exception');
1853: END IF;
1854:
1855: x_return_status := fnd_api.g_ret_sts_error;
1856: WHEN fpo_retrieval_failure THEN
1857: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1858: gme_debug.put_line ('in retrieval fail exception');
1859: END IF;

Line 1861: x_return_status := fnd_api.g_ret_sts_error;

1857: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1858: gme_debug.put_line ('in retrieval fail exception');
1859: END IF;
1860:
1861: x_return_status := fnd_api.g_ret_sts_error;
1862: WHEN batch_generation_failure THEN
1863: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1864: gme_debug.put_line ('in batch_generation fail exception');
1865: END IF;

Line 1867: x_return_status := fnd_api.g_ret_sts_error;

1863: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1864: gme_debug.put_line ('in batch_generation fail exception');
1865: END IF;
1866:
1867: x_return_status := fnd_api.g_ret_sts_error;
1868: WHEN insufficient_validity_rules THEN
1869: x_return_status := fnd_api.g_ret_sts_error;
1870: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1871: WHEN create_batch_failure THEN

Line 1869: x_return_status := fnd_api.g_ret_sts_error;

1865: END IF;
1866:
1867: x_return_status := fnd_api.g_ret_sts_error;
1868: WHEN insufficient_validity_rules THEN
1869: x_return_status := fnd_api.g_ret_sts_error;
1870: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1871: WHEN create_batch_failure THEN
1872: x_return_status := fnd_api.g_ret_sts_error;
1873: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN

Line 1872: x_return_status := fnd_api.g_ret_sts_error;

1868: WHEN insufficient_validity_rules THEN
1869: x_return_status := fnd_api.g_ret_sts_error;
1870: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1871: WHEN create_batch_failure THEN
1872: x_return_status := fnd_api.g_ret_sts_error;
1873: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN
1874: x_return_status := fnd_api.g_ret_sts_error;
1875: WHEN OTHERS THEN
1876: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1874: x_return_status := fnd_api.g_ret_sts_error;

1870: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1871: WHEN create_batch_failure THEN
1872: x_return_status := fnd_api.g_ret_sts_error;
1873: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN
1874: x_return_status := fnd_api.g_ret_sts_error;
1875: WHEN OTHERS THEN
1876: x_return_status := fnd_api.g_ret_sts_unexp_error;
1877: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'CONVERT_FPO_MAIN');
1878: END convert_fpo_main;

Line 1876: x_return_status := fnd_api.g_ret_sts_unexp_error;

1872: x_return_status := fnd_api.g_ret_sts_error;
1873: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN
1874: x_return_status := fnd_api.g_ret_sts_error;
1875: WHEN OTHERS THEN
1876: x_return_status := fnd_api.g_ret_sts_unexp_error;
1877: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'CONVERT_FPO_MAIN');
1878: END convert_fpo_main;
1879: --****************************************************************
1880: END gme_convert_fpo_pvt;