DBA Data[Home] [Help]

APPS.WMS_PICK_DROP_PVT dependencies on FND_MSG_PUB

Line 1092: fnd_msg_pub.initialize;

1088:
1089: BEGIN
1090: x_return_status := fnd_api.g_ret_sts_success;
1091:
1092: fnd_msg_pub.initialize;
1093:
1094: IF l_debug = 1 THEN
1095: print_version_info;
1096: print_debug

Line 1133: fnd_msg_pub.ADD;

1129: , l_api_name
1130: );
1131: END IF;
1132: fnd_message.set_name('WMS', 'WMS_DROP_LPN_LOCKED');
1133: fnd_msg_pub.ADD;
1134: RAISE FND_API.G_EXC_ERROR;
1135: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success
1136: THEN
1137: IF l_debug = 1 THEN

Line 1161: fnd_msg_pub.ADD;

1157: END IF;
1158: CLOSE c_check_txns;
1159:
1160: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
1161: fnd_msg_pub.ADD;
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164: CLOSE c_check_txns;
1165:

Line 1269: fnd_msg_pub.ADD;

1265: );
1266: END IF;
1267:
1268: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
1269: fnd_msg_pub.ADD;
1270: RAISE FND_API.G_EXC_ERROR;
1271: ELSE
1272: x_first_temp_id := l_txn_temp_id;
1273: x_txn_type_id := l_txn_type_id;

Line 1560: fnd_msg_pub.count_and_get

1556: ROLLBACK TO chk_if_d_sp;
1557:
1558: x_return_status := fnd_api.g_ret_sts_error;
1559:
1560: fnd_msg_pub.count_and_get
1561: ( p_count => l_msg_count
1562: , p_data => l_msg_data
1563: , p_encoded => fnd_api.g_false
1564: );

Line 4027: fnd_msg_pub.ADD;

4023:
4024: IF NOT g_current_drop_lpn.current_drop_list.COUNT > 0
4025: THEN
4026: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
4027: fnd_msg_pub.ADD;
4028: RAISE FND_API.G_EXC_ERROR;
4029: END IF;
4030:
4031: ELSE

Line 4040: fnd_msg_pub.ADD;

4036: );
4037: END IF;
4038:
4039: fnd_message.set_name('WMS', 'WMS_DROP_LPN_NO_MTL');
4040: fnd_msg_pub.ADD;
4041: RAISE FND_API.G_EXC_ERROR;
4042: END IF; -- end if c_remaining_tasks%FOUND
4043:
4044: l_progress := 40;

Line 4194: fnd_msg_pub.count_and_get

4190: EXCEPTION
4191: WHEN fnd_api.g_exc_error THEN
4192: x_return_status := fnd_api.g_ret_sts_error;
4193:
4194: fnd_msg_pub.count_and_get
4195: ( p_count => l_msg_count
4196: , p_data => l_msg_data
4197: , p_encoded => fnd_api.g_false
4198: );

Line 4370: fnd_msg_pub.count_and_get

4366: EXCEPTION
4367: WHEN fnd_api.g_exc_error THEN
4368: x_return_status := fnd_api.g_ret_sts_error;
4369:
4370: fnd_msg_pub.count_and_get
4371: ( p_count => l_msg_count
4372: , p_data => l_msg_data
4373: , p_encoded => fnd_api.g_false
4374: );

Line 4553: fnd_msg_pub.initialize;

4549: BEGIN
4550: x_return_status := fnd_api.g_ret_sts_success;
4551: x_drop_lpn_num := NULL;
4552:
4553: fnd_msg_pub.initialize;
4554:
4555: IF l_debug = 1 THEN
4556: print_debug
4557: ( 'Entered with parameters: ' || g_newline ||

Line 5106: fnd_msg_pub.initialize;

5102:
5103: BEGIN
5104: x_return_status := fnd_api.g_ret_sts_success;
5105:
5106: fnd_msg_pub.initialize;
5107:
5108: IF l_debug = 1 THEN
5109: print_debug
5110: ( 'Entered with parameters: ' || g_newline ||

Line 5146: fnd_msg_pub.ADD;

5142: );
5143: END IF;
5144:
5145: fnd_message.set_name('WMS', 'WMS_LPN_NOT_IN_OUTER');
5146: fnd_msg_pub.ADD;
5147: RAISE FND_API.G_EXC_ERROR;
5148: ELSE
5149: IF l_debug = 1 THEN
5150: print_debug

Line 5587: fnd_msg_pub.count_and_get

5583: ROLLBACK to process_lpn_sp;
5584:
5585: x_return_status := fnd_api.g_ret_sts_error;
5586:
5587: fnd_msg_pub.count_and_get
5588: ( p_count => l_msg_count
5589: , p_data => l_msg_data
5590: , p_encoded => fnd_api.g_false
5591: );

Line 5712: fnd_msg_pub.initialize;

5708:
5709: BEGIN
5710: x_return_status := fnd_api.g_ret_sts_success;
5711:
5712: fnd_msg_pub.initialize;
5713:
5714: IF l_debug = 1 THEN
5715: print_debug
5716: ( 'Entered with parameters: ' || g_newline ||

Line 5748: fnd_msg_pub.ADD;

5744: );
5745: END IF;
5746:
5747: fnd_message.set_name('WMS', 'WMS_NOT_ENOUGH_LOOSE_QTY');
5748: fnd_msg_pub.ADD;
5749: RAISE FND_API.G_EXC_ERROR;
5750: ELSE
5751: IF l_debug = 1 THEN
5752: print_debug

Line 6215: fnd_msg_pub.count_and_get

6211: ROLLBACK to process_loose_sp;
6212:
6213: x_return_status := fnd_api.g_ret_sts_error;
6214:
6215: fnd_msg_pub.count_and_get
6216: ( p_count => l_msg_count
6217: , p_data => l_msg_data
6218: , p_encoded => fnd_api.g_false
6219: );

Line 6411: fnd_msg_pub.initialize;

6407:
6408: BEGIN
6409: x_return_status := fnd_api.g_ret_sts_success;
6410:
6411: fnd_msg_pub.initialize;
6412:
6413: IF l_debug = 1 THEN
6414: print_debug
6415: ( 'Entered with parameters: ' || g_newline ||

Line 6470: fnd_msg_pub.ADD;

6466: );
6467: END IF;
6468:
6469: fnd_message.set_name('WMS', 'WMS_LPN_NOT_IN_OUTER');
6470: fnd_msg_pub.ADD;
6471: RAISE FND_API.G_EXC_ERROR;
6472: ELSE
6473: IF l_debug = 1 THEN
6474: print_debug

Line 6503: fnd_msg_pub.ADD;

6499: );
6500: END IF;
6501: CLOSE c_get_lot_msnt;
6502: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
6503: fnd_msg_pub.ADD;
6504: RAISE FND_API.G_EXC_ERROR;
6505: END IF;
6506: IF c_get_lot_msnt%ISOPEN THEN
6507: CLOSE c_get_lot_msnt;

Line 6528: fnd_msg_pub.ADD;

6524: );
6525: END IF;
6526: CLOSE c_get_loose_msnt;
6527: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
6528: fnd_msg_pub.ADD;
6529: RAISE FND_API.G_EXC_ERROR;
6530: END IF;
6531: IF c_get_loose_msnt%ISOPEN THEN
6532: CLOSE c_get_loose_msnt;

Line 6552: fnd_msg_pub.ADD;

6548: );
6549: END IF;
6550: CLOSE c_get_lpn_msnt;
6551: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
6552: fnd_msg_pub.ADD;
6553: RAISE FND_API.G_EXC_ERROR;
6554: END IF;
6555: IF c_get_lpn_msnt%ISOPEN THEN
6556: CLOSE c_get_lpn_msnt;

Line 7400: fnd_msg_pub.count_and_get

7396: ROLLBACK to process_serial_sp;
7397:
7398: x_return_status := fnd_api.g_ret_sts_error;
7399:
7400: fnd_msg_pub.count_and_get
7401: ( p_count => l_msg_count
7402: , p_data => l_msg_data
7403: , p_encoded => fnd_api.g_false
7404: );

Line 7490: fnd_msg_pub.initialize;

7486: , l_api_name
7487: );
7488: END IF;
7489:
7490: fnd_msg_pub.initialize;
7491:
7492: --
7493: -- Validate passed in Org and LPN
7494: --

Line 7749: fnd_msg_pub.initialize;

7745: , l_api_name
7746: );
7747: END IF;
7748:
7749: fnd_msg_pub.initialize;
7750:
7751: SAVEPOINT validate_xfer_sp;
7752:
7753: --

Line 7832: fnd_msg_pub.ADD;

7828: print_debug ('LPN is outermost LPN, but not done', l_api_name);
7829: END IF;
7830:
7831: fnd_message.set_name('WMS', 'WMS_LPN_HAS_MORE_DROP_MTL');
7832: fnd_msg_pub.ADD;
7833: RAISE FND_API.G_EXC_ERROR;
7834:
7835: ELSIF to_lpn_rec.lpn_context <> wms_container_pub.lpn_context_picked
7836: THEN

Line 7846: fnd_msg_pub.ADD;

7842: );
7843: END IF;
7844:
7845: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
7846: fnd_msg_pub.ADD;
7847: RAISE FND_API.G_EXC_ERROR;
7848:
7849: ELSE
7850: --

Line 7868: fnd_msg_pub.ADD;

7864: );
7865: END IF;
7866:
7867: fnd_message.set_name('WMS', 'WMS_XFER_LPN_DIFF_SUBINV');
7868: fnd_msg_pub.ADD;
7869: RAISE FND_API.G_EXC_ERROR;
7870: ELSE
7871: OPEN c_get_lpn_delivery (to_lpn_rec.lpn_id, p_organization_id);
7872: FETCH c_get_lpn_delivery INTO l_lpn_delivery_id;

Line 7885: fnd_msg_pub.ADD;

7881: );
7882: END IF;
7883:
7884: fnd_message.set_name('WMS', 'WMS_DROP_LPN_DIFF_DELIV');
7885: fnd_msg_pub.ADD;
7886: RAISE FND_API.G_EXC_ERROR;
7887: END IF;
7888:
7889: IF NVL(p_delivery_id,0) = 0 AND NVL(l_lpn_delivery_id,0) = 0 THEN

Line 7925: fnd_msg_pub.ADD;

7921: );
7922: END IF;
7923:
7924: fnd_message.set_name('WMS', 'WMS_INVALID_PACK_DELIVERY');
7925: fnd_msg_pub.ADD;
7926: RAISE FND_API.G_EXC_ERROR;
7927: END IF;
7928:
7929: END IF;

Line 8285: fnd_msg_pub.count_and_get

8281: ROLLBACK to validate_xfer_sp;
8282:
8283: x_return_status := fnd_api.g_ret_sts_error;
8284:
8285: fnd_msg_pub.count_and_get
8286: ( p_count => l_msg_count
8287: , p_data => l_msg_data
8288: , p_encoded => fnd_api.g_false
8289: );

Line 8776: fnd_msg_pub.count_and_get

8772: ROLLBACK to insert_pack_sp;
8773:
8774: x_return_status := fnd_api.g_ret_sts_error;
8775:
8776: fnd_msg_pub.count_and_get
8777: ( p_count => l_msg_count
8778: , p_data => l_msg_data
8779: , p_encoded => fnd_api.g_false
8780: );

Line 9140: fnd_msg_pub.count_and_get

9136: ROLLBACK TO preprocess_bulk_sp;
9137:
9138: x_return_status := fnd_api.g_ret_sts_error;
9139:
9140: fnd_msg_pub.count_and_get
9141: ( p_count => l_msg_count
9142: , p_data => l_msg_data
9143: , p_encoded => fnd_api.g_false
9144: );

Line 9508: fnd_msg_pub.ADD;

9504: RAISE FND_API.G_exc_unexpected_error;
9505: END ;
9506: IF l_to_loc_type <> inv_globals.g_loc_type_staging_lane THEN
9507: fnd_message.set_name('WMS', 'WMS_STAGE_FROM_CONSOL_LPN');
9508: fnd_msg_pub.ADD;
9509: IF l_debug = 1 THEN
9510: print_debug('WMS_STAGE_FROM_CONSOL_LPN : Destination Locator must be ' ||
9511: 'staging locator when one of the From LPNs is a consol LPN'
9512: , l_api_name );

Line 9522: fnd_msg_pub.initialize;

9518: END IF ;
9519: END IF;
9520: END IF;
9521:
9522: fnd_msg_pub.initialize;
9523:
9524: --
9525: -- Validate passed in Org and LPN
9526: --

Line 9929: fnd_msg_pub.ADD;

9925: , l_api_name
9926: );
9927: END IF;
9928: fnd_message.set_name('INV', 'INV-SUBINV NOT RESERVABLE');
9929: fnd_msg_pub.ADD;
9930: RAISE FND_API.G_EXC_ERROR;
9931: END IF;
9932: END IF;
9933:

Line 10334: fnd_msg_pub.count_and_get

10330: ROLLBACK TO pick_drop_sp;
10331:
10332: x_return_status := fnd_api.g_ret_sts_error;
10333:
10334: fnd_msg_pub.count_and_get
10335: ( p_count => l_msg_count
10336: , p_data => l_msg_data
10337: , p_encoded => fnd_api.g_false
10338: );

Line 10875: fnd_msg_pub.ADD;

10871: , l_api_name
10872: );
10873: END IF;
10874: fnd_message.set_name('WMS', 'WMS_DROP_PICK_LPN_SAME');
10875: fnd_msg_pub.ADD;
10876: RAISE FND_API.G_EXC_ERROR;
10877: RETURN;
10878: /*
10879: IF g_current_drop_lpn.multiple_drops = 'TRUE'

Line 10891: fnd_msg_pub.ADD;

10887: , l_api_name
10888: );
10889: END IF;
10890: fnd_message.set_name('WMS', 'WMS_LPN_HAS_MORE_DROP_MTL');
10891: fnd_msg_pub.ADD;
10892: RAISE FND_API.G_EXC_ERROR;
10893: ELSIF g_current_drop_lpn.multiple_drops <> 'TRUE'
10894: THEN
10895: CLOSE c_drop_lpn_cursor;

Line 10903: fnd_msg_pub.ADD;

10899: , l_api_name
10900: );
10901: END IF;
10902: fnd_message.set_name('WMS', 'WMS_DROP_PICK_LPN_SAME');
10903: fnd_msg_pub.ADD;
10904: RAISE FND_API.G_EXC_ERROR;
10905: END IF;
10906: RETURN; -- multiple drops is TRUE and outer LPN done
10907: */

Line 10928: fnd_msg_pub.ADD;

10924: , l_api_name
10925: );
10926: END IF;
10927: fnd_message.set_name('WMS', 'WMS_DROP_LPN_SUBLOC_MISMATCH');
10928: fnd_msg_pub.ADD;
10929: RAISE FND_API.G_EXC_ERROR;
10930: END IF;
10931: ELSIF drop_lpn_rec.lpn_context =
10932: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT

Line 10942: fnd_msg_pub.ADD;

10938: , l_api_name
10939: );
10940: END IF;
10941: fnd_message.set_name('WMS', 'WMS_DROP_LPN_LOADED');
10942: fnd_msg_pub.ADD;
10943: RAISE FND_API.G_EXC_ERROR;
10944: END IF;
10945:
10946: IF c_drop_lpn_cursor%ISOPEN

Line 11029: fnd_msg_pub.ADD;

11025:
11026: l_temp_tbl.DELETE;
11027:
11028: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
11029: fnd_msg_pub.ADD;
11030: RAISE FND_API.G_EXC_ERROR;
11031: END IF;
11032:
11033: IF ii < jj THEN

Line 11061: fnd_msg_pub.ADD;

11057: , l_api_name
11058: );
11059: END IF;
11060: fnd_message.set_name('WMS', 'WMS_INVALID_LPN_STATUS');
11061: fnd_msg_pub.ADD;
11062: RAISE FND_API.G_EXC_ERROR;
11063: END IF;
11064:
11065: --**MRANA temporary code for double validations and avoid data corruption

Line 11133: fnd_msg_pub.ADD;

11129: IF (l_debug = 1) THEN
11130: print_debug('Picked LPN does not belong to same delivery as Drop LPN. So cannot be dropped', l_api_name);
11131: END IF;
11132: fnd_message.set_name('WMS', 'WMS_DROP_LPN_DIFF_DELIV');
11133: fnd_msg_pub.ADD;
11134: RAISE FND_API.G_EXC_ERROR;
11135: END IF;
11136:
11137: EXCEPTION

Line 11157: fnd_msg_pub.count_and_get

11153: EXCEPTION
11154: WHEN fnd_api.g_exc_error THEN
11155: x_return_status := fnd_api.g_ret_sts_error;
11156:
11157: fnd_msg_pub.count_and_get
11158: ( p_count => l_msg_count
11159: , p_data => l_msg_data
11160: , p_encoded => fnd_api.g_false
11161: );