DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on FND_MESSAGE

Line 4680: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');

4676: WHEN record_locked THEN
4677: debug(' LPN Already locked by someone else', l_proc_name,1);
4678: x_return_status := fnd_api.g_ret_sts_error;
4679:
4680: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
4681: fnd_msg_pub.ADD;
4682: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
4683:
4684: WHEN OTHERS THEN

Line 4925: FND_MESSAGE.SET_NAME('WMS','WMS_NO_TASKS');

4921: IF l_rec_count = 0 THEN
4922: l_progress := '225';
4923: -- No Tasks found for the data passed
4924: -- Set error message and raise error handle it in exception block.
4925: FND_MESSAGE.SET_NAME('WMS','WMS_NO_TASKS');
4926: fnd_msg_pub.ADD;
4927: -- Instead of raising an error, return with success
4928: RETURN;
4929: END IF;

Line 6609: fnd_message.set_name('WMS','WMS_PUTAWAY_LPN_LOCKED');

6605: l_username := NULL;
6606: END;
6607:
6608: IF (l_username IS NOT NULL) THEN
6609: fnd_message.set_name('WMS','WMS_PUTAWAY_LPN_LOCKED');
6610: fnd_message.set_token('USER',l_username);
6611: fnd_msg_pub.ADD;
6612: fnd_message.set_name('WMS','WMS_CONT_INVALID_LPN');
6613: fnd_msg_pub.ADD;

Line 6610: fnd_message.set_token('USER',l_username);

6606: END;
6607:
6608: IF (l_username IS NOT NULL) THEN
6609: fnd_message.set_name('WMS','WMS_PUTAWAY_LPN_LOCKED');
6610: fnd_message.set_token('USER',l_username);
6611: fnd_msg_pub.ADD;
6612: fnd_message.set_name('WMS','WMS_CONT_INVALID_LPN');
6613: fnd_msg_pub.ADD;
6614: END IF;

Line 6612: fnd_message.set_name('WMS','WMS_CONT_INVALID_LPN');

6608: IF (l_username IS NOT NULL) THEN
6609: fnd_message.set_name('WMS','WMS_PUTAWAY_LPN_LOCKED');
6610: fnd_message.set_token('USER',l_username);
6611: fnd_msg_pub.ADD;
6612: fnd_message.set_name('WMS','WMS_CONT_INVALID_LPN');
6613: fnd_msg_pub.ADD;
6614: END IF;
6615:
6616: END IF;

Line 6789: fnd_message.set_name('INV', 'INV_LPN_ALLOCATED');

6785: AND wdt.status >= G_TASK_STATUS_LOADED ) ;
6786:
6787: IF ( l_invalid_cnt > 0 ) THEN
6788: x_ret := 3;
6789: fnd_message.set_name('INV', 'INV_LPN_ALLOCATED');
6790: fnd_msg_pub.add ;
6791: IF (l_debug = 1) THEN
6792: debug('check_lpn_validity: Error!!!, LPN is Allocated' );
6793: END IF;

Line 6805: fnd_message.set_name('WMS', 'WMS_LPN_LOADED_ERROR');

6801: AND NVL(wlqv.content_lpn_id , wlqv.lpn_id) = p_lpn_id ;
6802:
6803: IF ( l_invalid_cnt > 0 ) THEN
6804: x_ret := 3;
6805: fnd_message.set_name('WMS', 'WMS_LPN_LOADED_ERROR');
6806: fnd_msg_pub.add ;
6807: IF (l_debug = 1) THEN
6808: debug('check_lpn_validity: Error!!!, LPN has loaded tasks ' );
6809: END IF;

Line 6976: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');

6972: WHERE wlpn.lpn_id=p_lpn_id
6973: AND wlpn.organization_id=p_org_id;
6974: IF l_lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED THEN
6975: debug('There is no LPN content available for this transaction.');
6976: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
6977: fnd_msg_pub.ADD;
6978: x_return_status := fnd_api.g_ret_sts_unexp_error;
6979: x_ret := 3;
6980: RETURN;

Line 7115: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');

7111:
7112:
7113: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7114: -- IF x_msg_count = 0 THEN
7115: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
7116: -- FND_MSG_PUB.ADD;
7117: -- END IF;
7118: RAISE FND_API.g_exc_unexpected_error;
7119:

Line 7122: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');

7118: RAISE FND_API.g_exc_unexpected_error;
7119:
7120: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7121: -- IF x_msg_count = 0 THEN
7122: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
7123: -- FND_MSG_PUB.ADD;
7124: -- END IF;
7125: RAISE FND_API.G_EXC_ERROR;
7126: END IF;

Line 7165: fnd_message.set_name('WMS', 'WMS_INVLID_LPN_MOVE');

7161: debug('suggestions_pub: Before suggestions_csr ');
7162: debug('suggestions_pub: There is a WLC for lpn_id ' || p_lpn_id || ' that does not have an MMTT so preventing the putaway out');
7163: END IF;
7164: --fnd_msg_pub.initialize();
7165: fnd_message.set_name('WMS', 'WMS_INVLID_LPN_MOVE');
7166: fnd_msg_pub.ADD;
7167: ROLLBACK TO before_suggestions_pub_call;
7168: RAISE fnd_api.g_exc_error;
7169: END IF;

Line 7186: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');

7182: IF (l_msg_count IS NULL OR l_msg_count = 0) THEN
7183: -- use default message if there are no message on stack
7184: -- first reset message stack
7185: fnd_msg_pub.initialize();
7186: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
7187: FND_MSG_PUB.ADD;
7188: ELSIF l_msg_count > 1 THEN
7189: FOR i IN 2 .. l_msg_count LOOP
7190: fnd_msg_pub.delete_msg(i);

Line 7720: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');

7716:
7717:
7718: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7719: -- IF (x_msg_count = 0) THEN
7720: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
7721: -- FND_MSG_PUB.ADD;
7722: -- END IF;
7723: RAISE FND_API.g_exc_unexpected_error;
7724: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 7726: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');

7722: -- END IF;
7723: RAISE FND_API.g_exc_unexpected_error;
7724: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
7725: -- IF (x_msg_count = 0 ) THEN
7726: -- FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
7727: -- FND_MSG_PUB.ADD;
7728: -- END IF;
7729: RAISE FND_API.G_EXC_ERROR;
7730: END IF;

Line 7771: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');

7767: IF (l_msg_count IS NULL OR l_msg_count = 0) THEN
7768: -- use default message if there are no message on stack
7769: -- first reset message stack
7770: fnd_msg_pub.initialize();
7771: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
7772: FND_MSG_PUB.ADD;
7773: ELSIF l_msg_count > 1 THEN
7774: FOR i IN 2 .. l_msg_count LOOP
7775: fnd_msg_pub.delete_msg(i);

Line 7809: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');

7805: IF l_debug = 1 THEN
7806: debug('TM call for pack unpack faluire');
7807: debug('Failure message ' || x_msg_data);
7808: END IF;
7809: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
7810: RAISE FND_API.G_EXC_ERROR;
7811: END IF;
7812: END IF;
7813:

Line 7843: fnd_message.set_name('WMS', 'WMS_NO_EMP_FOR_USR');

7839: WHEN OTHERS THEN
7840: IF (l_debug = 1) THEN
7841: DEBUG('There is no employee id tied to the user','load_lpn',9);
7842: END IF;
7843: fnd_message.set_name('WMS', 'WMS_NO_EMP_FOR_USR');
7844: fnd_msg_pub.ADD;
7845: RAISE fnd_api.g_exc_error;
7846: END;
7847:

Line 7939: fnd_message.set_name('WMS', 'WMS_NO_EMP_FOR_USR');

7935: WHEN OTHERS THEN
7936: IF (l_debug = 1) THEN
7937: DEBUG('There is no employee id tied to the user','transfer_contents',9);
7938: END IF;
7939: fnd_message.set_name('WMS', 'WMS_NO_EMP_FOR_USR');
7940: fnd_msg_pub.ADD;
7941: RAISE fnd_api.g_exc_error;
7942: END;
7943: debug('Calling complete_atf_load for:'||p_from_lpn_id);

Line 8071: fnd_message.set_name('INV', 'INV_RCV_PARAM');

8067: BEGIN
8068: inv_rcv_common_apis.init_startup_values(l_from_org);
8069: EXCEPTION
8070: WHEN NO_DATA_FOUND THEN
8071: fnd_message.set_name('INV', 'INV_RCV_PARAM');
8072: fnd_msg_pub.ADD;
8073: RAISE fnd_api.g_exc_error;
8074: END;
8075:

Line 8447: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');

8443: IF l_debug = 1 THEN
8444: debug('TM call for pack unpack faluire');
8445: debug('Failure message ' || x_msg_data);
8446: END IF;
8447: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
8448: RAISE FND_API.G_EXC_ERROR;
8449: END IF;
8450:
8451: l_batch_seq := l_batch_seq + 1;

Line 8536: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');

8532: IF l_debug = 1 THEN
8533: debug('TM call for pack unpack faluire');
8534: debug('Failure message ' || x_msg_data);
8535: END IF;
8536: FND_MESSAGE.SET_NAME('WMS','WMS_LOG_EXCEPTION_FAIL');
8537: RAISE FND_API.G_EXC_ERROR;
8538: END IF; -- if l_ret<> 0
8539:
8540: l_batch_seq := l_batch_seq + 1;

Line 8849: fnd_message.set_name('WMS', 'WMS_NO_EMP_FOR_USR');

8845: WHEN OTHERS THEN
8846: IF (l_debug = 1) THEN
8847: DEBUG('There is no employee id tied to the user','transfer_contents',9);
8848: END IF;
8849: fnd_message.set_name('WMS', 'WMS_NO_EMP_FOR_USR');
8850: fnd_msg_pub.ADD;
8851: RAISE fnd_api.g_exc_error;
8852: END;
8853:

Line 8877: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

8873: IF (l_debug = 1) THEN
8874: DEBUG('from LPN not found in WMS_LICENSE_PLATE_NUMBERS',
8875: 'transfer_contents',9);
8876: END IF;
8877: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
8878: fnd_msg_pub.ADD;
8879: RAISE fnd_api.g_exc_error;
8880: END;
8881:

Line 8903: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

8899: IF (l_debug = 1) THEN
8900: DEBUG('INTO LPN not found in WMS_LICENSE_PLATE_NUMBERS',
8901: 'transfer_contents',9);
8902: END IF;
8903: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
8904: fnd_msg_pub.ADD;
8905: RAISE fnd_api.g_exc_error;
8906: END;
8907:

Line 8936: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');

8932: IF (l_debug = 1) THEN
8933: DEBUG('Invalid context for from_lpn_id',
8934: 'transfer_contents', 9);
8935: END IF;
8936: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
8937: fnd_msg_pub.ADD;
8938: RAISE fnd_api.g_exc_error;
8939: END IF;
8940:

Line 9015: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');

9011: IF (l_msg_count IS NULL OR l_msg_count = 0) THEN
9012: -- use default message if there are no message on stack
9013: -- first reset message stack
9014: fnd_msg_pub.initialize();
9015: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
9016: FND_MSG_PUB.ADD;
9017: ELSIF l_msg_count > 1 THEN
9018: FOR i IN 2 .. l_msg_count LOOP
9019: fnd_msg_pub.delete_msg(i);

Line 9079: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');

9075: IF (l_txn_tmp_id_tb.COUNT = 0) THEN
9076: IF (l_debug = 1) THEN
9077: debug('No MMTT returned!','transfer_contents',9);
9078: END IF;
9079: FND_MESSAGE.SET_NAME('WMS','WMS_ALLOCATE_FAIL');
9080: FND_MSG_PUB.ADD;
9081: RAISE fnd_api.g_exc_error;
9082: END IF;
9083: ELSE

Line 10070: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');

10066: COMMIT;
10067:
10068: EXCEPTION
10069: WHEN OTHERS THEN
10070: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
10071: fnd_msg_pub.add;
10072: x_return_status := fnd_api.g_ret_sts_unexp_error;
10073: IF (l_debug = 1) THEN
10074: debug('Exception occured after l_progress ='|| l_progress, 'transfer_contents', 9);

Line 10687: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');

10683: WHEN OTHERS THEN
10684: IF (l_debug = 1) THEN
10685: DEBUG('Error fetching MMTTs for the current group. Cannot drop', l_proc_name, 1);
10686: END IF;
10687: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
10688: fnd_msg_pub.add;
10689: RAISE FND_API.G_EXC_ERROR;
10690: END;
10691: ELSE

Line 11310: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');

11306: DEBUG('complete_putaway_wrapper: Progress: ' || l_progress || 'No. of tasks for this group: ' || l_temp_id_tbl.COUNT, l_proc_name);
11307: END IF;
11308:
11309: IF (l_temp_id_tbl.COUNT = 0) THEN
11310: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
11311: fnd_msg_pub.ADD;
11312: END IF;
11313:
11314: IF (p_drop_type = G_DT_ITEM_DROP) THEN

Line 11976: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');

11972: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
11973: IF (l_debug = 1) THEN
11974: DEBUG('complete_putaway_wrapper: Encountered g_exc_error while calling receiving manager;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
11975: END IF;
11976: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
11977: fnd_msg_pub.add;
11978: RAISE FND_API.G_EXC_ERROR;
11979: END IF;
11980:

Line 11985: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');

11981: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
11982: IF (l_debug = 1) THEN
11983: DEBUG('complete_putaway_wrapper: Encountered g_exc_unexp_error while calling receiving manager;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
11984: END IF;
11985: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
11986: fnd_msg_pub.add;
11987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11988: END IF;
11989:

Line 12121: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');

12117: debug('complete_putaway_wrapper: Txn Message ' || x_msg_data, l_proc_name);
12118: END IF;
12119:
12120: IF (l_txn_ret <> 0) THEN
12121: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
12122: fnd_msg_pub.ADD;
12123: RAISE fnd_api.g_exc_unexpected_error;
12124: END IF;
12125:

Line 12429: FND_MESSAGE.SET_NAME('WMS', 'WMS_TD_CREATE_LPN_ERROR');

12425: ELSE
12426: IF (l_debug = 1) THEN
12427: debug('Failure returned from wms_container_pub.create_lpn API','validate_into_lpn',9);
12428: END IF;
12429: FND_MESSAGE.SET_NAME('WMS', 'WMS_TD_CREATE_LPN_ERROR');
12430: FND_MSG_PUB.ADD;
12431: RAISE fnd_api.g_exc_error;
12432: END IF;
12433: l_progress := '60';

Line 12574: FND_MESSAGE.SET_NAME('WMS','WMS_NO_LPN_LOAD_ALLOWED');

12570: x_validation_passed := 'N';
12571: IF (l_debug = 1) THEN
12572: debug('Into LPN validation failed!','validate_into_lpn',9);
12573: END IF;
12574: FND_MESSAGE.SET_NAME('WMS','WMS_NO_LPN_LOAD_ALLOWED');
12575: FND_MSG_PUB.ADD;
12576: RAISE fnd_api.g_exc_error;
12577: ELSE
12578: x_validation_passed := 'Y';

Line 12678: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');

12674: --Commented for BUG#11769042
12675: /* IF l_allowed = 'N' THEN
12676: x_return_status := fnd_api.g_ret_sts_error;
12677: x_validation_passed := 'N';
12678: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');
12679: fnd_msg_pub.ADD;
12680: RETURN;
12681: END IF;*/--Commented for BUG#11769042
12682: END IF;

Line 12773: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');

12769: END IF;
12770: l_allowed := 'N';
12771: x_return_status := fnd_api.g_ret_sts_error;
12772: x_validation_passed := 'N';
12773: fnd_message.set_name('WMS', 'WMS_LOOSE_TO_LPN');
12774: fnd_msg_pub.ADD;
12775: RETURN;
12776: ELSE
12777: IF (l_debug = 1) THEN

Line 13538: fnd_message.set_name('WMS', 'WMS_MO_NOT_FOUND');

13534:
13535: l_progress := 2 ;
13536:
13537: IF (cur_mtrl_wlc_qty_mismatch%FOUND) THEN
13538: fnd_message.set_name('WMS', 'WMS_MO_NOT_FOUND');
13539: fnd_msg_pub.add;
13540: RAISE fnd_api.g_exc_error;
13541:
13542: ELSE

Line 13562: fnd_message.set_name('WMS', 'WMS_MO_NOT_FOUND');

13558: INTO
13559: l_cur_wlc_without_mtrl ;
13560:
13561: IF (cur_wlc_without_mtrl%FOUND) THEN
13562: fnd_message.set_name('WMS', 'WMS_MO_NOT_FOUND');
13563: --fnd_message.set_token('LPN', l_lpn);
13564: fnd_msg_pub.add;
13565: RAISE fnd_api.g_exc_error;
13566: ELSE

Line 13563: --fnd_message.set_token('LPN', l_lpn);

13559: l_cur_wlc_without_mtrl ;
13560:
13561: IF (cur_wlc_without_mtrl%FOUND) THEN
13562: fnd_message.set_name('WMS', 'WMS_MO_NOT_FOUND');
13563: --fnd_message.set_token('LPN', l_lpn);
13564: fnd_msg_pub.add;
13565: RAISE fnd_api.g_exc_error;
13566: ELSE
13567: IF (l_debug = 1) THEN

Line 13584: fnd_message.set_name('WMS', 'WMS_LPN_SUBLOC_MISMATCH');

13580: INTO
13581: l_cur_mtrl_wlpn_mismatch;
13582: l_progress := 4 ;
13583: IF cur_mtrl_wlpn_mismatch%FOUND THEN
13584: fnd_message.set_name('WMS', 'WMS_LPN_SUBLOC_MISMATCH');
13585: --fnd_message.set_token('LPN', l_lpn);
13586: fnd_msg_pub.add;
13587: RAISE fnd_api.g_exc_error;
13588: ELSE

Line 13585: --fnd_message.set_token('LPN', l_lpn);

13581: l_cur_mtrl_wlpn_mismatch;
13582: l_progress := 4 ;
13583: IF cur_mtrl_wlpn_mismatch%FOUND THEN
13584: fnd_message.set_name('WMS', 'WMS_LPN_SUBLOC_MISMATCH');
13585: --fnd_message.set_token('LPN', l_lpn);
13586: fnd_msg_pub.add;
13587: RAISE fnd_api.g_exc_error;
13588: ELSE
13589: IF (l_debug = 1) THEN

Line 13615: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT');

13611: cur_mtrl_wlc_lot_mismatch
13612: INTO
13613: l_cur_mtrl_wlc_lot_mismatch ;
13614: IF (cur_mtrl_wlc_lot_mismatch%found) THEN
13615: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT');
13616: --fnd_message.set_token('LPN', l_lpn);
13617: fnd_msg_pub.add;
13618: RAISE fnd_api.g_exc_error;
13619:

Line 13616: --fnd_message.set_token('LPN', l_lpn);

13612: INTO
13613: l_cur_mtrl_wlc_lot_mismatch ;
13614: IF (cur_mtrl_wlc_lot_mismatch%found) THEN
13615: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT');
13616: --fnd_message.set_token('LPN', l_lpn);
13617: fnd_msg_pub.add;
13618: RAISE fnd_api.g_exc_error;
13619:
13620: ELSE