eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_STD_RCPT_APIS dependencies on FND_MSG_PUB

Line 593: fnd_msg_pub.add;

589:
590: -- Give error message to user that no rate has been found
591: IF l_rate IS NULL THEN
592: fnd_message.set_name('PO', 'PO_CPO_NO_RATE_FOR_DATE');
593: fnd_msg_pub.add;
594: IF (l_debug = 1) THEN
595: print_debug('insert_txn_interface: No Conversion rate has been defined for the currency : ' || l_rcv_transaction_rec.currency_code || ' for the txn date : ' || l_rcv_transaction_rec.currency_conversion_date , 4);
596: END IF;
597: RAISE FND_API.G_EXC_ERROR;

Line 1814: fnd_msg_pub.ADD;

1810: inv_rcv_common_apis.init_startup_values(p_organization_id);
1811: EXCEPTION
1812: WHEN NO_DATA_FOUND THEN
1813: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1814: fnd_msg_pub.ADD;
1815: RAISE fnd_api.g_exc_error;
1816: END;
1817:
1818: l_progress := '30';

Line 1964: fnd_msg_pub.ADD;

1960:
1961: -- x_status is not successful if there is any execution error in matching.
1962: IF l_return_status = fnd_api.g_ret_sts_error THEN
1963: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1964: fnd_msg_pub.ADD;
1965:
1966: IF (l_debug = 1) THEN
1967: print_debug('create_po_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1968: END IF;

Line 1975: fnd_msg_pub.ADD;

1971: END IF;
1972:
1973: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1974: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1975: fnd_msg_pub.ADD;
1976:
1977: IF (l_debug = 1) THEN
1978: print_debug('Exiting create_po_rcpt_intf_rec 60.2: Unexpect error calling matching'
1979: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 1989: fnd_msg_pub.ADD;

1985:
1986: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
1987: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
1988: fnd_message.set_name('INV', l_err_message);
1989: fnd_msg_pub.ADD;
1990:
1991: IF (l_debug = 1) THEN
1992: print_debug('create_po_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1993: END IF;

Line 2028: fnd_msg_pub.ADD;

2024: END LOOP;
2025:
2026: IF l_err_message <> '@@@' THEN
2027: fnd_message.set_name(l_msg_prod, l_err_message);
2028: fnd_msg_pub.ADD;
2029:
2030: IF (l_debug = 1) THEN
2031: print_debug(
2032: 'create_po_rcpt_intf_rec 80: adding tolerance message - l_msg_prod = '

Line 2447: fnd_msg_pub.count_and_get(

2443: IF l_curs_rcpt_detail%ISOPEN THEN
2444: CLOSE l_curs_rcpt_detail;
2445: END IF;
2446:
2447: fnd_msg_pub.count_and_get(
2448: p_encoded => fnd_api.g_false
2449: , p_count => l_msg_count
2450: , p_data => x_message);
2451:

Line 2463: fnd_msg_pub.count_and_get(

2459: IF l_curs_rcpt_detail%ISOPEN THEN
2460: CLOSE l_curs_rcpt_detail;
2461: END IF;
2462:
2463: fnd_msg_pub.count_and_get(
2464: p_encoded => fnd_api.g_false
2465: , p_count => l_msg_count
2466: , p_data => x_message);
2467:

Line 2483: fnd_msg_pub.count_and_get(

2479: IF SQLCODE IS NOT NULL THEN
2480: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_po_rcpt_intf_rec', l_progress, SQLCODE);
2481: END IF;
2482:
2483: fnd_msg_pub.count_and_get(
2484: p_encoded => fnd_api.g_false
2485: , p_count => l_msg_count
2486: , p_data => x_message);
2487:

Line 2789: fnd_msg_pub.ADD;

2785: inv_rcv_common_apis.init_startup_values(p_organization_id);
2786: EXCEPTION
2787: WHEN NO_DATA_FOUND THEN
2788: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2789: fnd_msg_pub.ADD;
2790: RAISE fnd_api.g_exc_error;
2791: END;
2792:
2793: -- default header level non-DB items in rcv_transaction block

Line 2970: fnd_msg_pub.ADD;

2966:
2967: -- x_status is not successful if there is any execution error in matching.
2968: IF l_return_status = fnd_api.g_ret_sts_error THEN
2969: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2970: fnd_msg_pub.ADD;
2971:
2972: IF (l_debug = 1) THEN
2973: print_debug('create_intship_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2974: END IF;

Line 2981: fnd_msg_pub.ADD;

2977: END IF;
2978:
2979: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2980: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2981: fnd_msg_pub.ADD;
2982:
2983: IF (l_debug = 1) THEN
2984: print_debug('create_intship_rcpt_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
2985: , 1);

Line 2994: fnd_msg_pub.ADD;

2990:
2991: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
2992: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
2993: fnd_message.set_name('INV', l_err_message);
2994: fnd_msg_pub.ADD;
2995:
2996: IF (l_debug = 1) THEN
2997: print_debug('create_intship_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2998: END IF;

Line 3029: fnd_msg_pub.ADD;

3025: END LOOP;
3026:
3027: IF l_err_message <> '@@@' THEN
3028: fnd_message.set_name(l_msg_prod, l_err_message);
3029: fnd_msg_pub.ADD;
3030:
3031: IF (l_debug = 1) THEN
3032: print_debug('create_intship_rcpt_intf_rec 80: adding tolerance message ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3033: END IF;

Line 3252: fnd_msg_pub.count_and_get(

3248: IF l_curs_rcpt_detail%ISOPEN THEN
3249: CLOSE l_curs_rcpt_detail;
3250: END IF;
3251:
3252: fnd_msg_pub.count_and_get(
3253: p_encoded => fnd_api.g_false
3254: , p_count => l_msg_count
3255: , p_data => x_message);
3256:

Line 3268: fnd_msg_pub.count_and_get(

3264: IF l_curs_rcpt_detail%ISOPEN THEN
3265: CLOSE l_curs_rcpt_detail;
3266: END IF;
3267:
3268: fnd_msg_pub.count_and_get(
3269: p_encoded => fnd_api.g_false
3270: , p_count => l_msg_count
3271: , p_data => x_message);
3272:

Line 3288: fnd_msg_pub.count_and_get(

3284: IF SQLCODE IS NOT NULL THEN
3285: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_intship_rcpt_intf_rec', l_progress, SQLCODE);
3286: END IF;
3287:
3288: fnd_msg_pub.count_and_get(
3289: p_encoded => fnd_api.g_false
3290: , p_count => l_msg_count
3291: , p_data => x_message);
3292:

Line 3534: fnd_msg_pub.ADD;

3530: inv_rcv_common_apis.init_startup_values(p_organization_id);
3531: EXCEPTION
3532: WHEN NO_DATA_FOUND THEN
3533: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3534: fnd_msg_pub.ADD;
3535: RAISE fnd_api.g_exc_error;
3536: END;
3537:
3538: IF (l_debug = 1) THEN

Line 3611: fnd_msg_pub.ADD;

3607: END IF;
3608:
3609: IF l_return_status = fnd_api.g_ret_sts_error THEN
3610: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3611: fnd_msg_pub.ADD;
3612:
3613: IF (l_debug = 1) THEN
3614: print_debug('create_rma_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3615: END IF;

Line 3622: fnd_msg_pub.ADD;

3618: END IF;
3619:
3620: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3621: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3622: fnd_msg_pub.ADD;
3623:
3624: IF (l_debug = 1) THEN
3625: print_debug('create_rma_rcpt_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3626: END IF;

Line 3634: fnd_msg_pub.ADD;

3630:
3631: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
3632: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
3633: fnd_message.set_name('INV', l_err_message);
3634: fnd_msg_pub.ADD;
3635:
3636: IF (l_debug = 1) THEN
3637: print_debug('create_rma_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3638: END IF;

Line 3669: fnd_msg_pub.ADD;

3665: END LOOP;
3666:
3667: IF l_err_message <> '@@@' THEN
3668: fnd_message.set_name(l_msg_prod, l_err_message);
3669: fnd_msg_pub.ADD;
3670:
3671: IF (l_debug = 1) THEN
3672: print_debug('create_rma_rcpt_intf_rec 80: adding tolerance message ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3673: END IF;

Line 3845: fnd_msg_pub.count_and_get(

3841: IF l_curs_rcpt_detail%ISOPEN THEN
3842: CLOSE l_curs_rcpt_detail;
3843: END IF;
3844:
3845: fnd_msg_pub.count_and_get(
3846: p_encoded => fnd_api.g_false
3847: , p_count => l_msg_count
3848: , p_data => x_message);
3849:

Line 3861: fnd_msg_pub.count_and_get(

3857: IF l_curs_rcpt_detail%ISOPEN THEN
3858: CLOSE l_curs_rcpt_detail;
3859: END IF;
3860:
3861: fnd_msg_pub.count_and_get(
3862: p_encoded => fnd_api.g_false
3863: , p_count => l_msg_count
3864: , p_data => x_message);
3865:

Line 3881: fnd_msg_pub.count_and_get(

3877: IF SQLCODE IS NOT NULL THEN
3878: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_rma_rcpt_intf_rec', l_progress, SQLCODE);
3879: END IF;
3880:
3881: fnd_msg_pub.count_and_get(
3882: p_encoded => fnd_api.g_false
3883: , p_count => l_msg_count
3884: , p_data => x_message);
3885:

Line 4362: fnd_msg_pub.ADD;

4358: inv_rcv_common_apis.init_startup_values(p_organization_id);
4359: EXCEPTION
4360: WHEN NO_DATA_FOUND THEN
4361: fnd_message.set_name('INV', 'INV_RCV_PARAM');
4362: fnd_msg_pub.ADD;
4363: RAISE fnd_api.g_exc_error;
4364: END;
4365:
4366: -- default header level non-DB items in rcv_transaction block

Line 4572: fnd_msg_pub.ADD;

4568: END IF;
4569:
4570: IF l_return_status = fnd_api.g_ret_sts_error THEN
4571: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
4572: fnd_msg_pub.ADD;
4573:
4574: IF (l_debug = 1) THEN
4575: print_debug('create_asn_con_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4576: END IF;

Line 4583: fnd_msg_pub.ADD;

4579: END IF;
4580:
4581: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4582: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
4583: fnd_msg_pub.ADD;
4584:
4585: IF (l_debug = 1) THEN
4586: print_debug('create_asn_con_rcpt_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
4587: , 1);

Line 4596: fnd_msg_pub.ADD;

4592:
4593: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
4594: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
4595: fnd_message.set_name('INV', l_err_message);
4596: fnd_msg_pub.ADD;
4597:
4598: IF (l_debug = 1) THEN
4599: print_debug('create_asn_con_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4600: END IF;

Line 4631: fnd_msg_pub.ADD;

4627: END LOOP;
4628:
4629: IF l_err_message <> '@@@' THEN
4630: fnd_message.set_name(l_msg_prod, l_err_message);
4631: fnd_msg_pub.ADD;
4632:
4633: IF (l_debug = 1) THEN
4634: print_debug('create_asn_con_rcpt_intf_rec 80: adding tolerance message ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4635: END IF;

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

5016: IF l_curs_rcpt_detail%ISOPEN THEN
5017: CLOSE l_curs_rcpt_detail;
5018: END IF;
5019:
5020: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5021:
5022: IF (l_debug = 1) THEN
5023: print_debug('create_asn_con_rcpt_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5024: END IF;

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

5029: IF l_curs_rcpt_detail%ISOPEN THEN
5030: CLOSE l_curs_rcpt_detail;
5031: END IF;
5032:
5033: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5034:
5035: IF (l_debug = 1) THEN
5036: print_debug('create_asn_con_rcpt_intf_rec: fnd_api.g_exc_unexpected_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
5037: END IF;

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

5046: IF SQLCODE IS NOT NULL THEN
5047: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_con_rcpt_intf_rec', l_progress, SQLCODE);
5048: END IF;
5049:
5050: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
5051:
5052: IF (l_debug = 1) THEN
5053: print_debug(
5054: 'create_asn_con_rcpt_intf_rec: Other exception - l_progress = '

Line 5276: fnd_msg_pub.ADD;

5272: );
5273:
5274: IF l_return_status = fnd_api.g_ret_sts_error THEN
5275: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5276: fnd_msg_pub.ADD;
5277:
5278: IF (l_debug = 1) THEN
5279: print_debug(
5280: 'create_asn_exp_rcpt_intf_rec 30.1:create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 5290: fnd_msg_pub.ADD;

5286: END IF;
5287:
5288: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5289: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5290: fnd_msg_pub.ADD;
5291:
5292: IF (l_debug = 1) THEN
5293: print_debug(
5294: 'create_asn_exp_rcpt_intf_rec 30.2: create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 5350: fnd_msg_pub.ADD;

5346:
5347: --Check for failure
5348: IF l_lot_prm_quantity = -99999 THEN
5349: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
5350: fnd_msg_pub.ADD;
5351: IF (l_debug = 1) THEN
5352: print_debug('create_asn_exp_rcpt_intf_rec: 20.2 - txn/primary uom conversion failed', 4);
5353: END IF;
5354: RAISE fnd_api.g_exc_error;

Line 5573: fnd_msg_pub.ADD;

5569: END IF;
5570:
5571: IF l_return_status = fnd_api.g_ret_sts_error THEN
5572: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5573: fnd_msg_pub.ADD;
5574:
5575: IF (l_debug = 1) THEN
5576: print_debug(
5577: 'create_asn_exp_rcpt_intf_rec 40.1:create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 5588: fnd_msg_pub.ADD;

5584: END IF;
5585:
5586: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5587: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5588: fnd_msg_pub.ADD;
5589:
5590: IF (l_debug = 1) THEN
5591: print_debug(
5592: 'create_asn_exp_rcpt_intf_rec 40.2: create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 5657: fnd_msg_pub.ADD;

5653: END IF;
5654: --fnd_message.clear;
5655: --fnd_message.retrieve(l_fnd_msg_out);
5656: fnd_message.set_name('WMS', 'WMS_MISSING_SERIALS_EXP_RCPT');
5657: fnd_msg_pub.ADD;
5658:
5659: IF (l_debug = 1) THEN
5660: print_debug(
5661: 'create_asn_exp_rcpt_intf_rec: 63 : RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 5705: fnd_msg_pub.ADD;

5701: );
5702:
5703: IF l_return_status = fnd_api.g_ret_sts_error THEN
5704: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5705: fnd_msg_pub.ADD;
5706:
5707: IF (l_debug = 1) THEN
5708: print_debug('create_asn_exp_dd_intf_rec 50.2:create_asn_con_dd_intf_rec - RAISE FND_API.G_EXC_ERROR after insert_wlpni;'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
5709: END IF;

Line 5745: fnd_msg_pub.count_and_get(

5741: IF l_curs_serial_number%ISOPEN THEN
5742: CLOSE l_curs_serial_number;
5743: END IF;
5744:
5745: fnd_msg_pub.count_and_get(
5746: p_encoded => fnd_api.g_false
5747: , p_count => l_msg_count
5748: , p_data => x_message);
5749:

Line 5764: fnd_msg_pub.count_and_get(

5760: IF l_curs_serial_number%ISOPEN THEN
5761: CLOSE l_curs_serial_number;
5762: END IF;
5763:
5764: fnd_msg_pub.count_and_get(
5765: p_encoded => fnd_api.g_false
5766: , p_count => l_msg_count
5767: , p_data => x_message);
5768:

Line 5787: fnd_msg_pub.count_and_get(

5783: IF SQLCODE IS NOT NULL THEN
5784: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_exp_rcpt_intf_rec', l_progress, SQLCODE);
5785: END IF;
5786:
5787: fnd_msg_pub.count_and_get(
5788: p_encoded => fnd_api.g_false
5789: , p_count => l_msg_count
5790: , p_data => x_message);
5791:

Line 5971: fnd_msg_pub.ADD;

5967: );
5968:
5969: IF l_return_status = fnd_api.g_ret_sts_error THEN
5970: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
5971: fnd_msg_pub.ADD;
5972:
5973: IF (l_debug = 1) THEN
5974: print_debug(
5975: 'create_std_rcpt_intf_rec 2.1: create_po_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 5986: fnd_msg_pub.ADD;

5982: END IF;
5983:
5984: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5985: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
5986: fnd_msg_pub.ADD;
5987:
5988: IF (l_debug = 1) THEN
5989: print_debug(
5990: 'create_std_rcpt_intf_rec 2.2: create_po_rcpt_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 6053: fnd_msg_pub.ADD;

6049: );
6050:
6051: IF l_return_status = fnd_api.g_ret_sts_error THEN
6052: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6053: fnd_msg_pub.ADD;
6054:
6055: IF (l_debug = 1) THEN
6056: print_debug(
6057: 'create_std_rcpt_intf_rec 3.1: create_intship_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 6068: fnd_msg_pub.ADD;

6064: END IF;
6065:
6066: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6067: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6068: fnd_msg_pub.ADD;
6069:
6070: IF (l_debug = 1) THEN
6071: print_debug(
6072: 'create_std_rcpt_intf_rec 3.2: create_intship_rcpt_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 6133: fnd_msg_pub.ADD;

6129: );
6130:
6131: IF l_return_status = fnd_api.g_ret_sts_error THEN
6132: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
6133: fnd_msg_pub.ADD;
6134:
6135: IF (l_debug = 1) THEN
6136: print_debug(
6137: 'create_std_rcpt_intf_rec 4.1: create_rma_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 6148: fnd_msg_pub.ADD;

6144: END IF;
6145:
6146: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6147: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
6148: fnd_msg_pub.ADD;
6149:
6150: IF (l_debug = 1) THEN
6151: print_debug(
6152: 'create_std_rcpt_intf_rec 4.2: create_rma_rcpt_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 6209: fnd_msg_pub.ADD;

6205: );
6206:
6207: IF l_return_status = fnd_api.g_ret_sts_error THEN
6208: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
6209: fnd_msg_pub.ADD;
6210:
6211: IF (l_debug = 1) THEN
6212: print_debug(
6213: 'create_std_rcpt_intf_rec 5.1: create_asn_exp_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 6224: fnd_msg_pub.ADD;

6220: END IF;
6221:
6222: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6223: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
6224: fnd_msg_pub.ADD;
6225:
6226: IF (l_debug = 1) THEN
6227: print_debug(
6228: 'create_std_rcpt_intf_rec 5.2: create_asn_exp_rcpt_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 6266: fnd_msg_pub.ADD;

6262: );
6263:
6264: IF l_return_status = fnd_api.g_ret_sts_error THEN
6265: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6266: fnd_msg_pub.ADD;
6267:
6268: IF (l_debug = 1) THEN
6269: print_debug(
6270: 'create_std_rcpt_intf_rec 6.1: create_asn_exp_rcpt_intf_rec for IntShip RAISE FND_API.G_EXC_ERROR;'

Line 6281: fnd_msg_pub.ADD;

6277: END IF;
6278:
6279: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6280: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6281: fnd_msg_pub.ADD;
6282:
6283: IF (l_debug = 1) THEN
6284: print_debug(
6285: 'create_std_rcpt_intf_rec 6.2: create_asn_exp_rcpt_intf_rec for IntShip RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 6365: fnd_msg_pub.ADD;

6361: );
6362:
6363: IF l_return_status = fnd_api.g_ret_sts_error THEN
6364: fnd_message.set_name('INV', 'INV_RCV_CRT_ASNCON_RTI_FAIL'); -- MSGTBD
6365: fnd_msg_pub.ADD;
6366:
6367: IF (l_debug = 1) THEN
6368: print_debug(
6369: 'create_std_rcpt_intf_rec 7.1: create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 6380: fnd_msg_pub.ADD;

6376: END IF;
6377:
6378: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6379: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6380: fnd_msg_pub.ADD;
6381:
6382: IF (l_debug = 1) THEN
6383: print_debug(
6384: 'create_std_rcpt_intf_rec 7.2: create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 6449: fnd_msg_pub.ADD;

6445: END IF;
6446:
6447: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6448: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
6449: fnd_msg_pub.ADD;
6450: x_status := 'W';
6451:
6452: IF (l_debug = 1) THEN
6453: print_debug('create_std_rcpt_intf_rec 8.2: inv_label.print_label FAILED;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

Line 6475: fnd_msg_pub.count_and_get(

6471: x_status := fnd_api.g_ret_sts_error;
6472: IF c_rti_txn_id%ISOPEN THEN
6473: CLOSE c_rti_txn_id;
6474: END IF;
6475: fnd_msg_pub.count_and_get(
6476: p_encoded => fnd_api.g_false
6477: , p_count => l_msg_count
6478: , p_data => x_message);
6479: WHEN fnd_api.g_exc_unexpected_error THEN

Line 6484: fnd_msg_pub.count_and_get(

6480: x_status := fnd_api.g_ret_sts_unexp_error;
6481: IF c_rti_txn_id%ISOPEN THEN
6482: CLOSE c_rti_txn_id;
6483: END IF;
6484: fnd_msg_pub.count_and_get(
6485: p_encoded => fnd_api.g_false
6486: , p_count => l_msg_count
6487: , p_data => x_message);
6488: WHEN OTHERS THEN

Line 6496: fnd_msg_pub.count_and_get(

6492: END IF;
6493: IF SQLCODE IS NOT NULL THEN
6494: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_std_rcpt_intf_rec', l_progress, SQLCODE);
6495: END IF;
6496: fnd_msg_pub.count_and_get(
6497: p_encoded => fnd_api.g_false
6498: , p_count => l_msg_count
6499: , p_data => x_message);
6500: END create_std_rcpt_intf_rec;

Line 7203: fnd_msg_pub.count_and_get(

7199: EXCEPTION
7200: WHEN fnd_api.g_exc_error THEN
7201: ROLLBACK TO rcv_crt_mo_sp;
7202: x_status := fnd_api.g_ret_sts_error;
7203: fnd_msg_pub.count_and_get(
7204: p_encoded => fnd_api.g_false
7205: , p_count => l_msg_count
7206: , p_data => x_message);
7207:

Line 7214: fnd_msg_pub.count_and_get(

7210: END IF;
7211: WHEN fnd_api.g_exc_unexpected_error THEN
7212: ROLLBACK TO rcv_crt_mo_sp;
7213: x_status := fnd_api.g_ret_sts_unexp_error;
7214: fnd_msg_pub.count_and_get(
7215: p_encoded => fnd_api.g_false
7216: , p_count => l_msg_count
7217: , p_data => x_message);
7218:

Line 7230: fnd_msg_pub.count_and_get(

7226: IF SQLCODE IS NOT NULL THEN
7227: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_move_order', l_progress, SQLCODE);
7228: END IF;
7229:
7230: fnd_msg_pub.count_and_get(
7231: p_encoded => fnd_api.g_false
7232: , p_count => l_msg_count
7233: , p_data => x_message);
7234:

Line 7290: fnd_msg_pub.ADD;

7286:
7287: IF (l_process_status = 'ERROR') THEN
7288: x_return_status := fnd_api.g_ret_sts_error;
7289: fnd_message.set_name('INV', 'INV_FAILED');
7290: fnd_msg_pub.ADD;
7291: RAISE fnd_api.g_exc_error;
7292: END IF;
7293: EXCEPTION
7294: WHEN NO_DATA_FOUND THEN

Line 7297: fnd_msg_pub.ADD;

7293: EXCEPTION
7294: WHEN NO_DATA_FOUND THEN
7295: x_return_status := fnd_api.g_ret_sts_error;
7296: fnd_message.set_name('INV', 'INV_FAILED');
7297: fnd_msg_pub.ADD;
7298: RAISE fnd_api.g_exc_error;
7299: END;
7300:
7301: IF (l_debug = 1) THEN

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

7334: END IF;
7335: EXCEPTION
7336: WHEN fnd_api.g_exc_error THEN
7337: x_return_status := fnd_api.g_ret_sts_error;
7338: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7339: WHEN fnd_api.g_exc_unexpected_error THEN
7340: x_return_status := fnd_api.g_ret_sts_unexp_error;
7341: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7342: WHEN OTHERS THEN

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

7337: x_return_status := fnd_api.g_ret_sts_error;
7338: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7339: WHEN fnd_api.g_exc_unexpected_error THEN
7340: x_return_status := fnd_api.g_ret_sts_unexp_error;
7341: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7342: WHEN OTHERS THEN
7343: x_return_status := fnd_api.g_ret_sts_unexp_error;
7344:
7345: IF SQLCODE IS NOT NULL THEN

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

7345: IF SQLCODE IS NOT NULL THEN
7346: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_rti_from_header', l_progress, SQLCODE);
7347: END IF;
7348:
7349: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7350: END rcv_update_rti_from_header;
7351:
7352: -- Only called if patchset J or higher from rcv_insert_update_header
7353: -- This is called instead of rcv_insert_header

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

7634: IF (l_debug = 1) THEN
7635: print_debug('INV_RCV_STD_RCPT_APIS.rcv_insert_header_interface 50.1: RAISE FND_API.G_EXC_ERROR;' || l_progress, 4);
7636: END IF;
7637:
7638: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7639: WHEN fnd_api.g_exc_unexpected_error THEN
7640: ROLLBACK TO rcv_insert_ship_header_sp;
7641: x_return_status := fnd_api.g_ret_sts_unexp_error;
7642:

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

7643: IF (l_debug = 1) THEN
7644: print_debug('INV_RCV_STD_RCPT_APIS.rcv_insert_header_interface 50.2: RAISE FND_API.G_EXC_ERROR;' || l_progress, 4);
7645: END IF;
7646:
7647: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7648: WHEN OTHERS THEN
7649: ROLLBACK TO rcv_insert_ship_header_sp;
7650: x_return_status := fnd_api.g_ret_sts_unexp_error;
7651:

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

7652: IF SQLCODE IS NOT NULL THEN
7653: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_insert_header_interface', l_progress, SQLCODE);
7654: END IF;
7655:
7656: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7657: END rcv_insert_header_interface;
7658:
7659: PROCEDURE rcv_update_header_interface(
7660: p_organization_id NUMBER

Line 7797: fnd_msg_pub.ADD;

7793: );
7794:
7795: IF l_return_status = fnd_api.g_ret_sts_error THEN
7796: fnd_message.set_name('INV', 'INV_RCV_UPDATE_RTI_FAIL');
7797: fnd_msg_pub.ADD;
7798:
7799: IF (l_debug = 1) THEN
7800: print_debug(
7801: 'rcv_update_header_interface 30.1: rcv_update_rti_from_header RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 7811: fnd_msg_pub.ADD;

7807: END IF;
7808:
7809: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7810: fnd_message.set_name('INV', 'INV_RCV_UPDATE_RTI_FAIL');
7811: fnd_msg_pub.ADD;
7812:
7813: IF (l_debug = 1) THEN
7814: print_debug(
7815: 'rcv_update_header_interface 30.2: rcv_update_rti_from_header RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

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

7862: WHEN fnd_api.g_exc_error THEN
7863: ROLLBACK TO rcv_update_ship_header_sp;
7864:
7865: x_return_status := fnd_api.g_ret_sts_error;
7866: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7867: WHEN fnd_api.g_exc_unexpected_error THEN
7868: ROLLBACK TO rcv_update_ship_header_sp;
7869:
7870: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

7867: WHEN fnd_api.g_exc_unexpected_error THEN
7868: ROLLBACK TO rcv_update_ship_header_sp;
7869:
7870: x_return_status := fnd_api.g_ret_sts_unexp_error;
7871: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7872: WHEN OTHERS THEN
7873: ROLLBACK TO rcv_update_ship_header_sp;
7874: x_return_status := fnd_api.g_ret_sts_unexp_error;
7875:

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

7876: IF SQLCODE IS NOT NULL THEN
7877: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_header_interface', l_progress, SQLCODE);
7878: END IF;
7879:
7880: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7881: END rcv_update_header_interface;
7882:
7883: PROCEDURE rcv_insert_update_header(
7884: p_organization_id IN NUMBER

Line 8007: fnd_msg_pub.ADD;

8003: END IF;
8004:
8005: IF l_return_status = fnd_api.g_ret_sts_error THEN
8006: fnd_message.set_name('INV', 'INV_RCV_INS_SHIP_HDR_FAIL');
8007: fnd_msg_pub.ADD;
8008:
8009: IF (l_debug = 1) THEN
8010: print_debug(
8011: 'rcv_insert_update_header 20.1: rcv_insert_header RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 8021: fnd_msg_pub.ADD;

8017: END IF;
8018:
8019: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8020: fnd_message.set_name('INV', 'INV_RCV_INS_SHIP_HDR_FAIL');
8021: fnd_msg_pub.ADD;
8022:
8023: IF (l_debug = 1) THEN
8024: print_debug(
8025: 'rcv_insert_update_header 20.2: rcv_insert_header RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 8104: fnd_msg_pub.ADD;

8100: END IF;
8101:
8102: IF l_return_status = fnd_api.g_ret_sts_error THEN
8103: fnd_message.set_name('INV', 'INV_RCV_UPD_SHIP_HDR_FAIL');
8104: fnd_msg_pub.ADD;
8105:
8106: IF (l_debug = 1) THEN
8107: print_debug(
8108: 'rcv_insert_update_header 40.1: rcv_update_header RAISE FND_API.G_EXC_ERROR;' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 8118: fnd_msg_pub.ADD;

8114: END IF;
8115:
8116: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8117: fnd_message.set_name('INV', 'INV_RCV_UPD_SHIP_HDR_FAIL');
8118: fnd_msg_pub.ADD;
8119:
8120: IF (l_debug = 1) THEN
8121: print_debug(
8122: 'rcv_insert_update_header 40.2: rcv_update_header RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

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

8135: END IF;
8136: EXCEPTION
8137: WHEN fnd_api.g_exc_error THEN
8138: x_return_status := fnd_api.g_ret_sts_error;
8139: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8140: WHEN fnd_api.g_exc_unexpected_error THEN
8141: x_return_status := fnd_api.g_ret_sts_unexp_error;
8142: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8143: WHEN OTHERS THEN

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

8138: x_return_status := fnd_api.g_ret_sts_error;
8139: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8140: WHEN fnd_api.g_exc_unexpected_error THEN
8141: x_return_status := fnd_api.g_ret_sts_unexp_error;
8142: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8143: WHEN OTHERS THEN
8144: x_return_status := fnd_api.g_ret_sts_unexp_error;
8145:
8146: IF SQLCODE IS NOT NULL THEN

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

8146: IF SQLCODE IS NOT NULL THEN
8147: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_insert_header', l_progress, SQLCODE);
8148: END IF;
8149:
8150: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8151: END rcv_insert_update_header;
8152:
8153: PROCEDURE packunpack_container(
8154: p_api_version IN NUMBER

Line 8243: FND_MSG_PUB.ADD;

8239: g_dummy_lpn_id := l_to_lpn_id;
8240:
8241: IF l_return_status = FND_API.g_ret_sts_error THEN
8242: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
8243: FND_MSG_PUB.ADD;
8244: IF (l_debug = 1) THEN
8245: print_debug('PackUnpack_Container 2.1: generate dummy LPN RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
8246: END IF;
8247: RAISE FND_API.G_EXC_ERROR;

Line 8252: FND_MSG_PUB.ADD;

8248: END IF;
8249:
8250: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8251: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
8252: FND_MSG_PUB.ADD;
8253: IF (l_debug = 1) THEN
8254: print_debug('PackUnpack_Container 2.2: generate dummy LPN RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
8255: END IF;
8256: RAISE FND_API.g_exc_unexpected_error;

Line 8338: fnd_msg_pub.ADD;

8334: l_progress := '40';
8335:
8336: IF l_return_status = fnd_api.g_ret_sts_error THEN
8337: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL'); -- cannot pack LPN MSGTBD
8338: fnd_msg_pub.ADD;
8339:
8340: IF (l_debug = 1) THEN
8341: print_debug(
8342: 'PackUnpack_Container 5.1: WMS_Container_PUB.PackUnpack_Container RAISE FND_API.G_EXC_ERROR;'

Line 8353: fnd_msg_pub.ADD;

8349: END IF;
8350:
8351: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8352: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL');
8353: fnd_msg_pub.ADD;
8354:
8355: IF (l_debug = 1) THEN
8356: print_debug(
8357: 'PackUnpack_Container 5.2: WMS_Container_PUB.PackUnpack_Container FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 8429: FND_MSG_PUB.ADD;

8425: END IF;
8426:
8427: IF l_return_status = FND_API.g_ret_sts_error THEN
8428: FND_MESSAGE.SET_NAME('WMS', 'WMS_PACK_CONTAINER_FAIL'); -- cannot pack LPN MSGTBD
8429: FND_MSG_PUB.ADD;
8430: IF (l_debug = 1) THEN
8431: print_debug('PackUnpack_Container 8.1: - Unpack - WMS_Container_PUB.PackUnpack_Container RAISE FND_API.G_EXC_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
8432: END IF;
8433: RAISE FND_API.G_EXC_ERROR;

Line 8439: FND_MSG_PUB.ADD;

8435:
8436:
8437: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8438: FND_MESSAGE.SET_NAME('WMS', 'WMS_PACK_CONTAINER_FAIL');
8439: FND_MSG_PUB.ADD;
8440: IF (l_debug = 1) THEN
8441: print_debug('PackUnpack_Container 8.2: - Unpack - WMS_Container_PUB.PackUnpack_Container FND_API.G_EXC_UNEXPECTED_ERROR;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
8442: END IF;
8443: RAISE FND_API.g_exc_unexpected_error;

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

8478: EXCEPTION
8479: WHEN fnd_api.g_exc_error THEN
8480: ROLLBACK TO rcv_pack_unpack_sp;
8481: x_return_status := fnd_api.g_ret_sts_error;
8482: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8483: WHEN fnd_api.g_exc_unexpected_error THEN
8484: ROLLBACK TO rcv_pack_unpack_sp;
8485: x_return_status := fnd_api.g_ret_sts_unexp_error;
8486: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

8482: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8483: WHEN fnd_api.g_exc_unexpected_error THEN
8484: ROLLBACK TO rcv_pack_unpack_sp;
8485: x_return_status := fnd_api.g_ret_sts_unexp_error;
8486: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8487: WHEN OTHERS THEN
8488: ROLLBACK TO rcv_pack_unpack_sp;
8489: x_return_status := fnd_api.g_ret_sts_unexp_error;
8490:

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

8491: IF SQLCODE IS NOT NULL THEN
8492: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.packunpack_container', l_progress, SQLCODE);
8493: END IF;
8494:
8495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8496: END packunpack_container;
8497:
8498: PROCEDURE detect_asn_discrepancy(
8499: p_shipment_header_id NUMBER

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

8591: CLOSE l_curs_remaining_asn_has_lpn;
8592: END IF;
8593:
8594: x_return_status := fnd_api.g_ret_sts_error;
8595: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8596: WHEN fnd_api.g_exc_unexpected_error THEN
8597: ROLLBACK TO rcv_insert_ship_header_sp;
8598:
8599: IF l_curs_remaining_asn%ISOPEN THEN

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

8603: CLOSE l_curs_remaining_asn_has_lpn;
8604: END IF;
8605:
8606: x_return_status := fnd_api.g_ret_sts_unexp_error;
8607: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8608: WHEN OTHERS THEN
8609: ROLLBACK TO rcv_insert_ship_header_sp;
8610:
8611: IF l_curs_remaining_asn%ISOPEN THEN

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

8620: IF SQLCODE IS NOT NULL THEN
8621: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.detect_ASN_discrepancy', l_progress, SQLCODE);
8622: END IF;
8623:
8624: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8625: END detect_asn_discrepancy;
8626:
8627: PROCEDURE remove_lpn_contents(
8628: p_lpn_id IN NUMBER

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

8674: IF SQLCODE IS NOT NULL THEN
8675: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.remove_lpn_contents', l_progress, SQLCODE);
8676: END IF;
8677:
8678: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8679: END remove_lpn_contents;
8680:
8681: PROCEDURE clear_lpn_for_ship(
8682: p_organization_id IN NUMBER

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

8930: IF SQLCODE IS NOT NULL THEN
8931: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.clear_LPN_for_ship', l_progress, SQLCODE);
8932: END IF;
8933:
8934: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8935: END clear_lpn_for_ship;
8936:
8937: -- Check if there are LPNs on this shipment
8938: -- If theres LPN on this shipment, lpn_flag = 1, else lpn_flag = 0

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

9028: IF SQLCODE IS NOT NULL THEN
9029: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_shipment', l_progress, SQLCODE);
9030: END IF;
9031:
9032: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
9033: END check_lpn_on_shipment;
9034:
9035: PROCEDURE check_lpn_on_asn(
9036: p_shipment_header_id IN VARCHAR2

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

9120: IF SQLCODE IS NOT NULL THEN
9121: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_ASN', l_progress, SQLCODE);
9122: END IF;
9123:
9124: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
9125: END check_lpn_on_asn;
9126:
9127: -- Express Int Req Receiving
9128: PROCEDURE check_lpn_on_req(

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

9335: IF SQLCODE IS NOT NULL THEN
9336: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_REQ', l_progress, SQLCODE);
9337: END IF;
9338:
9339: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
9340: END;
9341:
9342: -- Express Int Req Receiving
9343:

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

9472: IF SQLCODE IS NOT NULL THEN
9473: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.update_LPN_Org', l_progress, SQLCODE);
9474: END IF;
9475:
9476: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
9477: END update_lpn_org;
9478:
9479: --Start of fix for the Bug #4037082
9480: --This procedure will validate the entered lot quantity

Line 9572: fnd_msg_pub.add;

9568: IF NVL(p_lot_primary_qty,0) <> 0 AND l_rlsu_primary_quantity <> 0 THEN
9569: IF p_lot_primary_qty > l_rlsu_primary_quantity THEN
9570: fnd_message.set_name('INV', 'INV_MAX_QTY');
9571: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity);
9572: fnd_msg_pub.add;
9573: IF (l_debug = 1) THEN
9574: print_debug('validate_lot_qty: 50 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);
9575: END IF;
9576:

Line 9707: fnd_msg_pub.add;

9703:
9704: IF (p_lot_primary_qty > (l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty) )) THEN
9705: fnd_message.set_name('INV', 'INV_MAX_QTY');
9706: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));
9707: fnd_msg_pub.add;
9708: x_return_status := fnd_api.g_ret_sts_error;
9709: IF (l_debug = 1) THEN
9710: print_debug('validate_lot_qty: 33 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);
9711: END IF;

Line 9859: fnd_msg_pub.add;

9855:
9856: IF (p_lot_primary_qty > (l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty) )) THEN
9857: fnd_message.set_name('INV', 'INV_MAX_QTY');
9858: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));
9859: fnd_msg_pub.add;
9860: x_return_status := fnd_api.g_ret_sts_error;
9861: IF (l_debug = 1) THEN
9862: print_debug('validate_lot_qty: 33 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);
9863: END IF;