DBA Data[Home] [Help]

APPS.WMS_WIP_INTEGRATION dependencies on FND_MSG_PUB

Line 33: fnd_msg_pub.count_and_get

29: EXCEPTION
30:
31: WHEN no_data_found THEN
32: x_return_status:=FND_API.G_RET_STS_ERROR;
33: fnd_msg_pub.count_and_get
34: ( p_count => x_msg_count
35: , p_data => x_msg_data
36: );
37:

Line 839: FND_MSG_PUB.ADD;

835:
836: --COMMIT;
837: IF l_txn_ret<>0 THEN
838: FND_MESSAGE.SET_NAME('WMS','WMS_TD_TXNMGR_ERROR' );
839: FND_MSG_PUB.ADD;
840:
841: l_return_status:=FND_API.G_RET_STS_ERROR;
842: fnd_msg_pub.count_and_get
843: ( p_count => x_msg_count

Line 842: fnd_msg_pub.count_and_get

838: FND_MESSAGE.SET_NAME('WMS','WMS_TD_TXNMGR_ERROR' );
839: FND_MSG_PUB.ADD;
840:
841: l_return_status:=FND_API.G_RET_STS_ERROR;
842: fnd_msg_pub.count_and_get
843: ( p_count => x_msg_count
844: , p_data => x_msg_data
845: );
846: ELSE

Line 855: fnd_msg_pub.count_and_get

851:
852: ELSE
853: -- No rows found in wip_lpn_completions
854: l_return_status:=FND_API.G_RET_STS_ERROR;
855: fnd_msg_pub.count_and_get
856: ( p_count => x_msg_count
857: , p_data => x_msg_data
858: );
859: END IF;

Line 867: fnd_msg_pub.count_and_get

863: EXCEPTION
864:
865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
866: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
867: fnd_msg_pub.count_and_get
868: (p_count => x_msg_count
869: , p_data => x_msg_data
870: );
871:

Line 874: fnd_msg_pub.count_and_get

870: );
871:
872: WHEN OTHERS THEN
873: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
874: fnd_msg_pub.count_and_get
875: (p_count => x_msg_count
876: , p_data => x_msg_data
877: );
878:

Line 1868: fnd_msg_pub.add;

1864: AND organization_id = l_org_id;
1865:
1866: IF l_lot_control_code = 1 THEN
1867: fnd_message.set_name('INV','INV_NO_LOT_CONTROL');
1868: fnd_msg_pub.add;
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1870: END IF;
1871:
1872: EXCEPTION

Line 1875: fnd_msg_pub.add;

1871:
1872: EXCEPTION
1873: WHEN NO_DATA_FOUND THEN
1874: fnd_message.set_name('INV','INV_INVALID_ITEM');
1875: fnd_msg_pub.add;
1876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1877: END;
1878:
1879:

Line 1899: fnd_msg_pub.add;

1895: AND lot.inventory_item_id = l_item_id);
1896:
1897: IF l_count > 0 then
1898: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
1899: fnd_msg_pub.add;
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;
1902: END IF;
1903:

Line 1918: fnd_msg_pub.add;

1914: -- Lot exists or not
1915: IF l_count = 1 THEN
1916:
1917: fnd_message.set_name('INV','INV_LOT_EXISTS');
1918: fnd_msg_pub.add;
1919:
1920: SELECT expiration_date
1921: INTO l_expiration_date
1922: FROM mtl_lot_numbers

Line 1930: fnd_msg_pub.add;

1926:
1927:
1928: IF l_shelf_life_code = 4 AND l_expiration_date < SYSDATE THEN
1929: fnd_message.set_name('INV','INV_LOT_EXPREQD');
1930: fnd_msg_pub.add;
1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1932:
1933: ELSE
1934: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1947: fnd_msg_pub.count_and_get

1943: EXCEPTION
1944:
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1947: fnd_msg_pub.count_and_get
1948: ( p_count => x_msg_count
1949: , p_data => x_msg_data
1950: );
1951:

Line 1954: fnd_msg_pub.count_and_get

1950: );
1951:
1952: WHEN OTHERS THEN
1953: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1954: fnd_msg_pub.count_and_get
1955: ( p_count => x_msg_count
1956: , p_data => x_msg_data
1957: );
1958:

Line 2007: FND_MSG_PUB.ADD;

2003: IF (l_debug = 1) THEN
2004: mydebug('post_completion: Invalid serial number given in range');
2005: END IF;
2006: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SER');
2007: FND_MSG_PUB.ADD;
2008: RAISE FND_API.G_EXC_ERROR;
2009: END IF;
2010:
2011: -- Check that in the case of a range of serial numbers, that the

Line 2019: FND_MSG_PUB.ADD;

2015: IF (l_debug = 1) THEN
2016: mydebug('post_completion: Range of serial numbers does not match given qty');
2017: END IF;
2018: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_X_QTY');
2019: FND_MSG_PUB.ADD;
2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;
2022: END IF;
2023:

Line 2060: fnd_msg_pub.count_and_get

2056: EXCEPTION
2057:
2058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2059: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2060: fnd_msg_pub.count_and_get
2061: ( p_count => x_msg_count
2062: , p_data => x_msg_data
2063: );
2064:

Line 2067: fnd_msg_pub.count_and_get

2063: );
2064:
2065: WHEN OTHERS THEN
2066: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2067: fnd_msg_pub.count_and_get
2068: ( p_count => x_msg_count
2069: , p_data => x_msg_data
2070: );
2071:

Line 2249: fnd_msg_pub.count_and_get

2245: EXCEPTION
2246:
2247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2248: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2249: fnd_msg_pub.count_and_get
2250: ( p_count => x_msg_count
2251: , p_data => x_msg_data
2252: );
2253:

Line 2256: fnd_msg_pub.count_and_get

2252: );
2253:
2254: WHEN OTHERS THEN
2255: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2256: fnd_msg_pub.count_and_get
2257: ( p_count => x_msg_count
2258: , p_data => x_msg_data
2259: );
2260:

Line 2472: fnd_msg_pub.count_and_get

2468: IF (l_debug = 1) THEN
2469: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2470: END IF;
2471: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2472: fnd_msg_pub.count_and_get
2473: ( p_count => x_msg_count
2474: , p_data => x_msg_data
2475: );
2476:

Line 2482: fnd_msg_pub.count_and_get

2478: IF (l_debug = 1) THEN
2479: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2480: END IF;
2481: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2482: fnd_msg_pub.count_and_get
2483: ( p_count => x_msg_count
2484: , p_data => x_msg_data
2485: );
2486:

Line 2533: fnd_msg_pub.count_and_get

2529: EXCEPTION
2530:
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2533: fnd_msg_pub.count_and_get
2534: ( p_count => l_msg_count
2535: , p_data => l_msg_data
2536: );
2537:

Line 2540: fnd_msg_pub.count_and_get

2536: );
2537:
2538: WHEN OTHERS THEN
2539: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2540: fnd_msg_pub.count_and_get
2541: ( p_count => l_msg_count
2542: , p_data => l_msg_data
2543: );
2544:

Line 2675: fnd_msg_pub.count_and_get

2671: EXCEPTION
2672:
2673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2674: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2675: fnd_msg_pub.count_and_get
2676: ( p_count => x_msg_count
2677: , p_data => x_err_msg
2678: );
2679:

Line 2686: fnd_msg_pub.count_and_get

2682: END IF;
2683:
2684: WHEN OTHERS THEN
2685: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2686: fnd_msg_pub.count_and_get
2687: ( p_count => x_msg_count
2688: , p_data => x_err_msg
2689: );
2690: IF (l_debug = 1) THEN

Line 2978: FND_MSG_PUB.ADD;

2974:
2975: WHEN FND_API.G_EXC_ERROR THEN
2976: x_return_status:=FND_API.G_RET_STS_ERROR;
2977:
2978: FND_MSG_PUB.ADD;
2979: IF (l_debug = 1) THEN
2980: mydebug('wip_processor: Error: ' || sqlerrm);
2981: END IF;
2982:

Line 2986: FND_MSG_PUB.ADD;

2982:
2983: WHEN OTHERS THEN
2984: x_return_status := FND_API.g_ret_sts_error;
2985:
2986: FND_MSG_PUB.ADD;
2987: IF (l_debug = 1) THEN
2988: mydebug('wip_processor: Other Error: ' || sqlerrm);
2989: END IF;
2990: