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

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

249: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
250: l_transaction_type VARCHAR2(20) := 'DELIVER';
251: l_total_primary_qty NUMBER := 0;
252: l_msg_count NUMBER;
253: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
254: l_group_id NUMBER;
255: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
256: l_err_message VARCHAR2(100);
257: l_temp_message VARCHAR2(100);

Line 420: x_status := fnd_api.g_ret_sts_success;

416: --table to store all RTId, quantity and original_rti_id for lot/serial splits
417: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
418: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
419: BEGIN
420: x_status := fnd_api.g_ret_sts_success;
421:
422: IF (l_debug = 1) THEN
423: print_debug('Enter create_osp_drct_dlvr_rti_rec: 1 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
424: END IF;

Line 545: IF x_status = fnd_api.g_ret_sts_error THEN

541: );
542: END IF;
543:
544: -- x_status is not successful if there is any execution error in matching.
545: IF x_status = fnd_api.g_ret_sts_error THEN
546: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
547: fnd_msg_pub.ADD;
548:
549: IF (l_debug = 1) THEN

Line 553: RAISE fnd_api.g_exc_error;

549: IF (l_debug = 1) THEN
550: print_debug('create_osp_drct_dlvr_rti_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
551: END IF;
552:
553: RAISE fnd_api.g_exc_error;
554: END IF;
555:
556: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
557: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

Line 556: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

552:
553: RAISE fnd_api.g_exc_error;
554: END IF;
555:
556: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
557: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
558: fnd_msg_pub.ADD;
559:
560: IF (l_debug = 1) THEN

Line 566: RAISE fnd_api.g_exc_unexpected_error;

562: 'Exiting create_osp_drct_dlvr_rti_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
563: , 1
564: );
565: END IF;
566: RAISE fnd_api.g_exc_unexpected_error;
567: END IF;
568:
569: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
570: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 578: RAISE fnd_api.g_exc_error;

574: IF (l_debug = 1) THEN
575: print_debug('create_osp_drct_dlvr_rti_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
576: END IF;
577:
578: RAISE fnd_api.g_exc_error;
579: END IF;
580:
581: l_err_message := '@@@';
582:

Line 721: , p_init_msg_lst => FND_API.G_FALSE

717: l_new_rti_info(1).quantity := l_rcv_transaction_rec.transaction_qty;
718:
719: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
720: p_api_version => 1.0
721: , p_init_msg_lst => FND_API.G_FALSE
722: , x_return_status => l_return_status
723: , x_msg_count => l_msg_count
724: , x_msg_data => x_message
725: , p_new_rti_info => l_new_rti_info);

Line 730: RAISE FND_API.G_EXC_ERROR;

726: IF ( NOT l_split_lot_serial_ok) THEN
727: IF (l_debug = 1) THEN
728: print_debug('create_osp_drct_dlvr_rti_rec 8.1: Failure in split_lot_serial', 4);
729: END IF;
730: RAISE FND_API.G_EXC_ERROR;
731: END IF;
732:
733: IF (l_debug = 1) THEN
734: print_debug('create_osp_drct_dlvr_rti_rec 8.2: Call split_lot_serial is OK', 4);

Line 754: IF l_return_status <> fnd_api.g_ret_sts_success THEN

750: , x_msg_count => l_msg_count
751: , x_msg_data => x_message
752: );
753:
754: IF l_return_status <> fnd_api.g_ret_sts_success THEN
755: x_status := l_return_status;
756: END IF;
757:
758: l_progress := '70';

Line 766: WHEN fnd_api.g_exc_error THEN

762: IF (l_debug = 1) THEN
763: print_debug('Exiting create_osp_drct_dlvr_rti_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
764: END IF;
765: EXCEPTION
766: WHEN fnd_api.g_exc_error THEN
767: ROLLBACK TO crt_po_rti_sp;
768: x_status := fnd_api.g_ret_sts_error;
769:
770: IF l_curs_rcpt_detail%ISOPEN THEN

Line 768: x_status := fnd_api.g_ret_sts_error;

764: END IF;
765: EXCEPTION
766: WHEN fnd_api.g_exc_error THEN
767: ROLLBACK TO crt_po_rti_sp;
768: x_status := fnd_api.g_ret_sts_error;
769:
770: IF l_curs_rcpt_detail%ISOPEN THEN
771: CLOSE l_curs_rcpt_detail;
772: END IF;

Line 774: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

770: IF l_curs_rcpt_detail%ISOPEN THEN
771: CLOSE l_curs_rcpt_detail;
772: END IF;
773:
774: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
775:
776: IF (l_debug = 1) THEN
777: print_debug('create_osp_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
778: END IF;

Line 777: print_debug('create_osp_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

773:
774: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
775:
776: IF (l_debug = 1) THEN
777: print_debug('create_osp_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
778: END IF;
779: WHEN fnd_api.g_exc_unexpected_error THEN
780: ROLLBACK TO crt_po_rti_sp;
781: x_status := fnd_api.g_ret_sts_unexp_error;

Line 779: WHEN fnd_api.g_exc_unexpected_error THEN

775:
776: IF (l_debug = 1) THEN
777: print_debug('create_osp_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
778: END IF;
779: WHEN fnd_api.g_exc_unexpected_error THEN
780: ROLLBACK TO crt_po_rti_sp;
781: x_status := fnd_api.g_ret_sts_unexp_error;
782:
783: IF l_curs_rcpt_detail%ISOPEN THEN

Line 781: x_status := fnd_api.g_ret_sts_unexp_error;

777: print_debug('create_osp_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
778: END IF;
779: WHEN fnd_api.g_exc_unexpected_error THEN
780: ROLLBACK TO crt_po_rti_sp;
781: x_status := fnd_api.g_ret_sts_unexp_error;
782:
783: IF l_curs_rcpt_detail%ISOPEN THEN
784: CLOSE l_curs_rcpt_detail;
785: END IF;

Line 787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

783: IF l_curs_rcpt_detail%ISOPEN THEN
784: CLOSE l_curs_rcpt_detail;
785: END IF;
786:
787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
788:
789: IF (l_debug = 1) THEN
790: print_debug('create_osp_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
791: END IF;

Line 790: print_debug('create_osp_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

786:
787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
788:
789: IF (l_debug = 1) THEN
790: print_debug('create_osp_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
791: END IF;
792: WHEN OTHERS THEN
793: ROLLBACK TO crt_po_rti_sp;
794: x_status := fnd_api.g_ret_sts_unexp_error;

Line 794: x_status := fnd_api.g_ret_sts_unexp_error;

790: print_debug('create_osp_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
791: END IF;
792: WHEN OTHERS THEN
793: ROLLBACK TO crt_po_rti_sp;
794: x_status := fnd_api.g_ret_sts_unexp_error;
795:
796: IF l_curs_rcpt_detail%ISOPEN THEN
797: CLOSE l_curs_rcpt_detail;
798: END IF;

Line 804: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

800: IF SQLCODE IS NOT NULL THEN
801: inv_mobile_helper_functions.sql_error('inv_rcv_dir_rcpt_apis.create_osp_drct_dlvr_rti_rec', l_progress, SQLCODE);
802: END IF;
803:
804: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
805:
806: IF (l_debug = 1) THEN
807: print_debug('create_osp_drct_dlvr_rti_rec: OTHER exception : ' || SQLCODE || ' '
808: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

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

863: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
864: l_transaction_type VARCHAR2(20) := 'DELIVER';
865: l_total_primary_qty NUMBER := 0;
866: l_msg_count NUMBER;
867: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
868: l_group_id NUMBER;
869: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
870: --l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
871:

Line 1045: x_status := fnd_api.g_ret_sts_success;

1041: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
1042: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
1043: l_msni_count NUMBER := 0;
1044: BEGIN
1045: x_status := fnd_api.g_ret_sts_success;
1046:
1047: IF (l_debug = 1) THEN
1048: print_debug('Enter create_po_drct_dlvr_rti_rec: 1 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1049: END IF;

Line 1180: IF x_status = fnd_api.g_ret_sts_error THEN

1176: , 4);
1177: END IF;
1178:
1179: -- x_status is not successful if there is any execution error in matching.
1180: IF x_status = fnd_api.g_ret_sts_error THEN
1181: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1182: fnd_msg_pub.ADD;
1183:
1184: IF (l_debug = 1) THEN

Line 1188: RAISE fnd_api.g_exc_error;

1184: IF (l_debug = 1) THEN
1185: print_debug('create_po_drct_dlvr_rti_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1186: END IF;
1187:
1188: RAISE fnd_api.g_exc_error;
1189: END IF;
1190:
1191: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1192: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

Line 1191: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

1187:
1188: RAISE fnd_api.g_exc_error;
1189: END IF;
1190:
1191: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1192: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1193: fnd_msg_pub.ADD;
1194:
1195: IF (l_debug = 1) THEN

Line 1201: RAISE fnd_api.g_exc_unexpected_error;

1197: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
1198: , 1);
1199: END IF;
1200:
1201: RAISE fnd_api.g_exc_unexpected_error;
1202: END IF;
1203:
1204: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1205: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 1213: RAISE fnd_api.g_exc_error;

1209: IF (l_debug = 1) THEN
1210: print_debug('create_po_drct_dlvr_rti_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1211: END IF;
1212:
1213: RAISE fnd_api.g_exc_error;
1214: END IF;
1215:
1216: l_err_message := '@@@';
1217:

Line 1470: , p_init_msg_lst => FND_API.G_FALSE

1466: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
1467:
1468: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
1469: p_api_version => 1.0
1470: , p_init_msg_lst => FND_API.G_FALSE
1471: , x_return_status => l_return_status
1472: , x_msg_count => l_msg_count
1473: , x_msg_data => x_message
1474: , p_new_rti_info => l_new_rti_info);

Line 1479: RAISE FND_API.G_EXC_ERROR;

1475: IF ( NOT l_split_lot_serial_ok) THEN
1476: IF (l_debug = 1) THEN
1477: print_debug('create_po_drct_dlvr_rti_rec 10.1: Failure in split_lot_serial', 4);
1478: END IF;
1479: RAISE FND_API.G_EXC_ERROR;
1480: END IF;
1481:
1482: IF (l_debug = 1) THEN
1483: print_debug('create_po_drct_dlvr_rti_rec 10.2: Call split_lot_serial is OK', 4);

Line 1501: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1497: , x_msg_count => l_msg_count
1498: , x_msg_data => x_message
1499: );
1500:
1501: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1502: x_status := l_return_status;
1503: END IF;
1504:
1505: l_progress := '100';

Line 1513: WHEN fnd_api.g_exc_error THEN

1509: IF (l_debug = 1) THEN
1510: print_debug('Exiting create_po_drct_dlvr_rti_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1511: END IF;
1512: EXCEPTION
1513: WHEN fnd_api.g_exc_error THEN
1514: ROLLBACK TO crt_po_rti_sp;
1515: x_status := fnd_api.g_ret_sts_error;
1516:
1517: IF l_curs_rcpt_detail%ISOPEN THEN

Line 1515: x_status := fnd_api.g_ret_sts_error;

1511: END IF;
1512: EXCEPTION
1513: WHEN fnd_api.g_exc_error THEN
1514: ROLLBACK TO crt_po_rti_sp;
1515: x_status := fnd_api.g_ret_sts_error;
1516:
1517: IF l_curs_rcpt_detail%ISOPEN THEN
1518: CLOSE l_curs_rcpt_detail;
1519: END IF;

Line 1521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

1517: IF l_curs_rcpt_detail%ISOPEN THEN
1518: CLOSE l_curs_rcpt_detail;
1519: END IF;
1520:
1521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1522:
1523: IF (l_debug = 1) THEN
1524: print_debug('create_po_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1525: END IF;

Line 1524: print_debug('create_po_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

1520:
1521: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1522:
1523: IF (l_debug = 1) THEN
1524: print_debug('create_po_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1525: END IF;
1526: WHEN fnd_api.g_exc_unexpected_error THEN
1527: ROLLBACK TO crt_po_rti_sp;
1528: x_status := fnd_api.g_ret_sts_unexp_error;

Line 1526: WHEN fnd_api.g_exc_unexpected_error THEN

1522:
1523: IF (l_debug = 1) THEN
1524: print_debug('create_po_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1525: END IF;
1526: WHEN fnd_api.g_exc_unexpected_error THEN
1527: ROLLBACK TO crt_po_rti_sp;
1528: x_status := fnd_api.g_ret_sts_unexp_error;
1529:
1530: IF l_curs_rcpt_detail%ISOPEN THEN

Line 1528: x_status := fnd_api.g_ret_sts_unexp_error;

1524: print_debug('create_po_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1525: END IF;
1526: WHEN fnd_api.g_exc_unexpected_error THEN
1527: ROLLBACK TO crt_po_rti_sp;
1528: x_status := fnd_api.g_ret_sts_unexp_error;
1529:
1530: IF l_curs_rcpt_detail%ISOPEN THEN
1531: CLOSE l_curs_rcpt_detail;
1532: END IF;

Line 1534: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

1530: IF l_curs_rcpt_detail%ISOPEN THEN
1531: CLOSE l_curs_rcpt_detail;
1532: END IF;
1533:
1534: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1535:
1536: IF (l_debug = 1) THEN
1537: print_debug('create_po_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1538: END IF;

Line 1537: print_debug('create_po_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

1533:
1534: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1535:
1536: IF (l_debug = 1) THEN
1537: print_debug('create_po_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1538: END IF;
1539: WHEN OTHERS THEN
1540: ROLLBACK TO crt_po_rti_sp;
1541: x_status := fnd_api.g_ret_sts_unexp_error;

Line 1541: x_status := fnd_api.g_ret_sts_unexp_error;

1537: print_debug('create_po_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1538: END IF;
1539: WHEN OTHERS THEN
1540: ROLLBACK TO crt_po_rti_sp;
1541: x_status := fnd_api.g_ret_sts_unexp_error;
1542:
1543: IF l_curs_rcpt_detail%ISOPEN THEN
1544: CLOSE l_curs_rcpt_detail;
1545: END IF;

Line 1551: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

1547: IF SQLCODE IS NOT NULL THEN
1548: inv_mobile_helper_functions.sql_error('inv_rcv_dir_rcpt_apis.create_po_drct_dlvr_rti_rec', l_progress, SQLCODE);
1549: END IF;
1550:
1551: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1552:
1553: IF (l_debug = 1) THEN
1554: print_debug('create_po_drct_dlvr_rti_rec: OTHER exception : ' || SQLCODE || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
1555: , 4);

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

1603: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
1604: l_transaction_type VARCHAR2(20) := 'DELIVER';
1605: l_total_primary_qty NUMBER := 0;
1606: l_msg_count NUMBER;
1607: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1608: l_group_id NUMBER;
1609: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
1610: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
1611: l_err_message VARCHAR2(100);

Line 1808: x_status := fnd_api.g_ret_sts_success;

1804: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
1805: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
1806: l_msni_count NUMBER := 0;
1807: BEGIN
1808: x_status := fnd_api.g_ret_sts_success;
1809:
1810: IF (l_debug = 1) THEN
1811: print_debug('Enter create_int_shp_dr_del_rti_rec: 1 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1812: END IF;

Line 1944: IF x_status = fnd_api.g_ret_sts_error THEN

1940: print_debug('create_int_shp_dr_del_rti_rec: 4.3 - after matching l_msg_data = ' || x_message, 4);
1941: END IF;
1942:
1943: -- x_status is not successful if there is any execution error in matching.
1944: IF x_status = fnd_api.g_ret_sts_error THEN
1945: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1946: fnd_msg_pub.ADD;
1947:
1948: IF (l_debug = 1) THEN

Line 1952: RAISE fnd_api.g_exc_error;

1948: IF (l_debug = 1) THEN
1949: print_debug('create_int_shp_dr_del_rti_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1950: END IF;
1951:
1952: RAISE fnd_api.g_exc_error;
1953: END IF;
1954:
1955: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1956: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

Line 1955: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

1951:
1952: RAISE fnd_api.g_exc_error;
1953: END IF;
1954:
1955: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1956: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1957: fnd_msg_pub.ADD;
1958:
1959: IF (l_debug = 1) THEN

Line 1965: RAISE fnd_api.g_exc_unexpected_error;

1961: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
1962: , 1);
1963: END IF;
1964:
1965: RAISE fnd_api.g_exc_unexpected_error;
1966: END IF;
1967:
1968: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1969: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 1977: RAISE fnd_api.g_exc_error;

1973: IF (l_debug = 1) THEN
1974: print_debug('create_int_shp_dr_del_rti_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1975: END IF;
1976:
1977: RAISE fnd_api.g_exc_error;
1978: END IF;
1979:
1980: l_err_message := '@@@';
1981:

Line 2252: , p_init_msg_lst => FND_API.G_FALSE

2248: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2249:
2250: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2251: p_api_version => 1.0
2252: , p_init_msg_lst => FND_API.G_FALSE
2253: , x_return_status => l_return_status
2254: , x_msg_count => l_msg_count
2255: , x_msg_data => x_message
2256: , p_new_rti_info => l_new_rti_info);

Line 2261: RAISE FND_API.G_EXC_ERROR;

2257: IF ( NOT l_split_lot_serial_ok) THEN
2258: IF (l_debug = 1) THEN
2259: print_debug('create_int_shp_dr_del_rti_rec 129.1: Failure in split_lot_serial', 4);
2260: END IF;
2261: RAISE FND_API.G_EXC_ERROR;
2262: END IF;
2263:
2264: IF (l_debug = 1) THEN
2265: print_debug('create_int_shp_dr_del_rti_rec 128.2: Call split_lot_serial is OK', 4);

Line 2282: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2278: , x_msg_count => l_msg_count
2279: , x_msg_data => x_message
2280: );
2281:
2282: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2283: x_status := l_return_status;
2284: END IF;
2285:
2286: l_progress := '100';

Line 2294: WHEN fnd_api.g_exc_error THEN

2290: IF (l_debug = 1) THEN
2291: print_debug('About exit create_int_shp_dr_del_rti_rec: 130 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2292: END IF;
2293: EXCEPTION
2294: WHEN fnd_api.g_exc_error THEN
2295: ROLLBACK TO crt_intship_rti_sp;
2296: x_status := fnd_api.g_ret_sts_error;
2297:
2298: IF l_curs_rcpt_detail%ISOPEN THEN

Line 2296: x_status := fnd_api.g_ret_sts_error;

2292: END IF;
2293: EXCEPTION
2294: WHEN fnd_api.g_exc_error THEN
2295: ROLLBACK TO crt_intship_rti_sp;
2296: x_status := fnd_api.g_ret_sts_error;
2297:
2298: IF l_curs_rcpt_detail%ISOPEN THEN
2299: CLOSE l_curs_rcpt_detail;
2300: END IF;

Line 2302: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

2298: IF l_curs_rcpt_detail%ISOPEN THEN
2299: CLOSE l_curs_rcpt_detail;
2300: END IF;
2301:
2302: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2303:
2304: IF (l_debug = 1) THEN
2305: print_debug('create_int_shp_dr_del_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2306: END IF;

Line 2305: print_debug('create_int_shp_dr_del_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

2301:
2302: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2303:
2304: IF (l_debug = 1) THEN
2305: print_debug('create_int_shp_dr_del_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2306: END IF;
2307: WHEN fnd_api.g_exc_unexpected_error THEN
2308: ROLLBACK TO crt_intship_rti_sp;
2309: x_status := fnd_api.g_ret_sts_unexp_error;

Line 2307: WHEN fnd_api.g_exc_unexpected_error THEN

2303:
2304: IF (l_debug = 1) THEN
2305: print_debug('create_int_shp_dr_del_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2306: END IF;
2307: WHEN fnd_api.g_exc_unexpected_error THEN
2308: ROLLBACK TO crt_intship_rti_sp;
2309: x_status := fnd_api.g_ret_sts_unexp_error;
2310:
2311: IF l_curs_rcpt_detail%ISOPEN THEN

Line 2309: x_status := fnd_api.g_ret_sts_unexp_error;

2305: print_debug('create_int_shp_dr_del_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2306: END IF;
2307: WHEN fnd_api.g_exc_unexpected_error THEN
2308: ROLLBACK TO crt_intship_rti_sp;
2309: x_status := fnd_api.g_ret_sts_unexp_error;
2310:
2311: IF l_curs_rcpt_detail%ISOPEN THEN
2312: CLOSE l_curs_rcpt_detail;
2313: END IF;

Line 2315: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

2311: IF l_curs_rcpt_detail%ISOPEN THEN
2312: CLOSE l_curs_rcpt_detail;
2313: END IF;
2314:
2315: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2316:
2317: IF (l_debug = 1) THEN
2318: print_debug('create_int_shp_dr_del_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2319: END IF;

Line 2318: print_debug('create_int_shp_dr_del_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

2314:
2315: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2316:
2317: IF (l_debug = 1) THEN
2318: print_debug('create_int_shp_dr_del_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2319: END IF;
2320: WHEN OTHERS THEN
2321: ROLLBACK TO crt_intship_rti_sp;
2322: x_status := fnd_api.g_ret_sts_unexp_error;

Line 2322: x_status := fnd_api.g_ret_sts_unexp_error;

2318: print_debug('create_int_shp_dr_del_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2319: END IF;
2320: WHEN OTHERS THEN
2321: ROLLBACK TO crt_intship_rti_sp;
2322: x_status := fnd_api.g_ret_sts_unexp_error;
2323:
2324: IF l_curs_rcpt_detail%ISOPEN THEN
2325: CLOSE l_curs_rcpt_detail;
2326: END IF;

Line 2332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

2328: IF SQLCODE IS NOT NULL THEN
2329: inv_mobile_helper_functions.sql_error('inv_rcv_dir_rcpt_apis.create_int_shp_dr_del_rti_rec', l_progress, SQLCODE);
2330: END IF;
2331:
2332: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2333: END create_int_shp_dr_del_rti_rec;
2334:
2335: PROCEDURE create_rma_drct_dlvr_rti_rec(
2336: p_move_order_header_id IN OUT NOCOPY NUMBER

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

2378: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
2379: l_transaction_type VARCHAR2(20) := 'DELIVER';
2380: l_total_primary_qty NUMBER := 0;
2381: l_msg_count NUMBER;
2382: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2383: l_group_id NUMBER;
2384: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
2385: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
2386: l_err_message VARCHAR2(100);

Line 2547: x_status := fnd_api.g_ret_sts_success;

2543: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2544: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2545: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2546: BEGIN
2547: x_status := fnd_api.g_ret_sts_success;
2548:
2549: IF (l_debug = 1) THEN
2550: print_debug('Enter create_rma_drct_dlvr_rti_rec: 1 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2551: END IF;

Line 2652: IF x_status = fnd_api.g_ret_sts_error THEN

2648: print_debug('create_rma_drct_dlvr_rti_rec: 4.3 - after matching l_msg_data = ' || x_message, 4);
2649: END IF;
2650:
2651: -- x_status is not successful if there is any execution error in matching.
2652: IF x_status = fnd_api.g_ret_sts_error THEN
2653: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2654: fnd_msg_pub.ADD;
2655:
2656: IF (l_debug = 1) THEN

Line 2660: RAISE fnd_api.g_exc_error;

2656: IF (l_debug = 1) THEN
2657: print_debug('create_rma_drct_dlvr_rti_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2658: END IF;
2659:
2660: RAISE fnd_api.g_exc_error;
2661: END IF;
2662:
2663: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
2664: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

Line 2663: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

2659:
2660: RAISE fnd_api.g_exc_error;
2661: END IF;
2662:
2663: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
2664: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2665: fnd_msg_pub.ADD;
2666:
2667: IF (l_debug = 1) THEN

Line 2672: RAISE fnd_api.g_exc_unexpected_error;

2668: print_debug('create_rma_drct_dlvr_rti_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
2669: , 1);
2670: END IF;
2671:
2672: RAISE fnd_api.g_exc_unexpected_error;
2673: END IF;
2674:
2675: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
2676: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 2684: RAISE fnd_api.g_exc_error;

2680: IF (l_debug = 1) THEN
2681: print_debug('create_rma_drct_dlvr_rti_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2682: END IF;
2683:
2684: RAISE fnd_api.g_exc_error;
2685: END IF;
2686:
2687: l_err_message := '@@@';
2688:

Line 2865: , p_init_msg_lst => FND_API.G_FALSE

2861: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
2862:
2863: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2864: p_api_version => 1.0
2865: , p_init_msg_lst => FND_API.G_FALSE
2866: , x_return_status => l_return_status
2867: , x_msg_count => l_msg_count
2868: , x_msg_data => x_message
2869: , p_new_rti_info => l_new_rti_info);

Line 2874: RAISE FND_API.G_EXC_ERROR;

2870: IF ( NOT l_split_lot_serial_ok) THEN
2871: IF (l_debug = 1) THEN
2872: print_debug('create_rma_drct_dlvr_rti_rec 9.1: Failure in split_lot_serial', 4);
2873: END IF;
2874: RAISE FND_API.G_EXC_ERROR;
2875: END IF;
2876:
2877: IF (l_debug = 1) THEN
2878: print_debug('create_rma_drct_dlvr_rti_rec 9.2: Call split_lot_serial is OK', 4);

Line 2896: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2892: , x_msg_count => l_msg_count
2893: , x_msg_data => x_message
2894: );
2895:
2896: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2897: x_status := l_return_status;
2898: END IF;
2899:
2900: l_progress := '100';

Line 2908: WHEN fnd_api.g_exc_error THEN

2904: IF (l_debug = 1) THEN
2905: print_debug('About exit create_rma_drct_dlvr_rti_rec: 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2906: END IF;
2907: EXCEPTION
2908: WHEN fnd_api.g_exc_error THEN
2909: ROLLBACK TO crt_rma_rti_sp;
2910: x_status := fnd_api.g_ret_sts_error;
2911:
2912: IF l_curs_rcpt_detail%ISOPEN THEN

Line 2910: x_status := fnd_api.g_ret_sts_error;

2906: END IF;
2907: EXCEPTION
2908: WHEN fnd_api.g_exc_error THEN
2909: ROLLBACK TO crt_rma_rti_sp;
2910: x_status := fnd_api.g_ret_sts_error;
2911:
2912: IF l_curs_rcpt_detail%ISOPEN THEN
2913: CLOSE l_curs_rcpt_detail;
2914: END IF;

Line 2916: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

2912: IF l_curs_rcpt_detail%ISOPEN THEN
2913: CLOSE l_curs_rcpt_detail;
2914: END IF;
2915:
2916: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2917:
2918: IF (l_debug = 1) THEN
2919: print_debug('create_rma_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2920: END IF;

Line 2919: print_debug('create_rma_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

2915:
2916: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2917:
2918: IF (l_debug = 1) THEN
2919: print_debug('create_rma_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2920: END IF;
2921: WHEN fnd_api.g_exc_unexpected_error THEN
2922: ROLLBACK TO crt_rma_rti_sp;
2923: x_status := fnd_api.g_ret_sts_unexp_error;

Line 2921: WHEN fnd_api.g_exc_unexpected_error THEN

2917:
2918: IF (l_debug = 1) THEN
2919: print_debug('create_rma_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2920: END IF;
2921: WHEN fnd_api.g_exc_unexpected_error THEN
2922: ROLLBACK TO crt_rma_rti_sp;
2923: x_status := fnd_api.g_ret_sts_unexp_error;
2924:
2925: IF l_curs_rcpt_detail%ISOPEN THEN

Line 2923: x_status := fnd_api.g_ret_sts_unexp_error;

2919: print_debug('create_rma_drct_dlvr_rti_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2920: END IF;
2921: WHEN fnd_api.g_exc_unexpected_error THEN
2922: ROLLBACK TO crt_rma_rti_sp;
2923: x_status := fnd_api.g_ret_sts_unexp_error;
2924:
2925: IF l_curs_rcpt_detail%ISOPEN THEN
2926: CLOSE l_curs_rcpt_detail;
2927: END IF;

Line 2929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

2925: IF l_curs_rcpt_detail%ISOPEN THEN
2926: CLOSE l_curs_rcpt_detail;
2927: END IF;
2928:
2929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2930:
2931: IF (l_debug = 1) THEN
2932: print_debug('create_rma_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2933: END IF;

Line 2932: print_debug('create_rma_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

2928:
2929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2930:
2931: IF (l_debug = 1) THEN
2932: print_debug('create_rma_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2933: END IF;
2934: WHEN OTHERS THEN
2935: ROLLBACK TO crt_rma_rti_sp;
2936: x_status := fnd_api.g_ret_sts_unexp_error;

Line 2936: x_status := fnd_api.g_ret_sts_unexp_error;

2932: print_debug('create_rma_drct_dlvr_rti_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2933: END IF;
2934: WHEN OTHERS THEN
2935: ROLLBACK TO crt_rma_rti_sp;
2936: x_status := fnd_api.g_ret_sts_unexp_error;
2937:
2938: IF l_curs_rcpt_detail%ISOPEN THEN
2939: CLOSE l_curs_rcpt_detail;
2940: END IF;

Line 2946: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

2942: IF SQLCODE IS NOT NULL THEN
2943: inv_mobile_helper_functions.sql_error('inv_rcv_dir_rcpt_apis.create_rma_drct_dlvr_rti_rec', l_progress, SQLCODE);
2944: END IF;
2945:
2946: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2947: END create_rma_drct_dlvr_rti_rec;
2948:
2949: PROCEDURE create_asn_con_dd_intf_rec(
2950: p_move_order_header_id IN OUT NOCOPY NUMBER

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

2997: l_total_primary_qty NUMBER := 0;
2998: l_match_type VARCHAR2(20);
2999: l_msg_count NUMBER;
3000: l_msg_data VARCHAR2(400);
3001: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3002: l_group_id NUMBER;
3003: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
3004: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
3005: l_err_message VARCHAR2(100);

Line 3381: x_status := fnd_api.g_ret_sts_success;

3377: print_debug('p_task_id = ' || p_task_id, 4);
3378: END IF;
3379:
3380: SAVEPOINT crt_asn_con_rti_sp;
3381: x_status := fnd_api.g_ret_sts_success;
3382: l_progress := '10';
3383:
3384: -- query po_startup_value
3385: BEGIN

Line 3416: RAISE fnd_api.g_exc_error;

3412: EXCEPTION
3413: WHEN NO_DATA_FOUND THEN
3414: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3415: fnd_msg_pub.ADD;
3416: RAISE fnd_api.g_exc_error;
3417: END;
3418:
3419: -- default header level non-DB items in rcv_transaction block
3420: -- and default other values need to be insert into RTI

Line 3559: IF l_return_status = fnd_api.g_ret_sts_error THEN

3555: print_debug('create_asn_con_dd_intf_rec: 40.2 - after matching l_msg_count = ' || l_msg_count, 4);
3556: print_debug('create_asn_con_dd_intf_rec: 40.3 - after matching l_msg_data = ' || l_msg_data, 4);
3557: END IF;
3558:
3559: IF l_return_status = fnd_api.g_ret_sts_error THEN
3560: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3561: fnd_msg_pub.ADD;
3562:
3563: IF (l_debug = 1) THEN

Line 3567: RAISE fnd_api.g_exc_error;

3563: IF (l_debug = 1) THEN
3564: print_debug('create_asn_con_dd_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3565: END IF;
3566:
3567: RAISE fnd_api.g_exc_error;
3568: END IF;
3569:
3570: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3571: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');

Line 3570: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3566:
3567: RAISE fnd_api.g_exc_error;
3568: END IF;
3569:
3570: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3571: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3572: fnd_msg_pub.ADD;
3573:
3574: IF (l_debug = 1) THEN

Line 3579: RAISE fnd_api.g_exc_unexpected_error;

3575: print_debug('create_asn_con_dd_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
3576: , 1);
3577: END IF;
3578:
3579: RAISE fnd_api.g_exc_unexpected_error;
3580: END IF;
3581:
3582: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
3583: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

Line 3591: RAISE fnd_api.g_exc_error;

3587: IF (l_debug = 1) THEN
3588: print_debug('create_asn_con_dd_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3589: END IF;
3590:
3591: RAISE fnd_api.g_exc_error;
3592: END IF;
3593:
3594: l_err_message := '@@@';
3595:

Line 3827: , p_init_msg_lst => FND_API.G_FALSE

3823: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3824:
3825: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3826: p_api_version => 1.0
3827: , p_init_msg_lst => FND_API.G_FALSE
3828: , x_return_status => l_return_status
3829: , x_msg_count => l_msg_count
3830: , x_msg_data => x_message
3831: , p_new_rti_info => l_new_rti_info);

Line 3836: RAISE FND_API.G_EXC_ERROR;

3832: IF ( NOT l_split_lot_serial_ok) THEN
3833: IF (l_debug = 1) THEN
3834: print_debug('create_asn_con_dd_intf_rec 115.1: Failure in split_lot_serial', 4);
3835: END IF;
3836: RAISE FND_API.G_EXC_ERROR;
3837: END IF;
3838:
3839: IF (l_debug = 1) THEN
3840: print_debug('create_asn_con_dd_intf_rec 115.2: Call split_lot_serial is OK', 4);

Line 3875: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3871: , x_msg_count => l_msg_count
3872: , x_msg_data => x_message
3873: );
3874:
3875: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3876: x_status := l_return_status;
3877: END IF;
3878:
3879: l_progress := '130';

Line 3897: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3893: , l_return_status
3894: , l_msg_data
3895: );
3896:
3897: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3898: x_status := l_return_status;
3899: END IF;
3900:
3901: l_progress := '140';

Line 3909: WHEN fnd_api.g_exc_error THEN

3905: IF (l_debug = 1) THEN
3906: print_debug('About exit create_asn_con_dd_intf_rec: 140' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3907: END IF;
3908: EXCEPTION
3909: WHEN fnd_api.g_exc_error THEN
3910: ROLLBACK TO crt_asn_con_rti_sp;
3911: x_status := fnd_api.g_ret_sts_error;
3912:
3913: IF l_curs_rcpt_detail%ISOPEN THEN

Line 3911: x_status := fnd_api.g_ret_sts_error;

3907: END IF;
3908: EXCEPTION
3909: WHEN fnd_api.g_exc_error THEN
3910: ROLLBACK TO crt_asn_con_rti_sp;
3911: x_status := fnd_api.g_ret_sts_error;
3912:
3913: IF l_curs_rcpt_detail%ISOPEN THEN
3914: CLOSE l_curs_rcpt_detail;
3915: END IF;

Line 3917: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

3913: IF l_curs_rcpt_detail%ISOPEN THEN
3914: CLOSE l_curs_rcpt_detail;
3915: END IF;
3916:
3917: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3918:
3919: IF (l_debug = 1) THEN
3920: print_debug('create_asn_con_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3921: END IF;

Line 3920: print_debug('create_asn_con_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

3916:
3917: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3918:
3919: IF (l_debug = 1) THEN
3920: print_debug('create_asn_con_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3921: END IF;
3922: WHEN fnd_api.g_exc_unexpected_error THEN
3923: ROLLBACK TO crt_asn_con_rti_sp;
3924: x_status := fnd_api.g_ret_sts_unexp_error;

Line 3922: WHEN fnd_api.g_exc_unexpected_error THEN

3918:
3919: IF (l_debug = 1) THEN
3920: print_debug('create_asn_con_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3921: END IF;
3922: WHEN fnd_api.g_exc_unexpected_error THEN
3923: ROLLBACK TO crt_asn_con_rti_sp;
3924: x_status := fnd_api.g_ret_sts_unexp_error;
3925:
3926: IF l_curs_rcpt_detail%ISOPEN THEN

Line 3924: x_status := fnd_api.g_ret_sts_unexp_error;

3920: print_debug('create_asn_con_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3921: END IF;
3922: WHEN fnd_api.g_exc_unexpected_error THEN
3923: ROLLBACK TO crt_asn_con_rti_sp;
3924: x_status := fnd_api.g_ret_sts_unexp_error;
3925:
3926: IF l_curs_rcpt_detail%ISOPEN THEN
3927: CLOSE l_curs_rcpt_detail;
3928: END IF;

Line 3930: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

3926: IF l_curs_rcpt_detail%ISOPEN THEN
3927: CLOSE l_curs_rcpt_detail;
3928: END IF;
3929:
3930: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3931:
3932: IF (l_debug = 1) THEN
3933: print_debug('create_asn_con_dd_intf_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3934: END IF;

Line 3933: print_debug('create_asn_con_dd_intf_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

3929:
3930: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3931:
3932: IF (l_debug = 1) THEN
3933: print_debug('create_asn_con_dd_intf_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3934: END IF;
3935: WHEN OTHERS THEN
3936: ROLLBACK TO crt_asn_con_rti_sp;
3937: x_status := fnd_api.g_ret_sts_unexp_error;

Line 3937: x_status := fnd_api.g_ret_sts_unexp_error;

3933: print_debug('create_asn_con_dd_intf_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3934: END IF;
3935: WHEN OTHERS THEN
3936: ROLLBACK TO crt_asn_con_rti_sp;
3937: x_status := fnd_api.g_ret_sts_unexp_error;
3938:
3939: IF l_curs_rcpt_detail%ISOPEN THEN
3940: CLOSE l_curs_rcpt_detail;
3941: END IF;

Line 3947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

3943: IF SQLCODE IS NOT NULL THEN
3944: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_con_dd_intf_rec', l_progress, SQLCODE);
3945: END IF;
3946:
3947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3948:
3949: IF (l_debug = 1) THEN
3950: print_debug('create_asn_con_dd_intf_rec: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3951: END IF;

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

4087: l_po_header_id NUMBER;
4088: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
4089: l_lot_number VARCHAR2(80);
4090: l_lot_expiration_date DATE;
4091: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4092: l_msg_count NUMBER;
4093: l_msg_data VARCHAR2(400);
4094: l_progress VARCHAR2(10);
4095: l_transaction_temp_id NUMBER;

Line 4131: x_status := fnd_api.g_ret_sts_success;

4127: print_debug('p_lpn_id = ' || p_lpn_id, 4);
4128: print_debug('project id = ' || p_project_id);
4129: END IF;
4130:
4131: x_status := fnd_api.g_ret_sts_success;
4132: l_progress := '10';
4133: OPEN l_curs_asn_lpn_content;
4134: l_progress := '20';
4135:

Line 4177: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4173: , x_msg_count => l_msg_count
4174: , x_msg_data => l_msg_data
4175: );
4176:
4177: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4178: RAISE fnd_api.g_exc_error;
4179: END IF;
4180: END IF;
4181:

Line 4178: RAISE fnd_api.g_exc_error;

4174: , x_msg_data => l_msg_data
4175: );
4176:
4177: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4178: RAISE fnd_api.g_exc_error;
4179: END IF;
4180: END IF;
4181:
4182: l_progress := '35';

Line 4223: RAISE fnd_api.g_exc_error;

4219: , 4
4220: );
4221: END IF;
4222:
4223: RAISE fnd_api.g_exc_error;
4224: END IF;
4225:
4226: IF (p_source_type = 'INTERNAL' AND l_lot_control_code = 2) THEN
4227: BEGIN

Line 4258: IF l_return_status = fnd_api.g_ret_sts_error THEN

4254: , x_return_status => l_return_status
4255: , x_msg_data => l_msg_data
4256: );
4257:
4258: IF l_return_status = fnd_api.g_ret_sts_error THEN
4259: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
4260: fnd_msg_pub.ADD;
4261:
4262: IF (l_debug = 1) THEN

Line 4264: 'create_asn_exp_dd_intf_rec 25.1: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_ERROR;'

4260: fnd_msg_pub.ADD;
4261:
4262: IF (l_debug = 1) THEN
4263: print_debug(
4264: 'create_asn_exp_dd_intf_rec 25.1: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_ERROR;'
4265: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4266: END IF;
4267:
4268: RAISE fnd_api.g_exc_error;

Line 4268: RAISE fnd_api.g_exc_error;

4264: 'create_asn_exp_dd_intf_rec 25.1: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_ERROR;'
4265: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4266: END IF;
4267:
4268: RAISE fnd_api.g_exc_error;
4269: END IF;
4270:
4271: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4272: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');

Line 4271: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4267:
4268: RAISE fnd_api.g_exc_error;
4269: END IF;
4270:
4271: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4272: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
4273: fnd_msg_pub.ADD;
4274:
4275: IF (l_debug = 1) THEN

Line 4277: 'create_asn_exp_dd_intf_rec 25.2: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

4273: fnd_msg_pub.ADD;
4274:
4275: IF (l_debug = 1) THEN
4276: print_debug(
4277: 'create_asn_exp_dd_intf_rec 25.2: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
4278: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4279: END IF;
4280:
4281: RAISE fnd_api.g_exc_unexpected_error;

Line 4281: RAISE fnd_api.g_exc_unexpected_error;

4277: 'create_asn_exp_dd_intf_rec 25.2: inv_rcv_common_apis.insert_lot RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
4278: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4279: END IF;
4280:
4281: RAISE fnd_api.g_exc_unexpected_error;
4282: END IF; --END IF ret_status = unexp_error
4283: END IF; --END IF item is lot controlled
4284:
4285: l_progress := '41';

Line 4387: RAISE fnd_api.g_exc_error;

4383: fnd_msg_pub.ADD;
4384: IF (l_debug = 1) THEN
4385: print_debug('create_asn_exp_rcpt_intf_rec: 20.2 - txn/primary uom conversion failed', 4);
4386: END IF;
4387: RAISE fnd_api.g_exc_error;
4388: END IF; --END IF check for failure
4389:
4390: ELSE
4391: l_lot_prm_quantity := l_quantity;

Line 4404: , p_init_msg_lst => FND_API.G_FALSE

4400: --Create MTLI record for the lot and the lot quantity for this content
4401: --Set the flag for the API to populate the lot attributes
4402: inv_rcv_integration_apis.insert_mtli(
4403: p_api_version => 1.0
4404: , p_init_msg_lst => FND_API.G_FALSE
4405: , x_return_status => l_return_status
4406: , x_msg_count => l_msg_count
4407: , x_msg_data => l_msg_data
4408: , p_transaction_interface_id => l_transaction_interface_id

Line 4423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4419: , p_att_exist => 'Y'
4420: , p_update_mln => 'N'
4421: );
4422:
4423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4424: IF (l_debug = 1) THEN
4425: print_debug('create_asn_exp_dd_intf_rec 28.1: Error in MTLI creation', 4);
4426: END IF;
4427: RAISE FND_API.G_EXC_ERROR;

Line 4427: RAISE FND_API.G_EXC_ERROR;

4423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4424: IF (l_debug = 1) THEN
4425: print_debug('create_asn_exp_dd_intf_rec 28.1: Error in MTLI creation', 4);
4426: END IF;
4427: RAISE FND_API.G_EXC_ERROR;
4428: END IF;
4429:
4430: IF (l_debug = 1) THEN
4431: print_debug('create_asn_exp_dd_intf_rec 28.2: txn i/f id: ' || l_transaction_interface_id

Line 4455: , p_init_msg_lst => FND_API.G_FALSE

4451: --For each serial number in the lot create one MSNI record. The
4452: --serial attributes would be populated by the API
4453: inv_rcv_integration_apis.insert_msni(
4454: p_api_version => 1.0
4455: , p_init_msg_lst => FND_API.G_FALSE
4456: , x_return_status => l_return_status
4457: , x_msg_count => l_msg_count
4458: , x_msg_data => l_msg_data
4459: , p_transaction_interface_id => l_serial_transaction_temp_id

Line 4471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4467: , p_att_exist => 'Y'
4468: , p_update_msn => 'N'
4469: );
4470:
4471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4472: IF (l_debug = 1) THEN
4473: print_debug('create_asn_exp_dd_intf_rec 28.3: Error in MSNI creation', 4);
4474: END IF;
4475: RAISE FND_API.G_EXC_ERROR;

Line 4475: RAISE FND_API.G_EXC_ERROR;

4471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4472: IF (l_debug = 1) THEN
4473: print_debug('create_asn_exp_dd_intf_rec 28.3: Error in MSNI creation', 4);
4474: END IF;
4475: RAISE FND_API.G_EXC_ERROR;
4476: END IF;
4477: END LOOP; --END LOOP through serials for the lot
4478:
4479: --Close the serial cursor

Line 4512: , p_init_msg_lst => FND_API.G_FALSE

4508: print_debug('create_asn_exp_dd_intf_rec 28.3.1: Before MSNI creation', 4);
4509: END IF;
4510: inv_rcv_integration_apis.insert_msni(
4511: p_api_version => 1.0
4512: , p_init_msg_lst => FND_API.G_FALSE
4513: , x_return_status => l_return_status
4514: , x_msg_count => l_msg_count
4515: , x_msg_data => l_msg_data
4516: , p_transaction_interface_id => l_transaction_interface_id

Line 4528: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4524: , p_att_exist => 'Y'
4525: , p_update_msn => 'N'
4526: );
4527:
4528: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4529: IF (l_debug = 1) THEN
4530: print_debug('create_asn_exp_dd_intf_rec 28.4: Error in MSNI creation', 4);
4531: END IF;
4532: RAISE FND_API.G_EXC_ERROR;

Line 4532: RAISE FND_API.G_EXC_ERROR;

4528: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4529: IF (l_debug = 1) THEN
4530: print_debug('create_asn_exp_dd_intf_rec 28.4: Error in MSNI creation', 4);
4531: END IF;
4532: RAISE FND_API.G_EXC_ERROR;
4533: END IF;
4534: IF (l_debug = 1) THEN
4535: print_debug('create_asn_exp_dd_intf_rec 28.5: txn i/f id: ' || l_transaction_interface_id || ' prod txn id: ' || l_product_transaction_id, 4);
4536: END IF;

Line 4606: IF l_return_status = fnd_api.g_ret_sts_error THEN

4602: , p_attribute15 => p_attribute15
4603: , p_express_transaction => 'Y'--Bug 5550783
4604: );
4605:
4606: IF l_return_status = fnd_api.g_ret_sts_error THEN
4607: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
4608: fnd_msg_pub.ADD;
4609:
4610: IF (l_debug = 1) THEN

Line 4612: 'create_asn_exp_dd_intf_rec 40.1:create_asn_con_dd_intf_rec RAISE FND_API.G_EXC_ERROR;'

4608: fnd_msg_pub.ADD;
4609:
4610: IF (l_debug = 1) THEN
4611: print_debug(
4612: 'create_asn_exp_dd_intf_rec 40.1:create_asn_con_dd_intf_rec RAISE FND_API.G_EXC_ERROR;'
4613: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
4614: , 4
4615: );
4616: END IF;

Line 4618: RAISE fnd_api.g_exc_error;

4614: , 4
4615: );
4616: END IF;
4617:
4618: RAISE fnd_api.g_exc_error;
4619: END IF;
4620:
4621: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4622: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');

Line 4621: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4617:
4618: RAISE fnd_api.g_exc_error;
4619: END IF;
4620:
4621: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4622: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
4623: fnd_msg_pub.ADD;
4624:
4625: IF (l_debug = 1) THEN

Line 4627: 'create_asn_exp_dd_intf_rec 40.2: create_asn_con_dd_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

4623: fnd_msg_pub.ADD;
4624:
4625: IF (l_debug = 1) THEN
4626: print_debug(
4627: 'create_asn_exp_dd_intf_rec 40.2: create_asn_con_dd_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
4628: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
4629: , 4
4630: );
4631: END IF;

Line 4633: RAISE fnd_api.g_exc_unexpected_error;

4629: , 4
4630: );
4631: END IF;
4632:
4633: RAISE fnd_api.g_exc_unexpected_error;
4634: END IF;
4635:
4636: IF (l_debug = 1) THEN
4637: print_debug('create_asn_exp_dd_intf_rec: 50 after create_asn_con_dd_intf_rec' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 4683: IF l_return_status = fnd_api.g_ret_sts_error THEN

4679: ,p_lpn_group_id => inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4680: ,p_parent_lpn_id => NULL
4681: );
4682:
4683: IF l_return_status = fnd_api.g_ret_sts_error THEN
4684: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
4685: fnd_msg_pub.ADD;
4686:
4687: IF (l_debug = 1) THEN

Line 4688: print_debug('create_asn_exp_dd_intf_rec 50.2:create_asn_con_dd_intf_rec - RAISE FND_API.G_EXC_ERROR after insert_wlpni;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4684: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
4685: fnd_msg_pub.ADD;
4686:
4687: IF (l_debug = 1) THEN
4688: print_debug('create_asn_exp_dd_intf_rec 50.2:create_asn_con_dd_intf_rec - RAISE FND_API.G_EXC_ERROR after insert_wlpni;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4689: END IF;
4690:
4691: RAISE fnd_api.g_exc_error;
4692: END IF;

Line 4691: RAISE fnd_api.g_exc_error;

4687: IF (l_debug = 1) THEN
4688: print_debug('create_asn_exp_dd_intf_rec 50.2:create_asn_con_dd_intf_rec - RAISE FND_API.G_EXC_ERROR after insert_wlpni;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4689: END IF;
4690:
4691: RAISE fnd_api.g_exc_error;
4692: END IF;
4693:
4694: IF (l_debug = 1) THEN
4695: print_debug(

Line 4750: WHEN fnd_api.g_exc_error THEN

4746: IF (l_debug = 1) THEN
4747: print_debug('Exit create_asn_exp_dd_intf_rec: 90 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4748: END IF;
4749: EXCEPTION
4750: WHEN fnd_api.g_exc_error THEN
4751: x_status := fnd_api.g_ret_sts_error;
4752:
4753: IF l_curs_asn_lpn_content%ISOPEN THEN
4754: CLOSE l_curs_asn_lpn_content;

Line 4751: x_status := fnd_api.g_ret_sts_error;

4747: print_debug('Exit create_asn_exp_dd_intf_rec: 90 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4748: END IF;
4749: EXCEPTION
4750: WHEN fnd_api.g_exc_error THEN
4751: x_status := fnd_api.g_ret_sts_error;
4752:
4753: IF l_curs_asn_lpn_content%ISOPEN THEN
4754: CLOSE l_curs_asn_lpn_content;
4755: END IF;

Line 4757: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4753: IF l_curs_asn_lpn_content%ISOPEN THEN
4754: CLOSE l_curs_asn_lpn_content;
4755: END IF;
4756:
4757: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4758:
4759: IF (l_debug = 1) THEN
4760: print_debug('create_asn_exp_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4761: END IF;

Line 4760: print_debug('create_asn_exp_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

4756:
4757: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4758:
4759: IF (l_debug = 1) THEN
4760: print_debug('create_asn_exp_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4761: END IF;
4762: WHEN fnd_api.g_exc_unexpected_error THEN
4763: x_status := fnd_api.g_ret_sts_unexp_error;
4764:

Line 4762: WHEN fnd_api.g_exc_unexpected_error THEN

4758:
4759: IF (l_debug = 1) THEN
4760: print_debug('create_asn_exp_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4761: END IF;
4762: WHEN fnd_api.g_exc_unexpected_error THEN
4763: x_status := fnd_api.g_ret_sts_unexp_error;
4764:
4765: IF l_curs_asn_lpn_content%ISOPEN THEN
4766: CLOSE l_curs_asn_lpn_content;

Line 4763: x_status := fnd_api.g_ret_sts_unexp_error;

4759: IF (l_debug = 1) THEN
4760: print_debug('create_asn_exp_dd_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4761: END IF;
4762: WHEN fnd_api.g_exc_unexpected_error THEN
4763: x_status := fnd_api.g_ret_sts_unexp_error;
4764:
4765: IF l_curs_asn_lpn_content%ISOPEN THEN
4766: CLOSE l_curs_asn_lpn_content;
4767: END IF;

Line 4769: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4765: IF l_curs_asn_lpn_content%ISOPEN THEN
4766: CLOSE l_curs_asn_lpn_content;
4767: END IF;
4768:
4769: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4770:
4771: IF (l_debug = 1) THEN
4772: print_debug('create_asn_exp_dd_intf_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4773: END IF;

Line 4772: print_debug('create_asn_exp_dd_intf_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

4768:
4769: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4770:
4771: IF (l_debug = 1) THEN
4772: print_debug('create_asn_exp_dd_intf_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4773: END IF;
4774: WHEN OTHERS THEN
4775: x_status := fnd_api.g_ret_sts_unexp_error;
4776:

Line 4775: x_status := fnd_api.g_ret_sts_unexp_error;

4771: IF (l_debug = 1) THEN
4772: print_debug('create_asn_exp_dd_intf_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4773: END IF;
4774: WHEN OTHERS THEN
4775: x_status := fnd_api.g_ret_sts_unexp_error;
4776:
4777: IF l_curs_asn_lpn_content%ISOPEN THEN
4778: CLOSE l_curs_asn_lpn_content;
4779: END IF;

Line 4785: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

4781: IF SQLCODE IS NOT NULL THEN
4782: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_exp_dd_intf_rec', l_progress, SQLCODE);
4783: END IF;
4784:
4785: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4786:
4787: IF (l_debug = 1) THEN
4788: print_debug('create_asn_exp_dd_intf_rec: Other exception ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4789: END IF;

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

4821: , p_attribute13 IN VARCHAR2 DEFAULT NULL
4822: , p_attribute14 IN VARCHAR2 DEFAULT NULL
4823: , p_attribute15 IN VARCHAR2 DEFAULT NULL
4824: ) IS
4825: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4826: l_msg_count NUMBER;
4827: l_msg_data VARCHAR2(400);
4828: l_label_status VARCHAR2(500);
4829: l_progress VARCHAR2(10);

Line 4846: x_status := fnd_api.g_ret_sts_success;

4842: -- GROUP BY rti.lpn_id;
4843:
4844: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4845: BEGIN
4846: x_status := fnd_api.g_ret_sts_success;
4847: l_progress := '10';
4848:
4849: IF (l_debug = 1) THEN
4850: print_debug('create_osp_direct_rti_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4879: IF x_status <> fnd_api.g_ret_sts_success THEN

4875: , x_return_status => x_status
4876: , x_error_code => x_message
4877: );
4878:
4879: IF x_status <> fnd_api.g_ret_sts_success THEN
4880: RETURN;
4881: END IF;
4882:
4883: IF p_po_header_id IS NULL

Line 4889: x_status := fnd_api.g_ret_sts_error;

4885: IF (l_debug = 1) THEN
4886: print_debug('create_osp_direct_rti_rec: 2 item id and po number cannot be NULL', 4);
4887: END IF;
4888:
4889: x_status := fnd_api.g_ret_sts_error;
4890: RETURN;
4891: END IF;
4892:
4893: l_progress := '30';

Line 4929: IF l_return_status = fnd_api.g_ret_sts_error THEN

4925: , p_attribute14 => p_attribute14
4926: , p_attribute15 => p_attribute15
4927: );
4928:
4929: IF l_return_status = fnd_api.g_ret_sts_error THEN
4930: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4931: fnd_msg_pub.ADD;
4932:
4933: IF (l_debug = 1) THEN

Line 4935: 'create_osp_direct_rti_rec 20.1: create_osp_drct_dlvr_rti_rec RAISE FND_API.G_EXC_ERROR;'

4931: fnd_msg_pub.ADD;
4932:
4933: IF (l_debug = 1) THEN
4934: print_debug(
4935: 'create_osp_direct_rti_rec 20.1: create_osp_drct_dlvr_rti_rec RAISE FND_API.G_EXC_ERROR;'
4936: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4937: END IF;
4938:
4939: RAISE fnd_api.g_exc_error;

Line 4939: RAISE fnd_api.g_exc_error;

4935: 'create_osp_direct_rti_rec 20.1: create_osp_drct_dlvr_rti_rec RAISE FND_API.G_EXC_ERROR;'
4936: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4937: END IF;
4938:
4939: RAISE fnd_api.g_exc_error;
4940: END IF;
4941:
4942: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4943: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 4942: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4938:
4939: RAISE fnd_api.g_exc_error;
4940: END IF;
4941:
4942: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4943: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4944: fnd_msg_pub.ADD;
4945:
4946: IF (l_debug = 1) THEN

Line 4948: 'create_osp_direct_rti_rec 20.2: create_osp_drct_dlvr_rti_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

4944: fnd_msg_pub.ADD;
4945:
4946: IF (l_debug = 1) THEN
4947: print_debug(
4948: 'create_osp_direct_rti_rec 20.2: create_osp_drct_dlvr_rti_rec FND_API.G_EXC_UNEXPECTED_ERROR;'
4949: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4950: END IF;
4951:
4952: RAISE fnd_api.g_exc_unexpected_error;

Line 4952: RAISE fnd_api.g_exc_unexpected_error;

4948: 'create_osp_direct_rti_rec 20.2: create_osp_drct_dlvr_rti_rec FND_API.G_EXC_UNEXPECTED_ERROR;'
4949: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4950: END IF;
4951:
4952: RAISE fnd_api.g_exc_unexpected_error;
4953: END IF;
4954:
4955: l_progress := '40';
4956:

Line 4964: IF l_return_status <> fnd_api.g_ret_sts_error THEN

4960:
4961: x_status := l_return_status; -- l_return_status can be 'W', we want to carry that over
4962: -- calling label printing API
4963:
4964: IF l_return_status <> fnd_api.g_ret_sts_error THEN
4965: l_progress := '40';
4966:
4967: IF (l_debug = 1) THEN
4968: print_debug(

Line 5005: IF l_return_status <> fnd_api.g_ret_sts_success THEN

5001: , p_business_flow_code => 1
5002: , p_transaction_id => l_txn_id_tbl
5003: );
5004:
5005: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5006: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
5007: fnd_msg_pub.ADD;
5008: x_status := 'W';
5009:

Line 5032: WHEN fnd_api.g_exc_error THEN

5028: print_debug('create_osp_direct_rti_rec: 8.1 - x_status = ' || x_status, 4);
5029: print_debug('create_osp_direct_rti_rec: 8.2 - x_message= ' || x_message, 4);
5030: END IF;
5031: EXCEPTION
5032: WHEN fnd_api.g_exc_error THEN
5033: x_status := fnd_api.g_ret_sts_error;
5034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5035: WHEN fnd_api.g_exc_unexpected_error THEN
5036: x_status := fnd_api.g_ret_sts_unexp_error;

Line 5033: x_status := fnd_api.g_ret_sts_error;

5029: print_debug('create_osp_direct_rti_rec: 8.2 - x_message= ' || x_message, 4);
5030: END IF;
5031: EXCEPTION
5032: WHEN fnd_api.g_exc_error THEN
5033: x_status := fnd_api.g_ret_sts_error;
5034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5035: WHEN fnd_api.g_exc_unexpected_error THEN
5036: x_status := fnd_api.g_ret_sts_unexp_error;
5037: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

Line 5034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

5030: END IF;
5031: EXCEPTION
5032: WHEN fnd_api.g_exc_error THEN
5033: x_status := fnd_api.g_ret_sts_error;
5034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5035: WHEN fnd_api.g_exc_unexpected_error THEN
5036: x_status := fnd_api.g_ret_sts_unexp_error;
5037: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5038: WHEN OTHERS THEN

Line 5035: WHEN fnd_api.g_exc_unexpected_error THEN

5031: EXCEPTION
5032: WHEN fnd_api.g_exc_error THEN
5033: x_status := fnd_api.g_ret_sts_error;
5034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5035: WHEN fnd_api.g_exc_unexpected_error THEN
5036: x_status := fnd_api.g_ret_sts_unexp_error;
5037: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5038: WHEN OTHERS THEN
5039: x_status := fnd_api.g_ret_sts_unexp_error;

Line 5036: x_status := fnd_api.g_ret_sts_unexp_error;

5032: WHEN fnd_api.g_exc_error THEN
5033: x_status := fnd_api.g_ret_sts_error;
5034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5035: WHEN fnd_api.g_exc_unexpected_error THEN
5036: x_status := fnd_api.g_ret_sts_unexp_error;
5037: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5038: WHEN OTHERS THEN
5039: x_status := fnd_api.g_ret_sts_unexp_error;
5040:

Line 5037: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

5033: x_status := fnd_api.g_ret_sts_error;
5034: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5035: WHEN fnd_api.g_exc_unexpected_error THEN
5036: x_status := fnd_api.g_ret_sts_unexp_error;
5037: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5038: WHEN OTHERS THEN
5039: x_status := fnd_api.g_ret_sts_unexp_error;
5040:
5041: IF SQLCODE IS NOT NULL THEN

Line 5039: x_status := fnd_api.g_ret_sts_unexp_error;

5035: WHEN fnd_api.g_exc_unexpected_error THEN
5036: x_status := fnd_api.g_ret_sts_unexp_error;
5037: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5038: WHEN OTHERS THEN
5039: x_status := fnd_api.g_ret_sts_unexp_error;
5040:
5041: IF SQLCODE IS NOT NULL THEN
5042: inv_mobile_helper_functions.sql_error('inv_rcv_dir_rcpt_apis.create_osp_direct_rti_rec', l_progress, SQLCODE);
5043: END IF;

Line 5045: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

5041: IF SQLCODE IS NOT NULL THEN
5042: inv_mobile_helper_functions.sql_error('inv_rcv_dir_rcpt_apis.create_osp_direct_rti_rec', l_progress, SQLCODE);
5043: END IF;
5044:
5045: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5046: END create_osp_direct_rti_rec;
5047:
5048: PROCEDURE create_direct_rti_rec(
5049: p_move_order_header_id IN OUT NOCOPY NUMBER

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

5094: , p_attribute13 IN VARCHAR2 DEFAULT NULL
5095: , p_attribute14 IN VARCHAR2 DEFAULT NULL
5096: , p_attribute15 IN VARCHAR2 DEFAULT NULL
5097: ) IS
5098: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5099: l_msg_count NUMBER;
5100: l_msg_data VARCHAR2(400);
5101: l_label_status VARCHAR2(500);
5102: l_progress VARCHAR2(10);

Line 5126: x_status := fnd_api.g_ret_sts_success;

5122:
5123: -- GROUP BY rti.lpn_id;
5124: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5125: BEGIN
5126: x_status := fnd_api.g_ret_sts_success;
5127: l_progress := '10';
5128:
5129: IF (l_debug = 1) THEN
5130: print_debug('create_direct_rti_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 5166: IF x_status <> fnd_api.g_ret_sts_success THEN

5162: , x_return_status => x_status
5163: , x_error_code => x_message
5164: );
5165:
5166: IF x_status <> fnd_api.g_ret_sts_success THEN
5167: RETURN;
5168: END IF;
5169:
5170: IF p_shipment_header_id IS NULL THEN -- Added this check to fix bug no. 2159179

Line 5177: x_status := fnd_api.g_ret_sts_error;

5173: IF (l_debug = 1) THEN
5174: print_debug('create_direct_rti_rec: 2 item id and po number cannot be NULL', 4);
5175: END IF;
5176:
5177: x_status := fnd_api.g_ret_sts_error;
5178: RETURN;
5179: END IF;
5180: END IF;
5181:

Line 5203: x_status := fnd_api.g_ret_sts_error;

5199: IF (l_debug = 1) THEN
5200: print_debug('create_direct_rti_rec: 2 item id and po number cannot be NULL', 4);
5201: END IF;
5202:
5203: x_status := fnd_api.g_ret_sts_error;
5204: RETURN;
5205: END IF;
5206:
5207: l_subinventory := p_subinventory;

Line 5265: IF l_return_status = fnd_api.g_ret_sts_error THEN

5261: , p_attribute14 => p_attribute14
5262: , p_attribute15 => p_attribute15
5263: );
5264:
5265: IF l_return_status = fnd_api.g_ret_sts_error THEN
5266: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
5267: fnd_msg_pub.ADD;
5268:
5269: IF (l_debug = 1) THEN

Line 5271: 'create_direct_rti_rec 20.1: create_po_drct_dlvr_rti_rec RAISE FND_API.G_EXC_ERROR;'

5267: fnd_msg_pub.ADD;
5268:
5269: IF (l_debug = 1) THEN
5270: print_debug(
5271: 'create_direct_rti_rec 20.1: create_po_drct_dlvr_rti_rec RAISE FND_API.G_EXC_ERROR;'
5272: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5273: END IF;
5274:
5275: RAISE fnd_api.g_exc_error;

Line 5275: RAISE fnd_api.g_exc_error;

5271: 'create_direct_rti_rec 20.1: create_po_drct_dlvr_rti_rec RAISE FND_API.G_EXC_ERROR;'
5272: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5273: END IF;
5274:
5275: RAISE fnd_api.g_exc_error;
5276: END IF;
5277:
5278: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5279: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 5278: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5274:
5275: RAISE fnd_api.g_exc_error;
5276: END IF;
5277:
5278: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5279: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
5280: fnd_msg_pub.ADD;
5281:
5282: IF (l_debug = 1) THEN

Line 5284: 'create_direct_rti_rec 20.2: create_po_drct_dlvr_rti_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

5280: fnd_msg_pub.ADD;
5281:
5282: IF (l_debug = 1) THEN
5283: print_debug(
5284: 'create_direct_rti_rec 20.2: create_po_drct_dlvr_rti_rec FND_API.G_EXC_UNEXPECTED_ERROR;'
5285: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5286: END IF;
5287:
5288: RAISE fnd_api.g_exc_unexpected_error;

Line 5288: RAISE fnd_api.g_exc_unexpected_error;

5284: 'create_direct_rti_rec 20.2: create_po_drct_dlvr_rti_rec FND_API.G_EXC_UNEXPECTED_ERROR;'
5285: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5286: END IF;
5287:
5288: RAISE fnd_api.g_exc_unexpected_error;
5289: END IF;
5290: ELSIF p_shipment_header_id IS NOT NULL THEN
5291: l_progress := '50';
5292:

Line 5354: IF l_return_status = fnd_api.g_ret_sts_error THEN

5350: , p_attribute14 => p_attribute14
5351: , p_attribute15 => p_attribute15
5352: );
5353:
5354: IF l_return_status = fnd_api.g_ret_sts_error THEN
5355: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
5356: fnd_msg_pub.ADD;
5357:
5358: IF (l_debug = 1) THEN

Line 5360: 'create_direct_rti_rec 23.1: create_asn_exp_dd_intf_rec RAISE FND_API.G_EXC_ERROR;'

5356: fnd_msg_pub.ADD;
5357:
5358: IF (l_debug = 1) THEN
5359: print_debug(
5360: 'create_direct_rti_rec 23.1: create_asn_exp_dd_intf_rec RAISE FND_API.G_EXC_ERROR;'
5361: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5362: END IF;
5363:
5364: RAISE fnd_api.g_exc_error;

Line 5364: RAISE fnd_api.g_exc_error;

5360: 'create_direct_rti_rec 23.1: create_asn_exp_dd_intf_rec RAISE FND_API.G_EXC_ERROR;'
5361: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5362: END IF;
5363:
5364: RAISE fnd_api.g_exc_error;
5365: END IF;
5366:
5367: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5368: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD

Line 5367: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5363:
5364: RAISE fnd_api.g_exc_error;
5365: END IF;
5366:
5367: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5368: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
5369: fnd_msg_pub.ADD;
5370:
5371: IF (l_debug = 1) THEN

Line 5373: 'create_direct_rti_rec 23.2: create_asn_exp_dd_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

5369: fnd_msg_pub.ADD;
5370:
5371: IF (l_debug = 1) THEN
5372: print_debug(
5373: 'create_direct_rti_rec 23.2: create_asn_exp_dd_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'
5374: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5375: END IF;
5376:
5377: RAISE fnd_api.g_exc_unexpected_error;

Line 5377: RAISE fnd_api.g_exc_unexpected_error;

5373: 'create_direct_rti_rec 23.2: create_asn_exp_dd_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'
5374: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5375: END IF;
5376:
5377: RAISE fnd_api.g_exc_unexpected_error;
5378: END IF;
5379: ELSE
5380: l_progress := '50';
5381:

Line 5424: IF l_return_status = fnd_api.g_ret_sts_error THEN

5420: , p_attribute14 => p_attribute14
5421: , p_attribute15 => p_attribute15
5422: );
5423:
5424: IF l_return_status = fnd_api.g_ret_sts_error THEN
5425: --BUG 3433072: The message below is not defined. Plus, it
5426: --create_asn_exp_dd_intf_rec fails, it will fails with a error
5427: --message.
5428: --fnd_message.set_name('INV', 'INV_RCV_CRT_INTSHIPEXP_RTI_FAIL'); -- MSGTBD

Line 5433: 'create_direct_rti_rec 24.1: create_asn_exp_dd_intf_rec for IntShip RAISE FND_API.G_EXC_ERROR;'

5429: --fnd_msg_pub.ADD;
5430:
5431: IF (l_debug = 1) THEN
5432: print_debug(
5433: 'create_direct_rti_rec 24.1: create_asn_exp_dd_intf_rec for IntShip RAISE FND_API.G_EXC_ERROR;'
5434: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5435: END IF;
5436:
5437: RAISE fnd_api.g_exc_error;

Line 5437: RAISE fnd_api.g_exc_error;

5433: 'create_direct_rti_rec 24.1: create_asn_exp_dd_intf_rec for IntShip RAISE FND_API.G_EXC_ERROR;'
5434: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5435: END IF;
5436:
5437: RAISE fnd_api.g_exc_error;
5438: END IF;
5439:
5440: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5441: --BUG 3433072: The message below is not defined

Line 5440: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5436:
5437: RAISE fnd_api.g_exc_error;
5438: END IF;
5439:
5440: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5441: --BUG 3433072: The message below is not defined
5442: --fnd_message.set_name('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL');
5443: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL');
5444: fnd_msg_pub.ADD;

Line 5448: 'create_direct_rti_rec 24.2: create_asn_exp_dd_intf_rec for IntShip RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

5444: fnd_msg_pub.ADD;
5445:
5446: IF (l_debug = 1) THEN
5447: print_debug(
5448: 'create_direct_rti_rec 24.2: create_asn_exp_dd_intf_rec for IntShip RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
5449: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5450: END IF;
5451:
5452: RAISE fnd_api.g_exc_unexpected_error;

Line 5452: RAISE fnd_api.g_exc_unexpected_error;

5448: 'create_direct_rti_rec 24.2: create_asn_exp_dd_intf_rec for IntShip RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
5449: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5450: END IF;
5451:
5452: RAISE fnd_api.g_exc_unexpected_error;
5453: END IF;
5454: END IF;
5455: ELSIF p_source_type IN ('ASNCONFM', 'LCMCONFM') THEN -- For LCM Project
5456:

Line 5518: IF l_return_status = fnd_api.g_ret_sts_error THEN

5514: , p_attribute15 => p_attribute15
5515: , p_express_transaction => NULL--Bug 5550783
5516: );
5517:
5518: IF l_return_status = fnd_api.g_ret_sts_error THEN
5519: fnd_message.set_name('INV', 'INV_RCV_CRT_ASNCON_RTI_FAIL'); -- MSGTBD
5520: fnd_msg_pub.ADD;
5521:
5522: IF (l_debug = 1) THEN

Line 5524: 'create_direct_rti_rec 25.1: create_asn_con_dd_intf_rec RAISE FND_API.G_EXC_ERROR;'

5520: fnd_msg_pub.ADD;
5521:
5522: IF (l_debug = 1) THEN
5523: print_debug(
5524: 'create_direct_rti_rec 25.1: create_asn_con_dd_intf_rec RAISE FND_API.G_EXC_ERROR;'
5525: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5526: END IF;
5527:
5528: RAISE fnd_api.g_exc_error;

Line 5528: RAISE fnd_api.g_exc_error;

5524: 'create_direct_rti_rec 25.1: create_asn_con_dd_intf_rec RAISE FND_API.G_EXC_ERROR;'
5525: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5526: END IF;
5527:
5528: RAISE fnd_api.g_exc_error;
5529: END IF;
5530:
5531: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5532: fnd_message.set_name('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD

Line 5531: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5527:
5528: RAISE fnd_api.g_exc_error;
5529: END IF;
5530:
5531: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5532: fnd_message.set_name('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
5533: fnd_msg_pub.ADD;
5534:
5535: IF (l_debug = 1) THEN

Line 5537: 'create_direct_rti_rec 25.2: create_asn_con_dd_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

5533: fnd_msg_pub.ADD;
5534:
5535: IF (l_debug = 1) THEN
5536: print_debug(
5537: 'create_direct_rti_rec 25.2: create_asn_con_dd_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
5538: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
5539: , 4
5540: );
5541: END IF;

Line 5543: RAISE fnd_api.g_exc_unexpected_error;

5539: , 4
5540: );
5541: END IF;
5542:
5543: RAISE fnd_api.g_exc_unexpected_error;
5544: END IF;
5545: ELSE
5546: create_int_shp_dr_del_rti_rec(
5547: p_move_order_header_id => p_move_order_header_id

Line 5591: IF l_return_status = fnd_api.g_ret_sts_error THEN

5587: , p_attribute14 => p_attribute14
5588: , p_attribute15 => p_attribute15
5589: );
5590:
5591: IF l_return_status = fnd_api.g_ret_sts_error THEN
5592: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5593: fnd_msg_pub.ADD;
5594:
5595: IF (l_debug = 1) THEN

Line 5597: 'create_direct_rti_rec 40.1: create_int_shp_dr_del_rti_rec RAISE FND_API.G_EXC_ERROR;'

5593: fnd_msg_pub.ADD;
5594:
5595: IF (l_debug = 1) THEN
5596: print_debug(
5597: 'create_direct_rti_rec 40.1: create_int_shp_dr_del_rti_rec RAISE FND_API.G_EXC_ERROR;'
5598: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5599: END IF;
5600:
5601: RAISE fnd_api.g_exc_error;

Line 5601: RAISE fnd_api.g_exc_error;

5597: 'create_direct_rti_rec 40.1: create_int_shp_dr_del_rti_rec RAISE FND_API.G_EXC_ERROR;'
5598: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5599: END IF;
5600:
5601: RAISE fnd_api.g_exc_error;
5602: END IF;
5603:
5604: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5605: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

Line 5604: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5600:
5601: RAISE fnd_api.g_exc_error;
5602: END IF;
5603:
5604: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5605: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5606: fnd_msg_pub.ADD;
5607:
5608: IF (l_debug = 1) THEN

Line 5610: 'create_direct_rti_rec 40.2:create_int_shp_dr_del_rti_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

5606: fnd_msg_pub.ADD;
5607:
5608: IF (l_debug = 1) THEN
5609: print_debug(
5610: 'create_direct_rti_rec 40.2:create_int_shp_dr_del_rti_rec FND_API.G_EXC_UNEXPECTED_ERROR;'
5611: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5612: END IF;
5613:
5614: RAISE fnd_api.g_exc_unexpected_error;

Line 5614: RAISE fnd_api.g_exc_unexpected_error;

5610: 'create_direct_rti_rec 40.2:create_int_shp_dr_del_rti_rec FND_API.G_EXC_UNEXPECTED_ERROR;'
5611: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5612: END IF;
5613:
5614: RAISE fnd_api.g_exc_unexpected_error;
5615: END IF;
5616: END IF;
5617: ELSIF p_oe_order_header_id IS NOT NULL THEN
5618: l_progress := '60';

Line 5668: IF l_return_status = fnd_api.g_ret_sts_error THEN

5664: , p_attribute14 => p_attribute14
5665: , p_attribute15 => p_attribute15
5666: );
5667:
5668: IF l_return_status = fnd_api.g_ret_sts_error THEN
5669: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
5670: fnd_msg_pub.ADD;
5671:
5672: IF (l_debug = 1) THEN

Line 5674: 'create_direct_rti_rec 50.1: create_rma_drct_dlvr_rti_rec RAISE FND_API.G_EXC_ERROR;'

5670: fnd_msg_pub.ADD;
5671:
5672: IF (l_debug = 1) THEN
5673: print_debug(
5674: 'create_direct_rti_rec 50.1: create_rma_drct_dlvr_rti_rec RAISE FND_API.G_EXC_ERROR;'
5675: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5676: END IF;
5677:
5678: RAISE fnd_api.g_exc_error;

Line 5678: RAISE fnd_api.g_exc_error;

5674: 'create_direct_rti_rec 50.1: create_rma_drct_dlvr_rti_rec RAISE FND_API.G_EXC_ERROR;'
5675: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5676: END IF;
5677:
5678: RAISE fnd_api.g_exc_error;
5679: END IF;
5680:
5681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5682: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

Line 5681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5677:
5678: RAISE fnd_api.g_exc_error;
5679: END IF;
5680:
5681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5682: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
5683: fnd_msg_pub.ADD;
5684:
5685: IF (l_debug = 1) THEN

Line 5687: 'create_direct_rti_rec 50.2: create_rma_drct_dlvr_rti_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

5683: fnd_msg_pub.ADD;
5684:
5685: IF (l_debug = 1) THEN
5686: print_debug(
5687: 'create_direct_rti_rec 50.2: create_rma_drct_dlvr_rti_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
5688: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5689: END IF;
5690:
5691: RAISE fnd_api.g_exc_unexpected_error;

Line 5691: RAISE fnd_api.g_exc_unexpected_error;

5687: 'create_direct_rti_rec 50.2: create_rma_drct_dlvr_rti_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'
5688: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5689: END IF;
5690:
5691: RAISE fnd_api.g_exc_unexpected_error;
5692: END IF;
5693: END IF;
5694:
5695: l_progress := '80';

Line 5705: IF l_return_status <> fnd_api.g_ret_sts_error THEN

5701: x_status := l_return_status; -- l_return_status can be 'W', we want to carry that over
5702:
5703: -- calling label printing API
5704:
5705: IF l_return_status <> fnd_api.g_ret_sts_error THEN
5706: l_progress := '80';
5707:
5708: IF (l_debug = 1) THEN
5709: print_debug('create_direct_rti_rec: 8.1 before inv_label.print_label ' || inv_rcv_common_apis.g_rcv_global_var.interface_group_id, 4);

Line 5746: IF l_return_status <> fnd_api.g_ret_sts_success THEN

5742: , p_business_flow_code => 1
5743: , p_transaction_id => l_txn_id_tbl
5744: );
5745:
5746: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5747: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
5748: fnd_msg_pub.ADD;
5749: x_status := 'W';
5750:

Line 5773: WHEN fnd_api.g_exc_error THEN

5769: print_debug('create_direct_rti_rec: 8.1 - x_status = ' || x_status, 4);
5770: print_debug('create_direct_rti_rec: 8.2 - x_message= ' || x_message, 4);
5771: END IF;
5772: EXCEPTION
5773: WHEN fnd_api.g_exc_error THEN
5774: x_status := fnd_api.g_ret_sts_error;
5775: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5776: WHEN fnd_api.g_exc_unexpected_error THEN
5777: x_status := fnd_api.g_ret_sts_unexp_error;

Line 5774: x_status := fnd_api.g_ret_sts_error;

5770: print_debug('create_direct_rti_rec: 8.2 - x_message= ' || x_message, 4);
5771: END IF;
5772: EXCEPTION
5773: WHEN fnd_api.g_exc_error THEN
5774: x_status := fnd_api.g_ret_sts_error;
5775: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5776: WHEN fnd_api.g_exc_unexpected_error THEN
5777: x_status := fnd_api.g_ret_sts_unexp_error;
5778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

Line 5775: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

5771: END IF;
5772: EXCEPTION
5773: WHEN fnd_api.g_exc_error THEN
5774: x_status := fnd_api.g_ret_sts_error;
5775: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5776: WHEN fnd_api.g_exc_unexpected_error THEN
5777: x_status := fnd_api.g_ret_sts_unexp_error;
5778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5779: WHEN OTHERS THEN

Line 5776: WHEN fnd_api.g_exc_unexpected_error THEN

5772: EXCEPTION
5773: WHEN fnd_api.g_exc_error THEN
5774: x_status := fnd_api.g_ret_sts_error;
5775: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5776: WHEN fnd_api.g_exc_unexpected_error THEN
5777: x_status := fnd_api.g_ret_sts_unexp_error;
5778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5779: WHEN OTHERS THEN
5780: x_status := fnd_api.g_ret_sts_unexp_error;

Line 5777: x_status := fnd_api.g_ret_sts_unexp_error;

5773: WHEN fnd_api.g_exc_error THEN
5774: x_status := fnd_api.g_ret_sts_error;
5775: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5776: WHEN fnd_api.g_exc_unexpected_error THEN
5777: x_status := fnd_api.g_ret_sts_unexp_error;
5778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5779: WHEN OTHERS THEN
5780: x_status := fnd_api.g_ret_sts_unexp_error;
5781:

Line 5778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

5774: x_status := fnd_api.g_ret_sts_error;
5775: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5776: WHEN fnd_api.g_exc_unexpected_error THEN
5777: x_status := fnd_api.g_ret_sts_unexp_error;
5778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5779: WHEN OTHERS THEN
5780: x_status := fnd_api.g_ret_sts_unexp_error;
5781:
5782: IF SQLCODE IS NOT NULL THEN

Line 5780: x_status := fnd_api.g_ret_sts_unexp_error;

5776: WHEN fnd_api.g_exc_unexpected_error THEN
5777: x_status := fnd_api.g_ret_sts_unexp_error;
5778: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5779: WHEN OTHERS THEN
5780: x_status := fnd_api.g_ret_sts_unexp_error;
5781:
5782: IF SQLCODE IS NOT NULL THEN
5783: inv_mobile_helper_functions.sql_error('inv_rcv_dir_rcpt_apis.create_direct_rti_rec', l_progress, SQLCODE);
5784: END IF;

Line 5786: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

5782: IF SQLCODE IS NOT NULL THEN
5783: inv_mobile_helper_functions.sql_error('inv_rcv_dir_rcpt_apis.create_direct_rti_rec', l_progress, SQLCODE);
5784: END IF;
5785:
5786: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5787: END create_direct_rti_rec;
5788: /*
5789: PROCEDURE pack_lpn_txn
5790: IS