DBA Data[Home] [Help]

APPS.WMS_RCV_PUP_PVT dependencies on FND_MSG_PUB

Line 516: fnd_msg_pub.ADD;

512: IF (l_debug = 1) THEN
513: print_debug('INSERT_LOT_SERIAL: ERROR - insert_mtli Fail');
514: END IF;
515: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
516: fnd_msg_pub.ADD;
517: RAISE fnd_api.g_exc_error;
518: END IF;
519:
520: /* Check if there are msnt associated with this mtlt */

Line 702: fnd_msg_pub.ADD;

698: IF (l_debug = 1) THEN
699: print_debug('INSERT_LOT_SERIAL: ERROR - insert_msni Fail');
700: END IF;
701: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
702: fnd_msg_pub.ADD;
703: RAISE fnd_api.g_exc_error;
704: END IF;
705:
706: END LOOP;

Line 713: fnd_msg_pub.count_and_get

709: RETURN l_intf_id;
710: EXCEPTION
711: WHEN fnd_api.g_exc_error THEN
712: x_return_status := fnd_api.g_ret_sts_error;
713: fnd_msg_pub.count_and_get
714: ( p_count => x_msg_count
715: ,p_data => x_msg_data );
716: IF (l_debug = 1) THEN
717: print_debug('INSERT_LOT_SERIAL: Exception occured');

Line 721: fnd_msg_pub.count_and_get

717: print_debug('INSERT_LOT_SERIAL: Exception occured');
718: END IF;
719: WHEN OTHERS THEN
720: x_return_status:=g_ret_sts_unexp_err;
721: fnd_msg_pub.count_and_get
722: ( p_count => x_msg_count
723: ,p_data => x_msg_data );
724: IF (l_debug = 1) THEN
725: print_debug('INSERT_LOT_SERIAL: Exception occured');

Line 863: fnd_msg_pub.count_and_get

859:
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_msg_pub.count_and_get
864: ( p_count => x_msg_count
865: ,p_data => x_msg_data );
866: IF (l_debug = 1) THEN
867: print_debug('ABORT_MMTTS: Exception occured');

Line 872: fnd_msg_pub.count_and_get

868: END IF;
869:
870: WHEN OTHERS THEN
871: x_return_status:=g_ret_sts_unexp_err;
872: fnd_msg_pub.count_and_get
873: ( p_count => x_msg_count
874: ,p_data => x_msg_data );
875: IF (l_debug = 1) THEN
876: print_debug('ABORT_MMTTS: Exception occured');

Line 1227: fnd_msg_pub.ADD;

1223: IF (l_debug = 1) THEN
1224: print_debug('PACK_UNPACK_SPLIT: abort_mmtts failed');
1225: END IF;
1226: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1227: fnd_msg_pub.ADD;
1228: RAISE fnd_api.g_exc_error;
1229: END IF;
1230: l_progress := '1.1.1';
1231:

Line 1260: fnd_msg_pub.ADD;

1256: IF (l_debug = 1) THEN
1257: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_rti Fail');
1258: END IF;
1259: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1260: fnd_msg_pub.ADD;
1261: RAISE fnd_api.g_exc_error;
1262: END IF;
1263:
1264: l_progress := '1.1.2';

Line 1332: fnd_msg_pub.ADD;

1328: IF (l_debug = 1) THEN
1329: print_debug('PACK_UNPACK_SPLIT: ERROR - Abort MMTTs Fail');
1330: END IF;
1331: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1332: fnd_msg_pub.ADD;
1333: RAISE fnd_api.g_exc_error;
1334: END IF;
1335:
1336: l_progress := '2.1.1';

Line 1364: fnd_msg_pub.ADD;

1360: IF (l_debug = 1) THEN
1361: print_debug('ERROR: insert_rti Fail');
1362: END IF;
1363: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1364: fnd_msg_pub.ADD;
1365: RAISE fnd_api.g_exc_error;
1366: END IF;
1367:
1368: l_progress := '2.1.2';

Line 1451: fnd_msg_pub.ADD;

1447: IF (l_debug = 1) THEN
1448: print_debug('PACK_UNPACK_SPLIT: ERROR - packunpack_container Fail');
1449: END IF;
1450: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_PACK_UPDATE_ERR');
1451: fnd_msg_pub.ADD;
1452: RAISE fnd_api.g_exc_error;
1453: END IF;
1454:
1455:

Line 1486: fnd_msg_pub.ADD;

1482: IF (l_debug = 1) THEN
1483: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts Fail');
1484: END IF;
1485: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1486: fnd_msg_pub.ADD;
1487: RAISE fnd_api.g_exc_error;
1488: END IF;
1489:
1490: l_progress := '3.1.1';

Line 1518: fnd_msg_pub.ADD;

1514: IF (l_debug = 1) THEN
1515: print_debug('ERROR: insert_rti Fail');
1516: END IF;
1517: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1518: fnd_msg_pub.ADD;
1519: RAISE fnd_api.g_exc_error;
1520: END IF;
1521:
1522: l_progress := '3.1.2';

Line 1590: fnd_msg_pub.ADD;

1586: IF (l_debug = 1) THEN
1587: print_debug('PACK_UNPACK_SPLIT: packunpack_container Fail');
1588: END IF;
1589: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_UNPACK_UPDATE_ERR');
1590: fnd_msg_pub.ADD;
1591: RAISE fnd_api.g_exc_error;
1592: END IF;
1593:
1594: l_progress := '3.2.1';

Line 1621: fnd_msg_pub.ADD;

1617: );
1618: IF (x_return_status <> g_ret_sts_success) THEN
1619: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts Fail');
1620: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1621: fnd_msg_pub.ADD;
1622: RAISE fnd_api.g_exc_error;
1623: END IF;
1624:
1625: l_progress := '4.1.1';

Line 1653: fnd_msg_pub.ADD;

1649: IF (l_debug = 1 ) THEN
1650: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_rti FAIL');
1651: END IF;
1652: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1653: fnd_msg_pub.ADD;
1654: RAISE fnd_api.g_exc_error;
1655: END IF;
1656:
1657: l_progress := '4.1.2';

Line 1724: fnd_msg_pub.ADD;

1720: IF (l_debug = 1) THEN
1721: print_debug('PACK_UNPACK_SPLIT: ERROR - packunpack_container Fail');
1722: END IF;
1723: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_UNPACK_UPDATE_ERR');
1724: fnd_msg_pub.ADD;
1725: RAISE fnd_api.g_exc_error;
1726: END IF;
1727:
1728: l_progress := '4.2.1';

Line 1771: fnd_msg_pub.ADD;

1767: IF (l_debug = 1) THEN
1768: print_debug('PACK_UNPACK_SPLIT: ERROR: packunpack_container Fail', 9);
1769: END IF;
1770: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_PACK_UPDATE_ERR');
1771: fnd_msg_pub.ADD;
1772: RAISE fnd_api.g_exc_error;
1773: END IF;
1774:
1775: l_progress := '2.2.1';

Line 1800: fnd_msg_pub.ADD;

1796: IF (l_debug = 1) THEN
1797: print_debug('PACK_UNPACK_SPLIT: ERROR: abort_mmtts FAIL', 9);
1798: END IF;
1799: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1800: fnd_msg_pub.ADD;
1801: RAISE fnd_api.g_exc_error;
1802: END IF;
1803:
1804: l_mo_splt_tb(1).prim_qty := l_tmp_mmtt_rec.primary_quantity;

Line 1825: fnd_msg_pub.ADD;

1821: IF (l_debug = 1) THEN
1822: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
1823: END IF;
1824: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
1825: fnd_msg_pub.ADD;
1826: RAISE fnd_api.g_exc_error;
1827: END IF;
1828:
1829: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 1990: fnd_msg_pub.ADD;

1986: IF (l_debug = 1) THEN
1987: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
1988: END IF;
1989: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
1990: fnd_msg_pub.ADD;
1991: RAISE fnd_api.g_exc_error;
1992: END IF;
1993:
1994: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 2032: fnd_msg_pub.ADD;

2028: IF (l_debug = 1) THEN
2029: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL', 9);
2030: END IF;
2031: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2032: fnd_msg_pub.ADD;
2033: RAISE fnd_api.g_exc_error;
2034: END IF;
2035:
2036: l_progress := '6.1.3';

Line 2173: fnd_msg_pub.ADD;

2169: IF (l_debug = 1) THEN
2170: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
2171: END IF;
2172: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2173: fnd_msg_pub.ADD;
2174: RAISE fnd_api.g_exc_error;
2175: END IF;
2176:
2177: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 2221: fnd_msg_pub.ADD;

2217: IF (l_debug = 1) THEN
2218: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL', 9);
2219: END IF;
2220: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2221: fnd_msg_pub.ADD;
2222: RAISE fnd_api.g_exc_error;
2223: END IF;
2224:
2225: l_progress := '6.2.2.5';

Line 2601: fnd_msg_pub.ADD;

2597: IF (l_debug = 1) THEN
2598: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL');
2599: END IF;
2600: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2601: fnd_msg_pub.ADD;
2602: RAISE fnd_api.g_exc_error;
2603: END IF;
2604:
2605: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 2647: fnd_msg_pub.ADD;

2643: IF (l_debug = 1) THEN
2644: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL');
2645: END IF;
2646: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2647: fnd_msg_pub.ADD;
2648: RAISE fnd_api.g_exc_error;
2649: END IF;
2650:
2651: l_progress := '7.1.3';

Line 2763: fnd_msg_pub.ADD;

2759: IF (l_debug = 1) THEN
2760: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL');
2761: END IF;
2762: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2763: fnd_msg_pub.ADD;
2764: RAISE fnd_api.g_exc_error;
2765: END IF;
2766:
2767: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 3041: fnd_msg_pub.ADD;

3037: END IF;
3038: END IF; -- End sub/loc test
3039: ELSE
3040: fnd_message.set_name('INV', 'INV_INVALID_TXN_TYPE');
3041: fnd_msg_pub.ADD;
3042: RAISE fnd_api.g_exc_error;
3043: END IF; -- End txn_type test
3044:
3045:

Line 3150: fnd_msg_pub.ADD;

3146:
3147: inv_rcv_common_apis.g_po_startup_value.transaction_mode
3148: := l_txn_mode_code;
3149: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
3150: fnd_msg_pub.ADD;
3151: x_return_status := g_ret_sts_unexp_err ;
3152: fnd_msg_pub.count_and_get
3153: ( p_count => x_msg_count
3154: , p_data => x_msg_data

Line 3152: fnd_msg_pub.count_and_get

3148: := l_txn_mode_code;
3149: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
3150: fnd_msg_pub.ADD;
3151: x_return_status := g_ret_sts_unexp_err ;
3152: fnd_msg_pub.count_and_get
3153: ( p_count => x_msg_count
3154: , p_data => x_msg_data
3155: );
3156: RETURN;

Line 3183: fnd_msg_pub.count_and_get

3179: CLOSE tmp_mmtt_cur_by_txn_id;
3180: END IF;
3181:
3182: x_return_status := g_ret_sts_unexp_err ;
3183: fnd_msg_pub.count_and_get
3184: ( p_count => x_msg_count
3185: , p_data => x_msg_data
3186: );
3187: ROLLBACK TO pack_unpack_split_pub;

Line 3203: fnd_msg_pub.count_and_get

3199: CLOSE tmp_mmtt_cur_by_txn_id;
3200: END IF;
3201:
3202: x_return_status := g_ret_sts_unexp_err;
3203: fnd_msg_pub.count_and_get
3204: ( p_count => x_msg_count
3205: , p_data => x_msg_data
3206: );
3207: ROLLBACK TO pack_unpack_split_pub;