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 392: x_return_status := fnd_api.g_ret_sts_error;

388: gme_debug.put_line ('no fetch material_details');
389: END IF;
390:
391: gme_common_pvt.log_message ('PM_NO_MATL_DTL');
392: x_return_status := fnd_api.g_ret_sts_error;
393: WHEN batch_fetch_error THEN
394: x_return_status := fnd_api.g_ret_sts_error;
395: WHEN OTHERS THEN
396: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 394: x_return_status := fnd_api.g_ret_sts_error;

390:
391: gme_common_pvt.log_message ('PM_NO_MATL_DTL');
392: x_return_status := fnd_api.g_ret_sts_error;
393: WHEN batch_fetch_error THEN
394: x_return_status := fnd_api.g_ret_sts_error;
395: WHEN OTHERS THEN
396: x_return_status := fnd_api.g_ret_sts_unexp_error;
397: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'retrieve_fpo_data');
398: END retrieve_fpo_data;

Line 396: x_return_status := fnd_api.g_ret_sts_unexp_error;

392: x_return_status := fnd_api.g_ret_sts_error;
393: WHEN batch_fetch_error THEN
394: x_return_status := fnd_api.g_ret_sts_error;
395: WHEN OTHERS THEN
396: x_return_status := fnd_api.g_ret_sts_unexp_error;
397: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'retrieve_fpo_data');
398: END retrieve_fpo_data;
399:
400: --*************************************************************

Line 416: x_return_status := fnd_api.g_ret_sts_success;

412: || l_api_name);
413: END IF;
414:
415: x_pregen_fpo_row := p_pregen_fpo_row;
416: x_return_status := fnd_api.g_ret_sts_success;
417:
418: IF ( p_pregen_fpo_row.variable_leadtime = 0
419: OR p_pregen_fpo_row.std_qty = 0) THEN
420: x_pregen_fpo_row.leadtime := p_pregen_fpo_row.fixed_leadtime;

Line 435: x_return_status := fnd_api.g_ret_sts_unexp_error;

431: END IF;
432: EXCEPTION
433: WHEN OTHERS THEN
434: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436: --End Bug2804440
437: END calculate_leadtime;
438:
439: --*************************************************************

Line 707: x_return_status := fnd_api.g_ret_sts_success;

703: ,'MM/DD/YYYY hh24:mi:ss') );
704: END IF;
705:
706: x_generated_pre_batch_tab (i) := l_generated_pre_batch_tab (i);
707: x_return_status := fnd_api.g_ret_sts_success;
708: END LOOP;
709:
710: IF x_return_status <> fnd_api.g_ret_sts_success THEN
711: RAISE generate_pre_batch_err;

Line 710: IF x_return_status <> fnd_api.g_ret_sts_success THEN

706: x_generated_pre_batch_tab (i) := l_generated_pre_batch_tab (i);
707: x_return_status := fnd_api.g_ret_sts_success;
708: END LOOP;
709:
710: IF x_return_status <> fnd_api.g_ret_sts_success THEN
711: RAISE generate_pre_batch_err;
712: END IF;
713:
714: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 725: x_return_status := fnd_api.g_ret_sts_error;

721: ('problem generateing the pre_batch-header recs');
722: END IF;
723:
724: gme_common_pvt.log_message ('GEN_PRE_BATCH_HEADER_ERR');
725: x_return_status := fnd_api.g_ret_sts_error;
726: WHEN OTHERS THEN
727: x_return_status := fnd_api.g_ret_sts_unexp_error;
728: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
729: ,'generate_pre_batch_header_recs');

Line 727: x_return_status := fnd_api.g_ret_sts_unexp_error;

723:
724: gme_common_pvt.log_message ('GEN_PRE_BATCH_HEADER_ERR');
725: x_return_status := fnd_api.g_ret_sts_error;
726: WHEN OTHERS THEN
727: x_return_status := fnd_api.g_ret_sts_unexp_error;
728: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
729: ,'generate_pre_batch_header_recs');
730: END generate_pre_batch_header_recs;
731:

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

738: ,x_generated_pre_batch_tab OUT NOCOPY generated_pre_batch_tab
739: ,x_return_status OUT NOCOPY VARCHAR2
740: ,x_arr_rtn_sts OUT NOCOPY return_array_sts
741: ,p_process_row IN NUMBER DEFAULT 0
742: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
743: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
744: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
745: ,p_fpo_validity_rule_id IN NUMBER --BUG#3185748 Sastry
746: )

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

739: ,x_return_status OUT NOCOPY VARCHAR2
740: ,x_arr_rtn_sts OUT NOCOPY return_array_sts
741: ,p_process_row IN NUMBER DEFAULT 0
742: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
743: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
744: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
745: ,p_fpo_validity_rule_id IN NUMBER --BUG#3185748 Sastry
746: )
747: IS

Line 791: x_return_status := fnd_api.g_ret_sts_success;

787: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
788: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
789: || l_api_name);
790: END IF;
791: x_return_status := fnd_api.g_ret_sts_success;
792: dummy := 0;
793: l_validation_level := gme_common_pvt.g_max_errors;
794: l_api_version := 2.0;
795: l_generated_pre_batch_tab := p_generated_pre_batch_tab;

Line 934: IF l_return_status <> fnd_api.g_ret_sts_success THEN

930: l_api_name ||
931: ' create_batch returns status of '||
932: l_return_status );
933: END IF;
934: IF l_return_status <> fnd_api.g_ret_sts_success THEN
935: x_arr_rtn_sts (i).return_status := l_return_status;
936:
937: -- Pawan Kumar ADDED code for bug 2398719
938: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN

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

942: x_exception_material_tbl (i) :=
943: l_exception_material_tbl (j);
944: END LOOP;
945: END IF;
946: END IF; /* l_return_status <> FND_API.G_RET_STS_SUCCESS */
947:
948: --Swapna Kommineni bug#3565971 13/08/2004 Assigning the planned start and end dates of
949: --batch that are calculated from the create_batch api
950: l_prev_start_date := l_pre_batch_row.plan_start_date;

Line 974: x_return_status := fnd_api.g_ret_sts_error;

970:
971: --BEGIN BUG#3185748 Sastry
972: EXCEPTION
973: WHEN batch_creation_failure OR validation_failure THEN
974: x_return_status := fnd_api.g_ret_sts_error;
975: ROLLBACK TO SAVEPOINT create_batch;
976:
977: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
978: gme_debug.put_line ('batch creation_fail');

Line 1013: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1009: l_return_status||
1010: ' current return status '||
1011: x_return_status);
1012: END IF;
1013: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1014: x_arr_rtn_sts (p_process_row).return_status := l_return_status;
1015:
1016: IF l_return_status NOT IN (gme_common_pvt.g_inv_short_err) THEN
1017: RAISE batch_creation_failure;

Line 1050: x_return_status := fnd_api.g_ret_sts_error;

1046: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1047: gme_debug.put_line ('batch creation_fail');
1048: END IF;
1049:
1050: x_return_status := fnd_api.g_ret_sts_error;
1051:
1052: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1053: gme_debug.put_line ('x_return_status = ' || x_return_status);
1054: END IF;

Line 1056: x_return_status := fnd_api.g_ret_sts_unexp_error;

1052: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1053: gme_debug.put_line ('x_return_status = ' || x_return_status);
1054: END IF;
1055: WHEN OTHERS THEN
1056: x_return_status := fnd_api.g_ret_sts_unexp_error;
1057: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
1058: ,'CONVERT_FPO_TO_BATCH');
1059: END convert_fpo_to_batch;
1060:

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

1064: p_fpo_header_row IN gme_batch_header%ROWTYPE
1065: ,p_prim_prod_row IN gme_material_details%ROWTYPE
1066: ,p_pregen_fpo_row IN pregen_fpo_row
1067: ,p_fpo_material_details_tab IN fpo_material_details_tab
1068: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
1069: ,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE
1070: ,x_return_status OUT NOCOPY VARCHAR2)
1071: IS
1072: CURSOR get_phantom_fpo (v_batch_id NUMBER)

Line 1113: x_return_status := fnd_api.g_ret_sts_success;

1109: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1110: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1111: || l_api_name);
1112: END IF;
1113: x_return_status := fnd_api.g_ret_sts_success;
1114:
1115: l_fpo_header_row := p_fpo_header_row;
1116: l_batch_status := l_fpo_header_row.batch_status;
1117: l_fpo_material_details_tab := p_fpo_material_details_tab;

Line 1130: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1126: gme_trans_engine_util.load_rsrc_trans (p_batch_row => l_fpo_header_row
1127: ,x_rsc_row_count => l_rsc_row_count
1128: ,x_return_status => l_return_status);
1129:
1130: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1131: RAISE load_rsrc_trans_err;
1132: END IF;
1133:
1134: --Fetch all Pending transactions for original FPO

Line 1145: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1141: l_tran_tab,
1142: l_return_status
1143: );
1144:
1145: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1146: RAISE gme_fetch_all_trans_err;
1147: END IF;
1148: GME CONV */
1149:

Line 1214: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1210: l_tran_row,
1211: l_return_status
1212: );
1213:
1214: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1215: RAISE update_pending_trans;
1216: END IF;
1217: END LOOP;
1218: GME CONV */

Line 1228: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1224: (p_resource_rec => l_resource_txns
1225: ,x_resource_tbl => l_resource_tab
1226: ,x_return_status => l_return_status);
1227:
1228: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1229: RAISE gme_fetch_all_trans_err;
1230: END IF; /* IF l_return_status <> x_return_status */
1231:
1232: FOR i IN 1 .. l_resource_tab.COUNT LOOP

Line 1245: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1241: gme_resource_engine_pvt.delete_resource_trans
1242: (p_tran_rec => l_resource_txns
1243: ,x_return_status => l_return_status);
1244:
1245: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1246: RAISE update_row_err;
1247: END IF;
1248: END LOOP; /* FOR i IN 1..l_resource_tab.COUNT */
1249:

Line 1271: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1267: (p_batch_header_rec => l_batch_header
1268: ,x_batch_header_rec => x_batch_header
1269: ,x_return_status => x_return_status);
1270:
1271: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1272: RAISE cancel_batch_err;
1273: END IF;
1274: END LOOP;
1275: ELSE

Line 1307: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1303: ,x_return_status => l_return_status
1304: ,x_batch_header_rec => x_fpo_header_row
1305: ,x_exception_material_tbl => l_exception_material_tbl);
1306:
1307: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1308: RAISE scale_batch_err;
1309: END IF;
1310: END IF;
1311:

Line 1322: x_return_status := fnd_api.g_ret_sts_error;

1318: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1319: gme_debug.put_line ('load_rsrc_trans_err_fail');
1320: END IF;
1321:
1322: x_return_status := fnd_api.g_ret_sts_error;
1323: WHEN cancel_batch_err THEN
1324: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1325: gme_debug.put_line ('Cancel_FPO_PHANTOM_fail');
1326: END IF;

Line 1328: x_return_status := fnd_api.g_ret_sts_error;

1324: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1325: gme_debug.put_line ('Cancel_FPO_PHANTOM_fail');
1326: END IF;
1327:
1328: x_return_status := fnd_api.g_ret_sts_error;
1329: WHEN gme_fetch_all_trans_err THEN
1330: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1331: gme_debug.put_line ('fetch_alltrans_err_fail');
1332: END IF;

Line 1334: x_return_status := fnd_api.g_ret_sts_error;

1330: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1331: gme_debug.put_line ('fetch_alltrans_err_fail');
1332: END IF;
1333:
1334: x_return_status := fnd_api.g_ret_sts_error;
1335: --FPBug#4941012
1336: WHEN fetch_batch_err THEN
1337: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1338: gme_debug.put_line ('fetch batch header fail');

Line 1341: x_return_status := fnd_api.g_ret_sts_error;

1337: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1338: gme_debug.put_line ('fetch batch header fail');
1339: END IF;
1340:
1341: x_return_status := fnd_api.g_ret_sts_error;
1342: WHEN update_row_err THEN
1343: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1344: gme_debug.put_line ('update_row _fail');
1345: END IF;

Line 1347: x_return_status := fnd_api.g_ret_sts_error;

1343: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1344: gme_debug.put_line ('update_row _fail');
1345: END IF;
1346:
1347: x_return_status := fnd_api.g_ret_sts_error;
1348: WHEN delete_pending_trans_err THEN
1349: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1350: gme_debug.put_line ('delete_pending_trans _fail');
1351: END IF;

Line 1353: x_return_status := fnd_api.g_ret_sts_error;

1349: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1350: gme_debug.put_line ('delete_pending_trans _fail');
1351: END IF;
1352:
1353: x_return_status := fnd_api.g_ret_sts_error;
1354: WHEN scale_batch_err THEN
1355: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1356: gme_debug.put_line ('scale_batch _fail');
1357: END IF;

Line 1359: x_return_status := fnd_api.g_ret_sts_error;

1355: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1356: gme_debug.put_line ('scale_batch _fail');
1357: END IF;
1358:
1359: x_return_status := fnd_api.g_ret_sts_error;
1360: WHEN update_pending_trans THEN
1361: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1362: gme_debug.put_line ('update_pending_trans _fail');
1363: END IF;

Line 1365: x_return_status := fnd_api.g_ret_sts_error;

1361: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1362: gme_debug.put_line ('update_pending_trans _fail');
1363: END IF;
1364:
1365: x_return_status := fnd_api.g_ret_sts_error;
1366: WHEN OTHERS THEN
1367: x_return_status := fnd_api.g_ret_sts_unexp_error;
1368: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
1369: ,'UPDATE_ORIGINAL_FPO');

Line 1367: x_return_status := fnd_api.g_ret_sts_unexp_error;

1363: END IF;
1364:
1365: x_return_status := fnd_api.g_ret_sts_error;
1366: WHEN OTHERS THEN
1367: x_return_status := fnd_api.g_ret_sts_unexp_error;
1368: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'
1369: ,'UPDATE_ORIGINAL_FPO');
1370: END update_original_fpo;
1371:

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

1375: ,p_batch_size IN NUMBER
1376: ,p_num_batches IN NUMBER
1377: ,p_validity_rule_id IN NUMBER
1378: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab
1379: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
1380: ,p_leadtime IN NUMBER
1381: ,p_batch_offset IN NUMBER
1382: ,p_offset_type IN NUMBER
1383: ,

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

1383: ,
1384: -- p_schedule_method IN VARCHAR2,
1385: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
1386: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1387: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1388: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1389: ,x_return_status OUT NOCOPY VARCHAR2
1390: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
1391: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)

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

1384: -- p_schedule_method IN VARCHAR2,
1385: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
1386: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1387: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1388: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1389: ,x_return_status OUT NOCOPY VARCHAR2
1390: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
1391: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)
1392: IS

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

1387: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1388: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1389: ,x_return_status OUT NOCOPY VARCHAR2
1390: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
1391: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)
1392: IS
1393: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_MAIN';
1394: /* Cursor definitions */
1395: --KYH GME Convergence - replace ic_item_mst with mtl_system_items

Line 1440: x_return_status := fnd_api.g_ret_sts_success;

1436: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1437: || l_api_name);
1438: END IF;
1439:
1440: x_return_status := fnd_api.g_ret_sts_success;
1441: -- Pawan Kumar ADDED code for bug 2398719
1442: l_batch_header.batch_id := p_batch_header.batch_id;
1443: /* Bug2403042: Added following code to identify the
1444: FPO based on batch_no, and plant_code */

Line 1519: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1515:
1516: l_pregen_fpo_row := x_pregen_fpo_row;
1517: l_fpo_header_row := l_batch_header;
1518:
1519: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1520: RAISE validation_failure;
1521: END IF;
1522:
1523: l_in_fpo_header_row := l_fpo_header_row;

Line 1549: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1545: ' retrieve_fpo_data returns status of '||
1546: x_return_status);
1547: END IF;
1548:
1549: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1550: RAISE fpo_retrieval_failure;
1551: END IF;
1552:
1553: l_item_um := l_prim_prod_row.dtl_um;

Line 1555: IF p_use_for_all = fnd_api.g_true THEN

1551: END IF;
1552:
1553: l_item_um := l_prim_prod_row.dtl_um;
1554:
1555: IF p_use_for_all = fnd_api.g_true THEN
1556: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1557: gme_debug.put_line (g_pkg_name ||
1558: '.' ||
1559: l_api_name ||

Line 1631: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1627: ' generate_pre_batch_header_recs returns '||
1628: x_return_status );
1629: END IF;
1630:
1631: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1632: RAISE batch_generation_failure;
1633: END IF;
1634:
1635: --Swapna Kommineni bug#3565971 13/08/2004 Start

Line 1691: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1687: ' convert_fpo_to_batch returns '||
1688: x_return_status);
1689: END IF;
1690:
1691: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1692: RAISE create_batch_failure;
1693: END IF;
1694:
1695: --BEGIN BUG#3185748 Sastry

Line 1715: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1711: gme_debug.put_line ( 'in private convert_fpo-after update'
1712: || x_return_status);
1713: END IF;
1714:
1715: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1716: RAISE update_original_fpo_failure;
1717: END IF;
1718:
1719: -- Bug 3185748 Use l_generated_pre_batch_tab.FIRST and l_generated_pre_batch_tab.LAST

Line 1752: x_return_status := fnd_api.g_ret_sts_error;

1748: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1749: gme_debug.put_line ('in validiation fail exception');
1750: END IF;
1751:
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: WHEN fpo_retrieval_failure THEN
1754: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1755: gme_debug.put_line ('in retrieval fail exception');
1756: END IF;

Line 1758: x_return_status := fnd_api.g_ret_sts_error;

1754: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1755: gme_debug.put_line ('in retrieval fail exception');
1756: END IF;
1757:
1758: x_return_status := fnd_api.g_ret_sts_error;
1759: WHEN batch_generation_failure THEN
1760: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1761: gme_debug.put_line ('in batch_generation fail exception');
1762: END IF;

Line 1764: x_return_status := fnd_api.g_ret_sts_error;

1760: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1761: gme_debug.put_line ('in batch_generation fail exception');
1762: END IF;
1763:
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: WHEN insufficient_validity_rules THEN
1766: x_return_status := fnd_api.g_ret_sts_error;
1767: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1768: WHEN create_batch_failure THEN

Line 1766: x_return_status := fnd_api.g_ret_sts_error;

1762: END IF;
1763:
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: WHEN insufficient_validity_rules THEN
1766: x_return_status := fnd_api.g_ret_sts_error;
1767: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1768: WHEN create_batch_failure THEN
1769: x_return_status := fnd_api.g_ret_sts_error;
1770: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN

Line 1769: x_return_status := fnd_api.g_ret_sts_error;

1765: WHEN insufficient_validity_rules THEN
1766: x_return_status := fnd_api.g_ret_sts_error;
1767: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1768: WHEN create_batch_failure THEN
1769: x_return_status := fnd_api.g_ret_sts_error;
1770: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN OTHERS THEN
1773: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1771: x_return_status := fnd_api.g_ret_sts_error;

1767: gme_common_pvt.log_message ('GME_INSUF_VAL_RULE');
1768: WHEN create_batch_failure THEN
1769: x_return_status := fnd_api.g_ret_sts_error;
1770: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN OTHERS THEN
1773: x_return_status := fnd_api.g_ret_sts_unexp_error;
1774: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'CONVERT_FPO_MAIN');
1775: END convert_fpo_main;

Line 1773: x_return_status := fnd_api.g_ret_sts_unexp_error;

1769: x_return_status := fnd_api.g_ret_sts_error;
1770: WHEN update_original_fpo_failure OR batch_header_fetch_error THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN OTHERS THEN
1773: x_return_status := fnd_api.g_ret_sts_unexp_error;
1774: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO', 'CONVERT_FPO_MAIN');
1775: END convert_fpo_main;
1776: --****************************************************************
1777: END gme_convert_fpo_pvt;