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 957: fnd_msg_pub.ADD;

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

Line 1036: fnd_msg_pub.ADD;

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

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

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

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

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

Line 1394: fnd_msg_pub.ADD;

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

Line 1522: fnd_msg_pub.ADD;

1518:
1519: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
1520: fnd_message.set_token('UOM', l_primary_uom_code);
1521: fnd_message.set_token('ROUTINE', 'Reduce Move Order Quantity');
1522: fnd_msg_pub.ADD;
1523: RAISE fnd_api.g_exc_unexpected_error;
1524: END IF;
1525: ELSE
1526: l_prim_quantity_to_delete := l_quantity_to_delete;

Line 1822: fnd_msg_pub.ADD;

1818: THEN
1819: CLOSE c_lock_wdd;
1820: END IF;
1821: fnd_message.set_name('INV', 'INV_WDD_LOCK_FAIL');
1822: fnd_msg_pub.ADD;
1823: fnd_msg_pub.count_and_get
1824: ( p_count => x_msg_count
1825: , p_data => x_msg_data
1826: , p_encoded => 'F'

Line 1823: fnd_msg_pub.count_and_get

1819: CLOSE c_lock_wdd;
1820: END IF;
1821: fnd_message.set_name('INV', 'INV_WDD_LOCK_FAIL');
1822: fnd_msg_pub.ADD;
1823: fnd_msg_pub.count_and_get
1824: ( p_count => x_msg_count
1825: , p_data => x_msg_data
1826: , p_encoded => 'F'
1827: );

Line 1860: fnd_msg_pub.ADD;

1856: THEN
1857: CLOSE c_xdock_rsv;
1858: END IF;
1859: fnd_message.set_name('WMS', 'INV_RSV_LOCK_FAIL');
1860: fnd_msg_pub.ADD;
1861: RAISE fnd_api.g_exc_error;
1862: END;
1863:
1864: wms_xdock_utils_pvt.g_demand_triggered := TRUE;

Line 1908: fnd_msg_pub.ADD;

1904: END IF;
1905: IF x_return_status = fnd_api.g_ret_sts_error
1906: THEN
1907: fnd_message.set_name('INV','INV_QRY_RSV_FAILED');
1908: fnd_msg_pub.ADD;
1909: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1910: p_data => x_msg_data,
1911: p_encoded => 'F');
1912: RAISE fnd_api.g_exc_error;

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

1905: IF x_return_status = fnd_api.g_ret_sts_error
1906: THEN
1907: fnd_message.set_name('INV','INV_QRY_RSV_FAILED');
1908: fnd_msg_pub.ADD;
1909: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1910: p_data => x_msg_data,
1911: p_encoded => 'F');
1912: RAISE fnd_api.g_exc_error;
1913: ELSE

Line 1924: fnd_msg_pub.ADD;

1920: DEBUG('Error: Query Reservations returned Reservation Count 0'
1921: ,'Reduce_Move_Order_Quantity');
1922: END IF;
1923: fnd_message.set_name('INV','INV_NO_RSVS_FOUND');
1924: fnd_msg_pub.ADD;
1925:
1926: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1927: p_data => x_msg_data,
1928: p_encoded => 'F');

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

1922: END IF;
1923: fnd_message.set_name('INV','INV_NO_RSVS_FOUND');
1924: fnd_msg_pub.ADD;
1925:
1926: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1927: p_data => x_msg_data,
1928: p_encoded => 'F');
1929: RAISE fnd_api.g_exc_error;
1930: END IF;

Line 2058: fnd_msg_pub.ADD;

2054: END IF;
2055: IF x_return_status = fnd_api.g_ret_sts_error
2056: THEN
2057: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
2058: fnd_msg_pub.ADD;
2059: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2060: p_data => x_msg_data,
2061: p_encoded => 'F');
2062: RAISE fnd_api.g_exc_error;

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

2055: IF x_return_status = fnd_api.g_ret_sts_error
2056: THEN
2057: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
2058: fnd_msg_pub.ADD;
2059: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2060: p_data => x_msg_data,
2061: p_encoded => 'F');
2062: RAISE fnd_api.g_exc_error;
2063: ELSE

Line 2173: fnd_msg_pub.count_and_get

2169: END IF;
2170:
2171: IF x_return_status = fnd_api.g_ret_sts_error
2172: THEN
2173: fnd_msg_pub.count_and_get
2174: ( p_count => x_msg_count
2175: , p_data => x_msg_data
2176: , p_encoded => 'F'
2177: );

Line 2217: fnd_msg_pub.count_and_get

2213: WHEN fnd_api.g_exc_error THEN
2214: ROLLBACK TO reducemo_sp;
2215: wms_xdock_utils_pvt.g_demand_triggered := FALSE;
2216: x_return_status := fnd_api.g_ret_sts_error;
2217: fnd_msg_pub.count_and_get
2218: ( p_count => x_msg_count
2219: , p_data => x_msg_data
2220: , p_encoded => 'F'
2221: );

Line 2357: fnd_msg_pub.ADD;

2353:
2354: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2355: fnd_message.set_token('UOM', l_primary_uom_code);
2356: fnd_message.set_token('ROUTINE', 'reduce_rsv_allocation');
2357: fnd_msg_pub.ADD;
2358: RAISE fnd_api.g_exc_unexpected_error;
2359: END IF;
2360: ELSE
2361: l_prim_quantity_to_delete := l_quantity_to_delete;

Line 2598: fnd_msg_pub.ADD;

2594: DEBUG('can not find move order line', 'update_mol_carton_group');
2595: END IF;
2596:
2597: fnd_message.set_name('INV', 'INV_PP_INPUT_LINE_NOT_FOUND');
2598: fnd_msg_pub.ADD;
2599: END IF;
2600:
2601: IF (l_debug = 1) THEN
2602: DEBUG('after update statement', 'update_mol_carton_group');

Line 2619: fnd_msg_pub.ADD;

2615: DEBUG('Exception: ' || sqlerrm, 'update_mol_carton_group');
2616: END IF;
2617:
2618: fnd_message.set_name('INV', 'FAIL_TO_UPDATE_CARTON_GROUP'); -- need new msg
2619: fnd_msg_pub.ADD;
2620: END update_mol_carton_group;
2621:
2622: END inv_mo_cancel_pvt;