APPS.INV_RCV_STD_DELIVER_APIS dependencies on FND_API

Line 1439: RAISE fnd_api.g_exc_error;

1435: print_debug('populate_default_values 141 - trying to do transfer IN storage sub_type : ', 4);
1436: END IF;
1437: fnd_message.set_name('INV', 'INV_INVALID_SUB_TXN_COMBO');
1438: fnd_msg_pub.ADD;
1439: RAISE fnd_api.g_exc_error;
1440: END IF;
1441: END IF;
1442:
1443: -- Call procedure INSERT_INTERFACE_CODE to populate RCV_TRANSACTION_INTERFACE

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

1551: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
1552: -- local variable to store the output of the matching algorithm
1553:
1554: l_msg_count NUMBER;
1555: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1556: l_group_id NUMBER;
1557: l_transaction_type VARCHAR2(20) := 'STD_DELIVER';
1558: l_total_primary_qty NUMBER := 0;
1559: l_err_message VARCHAR2(100);

Line 1674: x_status := fnd_api.g_ret_sts_success;

1670: ORDER BY rt.transaction_date DESC;
1671:
1672: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1673: BEGIN
1674: x_status := fnd_api.g_ret_sts_success;
1675:
1676: IF (l_debug = 1) THEN
1677: print_debug('Entering create_osp_po_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1678: END IF;

Line 1749: IF x_status <> fnd_api.g_ret_sts_success THEN

1745: , p_lpn_id => NULL
1746: );
1747:
1748: -- x_status is not successful if there is any execution error in matching.
1749: IF x_status <> fnd_api.g_ret_sts_success THEN
1750: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1751: fnd_msg_pub.ADD;
1752:
1753: IF (l_debug = 1) THEN

Line 1761: x_status := fnd_api.g_ret_sts_error;

1757: RETURN;
1758: END IF;
1759:
1760: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
1761: x_status := fnd_api.g_ret_sts_error;
1762: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
1763: fnd_message.set_name('INV', l_err_message);
1764: fnd_msg_pub.ADD;
1765:

Line 1871: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1867: , x_msg_count => l_msg_count
1868: , x_msg_data => x_message
1869: );
1870:
1871: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1872: x_status := l_return_status;
1873: END IF;
1874:
1875: l_progress := '100';

Line 1882: x_status := fnd_api.g_ret_sts_unexp_error;

1878: print_debug('Exiting create_osp_po_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1879: END IF;
1880: EXCEPTION
1881: WHEN OTHERS THEN
1882: x_status := fnd_api.g_ret_sts_unexp_error;
1883:
1884: IF l_curs_rcvtxn_detail%ISOPEN THEN
1885: CLOSE l_curs_rcvtxn_detail;
1886: END IF;

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

1888: IF SQLCODE IS NOT NULL THEN
1889: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_po_rcvtxn_intf_rec', l_progress, SQLCODE);
1890: END IF;
1891:
1892: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
1893: END create_osp_po_rcvtxn_intf_rec;
1894:
1895: PROCEDURE create_po_rcvtxn_intf_rec(
1896: p_organization_id IN NUMBER

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

1929: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
1930: -- local variable to store the output of the matching algorithm
1931:
1932: l_msg_count NUMBER;
1933: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1934: l_group_id NUMBER;
1935: l_transaction_type VARCHAR2(20) := 'STD_DELIVER';
1936: l_total_primary_qty NUMBER := 0;
1937: l_err_message VARCHAR2(100);

Line 2168: x_status := fnd_api.g_ret_sts_success;

2164: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2165: l_prim_uom_code VARCHAR2(3);
2166: l_rcvtxn_uom_code VARCHAR2(3);
2167: BEGIN
2168: x_status := fnd_api.g_ret_sts_success;
2169:
2170: IF (l_debug = 1) THEN
2171: print_debug('Entering create_po_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2172: print_debug(' p_item_id => '||p_item_id,4);

Line 2284: IF x_status <> fnd_api.g_ret_sts_success THEN

2280: , p_lpn_id => NULL
2281: );
2282:
2283: -- x_status is not successful if there is any execution error in matching.
2284: IF x_status <> fnd_api.g_ret_sts_success THEN
2285: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2286: fnd_msg_pub.ADD;
2287:
2288: IF (l_debug = 1) THEN

Line 2296: x_status := fnd_api.g_ret_sts_error;

2292: RETURN;
2293: END IF;
2294:
2295: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
2296: x_status := fnd_api.g_ret_sts_error;
2297: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
2298: fnd_message.set_name('INV', l_err_message);
2299: fnd_msg_pub.ADD;
2300:

Line 2506: RAISE fnd_api.g_exc_error;

2502: WHEN OTHERS THEN
2503: IF (l_debug = 1) THEN
2504: print_debug('create_po_rcvtxn_intf_rec: Error retrieving MOL id',4);
2505: END IF;
2506: RAISE fnd_api.g_exc_error;
2507: END;
2508: END IF; --IF (l_orig_mol_id IS NULL) THEN
2509:
2510:

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

2527: x_return_status => l_return_status,
2528: x_msg_count => l_msg_count,
2529: x_msg_data => x_message);
2530:
2531: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2532: RAISE fnd_api.g_exc_error;
2533: END IF;
2534: l_progress := '75';
2535:

Line 2532: RAISE fnd_api.g_exc_error;

2528: x_msg_count => l_msg_count,
2529: x_msg_data => x_message);
2530:
2531: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2532: RAISE fnd_api.g_exc_error;
2533: END IF;
2534: l_progress := '75';
2535:
2536: BEGIN

Line 2627: , p_init_msg_lst => FND_API.G_FALSE

2623: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
2624:
2625: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
2626: p_api_version => 1.0
2627: , p_init_msg_lst => FND_API.G_FALSE
2628: , x_return_status => l_return_status
2629: , x_msg_count => l_msg_count
2630: , x_msg_data => x_message
2631: , p_new_rti_info => l_new_rti_info);

Line 2636: RAISE FND_API.G_EXC_ERROR;

2632: IF ( NOT l_split_lot_serial_ok) THEN
2633: IF (l_debug = 1) THEN
2634: print_debug('create_po_rcvtxn_intf_rec 67: Failure in split_lot_serial', 4);
2635: END IF;
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;
2638:
2639: IF (l_debug = 1) THEN
2640: print_debug('create_po_rcvtxn_intf_rec 68: Call split_lot_serial is OK', 4);

Line 2656: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2652: , x_msg_count => l_msg_count
2653: , x_msg_data => x_message
2654: );
2655:
2656: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2657: x_status := l_return_status;
2658: END IF;
2659:
2660: l_progress := '100';

Line 2667: x_status := fnd_api.g_ret_sts_unexp_error;

2663: print_debug('Exiting create_po_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2664: END IF;
2665: EXCEPTION
2666: WHEN OTHERS THEN
2667: x_status := fnd_api.g_ret_sts_unexp_error;
2668:
2669: IF l_curs_rcvtxn_detail%ISOPEN THEN
2670: CLOSE l_curs_rcvtxn_detail;
2671: END IF;

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

2673: IF SQLCODE IS NOT NULL THEN
2674: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_po_rcvtxn_intf_rec', l_progress, SQLCODE);
2675: END IF;
2676:
2677: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
2678: END create_po_rcvtxn_intf_rec;
2679:
2680: PROCEDURE create_int_shp_rcvtxn_intf_rec(
2681: p_organization_id IN NUMBER

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

2711: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
2712: -- local variable to store the output of the matching algorithm
2713:
2714: l_msg_count NUMBER;
2715: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2716: l_group_id NUMBER;
2717: l_transaction_type VARCHAR2(20) := 'STD_DELIVER';
2718: l_total_primary_qty NUMBER := 0;
2719: l_asn_type VARCHAR2(25);

Line 2843: x_status := fnd_api.g_ret_sts_success;

2839: l_prim_uom_code VARCHAR2(3);
2840: l_rcvtxn_uom_code VARCHAR2(3);
2841: l_lot_number mtl_transaction_lots_interface.lot_number%TYPE; --Bug 13400589
2842: BEGIN
2843: x_status := fnd_api.g_ret_sts_success;
2844:
2845: IF (l_debug = 1) THEN
2846: print_debug('Entering create_int_shp_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2847: END IF;

Line 3006: IF x_status <> fnd_api.g_ret_sts_success THEN

3002: );
3003:
3004:
3005: -- x_status is not successful if there is any execution error in matching.
3006: IF x_status <> fnd_api.g_ret_sts_success THEN
3007: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3008: fnd_msg_pub.ADD;
3009:
3010: IF (l_debug = 1) THEN

Line 3020: x_status := fnd_api.g_ret_sts_error;

3016:
3017: END IF;
3018:
3019: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
3020: x_status := fnd_api.g_ret_sts_error;
3021: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
3022: fnd_message.set_name('INV', l_err_message);
3023: fnd_msg_pub.ADD;
3024:

Line 3200: RAISE fnd_api.g_exc_error;

3196: WHEN OTHERS THEN
3197: IF (l_debug = 1) THEN
3198: print_debug('create_int_shp_rcvtxn_intf_rec: Error retrieving MOL id',4);
3199: END IF;
3200: RAISE fnd_api.g_exc_error;
3201: END;
3202: END IF; --IF (l_orig_mol_id IS NULL) THEN
3203:
3204: l_mo_splt_tb(1).prim_qty := l_rcv_transaction_rec.primary_quantity;

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

3220: x_return_status => l_return_status,
3221: x_msg_count => l_msg_count,
3222: x_msg_data => x_message);
3223:
3224: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3225: RAISE fnd_api.g_exc_error;
3226: END IF;
3227: l_progress := '75';
3228:

Line 3225: RAISE fnd_api.g_exc_error;

3221: x_msg_count => l_msg_count,
3222: x_msg_data => x_message);
3223:
3224: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3225: RAISE fnd_api.g_exc_error;
3226: END IF;
3227: l_progress := '75';
3228:
3229: BEGIN

Line 3359: , p_init_msg_lst => FND_API.G_FALSE

3355: END IF;--IF (l_rcv_rcpt_rec.serial_number_control_code = 6) THEN
3356:
3357: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3358: p_api_version => 1.0
3359: , p_init_msg_lst => FND_API.G_FALSE
3360: , x_return_status => l_return_status
3361: , x_msg_count => l_msg_count
3362: , x_msg_data => x_message
3363: , p_new_rti_info => l_new_rti_info);

Line 3368: RAISE FND_API.G_EXC_ERROR;

3364: IF ( NOT l_split_lot_serial_ok) THEN
3365: IF (l_debug = 1) THEN
3366: print_debug('create_int_shp_rcvtxn_intf_rec 128: Failure in split_lot_serial', 4);
3367: END IF;
3368: RAISE FND_API.G_EXC_ERROR;
3369: END IF;
3370:
3371: IF (l_debug = 1) THEN
3372: print_debug('create_int_shp_rcvtxn_intf_rec 129: Call split_lot_serial is OK', 4);

Line 3387: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3383: , x_msg_count => l_msg_count
3384: , x_msg_data => x_message
3385: );
3386:
3387: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3388: x_status := l_return_status;
3389: END IF;
3390:
3391: l_progress := '100';

Line 3398: x_status := fnd_api.g_ret_sts_unexp_error;

3394: print_debug('Exiting create_int_shp_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3395: END IF;
3396: EXCEPTION
3397: WHEN OTHERS THEN
3398: x_status := fnd_api.g_ret_sts_unexp_error;
3399:
3400: IF l_curs_rcvtxn_detail%ISOPEN THEN
3401: CLOSE l_curs_rcvtxn_detail;
3402: END IF;

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

3404: IF SQLCODE IS NOT NULL THEN
3405: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_int_shp_rcvtxn_intf_rec', l_progress, SQLCODE);
3406: END IF;
3407:
3408: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3409: END create_int_shp_rcvtxn_intf_rec;
3410:
3411: PROCEDURE create_rma_rcvtxn_intf_rec(
3412: p_organization_id IN NUMBER

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

3442: l_rcvtxn_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type;
3443: -- local variable to store the output of the matching algorithm
3444:
3445: l_msg_count NUMBER;
3446: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3447: l_group_id NUMBER;
3448: l_transaction_type VARCHAR2(20) := 'STD_DELIVER';
3449: l_total_primary_qty NUMBER := 0;
3450: l_asn_type VARCHAR2(25);

Line 3572: x_status := fnd_api.g_ret_sts_success;

3568: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3569: l_prim_uom_code VARCHAR2(3);
3570: l_rcvtxn_uom_code VARCHAR2(3);
3571: BEGIN
3572: x_status := fnd_api.g_ret_sts_success;
3573:
3574: IF (l_debug = 1) THEN
3575: print_debug('Entering create_rma_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3576: END IF;

Line 3672: IF x_status <> fnd_api.g_ret_sts_success THEN

3668: , p_lpn_id => NULL
3669: );
3670:
3671: -- x_status is not successful if there is any execution error in matching.
3672: IF x_status <> fnd_api.g_ret_sts_success THEN
3673: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3674: fnd_msg_pub.ADD;
3675:
3676: IF (l_debug = 1) THEN

Line 3684: x_status := fnd_api.g_ret_sts_error;

3680: RETURN;
3681: END IF;
3682:
3683: IF g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_status = 'E' THEN
3684: x_status := fnd_api.g_ret_sts_error;
3685: l_err_message := g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).error_message;
3686: fnd_message.set_name('INV', l_err_message);
3687: fnd_msg_pub.ADD;
3688:

Line 3841: RAISE fnd_api.g_exc_error;

3837: WHEN OTHERS THEN
3838: IF (l_debug = 1) THEN
3839: print_debug('create_rma_rcvtxn_intf_rec: Error retrieving MOL id',4);
3840: END IF;
3841: RAISE fnd_api.g_exc_error;
3842: END;
3843: END IF; --IF (l_orig_mol_id IS NULL) THEN
3844:
3845: l_mo_splt_tb(1).prim_qty := l_rcv_transaction_rec.primary_quantity;

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

3861: x_return_status => l_return_status,
3862: x_msg_count => l_msg_count,
3863: x_msg_data => x_message);
3864:
3865: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3866: RAISE fnd_api.g_exc_error;
3867: END IF;
3868: l_progress := '75';
3869:

Line 3866: RAISE fnd_api.g_exc_error;

3862: x_msg_count => l_msg_count,
3863: x_msg_data => x_message);
3864:
3865: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3866: RAISE fnd_api.g_exc_error;
3867: END IF;
3868: l_progress := '75';
3869:
3870: BEGIN

Line 3941: , p_init_msg_lst => FND_API.G_FALSE

3937: IF (p_lot_control_code > 1 OR p_serial_control_code > 1) THEN
3938:
3939: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
3940: p_api_version => 1.0
3941: , p_init_msg_lst => FND_API.G_FALSE
3942: , x_return_status => l_return_status
3943: , x_msg_count => l_msg_count
3944: , x_msg_data => x_message
3945: , p_new_rti_info => l_new_rti_info);

Line 3950: RAISE FND_API.G_EXC_ERROR;

3946: IF ( NOT l_split_lot_serial_ok) THEN
3947: IF (l_debug = 1) THEN
3948: print_debug('create_rma_rcvtxn_intf_rec 65: Failure in split_lot_serial', 4);
3949: END IF;
3950: RAISE FND_API.G_EXC_ERROR;
3951: END IF;
3952:
3953: IF (l_debug = 1) THEN
3954: print_debug('create_rma_rcvtxn_intf_rec 66: Call split_lot_serial is OK', 4);

Line 3970: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3966: , x_msg_count => l_msg_count
3967: , x_msg_data => x_message
3968: );
3969:
3970: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3971: x_status := l_return_status;
3972: END IF;
3973:
3974: l_progress := '100';

Line 3981: x_status := fnd_api.g_ret_sts_unexp_error;

3977: print_debug('Exiting create_rma_rcvtxn_intf_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3978: END IF;
3979: EXCEPTION
3980: WHEN OTHERS THEN
3981: x_status := fnd_api.g_ret_sts_unexp_error;
3982:
3983: IF l_curs_rcvtxn_detail%ISOPEN THEN
3984: CLOSE l_curs_rcvtxn_detail;
3985: END IF;

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

3987: IF SQLCODE IS NOT NULL THEN
3988: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rma_rcvtxn_intf_rec', l_progress, SQLCODE);
3989: END IF;
3990:
3991: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3992: END create_rma_rcvtxn_intf_rec;
3993:
3994: PROCEDURE create_rpt_num_rcvtxn_intf_rec(
3995: p_organization_id IN NUMBER

Line 4036: x_status := fnd_api.g_ret_sts_success;

4032:
4033:
4034: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4035: BEGIN
4036: x_status := fnd_api.g_ret_sts_success;
4037: l_progress := '10';
4038:
4039: IF (l_debug = 1) THEN
4040: print_debug('create_rpt_num_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4081: IF x_status = fnd_api.g_ret_sts_error THEN

4077: , p_lot_number => NULL
4078: , p_deliver_to_location_id => p_deliver_to_location_id
4079: );
4080:
4081: IF x_status = fnd_api.g_ret_sts_error THEN
4082: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4083: fnd_msg_pub.ADD;
4084:
4085: IF (l_debug = 1) THEN

Line 4086: 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);

4082: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4083: fnd_msg_pub.ADD;
4084:
4085: IF (l_debug = 1) THEN
4086: 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);
4087: END IF;
4088:
4089: RAISE fnd_api.g_exc_error;
4090: END IF;

Line 4089: RAISE fnd_api.g_exc_error;

4085: IF (l_debug = 1) THEN
4086: 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);
4087: END IF;
4088:
4089: RAISE fnd_api.g_exc_error;
4090: END IF;
4091:
4092: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4093: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 4092: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4088:
4089: RAISE fnd_api.g_exc_error;
4090: END IF;
4091:
4092: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4093: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4094: fnd_msg_pub.ADD;
4095:
4096: IF (l_debug = 1) THEN

Line 4097: 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);

4093: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4094: fnd_msg_pub.ADD;
4095:
4096: IF (l_debug = 1) THEN
4097: 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);
4098: END IF;
4099:
4100: RAISE fnd_api.g_exc_unexpected_error;
4101: END IF;

Line 4100: RAISE fnd_api.g_exc_unexpected_error;

4096: IF (l_debug = 1) THEN
4097: 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);
4098: END IF;
4099:
4100: RAISE fnd_api.g_exc_unexpected_error;
4101: END IF;
4102: ELSIF l_oe_order_header_id IS NOT NULL THEN
4103: l_progress := '40';
4104:

Line 4132: IF x_status = fnd_api.g_ret_sts_error THEN

4128: , p_transfer_lpn_id => NULL
4129: , p_lot_number => NULL
4130: );
4131:
4132: IF x_status = fnd_api.g_ret_sts_error THEN
4133: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4134: fnd_msg_pub.ADD;
4135:
4136: IF (l_debug = 1) THEN

Line 4137: 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);

4133: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4134: fnd_msg_pub.ADD;
4135:
4136: IF (l_debug = 1) THEN
4137: 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);
4138: END IF;
4139:
4140: RAISE fnd_api.g_exc_error;
4141: END IF;

Line 4140: RAISE fnd_api.g_exc_error;

4136: IF (l_debug = 1) THEN
4137: 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);
4138: END IF;
4139:
4140: RAISE fnd_api.g_exc_error;
4141: END IF;
4142:
4143: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4144: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

Line 4143: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4139:
4140: RAISE fnd_api.g_exc_error;
4141: END IF;
4142:
4143: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4144: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4145: fnd_msg_pub.ADD;
4146:
4147: IF (l_debug = 1) THEN

Line 4148: 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);

4144: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4145: fnd_msg_pub.ADD;
4146:
4147: IF (l_debug = 1) THEN
4148: 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);
4149: END IF;
4150:
4151: RAISE fnd_api.g_exc_unexpected_error;
4152: END IF;

Line 4151: RAISE fnd_api.g_exc_unexpected_error;

4147: IF (l_debug = 1) THEN
4148: 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);
4149: END IF;
4150:
4151: RAISE fnd_api.g_exc_unexpected_error;
4152: END IF;
4153: ELSE
4154: l_progress := '50';
4155:

Line 4183: IF x_status = fnd_api.g_ret_sts_error THEN

4179: , p_transfer_lpn_id => NULL
4180: , p_lot_number => NULL
4181: );
4182:
4183: IF x_status = fnd_api.g_ret_sts_error THEN
4184: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4185: fnd_msg_pub.ADD;
4186:
4187: IF (l_debug = 1) THEN

Line 4188: 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);

4184: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4185: fnd_msg_pub.ADD;
4186:
4187: IF (l_debug = 1) THEN
4188: 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);
4189: END IF;
4190:
4191: RAISE fnd_api.g_exc_error;
4192: END IF;

Line 4191: RAISE fnd_api.g_exc_error;

4187: IF (l_debug = 1) THEN
4188: 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);
4189: END IF;
4190:
4191: RAISE fnd_api.g_exc_error;
4192: END IF;
4193:
4194: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4195: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

Line 4194: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4190:
4191: RAISE fnd_api.g_exc_error;
4192: END IF;
4193:
4194: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4195: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4196: fnd_msg_pub.ADD;
4197:
4198: IF (l_debug = 1) THEN

Line 4199: 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);

4195: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4196: fnd_msg_pub.ADD;
4197:
4198: IF (l_debug = 1) THEN
4199: 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);
4200: END IF;
4201:
4202: RAISE fnd_api.g_exc_unexpected_error;
4203: END IF;

Line 4202: RAISE fnd_api.g_exc_unexpected_error;

4198: IF (l_debug = 1) THEN
4199: 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);
4200: END IF;
4201:
4202: RAISE fnd_api.g_exc_unexpected_error;
4203: END IF;
4204: END IF;
4205:
4206: l_progress := '60';

Line 4212: WHEN fnd_api.g_exc_error THEN

4208: IF (l_debug = 1) THEN
4209: print_debug('create_rpt_num_rcvtxn_intf_rec exitting: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4210: END IF;
4211: EXCEPTION
4212: WHEN fnd_api.g_exc_error THEN
4213: x_status := fnd_api.g_ret_sts_error;
4214:
4215: IF l_curs_rcvtxn_detail%ISOPEN THEN
4216: CLOSE l_curs_rcvtxn_detail;

Line 4213: x_status := fnd_api.g_ret_sts_error;

4209: print_debug('create_rpt_num_rcvtxn_intf_rec exitting: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4210: END IF;
4211: EXCEPTION
4212: WHEN fnd_api.g_exc_error THEN
4213: x_status := fnd_api.g_ret_sts_error;
4214:
4215: IF l_curs_rcvtxn_detail%ISOPEN THEN
4216: CLOSE l_curs_rcvtxn_detail;
4217: END IF;

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

4215: IF l_curs_rcvtxn_detail%ISOPEN THEN
4216: CLOSE l_curs_rcvtxn_detail;
4217: END IF;
4218:
4219: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4220: WHEN fnd_api.g_exc_unexpected_error THEN
4221: x_status := fnd_api.g_ret_sts_unexp_error;
4222:
4223: IF l_curs_rcvtxn_detail%ISOPEN THEN

Line 4220: WHEN fnd_api.g_exc_unexpected_error THEN

4216: CLOSE l_curs_rcvtxn_detail;
4217: END IF;
4218:
4219: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4220: WHEN fnd_api.g_exc_unexpected_error THEN
4221: x_status := fnd_api.g_ret_sts_unexp_error;
4222:
4223: IF l_curs_rcvtxn_detail%ISOPEN THEN
4224: CLOSE l_curs_rcvtxn_detail;

Line 4221: x_status := fnd_api.g_ret_sts_unexp_error;

4217: END IF;
4218:
4219: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4220: WHEN fnd_api.g_exc_unexpected_error THEN
4221: x_status := fnd_api.g_ret_sts_unexp_error;
4222:
4223: IF l_curs_rcvtxn_detail%ISOPEN THEN
4224: CLOSE l_curs_rcvtxn_detail;
4225: END IF;

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

4223: IF l_curs_rcvtxn_detail%ISOPEN THEN
4224: CLOSE l_curs_rcvtxn_detail;
4225: END IF;
4226:
4227: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4228: WHEN OTHERS THEN
4229: x_status := fnd_api.g_ret_sts_unexp_error;
4230:
4231: IF l_curs_rcvtxn_detail%ISOPEN THEN

Line 4229: x_status := fnd_api.g_ret_sts_unexp_error;

4225: END IF;
4226:
4227: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4228: WHEN OTHERS THEN
4229: x_status := fnd_api.g_ret_sts_unexp_error;
4230:
4231: IF l_curs_rcvtxn_detail%ISOPEN THEN
4232: CLOSE l_curs_rcvtxn_detail;
4233: END IF;

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

4235: IF SQLCODE IS NOT NULL THEN
4236: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_rpt_num_rcvtxn_intf_rec', l_progress, SQLCODE);
4237: END IF;
4238:
4239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4240: END;
4241:
4242: PROCEDURE create_osp_std_rcvtxn_intf_rec(
4243: p_organization_id IN NUMBER

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

4256: , p_secondary_qty IN NUMBER DEFAULT NULL --OPM Convergence
4257: ) IS
4258: l_progress VARCHAR2(10);
4259: l_msg_count NUMBER;
4260: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4261: l_msg_data VARCHAR2(400);
4262: l_label_status VARCHAR2(500);
4263: l_txn_id_tbl inv_label.transaction_id_rec_type;
4264: l_counter NUMBER := 0;

Line 4276: x_status := fnd_api.g_ret_sts_success;

4272: GROUP BY rti.lpn_id;
4273:
4274: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4275: BEGIN
4276: x_status := fnd_api.g_ret_sts_success;
4277: l_progress := '10';
4278:
4279: IF (l_debug = 1) THEN
4280: print_debug('create_osp_std_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4302: IF x_status <> fnd_api.g_ret_sts_success THEN

4298: , x_return_status => x_status
4299: , x_error_code => x_message
4300: );
4301:
4302: IF x_status <> fnd_api.g_ret_sts_success THEN
4303: RETURN;
4304: END IF;
4305:
4306: l_progress := '30';

Line 4333: IF x_status = fnd_api.g_ret_sts_error THEN

4329: , x_message => x_message
4330: , p_inspection_status_code => NULL
4331: );
4332:
4333: IF x_status = fnd_api.g_ret_sts_error THEN
4334: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4335: fnd_msg_pub.ADD;
4336:
4337: IF (l_debug = 1) THEN

Line 4338: 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);

4334: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4335: fnd_msg_pub.ADD;
4336:
4337: IF (l_debug = 1) THEN
4338: 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);
4339: END IF;
4340:
4341: RAISE fnd_api.g_exc_error;
4342: END IF;

Line 4341: RAISE fnd_api.g_exc_error;

4337: IF (l_debug = 1) THEN
4338: 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);
4339: END IF;
4340:
4341: RAISE fnd_api.g_exc_error;
4342: END IF;
4343:
4344: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4345: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 4344: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4340:
4341: RAISE fnd_api.g_exc_error;
4342: END IF;
4343:
4344: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4345: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4346: fnd_msg_pub.ADD;
4347:
4348: IF (l_debug = 1) THEN

Line 4349: 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);

4345: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4346: fnd_msg_pub.ADD;
4347:
4348: IF (l_debug = 1) THEN
4349: 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);
4350: END IF;
4351:
4352: RAISE fnd_api.g_exc_unexpected_error;
4353: END IF;

Line 4352: RAISE fnd_api.g_exc_unexpected_error;

4348: IF (l_debug = 1) THEN
4349: 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);
4350: END IF;
4351:
4352: RAISE fnd_api.g_exc_unexpected_error;
4353: END IF;
4354: END IF;
4355:
4356: l_progress := '80';

Line 4363: IF x_status <> fnd_api.g_ret_sts_error THEN

4359: print_debug('create_osp_std_rcvtxn_intf_rec exitting: 60' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4360: END IF;
4361:
4362: -- calling label printing API
4363: IF x_status <> fnd_api.g_ret_sts_error THEN
4364: IF (l_debug = 1) THEN
4365: print_debug('create_osp_std_rcpt_intf_rec: 8.1 before inv_label.print_label ', 4);
4366: END IF;
4367:

Line 4394: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4390: , p_business_flow_code => 3
4391: , p_transaction_id => l_txn_id_tbl
4392: );
4393:
4394: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4395: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4396: fnd_msg_pub.ADD;
4397: x_status := 'W';
4398:

Line 4411: WHEN fnd_api.g_exc_error THEN

4407: END IF;
4408: END IF; --END IF check INV and PO patch levels
4409: END IF; --END IF check ret status
4410: EXCEPTION
4411: WHEN fnd_api.g_exc_error THEN
4412: x_status := fnd_api.g_ret_sts_error;
4413: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4414: WHEN fnd_api.g_exc_unexpected_error THEN
4415: x_status := fnd_api.g_ret_sts_unexp_error;

Line 4412: x_status := fnd_api.g_ret_sts_error;

4408: END IF; --END IF check INV and PO patch levels
4409: END IF; --END IF check ret status
4410: EXCEPTION
4411: WHEN fnd_api.g_exc_error THEN
4412: x_status := fnd_api.g_ret_sts_error;
4413: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4414: WHEN fnd_api.g_exc_unexpected_error THEN
4415: x_status := fnd_api.g_ret_sts_unexp_error;
4416: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

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

4409: END IF; --END IF check ret status
4410: EXCEPTION
4411: WHEN fnd_api.g_exc_error THEN
4412: x_status := fnd_api.g_ret_sts_error;
4413: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4414: WHEN fnd_api.g_exc_unexpected_error THEN
4415: x_status := fnd_api.g_ret_sts_unexp_error;
4416: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4417: WHEN OTHERS THEN

Line 4414: WHEN fnd_api.g_exc_unexpected_error THEN

4410: EXCEPTION
4411: WHEN fnd_api.g_exc_error THEN
4412: x_status := fnd_api.g_ret_sts_error;
4413: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4414: WHEN fnd_api.g_exc_unexpected_error THEN
4415: x_status := fnd_api.g_ret_sts_unexp_error;
4416: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4417: WHEN OTHERS THEN
4418: x_status := fnd_api.g_ret_sts_unexp_error;

Line 4415: x_status := fnd_api.g_ret_sts_unexp_error;

4411: WHEN fnd_api.g_exc_error THEN
4412: x_status := fnd_api.g_ret_sts_error;
4413: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4414: WHEN fnd_api.g_exc_unexpected_error THEN
4415: x_status := fnd_api.g_ret_sts_unexp_error;
4416: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4417: WHEN OTHERS THEN
4418: x_status := fnd_api.g_ret_sts_unexp_error;
4419:

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

4412: x_status := fnd_api.g_ret_sts_error;
4413: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4414: WHEN fnd_api.g_exc_unexpected_error THEN
4415: x_status := fnd_api.g_ret_sts_unexp_error;
4416: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4417: WHEN OTHERS THEN
4418: x_status := fnd_api.g_ret_sts_unexp_error;
4419:
4420: IF SQLCODE IS NOT NULL THEN

Line 4418: x_status := fnd_api.g_ret_sts_unexp_error;

4414: WHEN fnd_api.g_exc_unexpected_error THEN
4415: x_status := fnd_api.g_ret_sts_unexp_error;
4416: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4417: WHEN OTHERS THEN
4418: x_status := fnd_api.g_ret_sts_unexp_error;
4419:
4420: IF SQLCODE IS NOT NULL THEN
4421: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4422: END IF;

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

4420: IF SQLCODE IS NOT NULL THEN
4421: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_osp_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4422: END IF;
4423:
4424: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4425: END create_osp_std_rcvtxn_intf_rec;
4426:
4427: PROCEDURE create_std_rcvtxn_intf_rec(
4428: p_organization_id IN NUMBER

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

4450: , p_rcv_act_rjt_qty_type IN NUMBER DEFAULT NULL --BUG 4309432
4451: ) IS
4452: l_progress VARCHAR2(10);
4453: l_msg_count NUMBER;
4454: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4455: l_msg_data VARCHAR2(400);
4456: l_label_status VARCHAR2(500);
4457: l_txn_id_tbl inv_label.transaction_id_rec_type;
4458: l_counter NUMBER := 0;

Line 4471: x_status := fnd_api.g_ret_sts_success;

4467: GROUP BY rti.lpn_id;
4468:
4469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4470: BEGIN
4471: x_status := fnd_api.g_ret_sts_success;
4472: l_progress := '10';
4473:
4474: IF (l_debug = 1) THEN
4475: print_debug('create_std_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4498: IF x_status <> fnd_api.g_ret_sts_success THEN

4494: , x_return_status => x_status
4495: , x_error_code => x_message
4496: );
4497:
4498: IF x_status <> fnd_api.g_ret_sts_success THEN
4499: RETURN;
4500: END IF;
4501:
4502: l_progress := '30';

Line 4558: IF x_status = fnd_api.g_ret_sts_error THEN

4554: , p_sec_rcvtxn_qty => p_sec_rcvtxn_qty --OPM Convergence
4555: , p_secondary_uom => p_secondary_uom --OPM Convergence
4556: );
4557:
4558: IF x_status = fnd_api.g_ret_sts_error THEN
4559: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4560: fnd_msg_pub.ADD;
4561:
4562: IF (l_debug = 1) THEN

Line 4563: 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);

4559: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4560: fnd_msg_pub.ADD;
4561:
4562: IF (l_debug = 1) THEN
4563: 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);
4564: END IF;
4565:
4566: RAISE fnd_api.g_exc_error;
4567: END IF;

Line 4566: RAISE fnd_api.g_exc_error;

4562: IF (l_debug = 1) THEN
4563: 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);
4564: END IF;
4565:
4566: RAISE fnd_api.g_exc_error;
4567: END IF;
4568:
4569: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4570: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 4569: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4565:
4566: RAISE fnd_api.g_exc_error;
4567: END IF;
4568:
4569: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4570: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4571: fnd_msg_pub.ADD;
4572:
4573: IF (l_debug = 1) THEN

Line 4574: 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);

4570: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4571: fnd_msg_pub.ADD;
4572:
4573: IF (l_debug = 1) THEN
4574: 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);
4575: END IF;
4576:
4577: RAISE fnd_api.g_exc_unexpected_error;
4578: END IF;

Line 4577: RAISE fnd_api.g_exc_unexpected_error;

4573: IF (l_debug = 1) THEN
4574: 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);
4575: END IF;
4576:
4577: RAISE fnd_api.g_exc_unexpected_error;
4578: END IF;
4579: ELSIF p_receipt_num IS NOT NULL THEN
4580: l_progress := '50';
4581:

Line 4608: IF x_status = fnd_api.g_ret_sts_error THEN

4604: , p_secondary_uom => p_secondary_uom --OPM Convergence
4605: , p_inspection_status_code => l_inspection_status_code --Bug 4309432
4606: );
4607:
4608: IF x_status = fnd_api.g_ret_sts_error THEN
4609: IF (l_debug = 1) THEN
4610: 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);
4611: END IF;
4612:

Line 4610: 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);

4606: );
4607:
4608: IF x_status = fnd_api.g_ret_sts_error THEN
4609: IF (l_debug = 1) THEN
4610: 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);
4611: END IF;
4612:
4613: RAISE fnd_api.g_exc_error;
4614: END IF;

Line 4613: RAISE fnd_api.g_exc_error;

4609: IF (l_debug = 1) THEN
4610: 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);
4611: END IF;
4612:
4613: RAISE fnd_api.g_exc_error;
4614: END IF;
4615:
4616: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4617: IF (l_debug = 1) THEN

Line 4616: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4612:
4613: RAISE fnd_api.g_exc_error;
4614: END IF;
4615:
4616: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4617: IF (l_debug = 1) THEN
4618: 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);
4619: END IF;
4620:

Line 4618: 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);

4614: END IF;
4615:
4616: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4617: IF (l_debug = 1) THEN
4618: 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);
4619: END IF;
4620:
4621: RAISE fnd_api.g_exc_unexpected_error;
4622: END IF;

Line 4621: RAISE fnd_api.g_exc_unexpected_error;

4617: IF (l_debug = 1) THEN
4618: 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);
4619: END IF;
4620:
4621: RAISE fnd_api.g_exc_unexpected_error;
4622: END IF;
4623: ELSIF p_shipment_header_id IS NOT NULL THEN
4624: l_progress := '60';
4625:

Line 4655: IF x_status = fnd_api.g_ret_sts_error THEN

4651: , p_sec_rcvtxn_qty => p_sec_rcvtxn_qty --OPM Convergence
4652: , p_secondary_uom => p_secondary_uom --OPM Convergence
4653: );
4654:
4655: IF x_status = fnd_api.g_ret_sts_error THEN
4656: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4657: fnd_msg_pub.ADD;
4658:
4659: IF (l_debug = 1) THEN

Line 4660: 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);

4656: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4657: fnd_msg_pub.ADD;
4658:
4659: IF (l_debug = 1) THEN
4660: 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);
4661: END IF;
4662:
4663: RAISE fnd_api.g_exc_error;
4664: END IF;

Line 4663: RAISE fnd_api.g_exc_error;

4659: IF (l_debug = 1) THEN
4660: 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);
4661: END IF;
4662:
4663: RAISE fnd_api.g_exc_error;
4664: END IF;
4665:
4666: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4667: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

Line 4666: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4662:
4663: RAISE fnd_api.g_exc_error;
4664: END IF;
4665:
4666: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4667: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4668: fnd_msg_pub.ADD;
4669:
4670: IF (l_debug = 1) THEN

Line 4671: 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);

4667: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
4668: fnd_msg_pub.ADD;
4669:
4670: IF (l_debug = 1) THEN
4671: 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);
4672: END IF;
4673:
4674: RAISE fnd_api.g_exc_unexpected_error;
4675: END IF;

Line 4674: RAISE fnd_api.g_exc_unexpected_error;

4670: IF (l_debug = 1) THEN
4671: 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);
4672: END IF;
4673:
4674: RAISE fnd_api.g_exc_unexpected_error;
4675: END IF;
4676: ELSIF p_oe_order_header_id IS NOT NULL THEN
4677: l_progress := '70';
4678:

Line 4708: IF x_status = fnd_api.g_ret_sts_error THEN

4704: , p_sec_rcvtxn_qty => p_sec_rcvtxn_qty --OPM Convergence
4705: , p_secondary_uom => p_secondary_uom --OPM Convergence
4706: );
4707:
4708: IF x_status = fnd_api.g_ret_sts_error THEN
4709: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4710: fnd_msg_pub.ADD;
4711:
4712: IF (l_debug = 1) THEN

Line 4713: 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);

4709: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4710: fnd_msg_pub.ADD;
4711:
4712: IF (l_debug = 1) THEN
4713: 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);
4714: END IF;
4715:
4716: RAISE fnd_api.g_exc_error;
4717: END IF;

Line 4716: RAISE fnd_api.g_exc_error;

4712: IF (l_debug = 1) THEN
4713: 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);
4714: END IF;
4715:
4716: RAISE fnd_api.g_exc_error;
4717: END IF;
4718:
4719: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4720: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

Line 4719: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

4715:
4716: RAISE fnd_api.g_exc_error;
4717: END IF;
4718:
4719: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
4720: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4721: fnd_msg_pub.ADD;
4722:
4723: IF (l_debug = 1) THEN

Line 4724: 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);

4720: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
4721: fnd_msg_pub.ADD;
4722:
4723: IF (l_debug = 1) THEN
4724: 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);
4725: END IF;
4726:
4727: RAISE fnd_api.g_exc_unexpected_error;
4728: END IF;

Line 4727: RAISE fnd_api.g_exc_unexpected_error;

4723: IF (l_debug = 1) THEN
4724: 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);
4725: END IF;
4726:
4727: RAISE fnd_api.g_exc_unexpected_error;
4728: END IF;
4729: END IF;
4730:
4731: l_progress := '80';

Line 4738: IF x_status <> fnd_api.g_ret_sts_error THEN

4734: print_debug('create_std_rcvtxn_intf_rec exitting: 60' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4735: END IF;
4736:
4737: -- calling label printing API
4738: IF x_status <> fnd_api.g_ret_sts_error THEN
4739: IF (l_debug = 1) THEN
4740: print_debug('create_std_rcpt_intf_rec: 8.1 before inv_label.print_label ', 4);
4741: END IF;
4742:

Line 4769: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4765: , p_business_flow_code => 3
4766: , p_transaction_id => l_txn_id_tbl
4767: );
4768:
4769: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4770: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4771: fnd_msg_pub.ADD;
4772: x_status := 'W';
4773:

Line 4785: WHEN fnd_api.g_exc_error THEN

4781: END IF;
4782: END IF; --END IF check INV and PO patch levels
4783: END IF; --END IF check ret status
4784: EXCEPTION
4785: WHEN fnd_api.g_exc_error THEN
4786: x_status := fnd_api.g_ret_sts_error;
4787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4788: WHEN fnd_api.g_exc_unexpected_error THEN
4789: x_status := fnd_api.g_ret_sts_unexp_error;

Line 4786: x_status := fnd_api.g_ret_sts_error;

4782: END IF; --END IF check INV and PO patch levels
4783: END IF; --END IF check ret status
4784: EXCEPTION
4785: WHEN fnd_api.g_exc_error THEN
4786: x_status := fnd_api.g_ret_sts_error;
4787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4788: WHEN fnd_api.g_exc_unexpected_error THEN
4789: x_status := fnd_api.g_ret_sts_unexp_error;
4790: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);

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

4783: END IF; --END IF check ret status
4784: EXCEPTION
4785: WHEN fnd_api.g_exc_error THEN
4786: x_status := fnd_api.g_ret_sts_error;
4787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4788: WHEN fnd_api.g_exc_unexpected_error THEN
4789: x_status := fnd_api.g_ret_sts_unexp_error;
4790: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4791: WHEN OTHERS THEN

Line 4788: WHEN fnd_api.g_exc_unexpected_error THEN

4784: EXCEPTION
4785: WHEN fnd_api.g_exc_error THEN
4786: x_status := fnd_api.g_ret_sts_error;
4787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4788: WHEN fnd_api.g_exc_unexpected_error THEN
4789: x_status := fnd_api.g_ret_sts_unexp_error;
4790: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4791: WHEN OTHERS THEN
4792: x_status := fnd_api.g_ret_sts_unexp_error;

Line 4789: x_status := fnd_api.g_ret_sts_unexp_error;

4785: WHEN fnd_api.g_exc_error THEN
4786: x_status := fnd_api.g_ret_sts_error;
4787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4788: WHEN fnd_api.g_exc_unexpected_error THEN
4789: x_status := fnd_api.g_ret_sts_unexp_error;
4790: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4791: WHEN OTHERS THEN
4792: x_status := fnd_api.g_ret_sts_unexp_error;
4793:

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

4786: x_status := fnd_api.g_ret_sts_error;
4787: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4788: WHEN fnd_api.g_exc_unexpected_error THEN
4789: x_status := fnd_api.g_ret_sts_unexp_error;
4790: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4791: WHEN OTHERS THEN
4792: x_status := fnd_api.g_ret_sts_unexp_error;
4793:
4794: IF SQLCODE IS NOT NULL THEN

Line 4792: x_status := fnd_api.g_ret_sts_unexp_error;

4788: WHEN fnd_api.g_exc_unexpected_error THEN
4789: x_status := fnd_api.g_ret_sts_unexp_error;
4790: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4791: WHEN OTHERS THEN
4792: x_status := fnd_api.g_ret_sts_unexp_error;
4793:
4794: IF SQLCODE IS NOT NULL THEN
4795: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4796: END IF;

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

4794: IF SQLCODE IS NOT NULL THEN
4795: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
4796: END IF;
4797:
4798: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4799: END create_std_rcvtxn_intf_rec;
4800:
4801: /* FP-J Lot/Serial Support Enhancement
4802: * Added two new parameters p_transfer_lpn_id and p_lot_number

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

4834: l_shipment_header_id NUMBER;
4835: l_oe_order_header_id NUMBER;
4836: l_rcvtxn_uom VARCHAR2(25);
4837: l_progress VARCHAR2(10);
4838: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
4839: l_msg_count NUMBER;
4840: l_msg_data VARCHAR2(400);
4841: l_label_status VARCHAR2(500);
4842: l_txn_id_tbl inv_label.transaction_id_rec_type;

Line 4853: x_return_status := fnd_api.g_ret_sts_success;

4849: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4850:
4851: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4852: BEGIN
4853: x_return_status := fnd_api.g_ret_sts_success;
4854: l_progress := '10';
4855:
4856: IF (l_debug = 1) THEN
4857: print_debug('create_putaway_rcvtxn_intf_rec: 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 4897: RAISE fnd_api.g_exc_error;

4893: IF (l_debug = 1) THEN
4894: print_debug('create_std_rcvtxn_intf_rec 10.1: Error retrieving hr info',1);
4895: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||Sqlerrm,1);
4896: END IF;
4897: RAISE fnd_api.g_exc_error;
4898: END ;
4899: END IF;
4900:
4901: l_progress := '15';

Line 4911: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4907: , x_return_status => x_return_status
4908: , x_error_code => x_msg_data
4909: );
4910:
4911: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4912: IF (l_debug = 1) THEN
4913: print_debug('create_std_rcvtxn_intf_rec 10.2: validate_trx_date returned failure. x_error_code:'||x_msg_data,1);
4914: END IF;
4915: RETURN;

Line 4954: RAISE fnd_api.g_exc_error;

4950: IF (l_debug = 1) THEN
4951: print_debug('create_std_rcvtxn_intf_rec 20: Error retrieving po info.',1);
4952: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||Sqlerrm,1);
4953: END IF;
4954: RAISE fnd_api.g_exc_error;
4955: END;
4956:
4957: l_progress := '30';
4958: create_po_rcvtxn_intf_rec(

Line 4986: IF x_return_status = fnd_api.g_ret_sts_error THEN

4982: , p_lot_number => p_lot_number
4983: , p_parent_txn_id => p_parent_txn_id
4984: );
4985:
4986: IF x_return_status = fnd_api.g_ret_sts_error THEN
4987: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4988: fnd_msg_pub.ADD;
4989:
4990: IF (l_debug = 1) THEN

Line 4991: 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);

4987: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4988: fnd_msg_pub.ADD;
4989:
4990: IF (l_debug = 1) THEN
4991: 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);
4992: END IF;
4993:
4994: RAISE fnd_api.g_exc_error;
4995: END IF;

Line 4994: RAISE fnd_api.g_exc_error;

4990: IF (l_debug = 1) THEN
4991: 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);
4992: END IF;
4993:
4994: RAISE fnd_api.g_exc_error;
4995: END IF;
4996:
4997: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4998: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 4997: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4993:
4994: RAISE fnd_api.g_exc_error;
4995: END IF;
4996:
4997: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4998: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4999: fnd_msg_pub.ADD;
5000:
5001: IF (l_debug = 1) THEN

Line 5002: 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);

4998: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
4999: fnd_msg_pub.ADD;
5000:
5001: IF (l_debug = 1) THEN
5002: 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);
5003: END IF;
5004:
5005: RAISE fnd_api.g_exc_unexpected_error;
5006: END IF;

Line 5005: RAISE fnd_api.g_exc_unexpected_error;

5001: IF (l_debug = 1) THEN
5002: 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);
5003: END IF;
5004:
5005: RAISE fnd_api.g_exc_unexpected_error;
5006: END IF;
5007: ELSIF p_reference = 'SHIPMENT_LINE_ID' THEN
5008: l_progress := '40';
5009:

Line 5044: IF x_return_status = fnd_api.g_ret_sts_error THEN

5040: , p_sec_rcvtxn_qty => p_secondary_quantity -- Bug 13344122
5041: , p_secondary_uom => p_secondary_uom -- Bug 13344122
5042: );
5043:
5044: IF x_return_status = fnd_api.g_ret_sts_error THEN
5045: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5046: fnd_msg_pub.ADD;
5047:
5048: IF (l_debug = 1) THEN

Line 5049: 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);

5045: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5046: fnd_msg_pub.ADD;
5047:
5048: IF (l_debug = 1) THEN
5049: 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);
5050: END IF;
5051:
5052: RAISE fnd_api.g_exc_error;
5053: END IF;

Line 5052: RAISE fnd_api.g_exc_error;

5048: IF (l_debug = 1) THEN
5049: 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);
5050: END IF;
5051:
5052: RAISE fnd_api.g_exc_error;
5053: END IF;
5054:
5055: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5056: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

Line 5055: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5051:
5052: RAISE fnd_api.g_exc_error;
5053: END IF;
5054:
5055: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5056: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5057: fnd_msg_pub.ADD;
5058:
5059: IF (l_debug = 1) THEN

Line 5060: 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);

5056: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5057: fnd_msg_pub.ADD;
5058:
5059: IF (l_debug = 1) THEN
5060: 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);
5061: END IF;
5062:
5063: RAISE fnd_api.g_exc_unexpected_error;
5064: END IF;

Line 5063: RAISE fnd_api.g_exc_unexpected_error;

5059: IF (l_debug = 1) THEN
5060: 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);
5061: END IF;
5062:
5063: RAISE fnd_api.g_exc_unexpected_error;
5064: END IF;
5065: ELSIF p_reference = 'ORDER_LINE_ID' THEN
5066: l_progress := '60';
5067:

Line 5102: IF x_return_status = fnd_api.g_ret_sts_error THEN

5098: , p_sec_rcvtxn_qty => p_secondary_quantity -- Bug 10161177
5099: , p_secondary_uom => p_secondary_uom -- Bug 10161177
5100: );
5101:
5102: IF x_return_status = fnd_api.g_ret_sts_error THEN
5103: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
5104: fnd_msg_pub.ADD;
5105:
5106: IF (l_debug = 1) THEN

Line 5107: 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);

5103: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
5104: fnd_msg_pub.ADD;
5105:
5106: IF (l_debug = 1) THEN
5107: 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);
5108: END IF;
5109:
5110: RAISE fnd_api.g_exc_error;
5111: END IF;

Line 5110: RAISE fnd_api.g_exc_error;

5106: IF (l_debug = 1) THEN
5107: 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);
5108: END IF;
5109:
5110: RAISE fnd_api.g_exc_error;
5111: END IF;
5112:
5113: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5114: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

Line 5113: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

5109:
5110: RAISE fnd_api.g_exc_error;
5111: END IF;
5112:
5113: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5114: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
5115: fnd_msg_pub.ADD;
5116:
5117: IF (l_debug = 1) THEN

Line 5118: 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);

5114: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
5115: fnd_msg_pub.ADD;
5116:
5117: IF (l_debug = 1) THEN
5118: 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);
5119: END IF;
5120:
5121: RAISE fnd_api.g_exc_unexpected_error;
5122: END IF;

Line 5121: RAISE fnd_api.g_exc_unexpected_error;

5117: IF (l_debug = 1) THEN
5118: 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);
5119: END IF;
5120:
5121: RAISE fnd_api.g_exc_unexpected_error;
5122: END IF;
5123: END IF;
5124:
5125: l_progress := '80';

Line 5131: IF x_return_status <> fnd_api.g_ret_sts_error THEN

5127: IF (l_debug = 1) THEN
5128: print_debug('create_rma_rcvtxn_intf_rec exitting: 90' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5129: END IF;
5130:
5131: IF x_return_status <> fnd_api.g_ret_sts_error THEN
5132: IF (l_debug = 1) THEN
5133: print_debug('create_std_rcpt_intf_rec: 8.1 before inv_label.print_label ', 4);
5134: END IF;
5135:

Line 5167: IF l_return_status <> fnd_api.g_ret_sts_success THEN

5163: , p_transaction_id => l_txn_id_tbl
5164: );
5165:
5166: /* End of Change */
5167: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5168: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
5169: fnd_msg_pub.ADD;
5170: x_return_status := 'W';
5171: IF (l_debug = 1) THEN

Line 5182: WHEN fnd_api.g_exc_error THEN

5178: END IF;
5179: END IF; --END IF check INV and PO patch levels
5180: END IF; --END IF check ret status
5181: EXCEPTION
5182: WHEN fnd_api.g_exc_error THEN
5183: x_return_status := fnd_api.g_ret_sts_error;
5184: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5185: IF (l_debug = 1) THEN
5186: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);

Line 5183: x_return_status := fnd_api.g_ret_sts_error;

5179: END IF; --END IF check INV and PO patch levels
5180: END IF; --END IF check ret status
5181: EXCEPTION
5182: WHEN fnd_api.g_exc_error THEN
5183: x_return_status := fnd_api.g_ret_sts_error;
5184: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5185: IF (l_debug = 1) THEN
5186: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5187: END IF;

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

5180: END IF; --END IF check ret status
5181: EXCEPTION
5182: WHEN fnd_api.g_exc_error THEN
5183: x_return_status := fnd_api.g_ret_sts_error;
5184: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5185: IF (l_debug = 1) THEN
5186: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5187: END IF;
5188: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5188: WHEN fnd_api.g_exc_unexpected_error THEN

5184: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5185: IF (l_debug = 1) THEN
5186: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5187: END IF;
5188: WHEN fnd_api.g_exc_unexpected_error THEN
5189: x_return_status := fnd_api.g_ret_sts_unexp_error;
5190: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5191: IF (l_debug = 1) THEN
5192: print_debug('create_std_rcpt_intf_rec: g_exc_unexpected_error thrown at progress '||l_progress,4);

Line 5189: x_return_status := fnd_api.g_ret_sts_unexp_error;

5185: IF (l_debug = 1) THEN
5186: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5187: END IF;
5188: WHEN fnd_api.g_exc_unexpected_error THEN
5189: x_return_status := fnd_api.g_ret_sts_unexp_error;
5190: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5191: IF (l_debug = 1) THEN
5192: print_debug('create_std_rcpt_intf_rec: g_exc_unexpected_error thrown at progress '||l_progress,4);
5193: END IF;

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

5186: print_debug('create_std_rcpt_intf_rec: g_exc_error thrown at progress '||l_progress,4);
5187: END IF;
5188: WHEN fnd_api.g_exc_unexpected_error THEN
5189: x_return_status := fnd_api.g_ret_sts_unexp_error;
5190: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5191: IF (l_debug = 1) THEN
5192: print_debug('create_std_rcpt_intf_rec: g_exc_unexpected_error thrown at progress '||l_progress,4);
5193: END IF;
5194: WHEN OTHERS THEN

Line 5195: x_return_status := fnd_api.g_ret_sts_unexp_error;

5191: IF (l_debug = 1) THEN
5192: print_debug('create_std_rcpt_intf_rec: g_exc_unexpected_error thrown at progress '||l_progress,4);
5193: END IF;
5194: WHEN OTHERS THEN
5195: x_return_status := fnd_api.g_ret_sts_unexp_error;
5196: IF (l_debug = 1) THEN
5197: print_debug('create_std_rcpt_intf_rec: others exception thrown at progress '||l_progress,4);
5198: END IF;
5199:

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

5200: IF SQLCODE IS NOT NULL THEN
5201: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
5202: END IF;
5203:
5204: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5205: END create_putaway_rcvtxn_intf_rec;
5206:
5207: PROCEDURE rcvtxn_clear_global IS
5208: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 5226: x_return_status := fnd_api.g_ret_sts_success;

5222: l_progress VARCHAR2(10);
5223: l_serial_number VARCHAR2(30);
5224: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5225: BEGIN
5226: x_return_status := fnd_api.g_ret_sts_success;
5227:
5228: IF (l_debug = 1) THEN
5229: print_debug('Enter update_rcv_serials_supply 10' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5230: END IF;

Line 5271: x_return_status := fnd_api.g_ret_sts_unexp_error;

5267: print_debug('Complete update_rcv_serials_supply 40' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5268: END IF;
5269: EXCEPTION
5270: WHEN OTHERS THEN
5271: x_return_status := fnd_api.g_ret_sts_unexp_error;
5272:
5273: IF SQLCODE IS NOT NULL THEN
5274: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.update_rcv_serials_supply', l_progress, SQLCODE);
5275: END IF;

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

5273: IF SQLCODE IS NOT NULL THEN
5274: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.update_rcv_serials_supply', l_progress, SQLCODE);
5275: END IF;
5276:
5277: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5278:
5279: IF (l_debug = 1) THEN
5280: print_debug('Exception in update_rcv_serials_supply 50' || SQLCODE || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5281: END IF;

Line 5352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5348: ,x_msg_data => l_msg_data
5349: ,p_sec_qty => p_secondary_quantity
5350: );
5351:
5352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5353: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
5354: IF (l_debug = 1) THEN
5355: print_debug('insert_mtli_helper: Error occurred while creating interface lots: ' || l_msg_data,1);
5356: END IF;

Line 5418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5414: , p_product_code => l_prod_code
5415: , p_att_exist => l_yes
5416: , p_update_msn => l_no);
5417:
5418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5419: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
5420: IF (l_debug = 1) THEN
5421: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
5422: END IF;

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

5591: l_result Boolean;
5592: l_reference VARCHAR2(240);
5593: l_reference_type_code NUMBER;
5594: l_reference_id NUMBER;
5595: l_return_status VARCHAR2(1):= fnd_api.g_ret_sts_success;
5596: l_msg_count NUMBER;
5597: l_msg_data VARCHAR2(4000);
5598: l_matched_index NUMBER;
5599: l_ser_txn_temp_id NUMBER;

Line 5642: x_return_status := fnd_api.g_ret_sts_success;

5638: BEGIN
5639:
5640: SAVEPOINT create_rti_ss;
5641:
5642: x_return_status := fnd_api.g_ret_sts_success;
5643:
5644: IF (l_debug = 1) THEN
5645: print_debug('Enter Match_putaway_rcvtxn_intf_rec ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5646: END IF;

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

5891: print_debug('Returned from split_mmtt',1);
5892: print_debug('x_return_status: '||l_return_status,1);
5893: END IF;
5894:
5895: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
5896: IF (l_debug = 1) THEN
5897: print_debug('x_msg_data: '||l_msg_data,1);
5898: print_debug('x_msg_count: '||l_msg_count,1);
5899: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);

Line 5903: RAISE fnd_api.g_exc_unexpected_error;

5899: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);
5900: print_debug('Raising Exception!!!',1);
5901: END IF;
5902: l_progress := '@@@';
5903: RAISE fnd_api.g_exc_unexpected_error;
5904: END IF;
5905: END IF;
5906:
5907: IF (p_lot_control_code = 2) THEN

Line 5930: , p_init_msg_lst => FND_API.G_FALSE

5926: END IF;
5927:
5928: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial
5929: (p_api_version => 1.0
5930: , p_init_msg_lst => FND_API.G_FALSE
5931: , x_return_status => l_return_status
5932: , x_msg_count => l_msg_count
5933: , x_msg_data => l_msg_data
5934: , p_new_rti_info => l_new_rti_info);

Line 5940: RAISE FND_API.G_EXC_ERROR;

5936: IF ( NOT l_split_lot_serial_ok) THEN
5937: IF (l_debug = 1) THEN
5938: print_debug(' MATCH_PUTAWAY_RCVTXN_INTF_REC: Failure in split_lot_serial ', 4);
5939: END IF;
5940: RAISE FND_API.G_EXC_ERROR;
5941: END IF;
5942: END IF;
5943: ELSE
5944: /*10328780 - This is a redundant conversion

Line 5997: RAISE fnd_api.g_exc_error;

5993: print_debug('REFERENCE INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
5994: END IF;
5995: fnd_message.set_name('INV', 'INV_FAILED');
5996: fnd_msg_pub.ADD;
5997: RAISE fnd_api.g_exc_error;
5998: END IF;
5999:
6000: IF (l_debug = 1) THEN
6001: print_debug('REFERENCE = '||L_REFERENCE , 1);

Line 6060: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

6056: print_debug('AFTER CALLING THE DELIVERY API: p_rcvtxn_uom_code = '|| p_rcvtxn_uom_code, 1);
6057: print_debug('AFTER CALLING THE DELIVERY API: STATUS = '|| l_return_status, 1);
6058: END IF;
6059:
6060: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6061: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
6062: fnd_msg_pub.ADD;
6063: RAISE fnd_api.g_exc_unexpected_error;
6064: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 6063: RAISE fnd_api.g_exc_unexpected_error;

6059:
6060: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6061: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
6062: fnd_msg_pub.ADD;
6063: RAISE fnd_api.g_exc_unexpected_error;
6064: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6065: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
6066: fnd_msg_pub.ADD;
6067: RAISE fnd_api.g_exc_error;

Line 6064: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

6060: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6061: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
6062: fnd_msg_pub.ADD;
6063: RAISE fnd_api.g_exc_unexpected_error;
6064: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6065: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
6066: fnd_msg_pub.ADD;
6067: RAISE fnd_api.g_exc_error;
6068: END IF;

Line 6067: RAISE fnd_api.g_exc_error;

6063: RAISE fnd_api.g_exc_unexpected_error;
6064: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6065: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
6066: fnd_msg_pub.ADD;
6067: RAISE fnd_api.g_exc_error;
6068: END IF;
6069:
6070: <>
6071: NULL;

Line 6093: RAISE FND_API.g_exc_error;

6089:
6090: -- Unable to match RS with quantity.
6091: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
6092: fnd_msg_pub.ADD;
6093: RAISE FND_API.g_exc_error;
6094:
6095: END IF;
6096:
6097: --Bug 5331779-Begin Change

Line 6192: RAISE fnd_api.g_exc_error;

6188: print_debug('REF INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
6189: END IF;
6190: fnd_message.set_name('INV', 'INV_FAILED');
6191: fnd_msg_pub.ADD;
6192: RAISE fnd_api.g_exc_error;
6193: END IF;
6194:
6195: IF (l_debug = 1) THEN
6196: print_debug('REFERENCE = ' ||l_rti_tb(l_txn_id)(l_lot_num).reference , 1);

Line 6216: RAISE fnd_api.g_exc_unexpected_error;

6212: IF NOT l_result THEN
6213: IF (l_debug = 1) THEN
6214: print_debug('Failure while Inserting MSNI records - lot and serial controlled item',1);
6215: END IF;
6216: RAISE fnd_api.g_exc_unexpected_error;
6217: END IF; -- END IF check l_result
6218:
6219: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6220: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

Line 6219: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6215: END IF;
6216: RAISE fnd_api.g_exc_unexpected_error;
6217: END IF; -- END IF check l_result
6218:
6219: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6220: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
6221: IF (l_debug = 1) THEN
6222: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
6223: END IF;

Line 6224: RAISE fnd_api.g_exc_error;

6220: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
6221: IF (l_debug = 1) THEN
6222: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
6223: END IF;
6224: RAISE fnd_api.g_exc_error;
6225: END IF;
6226:
6227: END LOOP; -- End of serial cursor Loop here
6228:

Line 6316: RAISE fnd_api.g_exc_error;

6312: print_debug('Avaiable Qty is less than Txn Qty ' , 1);
6313: END IF;
6314: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6315: fnd_msg_pub.ADD;
6316: RAISE fnd_api.g_exc_error;
6317: END IF;
6318:
6319: IF (l_rti_tb(k)(l).quantity < l_remaining_prim_qty) THEN
6320: IF (p_original_txn_temp_id IS NOT NULL) THEN

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

6336: print_debug('Returned from split_mmtt',1);
6337: print_debug('x_return_status: '||l_return_status,1);
6338: END IF;
6339:
6340: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
6341: IF (l_debug = 1) THEN
6342: print_debug('x_msg_data: '||l_msg_data,1);
6343: print_debug('x_msg_count: '||l_msg_count,1);
6344: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);

Line 6348: RAISE fnd_api.g_exc_unexpected_error;

6344: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,1);
6345: print_debug('Raising Exception!!!',1);
6346: END IF;
6347: l_progress := '@@@';
6348: RAISE fnd_api.g_exc_unexpected_error;
6349: END IF;
6350: END IF;
6351:
6352: l_remaining_prim_qty := l_remaining_prim_qty-l_rti_tb(k)(l).quantity;

Line 6409: RAISE fnd_api.g_exc_unexpected_error;

6405: IF NOT l_result THEN
6406: IF (l_debug = 1) THEN
6407: print_debug('Failure while Inserting MTLI records - lot and serial controlled item',1);
6408: END IF;
6409: RAISE fnd_api.g_exc_unexpected_error;
6410: END IF; --END IF check l_result
6411: END IF; --IF P_LOT_NUMBER IS NOT NULL THEN
6412:
6413: -- CALL TO RTI HERE

Line 6466: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

6462: IF (l_debug = 1) THEN
6463: print_debug('AFTER CALLING THE DELIVER API: STATUS = '||l_return_status, 1);
6464: END IF;
6465:
6466: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6467: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6468: fnd_msg_pub.ADD;
6469: RAISE fnd_api.g_exc_unexpected_error;
6470: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 6469: RAISE fnd_api.g_exc_unexpected_error;

6465:
6466: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6467: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6468: fnd_msg_pub.ADD;
6469: RAISE fnd_api.g_exc_unexpected_error;
6470: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6471: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6472: fnd_msg_pub.ADD;
6473: RAISE fnd_api.g_exc_error;

Line 6470: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

6466: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6467: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6468: fnd_msg_pub.ADD;
6469: RAISE fnd_api.g_exc_unexpected_error;
6470: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6471: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6472: fnd_msg_pub.ADD;
6473: RAISE fnd_api.g_exc_error;
6474: END IF;

Line 6473: RAISE fnd_api.g_exc_error;

6469: RAISE fnd_api.g_exc_unexpected_error;
6470: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6471: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
6472: fnd_msg_pub.ADD;
6473: RAISE fnd_api.g_exc_error;
6474: END IF;
6475:
6476: l := l_rti_tb(k).next(l);
6477: END LOOP;

Line 6489: WHEN fnd_api.g_exc_error THEN

6485: print_debug('MATCH PUTAWAY RETURNING WITH SUCCESS RETUN STATUS = ' ||x_return_status, 1);
6486: END IF;
6487:
6488: EXCEPTION
6489: WHEN fnd_api.g_exc_error THEN
6490: rollback to create_rti_ss;
6491: x_return_status := fnd_api.g_ret_sts_error;
6492: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6493: IF (l_debug = 1) THEN

Line 6491: x_return_status := fnd_api.g_ret_sts_error;

6487:
6488: EXCEPTION
6489: WHEN fnd_api.g_exc_error THEN
6490: rollback to create_rti_ss;
6491: x_return_status := fnd_api.g_ret_sts_error;
6492: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6493: IF (l_debug = 1) THEN
6494: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6495: END IF;

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

6488: EXCEPTION
6489: WHEN fnd_api.g_exc_error THEN
6490: rollback to create_rti_ss;
6491: x_return_status := fnd_api.g_ret_sts_error;
6492: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6493: IF (l_debug = 1) THEN
6494: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6495: END IF;
6496:

Line 6497: WHEN fnd_api.g_exc_unexpected_error THEN

6493: IF (l_debug = 1) THEN
6494: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6495: END IF;
6496:
6497: WHEN fnd_api.g_exc_unexpected_error THEN
6498: rollback to create_rti_ss;
6499: x_return_status := fnd_api.g_ret_sts_unexp_error;
6500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6501: IF (l_debug = 1) THEN

Line 6499: x_return_status := fnd_api.g_ret_sts_unexp_error;

6495: END IF;
6496:
6497: WHEN fnd_api.g_exc_unexpected_error THEN
6498: rollback to create_rti_ss;
6499: x_return_status := fnd_api.g_ret_sts_unexp_error;
6500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6501: IF (l_debug = 1) THEN
6502: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6503: END IF;

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

6496:
6497: WHEN fnd_api.g_exc_unexpected_error THEN
6498: rollback to create_rti_ss;
6499: x_return_status := fnd_api.g_ret_sts_unexp_error;
6500: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6501: IF (l_debug = 1) THEN
6502: print_debug('MATCH PUTAWAY: EXCEPTION OCCURRED AT PROGRESS ' || l_progress, 1);
6503: END IF;
6504:

Line 6507: x_return_status := fnd_api.g_ret_sts_unexp_error;

6503: END IF;
6504:
6505: WHEN OTHERS THEN
6506: rollback to create_rti_ss;
6507: x_return_status := fnd_api.g_ret_sts_unexp_error;
6508:
6509: IF SQLCODE IS NOT NULL THEN
6510: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
6511: END IF;

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

6509: IF SQLCODE IS NOT NULL THEN
6510: inv_mobile_helper_functions.sql_error('INV_rcv_std_deliver_apis.create_std_rcvtxn_intf_rec', l_progress, SQLCODE);
6511: END IF;
6512:
6513: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6514: END Match_putaway_rcvtxn_intf_rec ;
6515:
6516: END inv_rcv_std_deliver_apis;