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.WMS_ENGINE_PVT dependencies on FND_API

Line 147: x_return_status := fnd_api.g_ret_sts_success;

143: log_procedure(l_api_name, 'start', 'Start Insert_Detail_temp_records');
144: END IF;
145:
146: -- Initialize API return status to access
147: x_return_status := fnd_api.g_ret_sts_success;
148: --
149: l_wms_txn_temp_tbl_size := p_wms_txn_temp_tbl.COUNT;
150:
151: -- return if nothing to insert

Line 237: WHEN fnd_api.g_exc_error THEN

233: log_procedure(l_api_name, 'end', 'End Insert_Detail_temp_records');
234: END IF;
235: --
236: EXCEPTION
237: WHEN fnd_api.g_exc_error THEN
238: /* bug 5265024
239: IF l_wms_txn_temp_id_csr%ISOPEN THEN
240: CLOSE l_wms_txn_temp_id_csr;
241: END IF;

Line 243: x_return_status := fnd_api.g_ret_sts_error;

239: IF l_wms_txn_temp_id_csr%ISOPEN THEN
240: CLOSE l_wms_txn_temp_id_csr;
241: END IF;
242: * /
243: x_return_status := fnd_api.g_ret_sts_error;
244: IF l_debug = 1 THEN
245: log_error(l_api_name, 'error', 'Error in Insert_Detail_temp_records');
246: END IF;
247: --

Line 248: WHEN fnd_api.g_exc_unexpected_error THEN

244: IF l_debug = 1 THEN
245: log_error(l_api_name, 'error', 'Error in Insert_Detail_temp_records');
246: END IF;
247: --
248: WHEN fnd_api.g_exc_unexpected_error THEN
249: /* bug 5265024
250: IF l_wms_txn_temp_id_csr%ISOPEN THEN
251: CLOSE l_wms_txn_temp_id_csr;
252: END IF;

Line 254: x_return_status := fnd_api.g_ret_sts_unexp_error;

250: IF l_wms_txn_temp_id_csr%ISOPEN THEN
251: CLOSE l_wms_txn_temp_id_csr;
252: END IF;
253: */
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: IF l_debug = 1 THEN
256: log_error(l_api_name, 'unexp_error',
257: 'Unexpected error in Insert_Detail_temp_records');
258: END IF;

Line 267: x_return_status := fnd_api.g_ret_sts_unexp_error;

263: CLOSE l_wms_txn_temp_id_csr;
264: END IF;
265: */
266:
267: x_return_status := fnd_api.g_ret_sts_unexp_error;
268:
269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
270: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
271: END IF;

Line 299: x_return_status := fnd_api.g_ret_sts_success;

295: log_procedure(l_api_name, 'start', 'Start purge_detail_temp_records');
296: END IF;
297:
298: -- Initialisize API return status to success
299: x_return_status := fnd_api.g_ret_sts_success;
300:
301: --
302: DELETE FROM wms_transactions_temp
303: WHERE transaction_temp_id = p_request_line_rec.line_id;

Line 313: WHEN fnd_api.g_exc_error THEN

309: log_procedure(l_api_name, 'end', 'End purge_detail_temp_records');
310: END IF;
311: --
312: EXCEPTION
313: WHEN fnd_api.g_exc_error THEN
314: x_return_status := fnd_api.g_ret_sts_error;
315: IF l_debug = 1 THEN
316: log_error(l_api_name, 'error', 'Error in purge_detail_temp_records');
317: END IF;

Line 314: x_return_status := fnd_api.g_ret_sts_error;

310: END IF;
311: --
312: EXCEPTION
313: WHEN fnd_api.g_exc_error THEN
314: x_return_status := fnd_api.g_ret_sts_error;
315: IF l_debug = 1 THEN
316: log_error(l_api_name, 'error', 'Error in purge_detail_temp_records');
317: END IF;
318: --

Line 319: WHEN fnd_api.g_exc_unexpected_error THEN

315: IF l_debug = 1 THEN
316: log_error(l_api_name, 'error', 'Error in purge_detail_temp_records');
317: END IF;
318: --
319: WHEN fnd_api.g_exc_unexpected_error THEN
320: x_return_status := fnd_api.g_ret_sts_unexp_error;
321: IF l_debug = 1 THEN
322: log_error(l_api_name, 'unexp_error', 'Unexpected error in purge_detail_temp_records');
323: END IF;

Line 320: x_return_status := fnd_api.g_ret_sts_unexp_error;

316: log_error(l_api_name, 'error', 'Error in purge_detail_temp_records');
317: END IF;
318: --
319: WHEN fnd_api.g_exc_unexpected_error THEN
320: x_return_status := fnd_api.g_ret_sts_unexp_error;
321: IF l_debug = 1 THEN
322: log_error(l_api_name, 'unexp_error', 'Unexpected error in purge_detail_temp_records');
323: END IF;
324: --

Line 326: x_return_status := fnd_api.g_ret_sts_unexp_error;

322: log_error(l_api_name, 'unexp_error', 'Unexpected error in purge_detail_temp_records');
323: END IF;
324: --
325: WHEN OTHERS THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327:
328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
329: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
330: END IF;

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

344: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
345: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
346: ) IS
347: l_api_name CONSTANT VARCHAR2(30) := 'resolve_serials';
348: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
349: --
350: l_counter INTEGER;
351: l_prefix VARCHAR2(30);
352: l_fm_num VARCHAR2(30);

Line 369: x_return_status := fnd_api.g_ret_sts_success;

365: log_procedure(l_api_name, 'start', 'Start resolve_serials');
366: END IF;
367: --
368: -- Initialisize API return status to access
369: x_return_status := fnd_api.g_ret_sts_success;
370:
371: --
372: -- get the actual serial number based on range
373: IF p_request_line_rec.serial_number_end IS NOT NULL

Line 425: WHEN fnd_api.g_exc_error THEN

421: log_procedure(l_api_name, 'end', 'End resolve_serials');
422: END IF;
423: --
424: EXCEPTION
425: WHEN fnd_api.g_exc_error THEN
426: x_return_status := fnd_api.g_ret_sts_error;
427: IF l_debug = 1 THEN
428: log_error(l_api_name, 'error', 'Error in resolve_serials');
429: END IF;

Line 426: x_return_status := fnd_api.g_ret_sts_error;

422: END IF;
423: --
424: EXCEPTION
425: WHEN fnd_api.g_exc_error THEN
426: x_return_status := fnd_api.g_ret_sts_error;
427: IF l_debug = 1 THEN
428: log_error(l_api_name, 'error', 'Error in resolve_serials');
429: END IF;
430: --

Line 431: WHEN fnd_api.g_exc_unexpected_error THEN

427: IF l_debug = 1 THEN
428: log_error(l_api_name, 'error', 'Error in resolve_serials');
429: END IF;
430: --
431: WHEN fnd_api.g_exc_unexpected_error THEN
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: If l_debug = 1 THEN
434: log_error(l_api_name, 'unexp_error', 'Unexpected error in resolve_serials');
435: END IF;

Line 432: x_return_status := fnd_api.g_ret_sts_unexp_error;

428: log_error(l_api_name, 'error', 'Error in resolve_serials');
429: END IF;
430: --
431: WHEN fnd_api.g_exc_unexpected_error THEN
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: If l_debug = 1 THEN
434: log_error(l_api_name, 'unexp_error', 'Unexpected error in resolve_serials');
435: END IF;
436: --

Line 438: x_return_status := fnd_api.g_ret_sts_unexp_error;

434: log_error(l_api_name, 'unexp_error', 'Unexpected error in resolve_serials');
435: END IF;
436: --
437: WHEN OTHERS THEN
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439:
440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
441: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
442: END IF;

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

459: , p_reservations IN inv_reservation_global.mtl_reservation_tbl_type
460: , x_allow_non_partial_rules OUT NOCOPY BOOLEAN
461: ) IS
462: l_api_name CONSTANT VARCHAR2(30) := 'Prepare';
463: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
464: l_sum_qty NUMBER := 0;
465: l_trx_qty NUMBER;
466: -- For serial number support in the future
467: l_serial_support VARCHAR2(1) := 'N';

Line 499: x_return_status := fnd_api.g_ret_sts_success;

495: log_procedure(l_api_name, 'start', 'Start Prepare');
496: END IF;
497:
498: -- Initialisize API return status to access
499: x_return_status := fnd_api.g_ret_sts_success;
500:
501: --
502: -- check serial number control and support
503: IF l_debug =1 then

Line 540: IF l_return_status = fnd_api.g_ret_sts_error THEN

536: IF l_debug = 1 THEN
537: log_statement(l_api_name , 'Calling resolve_serials() ', '');
538: END IF;
539: resolve_serials(l_return_status, p_request_line_rec, p_request_context);
540: IF l_return_status = fnd_api.g_ret_sts_error THEN
541: RAISE fnd_api.g_exc_error;
542: END IF;
543: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
544: RAISE fnd_api.g_exc_unexpected_error;

Line 541: RAISE fnd_api.g_exc_error;

537: log_statement(l_api_name , 'Calling resolve_serials() ', '');
538: END IF;
539: resolve_serials(l_return_status, p_request_line_rec, p_request_context);
540: IF l_return_status = fnd_api.g_ret_sts_error THEN
541: RAISE fnd_api.g_exc_error;
542: END IF;
543: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;

Line 543: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

539: resolve_serials(l_return_status, p_request_line_rec, p_request_context);
540: IF l_return_status = fnd_api.g_ret_sts_error THEN
541: RAISE fnd_api.g_exc_error;
542: END IF;
543: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: ELSE
547: IF p_request_context.transfer_flag

Line 544: RAISE fnd_api.g_exc_unexpected_error;

540: IF l_return_status = fnd_api.g_ret_sts_error THEN
541: RAISE fnd_api.g_exc_error;
542: END IF;
543: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: ELSE
547: IF p_request_context.transfer_flag
548: OR p_request_context.type_code = 2 THEN -- pick only or transfer

Line 667: IF l_return_status = fnd_api.g_ret_sts_error THEN

663: --
664: -- now we can insert these temporary records derived from
665: -- above
666: insert_detail_temp_records(l_return_status, l_wms_txn_temp_tbl);
667: IF l_return_status = fnd_api.g_ret_sts_error THEN
668: RAISE fnd_api.g_exc_error;
669: END IF;
670: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
671: RAISE fnd_api.g_exc_unexpected_error;

Line 668: RAISE fnd_api.g_exc_error;

664: -- now we can insert these temporary records derived from
665: -- above
666: insert_detail_temp_records(l_return_status, l_wms_txn_temp_tbl);
667: IF l_return_status = fnd_api.g_ret_sts_error THEN
668: RAISE fnd_api.g_exc_error;
669: END IF;
670: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
671: RAISE fnd_api.g_exc_unexpected_error;
672: END IF;

Line 670: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

666: insert_detail_temp_records(l_return_status, l_wms_txn_temp_tbl);
667: IF l_return_status = fnd_api.g_ret_sts_error THEN
668: RAISE fnd_api.g_exc_error;
669: END IF;
670: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
671: RAISE fnd_api.g_exc_unexpected_error;
672: END IF;
673: END IF;
674:

Line 671: RAISE fnd_api.g_exc_unexpected_error;

667: IF l_return_status = fnd_api.g_ret_sts_error THEN
668: RAISE fnd_api.g_exc_error;
669: END IF;
670: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
671: RAISE fnd_api.g_exc_unexpected_error;
672: END IF;
673: END IF;
674:
675: IF l_debug = 1 THEN

Line 680: WHEN fnd_api.g_exc_error THEN

676: log_procedure(l_api_name, 'end', 'End Prepare');
677: END IF;
678: --
679: EXCEPTION
680: WHEN fnd_api.g_exc_error THEN
681: /* --
682: -- debugging section
683: -- can be commented out for final code
684: IF inv_pp_debug.is_debug_mode THEN

Line 694: x_return_status := fnd_api.g_ret_sts_error;

690: END IF;
691:
692: -- end of debugging section
693: -- */
694: x_return_status := fnd_api.g_ret_sts_error;
695: IF l_debug = 1 THEN
696: log_error(l_api_name, 'error', 'Error in Prepare');
697: END IF;
698: --

Line 699: WHEN fnd_api.g_exc_unexpected_error THEN

695: IF l_debug = 1 THEN
696: log_error(l_api_name, 'error', 'Error in Prepare');
697: END IF;
698: --
699: WHEN fnd_api.g_exc_unexpected_error THEN
700: /* --
701: -- debugging section
702: -- can be commented out for final code
703: IF inv_pp_debug.is_debug_mode THEN

Line 713: x_return_status := fnd_api.g_ret_sts_unexp_error;

709: END IF;
710:
711: -- end of debugging section
712: -- */
713: x_return_status := fnd_api.g_ret_sts_unexp_error;
714: IF l_debug = 1 THEN
715: log_error(l_api_name, 'unexp_error', 'Unexpected error in Prepare');
716: END IF;
717: --

Line 720: x_return_status := fnd_api.g_ret_sts_unexp_error;

716: END IF;
717: --
718: WHEN OTHERS THEN
719:
720: x_return_status := fnd_api.g_ret_sts_unexp_error;
721:
722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
724: END IF;

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

745: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
746: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
747: ) IS
748: l_api_name CONSTANT VARCHAR2(30) := 'prepare_transfer_receipt';
749: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
750:
751: --
752: --changed by jcearley on 12/8/99 to attempt to order transfers
753: -- in order of pick suggestions

Line 805: x_return_status := fnd_api.g_ret_sts_success;

801: END IF;
802:
803: --
804: -- Initialisize API return status to access
805: x_return_status := fnd_api.g_ret_sts_success;
806: --
807: l_wms_txn_temp_tbl_size := 0;
808: -- the fetching might be changed to use bulk
809: -- fetching if it is too slow

Line 887: IF l_return_status = fnd_api.g_ret_sts_error THEN

883: -- insert the records into the temporary table
884: -- as input to put away detailing
885: insert_detail_temp_records(l_return_status, l_wms_txn_temp_tbl);
886:
887: IF l_return_status = fnd_api.g_ret_sts_error THEN
888: RAISE fnd_api.g_exc_error;
889: END IF;
890:
891: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 888: RAISE fnd_api.g_exc_error;

884: -- as input to put away detailing
885: insert_detail_temp_records(l_return_status, l_wms_txn_temp_tbl);
886:
887: IF l_return_status = fnd_api.g_ret_sts_error THEN
888: RAISE fnd_api.g_exc_error;
889: END IF;
890:
891: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
892: RAISE fnd_api.g_exc_unexpected_error;

Line 891: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

887: IF l_return_status = fnd_api.g_ret_sts_error THEN
888: RAISE fnd_api.g_exc_error;
889: END IF;
890:
891: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
892: RAISE fnd_api.g_exc_unexpected_error;
893: END IF;
894:
895: x_return_status := l_return_status;

Line 892: RAISE fnd_api.g_exc_unexpected_error;

888: RAISE fnd_api.g_exc_error;
889: END IF;
890:
891: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
892: RAISE fnd_api.g_exc_unexpected_error;
893: END IF;
894:
895: x_return_status := l_return_status;
896:

Line 902: WHEN fnd_api.g_exc_error THEN

898: log_procedure(l_api_name, 'end', 'End prepare_transfer_receipt');
899: END IF;
900:
901: EXCEPTION
902: WHEN fnd_api.g_exc_error THEN
903: IF l_put_input_csr%ISOPEN THEN
904: CLOSE l_put_input_csr;
905: END IF;
906:

Line 907: x_return_status := fnd_api.g_ret_sts_error;

903: IF l_put_input_csr%ISOPEN THEN
904: CLOSE l_put_input_csr;
905: END IF;
906:
907: x_return_status := fnd_api.g_ret_sts_error;
908: IF l_debug = 1 THEN
909: log_error(l_api_name, 'error', 'Error in prepare_transfer_receipt');
910: END IF;
911: --

Line 912: WHEN fnd_api.g_exc_unexpected_error THEN

908: IF l_debug = 1 THEN
909: log_error(l_api_name, 'error', 'Error in prepare_transfer_receipt');
910: END IF;
911: --
912: WHEN fnd_api.g_exc_unexpected_error THEN
913: IF l_put_input_csr%ISOPEN THEN
914: CLOSE l_put_input_csr;
915: END IF;
916:

Line 917: x_return_status := fnd_api.g_ret_sts_unexp_error;

913: IF l_put_input_csr%ISOPEN THEN
914: CLOSE l_put_input_csr;
915: END IF;
916:
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918: IF l_debug = 1 THEN
919: log_error(l_api_name, 'unexp_error', 'Unexpected error in prepare_transfer_receipt');
920: END IF;
921: --

Line 927: x_return_status := fnd_api.g_ret_sts_unexp_error;

923: IF l_put_input_csr%ISOPEN THEN
924: CLOSE l_put_input_csr;
925: END IF;
926:
927: x_return_status := fnd_api.g_ret_sts_unexp_error;
928:
929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
930: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
931: END IF;

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

1134: ORDER BY MIN(x.pp_transaction_temp_id);
1135:
1136: --
1137: l_api_name CONSTANT VARCHAR2(30) := 'output_issue_or_receipt';
1138: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1139: l_curr_rec inv_detail_util_pvt.g_output_process_rec_type;
1140: l_debug NUMBER;
1141: --
1142: BEGIN

Line 1153: x_return_status := fnd_api.g_ret_sts_success;

1149: END IF;
1150:
1151: --
1152: -- Initialisize API return status to access
1153: x_return_status := fnd_api.g_ret_sts_success;
1154: l_transaction_temp_id := p_request_line_rec.line_id;
1155: -- fetch the input request line into a record
1156: OPEN l_pp_temp_csr;
1157:

Line 1179: IF l_return_status = fnd_api.g_ret_sts_error THEN

1175: , p_request_line_rec
1176: , p_request_context
1177: , p_plan_tasks);
1178:
1179: IF l_return_status = fnd_api.g_ret_sts_error THEN
1180: RAISE fnd_api.g_exc_error;
1181: END IF;
1182:
1183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1180: RAISE fnd_api.g_exc_error;

1176: , p_request_context
1177: , p_plan_tasks);
1178:
1179: IF l_return_status = fnd_api.g_ret_sts_error THEN
1180: RAISE fnd_api.g_exc_error;
1181: END IF;
1182:
1183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1184: RAISE fnd_api.g_exc_unexpected_error;

Line 1183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1179: IF l_return_status = fnd_api.g_ret_sts_error THEN
1180: RAISE fnd_api.g_exc_error;
1181: END IF;
1182:
1183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1184: RAISE fnd_api.g_exc_unexpected_error;
1185: END IF;
1186:
1187: x_return_status := l_return_status;

Line 1184: RAISE fnd_api.g_exc_unexpected_error;

1180: RAISE fnd_api.g_exc_error;
1181: END IF;
1182:
1183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1184: RAISE fnd_api.g_exc_unexpected_error;
1185: END IF;
1186:
1187: x_return_status := l_return_status;
1188:

Line 1194: WHEN fnd_api.g_exc_error THEN

1190: log_procedure(l_api_name, 'end', 'End output_issue_or_receipt');
1191: END IF;
1192:
1193: EXCEPTION
1194: WHEN fnd_api.g_exc_error THEN
1195: IF l_pp_temp_csr%ISOPEN THEN
1196: CLOSE l_pp_temp_csr;
1197: END IF;
1198:

Line 1199: x_return_status := fnd_api.g_ret_sts_error;

1195: IF l_pp_temp_csr%ISOPEN THEN
1196: CLOSE l_pp_temp_csr;
1197: END IF;
1198:
1199: x_return_status := fnd_api.g_ret_sts_error;
1200: IF l_debug = 1 THEN
1201: log_error(l_api_name, 'error', 'Error in output_issue_or_receipt');
1202: END IF;
1203:

Line 1205: WHEN fnd_api.g_exc_unexpected_error THEN

1201: log_error(l_api_name, 'error', 'Error in output_issue_or_receipt');
1202: END IF;
1203:
1204: --
1205: WHEN fnd_api.g_exc_unexpected_error THEN
1206: IF l_pp_temp_csr%ISOPEN THEN
1207: CLOSE l_pp_temp_csr;
1208: END IF;
1209:

Line 1210: x_return_status := fnd_api.g_ret_sts_unexp_error;

1206: IF l_pp_temp_csr%ISOPEN THEN
1207: CLOSE l_pp_temp_csr;
1208: END IF;
1209:
1210: x_return_status := fnd_api.g_ret_sts_unexp_error;
1211: IF l_debug = 1 THEN
1212: log_error(l_api_name, 'unexp_error', 'Unexpected error in output_issue_or_receipt');
1213: END IF;
1214: --

Line 1220: x_return_status := fnd_api.g_ret_sts_unexp_error;

1216: IF l_pp_temp_csr%ISOPEN THEN
1217: CLOSE l_pp_temp_csr;
1218: END IF;
1219:
1220: x_return_status := fnd_api.g_ret_sts_unexp_error;
1221:
1222: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1223: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1224: END IF;

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

1236: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
1237: , p_plan_tasks IN BOOLEAN ----DEFAULT FALSE
1238: ) IS
1239: l_api_name VARCHAR2(30) := 'combine_transfer';
1240: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1241: l_transaction_temp_id NUMBER;
1242:
1243: --changed by jcearley on 12/8/99 to order transfer order in mmtt
1244: -- in the order in which suggestions were created

Line 1527: IF l_return_status = fnd_api.g_ret_sts_error THEN

1523: , p_request_line_rec
1524: , p_request_context
1525: , p_plan_tasks);
1526:
1527: IF l_return_status = fnd_api.g_ret_sts_error THEN
1528: RAISE fnd_api.g_exc_error;
1529: END IF;
1530:
1531: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1528: RAISE fnd_api.g_exc_error;

1524: , p_request_context
1525: , p_plan_tasks);
1526:
1527: IF l_return_status = fnd_api.g_ret_sts_error THEN
1528: RAISE fnd_api.g_exc_error;
1529: END IF;
1530:
1531: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1532: RAISE fnd_api.g_exc_unexpected_error;

Line 1531: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1527: IF l_return_status = fnd_api.g_ret_sts_error THEN
1528: RAISE fnd_api.g_exc_error;
1529: END IF;
1530:
1531: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1532: RAISE fnd_api.g_exc_unexpected_error;
1533: END IF;
1534:
1535: x_return_status := l_return_status;

Line 1532: RAISE fnd_api.g_exc_unexpected_error;

1528: RAISE fnd_api.g_exc_error;
1529: END IF;
1530:
1531: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1532: RAISE fnd_api.g_exc_unexpected_error;
1533: END IF;
1534:
1535: x_return_status := l_return_status;
1536:

Line 1542: WHEN fnd_api.g_exc_error THEN

1538: log_procedure(l_api_name, 'end', 'End combine_transfer');
1539: END IF;
1540: --
1541: EXCEPTION
1542: WHEN fnd_api.g_exc_error THEN
1543: IF l_issue_csr%ISOPEN THEN
1544: CLOSE l_issue_csr;
1545: END IF;
1546:

Line 1551: x_return_status := fnd_api.g_ret_sts_error;

1547: IF l_receipt_csr%ISOPEN THEN
1548: CLOSE l_receipt_csr;
1549: END IF;
1550:
1551: x_return_status := fnd_api.g_ret_sts_error;
1552: IF l_debug = 1 THEN
1553: log_error(l_api_name, 'error', 'Error in combine_transfer');
1554: END IF;
1555: --

Line 1556: WHEN fnd_api.g_exc_unexpected_error THEN

1552: IF l_debug = 1 THEN
1553: log_error(l_api_name, 'error', 'Error in combine_transfer');
1554: END IF;
1555: --
1556: WHEN fnd_api.g_exc_unexpected_error THEN
1557: IF l_issue_csr%ISOPEN THEN
1558: CLOSE l_issue_csr;
1559: END IF;
1560:

Line 1565: x_return_status := fnd_api.g_ret_sts_unexp_error;

1561: IF l_receipt_csr%ISOPEN THEN
1562: CLOSE l_receipt_csr;
1563: END IF;
1564:
1565: x_return_status := fnd_api.g_ret_sts_unexp_error;
1566: IF l_debug = 1 THEN
1567: log_error(l_api_name, 'unexp_error', 'Unexpected error in combine_transfer');
1568: END IF;
1569: --

Line 1579: x_return_status := fnd_api.g_ret_sts_unexp_error;

1575: IF l_receipt_csr%ISOPEN THEN
1576: CLOSE l_receipt_csr;
1577: END IF;
1578:
1579: x_return_status := fnd_api.g_ret_sts_unexp_error;
1580:
1581: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1582: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1583: END IF;

Line 1617: -- and pass p_suggest_serial as fnd_api.true, the engine will filter

1613: --
1614: -- 2. Serial Number Detailing in Picking
1615: -- Currently the serial number detailing is quite simple. If the caller
1616: -- gives a range (start, and end) serial numbers in the move order line
1617: -- and pass p_suggest_serial as fnd_api.true, the engine will filter
1618: -- the locations found from a rule, and suggest unused serial numbers
1619: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false
1620: -- (default), the engine will not give serial numbers in the output.
1621: --

Line 1619: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false

1615: -- Currently the serial number detailing is quite simple. If the caller
1616: -- gives a range (start, and end) serial numbers in the move order line
1617: -- and pass p_suggest_serial as fnd_api.true, the engine will filter
1618: -- the locations found from a rule, and suggest unused serial numbers
1619: -- in the locator. If p_suggest_serial is passed as fnd_api.g_false
1620: -- (default), the engine will not give serial numbers in the output.
1621: --
1622: -- Input Parameters
1623: -- p_api_version_number standard input parameter

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

1663: l_api_version CONSTANT NUMBER := 1.0;
1664: l_api_name CONSTANT VARCHAR2(30) := 'Create_Suggestions';
1665: l_strategy_id NUMBER;
1666: l_rule_id NUMBER; -- [l_rule_id New Column Added for K ]
1667: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1668: l_msg_count NUMBER;
1669: l_msg_data VARCHAR2(2000);
1670: l_counter PLS_INTEGER; --8809951 changed to Pls_Integer
1671: l_type_code PLS_INTEGER; --8809951 changed to Pls_Integer

Line 1867: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1863: SAVEPOINT create_suggestions_sa;
1864:
1865: --
1866: -- Standard Call to check for call compatibility
1867: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1868: RAISE fnd_api.g_exc_unexpected_error;
1869: END IF;
1870:
1871: --

Line 1868: RAISE fnd_api.g_exc_unexpected_error;

1864:
1865: --
1866: -- Standard Call to check for call compatibility
1867: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1868: RAISE fnd_api.g_exc_unexpected_error;
1869: END IF;
1870:
1871: --
1872: -- Initialize message list if p_init_msg_list is set to true

Line 1873: IF fnd_api.to_boolean(p_init_msg_list) THEN

1869: END IF;
1870:
1871: --
1872: -- Initialize message list if p_init_msg_list is set to true
1873: IF fnd_api.to_boolean(p_init_msg_list) THEN
1874: fnd_msg_pub.initialize;
1875: END IF;
1876:
1877: if p_wave_simulation_mode ='Y' then l_simulation_mode := 0; end if;

Line 1880: x_return_status := fnd_api.g_ret_sts_success;

1876:
1877: if p_wave_simulation_mode ='Y' then l_simulation_mode := 0; end if;
1878: --
1879: -- Initialisize API return status to access
1880: x_return_status := fnd_api.g_ret_sts_success;
1881: --
1882: g_trace_header_id := NULL;
1883: g_business_object_id := NULL;
1884: g_sugg_failure_message := NULL; -- Patchset 'J'

Line 2012: IF l_return_status = fnd_api.g_ret_sts_error THEN

2008: , l_request_line_rec
2009: , l_request_context
2010: , p_wave_simulation_mode);
2011:
2012: IF l_return_status = fnd_api.g_ret_sts_error THEN
2013: RAISE fnd_api.g_exc_error;
2014: END IF;
2015: IF l_debug = 1 THEN
2016: log_event(l_api_name, 'Create Suggestions', 'after init');

Line 2013: RAISE fnd_api.g_exc_error;

2009: , l_request_context
2010: , p_wave_simulation_mode);
2011:
2012: IF l_return_status = fnd_api.g_ret_sts_error THEN
2013: RAISE fnd_api.g_exc_error;
2014: END IF;
2015: IF l_debug = 1 THEN
2016: log_event(l_api_name, 'Create Suggestions', 'after init');
2017: log_event(l_api_name, 'Create Suggestions', 'l_return_status '||l_return_status);

Line 2036: /*IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2032: l_request_line_rec.to_locator_id is not null THEN
2033: g_Is_xdock := TRUE ;
2034: END IF;
2035:
2036: /*IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2037: RAISE fnd_api.g_exc_unexpected_error;
2038: END IF;*/
2039: -- Transfer flag is always false when simulating
2040: -- picking rules or strategies. When simulation putaway rules or

Line 2037: RAISE fnd_api.g_exc_unexpected_error;

2033: g_Is_xdock := TRUE ;
2034: END IF;
2035:
2036: /*IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2037: RAISE fnd_api.g_exc_unexpected_error;
2038: END IF;*/
2039: -- Transfer flag is always false when simulating
2040: -- picking rules or strategies. When simulation putaway rules or
2041: -- strategies for transfers, we execute the picking side of the engine

Line 2058: RAISE fnd_api.g_exc_unexpected_error;

2054: IF NOT inv_cache. set_mtrh_rec(l_request_line_rec.header_id) THEN
2055: If l_debug = 1 THEN
2056: log_event(l_api_name,'Create Suggestions','MTRH not found ');
2057: End If;
2058: RAISE fnd_api.g_exc_unexpected_error;
2059: END IF;
2060: l_move_order_type :=inv_cache.mtrh_rec.move_order_type;
2061: --8809951 end
2062: IF l_debug = 1 THEN

Line 2212: RAISE fnd_api.g_exc_unexpected_error;

2208: ELSE
2209: IF l_debug = 1 THEN
2210: log_error(l_api_name, 'Create Suggestions','Error calling inv_cache.set_mol_rec: ');
2211: END IF;
2212: RAISE fnd_api.g_exc_unexpected_error;
2213: END IF;
2214:
2215: IF l_debug = 1 THEN
2216: log_statement(l_api_name, 'Create Suggestions'

Line 2220: l_return_status := fnd_api.g_ret_sts_success;

2216: log_statement(l_api_name, 'Create Suggestions'
2217: ,'Calling stub API to check dual UOM allocation settings');
2218: END IF;
2219:
2220: l_return_status := fnd_api.g_ret_sts_success;
2221: wms_re_custom_pub.set_dualuom_alloc_prefs(
2222: p_organization_id => l_request_line_rec.organization_id
2223: , p_inventory_item_id => l_request_line_rec.inventory_item_id
2224: , p_move_order_type => l_move_order_type

Line 2234: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2230: , x_sec_qty_round_mode => l_sec_qty_round_mode
2231: , x_target_uom => l_target_uom
2232: );
2233:
2234: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2235: IF l_debug = 1 THEN
2236: log_error(l_api_name, 'Create Suggestions'
2237: ,'Error status returned from set_dualuom_alloc_prefs: ' || l_return_status);
2238: log_error(l_api_name, 'Create Suggestions'

Line 2435: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2431: , p_reservations
2432: , l_allow_non_partial_rules);
2433:
2434: --
2435: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2436: RAISE fnd_api.g_exc_error;
2437: END IF;
2438: ELSE
2439: -- Treat receipt for transfers, ie. copy the issue output data in

Line 2436: RAISE fnd_api.g_exc_error;

2432: , l_allow_non_partial_rules);
2433:
2434: --
2435: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2436: RAISE fnd_api.g_exc_error;
2437: END IF;
2438: ELSE
2439: -- Treat receipt for transfers, ie. copy the issue output data in
2440: -- WMS_TRANSACTIONS_TEMP as new input records for receipt part

Line 2445: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2441: prepare_transfer_receipt(l_return_status
2442: , l_request_line_rec
2443: , l_request_context);
2444: --
2445: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2446: RAISE fnd_api.g_exc_error;
2447: END IF;
2448: END IF;
2449: END IF;

Line 2446: RAISE fnd_api.g_exc_error;

2442: , l_request_line_rec
2443: , l_request_context);
2444: --
2445: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2446: RAISE fnd_api.g_exc_error;
2447: END IF;
2448: END IF;
2449: END IF;
2450: -- LG convergence add

Line 2490: , p_init_msg_list => fnd_api.g_false

2486: log_procedure(l_api_name, 'insert_trace_header', 'Calling insert_trace_header ');
2487: END IF;
2488: wms_search_order_globals_pvt.insert_trace_header(
2489: p_api_version => 1.0
2490: , p_init_msg_list => fnd_api.g_false
2491: , p_validation_level => fnd_api.g_valid_level_full
2492: , x_return_status => l_return_status
2493: , x_msg_count => l_msg_count
2494: , x_msg_data => l_msg_data

Line 2491: , p_validation_level => fnd_api.g_valid_level_full

2487: END IF;
2488: wms_search_order_globals_pvt.insert_trace_header(
2489: p_api_version => 1.0
2490: , p_init_msg_list => fnd_api.g_false
2491: , p_validation_level => fnd_api.g_valid_level_full
2492: , x_return_status => l_return_status
2493: , x_msg_count => l_msg_count
2494: , x_msg_data => l_msg_data
2495: , x_header_id => g_trace_header_id

Line 2506: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2502: , p_object_id => l_sequence_number
2503: , p_strategy_id => l_strategy_id
2504: );
2505:
2506: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2507: RAISE fnd_api.g_exc_error;
2508: END IF;
2509: END IF;
2510:

Line 2507: RAISE fnd_api.g_exc_error;

2503: , p_strategy_id => l_strategy_id
2504: );
2505:
2506: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2507: RAISE fnd_api.g_exc_error;
2508: END IF;
2509: END IF;
2510:
2511: -- Added to support PJM

Line 2644: , p_init_msg_list => fnd_api.g_false

2640: l_return_type_id := 0;
2641: l_rule_id := NULL; --- Bug# 5178290 / 5233300
2642: wms_rules_workbench_pvt.search(
2643: p_api_version => 1.0
2644: , p_init_msg_list => fnd_api.g_false
2645: , p_validation_level => fnd_api.g_valid_level_none
2646: , x_return_status => l_return_status
2647: , x_msg_count => l_msg_count
2648: , x_msg_data => l_msg_data

Line 2645: , p_validation_level => fnd_api.g_valid_level_none

2641: l_rule_id := NULL; --- Bug# 5178290 / 5233300
2642: wms_rules_workbench_pvt.search(
2643: p_api_version => 1.0
2644: , p_init_msg_list => fnd_api.g_false
2645: , p_validation_level => fnd_api.g_valid_level_none
2646: , x_return_status => l_return_status
2647: , x_msg_count => l_msg_count
2648: , x_msg_data => l_msg_data
2649: , p_transaction_temp_id => p_transaction_temp_id

Line 2670: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2666:
2667: -- If no strategy is assigned, still detail, but
2668: -- with no strategy or rules
2669:
2670: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2671:
2672: IF l_debug = 1 THEN
2673: log_event(
2674: l_api_name

Line 2697: END IF; -- FND_API.G_RET_STS_SUCCESS

2693: ELSE
2694: log_statement(l_api_name, 'wms_rules_workbench_pvt.search()', 'l_rule_id '|| l_rule_id );
2695: END IF;
2696:
2697: END IF; -- FND_API.G_RET_STS_SUCCESS
2698:
2699: END IF; -- J PROJECT : if not quickpick
2700: END IF; --STRATEGY ID / Rule ID is NULL
2701:

Line 2759: p_init_msg_list => fnd_api.g_false,

2755:
2756: wms_strategy_pvt.apply
2757: (
2758: p_api_version => 1.0,
2759: p_init_msg_list => fnd_api.g_false,
2760: p_validation_level => fnd_api.g_valid_level_none,
2761: x_return_status => l_return_status,
2762: x_msg_count => l_msg_count,
2763: x_msg_data => l_msg_data,

Line 2760: p_validation_level => fnd_api.g_valid_level_none,

2756: wms_strategy_pvt.apply
2757: (
2758: p_api_version => 1.0,
2759: p_init_msg_list => fnd_api.g_false,
2760: p_validation_level => fnd_api.g_valid_level_none,
2761: x_return_status => l_return_status,
2762: x_msg_count => l_msg_count,
2763: x_msg_data => l_msg_data,
2764: p_transaction_temp_id => p_transaction_temp_id,

Line 2794: IF l_return_status <> fnd_api.g_ret_sts_success then

2790: l_quick_Pick_flag := 'N';
2791: IF l_debug = 1 THEN
2792: log_event(l_api_name, ' Create suggestions', ' Setting the value of l_quick_Pick');
2793: END IF;
2794: IF l_return_status <> fnd_api.g_ret_sts_success then
2795: RAISE fnd_api.g_exc_error;
2796: ELSE
2797: IF ((WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SUB_STATUS_NA' ) or
2798: (WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SERIAL_STATUS_NA' )) then

Line 2795: RAISE fnd_api.g_exc_error;

2791: IF l_debug = 1 THEN
2792: log_event(l_api_name, ' Create suggestions', ' Setting the value of l_quick_Pick');
2793: END IF;
2794: IF l_return_status <> fnd_api.g_ret_sts_success then
2795: RAISE fnd_api.g_exc_error;
2796: ELSE
2797: IF ((WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SUB_STATUS_NA' ) or
2798: (WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SERIAL_STATUS_NA' )) then
2799: IF l_debug = 1 THEN

Line 2811: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2807: END IF;
2808: END IF;
2809: /* Commented for Bug #4006426
2810: ELSE
2811: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2812: RAISE fnd_api.g_exc_error;
2813: END IF;
2814: END IF;
2815: */

Line 2812: RAISE fnd_api.g_exc_error;

2808: END IF;
2809: /* Commented for Bug #4006426
2810: ELSE
2811: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2812: RAISE fnd_api.g_exc_error;
2813: END IF;
2814: END IF;
2815: */
2816: display_temp_records;

Line 2837: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2833: , p_organization_id => l_request_line_rec.organization_id
2834: , p_inventory_item_id => l_request_line_rec.inventory_item_id
2835: );
2836:
2837: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2838: IF l_debug = 1 THEN
2839: log_event(l_api_name, 'Create Suggestions','err in rollback_capacity: '|| l_msg_data);
2840: END IF;
2841: RAISE fnd_api.g_exc_error;

Line 2841: RAISE fnd_api.g_exc_error;

2837: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2838: IF l_debug = 1 THEN
2839: log_event(l_api_name, 'Create Suggestions','err in rollback_capacity: '|| l_msg_data);
2840: END IF;
2841: RAISE fnd_api.g_exc_error;
2842: END IF;
2843: END IF;
2844:
2845: -- Insert rows to MTL_MATERIAL_TRANSACTIONS_TEMP,

Line 2866: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2862: ELSE
2863: output_issue_or_receipt(l_return_status, l_request_line_rec, l_request_context, p_plan_tasks);
2864: END IF;
2865:
2866: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2867: RAISE fnd_api.g_exc_error;
2868: END IF;
2869:
2870: IF l_simulation_mode = g_no_simulation

Line 2867: RAISE fnd_api.g_exc_error;

2863: output_issue_or_receipt(l_return_status, l_request_line_rec, l_request_context, p_plan_tasks);
2864: END IF;
2865:
2866: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2867: RAISE fnd_api.g_exc_error;
2868: END IF;
2869:
2870: IF l_simulation_mode = g_no_simulation
2871: AND wms_rule_pvt.isruledebugon(l_simulation_mode) THEN

Line 2880: , p_init_msg_list => fnd_api.g_false

2876: 'Calling insert_txn_trace_rows ');
2877: END IF;
2878: wms_search_order_globals_pvt.insert_txn_trace_rows(
2879: p_api_version => 1.0
2880: , p_init_msg_list => fnd_api.g_false
2881: , p_validation_level => fnd_api.g_valid_level_full
2882: , x_return_status => l_return_status
2883: , x_msg_count => l_msg_count
2884: , x_msg_data => l_msg_data

Line 2881: , p_validation_level => fnd_api.g_valid_level_full

2877: END IF;
2878: wms_search_order_globals_pvt.insert_txn_trace_rows(
2879: p_api_version => 1.0
2880: , p_init_msg_list => fnd_api.g_false
2881: , p_validation_level => fnd_api.g_valid_level_full
2882: , x_return_status => l_return_status
2883: , x_msg_count => l_msg_count
2884: , x_msg_data => l_msg_data
2885: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id

Line 2894: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2890:
2891: -- Delete records from WMS_TRANSACTIONS_TEMP
2892: purge_detail_temp_records(l_return_status, l_request_line_rec);
2893:
2894: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2895: RAISE fnd_api.g_exc_error;
2896: END IF;
2897: --
2898: END IF;

Line 2895: RAISE fnd_api.g_exc_error;

2891: -- Delete records from WMS_TRANSACTIONS_TEMP
2892: purge_detail_temp_records(l_return_status, l_request_line_rec);
2893:
2894: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2895: RAISE fnd_api.g_exc_error;
2896: END IF;
2897: --
2898: END IF;
2899:

Line 2931: IF fnd_api.to_boolean(p_commit) THEN

2927: end if;
2928: end if;
2929:
2930: -- Standard check of p_commit
2931: IF fnd_api.to_boolean(p_commit) THEN
2932: COMMIT;
2933: END IF;
2934:
2935: /*-- debugging section

Line 2962: WHEN fnd_api.g_exc_error THEN

2958: log_procedure(l_api_name, 'End', 'End create_suggestions');
2959: END IF;
2960: --
2961: EXCEPTION
2962: WHEN fnd_api.g_exc_error THEN
2963: ROLLBACK TO create_suggestions_sa;
2964: x_return_status := fnd_api.g_ret_sts_error;
2965: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2966: IF l_debug = 1 THEN

Line 2964: x_return_status := fnd_api.g_ret_sts_error;

2960: --
2961: EXCEPTION
2962: WHEN fnd_api.g_exc_error THEN
2963: ROLLBACK TO create_suggestions_sa;
2964: x_return_status := fnd_api.g_ret_sts_error;
2965: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2966: IF l_debug = 1 THEN
2967: log_error(l_api_name, 'error', 'Error in create_suggestions - ' || x_msg_data);
2968: END IF ;

Line 2970: WHEN fnd_api.g_exc_unexpected_error THEN

2966: IF l_debug = 1 THEN
2967: log_error(l_api_name, 'error', 'Error in create_suggestions - ' || x_msg_data);
2968: END IF ;
2969: --
2970: WHEN fnd_api.g_exc_unexpected_error THEN
2971: ROLLBACK TO create_suggestions_sa;
2972: x_return_status := fnd_api.g_ret_sts_unexp_error;
2973: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2974: IF l_debug = 1 THEN

Line 2972: x_return_status := fnd_api.g_ret_sts_unexp_error;

2968: END IF ;
2969: --
2970: WHEN fnd_api.g_exc_unexpected_error THEN
2971: ROLLBACK TO create_suggestions_sa;
2972: x_return_status := fnd_api.g_ret_sts_unexp_error;
2973: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2974: IF l_debug = 1 THEN
2975: log_error(l_api_name, 'unexp_error', 'Unexpected error ' || 'in create_suggestions - ' || x_msg_data);
2976: END IF;

Line 2980: x_return_status := fnd_api.g_ret_sts_unexp_error;

2976: END IF;
2977: --
2978: WHEN OTHERS THEN
2979: ROLLBACK TO create_suggestions_sa;
2980: x_return_status := fnd_api.g_ret_sts_unexp_error;
2981:
2982: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2983: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2984: END IF;

Line 3028: RAISE fnd_api.g_exc_unexpected_error;

3024: l_transaction_source_type_id := inv_cache.mol_rec.transaction_source_type_id;
3025: l_txn_source_line_id := inv_cache.mol_rec.txn_source_line_id;
3026: l_transaction_type_id := inv_cache.mol_rec.transaction_type_id;
3027: ELSE
3028: RAISE fnd_api.g_exc_unexpected_error;
3029: END IF;
3030:
3031: l_return_value := INV_CACHE.set_item_rec(l_organization_id, l_inventory_item_id);
3032:

Line 3036: RAISE fnd_api.g_exc_unexpected_error;

3032:
3033: IF (l_return_value) THEN
3034: l_is_item_lot_controlled := NVL(inv_cache.item_rec.lot_control_code,1);
3035: ELSE
3036: RAISE fnd_api.g_exc_unexpected_error;
3037: END IF;
3038:
3039: IF(l_debug=1) THEN
3040: inv_log_util.trace( 'Value of organization_id is : ' ||l_organization_id, 'Inside check_exp_lot_txn_allowed ' , 9);

Line 3061: RAISE fnd_api.g_exc_unexpected_error;

3057: IF inv_cache.set_mtt_rec(l_transaction_type_id) THEN
3058: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
3059: l_txn_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
3060: ELSE
3061: RAISE fnd_api.g_exc_unexpected_error;
3062: END IF;
3063:
3064: IF(l_debug=1) THEN
3065: inv_log_util.trace( 'Value of l_transaction_type_id : ' ||l_transaction_type_id, 'Inside check_exp_lot_txn_allowed ', 9);