DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on FND_MSG_PUB

Line 208: FND_MSG_PUB.Add;

204: l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(l_oe_header_id);
205:
206: IF l_mso_header_id IS NULL THEN
207: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
208: FND_MSG_PUB.Add;
209: RAISE fnd_api.g_exc_unexpected_error;
210: END IF;
211:
212: -- get data for p_missing_quantity

Line 287: fnd_msg_pub.count_and_get

283: , l_item_id
284: , l_revision
285: , l_lot
286: );
287: fnd_msg_pub.count_and_get
288: ( p_count => l_msg_count
289: , p_data => l_msg_data
290: );
291:

Line 306: l_msg_data := fnd_msg_pub.get(I,'F');

302: IF (l_debug = 1) THEN
303: mdebug('Not Successful2');
304: END IF;
305: For I in 1..l_msg_count LOOP
306: l_msg_data := fnd_msg_pub.get(I,'F');
307: IF (l_debug = 1) THEN
308: mdebug(replace(l_msg_data,chr(0),' '));
309: END IF;
310: END LOOP;

Line 316: FND_MSG_PUB.Add_Exc_Msg

312:
313:
314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
315: -- mdebug('FE');
316: FND_MSG_PUB.Add_Exc_Msg
317: ( 'Inadequate Qty'
318: , 'Calling Log Exception'
319: );
320: RAISE FND_API.G_EXC_ERROR;

Line 325: FND_MSG_PUB.Add_Exc_Msg

321: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
322: IF (l_debug = 1) THEN
323: mdebug('SE');
324: END IF;
325: FND_MSG_PUB.Add_Exc_Msg
326: ( 'Inadequate Qty'
327: , 'Calling Log Exception'
328: );
329: RAISE FND_API.G_EXC_ERROR;

Line 338: fnd_msg_pub.count_and_get

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

Line 347: fnd_msg_pub.count_and_get

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

Line 1028: --FND_MSG_PUB.ADD;

1024: end if;
1025: -- ??? should we raise exception????
1026: --FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1027: --FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1028: --FND_MSG_PUB.ADD;
1029: --RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: mdebug('after calling quantity tree ARI, l_atr:'||l_atr);
1032: mdebug('after calling quantity tree ARI, l_satr:'||l_satr);

Line 1129: --FND_MSG_PUB.ADD;

1125: end if;
1126: -- ??? should we raise exception????
1127: --FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
1128: --FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
1129: --FND_MSG_PUB.ADD;
1130: --RAISE FND_API.G_EXC_ERROR;
1131: END IF;
1132: mdebug('after calling quantity tree ARI, l_atr:'||l_atr);
1133: mdebug('after calling quantity tree ARI, l_satr:'||l_satr);

Line 1396: fnd_msg_pub.count_and_get

1392: AND line_id = l_line_num;
1393: --bug3278170
1394: END IF;
1395:
1396: fnd_msg_pub.count_and_get
1397: ( p_count => l_msg_count
1398: , p_data => l_msg_data
1399: );
1400:

Line 1409: l_msg_data := fnd_msg_pub.get(I,'F');

1405: mdebug(replace(l_msg_data,chr(0),' '));
1406: ELSE
1407: mdebug('Not Successful2');
1408: For I in 1..l_msg_count LOOP
1409: l_msg_data := fnd_msg_pub.get(I,'F');
1410: mdebug(replace(l_msg_data,chr(0),' '));
1411: END LOOP;
1412: END IF;
1413:

Line 1416: FND_MSG_PUB.Add_Exc_Msg

1412: END IF;
1413:
1414:
1415: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1416: FND_MSG_PUB.Add_Exc_Msg
1417: ( 'Suggest Alt Loc'
1418: , 'Call Pick Release'
1419: );
1420: RAISE FND_API.G_EXC_ERROR;

Line 1422: FND_MSG_PUB.Add_Exc_Msg

1418: , 'Call Pick Release'
1419: );
1420: RAISE FND_API.G_EXC_ERROR;
1421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1422: FND_MSG_PUB.Add_Exc_Msg
1423: ( 'Suggest Alt Loc'
1424: , 'Call Pick Release'
1425: );
1426: RAISE FND_API.G_EXC_ERROR;

Line 1438: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1434:
1435: Raise FND_API.G_EXC_ERROR;
1436:
1437: WHEN OTHERS THEN
1438: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1439: THEN
1440: FND_MSG_PUB.Add_Exc_Msg
1441: ( 'INV_Move_Order_PUB'
1442: , 'Create_Move_Orders'

Line 1440: FND_MSG_PUB.Add_Exc_Msg

1436:
1437: WHEN OTHERS THEN
1438: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1439: THEN
1440: FND_MSG_PUB.Add_Exc_Msg
1441: ( 'INV_Move_Order_PUB'
1442: , 'Create_Move_Orders'
1443: );
1444: END IF;

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

1695: mdebug('END : ' || l_proc_name );
1696: EXCEPTION
1697: WHEN fnd_api.g_exc_error THEN
1698: x_return_status := l_g_ret_sts_error;
1699: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1700: mdebug('ROLLBACK ' );
1701: ROLLBACK ;
1702: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
1703: WHEN OTHERS THEN

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

1701: ROLLBACK ;
1702: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
1703: WHEN OTHERS THEN
1704: x_return_status := l_g_ret_sts_unexp_error;
1705: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1706: mdebug('ROLLBACK ' );
1707: ROLLBACK ;
1708: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
1709:

Line 1931: fnd_msg_pub.ADD;

1927:
1928: IF (l_debug = 1) THEN mdebug('x_return_status = ' || x_return_status); END IF;
1929: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1930: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
1931: fnd_msg_pub.ADD;
1932: RAISE fnd_api.g_exc_unexpected_error;
1933: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1934: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
1935: fnd_msg_pub.ADD;

Line 1935: fnd_msg_pub.ADD;

1931: fnd_msg_pub.ADD;
1932: RAISE fnd_api.g_exc_unexpected_error;
1933: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1934: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
1935: fnd_msg_pub.ADD;
1936: RAISE fnd_api.g_exc_error;
1937: END IF;
1938: -- MRANA : added the following 3392471 . : 26-feb-04
1939: -- Cascade delete the current MMTT and WDT That was just processed

Line 2244: fnd_msg_pub.ADD;

2240: , p_user_id => p_employee_id);
2241:
2242: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2243: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2244: fnd_msg_pub.ADD;
2245: RAISE fnd_api.g_exc_unexpected_error;
2246: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2247: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2248: fnd_msg_pub.ADD;

Line 2248: fnd_msg_pub.ADD;

2244: fnd_msg_pub.ADD;
2245: RAISE fnd_api.g_exc_unexpected_error;
2246: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2247: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2248: fnd_msg_pub.ADD;
2249: RAISE fnd_api.g_exc_error;
2250: END IF;
2251:
2252: l_progress := '390';

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

2285: mdebug('END : ' || l_proc_name );
2286: EXCEPTION
2287: WHEN fnd_api.g_exc_error THEN
2288: x_return_status := l_g_ret_sts_error;
2289: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2290: mdebug('ROLLBACK ' );
2291: ROLLBACK ;
2292: mdebug('l_progress = ' || l_proc_name || ':'|| l_progress);
2293: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);

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

2292: mdebug('l_progress = ' || l_proc_name || ':'|| l_progress);
2293: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
2294: WHEN OTHERS THEN
2295: x_return_status := l_g_ret_sts_unexp_error;
2296: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2297: mdebug('ROLLBACK ' );
2298: ROLLBACK ;
2299: mdebug('l_progress = ' || l_proc_name || ':'|| l_progress);
2300: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);