APPS.INV_RCV_STD_DELIVER_APIS dependencies on FND_API

Line 1405: RAISE fnd_api.g_exc_error;

1401: print_debug('populate_default_values 141 - trying to do transfer IN storage sub_type : ', 4);
1402: END IF;
1403: fnd_message.set_name('INV', 'INV_INVALID_SUB_TXN_COMBO');
1404: fnd_msg_pub.ADD;
1405: RAISE fnd_api.g_exc_error;
1406: END IF;
1407: END IF;
1408:
1409: -- Call procedure INSERT_INTERFACE_CODE to populate RCV_TRANSACTION_INTERFACE

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

1517: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
1518: -- local variable to store the output of the matching algorithm
1519:
1520: l_msg_count NUMBER;
1521: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1522: l_group_id NUMBER;
1523: l_transaction_type VARCHAR2(20) := 'STD_DELIVER';
1524: l_total_primary_qty NUMBER := 0;
1525: l_err_message VARCHAR2(100);

Line 1640: x_status := fnd_api.g_ret_sts_success;

1636: ORDER BY rt.transaction_date DESC;
1637:
1638: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1639: BEGIN
1640: x_status := fnd_api.g_ret_sts_success;
1641:
1642: IF (l_debug = 1) THEN
1643: print_debug('Entering create_osp_po_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1644: END IF;

Line 1715: IF x_status <> fnd_api.g_ret_sts_success THEN

1711: , p_lpn_id => NULL
1712: );
1713:
1714: -- x_status is not successful if there is any execution error in matching.
1715: IF x_status <> fnd_api.g_ret_sts_success THEN
1716: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1717: fnd_msg_pub.ADD;
1718:
1719: IF (l_debug = 1) THEN

Line 1727: x_status := fnd_api.g_ret_sts_error;

1723: RETURN;
1724: END IF;
1725:
1726: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
1727: x_status := fnd_api.g_ret_sts_error;
1728: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
1729: fnd_message.set_name('INV', l_err_message);
1730: fnd_msg_pub.ADD;
1731:

Line 1837: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1833: , x_msg_count => l_msg_count
1834: , x_msg_data => x_message
1835: );
1836:
1837: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1838: x_status := l_return_status;
1839: END IF;
1840:
1841: l_progress := '100';

Line 1848: x_status := fnd_api.g_ret_sts_unexp_error;

1844: print_debug('Exiting create_osp_po_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1845: END IF;
1846: EXCEPTION
1847: WHEN OTHERS THEN
1848: x_status := fnd_api.g_ret_sts_unexp_error;
1849:
1850: IF l_curs_rcvtxn_detail%ISOPEN THEN
1851: CLOSE l_curs_rcvtxn_detail;
1852: END IF;

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

1854: IF SQLCODE IS NOT NULL THEN
1855: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_po_rcvtxn_intf_rec', l_progress, SQLCODE);
1856: END IF;
1857:
1858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1859: END create_osp_po_rcvtxn_intf_rec;
1860:
1861: PROCEDURE create_po_rcvtxn_intf_rec(
1862: p_organization_id IN NUMBER

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

1895: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
1896: -- local variable to store the output of the matching algorithm
1897:
1898: l_msg_count NUMBER;
1899: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1900: l_group_id NUMBER;
1901: l_transaction_type VARCHAR2(20) := 'STD_DELIVER';
1902: l_total_primary_qty NUMBER := 0;
1903: l_err_message VARCHAR2(100);

Line 2134: x_status := fnd_api.g_ret_sts_success;

2130: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2131: l_prim_uom_code VARCHAR2(3);
2132: l_rcvtxn_uom_code VARCHAR2(3);
2133: BEGIN
2134: x_status := fnd_api.g_ret_sts_success;
2135:
2136: IF (l_debug = 1) THEN
2137: print_debug('Entering create_po_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2138: print_debug(' p_item_id => '||p_item_id,4);

Line 2250: IF x_status <> fnd_api.g_ret_sts_success THEN

2246: , p_lpn_id => NULL
2247: );
2248:
2249: -- x_status is not successful if there is any execution error in matching.
2250: IF x_status <> fnd_api.g_ret_sts_success THEN
2251: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2252: fnd_msg_pub.ADD;
2253:
2254: IF (l_debug = 1) THEN

Line 2262: x_status := fnd_api.g_ret_sts_error;

2258: RETURN;
2259: END IF;
2260:
2261: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
2262: x_status := fnd_api.g_ret_sts_error;
2263: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
2264: fnd_message.set_name('INV', l_err_message);
2265: fnd_msg_pub.ADD;
2266:

Line 2472: RAISE fnd_api.g_exc_error;

2468: WHEN OTHERS THEN
2469: IF (l_debug = 1) THEN
2470: print_debug('create_po_rcvtxn_intf_rec: Error retrieving MOL id',4);
2471: END IF;
2472: RAISE fnd_api.g_exc_error;
2473: END;
2474: END IF; --IF (l_orig_mol_id IS NULL) THEN
2475:
2476:

Line 2497: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2493: x_return_status => l_return_status,
2494: x_msg_count => l_msg_count,
2495: x_msg_data => x_message);
2496:
2497: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2498: RAISE fnd_api.g_exc_error;
2499: END IF;
2500: l_progress := '75';
2501:

Line 2498: RAISE fnd_api.g_exc_error;

2494: x_msg_count => l_msg_count,
2495: x_msg_data => x_message);
2496:
2497: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2498: RAISE fnd_api.g_exc_error;
2499: END IF;
2500: l_progress := '75';
2501:
2502: BEGIN

Line 2593: , p_init_msg_lst => FND_API.G_FALSE

2589: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2590:
2591: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2592: p_api_version => 1.0
2593: , p_init_msg_lst => FND_API.G_FALSE
2594: , x_return_status => l_return_status
2595: , x_msg_count => l_msg_count
2596: , x_msg_data => x_message
2597: , p_new_rti_info => l_new_rti_info);

Line 2602: RAISE FND_API.G_EXC_ERROR;

2598: IF ( NOT l_split_lot_serial_ok) THEN
2599: IF (l_debug = 1) THEN
2600: print_debug('create_po_rcvtxn_intf_rec 67: Failure in split_lot_serial', 4);
2601: END IF;
2602: RAISE FND_API.G_EXC_ERROR;
2603: END IF;
2604:
2605: IF (l_debug = 1) THEN
2606: print_debug('create_po_rcvtxn_intf_rec 68: Call split_lot_serial is OK', 4);

Line 2622: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2618: , x_msg_count => l_msg_count
2619: , x_msg_data => x_message
2620: );
2621:
2622: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2623: x_status := l_return_status;
2624: END IF;
2625:
2626: l_progress := '100';

Line 2633: x_status := fnd_api.g_ret_sts_unexp_error;

2629: print_debug('Exiting create_po_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2630: END IF;
2631: EXCEPTION
2632: WHEN OTHERS THEN
2633: x_status := fnd_api.g_ret_sts_unexp_error;
2634:
2635: IF l_curs_rcvtxn_detail%ISOPEN THEN
2636: CLOSE l_curs_rcvtxn_detail;
2637: END IF;

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

2639: IF SQLCODE IS NOT NULL THEN
2640: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_po_rcvtxn_intf_rec', l_progress, SQLCODE);
2641: END IF;
2642:
2643: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2644: END create_po_rcvtxn_intf_rec;
2645:
2646: PROCEDURE create_int_shp_rcvtxn_intf_rec(
2647: p_organization_id IN NUMBER

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

2677: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
2678: -- local variable to store the output of the matching algorithm
2679:
2680: l_msg_count NUMBER;
2681: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2682: l_group_id NUMBER;
2683: l_transaction_type VARCHAR2(20) := 'STD_DELIVER';
2684: l_total_primary_qty NUMBER := 0;
2685: l_asn_type VARCHAR2(25);

Line 2808: x_status := fnd_api.g_ret_sts_success;

2804: l_msni_count NUMBER := 0;
2805: l_prim_uom_code VARCHAR2(3);
2806: l_rcvtxn_uom_code VARCHAR2(3);
2807: BEGIN
2808: x_status := fnd_api.g_ret_sts_success;
2809:
2810: IF (l_debug = 1) THEN
2811: print_debug('Entering create_int_shp_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2812: END IF;

Line 2945: IF x_status <> fnd_api.g_ret_sts_success THEN

2941: );
2942:
2943:
2944: -- x_status is not successful if there is any execution error in matching.
2945: IF x_status <> fnd_api.g_ret_sts_success THEN
2946: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2947: fnd_msg_pub.ADD;
2948:
2949: IF (l_debug = 1) THEN

Line 2959: x_status := fnd_api.g_ret_sts_error;

2955:
2956: END IF;
2957:
2958: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
2959: x_status := fnd_api.g_ret_sts_error;
2960: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
2961: fnd_message.set_name('INV', l_err_message);
2962: fnd_msg_pub.ADD;
2963:

Line 3104: RAISE fnd_api.g_exc_error;

3100: WHEN OTHERS THEN
3101: IF (l_debug = 1) THEN
3102: print_debug('create_int_shp_rcvtxn_intf_rec: Error retrieving MOL id',4);
3103: END IF;
3104: RAISE fnd_api.g_exc_error;
3105: END;
3106: END IF; --IF (l_orig_mol_id IS NULL) THEN
3107:
3108: l_mo_splt_tb(1).prim_qty := l_rcv_transaction_rec.primary_quantity;

Line 3128: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3124: x_return_status => l_return_status,
3125: x_msg_count => l_msg_count,
3126: x_msg_data => x_message);
3127:
3128: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3129: RAISE fnd_api.g_exc_error;
3130: END IF;
3131: l_progress := '75';
3132:

Line 3129: RAISE fnd_api.g_exc_error;

3125: x_msg_count => l_msg_count,
3126: x_msg_data => x_message);
3127:
3128: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3129: RAISE fnd_api.g_exc_error;
3130: END IF;
3131: l_progress := '75';
3132:
3133: BEGIN

Line 3263: , p_init_msg_lst => FND_API.G_FALSE

3259: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3260:
3261: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3262: p_api_version => 1.0
3263: , p_init_msg_lst => FND_API.G_FALSE
3264: , x_return_status => l_return_status
3265: , x_msg_count => l_msg_count
3266: , x_msg_data => x_message
3267: , p_new_rti_info => l_new_rti_info);

Line 3272: RAISE FND_API.G_EXC_ERROR;

3268: IF ( NOT l_split_lot_serial_ok) THEN
3269: IF (l_debug = 1) THEN
3270: print_debug('create_int_shp_rcvtxn_intf_rec 128: Failure in split_lot_serial', 4);
3271: END IF;
3272: RAISE FND_API.G_EXC_ERROR;
3273: END IF;
3274:
3275: IF (l_debug = 1) THEN
3276: print_debug('create_int_shp_rcvtxn_intf_rec 129: Call split_lot_serial is OK', 4);

Line 3291: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3287: , x_msg_count => l_msg_count
3288: , x_msg_data => x_message
3289: );
3290:
3291: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3292: x_status := l_return_status;
3293: END IF;
3294:
3295: l_progress := '100';

Line 3302: x_status := fnd_api.g_ret_sts_unexp_error;

3298: print_debug('Exiting create_int_shp_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3299: END IF;
3300: EXCEPTION
3301: WHEN OTHERS THEN
3302: x_status := fnd_api.g_ret_sts_unexp_error;
3303:
3304: IF l_curs_rcvtxn_detail%ISOPEN THEN
3305: CLOSE l_curs_rcvtxn_detail;
3306: END IF;

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

3308: IF SQLCODE IS NOT NULL THEN
3309: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_int_shp_rcvtxn_intf_rec', l_progress, SQLCODE);
3310: END IF;
3311:
3312: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3313: END create_int_shp_rcvtxn_intf_rec;
3314:
3315: PROCEDURE create_rma_rcvtxn_intf_rec(
3316: p_organization_id IN NUMBER

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

3346: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
3347: -- local variable to store the output of the matching algorithm
3348:
3349: l_msg_count NUMBER;
3350: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3351: l_group_id NUMBER;
3352: l_transaction_type VARCHAR2(20) := 'STD_DELIVER';
3353: l_total_primary_qty NUMBER := 0;
3354: l_asn_type VARCHAR2(25);

Line 3476: x_status := fnd_api.g_ret_sts_success;

3472: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3473: l_prim_uom_code VARCHAR2(3);
3474: l_rcvtxn_uom_code VARCHAR2(3);
3475: BEGIN
3476: x_status := fnd_api.g_ret_sts_success;
3477:
3478: IF (l_debug = 1) THEN
3479: print_debug('Entering create_rma_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3480: END IF;

Line 3576: IF x_status <> fnd_api.g_ret_sts_success THEN

3572: , p_lpn_id => NULL
3573: );
3574:
3575: -- x_status is not successful if there is any execution error in matching.
3576: IF x_status <> fnd_api.g_ret_sts_success THEN
3577: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3578: fnd_msg_pub.ADD;
3579:
3580: IF (l_debug = 1) THEN

Line 3588: x_status := fnd_api.g_ret_sts_error;

3584: RETURN;
3585: END IF;
3586:
3587: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
3588: x_status := fnd_api.g_ret_sts_error;
3589: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
3590: fnd_message.set_name('INV', l_err_message);
3591: fnd_msg_pub.ADD;
3592:

Line 3727: RAISE fnd_api.g_exc_error;

3723: WHEN OTHERS THEN
3724: IF (l_debug = 1) THEN
3725: print_debug('create_rma_rcvtxn_intf_rec: Error retrieving MOL id',4);
3726: END IF;
3727: RAISE fnd_api.g_exc_error;
3728: END;
3729: END IF; --IF (l_orig_mol_id IS NULL) THEN
3730:
3731: l_mo_splt_tb(1).prim_qty := l_rcv_transaction_rec.primary_quantity;

Line 3751: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3747: x_return_status => l_return_status,
3748: x_msg_count => l_msg_count,
3749: x_msg_data => x_message);
3750:
3751: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3752: RAISE fnd_api.g_exc_error;
3753: END IF;
3754: l_progress := '75';
3755:

Line 3752: RAISE fnd_api.g_exc_error;

3748: x_msg_count => l_msg_count,
3749: x_msg_data => x_message);
3750:
3751: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3752: RAISE fnd_api.g_exc_error;
3753: END IF;
3754: l_progress := '75';
3755:
3756: BEGIN

Line 3827: , p_init_msg_lst => FND_API.G_FALSE

3823: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) 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_rma_rcvtxn_intf_rec 65: 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_rma_rcvtxn_intf_rec 66: Call split_lot_serial is OK', 4);

Line 3856: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3852: , x_msg_count => l_msg_count
3853: , x_msg_data => x_message
3854: );
3855:
3856: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3857: x_status := l_return_status;
3858: END IF;
3859:
3860: l_progress := '100';

Line 3867: x_status := fnd_api.g_ret_sts_unexp_error;

3863: print_debug('Exiting create_rma_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3864: END IF;
3865: EXCEPTION
3866: WHEN OTHERS THEN
3867: x_status := fnd_api.g_ret_sts_unexp_error;
3868:
3869: IF l_curs_rcvtxn_detail%ISOPEN THEN
3870: CLOSE l_curs_rcvtxn_detail;
3871: END IF;

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

3873: IF SQLCODE IS NOT NULL THEN
3874: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rma_rcvtxn_intf_rec', l_progress, SQLCODE);
3875: END IF;
3876:
3877: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3878: END create_rma_rcvtxn_intf_rec;
3879:
3880: PROCEDURE create_rpt_num_rcvtxn_intf_rec(
3881: p_organization_id IN NUMBER

Line 3920: x_status := fnd_api.g_ret_sts_success;

3916: AND rsup.item_id = p_item_id;
3917:
3918: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3919: BEGIN
3920: x_status := fnd_api.g_ret_sts_success;
3921: l_progress := '10';
3922:
3923: IF (l_debug = 1) THEN
3924: print_debug('create_rpt_num_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 3965: IF x_status = fnd_api.g_ret_sts_error THEN

3961: , p_lot_number => NULL
3962: , p_deliver_to_location_id => p_deliver_to_location_id
3963: );
3964:
3965: IF x_status = fnd_api.g_ret_sts_error THEN
3966: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3967: fnd_msg_pub.ADD;
3968:
3969: IF (l_debug = 1) THEN

Line 3970: print_debug('create_rpt_num_rcvtxn_intf_rec 20.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

3966: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3967: fnd_msg_pub.ADD;
3968:
3969: IF (l_debug = 1) THEN
3970: print_debug('create_rpt_num_rcvtxn_intf_rec 20.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
3971: END IF;
3972:
3973: RAISE fnd_api.g_exc_error;
3974: END IF;

Line 3973: RAISE fnd_api.g_exc_error;

3969: IF (l_debug = 1) THEN
3970: print_debug('create_rpt_num_rcvtxn_intf_rec 20.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
3971: END IF;
3972:
3973: RAISE fnd_api.g_exc_error;
3974: END IF;
3975:
3976: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
3977: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 3976: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

3972:
3973: RAISE fnd_api.g_exc_error;
3974: END IF;
3975:
3976: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
3977: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3978: fnd_msg_pub.ADD;
3979:
3980: IF (l_debug = 1) THEN

Line 3981: print_debug('create_rpt_num_rcvtxn_intf_rec 20.2: FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

3977: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3978: fnd_msg_pub.ADD;
3979:
3980: IF (l_debug = 1) THEN
3981: print_debug('create_rpt_num_rcvtxn_intf_rec 20.2: FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
3982: END IF;
3983:
3984: RAISE fnd_api.g_exc_unexpected_error;
3985: END IF;

Line 3984: RAISE fnd_api.g_exc_unexpected_error;

3980: IF (l_debug = 1) THEN
3981: print_debug('create_rpt_num_rcvtxn_intf_rec 20.2: FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
3982: END IF;
3983:
3984: RAISE fnd_api.g_exc_unexpected_error;
3985: END IF;
3986: ELSIF l_oe_order_header_id IS NOT NULL THEN
3987: l_progress := '40';
3988:

Line 4016: IF x_status = fnd_api.g_ret_sts_error THEN

4012: , p_transfer_lpn_id => NULL
4013: , p_lot_number => NULL
4014: );
4015:
4016: IF x_status = fnd_api.g_ret_sts_error THEN
4017: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4018: fnd_msg_pub.ADD;
4019:
4020: IF (l_debug = 1) THEN

Line 4021: print_debug('create_rpt_num_rcvtxn_intf_rec 30.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4017: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4018: fnd_msg_pub.ADD;
4019:
4020: IF (l_debug = 1) THEN
4021: print_debug('create_rpt_num_rcvtxn_intf_rec 30.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4022: END IF;
4023:
4024: RAISE fnd_api.g_exc_error;
4025: END IF;

Line 4024: RAISE fnd_api.g_exc_error;

4020: IF (l_debug = 1) THEN
4021: print_debug('create_rpt_num_rcvtxn_intf_rec 30.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4022: END IF;
4023:
4024: RAISE fnd_api.g_exc_error;
4025: END IF;
4026:
4027: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4028: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

Line 4027: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4023:
4024: RAISE fnd_api.g_exc_error;
4025: END IF;
4026:
4027: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4028: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4029: fnd_msg_pub.ADD;
4030:
4031: IF (l_debug = 1) THEN

Line 4032: print_debug('create_rpt_num_rcvtxn_intf_rec 30.2: FND_API.G_EXC_UNEXPECTED_ERROR;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4028: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4029: fnd_msg_pub.ADD;
4030:
4031: IF (l_debug = 1) THEN
4032: print_debug('create_rpt_num_rcvtxn_intf_rec 30.2: FND_API.G_EXC_UNEXPECTED_ERROR;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4033: END IF;
4034:
4035: RAISE fnd_api.g_exc_unexpected_error;
4036: END IF;

Line 4035: RAISE fnd_api.g_exc_unexpected_error;

4031: IF (l_debug = 1) THEN
4032: print_debug('create_rpt_num_rcvtxn_intf_rec 30.2: FND_API.G_EXC_UNEXPECTED_ERROR;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4033: END IF;
4034:
4035: RAISE fnd_api.g_exc_unexpected_error;
4036: END IF;
4037: ELSE
4038: l_progress := '50';
4039:

Line 4067: IF x_status = fnd_api.g_ret_sts_error THEN

4063: , p_transfer_lpn_id => NULL
4064: , p_lot_number => NULL
4065: );
4066:
4067: IF x_status = fnd_api.g_ret_sts_error THEN
4068: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4069: fnd_msg_pub.ADD;
4070:
4071: IF (l_debug = 1) THEN

Line 4072: print_debug('create_rpt_num_rcvtxn_intf_rec 40.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4068: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4069: fnd_msg_pub.ADD;
4070:
4071: IF (l_debug = 1) THEN
4072: print_debug('create_rpt_num_rcvtxn_intf_rec 40.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4073: END IF;
4074:
4075: RAISE fnd_api.g_exc_error;
4076: END IF;

Line 4075: RAISE fnd_api.g_exc_error;

4071: IF (l_debug = 1) THEN
4072: print_debug('create_rpt_num_rcvtxn_intf_rec 40.1: RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4073: END IF;
4074:
4075: RAISE fnd_api.g_exc_error;
4076: END IF;
4077:
4078: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4079: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

Line 4078: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4074:
4075: RAISE fnd_api.g_exc_error;
4076: END IF;
4077:
4078: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4079: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4080: fnd_msg_pub.ADD;
4081:
4082: IF (l_debug = 1) THEN

Line 4083: print_debug('create_rpt_num_rcvtxn_intf_rec 40.2: FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4079: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4080: fnd_msg_pub.ADD;
4081:
4082: IF (l_debug = 1) THEN
4083: print_debug('create_rpt_num_rcvtxn_intf_rec 40.2: FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4084: END IF;
4085:
4086: RAISE fnd_api.g_exc_unexpected_error;
4087: END IF;

Line 4086: RAISE fnd_api.g_exc_unexpected_error;

4082: IF (l_debug = 1) THEN
4083: print_debug('create_rpt_num_rcvtxn_intf_rec 40.2: FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4084: END IF;
4085:
4086: RAISE fnd_api.g_exc_unexpected_error;
4087: END IF;
4088: END IF;
4089:
4090: l_progress := '60';

Line 4096: WHEN fnd_api.g_exc_error THEN

4092: IF (l_debug = 1) THEN
4093: print_debug('create_rpt_num_rcvtxn_intf_rec exitting: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4094: END IF;
4095: EXCEPTION
4096: WHEN fnd_api.g_exc_error THEN
4097: x_status := fnd_api.g_ret_sts_error;
4098:
4099: IF l_curs_rcvtxn_detail%ISOPEN THEN
4100: CLOSE l_curs_rcvtxn_detail;

Line 4097: x_status := fnd_api.g_ret_sts_error;

4093: print_debug('create_rpt_num_rcvtxn_intf_rec exitting: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4094: END IF;
4095: EXCEPTION
4096: WHEN fnd_api.g_exc_error THEN
4097: x_status := fnd_api.g_ret_sts_error;
4098:
4099: IF l_curs_rcvtxn_detail%ISOPEN THEN
4100: CLOSE l_curs_rcvtxn_detail;
4101: END IF;

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

4099: IF l_curs_rcvtxn_detail%ISOPEN THEN
4100: CLOSE l_curs_rcvtxn_detail;
4101: END IF;
4102:
4103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4104: WHEN fnd_api.g_exc_unexpected_error THEN
4105: x_status := fnd_api.g_ret_sts_unexp_error;
4106:
4107: IF l_curs_rcvtxn_detail%ISOPEN THEN

Line 4104: WHEN fnd_api.g_exc_unexpected_error THEN

4100: CLOSE l_curs_rcvtxn_detail;
4101: END IF;
4102:
4103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4104: WHEN fnd_api.g_exc_unexpected_error THEN
4105: x_status := fnd_api.g_ret_sts_unexp_error;
4106:
4107: IF l_curs_rcvtxn_detail%ISOPEN THEN
4108: CLOSE l_curs_rcvtxn_detail;

Line 4105: x_status := fnd_api.g_ret_sts_unexp_error;

4101: END IF;
4102:
4103: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4104: WHEN fnd_api.g_exc_unexpected_error THEN
4105: x_status := fnd_api.g_ret_sts_unexp_error;
4106:
4107: IF l_curs_rcvtxn_detail%ISOPEN THEN
4108: CLOSE l_curs_rcvtxn_detail;
4109: END IF;

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

4107: IF l_curs_rcvtxn_detail%ISOPEN THEN
4108: CLOSE l_curs_rcvtxn_detail;
4109: END IF;
4110:
4111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4112: WHEN OTHERS THEN
4113: x_status := fnd_api.g_ret_sts_unexp_error;
4114:
4115: IF l_curs_rcvtxn_detail%ISOPEN THEN

Line 4113: x_status := fnd_api.g_ret_sts_unexp_error;

4109: END IF;
4110:
4111: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4112: WHEN OTHERS THEN
4113: x_status := fnd_api.g_ret_sts_unexp_error;
4114:
4115: IF l_curs_rcvtxn_detail%ISOPEN THEN
4116: CLOSE l_curs_rcvtxn_detail;
4117: END IF;

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

4119: IF SQLCODE IS NOT NULL THEN
4120: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rpt_num_rcvtxn_intf_rec', l_progress, SQLCODE);
4121: END IF;
4122:
4123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4124: END;
4125:
4126: PROCEDURE create_osp_std_rcvtxn_intf_rec(
4127: p_organization_id IN NUMBER

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

4140: , p_secondary_qty IN NUMBER DEFAULT NULL --OPM Convergence
4141: ) IS
4142: l_progress VARCHAR2(10);
4143: l_msg_count NUMBER;
4144: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4145: l_msg_data VARCHAR2(400);
4146: l_label_status VARCHAR2(500);
4147: l_txn_id_tbl inv_label.transaction_id_rec_type;
4148: l_counter NUMBER := 0;

Line 4160: x_status := fnd_api.g_ret_sts_success;

4156: GROUP BY rti.lpn_id;
4157:
4158: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4159: BEGIN
4160: x_status := fnd_api.g_ret_sts_success;
4161: l_progress := '10';
4162:
4163: IF (l_debug = 1) THEN
4164: print_debug('create_osp_std_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4186: IF x_status <> fnd_api.g_ret_sts_success THEN

4182: , x_return_status => x_status
4183: , x_error_code => x_message
4184: );
4185:
4186: IF x_status <> fnd_api.g_ret_sts_success THEN
4187: RETURN;
4188: END IF;
4189:
4190: l_progress := '30';

Line 4217: IF x_status = fnd_api.g_ret_sts_error THEN

4213: , x_message => x_message
4214: , p_inspection_status_code => NULL
4215: );
4216:
4217: IF x_status = fnd_api.g_ret_sts_error THEN
4218: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4219: fnd_msg_pub.ADD;
4220:
4221: IF (l_debug = 1) THEN

Line 4222: print_debug('create_osp_std_rcvtxn_intf_rec 20.1: create_osp_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4218: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4219: fnd_msg_pub.ADD;
4220:
4221: IF (l_debug = 1) THEN
4222: print_debug('create_osp_std_rcvtxn_intf_rec 20.1: create_osp_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4223: END IF;
4224:
4225: RAISE fnd_api.g_exc_error;
4226: END IF;

Line 4225: RAISE fnd_api.g_exc_error;

4221: IF (l_debug = 1) THEN
4222: print_debug('create_osp_std_rcvtxn_intf_rec 20.1: create_osp_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4223: END IF;
4224:
4225: RAISE fnd_api.g_exc_error;
4226: END IF;
4227:
4228: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4229: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 4228: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4224:
4225: RAISE fnd_api.g_exc_error;
4226: END IF;
4227:
4228: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4229: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4230: fnd_msg_pub.ADD;
4231:
4232: IF (l_debug = 1) THEN

Line 4233: print_debug('create_osp_std_rcvtxn_intf_rec 20.2: create_osp_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4229: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4230: fnd_msg_pub.ADD;
4231:
4232: IF (l_debug = 1) THEN
4233: print_debug('create_osp_std_rcvtxn_intf_rec 20.2: create_osp_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4234: END IF;
4235:
4236: RAISE fnd_api.g_exc_unexpected_error;
4237: END IF;

Line 4236: RAISE fnd_api.g_exc_unexpected_error;

4232: IF (l_debug = 1) THEN
4233: print_debug('create_osp_std_rcvtxn_intf_rec 20.2: create_osp_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4234: END IF;
4235:
4236: RAISE fnd_api.g_exc_unexpected_error;
4237: END IF;
4238: END IF;
4239:
4240: l_progress := '80';

Line 4247: IF x_status <> fnd_api.g_ret_sts_error THEN

4243: print_debug('create_osp_std_rcvtxn_intf_rec exitting: 60' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4244: END IF;
4245:
4246: -- calling label printing API
4247: IF x_status <> fnd_api.g_ret_sts_error THEN
4248: IF (l_debug = 1) THEN
4249: print_debug('create_osp_std_rcpt_intf_rec: 8.1 before inv_label.print_label ', 4);
4250: END IF;
4251:

Line 4278: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4274: , p_business_flow_code => 3
4275: , p_transaction_id => l_txn_id_tbl
4276: );
4277:
4278: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4279: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4280: fnd_msg_pub.ADD;
4281: x_status := 'W';
4282:

Line 4295: WHEN fnd_api.g_exc_error THEN

4291: END IF;
4292: END IF; --END IF check INV and PO patch levels
4293: END IF; --END IF check ret status
4294: EXCEPTION
4295: WHEN fnd_api.g_exc_error THEN
4296: x_status := fnd_api.g_ret_sts_error;
4297: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4298: WHEN fnd_api.g_exc_unexpected_error THEN
4299: x_status := fnd_api.g_ret_sts_unexp_error;

Line 4296: x_status := fnd_api.g_ret_sts_error;

4292: END IF; --END IF check INV and PO patch levels
4293: END IF; --END IF check ret status
4294: EXCEPTION
4295: WHEN fnd_api.g_exc_error THEN
4296: x_status := fnd_api.g_ret_sts_error;
4297: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4298: WHEN fnd_api.g_exc_unexpected_error THEN
4299: x_status := fnd_api.g_ret_sts_unexp_error;
4300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

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

4293: END IF; --END IF check ret status
4294: EXCEPTION
4295: WHEN fnd_api.g_exc_error THEN
4296: x_status := fnd_api.g_ret_sts_error;
4297: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4298: WHEN fnd_api.g_exc_unexpected_error THEN
4299: x_status := fnd_api.g_ret_sts_unexp_error;
4300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4301: WHEN OTHERS THEN

Line 4298: WHEN fnd_api.g_exc_unexpected_error THEN

4294: EXCEPTION
4295: WHEN fnd_api.g_exc_error THEN
4296: x_status := fnd_api.g_ret_sts_error;
4297: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4298: WHEN fnd_api.g_exc_unexpected_error THEN
4299: x_status := fnd_api.g_ret_sts_unexp_error;
4300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4301: WHEN OTHERS THEN
4302: x_status := fnd_api.g_ret_sts_unexp_error;

Line 4299: x_status := fnd_api.g_ret_sts_unexp_error;

4295: WHEN fnd_api.g_exc_error THEN
4296: x_status := fnd_api.g_ret_sts_error;
4297: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4298: WHEN fnd_api.g_exc_unexpected_error THEN
4299: x_status := fnd_api.g_ret_sts_unexp_error;
4300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4301: WHEN OTHERS THEN
4302: x_status := fnd_api.g_ret_sts_unexp_error;
4303:

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

4296: x_status := fnd_api.g_ret_sts_error;
4297: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4298: WHEN fnd_api.g_exc_unexpected_error THEN
4299: x_status := fnd_api.g_ret_sts_unexp_error;
4300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4301: WHEN OTHERS THEN
4302: x_status := fnd_api.g_ret_sts_unexp_error;
4303:
4304: IF SQLCODE IS NOT NULL THEN

Line 4302: x_status := fnd_api.g_ret_sts_unexp_error;

4298: WHEN fnd_api.g_exc_unexpected_error THEN
4299: x_status := fnd_api.g_ret_sts_unexp_error;
4300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4301: WHEN OTHERS THEN
4302: x_status := fnd_api.g_ret_sts_unexp_error;
4303:
4304: IF SQLCODE IS NOT NULL THEN
4305: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4306: END IF;

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

4304: IF SQLCODE IS NOT NULL THEN
4305: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4306: END IF;
4307:
4308: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4309: END create_osp_std_rcvtxn_intf_rec;
4310:
4311: PROCEDURE create_std_rcvtxn_intf_rec(
4312: p_organization_id IN NUMBER

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

4334: , p_rcv_act_rjt_qty_type IN NUMBER DEFAULT NULL --BUG 4309432
4335: ) IS
4336: l_progress VARCHAR2(10);
4337: l_msg_count NUMBER;
4338: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4339: l_msg_data VARCHAR2(400);
4340: l_label_status VARCHAR2(500);
4341: l_txn_id_tbl inv_label.transaction_id_rec_type;
4342: l_counter NUMBER := 0;

Line 4355: x_status := fnd_api.g_ret_sts_success;

4351: GROUP BY rti.lpn_id;
4352:
4353: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4354: BEGIN
4355: x_status := fnd_api.g_ret_sts_success;
4356: l_progress := '10';
4357:
4358: IF (l_debug = 1) THEN
4359: print_debug('create_std_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4382: IF x_status <> fnd_api.g_ret_sts_success THEN

4378: , x_return_status => x_status
4379: , x_error_code => x_message
4380: );
4381:
4382: IF x_status <> fnd_api.g_ret_sts_success THEN
4383: RETURN;
4384: END IF;
4385:
4386: l_progress := '30';

Line 4440: IF x_status = fnd_api.g_ret_sts_error THEN

4436: , p_sec_rcvtxn_qty => p_sec_rcvtxn_qty --OPM Convergence
4437: , p_secondary_uom => p_secondary_uom --OPM Convergence
4438: );
4439:
4440: IF x_status = fnd_api.g_ret_sts_error THEN
4441: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4442: fnd_msg_pub.ADD;
4443:
4444: IF (l_debug = 1) THEN

Line 4445: print_debug('create_std_rcvtxn_intf_rec 20.1: create_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4441: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4442: fnd_msg_pub.ADD;
4443:
4444: IF (l_debug = 1) THEN
4445: print_debug('create_std_rcvtxn_intf_rec 20.1: create_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4446: END IF;
4447:
4448: RAISE fnd_api.g_exc_error;
4449: END IF;

Line 4448: RAISE fnd_api.g_exc_error;

4444: IF (l_debug = 1) THEN
4445: print_debug('create_std_rcvtxn_intf_rec 20.1: create_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4446: END IF;
4447:
4448: RAISE fnd_api.g_exc_error;
4449: END IF;
4450:
4451: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4452: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 4451: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4447:
4448: RAISE fnd_api.g_exc_error;
4449: END IF;
4450:
4451: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4452: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4453: fnd_msg_pub.ADD;
4454:
4455: IF (l_debug = 1) THEN

Line 4456: print_debug('create_std_rcvtxn_intf_rec 20.2: create_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4452: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4453: fnd_msg_pub.ADD;
4454:
4455: IF (l_debug = 1) THEN
4456: print_debug('create_std_rcvtxn_intf_rec 20.2: create_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4457: END IF;
4458:
4459: RAISE fnd_api.g_exc_unexpected_error;
4460: END IF;

Line 4459: RAISE fnd_api.g_exc_unexpected_error;

4455: IF (l_debug = 1) THEN
4456: print_debug('create_std_rcvtxn_intf_rec 20.2: create_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4457: END IF;
4458:
4459: RAISE fnd_api.g_exc_unexpected_error;
4460: END IF;
4461: ELSIF p_receipt_num IS NOT NULL THEN
4462: l_progress := '50';
4463:

Line 4490: IF x_status = fnd_api.g_ret_sts_error THEN

4486: , p_secondary_uom => p_secondary_uom --OPM Convergence
4487: , p_inspection_status_code => l_inspection_status_code --Bug 4309432
4488: );
4489:
4490: IF x_status = fnd_api.g_ret_sts_error THEN
4491: IF (l_debug = 1) THEN
4492: print_debug('create_std_rcvtxn_intf_rec 30.1: create_rpt_num_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4493: END IF;
4494:

Line 4492: print_debug('create_std_rcvtxn_intf_rec 30.1: create_rpt_num_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4488: );
4489:
4490: IF x_status = fnd_api.g_ret_sts_error THEN
4491: IF (l_debug = 1) THEN
4492: print_debug('create_std_rcvtxn_intf_rec 30.1: create_rpt_num_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4493: END IF;
4494:
4495: RAISE fnd_api.g_exc_error;
4496: END IF;

Line 4495: RAISE fnd_api.g_exc_error;

4491: IF (l_debug = 1) THEN
4492: print_debug('create_std_rcvtxn_intf_rec 30.1: create_rpt_num_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4493: END IF;
4494:
4495: RAISE fnd_api.g_exc_error;
4496: END IF;
4497:
4498: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4499: IF (l_debug = 1) THEN

Line 4498: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4494:
4495: RAISE fnd_api.g_exc_error;
4496: END IF;
4497:
4498: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4499: IF (l_debug = 1) THEN
4500: print_debug('create_std_rcvtxn_intf_rec 30.2: create_rpt_num_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4501: END IF;
4502:

Line 4500: print_debug('create_std_rcvtxn_intf_rec 30.2: create_rpt_num_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4496: END IF;
4497:
4498: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4499: IF (l_debug = 1) THEN
4500: print_debug('create_std_rcvtxn_intf_rec 30.2: create_rpt_num_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4501: END IF;
4502:
4503: RAISE fnd_api.g_exc_unexpected_error;
4504: END IF;

Line 4503: RAISE fnd_api.g_exc_unexpected_error;

4499: IF (l_debug = 1) THEN
4500: print_debug('create_std_rcvtxn_intf_rec 30.2: create_rpt_num_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4501: END IF;
4502:
4503: RAISE fnd_api.g_exc_unexpected_error;
4504: END IF;
4505: ELSIF p_shipment_header_id IS NOT NULL THEN
4506: l_progress := '60';
4507:

Line 4537: IF x_status = fnd_api.g_ret_sts_error THEN

4533: , p_sec_rcvtxn_qty => p_sec_rcvtxn_qty --OPM Convergence
4534: , p_secondary_uom => p_secondary_uom --OPM Convergence
4535: );
4536:
4537: IF x_status = fnd_api.g_ret_sts_error THEN
4538: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4539: fnd_msg_pub.ADD;
4540:
4541: IF (l_debug = 1) THEN

Line 4542: print_debug('create_std_rcvtxn_intf_rec 40.1: create_int_shp_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4538: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4539: fnd_msg_pub.ADD;
4540:
4541: IF (l_debug = 1) THEN
4542: print_debug('create_std_rcvtxn_intf_rec 40.1: create_int_shp_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4543: END IF;
4544:
4545: RAISE fnd_api.g_exc_error;
4546: END IF;

Line 4545: RAISE fnd_api.g_exc_error;

4541: IF (l_debug = 1) THEN
4542: print_debug('create_std_rcvtxn_intf_rec 40.1: create_int_shp_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4543: END IF;
4544:
4545: RAISE fnd_api.g_exc_error;
4546: END IF;
4547:
4548: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4549: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

Line 4548: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4544:
4545: RAISE fnd_api.g_exc_error;
4546: END IF;
4547:
4548: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4549: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4550: fnd_msg_pub.ADD;
4551:
4552: IF (l_debug = 1) THEN

Line 4553: print_debug('create_std_rcvtxn_intf_rec 40.2: create_int_shp_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4549: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4550: fnd_msg_pub.ADD;
4551:
4552: IF (l_debug = 1) THEN
4553: print_debug('create_std_rcvtxn_intf_rec 40.2: create_int_shp_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4554: END IF;
4555:
4556: RAISE fnd_api.g_exc_unexpected_error;
4557: END IF;

Line 4556: RAISE fnd_api.g_exc_unexpected_error;

4552: IF (l_debug = 1) THEN
4553: print_debug('create_std_rcvtxn_intf_rec 40.2: create_int_shp_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4554: END IF;
4555:
4556: RAISE fnd_api.g_exc_unexpected_error;
4557: END IF;
4558: ELSIF p_oe_order_header_id IS NOT NULL THEN
4559: l_progress := '70';
4560:

Line 4590: IF x_status = fnd_api.g_ret_sts_error THEN

4586: , p_sec_rcvtxn_qty => p_sec_rcvtxn_qty --OPM Convergence
4587: , p_secondary_uom => p_secondary_uom --OPM Convergence
4588: );
4589:
4590: IF x_status = fnd_api.g_ret_sts_error THEN
4591: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4592: fnd_msg_pub.ADD;
4593:
4594: IF (l_debug = 1) THEN

Line 4595: print_debug('create_std_rcvtxn_intf_rec 50.1: create_rma_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4591: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4592: fnd_msg_pub.ADD;
4593:
4594: IF (l_debug = 1) THEN
4595: print_debug('create_std_rcvtxn_intf_rec 50.1: create_rma_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4596: END IF;
4597:
4598: RAISE fnd_api.g_exc_error;
4599: END IF;

Line 4598: RAISE fnd_api.g_exc_error;

4594: IF (l_debug = 1) THEN
4595: print_debug('create_std_rcvtxn_intf_rec 50.1: create_rma_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4596: END IF;
4597:
4598: RAISE fnd_api.g_exc_error;
4599: END IF;
4600:
4601: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4602: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

Line 4601: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4597:
4598: RAISE fnd_api.g_exc_error;
4599: END IF;
4600:
4601: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4602: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4603: fnd_msg_pub.ADD;
4604:
4605: IF (l_debug = 1) THEN

Line 4606: print_debug('create_std_rcvtxn_intf_rec 50.2: create_rma_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4602: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4603: fnd_msg_pub.ADD;
4604:
4605: IF (l_debug = 1) THEN
4606: print_debug('create_std_rcvtxn_intf_rec 50.2: create_rma_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4607: END IF;
4608:
4609: RAISE fnd_api.g_exc_unexpected_error;
4610: END IF;

Line 4609: RAISE fnd_api.g_exc_unexpected_error;

4605: IF (l_debug = 1) THEN
4606: print_debug('create_std_rcvtxn_intf_rec 50.2: create_rma_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4607: END IF;
4608:
4609: RAISE fnd_api.g_exc_unexpected_error;
4610: END IF;
4611: END IF;
4612:
4613: l_progress := '80';

Line 4620: IF x_status <> fnd_api.g_ret_sts_error THEN

4616: print_debug('create_std_rcvtxn_intf_rec exitting: 60' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4617: END IF;
4618:
4619: -- calling label printing API
4620: IF x_status <> fnd_api.g_ret_sts_error THEN
4621: IF (l_debug = 1) THEN
4622: print_debug('create_std_rcpt_intf_rec: 8.1 before inv_label.print_label ', 4);
4623: END IF;
4624:

Line 4651: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4647: , p_business_flow_code => 3
4648: , p_transaction_id => l_txn_id_tbl
4649: );
4650:
4651: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4652: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4653: fnd_msg_pub.ADD;
4654: x_status := 'W';
4655:

Line 4667: WHEN fnd_api.g_exc_error THEN

4663: END IF;
4664: END IF; --END IF check INV and PO patch levels
4665: END IF; --END IF check ret status
4666: EXCEPTION
4667: WHEN fnd_api.g_exc_error THEN
4668: x_status := fnd_api.g_ret_sts_error;
4669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4670: WHEN fnd_api.g_exc_unexpected_error THEN
4671: x_status := fnd_api.g_ret_sts_unexp_error;

Line 4668: x_status := fnd_api.g_ret_sts_error;

4664: END IF; --END IF check INV and PO patch levels
4665: END IF; --END IF check ret status
4666: EXCEPTION
4667: WHEN fnd_api.g_exc_error THEN
4668: x_status := fnd_api.g_ret_sts_error;
4669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4670: WHEN fnd_api.g_exc_unexpected_error THEN
4671: x_status := fnd_api.g_ret_sts_unexp_error;
4672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

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

4665: END IF; --END IF check ret status
4666: EXCEPTION
4667: WHEN fnd_api.g_exc_error THEN
4668: x_status := fnd_api.g_ret_sts_error;
4669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4670: WHEN fnd_api.g_exc_unexpected_error THEN
4671: x_status := fnd_api.g_ret_sts_unexp_error;
4672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4673: WHEN OTHERS THEN

Line 4670: WHEN fnd_api.g_exc_unexpected_error THEN

4666: EXCEPTION
4667: WHEN fnd_api.g_exc_error THEN
4668: x_status := fnd_api.g_ret_sts_error;
4669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4670: WHEN fnd_api.g_exc_unexpected_error THEN
4671: x_status := fnd_api.g_ret_sts_unexp_error;
4672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4673: WHEN OTHERS THEN
4674: x_status := fnd_api.g_ret_sts_unexp_error;

Line 4671: x_status := fnd_api.g_ret_sts_unexp_error;

4667: WHEN fnd_api.g_exc_error THEN
4668: x_status := fnd_api.g_ret_sts_error;
4669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4670: WHEN fnd_api.g_exc_unexpected_error THEN
4671: x_status := fnd_api.g_ret_sts_unexp_error;
4672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4673: WHEN OTHERS THEN
4674: x_status := fnd_api.g_ret_sts_unexp_error;
4675:

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

4668: x_status := fnd_api.g_ret_sts_error;
4669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4670: WHEN fnd_api.g_exc_unexpected_error THEN
4671: x_status := fnd_api.g_ret_sts_unexp_error;
4672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4673: WHEN OTHERS THEN
4674: x_status := fnd_api.g_ret_sts_unexp_error;
4675:
4676: IF SQLCODE IS NOT NULL THEN

Line 4674: x_status := fnd_api.g_ret_sts_unexp_error;

4670: WHEN fnd_api.g_exc_unexpected_error THEN
4671: x_status := fnd_api.g_ret_sts_unexp_error;
4672: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4673: WHEN OTHERS THEN
4674: x_status := fnd_api.g_ret_sts_unexp_error;
4675:
4676: IF SQLCODE IS NOT NULL THEN
4677: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4678: END IF;

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

4676: IF SQLCODE IS NOT NULL THEN
4677: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4678: END IF;
4679:
4680: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4681: END create_std_rcvtxn_intf_rec;
4682:
4683: /* FP-J Lot/Serial Support Enhancement
4684: * Added two new parameters p_transfer_lpn_id and p_lot_number

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

4716: l_shipment_header_id NUMBER;
4717: l_oe_order_header_id NUMBER;
4718: l_rcvtxn_uom VARCHAR2(25);
4719: l_progress VARCHAR2(10);
4720: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4721: l_msg_count NUMBER;
4722: l_msg_data VARCHAR2(400);
4723: l_label_status VARCHAR2(500);
4724: l_txn_id_tbl inv_label.transaction_id_rec_type;

Line 4735: x_return_status := fnd_api.g_ret_sts_success;

4731: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4732:
4733: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4734: BEGIN
4735: x_return_status := fnd_api.g_ret_sts_success;
4736: l_progress := '10';
4737:
4738: IF (l_debug = 1) THEN
4739: print_debug('create_putaway_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4779: RAISE fnd_api.g_exc_error;

4775: IF (l_debug = 1) THEN
4776: print_debug('create_std_rcvtxn_intf_rec 10.1: Error retrieving hr info',1);
4777: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||Sqlerrm,1);
4778: END IF;
4779: RAISE fnd_api.g_exc_error;
4780: END ;
4781: END IF;
4782:
4783: l_progress := '15';

Line 4793: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4789: , x_return_status => x_return_status
4790: , x_error_code => x_msg_data
4791: );
4792:
4793: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4794: IF (l_debug = 1) THEN
4795: print_debug('create_std_rcvtxn_intf_rec 10.2: validate_trx_date returned failure. x_error_code:'||x_msg_data,1);
4796: END IF;
4797: RETURN;

Line 4836: RAISE fnd_api.g_exc_error;

4832: IF (l_debug = 1) THEN
4833: print_debug('create_std_rcvtxn_intf_rec 20: Error retrieving po info.',1);
4834: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||Sqlerrm,1);
4835: END IF;
4836: RAISE fnd_api.g_exc_error;
4837: END;
4838:
4839: l_progress := '30';
4840: create_po_rcvtxn_intf_rec(

Line 4868: IF x_return_status = fnd_api.g_ret_sts_error THEN

4864: , p_lot_number => p_lot_number
4865: , p_parent_txn_id => p_parent_txn_id
4866: );
4867:
4868: IF x_return_status = fnd_api.g_ret_sts_error THEN
4869: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4870: fnd_msg_pub.ADD;
4871:
4872: IF (l_debug = 1) THEN

Line 4873: print_debug('create_std_rcvtxn_intf_rec 20.1: create_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4869: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4870: fnd_msg_pub.ADD;
4871:
4872: IF (l_debug = 1) THEN
4873: print_debug('create_std_rcvtxn_intf_rec 20.1: create_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4874: END IF;
4875:
4876: RAISE fnd_api.g_exc_error;
4877: END IF;

Line 4876: RAISE fnd_api.g_exc_error;

4872: IF (l_debug = 1) THEN
4873: print_debug('create_std_rcvtxn_intf_rec 20.1: create_po_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4874: END IF;
4875:
4876: RAISE fnd_api.g_exc_error;
4877: END IF;
4878:
4879: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4880: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 4879: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4875:
4876: RAISE fnd_api.g_exc_error;
4877: END IF;
4878:
4879: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4880: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4881: fnd_msg_pub.ADD;
4882:
4883: IF (l_debug = 1) THEN

Line 4884: print_debug('create_std_rcvtxn_intf_rec 20.2: create_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4880: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4881: fnd_msg_pub.ADD;
4882:
4883: IF (l_debug = 1) THEN
4884: print_debug('create_std_rcvtxn_intf_rec 20.2: create_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4885: END IF;
4886:
4887: RAISE fnd_api.g_exc_unexpected_error;
4888: END IF;

Line 4887: RAISE fnd_api.g_exc_unexpected_error;

4883: IF (l_debug = 1) THEN
4884: print_debug('create_std_rcvtxn_intf_rec 20.2: create_po_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4885: END IF;
4886:
4887: RAISE fnd_api.g_exc_unexpected_error;
4888: END IF;
4889: ELSIF p_reference = 'SHIPMENT_LINE_ID' THEN
4890: l_progress := '40';
4891:

Line 4924: IF x_return_status = fnd_api.g_ret_sts_error THEN

4920: , p_lot_number => p_lot_number
4921: , p_parent_txn_id => p_parent_txn_id
4922: );
4923:
4924: IF x_return_status = fnd_api.g_ret_sts_error THEN
4925: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4926: fnd_msg_pub.ADD;
4927:
4928: IF (l_debug = 1) THEN

Line 4929: print_debug('create_std_rcvtxn_intf_rec 30.1: create_int_shp_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4925: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4926: fnd_msg_pub.ADD;
4927:
4928: IF (l_debug = 1) THEN
4929: print_debug('create_std_rcvtxn_intf_rec 30.1: create_int_shp_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4930: END IF;
4931:
4932: RAISE fnd_api.g_exc_error;
4933: END IF;

Line 4932: RAISE fnd_api.g_exc_error;

4928: IF (l_debug = 1) THEN
4929: print_debug('create_std_rcvtxn_intf_rec 30.1: create_int_shp_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4930: END IF;
4931:
4932: RAISE fnd_api.g_exc_error;
4933: END IF;
4934:
4935: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4936: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

Line 4935: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4931:
4932: RAISE fnd_api.g_exc_error;
4933: END IF;
4934:
4935: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4936: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4937: fnd_msg_pub.ADD;
4938:
4939: IF (l_debug = 1) THEN

Line 4940: print_debug('create_std_rcvtxn_intf_rec 30.2: create_int_shp_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4936: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4937: fnd_msg_pub.ADD;
4938:
4939: IF (l_debug = 1) THEN
4940: print_debug('create_std_rcvtxn_intf_rec 30.2: create_int_shp_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4941: END IF;
4942:
4943: RAISE fnd_api.g_exc_unexpected_error;
4944: END IF;

Line 4943: RAISE fnd_api.g_exc_unexpected_error;

4939: IF (l_debug = 1) THEN
4940: print_debug('create_std_rcvtxn_intf_rec 30.2: create_int_shp_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4941: END IF;
4942:
4943: RAISE fnd_api.g_exc_unexpected_error;
4944: END IF;
4945: ELSIF p_reference = 'ORDER_LINE_ID' THEN
4946: l_progress := '60';
4947:

Line 4980: IF x_return_status = fnd_api.g_ret_sts_error THEN

4976: , p_lot_number => p_lot_number
4977: , p_parent_txn_id => p_parent_txn_id
4978: );
4979:
4980: IF x_return_status = fnd_api.g_ret_sts_error THEN
4981: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4982: fnd_msg_pub.ADD;
4983:
4984: IF (l_debug = 1) THEN

Line 4985: print_debug('create_std_rcvtxn_intf_rec 40.1: create_rma_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4981: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4982: fnd_msg_pub.ADD;
4983:
4984: IF (l_debug = 1) THEN
4985: print_debug('create_std_rcvtxn_intf_rec 40.1: create_rma_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4986: END IF;
4987:
4988: RAISE fnd_api.g_exc_error;
4989: END IF;

Line 4988: RAISE fnd_api.g_exc_error;

4984: IF (l_debug = 1) THEN
4985: print_debug('create_std_rcvtxn_intf_rec 40.1: create_rma_rcvtxn_intf_rec RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4986: END IF;
4987:
4988: RAISE fnd_api.g_exc_error;
4989: END IF;
4990:
4991: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4992: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

Line 4991: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4987:
4988: RAISE fnd_api.g_exc_error;
4989: END IF;
4990:
4991: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4992: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4993: fnd_msg_pub.ADD;
4994:
4995: IF (l_debug = 1) THEN

Line 4996: print_debug('create_std_rcvtxn_intf_rec 40.2: create_rma_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4992: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4993: fnd_msg_pub.ADD;
4994:
4995: IF (l_debug = 1) THEN
4996: print_debug('create_std_rcvtxn_intf_rec 40.2: create_rma_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4997: END IF;
4998:
4999: RAISE fnd_api.g_exc_unexpected_error;
5000: END IF;

Line 4999: RAISE fnd_api.g_exc_unexpected_error;

4995: IF (l_debug = 1) THEN
4996: print_debug('create_std_rcvtxn_intf_rec 40.2: create_rma_rcvtxn_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4997: END IF;
4998:
4999: RAISE fnd_api.g_exc_unexpected_error;
5000: END IF;
5001: END IF;
5002:
5003: l_progress := '80';

Line 5009: IF x_return_status <> fnd_api.g_ret_sts_error THEN

5005: IF (l_debug = 1) THEN
5006: print_debug('create_rma_rcvtxn_intf_rec exitting: 90' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5007: END IF;
5008:
5009: IF x_return_status <> fnd_api.g_ret_sts_error THEN
5010: IF (l_debug = 1) THEN
5011: print_debug('create_std_rcpt_intf_rec: 8.1 before inv_label.print_label ', 4);
5012: END IF;
5013:

Line 5045: IF l_return_status <> fnd_api.g_ret_sts_success THEN

5041: , p_transaction_id => l_txn_id_tbl
5042: );
5043:
5044: /* End of Change */
5045: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5046: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
5047: fnd_msg_pub.ADD;
5048: x_return_status := 'W';
5049: IF (l_debug = 1) THEN

Line 5060: WHEN fnd_api.g_exc_error THEN

5056: END IF;
5057: END IF; --END IF check INV and PO patch levels
5058: END IF; --END IF check ret status
5059: EXCEPTION
5060: WHEN fnd_api.g_exc_error THEN
5061: x_return_status := fnd_api.g_ret_sts_error;
5062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5063: IF (l_debug = 1) THEN
5064: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);

Line 5061: x_return_status := fnd_api.g_ret_sts_error;

5057: END IF; --END IF check INV and PO patch levels
5058: END IF; --END IF check ret status
5059: EXCEPTION
5060: WHEN fnd_api.g_exc_error THEN
5061: x_return_status := fnd_api.g_ret_sts_error;
5062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5063: IF (l_debug = 1) THEN
5064: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5065: END IF;

Line 5062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5058: END IF; --END IF check ret status
5059: EXCEPTION
5060: WHEN fnd_api.g_exc_error THEN
5061: x_return_status := fnd_api.g_ret_sts_error;
5062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5063: IF (l_debug = 1) THEN
5064: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5065: END IF;
5066: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5066: WHEN fnd_api.g_exc_unexpected_error THEN

5062: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5063: IF (l_debug = 1) THEN
5064: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5065: END IF;
5066: WHEN fnd_api.g_exc_unexpected_error THEN
5067: x_return_status := fnd_api.g_ret_sts_unexp_error;
5068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5069: IF (l_debug = 1) THEN
5070: print_debug('create_std_rcpt_intf_rec: g_exc_unexpected_error thrown at progress '||l_progress,4);

Line 5067: x_return_status := fnd_api.g_ret_sts_unexp_error;

5063: IF (l_debug = 1) THEN
5064: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5065: END IF;
5066: WHEN fnd_api.g_exc_unexpected_error THEN
5067: x_return_status := fnd_api.g_ret_sts_unexp_error;
5068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5069: IF (l_debug = 1) THEN
5070: print_debug('create_std_rcpt_intf_rec: g_exc_unexpected_error thrown at progress '||l_progress,4);
5071: END IF;

Line 5068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5064: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5065: END IF;
5066: WHEN fnd_api.g_exc_unexpected_error THEN
5067: x_return_status := fnd_api.g_ret_sts_unexp_error;
5068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5069: IF (l_debug = 1) THEN
5070: print_debug('create_std_rcpt_intf_rec: g_exc_unexpected_error thrown at progress '||l_progress,4);
5071: END IF;
5072: WHEN OTHERS THEN

Line 5073: x_return_status := fnd_api.g_ret_sts_unexp_error;

5069: IF (l_debug = 1) THEN
5070: print_debug('create_std_rcpt_intf_rec: g_exc_unexpected_error thrown at progress '||l_progress,4);
5071: END IF;
5072: WHEN OTHERS THEN
5073: x_return_status := fnd_api.g_ret_sts_unexp_error;
5074: IF (l_debug = 1) THEN
5075: print_debug('create_std_rcpt_intf_rec: others exception thrown at progress '||l_progress,4);
5076: END IF;
5077:

Line 5082: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5078: IF SQLCODE IS NOT NULL THEN
5079: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
5080: END IF;
5081:
5082: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5083: END create_putaway_rcvtxn_intf_rec;
5084:
5085: PROCEDURE rcvtxn_clear_global IS
5086: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 5104: x_return_status := fnd_api.g_ret_sts_success;

5100: l_progress VARCHAR2(10);
5101: l_serial_number VARCHAR2(30);
5102: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5103: BEGIN
5104: x_return_status := fnd_api.g_ret_sts_success;
5105:
5106: IF (l_debug = 1) THEN
5107: print_debug('Enter update_rcv_serials_supply 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5108: END IF;

Line 5149: x_return_status := fnd_api.g_ret_sts_unexp_error;

5145: print_debug('Complete update_rcv_serials_supply 40' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5146: END IF;
5147: EXCEPTION
5148: WHEN OTHERS THEN
5149: x_return_status := fnd_api.g_ret_sts_unexp_error;
5150:
5151: IF SQLCODE IS NOT NULL THEN
5152: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.update_rcv_serials_supply', l_progress, SQLCODE);
5153: END IF;

Line 5155: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

5151: IF SQLCODE IS NOT NULL THEN
5152: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.update_rcv_serials_supply', l_progress, SQLCODE);
5153: END IF;
5154:
5155: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5156:
5157: IF (l_debug = 1) THEN
5158: print_debug('Exception in update_rcv_serials_supply 50' || SQLCODE || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5159: END IF;

Line 5230: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5226: ,x_msg_data => l_msg_data
5227: ,p_sec_qty => p_secondary_quantity
5228: );
5229:
5230: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5231: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
5232: IF (l_debug = 1) THEN
5233: print_debug('insert_mtli_helper: Error occurred while creating interface lots: ' || l_msg_data,1);
5234: END IF;

Line 5296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5292: , p_product_code => l_prod_code
5293: , p_att_exist => l_yes
5294: , p_update_msn => l_no);
5295:
5296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5297: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
5298: IF (l_debug = 1) THEN
5299: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
5300: END IF;

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

5460: l_result Boolean;
5461: l_reference VARCHAR2(240);
5462: l_reference_type_code NUMBER;
5463: l_reference_id NUMBER;
5464: l_return_status VARCHAR2(1):= fnd_api.g_ret_sts_success;
5465: l_msg_count NUMBER;
5466: l_msg_data VARCHAR2(4000);
5467: l_matched_index NUMBER;
5468: l_ser_txn_temp_id NUMBER;

Line 5511: x_return_status := fnd_api.g_ret_sts_success;

5507: BEGIN
5508:
5509: SAVEPOINT create_rti_ss;
5510:
5511: x_return_status := fnd_api.g_ret_sts_success;
5512:
5513: IF (l_debug = 1) THEN
5514: print_debug('Enter Match_putaway_rcvtxn_intf_rec ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5515: END IF;

Line 5760: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

5756: print_debug('Returned from split_mmtt',1);
5757: print_debug('x_return_status: '||l_return_status,1);
5758: END IF;
5759:
5760: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
5761: IF (l_debug = 1) THEN
5762: print_debug('x_msg_data: '||l_msg_data,1);
5763: print_debug('x_msg_count: '||l_msg_count,1);
5764: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);

Line 5768: RAISE fnd_api.g_exc_unexpected_error;

5764: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);
5765: print_debug('Raising Exception!!!',1);
5766: END IF;
5767: l_progress := '@@@';
5768: RAISE fnd_api.g_exc_unexpected_error;
5769: END IF;
5770: END IF;
5771:
5772: IF (p_lot_control_code = 2) THEN

Line 5795: , p_init_msg_lst => FND_API.G_FALSE

5791: END IF;
5792:
5793: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial
5794: (p_api_version => 1.0
5795: , p_init_msg_lst => FND_API.G_FALSE
5796: , x_return_status => l_return_status
5797: , x_msg_count => l_msg_count
5798: , x_msg_data => l_msg_data
5799: , p_new_rti_info => l_new_rti_info);

Line 5805: RAISE FND_API.G_EXC_ERROR;

5801: IF ( NOT l_split_lot_serial_ok) THEN
5802: IF (l_debug = 1) THEN
5803: print_debug(' MATCH_PUTAWAY_RCVTXN_INTF_REC: Failure in split_lot_serial ', 4);
5804: END IF;
5805: RAISE FND_API.G_EXC_ERROR;
5806: END IF;
5807: END IF;
5808: ELSE
5809: l_qty_to_insert := inv_convert.inv_um_convert(

Line 5860: RAISE fnd_api.g_exc_error;

5856: print_debug('REFERENCE INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
5857: END IF;
5858: fnd_message.set_name('INV', 'INV_FAILED');
5859: fnd_msg_pub.ADD;
5860: RAISE fnd_api.g_exc_error;
5861: END IF;
5862:
5863: IF (l_debug = 1) THEN
5864: print_debug('REFERENCE = '||L_REFERENCE , 1);

Line 5921: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

5917: IF (l_debug = 1) THEN
5918: print_debug('AFTER CALLING THE DELIVERY API: STATUS = '|| l_return_status, 1);
5919: END IF;
5920:
5921: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5922: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5923: fnd_msg_pub.ADD;
5924: RAISE fnd_api.g_exc_unexpected_error;
5925: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 5924: RAISE fnd_api.g_exc_unexpected_error;

5920:
5921: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5922: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5923: fnd_msg_pub.ADD;
5924: RAISE fnd_api.g_exc_unexpected_error;
5925: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5926: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5927: fnd_msg_pub.ADD;
5928: RAISE fnd_api.g_exc_error;

Line 5925: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

5921: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5922: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5923: fnd_msg_pub.ADD;
5924: RAISE fnd_api.g_exc_unexpected_error;
5925: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5926: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5927: fnd_msg_pub.ADD;
5928: RAISE fnd_api.g_exc_error;
5929: END IF;

Line 5928: RAISE fnd_api.g_exc_error;

5924: RAISE fnd_api.g_exc_unexpected_error;
5925: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5926: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5927: fnd_msg_pub.ADD;
5928: RAISE fnd_api.g_exc_error;
5929: END IF;
5930:
5931: <>
5932: NULL;

Line 5950: RAISE FND_API.g_exc_error;

5946:
5947: -- Unable to match RS with quantity.
5948: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5949: fnd_msg_pub.ADD;
5950: RAISE FND_API.g_exc_error;
5951:
5952: END IF;
5953:
5954: --Bug 5331779-Begin Change

Line 6049: RAISE fnd_api.g_exc_error;

6045: print_debug('REF INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
6046: END IF;
6047: fnd_message.set_name('INV', 'INV_FAILED');
6048: fnd_msg_pub.ADD;
6049: RAISE fnd_api.g_exc_error;
6050: END IF;
6051:
6052: IF (l_debug = 1) THEN
6053: print_debug('REFERENCE = ' ||l_rti_tb(l_txn_id)(l_lot_num).reference , 1);

Line 6073: RAISE fnd_api.g_exc_unexpected_error;

6069: IF NOT l_result THEN
6070: IF (l_debug = 1) THEN
6071: print_debug('Failure while Inserting MSNI records - lot and serial controlled item',1);
6072: END IF;
6073: RAISE fnd_api.g_exc_unexpected_error;
6074: END IF; -- END IF check l_result
6075:
6076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6077: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

Line 6076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6072: END IF;
6073: RAISE fnd_api.g_exc_unexpected_error;
6074: END IF; -- END IF check l_result
6075:
6076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6077: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
6078: IF (l_debug = 1) THEN
6079: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
6080: END IF;

Line 6081: RAISE fnd_api.g_exc_error;

6077: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
6078: IF (l_debug = 1) THEN
6079: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
6080: END IF;
6081: RAISE fnd_api.g_exc_error;
6082: END IF;
6083:
6084: END LOOP; -- End of serial cursor Loop here
6085:

Line 6173: RAISE fnd_api.g_exc_error;

6169: print_debug('Avaiable Qty is less than Txn Qty ' , 1);
6170: END IF;
6171: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6172: fnd_msg_pub.ADD;
6173: RAISE fnd_api.g_exc_error;
6174: END IF;
6175:
6176: IF (l_rti_tb(k)(l).quantity < l_remaining_prim_qty) THEN
6177: IF (p_original_txn_temp_id IS NOT NULL) THEN

Line 6197: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

6193: print_debug('Returned from split_mmtt',1);
6194: print_debug('x_return_status: '||l_return_status,1);
6195: END IF;
6196:
6197: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
6198: IF (l_debug = 1) THEN
6199: print_debug('x_msg_data: '||l_msg_data,1);
6200: print_debug('x_msg_count: '||l_msg_count,1);
6201: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);

Line 6205: RAISE fnd_api.g_exc_unexpected_error;

6201: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);
6202: print_debug('Raising Exception!!!',1);
6203: END IF;
6204: l_progress := '@@@';
6205: RAISE fnd_api.g_exc_unexpected_error;
6206: END IF;
6207: END IF;
6208:
6209: l_remaining_prim_qty := l_remaining_prim_qty-l_rti_tb(k)(l).quantity;

Line 6266: RAISE fnd_api.g_exc_unexpected_error;

6262: IF NOT l_result THEN
6263: IF (l_debug = 1) THEN
6264: print_debug('Failure while Inserting MTLI records - lot and serial controlled item',1);
6265: END IF;
6266: RAISE fnd_api.g_exc_unexpected_error;
6267: END IF; --END IF check l_result
6268: END IF; --IF P_LOT_NUMBER IS NOT NULL THEN
6269:
6270: -- CALL TO RTI HERE

Line 6323: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

6319: IF (l_debug = 1) THEN
6320: print_debug('AFTER CALLING THE DELIVER API: STATUS = '||l_return_status, 1);
6321: END IF;
6322:
6323: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6324: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6325: fnd_msg_pub.ADD;
6326: RAISE fnd_api.g_exc_unexpected_error;
6327: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 6326: RAISE fnd_api.g_exc_unexpected_error;

6322:
6323: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6324: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6325: fnd_msg_pub.ADD;
6326: RAISE fnd_api.g_exc_unexpected_error;
6327: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6328: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6329: fnd_msg_pub.ADD;
6330: RAISE fnd_api.g_exc_error;

Line 6327: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

6323: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6324: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6325: fnd_msg_pub.ADD;
6326: RAISE fnd_api.g_exc_unexpected_error;
6327: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6328: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6329: fnd_msg_pub.ADD;
6330: RAISE fnd_api.g_exc_error;
6331: END IF;

Line 6330: RAISE fnd_api.g_exc_error;

6326: RAISE fnd_api.g_exc_unexpected_error;
6327: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6328: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6329: fnd_msg_pub.ADD;
6330: RAISE fnd_api.g_exc_error;
6331: END IF;
6332:
6333: l := l_rti_tb(k).next(l);
6334: END LOOP;

Line 6346: WHEN fnd_api.g_exc_error THEN

6342: print_debug('MATCH PUTAWAY RETURNING WITH SUCCESS RETUN STATUS = ' ||x_return_status, 1);
6343: END IF;
6344:
6345: EXCEPTION
6346: WHEN fnd_api.g_exc_error THEN
6347: rollback to create_rti_ss;
6348: x_return_status := fnd_api.g_ret_sts_error;
6349: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6350: IF (l_debug = 1) THEN

Line 6348: x_return_status := fnd_api.g_ret_sts_error;

6344:
6345: EXCEPTION
6346: WHEN fnd_api.g_exc_error THEN
6347: rollback to create_rti_ss;
6348: x_return_status := fnd_api.g_ret_sts_error;
6349: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6350: IF (l_debug = 1) THEN
6351: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6352: END IF;

Line 6349: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6345: EXCEPTION
6346: WHEN fnd_api.g_exc_error THEN
6347: rollback to create_rti_ss;
6348: x_return_status := fnd_api.g_ret_sts_error;
6349: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6350: IF (l_debug = 1) THEN
6351: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6352: END IF;
6353:

Line 6354: WHEN fnd_api.g_exc_unexpected_error THEN

6350: IF (l_debug = 1) THEN
6351: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6352: END IF;
6353:
6354: WHEN fnd_api.g_exc_unexpected_error THEN
6355: rollback to create_rti_ss;
6356: x_return_status := fnd_api.g_ret_sts_unexp_error;
6357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6358: IF (l_debug = 1) THEN

Line 6356: x_return_status := fnd_api.g_ret_sts_unexp_error;

6352: END IF;
6353:
6354: WHEN fnd_api.g_exc_unexpected_error THEN
6355: rollback to create_rti_ss;
6356: x_return_status := fnd_api.g_ret_sts_unexp_error;
6357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6358: IF (l_debug = 1) THEN
6359: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6360: END IF;

Line 6357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6353:
6354: WHEN fnd_api.g_exc_unexpected_error THEN
6355: rollback to create_rti_ss;
6356: x_return_status := fnd_api.g_ret_sts_unexp_error;
6357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6358: IF (l_debug = 1) THEN
6359: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6360: END IF;
6361:

Line 6364: x_return_status := fnd_api.g_ret_sts_unexp_error;

6360: END IF;
6361:
6362: WHEN OTHERS THEN
6363: rollback to create_rti_ss;
6364: x_return_status := fnd_api.g_ret_sts_unexp_error;
6365:
6366: IF SQLCODE IS NOT NULL THEN
6367: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
6368: END IF;

Line 6370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

6366: IF SQLCODE IS NOT NULL THEN
6367: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
6368: END IF;
6369:
6370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6371: END Match_putaway_rcvtxn_intf_rec ;
6372:
6373: END inv_rcv_std_deliver_apis;