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 559: fnd_msg_pub.add;

555:
556: -- Give error message to user that no rate has been found
557: IF l_rate IS NULL THEN
558: fnd_message.set_name('PO', 'PO_CPO_NO_RATE_FOR_DATE');
559: fnd_msg_pub.add;
560: IF (l_debug = 1) THEN
561: 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);
562: END IF;
563: RAISE FND_API.G_EXC_ERROR;

Line 1765: fnd_msg_pub.ADD;

1761: inv_rcv_common_apis.init_startup_values(p_organization_id);
1762: EXCEPTION
1763: WHEN NO_DATA_FOUND THEN
1764: fnd_message.set_name('INV', 'INV_RCV_PARAM');
1765: fnd_msg_pub.ADD;
1766: RAISE fnd_api.g_exc_error;
1767: END;
1768:
1769: l_progress := '30';

Line 1915: fnd_msg_pub.ADD;

1911:
1912: -- x_status is not successful if there is any execution error in matching.
1913: IF l_return_status = fnd_api.g_ret_sts_error THEN
1914: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1915: fnd_msg_pub.ADD;
1916:
1917: IF (l_debug = 1) THEN
1918: print_debug('create_po_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1919: END IF;

Line 1926: fnd_msg_pub.ADD;

1922: END IF;
1923:
1924: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1925: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
1926: fnd_msg_pub.ADD;
1927:
1928: IF (l_debug = 1) THEN
1929: print_debug('Exiting create_po_rcpt_intf_rec 60.2: Unexpect error calling matching'
1930: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 1940: fnd_msg_pub.ADD;

1936:
1937: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
1938: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
1939: fnd_message.set_name('INV', l_err_message);
1940: fnd_msg_pub.ADD;
1941:
1942: IF (l_debug = 1) THEN
1943: print_debug('create_po_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1944: END IF;

Line 1975: fnd_msg_pub.ADD;

1971: END LOOP;
1972:
1973: IF l_err_message <> '@@@' THEN
1974: fnd_message.set_name(l_msg_prod, l_err_message);
1975: fnd_msg_pub.ADD;
1976:
1977: IF (l_debug = 1) THEN
1978: print_debug(
1979: 'create_po_rcpt_intf_rec 80: adding tolerance message - l_msg_prod = '

Line 2394: fnd_msg_pub.count_and_get(

2390: IF l_curs_rcpt_detail%ISOPEN THEN
2391: CLOSE l_curs_rcpt_detail;
2392: END IF;
2393:
2394: fnd_msg_pub.count_and_get(
2395: p_encoded => fnd_api.g_false
2396: , p_count => l_msg_count
2397: , p_data => x_message);
2398:

Line 2410: fnd_msg_pub.count_and_get(

2406: IF l_curs_rcpt_detail%ISOPEN THEN
2407: CLOSE l_curs_rcpt_detail;
2408: END IF;
2409:
2410: fnd_msg_pub.count_and_get(
2411: p_encoded => fnd_api.g_false
2412: , p_count => l_msg_count
2413: , p_data => x_message);
2414:

Line 2430: fnd_msg_pub.count_and_get(

2426: IF SQLCODE IS NOT NULL THEN
2427: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_po_rcpt_intf_rec', l_progress, SQLCODE);
2428: END IF;
2429:
2430: fnd_msg_pub.count_and_get(
2431: p_encoded => fnd_api.g_false
2432: , p_count => l_msg_count
2433: , p_data => x_message);
2434:

Line 2731: fnd_msg_pub.ADD;

2727: inv_rcv_common_apis.init_startup_values(p_organization_id);
2728: EXCEPTION
2729: WHEN NO_DATA_FOUND THEN
2730: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2731: fnd_msg_pub.ADD;
2732: RAISE fnd_api.g_exc_error;
2733: END;
2734:
2735: -- default header level non-DB items in rcv_transaction block

Line 2826: fnd_msg_pub.ADD;

2822:
2823: -- x_status is not successful if there is any execution error in matching.
2824: IF l_return_status = fnd_api.g_ret_sts_error THEN
2825: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2826: fnd_msg_pub.ADD;
2827:
2828: IF (l_debug = 1) THEN
2829: print_debug('create_intship_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2830: END IF;

Line 2837: fnd_msg_pub.ADD;

2833: END IF;
2834:
2835: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2836: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
2837: fnd_msg_pub.ADD;
2838:
2839: IF (l_debug = 1) THEN
2840: print_debug('create_intship_rcpt_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
2841: , 1);

Line 2850: fnd_msg_pub.ADD;

2846:
2847: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
2848: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
2849: fnd_message.set_name('INV', l_err_message);
2850: fnd_msg_pub.ADD;
2851:
2852: IF (l_debug = 1) THEN
2853: print_debug('create_intship_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2854: END IF;

Line 2885: fnd_msg_pub.ADD;

2881: END LOOP;
2882:
2883: IF l_err_message <> '@@@' THEN
2884: fnd_message.set_name(l_msg_prod, l_err_message);
2885: fnd_msg_pub.ADD;
2886:
2887: IF (l_debug = 1) THEN
2888: print_debug('create_intship_rcpt_intf_rec 80: adding tolerance message ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2889: END IF;

Line 3089: fnd_msg_pub.count_and_get(

3085: IF l_curs_rcpt_detail%ISOPEN THEN
3086: CLOSE l_curs_rcpt_detail;
3087: END IF;
3088:
3089: fnd_msg_pub.count_and_get(
3090: p_encoded => fnd_api.g_false
3091: , p_count => l_msg_count
3092: , p_data => x_message);
3093:

Line 3105: fnd_msg_pub.count_and_get(

3101: IF l_curs_rcpt_detail%ISOPEN THEN
3102: CLOSE l_curs_rcpt_detail;
3103: END IF;
3104:
3105: fnd_msg_pub.count_and_get(
3106: p_encoded => fnd_api.g_false
3107: , p_count => l_msg_count
3108: , p_data => x_message);
3109:

Line 3125: fnd_msg_pub.count_and_get(

3121: IF SQLCODE IS NOT NULL THEN
3122: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_intship_rcpt_intf_rec', l_progress, SQLCODE);
3123: END IF;
3124:
3125: fnd_msg_pub.count_and_get(
3126: p_encoded => fnd_api.g_false
3127: , p_count => l_msg_count
3128: , p_data => x_message);
3129:

Line 3371: fnd_msg_pub.ADD;

3367: inv_rcv_common_apis.init_startup_values(p_organization_id);
3368: EXCEPTION
3369: WHEN NO_DATA_FOUND THEN
3370: fnd_message.set_name('INV', 'INV_RCV_PARAM');
3371: fnd_msg_pub.ADD;
3372: RAISE fnd_api.g_exc_error;
3373: END;
3374:
3375: IF (l_debug = 1) THEN

Line 3448: fnd_msg_pub.ADD;

3444: END IF;
3445:
3446: IF l_return_status = fnd_api.g_ret_sts_error THEN
3447: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3448: fnd_msg_pub.ADD;
3449:
3450: IF (l_debug = 1) THEN
3451: print_debug('create_rma_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3452: END IF;

Line 3459: fnd_msg_pub.ADD;

3455: END IF;
3456:
3457: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3458: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
3459: fnd_msg_pub.ADD;
3460:
3461: IF (l_debug = 1) THEN
3462: print_debug('create_rma_rcpt_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3463: END IF;

Line 3471: fnd_msg_pub.ADD;

3467:
3468: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
3469: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
3470: fnd_message.set_name('INV', l_err_message);
3471: fnd_msg_pub.ADD;
3472:
3473: IF (l_debug = 1) THEN
3474: print_debug('create_rma_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3475: END IF;

Line 3506: fnd_msg_pub.ADD;

3502: END LOOP;
3503:
3504: IF l_err_message <> '@@@' THEN
3505: fnd_message.set_name(l_msg_prod, l_err_message);
3506: fnd_msg_pub.ADD;
3507:
3508: IF (l_debug = 1) THEN
3509: print_debug('create_rma_rcpt_intf_rec 80: adding tolerance message ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3510: END IF;

Line 3665: fnd_msg_pub.count_and_get(

3661: IF l_curs_rcpt_detail%ISOPEN THEN
3662: CLOSE l_curs_rcpt_detail;
3663: END IF;
3664:
3665: fnd_msg_pub.count_and_get(
3666: p_encoded => fnd_api.g_false
3667: , p_count => l_msg_count
3668: , p_data => x_message);
3669:

Line 3681: fnd_msg_pub.count_and_get(

3677: IF l_curs_rcpt_detail%ISOPEN THEN
3678: CLOSE l_curs_rcpt_detail;
3679: END IF;
3680:
3681: fnd_msg_pub.count_and_get(
3682: p_encoded => fnd_api.g_false
3683: , p_count => l_msg_count
3684: , p_data => x_message);
3685:

Line 3701: fnd_msg_pub.count_and_get(

3697: IF SQLCODE IS NOT NULL THEN
3698: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_rma_rcpt_intf_rec', l_progress, SQLCODE);
3699: END IF;
3700:
3701: fnd_msg_pub.count_and_get(
3702: p_encoded => fnd_api.g_false
3703: , p_count => l_msg_count
3704: , p_data => x_message);
3705:

Line 4178: fnd_msg_pub.ADD;

4174: inv_rcv_common_apis.init_startup_values(p_organization_id);
4175: EXCEPTION
4176: WHEN NO_DATA_FOUND THEN
4177: fnd_message.set_name('INV', 'INV_RCV_PARAM');
4178: fnd_msg_pub.ADD;
4179: RAISE fnd_api.g_exc_error;
4180: END;
4181:
4182: -- default header level non-DB items in rcv_transaction block

Line 4316: fnd_msg_pub.ADD;

4312: END IF;
4313:
4314: IF l_return_status = fnd_api.g_ret_sts_error THEN
4315: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
4316: fnd_msg_pub.ADD;
4317:
4318: IF (l_debug = 1) THEN
4319: print_debug('create_asn_con_rcpt_intf_rec 60.1: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4320: END IF;

Line 4327: fnd_msg_pub.ADD;

4323: END IF;
4324:
4325: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4326: fnd_message.set_name('INV', 'INV_RCV_MATCH_ERROR');
4327: fnd_msg_pub.ADD;
4328:
4329: IF (l_debug = 1) THEN
4330: print_debug('create_asn_con_rcpt_intf_rec 60.2: Unexpect error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
4331: , 1);

Line 4340: fnd_msg_pub.ADD;

4336:
4337: IF g_rcpt_match_table_gross(g_receipt_detail_index).error_status = 'E' THEN
4338: l_err_message := g_rcpt_match_table_gross(g_receipt_detail_index).error_message;
4339: fnd_message.set_name('INV', l_err_message);
4340: fnd_msg_pub.ADD;
4341:
4342: IF (l_debug = 1) THEN
4343: print_debug('create_asn_con_rcpt_intf_rec 70: error calling matching' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4344: END IF;

Line 4375: fnd_msg_pub.ADD;

4371: END LOOP;
4372:
4373: IF l_err_message <> '@@@' THEN
4374: fnd_message.set_name(l_msg_prod, l_err_message);
4375: fnd_msg_pub.ADD;
4376:
4377: IF (l_debug = 1) THEN
4378: print_debug('create_asn_con_rcpt_intf_rec 80: adding tolerance message ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4379: END IF;

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

4749: IF l_curs_rcpt_detail%ISOPEN THEN
4750: CLOSE l_curs_rcpt_detail;
4751: END IF;
4752:
4753: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4754:
4755: IF (l_debug = 1) THEN
4756: print_debug('create_asn_con_rcpt_intf_rec: FND_API.g_exc_error ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
4757: END IF;

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

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

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

4779: IF SQLCODE IS NOT NULL THEN
4780: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_con_rcpt_intf_rec', l_progress, SQLCODE);
4781: END IF;
4782:
4783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4784:
4785: IF (l_debug = 1) THEN
4786: print_debug(
4787: 'create_asn_con_rcpt_intf_rec: Other exception - l_progress = '

Line 5001: fnd_msg_pub.ADD;

4997: );
4998:
4999: IF l_return_status = fnd_api.g_ret_sts_error THEN
5000: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5001: fnd_msg_pub.ADD;
5002:
5003: IF (l_debug = 1) THEN
5004: print_debug(
5005: 'create_asn_exp_rcpt_intf_rec 30.1:create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 5015: fnd_msg_pub.ADD;

5011: END IF;
5012:
5013: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5014: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5015: fnd_msg_pub.ADD;
5016:
5017: IF (l_debug = 1) THEN
5018: print_debug(
5019: 'create_asn_exp_rcpt_intf_rec 30.2: create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 5075: fnd_msg_pub.ADD;

5071:
5072: --Check for failure
5073: IF l_lot_prm_quantity = -99999 THEN
5074: fnd_message.set_name('INV', 'INV_INT_UOMCONVCODE');
5075: fnd_msg_pub.ADD;
5076: IF (l_debug = 1) THEN
5077: print_debug('create_asn_exp_rcpt_intf_rec: 20.2 - txn/primary uom conversion failed', 4);
5078: END IF;
5079: RAISE fnd_api.g_exc_error;

Line 5289: fnd_msg_pub.ADD;

5285: );
5286:
5287: IF l_return_status = fnd_api.g_ret_sts_error THEN
5288: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5289: fnd_msg_pub.ADD;
5290:
5291: IF (l_debug = 1) THEN
5292: print_debug(
5293: 'create_asn_exp_rcpt_intf_rec 40.1:create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 5304: fnd_msg_pub.ADD;

5300: END IF;
5301:
5302: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5303: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5304: fnd_msg_pub.ADD;
5305:
5306: IF (l_debug = 1) THEN
5307: print_debug(
5308: 'create_asn_exp_rcpt_intf_rec 40.2: create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 5354: fnd_msg_pub.ADD;

5350: );
5351:
5352: IF l_return_status = fnd_api.g_ret_sts_error THEN
5353: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
5354: fnd_msg_pub.ADD;
5355:
5356: IF (l_debug = 1) THEN
5357: 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);
5358: END IF;

Line 5394: fnd_msg_pub.count_and_get(

5390: IF l_curs_serial_number%ISOPEN THEN
5391: CLOSE l_curs_serial_number;
5392: END IF;
5393:
5394: fnd_msg_pub.count_and_get(
5395: p_encoded => fnd_api.g_false
5396: , p_count => l_msg_count
5397: , p_data => x_message);
5398:

Line 5413: fnd_msg_pub.count_and_get(

5409: IF l_curs_serial_number%ISOPEN THEN
5410: CLOSE l_curs_serial_number;
5411: END IF;
5412:
5413: fnd_msg_pub.count_and_get(
5414: p_encoded => fnd_api.g_false
5415: , p_count => l_msg_count
5416: , p_data => x_message);
5417:

Line 5436: fnd_msg_pub.count_and_get(

5432: IF SQLCODE IS NOT NULL THEN
5433: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_exp_rcpt_intf_rec', l_progress, SQLCODE);
5434: END IF;
5435:
5436: fnd_msg_pub.count_and_get(
5437: p_encoded => fnd_api.g_false
5438: , p_count => l_msg_count
5439: , p_data => x_message);
5440:

Line 5620: fnd_msg_pub.ADD;

5616: );
5617:
5618: IF l_return_status = fnd_api.g_ret_sts_error THEN
5619: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
5620: fnd_msg_pub.ADD;
5621:
5622: IF (l_debug = 1) THEN
5623: print_debug(
5624: 'create_std_rcpt_intf_rec 2.1: create_po_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 5635: fnd_msg_pub.ADD;

5631: END IF;
5632:
5633: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5634: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
5635: fnd_msg_pub.ADD;
5636:
5637: IF (l_debug = 1) THEN
5638: print_debug(
5639: 'create_std_rcpt_intf_rec 2.2: create_po_rcpt_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 5702: fnd_msg_pub.ADD;

5698: );
5699:
5700: IF l_return_status = fnd_api.g_ret_sts_error THEN
5701: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5702: fnd_msg_pub.ADD;
5703:
5704: IF (l_debug = 1) THEN
5705: print_debug(
5706: 'create_std_rcpt_intf_rec 3.1: create_intship_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 5717: fnd_msg_pub.ADD;

5713: END IF;
5714:
5715: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5716: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5717: fnd_msg_pub.ADD;
5718:
5719: IF (l_debug = 1) THEN
5720: print_debug(
5721: 'create_std_rcpt_intf_rec 3.2: create_intship_rcpt_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 5782: fnd_msg_pub.ADD;

5778: );
5779:
5780: IF l_return_status = fnd_api.g_ret_sts_error THEN
5781: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
5782: fnd_msg_pub.ADD;
5783:
5784: IF (l_debug = 1) THEN
5785: print_debug(
5786: 'create_std_rcpt_intf_rec 4.1: create_rma_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 5797: fnd_msg_pub.ADD;

5793: END IF;
5794:
5795: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5796: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
5797: fnd_msg_pub.ADD;
5798:
5799: IF (l_debug = 1) THEN
5800: print_debug(
5801: 'create_std_rcpt_intf_rec 4.2: create_rma_rcpt_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 5858: fnd_msg_pub.ADD;

5854: );
5855:
5856: IF l_return_status = fnd_api.g_ret_sts_error THEN
5857: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
5858: fnd_msg_pub.ADD;
5859:
5860: IF (l_debug = 1) THEN
5861: print_debug(
5862: 'create_std_rcpt_intf_rec 5.1: create_asn_exp_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 5873: fnd_msg_pub.ADD;

5869: END IF;
5870:
5871: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5872: fnd_message.set_name('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
5873: fnd_msg_pub.ADD;
5874:
5875: IF (l_debug = 1) THEN
5876: print_debug(
5877: 'create_std_rcpt_intf_rec 5.2: create_asn_exp_rcpt_intf_rec FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 5915: fnd_msg_pub.ADD;

5911: );
5912:
5913: IF l_return_status = fnd_api.g_ret_sts_error THEN
5914: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5915: fnd_msg_pub.ADD;
5916:
5917: IF (l_debug = 1) THEN
5918: print_debug(
5919: 'create_std_rcpt_intf_rec 6.1: create_asn_exp_rcpt_intf_rec for IntShip RAISE FND_API.G_EXC_ERROR;'

Line 5930: fnd_msg_pub.ADD;

5926: END IF;
5927:
5928: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5929: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
5930: fnd_msg_pub.ADD;
5931:
5932: IF (l_debug = 1) THEN
5933: print_debug(
5934: 'create_std_rcpt_intf_rec 6.2: create_asn_exp_rcpt_intf_rec for IntShip RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 6014: fnd_msg_pub.ADD;

6010: );
6011:
6012: IF l_return_status = fnd_api.g_ret_sts_error THEN
6013: fnd_message.set_name('INV', 'INV_RCV_CRT_ASNCON_RTI_FAIL'); -- MSGTBD
6014: fnd_msg_pub.ADD;
6015:
6016: IF (l_debug = 1) THEN
6017: print_debug(
6018: 'create_std_rcpt_intf_rec 7.1: create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_ERROR;'

Line 6029: fnd_msg_pub.ADD;

6025: END IF;
6026:
6027: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6028: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
6029: fnd_msg_pub.ADD;
6030:
6031: IF (l_debug = 1) THEN
6032: print_debug(
6033: 'create_std_rcpt_intf_rec 7.2: create_asn_con_rcpt_intf_rec RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 6098: fnd_msg_pub.ADD;

6094: END IF;
6095:
6096: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6097: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
6098: fnd_msg_pub.ADD;
6099: x_status := 'W';
6100:
6101: IF (l_debug = 1) THEN
6102: 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 6124: fnd_msg_pub.count_and_get(

6120: x_status := fnd_api.g_ret_sts_error;
6121: IF c_rti_txn_id%ISOPEN THEN
6122: CLOSE c_rti_txn_id;
6123: END IF;
6124: fnd_msg_pub.count_and_get(
6125: p_encoded => fnd_api.g_false
6126: , p_count => l_msg_count
6127: , p_data => x_message);
6128: WHEN fnd_api.g_exc_unexpected_error THEN

Line 6133: fnd_msg_pub.count_and_get(

6129: x_status := fnd_api.g_ret_sts_unexp_error;
6130: IF c_rti_txn_id%ISOPEN THEN
6131: CLOSE c_rti_txn_id;
6132: END IF;
6133: fnd_msg_pub.count_and_get(
6134: p_encoded => fnd_api.g_false
6135: , p_count => l_msg_count
6136: , p_data => x_message);
6137: WHEN OTHERS THEN

Line 6145: fnd_msg_pub.count_and_get(

6141: END IF;
6142: IF SQLCODE IS NOT NULL THEN
6143: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_std_rcpt_intf_rec', l_progress, SQLCODE);
6144: END IF;
6145: fnd_msg_pub.count_and_get(
6146: p_encoded => fnd_api.g_false
6147: , p_count => l_msg_count
6148: , p_data => x_message);
6149: END create_std_rcpt_intf_rec;

Line 6847: fnd_msg_pub.count_and_get(

6843: EXCEPTION
6844: WHEN fnd_api.g_exc_error THEN
6845: ROLLBACK TO rcv_crt_mo_sp;
6846: x_status := fnd_api.g_ret_sts_error;
6847: fnd_msg_pub.count_and_get(
6848: p_encoded => fnd_api.g_false
6849: , p_count => l_msg_count
6850: , p_data => x_message);
6851:

Line 6858: fnd_msg_pub.count_and_get(

6854: END IF;
6855: WHEN fnd_api.g_exc_unexpected_error THEN
6856: ROLLBACK TO rcv_crt_mo_sp;
6857: x_status := fnd_api.g_ret_sts_unexp_error;
6858: fnd_msg_pub.count_and_get(
6859: p_encoded => fnd_api.g_false
6860: , p_count => l_msg_count
6861: , p_data => x_message);
6862:

Line 6874: fnd_msg_pub.count_and_get(

6870: IF SQLCODE IS NOT NULL THEN
6871: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_move_order', l_progress, SQLCODE);
6872: END IF;
6873:
6874: fnd_msg_pub.count_and_get(
6875: p_encoded => fnd_api.g_false
6876: , p_count => l_msg_count
6877: , p_data => x_message);
6878:

Line 6934: fnd_msg_pub.ADD;

6930:
6931: IF (l_process_status = 'ERROR') THEN
6932: x_return_status := fnd_api.g_ret_sts_error;
6933: fnd_message.set_name('INV', 'INV_FAILED');
6934: fnd_msg_pub.ADD;
6935: RAISE fnd_api.g_exc_error;
6936: END IF;
6937: EXCEPTION
6938: WHEN NO_DATA_FOUND THEN

Line 6941: fnd_msg_pub.ADD;

6937: EXCEPTION
6938: WHEN NO_DATA_FOUND THEN
6939: x_return_status := fnd_api.g_ret_sts_error;
6940: fnd_message.set_name('INV', 'INV_FAILED');
6941: fnd_msg_pub.ADD;
6942: RAISE fnd_api.g_exc_error;
6943: END;
6944:
6945: IF (l_debug = 1) THEN

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

6978: END IF;
6979: EXCEPTION
6980: WHEN fnd_api.g_exc_error THEN
6981: x_return_status := fnd_api.g_ret_sts_error;
6982: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6983: WHEN fnd_api.g_exc_unexpected_error THEN
6984: x_return_status := fnd_api.g_ret_sts_unexp_error;
6985: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6986: WHEN OTHERS THEN

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

6981: x_return_status := fnd_api.g_ret_sts_error;
6982: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6983: WHEN fnd_api.g_exc_unexpected_error THEN
6984: x_return_status := fnd_api.g_ret_sts_unexp_error;
6985: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6986: WHEN OTHERS THEN
6987: x_return_status := fnd_api.g_ret_sts_unexp_error;
6988:
6989: IF SQLCODE IS NOT NULL THEN

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

6989: IF SQLCODE IS NOT NULL THEN
6990: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_rti_from_header', l_progress, SQLCODE);
6991: END IF;
6992:
6993: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
6994: END rcv_update_rti_from_header;
6995:
6996: -- Only called if patchset J or higher from rcv_insert_update_header
6997: -- This is called instead of rcv_insert_header

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

7249: IF (l_debug = 1) THEN
7250: print_debug('INV_RCV_STD_RCPT_APIS.rcv_insert_header_interface 50.1: RAISE FND_API.G_EXC_ERROR;' || l_progress, 4);
7251: END IF;
7252:
7253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7254: WHEN fnd_api.g_exc_unexpected_error THEN
7255: ROLLBACK TO rcv_insert_ship_header_sp;
7256: x_return_status := fnd_api.g_ret_sts_unexp_error;
7257:

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

7258: IF (l_debug = 1) THEN
7259: print_debug('INV_RCV_STD_RCPT_APIS.rcv_insert_header_interface 50.2: RAISE FND_API.G_EXC_ERROR;' || l_progress, 4);
7260: END IF;
7261:
7262: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7263: WHEN OTHERS THEN
7264: ROLLBACK TO rcv_insert_ship_header_sp;
7265: x_return_status := fnd_api.g_ret_sts_unexp_error;
7266:

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

7267: IF SQLCODE IS NOT NULL THEN
7268: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_insert_header_interface', l_progress, SQLCODE);
7269: END IF;
7270:
7271: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7272: END rcv_insert_header_interface;
7273:
7274: PROCEDURE rcv_update_header_interface(
7275: p_organization_id NUMBER

Line 7401: fnd_msg_pub.ADD;

7397: );
7398:
7399: IF l_return_status = fnd_api.g_ret_sts_error THEN
7400: fnd_message.set_name('INV', 'INV_RCV_UPDATE_RTI_FAIL');
7401: fnd_msg_pub.ADD;
7402:
7403: IF (l_debug = 1) THEN
7404: print_debug(
7405: '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 7415: fnd_msg_pub.ADD;

7411: END IF;
7412:
7413: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7414: fnd_message.set_name('INV', 'INV_RCV_UPDATE_RTI_FAIL');
7415: fnd_msg_pub.ADD;
7416:
7417: IF (l_debug = 1) THEN
7418: print_debug(
7419: 'rcv_update_header_interface 30.2: rcv_update_rti_from_header RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

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

7466: WHEN fnd_api.g_exc_error THEN
7467: ROLLBACK TO rcv_update_ship_header_sp;
7468:
7469: x_return_status := fnd_api.g_ret_sts_error;
7470: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7471: WHEN fnd_api.g_exc_unexpected_error THEN
7472: ROLLBACK TO rcv_update_ship_header_sp;
7473:
7474: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

7471: WHEN fnd_api.g_exc_unexpected_error THEN
7472: ROLLBACK TO rcv_update_ship_header_sp;
7473:
7474: x_return_status := fnd_api.g_ret_sts_unexp_error;
7475: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7476: WHEN OTHERS THEN
7477: ROLLBACK TO rcv_update_ship_header_sp;
7478: x_return_status := fnd_api.g_ret_sts_unexp_error;
7479:

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

7480: IF SQLCODE IS NOT NULL THEN
7481: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_header_interface', l_progress, SQLCODE);
7482: END IF;
7483:
7484: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7485: END rcv_update_header_interface;
7486:
7487: PROCEDURE rcv_insert_update_header(
7488: p_organization_id IN NUMBER

Line 7611: fnd_msg_pub.ADD;

7607: END IF;
7608:
7609: IF l_return_status = fnd_api.g_ret_sts_error THEN
7610: fnd_message.set_name('INV', 'INV_RCV_INS_SHIP_HDR_FAIL');
7611: fnd_msg_pub.ADD;
7612:
7613: IF (l_debug = 1) THEN
7614: print_debug(
7615: '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 7625: fnd_msg_pub.ADD;

7621: END IF;
7622:
7623: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7624: fnd_message.set_name('INV', 'INV_RCV_INS_SHIP_HDR_FAIL');
7625: fnd_msg_pub.ADD;
7626:
7627: IF (l_debug = 1) THEN
7628: print_debug(
7629: 'rcv_insert_update_header 20.2: rcv_insert_header RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 7708: fnd_msg_pub.ADD;

7704: END IF;
7705:
7706: IF l_return_status = fnd_api.g_ret_sts_error THEN
7707: fnd_message.set_name('INV', 'INV_RCV_UPD_SHIP_HDR_FAIL');
7708: fnd_msg_pub.ADD;
7709:
7710: IF (l_debug = 1) THEN
7711: print_debug(
7712: '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 7722: fnd_msg_pub.ADD;

7718: END IF;
7719:
7720: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7721: fnd_message.set_name('INV', 'INV_RCV_UPD_SHIP_HDR_FAIL');
7722: fnd_msg_pub.ADD;
7723:
7724: IF (l_debug = 1) THEN
7725: print_debug(
7726: 'rcv_insert_update_header 40.2: rcv_update_header RAISE FND_API.G_EXC_UNEXPECTED_ERROR;'

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

7739: END IF;
7740: EXCEPTION
7741: WHEN fnd_api.g_exc_error THEN
7742: x_return_status := fnd_api.g_ret_sts_error;
7743: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7744: WHEN fnd_api.g_exc_unexpected_error THEN
7745: x_return_status := fnd_api.g_ret_sts_unexp_error;
7746: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7747: WHEN OTHERS THEN

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

7742: x_return_status := fnd_api.g_ret_sts_error;
7743: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7744: WHEN fnd_api.g_exc_unexpected_error THEN
7745: x_return_status := fnd_api.g_ret_sts_unexp_error;
7746: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7747: WHEN OTHERS THEN
7748: x_return_status := fnd_api.g_ret_sts_unexp_error;
7749:
7750: IF SQLCODE IS NOT NULL THEN

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

7750: IF SQLCODE IS NOT NULL THEN
7751: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.rcv_update_insert_header', l_progress, SQLCODE);
7752: END IF;
7753:
7754: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7755: END rcv_insert_update_header;
7756:
7757: PROCEDURE packunpack_container(
7758: p_api_version IN NUMBER

Line 7847: FND_MSG_PUB.ADD;

7843: g_dummy_lpn_id := l_to_lpn_id;
7844:
7845: IF l_return_status = FND_API.g_ret_sts_error THEN
7846: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
7847: FND_MSG_PUB.ADD;
7848: IF (l_debug = 1) THEN
7849: 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);
7850: END IF;
7851: RAISE FND_API.G_EXC_ERROR;

Line 7856: FND_MSG_PUB.ADD;

7852: END IF;
7853:
7854: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7855: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
7856: FND_MSG_PUB.ADD;
7857: IF (l_debug = 1) THEN
7858: 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);
7859: END IF;
7860: RAISE FND_API.g_exc_unexpected_error;

Line 7942: fnd_msg_pub.ADD;

7938: l_progress := '40';
7939:
7940: IF l_return_status = fnd_api.g_ret_sts_error THEN
7941: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL'); -- cannot pack LPN MSGTBD
7942: fnd_msg_pub.ADD;
7943:
7944: IF (l_debug = 1) THEN
7945: print_debug(
7946: 'PackUnpack_Container 5.1: WMS_Container_PUB.PackUnpack_Container RAISE FND_API.G_EXC_ERROR;'

Line 7957: fnd_msg_pub.ADD;

7953: END IF;
7954:
7955: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7956: fnd_message.set_name('WMS', 'WMS_PACK_CONTAINER_FAIL');
7957: fnd_msg_pub.ADD;
7958:
7959: IF (l_debug = 1) THEN
7960: print_debug(
7961: 'PackUnpack_Container 5.2: WMS_Container_PUB.PackUnpack_Container FND_API.G_EXC_UNEXPECTED_ERROR;'

Line 8033: FND_MSG_PUB.ADD;

8029: END IF;
8030:
8031: IF l_return_status = FND_API.g_ret_sts_error THEN
8032: FND_MESSAGE.SET_NAME('WMS', 'WMS_PACK_CONTAINER_FAIL'); -- cannot pack LPN MSGTBD
8033: FND_MSG_PUB.ADD;
8034: IF (l_debug = 1) THEN
8035: 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);
8036: END IF;
8037: RAISE FND_API.G_EXC_ERROR;

Line 8043: FND_MSG_PUB.ADD;

8039:
8040:
8041: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
8042: FND_MESSAGE.SET_NAME('WMS', 'WMS_PACK_CONTAINER_FAIL');
8043: FND_MSG_PUB.ADD;
8044: IF (l_debug = 1) THEN
8045: 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);
8046: END IF;
8047: RAISE FND_API.g_exc_unexpected_error;

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

8082: EXCEPTION
8083: WHEN fnd_api.g_exc_error THEN
8084: ROLLBACK TO rcv_pack_unpack_sp;
8085: x_return_status := fnd_api.g_ret_sts_error;
8086: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8087: WHEN fnd_api.g_exc_unexpected_error THEN
8088: ROLLBACK TO rcv_pack_unpack_sp;
8089: x_return_status := fnd_api.g_ret_sts_unexp_error;
8090: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

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

8086: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8087: WHEN fnd_api.g_exc_unexpected_error THEN
8088: ROLLBACK TO rcv_pack_unpack_sp;
8089: x_return_status := fnd_api.g_ret_sts_unexp_error;
8090: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8091: WHEN OTHERS THEN
8092: ROLLBACK TO rcv_pack_unpack_sp;
8093: x_return_status := fnd_api.g_ret_sts_unexp_error;
8094:

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

8095: IF SQLCODE IS NOT NULL THEN
8096: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.packunpack_container', l_progress, SQLCODE);
8097: END IF;
8098:
8099: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8100: END packunpack_container;
8101:
8102: PROCEDURE detect_asn_discrepancy(
8103: p_shipment_header_id NUMBER

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

8195: CLOSE l_curs_remaining_asn_has_lpn;
8196: END IF;
8197:
8198: x_return_status := fnd_api.g_ret_sts_error;
8199: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8200: WHEN fnd_api.g_exc_unexpected_error THEN
8201: ROLLBACK TO rcv_insert_ship_header_sp;
8202:
8203: IF l_curs_remaining_asn%ISOPEN THEN

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

8207: CLOSE l_curs_remaining_asn_has_lpn;
8208: END IF;
8209:
8210: x_return_status := fnd_api.g_ret_sts_unexp_error;
8211: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8212: WHEN OTHERS THEN
8213: ROLLBACK TO rcv_insert_ship_header_sp;
8214:
8215: IF l_curs_remaining_asn%ISOPEN THEN

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

8224: IF SQLCODE IS NOT NULL THEN
8225: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.detect_ASN_discrepancy', l_progress, SQLCODE);
8226: END IF;
8227:
8228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8229: END detect_asn_discrepancy;
8230:
8231: PROCEDURE remove_lpn_contents(
8232: p_lpn_id IN NUMBER

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

8278: IF SQLCODE IS NOT NULL THEN
8279: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.remove_lpn_contents', l_progress, SQLCODE);
8280: END IF;
8281:
8282: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8283: END remove_lpn_contents;
8284:
8285: PROCEDURE clear_lpn_for_ship(
8286: p_organization_id IN NUMBER

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

8534: IF SQLCODE IS NOT NULL THEN
8535: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.clear_LPN_for_ship', l_progress, SQLCODE);
8536: END IF;
8537:
8538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8539: END clear_lpn_for_ship;
8540:
8541: -- Check if there are LPNs on this shipment
8542: -- If theres LPN on this shipment, lpn_flag = 1, else lpn_flag = 0

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

8632: IF SQLCODE IS NOT NULL THEN
8633: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_shipment', l_progress, SQLCODE);
8634: END IF;
8635:
8636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8637: END check_lpn_on_shipment;
8638:
8639: PROCEDURE check_lpn_on_asn(
8640: p_shipment_header_id IN VARCHAR2

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

8724: IF SQLCODE IS NOT NULL THEN
8725: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_ASN', l_progress, SQLCODE);
8726: END IF;
8727:
8728: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8729: END check_lpn_on_asn;
8730:
8731: -- Express Int Req Receiving
8732: PROCEDURE check_lpn_on_req(

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

8939: IF SQLCODE IS NOT NULL THEN
8940: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.check_lpn_on_REQ', l_progress, SQLCODE);
8941: END IF;
8942:
8943: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8944: END;
8945:
8946: -- Express Int Req Receiving
8947:

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

9076: IF SQLCODE IS NOT NULL THEN
9077: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.update_LPN_Org', l_progress, SQLCODE);
9078: END IF;
9079:
9080: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
9081: END update_lpn_org;
9082:
9083: --Start of fix for the Bug #4037082
9084: --This procedure will validate the entered lot quantity

Line 9176: fnd_msg_pub.add;

9172: IF NVL(p_lot_primary_qty,0) <> 0 AND l_rlsu_primary_quantity <> 0 THEN
9173: IF p_lot_primary_qty > l_rlsu_primary_quantity THEN
9174: fnd_message.set_name('INV', 'INV_MAX_QTY');
9175: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity);
9176: fnd_msg_pub.add;
9177: IF (l_debug = 1) THEN
9178: print_debug('validate_lot_qty: 50 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);
9179: END IF;
9180:

Line 9311: fnd_msg_pub.add;

9307:
9308: IF (p_lot_primary_qty > (l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty) )) THEN
9309: fnd_message.set_name('INV', 'INV_MAX_QTY');
9310: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));
9311: fnd_msg_pub.add;
9312: x_return_status := fnd_api.g_ret_sts_error;
9313: IF (l_debug = 1) THEN
9314: print_debug('validate_lot_qty: 33 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);
9315: END IF;

Line 9431: fnd_msg_pub.add;

9427:
9428: IF (p_lot_primary_qty > (l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty) )) THEN
9429: fnd_message.set_name('INV', 'INV_MAX_QTY');
9430: fnd_message.set_token('TOKEN', l_rlsu_primary_quantity - (l_mtli_primary_quantity + l_current_grp_prim_qty));
9431: fnd_msg_pub.add;
9432: x_return_status := fnd_api.g_ret_sts_error;
9433: IF (l_debug = 1) THEN
9434: print_debug('validate_lot_qty: 33 Receiving Lot Qty : ' || p_lot_primary_qty || ' cannot be more than Shipped Qty : ' || l_rlsu_primary_quantity , 4);
9435: END IF;