DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on FND_MSG_PUB

Line 210: FND_MSG_PUB.Add;

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

Line 289: fnd_msg_pub.count_and_get

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

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

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

Line 318: FND_MSG_PUB.Add_Exc_Msg

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

Line 327: FND_MSG_PUB.Add_Exc_Msg

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

Line 340: fnd_msg_pub.count_and_get

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

Line 349: fnd_msg_pub.count_and_get

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

Line 1872: fnd_msg_pub.count_and_get

1868: AND line_id = l_line_num;
1869: --bug3278170
1870: END IF;
1871:
1872: fnd_msg_pub.count_and_get
1873: ( p_count => l_msg_count
1874: , p_data => l_msg_data
1875: );
1876:

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

1881: mdebug(replace(l_msg_data,chr(0),' '));
1882: ELSE
1883: mdebug('Not Successful2');
1884: For I in 1..l_msg_count LOOP
1885: l_msg_data := fnd_msg_pub.get(I,'F');
1886: mdebug(replace(l_msg_data,chr(0),' '));
1887: END LOOP;
1888: END IF;
1889:

Line 1892: FND_MSG_PUB.Add_Exc_Msg

1888: END IF;
1889:
1890:
1891: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1892: FND_MSG_PUB.Add_Exc_Msg
1893: ( 'Suggest Alt Loc'
1894: , 'Call Pick Release'
1895: );
1896: RAISE FND_API.G_EXC_ERROR;

Line 1898: FND_MSG_PUB.Add_Exc_Msg

1894: , 'Call Pick Release'
1895: );
1896: RAISE FND_API.G_EXC_ERROR;
1897: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1898: FND_MSG_PUB.Add_Exc_Msg
1899: ( 'Suggest Alt Loc'
1900: , 'Call Pick Release'
1901: );
1902: RAISE FND_API.G_EXC_ERROR;

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

1910:
1911: Raise FND_API.G_EXC_ERROR;
1912:
1913: WHEN OTHERS THEN
1914: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1915: THEN
1916: FND_MSG_PUB.Add_Exc_Msg
1917: ( 'INV_Move_Order_PUB'
1918: , 'Create_Move_Orders'

Line 1916: FND_MSG_PUB.Add_Exc_Msg

1912:
1913: WHEN OTHERS THEN
1914: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1915: THEN
1916: FND_MSG_PUB.Add_Exc_Msg
1917: ( 'INV_Move_Order_PUB'
1918: , 'Create_Move_Orders'
1919: );
1920: END IF;

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

2226: mdebug('END : ' || l_proc_name );
2227: EXCEPTION
2228: WHEN fnd_api.g_exc_error THEN
2229: x_return_status := l_g_ret_sts_error;
2230: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2231: mdebug('ROLLBACK ' );
2232: ROLLBACK ;
2233: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
2234: WHEN OTHERS THEN

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

2232: ROLLBACK ;
2233: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
2234: WHEN OTHERS THEN
2235: x_return_status := l_g_ret_sts_unexp_error;
2236: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2237: mdebug('ROLLBACK ' );
2238: ROLLBACK ;
2239: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
2240:

Line 2489: fnd_msg_pub.ADD;

2485:
2486: IF (l_debug = 1) THEN mdebug('x_return_status = ' || x_return_status); END IF;
2487: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2488: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
2489: fnd_msg_pub.ADD;
2490: RAISE fnd_api.g_exc_unexpected_error;
2491: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2492: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
2493: fnd_msg_pub.ADD;

Line 2493: fnd_msg_pub.ADD;

2489: fnd_msg_pub.ADD;
2490: RAISE fnd_api.g_exc_unexpected_error;
2491: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2492: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
2493: fnd_msg_pub.ADD;
2494: RAISE fnd_api.g_exc_error;
2495: END IF;
2496: -- MRANA : added the following 3392471 . : 26-feb-04
2497: -- Cascade delete the current MMTT and WDT That was just processed

Line 2880: fnd_msg_pub.ADD;

2876: , p_user_id => p_employee_id);
2877:
2878: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2879: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2880: fnd_msg_pub.ADD;
2881: RAISE fnd_api.g_exc_unexpected_error;
2882: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2883: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2884: fnd_msg_pub.ADD;

Line 2884: fnd_msg_pub.ADD;

2880: fnd_msg_pub.ADD;
2881: RAISE fnd_api.g_exc_unexpected_error;
2882: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2883: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
2884: fnd_msg_pub.ADD;
2885: RAISE fnd_api.g_exc_error;
2886: END IF;
2887:
2888: l_progress := '390';

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

2921: mdebug('END : ' || l_proc_name );
2922: EXCEPTION
2923: WHEN fnd_api.g_exc_error THEN
2924: x_return_status := l_g_ret_sts_error;
2925: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2926: mdebug('ROLLBACK ' );
2927: ROLLBACK ;
2928: mdebug('l_progress = ' || l_proc_name || ':'|| l_progress);
2929: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);

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

2928: mdebug('l_progress = ' || l_proc_name || ':'|| l_progress);
2929: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);
2930: WHEN OTHERS THEN
2931: x_return_status := l_g_ret_sts_unexp_error;
2932: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2933: mdebug('ROLLBACK ' );
2934: ROLLBACK ;
2935: mdebug('l_progress = ' || l_proc_name || ':'|| l_progress);
2936: mdebug('RAISE fnd_api.g_exc_error: ' || SQLERRM);