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

1894: AND organization_id = l_org_id;
1895:
1896: IF l_lot_control_code = 1 THEN
1897: fnd_message.set_name('INV','INV_NO_LOT_CONTROL');
1898: fnd_msg_pub.add;
1899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1900: END IF;
1901:
1902: EXCEPTION

Line 1905: fnd_msg_pub.add;

1901:
1902: EXCEPTION
1903: WHEN NO_DATA_FOUND THEN
1904: fnd_message.set_name('INV','INV_INVALID_ITEM');
1905: fnd_msg_pub.add;
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: END;
1908:
1909:

Line 1929: fnd_msg_pub.add;

1925: AND lot.inventory_item_id = l_item_id);
1926:
1927: IF l_count > 0 then
1928: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
1929: fnd_msg_pub.add;
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END IF;
1932: END IF;
1933:

Line 1948: fnd_msg_pub.add;

1944: -- Lot exists or not
1945: IF l_count = 1 THEN
1946:
1947: fnd_message.set_name('INV','INV_LOT_EXISTS');
1948: fnd_msg_pub.add;
1949:
1950: SELECT expiration_date
1951: INTO l_expiration_date
1952: FROM mtl_lot_numbers

Line 1960: fnd_msg_pub.add;

1956:
1957:
1958: IF l_shelf_life_code = 4 AND l_expiration_date < SYSDATE THEN
1959: fnd_message.set_name('INV','INV_LOT_EXPREQD');
1960: fnd_msg_pub.add;
1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1962:
1963: ELSE
1964: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1977: fnd_msg_pub.count_and_get

1973: EXCEPTION
1974:
1975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1976: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1977: fnd_msg_pub.count_and_get
1978: ( p_count => x_msg_count
1979: , p_data => x_msg_data
1980: );
1981:

Line 1984: fnd_msg_pub.count_and_get

1980: );
1981:
1982: WHEN OTHERS THEN
1983: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1984: fnd_msg_pub.count_and_get
1985: ( p_count => x_msg_count
1986: , p_data => x_msg_data
1987: );
1988:

Line 2037: FND_MSG_PUB.ADD;

2033: IF (l_debug = 1) THEN
2034: mydebug('post_completion: Invalid serial number given in range');
2035: END IF;
2036: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SER');
2037: FND_MSG_PUB.ADD;
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;
2040:
2041: -- Check that in the case of a range of serial numbers, that the

Line 2049: FND_MSG_PUB.ADD;

2045: IF (l_debug = 1) THEN
2046: mydebug('post_completion: Range of serial numbers does not match given qty');
2047: END IF;
2048: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_X_QTY');
2049: FND_MSG_PUB.ADD;
2050: RAISE FND_API.G_EXC_ERROR;
2051: END IF;
2052: END IF;
2053:

Line 2090: fnd_msg_pub.count_and_get

2086: EXCEPTION
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2089: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2090: fnd_msg_pub.count_and_get
2091: ( p_count => x_msg_count
2092: , p_data => x_msg_data
2093: );
2094:

Line 2097: fnd_msg_pub.count_and_get

2093: );
2094:
2095: WHEN OTHERS THEN
2096: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2097: fnd_msg_pub.count_and_get
2098: ( p_count => x_msg_count
2099: , p_data => x_msg_data
2100: );
2101:

Line 2279: fnd_msg_pub.count_and_get

2275: EXCEPTION
2276:
2277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2278: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2279: fnd_msg_pub.count_and_get
2280: ( p_count => x_msg_count
2281: , p_data => x_msg_data
2282: );
2283:

Line 2286: fnd_msg_pub.count_and_get

2282: );
2283:
2284: WHEN OTHERS THEN
2285: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2286: fnd_msg_pub.count_and_get
2287: ( p_count => x_msg_count
2288: , p_data => x_msg_data
2289: );
2290:

Line 2502: fnd_msg_pub.count_and_get

2498: IF (l_debug = 1) THEN
2499: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2500: END IF;
2501: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2502: fnd_msg_pub.count_and_get
2503: ( p_count => x_msg_count
2504: , p_data => x_msg_data
2505: );
2506:

Line 2512: fnd_msg_pub.count_and_get

2508: IF (l_debug = 1) THEN
2509: mydebug('get_wip_info_for_putaway: unexpected error: ' || Sqlerrm);
2510: END IF;
2511: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2512: fnd_msg_pub.count_and_get
2513: ( p_count => x_msg_count
2514: , p_data => x_msg_data
2515: );
2516:

Line 2563: fnd_msg_pub.count_and_get

2559: EXCEPTION
2560:
2561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2562: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2563: fnd_msg_pub.count_and_get
2564: ( p_count => l_msg_count
2565: , p_data => l_msg_data
2566: );
2567:

Line 2570: fnd_msg_pub.count_and_get

2566: );
2567:
2568: WHEN OTHERS THEN
2569: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2570: fnd_msg_pub.count_and_get
2571: ( p_count => l_msg_count
2572: , p_data => l_msg_data
2573: );
2574:

Line 2705: fnd_msg_pub.count_and_get

2701: EXCEPTION
2702:
2703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2704: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2705: fnd_msg_pub.count_and_get
2706: ( p_count => x_msg_count
2707: , p_data => x_err_msg
2708: );
2709:

Line 2716: fnd_msg_pub.count_and_get

2712: END IF;
2713:
2714: WHEN OTHERS THEN
2715: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2716: fnd_msg_pub.count_and_get
2717: ( p_count => x_msg_count
2718: , p_data => x_err_msg
2719: );
2720: IF (l_debug = 1) THEN

Line 3008: FND_MSG_PUB.ADD;

3004:
3005: WHEN FND_API.G_EXC_ERROR THEN
3006: x_return_status:=FND_API.G_RET_STS_ERROR;
3007:
3008: FND_MSG_PUB.ADD;
3009: IF (l_debug = 1) THEN
3010: mydebug('wip_processor: Error: ' || sqlerrm);
3011: END IF;
3012:

Line 3016: FND_MSG_PUB.ADD;

3012:
3013: WHEN OTHERS THEN
3014: x_return_status := FND_API.g_ret_sts_error;
3015:
3016: FND_MSG_PUB.ADD;
3017: IF (l_debug = 1) THEN
3018: mydebug('wip_processor: Other Error: ' || sqlerrm);
3019: END IF;
3020: