DBA Data[Home] [Help]

APPS.INV_RCV_STD_TRANSFER_APIS dependencies on FND_MSG_PUB

Line 752: fnd_msg_pub.count_and_get (

748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_ERROR THEN
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: fnd_msg_pub.count_and_get (
753: p_encoded => FND_API.G_FALSE
754: , p_count => x_msg_count
755: , p_data => x_msg_data );
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 758: fnd_msg_pub.count_and_get (

754: , p_count => x_msg_count
755: , p_data => x_msg_data );
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: fnd_msg_pub.count_and_get (
759: p_encoded => FND_API.G_FALSE
760: , p_count => x_msg_count
761: , p_data => x_msg_data );
762: WHEN OTHERS THEN

Line 764: fnd_msg_pub.count_and_get (

760: , p_count => x_msg_count
761: , p_data => x_msg_data );
762: WHEN OTHERS THEN
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: fnd_msg_pub.count_and_get (
765: p_encoded => FND_API.G_FALSE
766: , p_count => x_msg_count
767: , p_data => x_msg_data );
768: IF SQLCODE IS NOT NULL THEN

Line 862: fnd_msg_pub.add;

858: IF (l_debug = 1) THEN
859: print_debug('MOL LPN not matching!!!', 4);
860: END IF;
861: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
862: fnd_msg_pub.add;
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;
865:
866: EXCEPTION

Line 869: fnd_msg_pub.add;

865:
866: EXCEPTION
867: WHEN OTHERS THEN
868: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
869: fnd_msg_pub.add;
870: RAISE FND_API.G_EXC_ERROR;
871: END;
872: END IF; --END IF p_lpn_id is NOT NULL
873:

Line 893: fnd_msg_pub.add;

889: IF (l_debug = 1) THEN
890: print_debug('Lot Number not matching!!!', 4);
891: END IF;
892: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
893: fnd_msg_pub.add;
894: RAISE FND_API.G_EXC_ERROR;
895: END IF;
896:
897: EXCEPTION

Line 900: fnd_msg_pub.add;

896:
897: EXCEPTION
898: WHEN OTHERS THEN
899: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
900: fnd_msg_pub.add;
901: RAISE FND_API.G_EXC_ERROR;
902: END;
903: END IF; --END IF p_lot_number is NOT NULL
904:

Line 966: fnd_msg_pub.add;

962: IF (l_debug = 1) THEN
963: print_debug('get_avail_quantity_to_transfer: There is no quantity available to transfer: ', 4);
964: END IF;
965: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
966: fnd_msg_pub.add;
967: RAISE FND_API.G_EXC_ERROR;
968: ELSIF (p_transfer_quantity > l_rcvqty_txn_uom) THEN
969: IF (l_debug = 1) THEN
970: print_debug('Transfer qty ' || p_transfer_quantity || ' exceeds ' ||

Line 974: fnd_msg_pub.add;

970: print_debug('Transfer qty ' || p_transfer_quantity || ' exceeds ' ||
971: ' available quantity ' || l_rcvqty_txn_uom, 4);
972: END IF;
973: fnd_message.set_name('INV', 'INV_RCV_QTY_OVER_TOLERANCE');
974: fnd_msg_pub.add;
975: RAISE FND_API.G_EXC_ERROR;
976: ELSIF (p_transfer_quantity < l_rcvqty_txn_uom) THEN
977: l_avail_transfer_qty := p_transfer_quantity;
978: ELSE

Line 1013: fnd_msg_pub.count_and_get (

1009:
1010: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: fnd_msg_pub.count_and_get (
1014: p_encoded => FND_API.G_FALSE
1015: , p_count => x_msg_count
1016: , p_data => x_msg_data );
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1019: fnd_msg_pub.count_and_get (

1015: , p_count => x_msg_count
1016: , p_data => x_msg_data );
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: fnd_msg_pub.count_and_get (
1020: p_encoded => FND_API.G_FALSE
1021: , p_count => x_msg_count
1022: , p_data => x_msg_data );
1023: WHEN OTHERS THEN

Line 1025: fnd_msg_pub.count_and_get (

1021: , p_count => x_msg_count
1022: , p_data => x_msg_data );
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: fnd_msg_pub.count_and_get (
1026: p_encoded => FND_API.G_FALSE
1027: , p_count => x_msg_count
1028: , p_data => x_msg_data );
1029: IF SQLCODE IS NOT NULL THEN

Line 1304: fnd_msg_pub.add;

1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: fnd_message.set_name('INV', 'INV-NO ITEM UOM');
1304: fnd_msg_pub.add;
1305: RAISE FND_API.G_EXC_ERROR;
1306: END;
1307:
1308: l_progress := 30;

Line 1445: fnd_msg_pub.count_and_get (

1441: IF c_rcvtxn_detail%ISOPEN THEN
1442: CLOSE c_rcvtxn_detail;
1443: END IF;
1444: x_return_status := FND_API.G_RET_STS_ERROR;
1445: fnd_msg_pub.count_and_get (
1446: p_encoded => FND_API.G_FALSE
1447: , p_count => x_msg_count
1448: , p_data => x_msg_data );
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1455: fnd_msg_pub.count_and_get (

1451: IF c_rcvtxn_detail%ISOPEN THEN
1452: CLOSE c_rcvtxn_detail;
1453: END IF;
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: fnd_msg_pub.count_and_get (
1456: p_encoded => FND_API.G_FALSE
1457: , p_count => x_msg_count
1458: , p_data => x_msg_data );
1459: WHEN OTHERS THEN

Line 1465: fnd_msg_pub.count_and_get (

1461: IF c_rcvtxn_detail%ISOPEN THEN
1462: CLOSE c_rcvtxn_detail;
1463: END IF;
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: fnd_msg_pub.count_and_get (
1466: p_encoded => FND_API.G_FALSE
1467: , p_count => x_msg_count
1468: , p_data => x_msg_data );
1469: IF SQLCODE IS NOT NULL THEN

Line 1727: fnd_msg_pub.add;

1723:
1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: fnd_message.set_name('INV', 'INV-NO ITEM UOM');
1727: fnd_msg_pub.add;
1728: RAISE FND_API.G_EXC_ERROR;
1729: END;
1730:
1731: l_progress := 30;

Line 1863: fnd_msg_pub.count_and_get (

1859: IF c_rcvtxn_detail%ISOPEN THEN
1860: CLOSE c_rcvtxn_detail;
1861: END IF;
1862: x_return_status := FND_API.G_RET_STS_ERROR;
1863: fnd_msg_pub.count_and_get (
1864: p_encoded => FND_API.G_FALSE
1865: , p_count => x_msg_count
1866: , p_data => x_msg_data );
1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1872: fnd_msg_pub.count_and_get (

1868: IF c_rcvtxn_detail%ISOPEN THEN
1869: CLOSE c_rcvtxn_detail;
1870: END IF;
1871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1872: fnd_msg_pub.count_and_get (
1873: p_encoded => FND_API.G_FALSE
1874: , p_count => x_msg_count
1875: , p_data => x_msg_data );
1876: WHEN OTHERS THEN

Line 1881: fnd_msg_pub.count_and_get (

1877: IF c_rcvtxn_detail%ISOPEN THEN
1878: CLOSE c_rcvtxn_detail;
1879: END IF;
1880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1881: fnd_msg_pub.count_and_get (
1882: p_encoded => FND_API.G_FALSE
1883: , p_count => x_msg_count
1884: , p_data => x_msg_data );
1885: IF SQLCODE IS NOT NULL THEN

Line 2145: fnd_msg_pub.add;

2141:
2142: EXCEPTION
2143: WHEN OTHERS THEN
2144: fnd_message.set_name('INV', 'INV-NO ITEM UOM');
2145: fnd_msg_pub.add;
2146: RAISE FND_API.G_EXC_ERROR;
2147: END;
2148:
2149: l_progress := 30;

Line 2282: fnd_msg_pub.count_and_get (

2278: IF c_rcvtxn_detail%ISOPEN THEN
2279: CLOSE c_rcvtxn_detail;
2280: END IF;
2281: x_return_status := FND_API.G_RET_STS_ERROR;
2282: fnd_msg_pub.count_and_get (
2283: p_encoded => FND_API.G_FALSE
2284: , p_count => x_msg_count
2285: , p_data => x_msg_data );
2286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2291: fnd_msg_pub.count_and_get (

2287: IF c_rcvtxn_detail%ISOPEN THEN
2288: CLOSE c_rcvtxn_detail;
2289: END IF;
2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2291: fnd_msg_pub.count_and_get (
2292: p_encoded => FND_API.G_FALSE
2293: , p_count => x_msg_count
2294: , p_data => x_msg_data );
2295: WHEN OTHERS THEN

Line 2300: fnd_msg_pub.count_and_get (

2296: IF c_rcvtxn_detail%ISOPEN THEN
2297: CLOSE c_rcvtxn_detail;
2298: END IF;
2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2300: fnd_msg_pub.count_and_get (
2301: p_encoded => FND_API.G_FALSE
2302: , p_count => x_msg_count
2303: , p_data => x_msg_data );
2304: IF SQLCODE IS NOT NULL THEN

Line 2455: fnd_msg_pub.add;

2451: ' . Error in initializing receiving parameters', 4);
2452: print_debug('err: ' || substr(sqlerrm,1,140),4);
2453: END IF;
2454: fnd_message.set_name('INV', 'INV_RCV_PARAM');
2455: fnd_msg_pub.add;
2456:
2457: RAISE FND_API.G_EXC_ERROR;
2458: END;
2459:

Line 2564: fnd_msg_pub.add;

2560:
2561: --Check the return status
2562: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2563: fnd_message.set_name('INV', 'INV_RCV_CREATE_PO_RTI_FAIL');
2564: fnd_msg_pub.add;
2565:
2566: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2567: IF (l_debug = 1) THEN
2568: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '

Line 2632: fnd_msg_pub.add;

2628:
2629: --Check the return status
2630: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2631: fnd_message.set_name('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL');
2632: fnd_msg_pub.add;
2633:
2634: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2635: IF (l_debug = 1) THEN
2636: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '

Line 2695: fnd_msg_pub.add;

2691:
2692: --Check the return status
2693: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2694: fnd_message.set_name('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL');
2695: fnd_msg_pub.add;
2696:
2697: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2698: IF (l_debug = 1) THEN
2699: print_debug('Failure in create_transfer_rcvtxn_rec at progress level '

Line 2721: fnd_msg_pub.add;

2717: ELSE
2718: print_debug('Failed at : ' || l_progress || ' . Invalid Reference passed : '
2719: || p_reference_type_code, 4);
2720: fnd_message.set_name('INV', 'INV-BAD SOURCE TYPE');
2721: fnd_msg_pub.add;
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724:
2725: l_progress := 60;

Line 2735: fnd_msg_pub.count_and_get (

2731:
2732: EXCEPTION
2733: WHEN FND_API.G_EXC_ERROR THEN
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: fnd_msg_pub.count_and_get (
2736: p_encoded => FND_API.G_FALSE
2737: , p_count => x_msg_count
2738: , p_data => x_msg_data );
2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2741: fnd_msg_pub.count_and_get (

2737: , p_count => x_msg_count
2738: , p_data => x_msg_data );
2739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: fnd_msg_pub.count_and_get (
2742: p_encoded => FND_API.G_FALSE
2743: , p_count => x_msg_count
2744: , p_data => x_msg_data );
2745: WHEN OTHERS THEN

Line 2747: fnd_msg_pub.count_and_get (

2743: , p_count => x_msg_count
2744: , p_data => x_msg_data );
2745: WHEN OTHERS THEN
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747: fnd_msg_pub.count_and_get (
2748: p_encoded => FND_API.G_FALSE
2749: , p_count => x_msg_count
2750: , p_data => x_msg_data );
2751: IF SQLCODE IS NOT NULL THEN

Line 2828: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

2824: ,p_sec_qty => p_secondary_quantity
2825: );
2826:
2827: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2828: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
2829: IF (l_debug = 1) THEN
2830: print_debug('insert_mtli_helper: Error occurred while creating interface lots: ' || l_msg_data,1);
2831: END IF;
2832: RETURN FALSE;

Line 2894: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

2890: , p_att_exist => l_yes
2891: , p_update_msn => l_no);
2892:
2893: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2894: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
2895: IF (l_debug = 1) THEN
2896: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
2897: END IF;
2898: RETURN FALSE;

Line 3453: fnd_msg_pub.ADD;

3449: IF (l_debug = 1) THEN
3450: print_debug('REFERENCE INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
3451: END IF;
3452: fnd_message.set_name('INV', 'INV_FAILED');
3453: fnd_msg_pub.ADD;
3454: RAISE fnd_api.g_exc_error;
3455: END IF;
3456:
3457: IF (l_debug = 1) THEN

Line 3514: fnd_msg_pub.ADD;

3510: END IF;
3511:
3512: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3513: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3514: fnd_msg_pub.ADD;
3515: RAISE fnd_api.g_exc_unexpected_error;
3516: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3517: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3518: fnd_msg_pub.ADD;

Line 3518: fnd_msg_pub.ADD;

3514: fnd_msg_pub.ADD;
3515: RAISE fnd_api.g_exc_unexpected_error;
3516: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3517: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3518: fnd_msg_pub.ADD;
3519: RAISE fnd_api.g_exc_error;
3520: END IF;
3521:
3522: <>

Line 3540: fnd_msg_pub.ADD;

3536: END IF;
3537:
3538: -- Unable to match RS with quantity.
3539: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3540: fnd_msg_pub.ADD;
3541: RAISE FND_API.g_exc_error;
3542:
3543: END IF;
3544: --Bug 5331779-Begin Change

Line 3633: fnd_msg_pub.ADD;

3629: IF (l_debug = 1) THEN
3630: print_debug('REF INFO CAN NOT BE RETRIEVVED FROM RT' , 1);
3631: END IF;
3632: fnd_message.set_name('INV', 'INV_FAILED');
3633: fnd_msg_pub.ADD;
3634: RAISE fnd_api.g_exc_error;
3635: END IF;
3636:
3637: IF (l_debug = 1) THEN

Line 3661: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

3657: RAISE fnd_api.g_exc_unexpected_error;
3658: END IF; -- END IF check l_result
3659:
3660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3661: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
3662: IF (l_debug = 1) THEN
3663: print_debug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data,1);
3664: END IF;
3665: RAISE fnd_api.g_exc_error;

Line 3733: fnd_msg_pub.ADD;

3729: IF (l_debug = 1) THEN
3730: print_debug('Avaiable Qty is less than Txn Qty ' , 1);
3731: END IF;
3732: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3733: fnd_msg_pub.ADD;
3734: RAISE fnd_api.g_exc_error;
3735: END IF;
3736:
3737: IF (l_rti_tb(k)(l).quantity < l_remaining_prim_qty) THEN

Line 3881: fnd_msg_pub.ADD;

3877: END IF;
3878:
3879: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3880: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3881: fnd_msg_pub.ADD;
3882: RAISE fnd_api.g_exc_unexpected_error;
3883: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3884: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3885: fnd_msg_pub.ADD;

Line 3885: fnd_msg_pub.ADD;

3881: fnd_msg_pub.ADD;
3882: RAISE fnd_api.g_exc_unexpected_error;
3883: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3884: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
3885: fnd_msg_pub.ADD;
3886: RAISE fnd_api.g_exc_error;
3887: END IF;
3888:
3889: l := l_rti_tb(k).next(l);

Line 3904: fnd_msg_pub.count_and_get (

3900: EXCEPTION
3901: WHEN FND_API.G_EXC_ERROR THEN
3902: rollback to match_rti_ss;
3903: x_return_status := FND_API.G_RET_STS_ERROR;
3904: fnd_msg_pub.count_and_get (
3905: p_encoded => FND_API.G_FALSE
3906: , p_count => x_msg_count
3907: , p_data => x_msg_data );
3908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3911: fnd_msg_pub.count_and_get (

3907: , p_data => x_msg_data );
3908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3909: rollback to match_rti_ss;
3910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3911: fnd_msg_pub.count_and_get (
3912: p_encoded => FND_API.G_FALSE
3913: , p_count => x_msg_count
3914: , p_data => x_msg_data );
3915: WHEN OTHERS THEN

Line 3918: fnd_msg_pub.count_and_get (

3914: , p_data => x_msg_data );
3915: WHEN OTHERS THEN
3916: rollback to match_rti_ss;
3917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3918: fnd_msg_pub.count_and_get (
3919: p_encoded => FND_API.G_FALSE
3920: , p_count => x_msg_count
3921: , p_data => x_msg_data );
3922: IF SQLCODE IS NOT NULL THEN