DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on FND_MSG_PUB

Line 99: fnd_msg_pub.count_and_get

95: EXCEPTION
96:
97: WHEN FND_API.G_EXC_ERROR THEN
98: x_return_status:=FND_API.G_RET_STS_ERROR;
99: fnd_msg_pub.count_and_get
100: ( p_count => x_msg_count
101: , p_data => x_msg_data
102: );
103:

Line 110: fnd_msg_pub.count_and_get

106:
107: WHEN OTHERS THEN
108:
109: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
110: fnd_msg_pub.count_and_get
111: ( p_count => x_msg_count
112: , p_data => x_msg_data
113: );
114:

Line 339: fnd_msg_pub.count_and_get

335: EXCEPTION
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: x_return_status:=FND_API.G_RET_STS_ERROR;
339: fnd_msg_pub.count_and_get
340: ( p_count => x_msg_count
341: , p_data => x_msg_data
342: );
343:

Line 350: fnd_msg_pub.count_and_get

346:
347: WHEN OTHERS THEN
348:
349: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
350: fnd_msg_pub.count_and_get
351: ( p_count => x_msg_count
352: , p_data => x_msg_data
353: );
354:

Line 1176: fnd_msg_pub.count_and_get

1172: EXCEPTION
1173:
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: x_return_status:=FND_API.G_RET_STS_ERROR;
1176: fnd_msg_pub.count_and_get
1177: ( p_count => x_msg_count
1178: , p_data => x_msg_data
1179: );
1180:

Line 1187: fnd_msg_pub.count_and_get

1183:
1184: WHEN OTHERS THEN
1185:
1186: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1187: fnd_msg_pub.count_and_get
1188: ( p_count => x_msg_count
1189: , p_data => x_msg_data
1190: );
1191:

Line 1404: fnd_msg_pub.count_and_get

1400: EXCEPTION
1401:
1402: WHEN FND_API.G_EXC_ERROR THEN
1403: x_return_status:=FND_API.G_RET_STS_ERROR;
1404: fnd_msg_pub.count_and_get
1405: ( p_count => x_msg_count
1406: , p_data => x_msg_data
1407: );
1408:

Line 1415: fnd_msg_pub.count_and_get

1411:
1412: WHEN OTHERS THEN
1413:
1414: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1415: fnd_msg_pub.count_and_get
1416: ( p_count => x_msg_count
1417: , p_data => x_msg_data
1418: );
1419:

Line 1581: fnd_msg_pub.count_and_get

1577: EXCEPTION
1578:
1579: WHEN FND_API.G_EXC_ERROR THEN
1580: x_return_status:=FND_API.G_RET_STS_ERROR;
1581: fnd_msg_pub.count_and_get
1582: ( p_count => x_msg_count
1583: , p_data => x_msg_data
1584: );
1585:

Line 1592: fnd_msg_pub.count_and_get

1588:
1589: WHEN OTHERS THEN
1590:
1591: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1592: fnd_msg_pub.count_and_get
1593: ( p_count => x_msg_count
1594: , p_data => x_msg_data
1595: );
1596:

Line 1659: FND_MSG_PUB.ADD;

1655: IF (g_trace_on = 1) THEN mydebug('lpn_mass_move: Period is invalid');
1656: END IF;
1657:
1658: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
1659: FND_MSG_PUB.ADD;
1660: RAISE FND_API.G_exc_unexpected_error;
1661:
1662: END IF;
1663:

Line 1721: fnd_msg_pub.ADD;

1717: RAISE FND_API.G_exc_unexpected_error;
1718: END ;
1719: IF l_to_loc_type <> g_loc_type_staging_lane THEN
1720: fnd_message.set_name('WMS', 'WMS_STAGE_FROM_CONSOL_LPN'); -- mrana :addmsg
1721: fnd_msg_pub.ADD;
1722: IF g_trace_on = 1 THEN
1723: mydebug('WMS_STAGE_FROM_CONSOL_LPN : Destination Locator must be staging locator when one of' ||
1724: ' the From LPNs is a consol LPN : ' );
1725: -- {{- Destination Locator must be staging locator when one of the From LPNs is a consol LPN }}

Line 1763: FND_MSG_PUB.ADD;

1759: p_org_id => p_org_id,
1760: x_return_msg => x_msg_data) = 'N' THEN
1761:
1762: FND_MESSAGE.SET_NAME('WMS', x_msg_data);
1763: FND_MSG_PUB.ADD;
1764: RAISE FND_API.G_exc_unexpected_error;
1765: END IF;
1766:
1767: IF (g_trace_on = 1) THEN mydebug('after pn validations ...:: ' ); END IF;

Line 1863: FND_MSG_PUB.ADD;

1859: IF (l_debug = 1) THEN mydebug('l_return: ' || l_return); END IF;
1860: IF l_return <> 0 THEN
1861: ROLLBACK TO sp_lpn_mass_move;
1862: FND_MESSAGE.SET_NAME('WMS','WMS_TD_TXNMGR_ERROR' );
1863: FND_MSG_PUB.ADD;
1864: RAISE FND_API.g_exc_unexpected_error;
1865: END IF;
1866:
1867: COMMIT;

Line 1876: fnd_msg_pub.count_and_get

1872:
1873: WHEN FND_API.G_EXC_ERROR THEN
1874: ROLLBACK TO sp_lpn_mass_move;
1875: x_return_status:=FND_API.G_RET_STS_ERROR;
1876: fnd_msg_pub.count_and_get
1877: ( p_count => x_msg_count
1878: , p_data => x_msg_data
1879: );
1880:

Line 1886: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1882: END IF;
1883:
1884: WHEN fnd_api.g_exc_unexpected_error THEN
1885: x_return_status := fnd_api.g_ret_sts_unexp_error;
1886: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1887: IF (g_trace_on = 1) THEN mydebug('Unexpected ROLLBACK ' ); END IF;
1888: ROLLBACK TO sp_lpn_mass_move;
1889:
1890: WHEN OTHERS THEN

Line 1893: fnd_msg_pub.count_and_get

1889:
1890: WHEN OTHERS THEN
1891: ROLLBACK TO sp_lpn_mass_move;
1892: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1893: fnd_msg_pub.count_and_get
1894: ( p_count => x_msg_count
1895: , p_data => x_msg_data
1896: );
1897:

Line 2430: fnd_msg_pub.count_and_get

2426: EXCEPTION
2427:
2428: WHEN FND_API.G_EXC_ERROR THEN
2429: x_return_status:=FND_API.G_RET_STS_ERROR;
2430: fnd_msg_pub.count_and_get
2431: ( p_count => x_msg_count
2432: , p_data => x_msg_data
2433: );
2434:

Line 2438: fnd_msg_pub.count_and_get

2434:
2435: WHEN OTHERS THEN
2436:
2437: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2438: fnd_msg_pub.count_and_get
2439: ( p_count => x_msg_count
2440: , p_data => x_msg_data
2441: );
2442:

Line 2604: FND_MSG_PUB.ADD;

2600:
2601: END IF;
2602:
2603: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
2604: FND_MSG_PUB.ADD;
2605: RAISE FND_API.G_exc_unexpected_error;
2606:
2607: END IF;
2608:

Line 2639: FND_MSG_PUB.ADD;

2635: END IF;
2636:
2637: IF p_calling_mode = 'LOAD' THEN
2638: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOADED_ERROR');
2639: FND_MSG_PUB.ADD;
2640: RAISE FND_API.G_exc_unexpected_error;
2641:
2642: ELSE
2643: p_temp_id := l_temp_id;

Line 2682: FND_MSG_PUB.ADD;

2678: END IF;
2679: END IF;
2680:
2681: FND_MESSAGE.SET_NAME('WMS', x_msg_data);
2682: FND_MSG_PUB.ADD;
2683: RAISE FND_API.G_exc_unexpected_error;
2684: END IF;
2685:
2686: IF (g_trace_on = 1) THEN

Line 2803: FND_MSG_PUB.ADD;

2799: END IF;
2800: EXCEPTION
2801: WHEN no_data_found THEN
2802: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_INVALID_LPN');
2803: FND_MSG_PUB.ADD;
2804: RAISE FND_API.G_EXC_ERROR;
2805: END; --End of Fix for bug #4157153.
2806: END;
2807:

Line 2818: fnd_msg_pub.ADD;

2814: mydebug('Setting Subinv info = '||INV_CACHE.fromsub_rec.secondary_inventory_name);
2815: END IF;
2816: ELSE
2817: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
2818: fnd_msg_pub.ADD;
2819: RAISE fnd_api.g_exc_error;
2820: END IF;
2821:
2822: -- to check if the current subinventory is reservable

Line 2993: fnd_msg_pub.count_and_get

2989:
2990: WHEN FND_API.G_EXC_ERROR THEN
2991: ROLLBACK TO sp_stg_move;
2992: x_return_status:=FND_API.G_RET_STS_ERROR;
2993: fnd_msg_pub.count_and_get
2994: ( p_count => x_msg_count
2995: , p_data => x_msg_data
2996: );
2997: IF (g_trace_on = 1) THEN

Line 3008: fnd_msg_pub.count_and_get

3004: WHEN OTHERS THEN
3005:
3006: ROLLBACK TO sp_stg_move;
3007: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3008: fnd_msg_pub.count_and_get
3009: ( p_count => x_msg_count
3010: , p_data => x_msg_data
3011: );
3012: IF (g_trace_on = 1) THEN