DBA Data[Home] [Help]

APPS.INV_MO_CANCEL_PVT dependencies on FND_MSG_PUB

Line 254: fnd_msg_pub.ADD;

250: ,'CANCEL_MOVE_ORDER_LINE');
251: END IF;
252: fnd_message.set_name('INV','INV_MO_LINE_NOT_FOUND');
253: fnd_message.set_token('LINE_ID',p_line_id);
254: fnd_msg_pub.ADD;
255: RAISE fnd_api.g_exc_error;
256: END IF;
257: CLOSE c_line_info;
258:

Line 345: fnd_msg_pub.ADD;

341: || l_api_return_status
342: ,'CANCEL_MOVE_ORDER_LINE');
343: END IF;
344: fnd_message.set_name('INV','INV_QRY_RSV_FAILED');
345: fnd_msg_pub.ADD;
346: RAISE fnd_api.g_exc_unexpected_error;
347: END IF;
348:
349: IF l_rsv_count <= 0 THEN

Line 355: fnd_msg_pub.ADD;

351: DEBUG('Error: Query Reservations returned Reservation Count 0'
352: ,'CANCEL_MOVE_ORDER_LINE');
353: END IF;
354: fnd_message.set_name('INV','INV_NO_RSVS_FOUND');
355: fnd_msg_pub.ADD;
356: RAISE fnd_api.g_exc_unexpected_error;
357: END IF;
358:
359: l_update_rec := l_rsv_tbl(1);

Line 435: fnd_msg_pub.ADD;

431: || l_api_return_status, 'CANCEL_MOVE_ORDER_LINE');
432: END IF;
433:
434: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
435: fnd_msg_pub.ADD;
436: RAISE fnd_api.g_exc_unexpected_error;
437: END IF;
438: -- }
439: END LOOP;

Line 583: fnd_msg_pub.ADD;

579: DEBUG('Error: Query Reservations returned '
580: || l_api_return_status, 'CANCEL_MOVE_ORDER_LINE');
581: END IF;
582: fnd_message.set_name('INV','INV_QRY_RSV_FAILED');
583: fnd_msg_pub.ADD;
584: RAISE fnd_api.g_exc_unexpected_error;
585: END IF;
586:
587: IF l_rsv_count <= 0

Line 594: fnd_msg_pub.ADD;

590: DEBUG('Error: Query Reservations returned Reservation Count 0'
591: ,'CANCEL_MOVE_ORDER_LINE');
592: END IF;
593: fnd_message.set_name('INV','INV_NO_RSVS_FOUND');
594: fnd_msg_pub.ADD;
595: RAISE fnd_api.g_exc_unexpected_error;
596: END IF;
597:
598: l_update_rec := l_rsv_tbl(1);

Line 754: fnd_msg_pub.ADD;

750: || l_api_return_status, 'CANCEL_MOVE_ORDER_LINE');
751: END IF;
752:
753: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
754: fnd_msg_pub.ADD;
755: RAISE fnd_api.g_exc_unexpected_error;
756: END IF;
757: -- }
758: END IF; -- reservation id is not null

Line 798: fnd_msg_pub.ADD;

794: ,'CANCEL_MOVE_ORDER_LINE');
795: END IF;
796: fnd_message.set_name('INV','INV_DELETE_TXN_FAILED');
797: fnd_message.set_token('TXN_TEMP_ID',l_transaction_temp_id);
798: fnd_msg_pub.ADD;
799: RAISE fnd_api.g_exc_error;
800: END IF;
801: ELSE
802: IF (l_debug = 1) THEN

Line 959: fnd_msg_pub.ADD;

955: WHEN record_locked THEN
956: DEBUG('Unable to lock the putaway MO line'
957: ,'CANCEL_MOVE_ORDER_LINE');
958: fnd_message.set_name('WMS', 'INV_PUTAWAY_MOL_LOCK_FAIL');
959: fnd_msg_pub.ADD;
960: RAISE fnd_api.g_exc_error;
961: END;
962:
963: wms_xdock_utils_pvt.g_demand_triggered := TRUE;

Line 1038: fnd_msg_pub.ADD;

1034: THEN
1035: CLOSE c_xdock_rsv;
1036: END IF;
1037: fnd_message.set_name('WMS', 'INV_RSV_LOCK_FAIL');
1038: fnd_msg_pub.ADD;
1039: RAISE fnd_api.g_exc_error;
1040: END;
1041:
1042: wms_xdock_utils_pvt.g_demand_triggered := TRUE;

Line 1111: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1107: EXCEPTION
1108: WHEN fnd_api.g_exc_error THEN
1109: ROLLBACK TO cancelmo_sp;
1110: wms_xdock_utils_pvt.g_demand_triggered := FALSE;
1111: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1112: p_data => x_msg_data,
1113: p_encoded => 'F');
1114: x_return_status := fnd_api.g_ret_sts_error;
1115:

Line 1125: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1121:
1122: WHEN fnd_api.g_exc_unexpected_error THEN
1123: ROLLBACK TO cancelmo_sp;
1124: wms_xdock_utils_pvt.g_demand_triggered := FALSE;
1125: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1126: p_data => x_msg_data,
1127: p_encoded => 'F');
1128: x_return_status := fnd_api.g_ret_sts_unexp_error;
1129:

Line 1393: fnd_msg_pub.ADD;

1389: IF (l_debug = 1) THEN
1390: DEBUG('Cannot reduce putaway MO line qty','Reduce_Move_Order_Quantity');
1391: END IF;
1392: fnd_message.set_name('WMS', 'INV_MOL_PUTAWAY_QTY_NOCHG');
1393: fnd_msg_pub.ADD;
1394: RAISE fnd_api.g_exc_error;
1395: END IF;
1396:
1397: -- query mo line info

Line 1517: fnd_msg_pub.ADD;

1513:
1514: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1515: fnd_message.set_token('UOM', l_primary_uom_code);
1516: fnd_message.set_token('ROUTINE', 'Reduce Move Order Quantity');
1517: fnd_msg_pub.ADD;
1518: RAISE fnd_api.g_exc_unexpected_error;
1519: END IF;
1520: ELSE
1521: l_prim_quantity_to_delete := l_quantity_to_delete;

Line 1807: fnd_msg_pub.ADD;

1803: THEN
1804: CLOSE c_lock_wdd;
1805: END IF;
1806: fnd_message.set_name('INV', 'INV_WDD_LOCK_FAIL');
1807: fnd_msg_pub.ADD;
1808: fnd_msg_pub.count_and_get
1809: ( p_count => x_msg_count
1810: , p_data => x_msg_data
1811: , p_encoded => 'F'

Line 1808: fnd_msg_pub.count_and_get

1804: CLOSE c_lock_wdd;
1805: END IF;
1806: fnd_message.set_name('INV', 'INV_WDD_LOCK_FAIL');
1807: fnd_msg_pub.ADD;
1808: fnd_msg_pub.count_and_get
1809: ( p_count => x_msg_count
1810: , p_data => x_msg_data
1811: , p_encoded => 'F'
1812: );

Line 1845: fnd_msg_pub.ADD;

1841: THEN
1842: CLOSE c_xdock_rsv;
1843: END IF;
1844: fnd_message.set_name('WMS', 'INV_RSV_LOCK_FAIL');
1845: fnd_msg_pub.ADD;
1846: RAISE fnd_api.g_exc_error;
1847: END;
1848:
1849: wms_xdock_utils_pvt.g_demand_triggered := TRUE;

Line 1893: fnd_msg_pub.ADD;

1889: END IF;
1890: IF x_return_status = fnd_api.g_ret_sts_error
1891: THEN
1892: fnd_message.set_name('INV','INV_QRY_RSV_FAILED');
1893: fnd_msg_pub.ADD;
1894: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1895: p_data => x_msg_data,
1896: p_encoded => 'F');
1897: RAISE fnd_api.g_exc_error;

Line 1894: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1890: IF x_return_status = fnd_api.g_ret_sts_error
1891: THEN
1892: fnd_message.set_name('INV','INV_QRY_RSV_FAILED');
1893: fnd_msg_pub.ADD;
1894: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1895: p_data => x_msg_data,
1896: p_encoded => 'F');
1897: RAISE fnd_api.g_exc_error;
1898: ELSE

Line 1909: fnd_msg_pub.ADD;

1905: DEBUG('Error: Query Reservations returned Reservation Count 0'
1906: ,'Reduce_Move_Order_Quantity');
1907: END IF;
1908: fnd_message.set_name('INV','INV_NO_RSVS_FOUND');
1909: fnd_msg_pub.ADD;
1910:
1911: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1912: p_data => x_msg_data,
1913: p_encoded => 'F');

Line 1911: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1907: END IF;
1908: fnd_message.set_name('INV','INV_NO_RSVS_FOUND');
1909: fnd_msg_pub.ADD;
1910:
1911: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1912: p_data => x_msg_data,
1913: p_encoded => 'F');
1914: RAISE fnd_api.g_exc_error;
1915: END IF;

Line 2043: fnd_msg_pub.ADD;

2039: END IF;
2040: IF x_return_status = fnd_api.g_ret_sts_error
2041: THEN
2042: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
2043: fnd_msg_pub.ADD;
2044: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2045: p_data => x_msg_data,
2046: p_encoded => 'F');
2047: RAISE fnd_api.g_exc_error;

Line 2044: fnd_msg_pub.count_and_get(p_count => x_msg_count,

2040: IF x_return_status = fnd_api.g_ret_sts_error
2041: THEN
2042: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
2043: fnd_msg_pub.ADD;
2044: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2045: p_data => x_msg_data,
2046: p_encoded => 'F');
2047: RAISE fnd_api.g_exc_error;
2048: ELSE

Line 2158: fnd_msg_pub.count_and_get

2154: END IF;
2155:
2156: IF x_return_status = fnd_api.g_ret_sts_error
2157: THEN
2158: fnd_msg_pub.count_and_get
2159: ( p_count => x_msg_count
2160: , p_data => x_msg_data
2161: , p_encoded => 'F'
2162: );

Line 2202: fnd_msg_pub.count_and_get

2198: WHEN fnd_api.g_exc_error THEN
2199: ROLLBACK TO reducemo_sp;
2200: wms_xdock_utils_pvt.g_demand_triggered := FALSE;
2201: x_return_status := fnd_api.g_ret_sts_error;
2202: fnd_msg_pub.count_and_get
2203: ( p_count => x_msg_count
2204: , p_data => x_msg_data
2205: , p_encoded => 'F'
2206: );

Line 2342: fnd_msg_pub.ADD;

2338:
2339: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2340: fnd_message.set_token('UOM', l_primary_uom_code);
2341: fnd_message.set_token('ROUTINE', 'reduce_rsv_allocation');
2342: fnd_msg_pub.ADD;
2343: RAISE fnd_api.g_exc_unexpected_error;
2344: END IF;
2345: ELSE
2346: l_prim_quantity_to_delete := l_quantity_to_delete;

Line 2583: fnd_msg_pub.ADD;

2579: DEBUG('can not find move order line', 'update_mol_carton_group');
2580: END IF;
2581:
2582: fnd_message.set_name('INV', 'INV_PP_INPUT_LINE_NOT_FOUND');
2583: fnd_msg_pub.ADD;
2584: END IF;
2585:
2586: IF (l_debug = 1) THEN
2587: DEBUG('after update statement', 'update_mol_carton_group');

Line 2604: fnd_msg_pub.ADD;

2600: DEBUG('Exception: ' || sqlerrm, 'update_mol_carton_group');
2601: END IF;
2602:
2603: fnd_message.set_name('INV', 'FAIL_TO_UPDATE_CARTON_GROUP'); -- need new msg
2604: fnd_msg_pub.ADD;
2605: END update_mol_carton_group;
2606:
2607: END inv_mo_cancel_pvt;