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 1171: fnd_msg_pub.count_and_get

1167: EXCEPTION
1168:
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: x_return_status:=FND_API.G_RET_STS_ERROR;
1171: fnd_msg_pub.count_and_get
1172: ( p_count => x_msg_count
1173: , p_data => x_msg_data
1174: );
1175:

Line 1182: fnd_msg_pub.count_and_get

1178:
1179: WHEN OTHERS THEN
1180:
1181: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1182: fnd_msg_pub.count_and_get
1183: ( p_count => x_msg_count
1184: , p_data => x_msg_data
1185: );
1186:

Line 1399: fnd_msg_pub.count_and_get

1395: EXCEPTION
1396:
1397: WHEN FND_API.G_EXC_ERROR THEN
1398: x_return_status:=FND_API.G_RET_STS_ERROR;
1399: fnd_msg_pub.count_and_get
1400: ( p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );
1403:

Line 1410: fnd_msg_pub.count_and_get

1406:
1407: WHEN OTHERS THEN
1408:
1409: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1410: fnd_msg_pub.count_and_get
1411: ( p_count => x_msg_count
1412: , p_data => x_msg_data
1413: );
1414:

Line 1576: fnd_msg_pub.count_and_get

1572: EXCEPTION
1573:
1574: WHEN FND_API.G_EXC_ERROR THEN
1575: x_return_status:=FND_API.G_RET_STS_ERROR;
1576: fnd_msg_pub.count_and_get
1577: ( p_count => x_msg_count
1578: , p_data => x_msg_data
1579: );
1580:

Line 1587: fnd_msg_pub.count_and_get

1583:
1584: WHEN OTHERS THEN
1585:
1586: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1587: fnd_msg_pub.count_and_get
1588: ( p_count => x_msg_count
1589: , p_data => x_msg_data
1590: );
1591:

Line 1654: FND_MSG_PUB.ADD;

1650: IF (g_trace_on = 1) THEN mydebug('lpn_mass_move: Period is invalid');
1651: END IF;
1652:
1653: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_exc_unexpected_error;
1656:
1657: END IF;
1658:

Line 1716: fnd_msg_pub.ADD;

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

Line 1758: FND_MSG_PUB.ADD;

1754: p_org_id => p_org_id,
1755: x_return_msg => x_msg_data) = 'N' THEN
1756:
1757: FND_MESSAGE.SET_NAME('WMS', x_msg_data);
1758: FND_MSG_PUB.ADD;
1759: RAISE FND_API.G_exc_unexpected_error;
1760: END IF;
1761:
1762: IF (g_trace_on = 1) THEN mydebug('after pn validations ...:: ' ); END IF;

Line 1858: FND_MSG_PUB.ADD;

1854: IF (l_debug = 1) THEN mydebug('l_return: ' || l_return); END IF;
1855: IF l_return <> 0 THEN
1856: ROLLBACK TO sp_lpn_mass_move;
1857: FND_MESSAGE.SET_NAME('WMS','WMS_TD_TXNMGR_ERROR' );
1858: FND_MSG_PUB.ADD;
1859: RAISE FND_API.g_exc_unexpected_error;
1860: END IF;
1861:
1862: COMMIT;

Line 1871: fnd_msg_pub.count_and_get

1867:
1868: WHEN FND_API.G_EXC_ERROR THEN
1869: ROLLBACK TO sp_lpn_mass_move;
1870: x_return_status:=FND_API.G_RET_STS_ERROR;
1871: fnd_msg_pub.count_and_get
1872: ( p_count => x_msg_count
1873: , p_data => x_msg_data
1874: );
1875:

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

1877: END IF;
1878:
1879: WHEN fnd_api.g_exc_unexpected_error THEN
1880: x_return_status := fnd_api.g_ret_sts_unexp_error;
1881: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1882: IF (g_trace_on = 1) THEN mydebug('Unexpected ROLLBACK ' ); END IF;
1883: ROLLBACK TO sp_lpn_mass_move;
1884:
1885: WHEN OTHERS THEN

Line 1888: fnd_msg_pub.count_and_get

1884:
1885: WHEN OTHERS THEN
1886: ROLLBACK TO sp_lpn_mass_move;
1887: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1888: fnd_msg_pub.count_and_get
1889: ( p_count => x_msg_count
1890: , p_data => x_msg_data
1891: );
1892:

Line 2425: fnd_msg_pub.count_and_get

2421: EXCEPTION
2422:
2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status:=FND_API.G_RET_STS_ERROR;
2425: fnd_msg_pub.count_and_get
2426: ( p_count => x_msg_count
2427: , p_data => x_msg_data
2428: );
2429:

Line 2433: fnd_msg_pub.count_and_get

2429:
2430: WHEN OTHERS THEN
2431:
2432: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2433: fnd_msg_pub.count_and_get
2434: ( p_count => x_msg_count
2435: , p_data => x_msg_data
2436: );
2437:

Line 2596: FND_MSG_PUB.ADD;

2592:
2593: END IF;
2594:
2595: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
2596: FND_MSG_PUB.ADD;
2597: RAISE FND_API.G_exc_unexpected_error;
2598:
2599: END IF;
2600:

Line 2631: FND_MSG_PUB.ADD;

2627: END IF;
2628:
2629: IF p_calling_mode = 'LOAD' THEN
2630: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOADED_ERROR');
2631: FND_MSG_PUB.ADD;
2632: RAISE FND_API.G_exc_unexpected_error;
2633:
2634: ELSE
2635: p_temp_id := l_temp_id;

Line 2674: FND_MSG_PUB.ADD;

2670: END IF;
2671: END IF;
2672:
2673: FND_MESSAGE.SET_NAME('WMS', x_msg_data);
2674: FND_MSG_PUB.ADD;
2675: RAISE FND_API.G_exc_unexpected_error;
2676: END IF;
2677:
2678: IF (g_trace_on = 1) THEN

Line 2732: FND_MSG_PUB.ADD;

2728: END IF;
2729: EXCEPTION
2730: WHEN no_data_found THEN
2731: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_INVALID_LPN');
2732: FND_MSG_PUB.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: END; --End of Fix for bug #4157153.
2735: END;
2736:

Line 2899: fnd_msg_pub.count_and_get

2895:
2896: WHEN FND_API.G_EXC_ERROR THEN
2897: ROLLBACK TO sp_stg_move;
2898: x_return_status:=FND_API.G_RET_STS_ERROR;
2899: fnd_msg_pub.count_and_get
2900: ( p_count => x_msg_count
2901: , p_data => x_msg_data
2902: );
2903: IF (g_trace_on = 1) THEN

Line 2914: fnd_msg_pub.count_and_get

2910: WHEN OTHERS THEN
2911:
2912: ROLLBACK TO sp_stg_move;
2913: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2914: fnd_msg_pub.count_and_get
2915: ( p_count => x_msg_count
2916: , p_data => x_msg_data
2917: );
2918: IF (g_trace_on = 1) THEN