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

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

Line 539: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

Line 540: RAISE fnd_api.g_exc_error;

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

Line 542: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

Line 543: RAISE fnd_api.g_exc_unexpected_error;

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

Line 663: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

Line 664: RAISE fnd_api.g_exc_error;

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

Line 666: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

662: insert_detail_temp_records(l_return_status, l_wms_txn_temp_tbl);
663: IF l_return_status = fnd_api.g_ret_sts_error THEN
664: RAISE fnd_api.g_exc_error;
665: END IF;
666: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
667: RAISE fnd_api.g_exc_unexpected_error;
668: END IF;
669: END IF;
670:

Line 667: RAISE fnd_api.g_exc_unexpected_error;

663: IF l_return_status = fnd_api.g_ret_sts_error THEN
664: RAISE fnd_api.g_exc_error;
665: END IF;
666: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
667: RAISE fnd_api.g_exc_unexpected_error;
668: END IF;
669: END IF;
670:
671: IF l_debug = 1 THEN

Line 676: WHEN fnd_api.g_exc_error THEN

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

Line 690: x_return_status := fnd_api.g_ret_sts_error;

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

Line 695: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 709: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 716: x_return_status := fnd_api.g_ret_sts_unexp_error;

712: END IF;
713: --
714: WHEN OTHERS THEN
715:
716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717:
718: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
719: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
720: END IF;

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

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

Line 801: x_return_status := fnd_api.g_ret_sts_success;

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

Line 883: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

Line 884: RAISE fnd_api.g_exc_error;

880: -- as input to put away detailing
881: insert_detail_temp_records(l_return_status, l_wms_txn_temp_tbl);
882:
883: IF l_return_status = fnd_api.g_ret_sts_error THEN
884: RAISE fnd_api.g_exc_error;
885: END IF;
886:
887: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
888: RAISE fnd_api.g_exc_unexpected_error;

Line 887: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

883: IF l_return_status = fnd_api.g_ret_sts_error THEN
884: RAISE fnd_api.g_exc_error;
885: END IF;
886:
887: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
888: RAISE fnd_api.g_exc_unexpected_error;
889: END IF;
890:
891: x_return_status := l_return_status;

Line 888: RAISE fnd_api.g_exc_unexpected_error;

884: RAISE fnd_api.g_exc_error;
885: END IF;
886:
887: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
888: RAISE fnd_api.g_exc_unexpected_error;
889: END IF;
890:
891: x_return_status := l_return_status;
892:

Line 898: WHEN fnd_api.g_exc_error THEN

894: log_procedure(l_api_name, 'end', 'End prepare_transfer_receipt');
895: END IF;
896:
897: EXCEPTION
898: WHEN fnd_api.g_exc_error THEN
899: IF l_put_input_csr%ISOPEN THEN
900: CLOSE l_put_input_csr;
901: END IF;
902:

Line 903: x_return_status := fnd_api.g_ret_sts_error;

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

Line 908: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 913: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 923: x_return_status := fnd_api.g_ret_sts_unexp_error;

919: IF l_put_input_csr%ISOPEN THEN
920: CLOSE l_put_input_csr;
921: END IF;
922:
923: x_return_status := fnd_api.g_ret_sts_unexp_error;
924:
925: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
926: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
927: END IF;

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

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

Line 1149: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1175: IF l_return_status = fnd_api.g_ret_sts_error THEN

1171: , p_request_line_rec
1172: , p_request_context
1173: , p_plan_tasks);
1174:
1175: IF l_return_status = fnd_api.g_ret_sts_error THEN
1176: RAISE fnd_api.g_exc_error;
1177: END IF;
1178:
1179: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1176: RAISE fnd_api.g_exc_error;

1172: , p_request_context
1173: , p_plan_tasks);
1174:
1175: IF l_return_status = fnd_api.g_ret_sts_error THEN
1176: RAISE fnd_api.g_exc_error;
1177: END IF;
1178:
1179: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1180: RAISE fnd_api.g_exc_unexpected_error;

Line 1179: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1175: IF l_return_status = fnd_api.g_ret_sts_error THEN
1176: RAISE fnd_api.g_exc_error;
1177: END IF;
1178:
1179: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1180: RAISE fnd_api.g_exc_unexpected_error;
1181: END IF;
1182:
1183: x_return_status := l_return_status;

Line 1180: RAISE fnd_api.g_exc_unexpected_error;

1176: RAISE fnd_api.g_exc_error;
1177: END IF;
1178:
1179: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1180: RAISE fnd_api.g_exc_unexpected_error;
1181: END IF;
1182:
1183: x_return_status := l_return_status;
1184:

Line 1190: WHEN fnd_api.g_exc_error THEN

1186: log_procedure(l_api_name, 'end', 'End output_issue_or_receipt');
1187: END IF;
1188:
1189: EXCEPTION
1190: WHEN fnd_api.g_exc_error THEN
1191: IF l_pp_temp_csr%ISOPEN THEN
1192: CLOSE l_pp_temp_csr;
1193: END IF;
1194:

Line 1195: x_return_status := fnd_api.g_ret_sts_error;

1191: IF l_pp_temp_csr%ISOPEN THEN
1192: CLOSE l_pp_temp_csr;
1193: END IF;
1194:
1195: x_return_status := fnd_api.g_ret_sts_error;
1196: IF l_debug = 1 THEN
1197: log_error(l_api_name, 'error', 'Error in output_issue_or_receipt');
1198: END IF;
1199:

Line 1201: WHEN fnd_api.g_exc_unexpected_error THEN

1197: log_error(l_api_name, 'error', 'Error in output_issue_or_receipt');
1198: END IF;
1199:
1200: --
1201: WHEN fnd_api.g_exc_unexpected_error THEN
1202: IF l_pp_temp_csr%ISOPEN THEN
1203: CLOSE l_pp_temp_csr;
1204: END IF;
1205:

Line 1206: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1216: x_return_status := fnd_api.g_ret_sts_unexp_error;

1212: IF l_pp_temp_csr%ISOPEN THEN
1213: CLOSE l_pp_temp_csr;
1214: END IF;
1215:
1216: x_return_status := fnd_api.g_ret_sts_unexp_error;
1217:
1218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1219: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1220: END IF;

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

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

Line 1523: IF l_return_status = fnd_api.g_ret_sts_error THEN

1519: , p_request_line_rec
1520: , p_request_context
1521: , p_plan_tasks);
1522:
1523: IF l_return_status = fnd_api.g_ret_sts_error THEN
1524: RAISE fnd_api.g_exc_error;
1525: END IF;
1526:
1527: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1524: RAISE fnd_api.g_exc_error;

1520: , p_request_context
1521: , p_plan_tasks);
1522:
1523: IF l_return_status = fnd_api.g_ret_sts_error THEN
1524: RAISE fnd_api.g_exc_error;
1525: END IF;
1526:
1527: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1528: RAISE fnd_api.g_exc_unexpected_error;

Line 1527: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1523: IF l_return_status = fnd_api.g_ret_sts_error THEN
1524: RAISE fnd_api.g_exc_error;
1525: END IF;
1526:
1527: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1528: RAISE fnd_api.g_exc_unexpected_error;
1529: END IF;
1530:
1531: x_return_status := l_return_status;

Line 1528: RAISE fnd_api.g_exc_unexpected_error;

1524: RAISE fnd_api.g_exc_error;
1525: END IF;
1526:
1527: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1528: RAISE fnd_api.g_exc_unexpected_error;
1529: END IF;
1530:
1531: x_return_status := l_return_status;
1532:

Line 1538: WHEN fnd_api.g_exc_error THEN

1534: log_procedure(l_api_name, 'end', 'End combine_transfer');
1535: END IF;
1536: --
1537: EXCEPTION
1538: WHEN fnd_api.g_exc_error THEN
1539: IF l_issue_csr%ISOPEN THEN
1540: CLOSE l_issue_csr;
1541: END IF;
1542:

Line 1547: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1552: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 1561: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1575: x_return_status := fnd_api.g_ret_sts_unexp_error;

1571: IF l_receipt_csr%ISOPEN THEN
1572: CLOSE l_receipt_csr;
1573: END IF;
1574:
1575: x_return_status := fnd_api.g_ret_sts_unexp_error;
1576:
1577: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1578: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1579: END IF;

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

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

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

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

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

1658: l_api_version CONSTANT NUMBER := 1.0;
1659: l_api_name CONSTANT VARCHAR2(30) := 'Create_Suggestions';
1660: l_strategy_id NUMBER;
1661: l_rule_id NUMBER; -- [l_rule_id New Column Added for K ]
1662: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1663: l_msg_count NUMBER;
1664: l_msg_data VARCHAR2(2000);
1665: l_counter INTEGER;
1666: l_type_code NUMBER;

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

1814: SAVEPOINT create_suggestions_sa;
1815:
1816: --
1817: -- Standard Call to check for call compatibility
1818: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1819: RAISE fnd_api.g_exc_unexpected_error;
1820: END IF;
1821:
1822: --

Line 1819: RAISE fnd_api.g_exc_unexpected_error;

1815:
1816: --
1817: -- Standard Call to check for call compatibility
1818: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1819: RAISE fnd_api.g_exc_unexpected_error;
1820: END IF;
1821:
1822: --
1823: -- Initialize message list if p_init_msg_list is set to true

Line 1824: IF fnd_api.to_boolean(p_init_msg_list) THEN

1820: END IF;
1821:
1822: --
1823: -- Initialize message list if p_init_msg_list is set to true
1824: IF fnd_api.to_boolean(p_init_msg_list) THEN
1825: fnd_msg_pub.initialize;
1826: END IF;
1827:
1828: --

Line 1830: x_return_status := fnd_api.g_ret_sts_success;

1826: END IF;
1827:
1828: --
1829: -- Initialisize API return status to access
1830: x_return_status := fnd_api.g_ret_sts_success;
1831: --
1832: g_trace_header_id := NULL;
1833: g_business_object_id := NULL;
1834: g_sugg_failure_message := NULL; -- Patchset 'J'

Line 1952: IF l_return_status = fnd_api.g_ret_sts_error THEN

1948: , p_suggest_serial
1949: , l_request_line_rec
1950: , l_request_context);
1951:
1952: IF l_return_status = fnd_api.g_ret_sts_error THEN
1953: RAISE fnd_api.g_exc_error;
1954: END IF;
1955: IF l_debug = 1 THEN
1956: log_event(l_api_name, 'Create Suggestions', 'after init');

Line 1953: RAISE fnd_api.g_exc_error;

1949: , l_request_line_rec
1950: , l_request_context);
1951:
1952: IF l_return_status = fnd_api.g_ret_sts_error THEN
1953: RAISE fnd_api.g_exc_error;
1954: END IF;
1955: IF l_debug = 1 THEN
1956: log_event(l_api_name, 'Create Suggestions', 'after init');
1957: log_event(l_api_name, 'Create Suggestions', 'l_return_status '||l_return_status);

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

1969: l_request_line_rec.to_locator_id is not null THEN
1970: g_Is_xdock := TRUE ;
1971: END IF;
1972:
1973: /*IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1974: RAISE fnd_api.g_exc_unexpected_error;
1975: END IF;*/
1976: -- Transfer flag is always false when simulating
1977: -- picking rules or strategies. When simulation putaway rules or

Line 1974: RAISE fnd_api.g_exc_unexpected_error;

1970: g_Is_xdock := TRUE ;
1971: END IF;
1972:
1973: /*IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1974: RAISE fnd_api.g_exc_unexpected_error;
1975: END IF;*/
1976: -- Transfer flag is always false when simulating
1977: -- picking rules or strategies. When simulation putaway rules or
1978: -- strategies for transfers, we execute the picking side of the engine

Line 1996: RAISE fnd_api.g_exc_unexpected_error;

1992:
1993: IF c_move_order_type%NOTFOUND THEN
1994: --produce error
1995: CLOSE c_move_order_type;
1996: RAISE fnd_api.g_exc_unexpected_error;
1997: END IF;
1998:
1999: CLOSE c_move_order_type;
2000: IF l_debug = 1 THEN

Line 2225: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2221: , p_reservations
2222: , l_allow_non_partial_rules);
2223:
2224: --
2225: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2226: RAISE fnd_api.g_exc_error;
2227: END IF;
2228: ELSE
2229: -- Treat receipt for transfers, ie. copy the issue output data in

Line 2226: RAISE fnd_api.g_exc_error;

2222: , l_allow_non_partial_rules);
2223:
2224: --
2225: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2226: RAISE fnd_api.g_exc_error;
2227: END IF;
2228: ELSE
2229: -- Treat receipt for transfers, ie. copy the issue output data in
2230: -- WMS_TRANSACTIONS_TEMP as new input records for receipt part

Line 2235: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2231: prepare_transfer_receipt(l_return_status
2232: , l_request_line_rec
2233: , l_request_context);
2234: --
2235: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2236: RAISE fnd_api.g_exc_error;
2237: END IF;
2238: END IF;
2239: END IF;

Line 2236: RAISE fnd_api.g_exc_error;

2232: , l_request_line_rec
2233: , l_request_context);
2234: --
2235: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2236: RAISE fnd_api.g_exc_error;
2237: END IF;
2238: END IF;
2239: END IF;
2240: -- LG convergence add

Line 2280: , p_init_msg_list => fnd_api.g_false

2276: log_procedure(l_api_name, 'insert_trace_header', 'Calling insert_trace_header ');
2277: END IF;
2278: wms_search_order_globals_pvt.insert_trace_header(
2279: p_api_version => 1.0
2280: , p_init_msg_list => fnd_api.g_false
2281: , p_validation_level => fnd_api.g_valid_level_full
2282: , x_return_status => l_return_status
2283: , x_msg_count => l_msg_count
2284: , x_msg_data => l_msg_data

Line 2281: , p_validation_level => fnd_api.g_valid_level_full

2277: END IF;
2278: wms_search_order_globals_pvt.insert_trace_header(
2279: p_api_version => 1.0
2280: , p_init_msg_list => fnd_api.g_false
2281: , p_validation_level => fnd_api.g_valid_level_full
2282: , x_return_status => l_return_status
2283: , x_msg_count => l_msg_count
2284: , x_msg_data => l_msg_data
2285: , x_header_id => g_trace_header_id

Line 2296: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2292: , p_object_id => l_sequence_number
2293: , p_strategy_id => l_strategy_id
2294: );
2295:
2296: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2297: RAISE fnd_api.g_exc_error;
2298: END IF;
2299: END IF;
2300:

Line 2297: RAISE fnd_api.g_exc_error;

2293: , p_strategy_id => l_strategy_id
2294: );
2295:
2296: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2297: RAISE fnd_api.g_exc_error;
2298: END IF;
2299: END IF;
2300:
2301: -- Added to support PJM

Line 2391: , p_init_msg_list => fnd_api.g_false

2387: l_return_type_id := 0;
2388: l_rule_id := NULL; --- Bug# 5178290 / 5233300
2389: wms_rules_workbench_pvt.search(
2390: p_api_version => 1.0
2391: , p_init_msg_list => fnd_api.g_false
2392: , p_validation_level => fnd_api.g_valid_level_none
2393: , x_return_status => l_return_status
2394: , x_msg_count => l_msg_count
2395: , x_msg_data => l_msg_data

Line 2392: , p_validation_level => fnd_api.g_valid_level_none

2388: l_rule_id := NULL; --- Bug# 5178290 / 5233300
2389: wms_rules_workbench_pvt.search(
2390: p_api_version => 1.0
2391: , p_init_msg_list => fnd_api.g_false
2392: , p_validation_level => fnd_api.g_valid_level_none
2393: , x_return_status => l_return_status
2394: , x_msg_count => l_msg_count
2395: , x_msg_data => l_msg_data
2396: , p_transaction_temp_id => p_transaction_temp_id

Line 2417: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2413:
2414: -- If no strategy is assigned, still detail, but
2415: -- with no strategy or rules
2416:
2417: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2418:
2419: IF l_debug = 1 THEN
2420: log_event(
2421: l_api_name

Line 2444: END IF; -- FND_API.G_RET_STS_SUCCESS

2440: ELSE
2441: log_statement(l_api_name, 'wms_rules_workbench_pvt.search()', 'l_rule_id '|| l_rule_id );
2442: END IF;
2443:
2444: END IF; -- FND_API.G_RET_STS_SUCCESS
2445:
2446: END IF; -- J PROJECT : if not quickpick
2447: END IF; --STRATEGY ID / Rule ID is NULL
2448:

Line 2505: p_init_msg_list => fnd_api.g_false,

2501:
2502: wms_strategy_pvt.apply
2503: (
2504: p_api_version => 1.0,
2505: p_init_msg_list => fnd_api.g_false,
2506: p_validation_level => fnd_api.g_valid_level_none,
2507: x_return_status => l_return_status,
2508: x_msg_count => l_msg_count,
2509: x_msg_data => l_msg_data,

Line 2506: p_validation_level => fnd_api.g_valid_level_none,

2502: wms_strategy_pvt.apply
2503: (
2504: p_api_version => 1.0,
2505: p_init_msg_list => fnd_api.g_false,
2506: p_validation_level => fnd_api.g_valid_level_none,
2507: x_return_status => l_return_status,
2508: x_msg_count => l_msg_count,
2509: x_msg_data => l_msg_data,
2510: p_transaction_temp_id => p_transaction_temp_id,

Line 2539: IF l_return_status <> fnd_api.g_ret_sts_success then

2535: l_quick_Pick_flag := 'N';
2536: IF l_debug = 1 THEN
2537: log_event(l_api_name, ' Create suggestions', ' Setting the value of l_quick_Pick');
2538: END IF;
2539: IF l_return_status <> fnd_api.g_ret_sts_success then
2540: RAISE fnd_api.g_exc_error;
2541: ELSE
2542: IF ((WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SUB_STATUS_NA' ) or
2543: (WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SERIAL_STATUS_NA' )) then

Line 2540: RAISE fnd_api.g_exc_error;

2536: IF l_debug = 1 THEN
2537: log_event(l_api_name, ' Create suggestions', ' Setting the value of l_quick_Pick');
2538: END IF;
2539: IF l_return_status <> fnd_api.g_ret_sts_success then
2540: RAISE fnd_api.g_exc_error;
2541: ELSE
2542: IF ((WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SUB_STATUS_NA' ) or
2543: (WMS_ENGINE_PVT.G_SUGG_FAILURE_MESSAGE = 'WMS_ATT_SERIAL_STATUS_NA' )) then
2544: IF l_debug = 1 THEN

Line 2556: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2552: END IF;
2553: END IF;
2554: /* Commented for Bug #4006426
2555: ELSE
2556: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2557: RAISE fnd_api.g_exc_error;
2558: END IF;
2559: END IF;
2560: */

Line 2557: RAISE fnd_api.g_exc_error;

2553: END IF;
2554: /* Commented for Bug #4006426
2555: ELSE
2556: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2557: RAISE fnd_api.g_exc_error;
2558: END IF;
2559: END IF;
2560: */
2561: display_temp_records;

Line 2582: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2578: , p_organization_id => l_request_line_rec.organization_id
2579: , p_inventory_item_id => l_request_line_rec.inventory_item_id
2580: );
2581:
2582: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2583: IF l_debug = 1 THEN
2584: log_event(l_api_name, 'Create Suggestions','err in rollback_capacity: '|| l_msg_data);
2585: END IF;
2586: RAISE fnd_api.g_exc_error;

Line 2586: RAISE fnd_api.g_exc_error;

2582: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2583: IF l_debug = 1 THEN
2584: log_event(l_api_name, 'Create Suggestions','err in rollback_capacity: '|| l_msg_data);
2585: END IF;
2586: RAISE fnd_api.g_exc_error;
2587: END IF;
2588: END IF;
2589:
2590: -- Insert rows to MTL_MATERIAL_TRANSACTIONS_TEMP,

Line 2606: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2602: ELSE
2603: output_issue_or_receipt(l_return_status, l_request_line_rec, l_request_context, p_plan_tasks);
2604: END IF;
2605:
2606: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2607: RAISE fnd_api.g_exc_error;
2608: END IF;
2609:
2610: IF l_simulation_mode = g_no_simulation

Line 2607: RAISE fnd_api.g_exc_error;

2603: output_issue_or_receipt(l_return_status, l_request_line_rec, l_request_context, p_plan_tasks);
2604: END IF;
2605:
2606: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2607: RAISE fnd_api.g_exc_error;
2608: END IF;
2609:
2610: IF l_simulation_mode = g_no_simulation
2611: AND wms_rule_pvt.isruledebugon(l_simulation_mode) THEN

Line 2620: , p_init_msg_list => fnd_api.g_false

2616: 'Calling insert_txn_trace_rows ');
2617: END IF;
2618: wms_search_order_globals_pvt.insert_txn_trace_rows(
2619: p_api_version => 1.0
2620: , p_init_msg_list => fnd_api.g_false
2621: , p_validation_level => fnd_api.g_valid_level_full
2622: , x_return_status => l_return_status
2623: , x_msg_count => l_msg_count
2624: , x_msg_data => l_msg_data

Line 2621: , p_validation_level => fnd_api.g_valid_level_full

2617: END IF;
2618: wms_search_order_globals_pvt.insert_txn_trace_rows(
2619: p_api_version => 1.0
2620: , p_init_msg_list => fnd_api.g_false
2621: , p_validation_level => fnd_api.g_valid_level_full
2622: , x_return_status => l_return_status
2623: , x_msg_count => l_msg_count
2624: , x_msg_data => l_msg_data
2625: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id

Line 2634: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2630:
2631: -- Delete records from WMS_TRANSACTIONS_TEMP
2632: purge_detail_temp_records(l_return_status, l_request_line_rec);
2633:
2634: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2635: RAISE fnd_api.g_exc_error;
2636: END IF;
2637: --
2638: END IF;

Line 2635: RAISE fnd_api.g_exc_error;

2631: -- Delete records from WMS_TRANSACTIONS_TEMP
2632: purge_detail_temp_records(l_return_status, l_request_line_rec);
2633:
2634: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2635: RAISE fnd_api.g_exc_error;
2636: END IF;
2637: --
2638: END IF;
2639:

Line 2641: IF fnd_api.to_boolean(p_commit) THEN

2637: --
2638: END IF;
2639:
2640: -- Standard check of p_commit
2641: IF fnd_api.to_boolean(p_commit) THEN
2642: COMMIT;
2643: END IF;
2644:
2645: /*-- debugging section

Line 2672: WHEN fnd_api.g_exc_error THEN

2668: log_procedure(l_api_name, 'End', 'End create_suggestions');
2669: END IF;
2670: --
2671: EXCEPTION
2672: WHEN fnd_api.g_exc_error THEN
2673: ROLLBACK TO create_suggestions_sa;
2674: x_return_status := fnd_api.g_ret_sts_error;
2675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2676: IF l_debug = 1 THEN

Line 2674: x_return_status := fnd_api.g_ret_sts_error;

2670: --
2671: EXCEPTION
2672: WHEN fnd_api.g_exc_error THEN
2673: ROLLBACK TO create_suggestions_sa;
2674: x_return_status := fnd_api.g_ret_sts_error;
2675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2676: IF l_debug = 1 THEN
2677: log_error(l_api_name, 'error', 'Error in create_suggestions - ' || x_msg_data);
2678: END IF ;

Line 2680: WHEN fnd_api.g_exc_unexpected_error THEN

2676: IF l_debug = 1 THEN
2677: log_error(l_api_name, 'error', 'Error in create_suggestions - ' || x_msg_data);
2678: END IF ;
2679: --
2680: WHEN fnd_api.g_exc_unexpected_error THEN
2681: ROLLBACK TO create_suggestions_sa;
2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2684: IF l_debug = 1 THEN

Line 2682: x_return_status := fnd_api.g_ret_sts_unexp_error;

2678: END IF ;
2679: --
2680: WHEN fnd_api.g_exc_unexpected_error THEN
2681: ROLLBACK TO create_suggestions_sa;
2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2684: IF l_debug = 1 THEN
2685: log_error(l_api_name, 'unexp_error', 'Unexpected error ' || 'in create_suggestions - ' || x_msg_data);
2686: END IF;

Line 2690: x_return_status := fnd_api.g_ret_sts_unexp_error;

2686: END IF;
2687: --
2688: WHEN OTHERS THEN
2689: ROLLBACK TO create_suggestions_sa;
2690: x_return_status := fnd_api.g_ret_sts_unexp_error;
2691:
2692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2693: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2694: END IF;