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

1183: IF (l_debug = 1) THEN
1184: print_debug('PACK_UNPACK_SPLIT: abort_mmtts failed');
1185: END IF;
1186: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1187: fnd_msg_pub.ADD;
1188: RAISE fnd_api.g_exc_error;
1189: END IF;
1190: l_progress := '1.1.1';
1191:

Line 1220: fnd_msg_pub.ADD;

1216: IF (l_debug = 1) THEN
1217: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_rti Fail');
1218: END IF;
1219: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1220: fnd_msg_pub.ADD;
1221: RAISE fnd_api.g_exc_error;
1222: END IF;
1223:
1224: l_progress := '1.1.2';

Line 1292: fnd_msg_pub.ADD;

1288: IF (l_debug = 1) THEN
1289: print_debug('PACK_UNPACK_SPLIT: ERROR - Abort MMTTs Fail');
1290: END IF;
1291: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1292: fnd_msg_pub.ADD;
1293: RAISE fnd_api.g_exc_error;
1294: END IF;
1295:
1296: l_progress := '2.1.1';

Line 1324: fnd_msg_pub.ADD;

1320: IF (l_debug = 1) THEN
1321: print_debug('ERROR: insert_rti Fail');
1322: END IF;
1323: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1324: fnd_msg_pub.ADD;
1325: RAISE fnd_api.g_exc_error;
1326: END IF;
1327:
1328: l_progress := '2.1.2';

Line 1411: fnd_msg_pub.ADD;

1407: IF (l_debug = 1) THEN
1408: print_debug('PACK_UNPACK_SPLIT: ERROR - packunpack_container Fail');
1409: END IF;
1410: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_PACK_UPDATE_ERR');
1411: fnd_msg_pub.ADD;
1412: RAISE fnd_api.g_exc_error;
1413: END IF;
1414:
1415:

Line 1446: fnd_msg_pub.ADD;

1442: IF (l_debug = 1) THEN
1443: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts Fail');
1444: END IF;
1445: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1446: fnd_msg_pub.ADD;
1447: RAISE fnd_api.g_exc_error;
1448: END IF;
1449:
1450: l_progress := '3.1.1';

Line 1478: fnd_msg_pub.ADD;

1474: IF (l_debug = 1) THEN
1475: print_debug('ERROR: insert_rti Fail');
1476: END IF;
1477: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1478: fnd_msg_pub.ADD;
1479: RAISE fnd_api.g_exc_error;
1480: END IF;
1481:
1482: l_progress := '3.1.2';

Line 1550: fnd_msg_pub.ADD;

1546: IF (l_debug = 1) THEN
1547: print_debug('PACK_UNPACK_SPLIT: packunpack_container Fail');
1548: END IF;
1549: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_UNPACK_UPDATE_ERR');
1550: fnd_msg_pub.ADD;
1551: RAISE fnd_api.g_exc_error;
1552: END IF;
1553:
1554: l_progress := '3.2.1';

Line 1581: fnd_msg_pub.ADD;

1577: );
1578: IF (x_return_status <> g_ret_sts_success) THEN
1579: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts Fail');
1580: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1581: fnd_msg_pub.ADD;
1582: RAISE fnd_api.g_exc_error;
1583: END IF;
1584:
1585: l_progress := '4.1.1';

Line 1613: fnd_msg_pub.ADD;

1609: IF (l_debug = 1 ) THEN
1610: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_rti FAIL');
1611: END IF;
1612: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1613: fnd_msg_pub.ADD;
1614: RAISE fnd_api.g_exc_error;
1615: END IF;
1616:
1617: l_progress := '4.1.2';

Line 1684: fnd_msg_pub.ADD;

1680: IF (l_debug = 1) THEN
1681: print_debug('PACK_UNPACK_SPLIT: ERROR - packunpack_container Fail');
1682: END IF;
1683: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_UNPACK_UPDATE_ERR');
1684: fnd_msg_pub.ADD;
1685: RAISE fnd_api.g_exc_error;
1686: END IF;
1687:
1688: l_progress := '4.2.1';

Line 1731: fnd_msg_pub.ADD;

1727: IF (l_debug = 1) THEN
1728: print_debug('PACK_UNPACK_SPLIT: ERROR: packunpack_container Fail', 9);
1729: END IF;
1730: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_PACK_UPDATE_ERR');
1731: fnd_msg_pub.ADD;
1732: RAISE fnd_api.g_exc_error;
1733: END IF;
1734:
1735: l_progress := '2.2.1';

Line 1760: fnd_msg_pub.ADD;

1756: IF (l_debug = 1) THEN
1757: print_debug('PACK_UNPACK_SPLIT: ERROR: abort_mmtts FAIL', 9);
1758: END IF;
1759: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1760: fnd_msg_pub.ADD;
1761: RAISE fnd_api.g_exc_error;
1762: END IF;
1763:
1764: l_mo_splt_tb(1).prim_qty := l_tmp_mmtt_rec.primary_quantity;

Line 1785: fnd_msg_pub.ADD;

1781: IF (l_debug = 1) THEN
1782: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
1783: END IF;
1784: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
1785: fnd_msg_pub.ADD;
1786: RAISE fnd_api.g_exc_error;
1787: END IF;
1788:
1789: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 1949: fnd_msg_pub.ADD;

1945: IF (l_debug = 1) THEN
1946: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
1947: END IF;
1948: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
1949: fnd_msg_pub.ADD;
1950: RAISE fnd_api.g_exc_error;
1951: END IF;
1952:
1953: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 1991: fnd_msg_pub.ADD;

1987: IF (l_debug = 1) THEN
1988: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL', 9);
1989: END IF;
1990: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1991: fnd_msg_pub.ADD;
1992: RAISE fnd_api.g_exc_error;
1993: END IF;
1994:
1995: l_progress := '6.1.3';

Line 2131: fnd_msg_pub.ADD;

2127: IF (l_debug = 1) THEN
2128: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
2129: END IF;
2130: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2131: fnd_msg_pub.ADD;
2132: RAISE fnd_api.g_exc_error;
2133: END IF;
2134:
2135: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 2179: fnd_msg_pub.ADD;

2175: IF (l_debug = 1) THEN
2176: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL', 9);
2177: END IF;
2178: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2179: fnd_msg_pub.ADD;
2180: RAISE fnd_api.g_exc_error;
2181: END IF;
2182:
2183: l_progress := '6.2.2.5';

Line 2557: fnd_msg_pub.ADD;

2553: IF (l_debug = 1) THEN
2554: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL');
2555: END IF;
2556: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2557: fnd_msg_pub.ADD;
2558: RAISE fnd_api.g_exc_error;
2559: END IF;
2560:
2561: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 2603: fnd_msg_pub.ADD;

2599: IF (l_debug = 1) THEN
2600: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL');
2601: END IF;
2602: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2603: fnd_msg_pub.ADD;
2604: RAISE fnd_api.g_exc_error;
2605: END IF;
2606:
2607: l_progress := '7.1.3';

Line 2718: fnd_msg_pub.ADD;

2714: IF (l_debug = 1) THEN
2715: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL');
2716: END IF;
2717: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2718: fnd_msg_pub.ADD;
2719: RAISE fnd_api.g_exc_error;
2720: END IF;
2721:
2722: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN

Line 2994: fnd_msg_pub.ADD;

2990: END IF;
2991: END IF; -- End sub/loc test
2992: ELSE
2993: fnd_message.set_name('INV', 'INV_INVALID_TXN_TYPE');
2994: fnd_msg_pub.ADD;
2995: RAISE fnd_api.g_exc_error;
2996: END IF; -- End txn_type test
2997:
2998:

Line 3088: fnd_msg_pub.ADD;

3084:
3085: inv_rcv_common_apis.g_po_startup_value.transaction_mode
3086: := l_txn_mode_code;
3087: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
3088: fnd_msg_pub.ADD;
3089: x_return_status := g_ret_sts_unexp_err ;
3090: fnd_msg_pub.count_and_get
3091: ( p_count => x_msg_count
3092: , p_data => x_msg_data

Line 3090: fnd_msg_pub.count_and_get

3086: := l_txn_mode_code;
3087: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
3088: fnd_msg_pub.ADD;
3089: x_return_status := g_ret_sts_unexp_err ;
3090: fnd_msg_pub.count_and_get
3091: ( p_count => x_msg_count
3092: , p_data => x_msg_data
3093: );
3094: RETURN;

Line 3121: fnd_msg_pub.count_and_get

3117: CLOSE tmp_mmtt_cur_by_txn_id;
3118: END IF;
3119:
3120: x_return_status := g_ret_sts_unexp_err ;
3121: fnd_msg_pub.count_and_get
3122: ( p_count => x_msg_count
3123: , p_data => x_msg_data
3124: );
3125: ROLLBACK TO pack_unpack_split_pub;

Line 3141: fnd_msg_pub.count_and_get

3137: CLOSE tmp_mmtt_cur_by_txn_id;
3138: END IF;
3139:
3140: x_return_status := g_ret_sts_unexp_err;
3141: fnd_msg_pub.count_and_get
3142: ( p_count => x_msg_count
3143: , p_data => x_msg_data
3144: );
3145: ROLLBACK TO pack_unpack_split_pub;