DBA Data[Home] [Help]

APPS.WMS_PICK_DROP_PVT dependencies on FND_MSG_PUB

Line 1008: fnd_msg_pub.initialize;

1004:
1005: BEGIN
1006: x_return_status := fnd_api.g_ret_sts_success;
1007:
1008: fnd_msg_pub.initialize;
1009:
1010: IF l_debug = 1 THEN
1011: print_version_info;
1012: print_debug

Line 1043: fnd_msg_pub.ADD;

1039: , l_api_name
1040: );
1041: END IF;
1042: fnd_message.set_name('WMS', 'WMS_DROP_LPN_LOCKED');
1043: fnd_msg_pub.ADD;
1044: RAISE FND_API.G_EXC_ERROR;
1045: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success
1046: THEN
1047: IF l_debug = 1 THEN

Line 1071: fnd_msg_pub.ADD;

1067: END IF;
1068: CLOSE c_check_txns;
1069:
1070: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
1071: fnd_msg_pub.ADD;
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074: CLOSE c_check_txns;
1075:

Line 1179: fnd_msg_pub.ADD;

1175: );
1176: END IF;
1177:
1178: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
1179: fnd_msg_pub.ADD;
1180: RAISE FND_API.G_EXC_ERROR;
1181: ELSE
1182: x_first_temp_id := l_txn_temp_id;
1183: x_txn_type_id := l_txn_type_id;

Line 1419: fnd_msg_pub.count_and_get

1415: ROLLBACK TO chk_if_d_sp;
1416:
1417: x_return_status := fnd_api.g_ret_sts_error;
1418:
1419: fnd_msg_pub.count_and_get
1420: ( p_count => l_msg_count
1421: , p_data => l_msg_data
1422: , p_encoded => fnd_api.g_false
1423: );

Line 3765: fnd_msg_pub.ADD;

3761:
3762: IF NOT g_current_drop_lpn.current_drop_list.COUNT > 0
3763: THEN
3764: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
3765: fnd_msg_pub.ADD;
3766: RAISE FND_API.G_EXC_ERROR;
3767: END IF;
3768:
3769: ELSE

Line 3778: fnd_msg_pub.ADD;

3774: );
3775: END IF;
3776:
3777: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
3778: fnd_msg_pub.ADD;
3779: RAISE FND_API.G_EXC_ERROR;
3780: END IF; -- end if c_remaining_tasks%FOUND
3781:
3782: l_progress := 40;

Line 3920: fnd_msg_pub.count_and_get

3916: EXCEPTION
3917: WHEN fnd_api.g_exc_error THEN
3918: x_return_status := fnd_api.g_ret_sts_error;
3919:
3920: fnd_msg_pub.count_and_get
3921: ( p_count => l_msg_count
3922: , p_data => l_msg_data
3923: , p_encoded => fnd_api.g_false
3924: );

Line 4092: fnd_msg_pub.count_and_get

4088: EXCEPTION
4089: WHEN fnd_api.g_exc_error THEN
4090: x_return_status := fnd_api.g_ret_sts_error;
4091:
4092: fnd_msg_pub.count_and_get
4093: ( p_count => l_msg_count
4094: , p_data => l_msg_data
4095: , p_encoded => fnd_api.g_false
4096: );

Line 4275: fnd_msg_pub.initialize;

4271: BEGIN
4272: x_return_status := fnd_api.g_ret_sts_success;
4273: x_drop_lpn_num := NULL;
4274:
4275: fnd_msg_pub.initialize;
4276:
4277: IF l_debug = 1 THEN
4278: print_debug
4279: ( 'Entered with parameters: ' || g_newline ||

Line 4828: fnd_msg_pub.initialize;

4824:
4825: BEGIN
4826: x_return_status := fnd_api.g_ret_sts_success;
4827:
4828: fnd_msg_pub.initialize;
4829:
4830: IF l_debug = 1 THEN
4831: print_debug
4832: ( 'Entered with parameters: ' || g_newline ||

Line 4868: fnd_msg_pub.ADD;

4864: );
4865: END IF;
4866:
4867: fnd_message.set_name('WMS', 'WMS_LPN_NOT_IN_OUTER');
4868: fnd_msg_pub.ADD;
4869: RAISE FND_API.G_EXC_ERROR;
4870: ELSE
4871: IF l_debug = 1 THEN
4872: print_debug

Line 5309: fnd_msg_pub.count_and_get

5305: ROLLBACK to process_lpn_sp;
5306:
5307: x_return_status := fnd_api.g_ret_sts_error;
5308:
5309: fnd_msg_pub.count_and_get
5310: ( p_count => l_msg_count
5311: , p_data => l_msg_data
5312: , p_encoded => fnd_api.g_false
5313: );

Line 5434: fnd_msg_pub.initialize;

5430:
5431: BEGIN
5432: x_return_status := fnd_api.g_ret_sts_success;
5433:
5434: fnd_msg_pub.initialize;
5435:
5436: IF l_debug = 1 THEN
5437: print_debug
5438: ( 'Entered with parameters: ' || g_newline ||

Line 5470: fnd_msg_pub.ADD;

5466: );
5467: END IF;
5468:
5469: fnd_message.set_name('WMS', 'WMS_NOT_ENOUGH_LOOSE_QTY');
5470: fnd_msg_pub.ADD;
5471: RAISE FND_API.G_EXC_ERROR;
5472: ELSE
5473: IF l_debug = 1 THEN
5474: print_debug

Line 5937: fnd_msg_pub.count_and_get

5933: ROLLBACK to process_loose_sp;
5934:
5935: x_return_status := fnd_api.g_ret_sts_error;
5936:
5937: fnd_msg_pub.count_and_get
5938: ( p_count => l_msg_count
5939: , p_data => l_msg_data
5940: , p_encoded => fnd_api.g_false
5941: );

Line 6133: fnd_msg_pub.initialize;

6129:
6130: BEGIN
6131: x_return_status := fnd_api.g_ret_sts_success;
6132:
6133: fnd_msg_pub.initialize;
6134:
6135: IF l_debug = 1 THEN
6136: print_debug
6137: ( 'Entered with parameters: ' || g_newline ||

Line 6192: fnd_msg_pub.ADD;

6188: );
6189: END IF;
6190:
6191: fnd_message.set_name('WMS', 'WMS_LPN_NOT_IN_OUTER');
6192: fnd_msg_pub.ADD;
6193: RAISE FND_API.G_EXC_ERROR;
6194: ELSE
6195: IF l_debug = 1 THEN
6196: print_debug

Line 6225: fnd_msg_pub.ADD;

6221: );
6222: END IF;
6223: CLOSE c_get_lot_msnt;
6224: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
6225: fnd_msg_pub.ADD;
6226: RAISE FND_API.G_EXC_ERROR;
6227: END IF;
6228: IF c_get_lot_msnt%ISOPEN THEN
6229: CLOSE c_get_lot_msnt;

Line 6250: fnd_msg_pub.ADD;

6246: );
6247: END IF;
6248: CLOSE c_get_loose_msnt;
6249: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
6250: fnd_msg_pub.ADD;
6251: RAISE FND_API.G_EXC_ERROR;
6252: END IF;
6253: IF c_get_loose_msnt%ISOPEN THEN
6254: CLOSE c_get_loose_msnt;

Line 6274: fnd_msg_pub.ADD;

6270: );
6271: END IF;
6272: CLOSE c_get_lpn_msnt;
6273: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
6274: fnd_msg_pub.ADD;
6275: RAISE FND_API.G_EXC_ERROR;
6276: END IF;
6277: IF c_get_lpn_msnt%ISOPEN THEN
6278: CLOSE c_get_lpn_msnt;

Line 7122: fnd_msg_pub.count_and_get

7118: ROLLBACK to process_serial_sp;
7119:
7120: x_return_status := fnd_api.g_ret_sts_error;
7121:
7122: fnd_msg_pub.count_and_get
7123: ( p_count => l_msg_count
7124: , p_data => l_msg_data
7125: , p_encoded => fnd_api.g_false
7126: );

Line 7212: fnd_msg_pub.initialize;

7208: , l_api_name
7209: );
7210: END IF;
7211:
7212: fnd_msg_pub.initialize;
7213:
7214: --
7215: -- Validate passed in Org and LPN
7216: --

Line 7471: fnd_msg_pub.initialize;

7467: , l_api_name
7468: );
7469: END IF;
7470:
7471: fnd_msg_pub.initialize;
7472:
7473: SAVEPOINT validate_xfer_sp;
7474:
7475: --

Line 7554: fnd_msg_pub.ADD;

7550: print_debug ('LPN is outermost LPN, but not done', l_api_name);
7551: END IF;
7552:
7553: fnd_message.set_name('WMS', 'WMS_LPN_HAS_MORE_DROP_MTL');
7554: fnd_msg_pub.ADD;
7555: RAISE FND_API.G_EXC_ERROR;
7556:
7557: ELSIF to_lpn_rec.lpn_context <> wms_container_pub.lpn_context_picked
7558: THEN

Line 7568: fnd_msg_pub.ADD;

7564: );
7565: END IF;
7566:
7567: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
7568: fnd_msg_pub.ADD;
7569: RAISE FND_API.G_EXC_ERROR;
7570:
7571: ELSE
7572: --

Line 7590: fnd_msg_pub.ADD;

7586: );
7587: END IF;
7588:
7589: fnd_message.set_name('WMS', 'WMS_XFER_LPN_DIFF_SUBINV');
7590: fnd_msg_pub.ADD;
7591: RAISE FND_API.G_EXC_ERROR;
7592: ELSE
7593: OPEN c_get_lpn_delivery (to_lpn_rec.lpn_id, p_organization_id);
7594: FETCH c_get_lpn_delivery INTO l_lpn_delivery_id;

Line 7607: fnd_msg_pub.ADD;

7603: );
7604: END IF;
7605:
7606: fnd_message.set_name('WMS', 'WMS_DROP_LPN_DIFF_DELIV');
7607: fnd_msg_pub.ADD;
7608: RAISE FND_API.G_EXC_ERROR;
7609: END IF;
7610:
7611: IF NVL(p_delivery_id,0) = 0 AND NVL(l_lpn_delivery_id,0) = 0 THEN

Line 7647: fnd_msg_pub.ADD;

7643: );
7644: END IF;
7645:
7646: fnd_message.set_name('WMS', 'WMS_INVALID_PACK_DELIVERY');
7647: fnd_msg_pub.ADD;
7648: RAISE FND_API.G_EXC_ERROR;
7649: END IF;
7650:
7651: END IF;

Line 7991: fnd_msg_pub.count_and_get

7987: ROLLBACK to validate_xfer_sp;
7988:
7989: x_return_status := fnd_api.g_ret_sts_error;
7990:
7991: fnd_msg_pub.count_and_get
7992: ( p_count => l_msg_count
7993: , p_data => l_msg_data
7994: , p_encoded => fnd_api.g_false
7995: );

Line 8482: fnd_msg_pub.count_and_get

8478: ROLLBACK to insert_pack_sp;
8479:
8480: x_return_status := fnd_api.g_ret_sts_error;
8481:
8482: fnd_msg_pub.count_and_get
8483: ( p_count => l_msg_count
8484: , p_data => l_msg_data
8485: , p_encoded => fnd_api.g_false
8486: );

Line 8846: fnd_msg_pub.count_and_get

8842: ROLLBACK TO preprocess_bulk_sp;
8843:
8844: x_return_status := fnd_api.g_ret_sts_error;
8845:
8846: fnd_msg_pub.count_and_get
8847: ( p_count => l_msg_count
8848: , p_data => l_msg_data
8849: , p_encoded => fnd_api.g_false
8850: );

Line 9189: fnd_msg_pub.ADD;

9185: RAISE FND_API.G_exc_unexpected_error;
9186: END ;
9187: IF l_to_loc_type <> inv_globals.g_loc_type_staging_lane THEN
9188: fnd_message.set_name('WMS', 'WMS_STAGE_FROM_CONSOL_LPN');
9189: fnd_msg_pub.ADD;
9190: IF l_debug = 1 THEN
9191: print_debug('WMS_STAGE_FROM_CONSOL_LPN : Destination Locator must be ' ||
9192: 'staging locator when one of the From LPNs is a consol LPN'
9193: , l_api_name );

Line 9203: fnd_msg_pub.initialize;

9199: END IF ;
9200: END IF;
9201: END IF;
9202:
9203: fnd_msg_pub.initialize;
9204:
9205: --
9206: -- Validate passed in Org and LPN
9207: --

Line 9606: fnd_msg_pub.ADD;

9602: , l_api_name
9603: );
9604: END IF;
9605: fnd_message.set_name('INV', 'INV-SUBINV NOT RESERVABLE');
9606: fnd_msg_pub.ADD;
9607: RAISE FND_API.G_EXC_ERROR;
9608: END IF;
9609: END IF;
9610:

Line 10011: fnd_msg_pub.count_and_get

10007: ROLLBACK TO pick_drop_sp;
10008:
10009: x_return_status := fnd_api.g_ret_sts_error;
10010:
10011: fnd_msg_pub.count_and_get
10012: ( p_count => l_msg_count
10013: , p_data => l_msg_data
10014: , p_encoded => fnd_api.g_false
10015: );

Line 10552: fnd_msg_pub.ADD;

10548: , l_api_name
10549: );
10550: END IF;
10551: fnd_message.set_name('WMS', 'WMS_DROP_PICK_LPN_SAME');
10552: fnd_msg_pub.ADD;
10553: RAISE FND_API.G_EXC_ERROR;
10554: RETURN;
10555: /*
10556: IF g_current_drop_lpn.multiple_drops = 'TRUE'

Line 10568: fnd_msg_pub.ADD;

10564: , l_api_name
10565: );
10566: END IF;
10567: fnd_message.set_name('WMS', 'WMS_LPN_HAS_MORE_DROP_MTL');
10568: fnd_msg_pub.ADD;
10569: RAISE FND_API.G_EXC_ERROR;
10570: ELSIF g_current_drop_lpn.multiple_drops <> 'TRUE'
10571: THEN
10572: CLOSE c_drop_lpn_cursor;

Line 10580: fnd_msg_pub.ADD;

10576: , l_api_name
10577: );
10578: END IF;
10579: fnd_message.set_name('WMS', 'WMS_DROP_PICK_LPN_SAME');
10580: fnd_msg_pub.ADD;
10581: RAISE FND_API.G_EXC_ERROR;
10582: END IF;
10583: RETURN; -- multiple drops is TRUE and outer LPN done
10584: */

Line 10605: fnd_msg_pub.ADD;

10601: , l_api_name
10602: );
10603: END IF;
10604: fnd_message.set_name('WMS', 'WMS_DROP_LPN_SUBLOC_MISMATCH');
10605: fnd_msg_pub.ADD;
10606: RAISE FND_API.G_EXC_ERROR;
10607: END IF;
10608: ELSIF drop_lpn_rec.lpn_context =
10609: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT

Line 10619: fnd_msg_pub.ADD;

10615: , l_api_name
10616: );
10617: END IF;
10618: fnd_message.set_name('WMS', 'WMS_DROP_LPN_LOADED');
10619: fnd_msg_pub.ADD;
10620: RAISE FND_API.G_EXC_ERROR;
10621: END IF;
10622:
10623: IF c_drop_lpn_cursor%ISOPEN

Line 10706: fnd_msg_pub.ADD;

10702:
10703: l_temp_tbl.DELETE;
10704:
10705: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
10706: fnd_msg_pub.ADD;
10707: RAISE FND_API.G_EXC_ERROR;
10708: END IF;
10709:
10710: IF ii < jj THEN

Line 10738: fnd_msg_pub.ADD;

10734: , l_api_name
10735: );
10736: END IF;
10737: fnd_message.set_name('WMS', 'WMS_INVALID_LPN_STATUS');
10738: fnd_msg_pub.ADD;
10739: RAISE FND_API.G_EXC_ERROR;
10740: END IF;
10741:
10742: --**MRANA temporary code for double validations and avoid data corruption

Line 10810: fnd_msg_pub.ADD;

10806: IF (l_debug = 1) THEN
10807: print_debug('Picked LPN does not belong to same delivery as Drop LPN. So cannot be dropped', l_api_name);
10808: END IF;
10809: fnd_message.set_name('WMS', 'WMS_DROP_LPN_DIFF_DELIV');
10810: fnd_msg_pub.ADD;
10811: RAISE FND_API.G_EXC_ERROR;
10812: END IF;
10813:
10814: EXCEPTION

Line 10834: fnd_msg_pub.count_and_get

10830: EXCEPTION
10831: WHEN fnd_api.g_exc_error THEN
10832: x_return_status := fnd_api.g_ret_sts_error;
10833:
10834: fnd_msg_pub.count_and_get
10835: ( p_count => l_msg_count
10836: , p_data => l_msg_data
10837: , p_encoded => fnd_api.g_false
10838: );