327: mydebug('create_mo_line: ' || l_return_status);
328: END IF;
329:
330: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
331: fnd_message.set_name('WMS', 'WMS_TD_MOL_ERROR');
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_unexpected_error;
334: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
335: fnd_message.set_name('WMS', 'WMS_TD_MOL_ERROR');
331: fnd_message.set_name('WMS', 'WMS_TD_MOL_ERROR');
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_unexpected_error;
334: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
335: fnd_message.set_name('WMS', 'WMS_TD_MOL_ERROR');
336: fnd_msg_pub.ADD;
337: RAISE fnd_api.g_exc_error;
338: END IF;
339:
410: END LOOP;
411: END IF;
412:
413: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
414: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
415: fnd_msg_pub.ADD;
416: RAISE fnd_api.g_exc_unexpected_error;
417: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
418: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
414: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
415: fnd_msg_pub.ADD;
416: RAISE fnd_api.g_exc_unexpected_error;
417: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
418: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
419: fnd_msg_pub.ADD;
420: RAISE fnd_api.g_exc_error;
421: END IF;
422: END IF;
551: AND line_status <> inv_globals.g_to_status_closed
552: AND NVL(project_id, -1) <> NVL(p_project_id, -1)
553: AND NVL(task_id, -1) <> NVL(p_task_id, -1));
554:
555: fnd_message.set_name('WMS', 'WMS_PROJ_LPN_COMINGLE');
556: fnd_msg_pub.ADD;
557: RAISE fnd_api.g_exc_error;
558: EXCEPTION
559: WHEN NO_DATA_FOUND THEN
709: END LOOP;
710: END IF;
711:
712: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
713: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
714: fnd_msg_pub.ADD;
715: RAISE fnd_api.g_exc_unexpected_error;
716: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
717: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
713: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
714: fnd_msg_pub.ADD;
715: RAISE fnd_api.g_exc_unexpected_error;
716: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
717: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
718: fnd_msg_pub.ADD;
719: RAISE fnd_api.g_exc_error;
720: END IF;
721:
782: IF (l_debug = 1) THEN
783: mydebug('create_mo: UnexpError In CG');
784: END IF;
785:
786: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
787: fnd_msg_pub.ADD;
788: RAISE fnd_api.g_exc_unexpected_error;
789: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
790: IF (l_debug = 1) THEN
790: IF (l_debug = 1) THEN
791: mydebug('create_mo: Error In CG');
792: END IF;
793:
794: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_error;
797: END IF;
798: END IF;
829: , x_line_id => x_line_id
830: );
831:
832: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
833: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
834: fnd_msg_pub.ADD;
835: RAISE fnd_api.g_exc_unexpected_error;
836: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
837: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
833: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
834: fnd_msg_pub.ADD;
835: RAISE fnd_api.g_exc_unexpected_error;
836: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
837: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
838: fnd_msg_pub.ADD;
839: RAISE fnd_api.g_exc_error;
840: END IF;
841: END IF;
1233: IF (l_debug = 1) THEN
1234: mydebug('suggestions_pub: Not an INV LPN');
1235: END IF;
1236:
1237: fnd_message.set_name('WMS', 'WMS_MO_NOT_FOUND');
1238: fnd_msg_pub.ADD;
1239: RAISE fnd_api.g_exc_error;
1240: END IF;
1241: END IF; -- (l_rcount=0) -- fixed in ATF
1499: END LOOP;
1500: END IF;
1501:
1502: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1503: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
1504: fnd_msg_pub.ADD;
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1507: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
1503: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
1504: fnd_msg_pub.ADD;
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1507: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
1508: fnd_msg_pub.ADD;
1509: RAISE fnd_api.g_exc_error;
1510: END IF;
1511:
2075: IF (l_debug = 1) THEN
2076: mydebug('suggestions_pub: unexpected error in inv_ppengine_pvt.create_suggestions');
2077: END IF;
2078:
2079: fnd_message.set_name('WMS', 'WMS_ALLOCATE_FAIL');
2080: fnd_msg_pub.ADD;
2081: RAISE fnd_api.g_exc_error;
2082: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2083: IF (l_debug = 1) THEN
2083: IF (l_debug = 1) THEN
2084: mydebug('suggestions_pub: expected error in inv_ppengine_pvt.create_suggestions');
2085: END IF;
2086:
2087: fnd_message.set_name('WMS', 'WMS_ALLOCATE_FAIL');
2088: fnd_msg_pub.ADD;
2089: RAISE fnd_api.g_exc_error;
2090: END IF;
2091:
2175: -- since the savepoint is never set. Also setting a
2176: -- different error message since the one used initially
2177: -- doesn't seem to be a valid seeded message.
2178: --ROLLBACK TO mtl_stat_chk;
2179: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_STATUS');
2180: fnd_message.set_name('WMS', 'WMS_INVALID_LPN_ITEM_STATUS');
2181: fnd_msg_pub.ADD;
2182: RAISE fnd_api.g_exc_error;
2183: END IF;
2176: -- different error message since the one used initially
2177: -- doesn't seem to be a valid seeded message.
2178: --ROLLBACK TO mtl_stat_chk;
2179: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_STATUS');
2180: fnd_message.set_name('WMS', 'WMS_INVALID_LPN_ITEM_STATUS');
2181: fnd_msg_pub.ADD;
2182: RAISE fnd_api.g_exc_error;
2183: END IF;
2184:
3105: err_num => l_errNum,
3106: err_code => l_errCode,
3107: err_msg => l_errMsg);
3108: IF(l_cst_ret <> 1) THEN
3109: fnd_message.set_name('BOM', 'CST_SNAPSHOT_FAILED');
3110: fnd_msg_pub.ADD;
3111: IF (l_debug = 1) THEN
3112: mydebug('complete_putaway: Error from CSTACOSN.op_snapshot ');
3113: END IF;
3788:
3789: IF (l_debug = 1) THEN
3790: mydebug('complete_putaway: Current release is above J. Disallow 0 quantity.');
3791: END IF;
3792: fnd_message.set_name('INV', 'INV_QTY_MUST_EXCEED_ZERO');
3793: fnd_msg_pub.ADD;
3794:
3795: RAISE fnd_api.g_exc_error;
3796: END IF; --IF l_qty <= 0 THEN
3938: END LOOP;
3939: END IF;
3940:
3941: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3942: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
3943: fnd_msg_pub.ADD;
3944: RAISE fnd_api.g_exc_unexpected_error;
3945: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
3946: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
3942: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
3943: fnd_msg_pub.ADD;
3944: RAISE fnd_api.g_exc_unexpected_error;
3945: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
3946: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
3947: fnd_msg_pub.ADD;
3948: RAISE fnd_api.g_exc_error;
3949: END IF;
3950: ELSE
4785: , p_lot_number => p_lot
4786: );
4787:
4788: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4789: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4790: fnd_msg_pub.ADD;
4791: RAISE fnd_api.g_exc_unexpected_error;
4792: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4793: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4789: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4790: fnd_msg_pub.ADD;
4791: RAISE fnd_api.g_exc_unexpected_error;
4792: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4793: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4794: fnd_msg_pub.ADD;
4795: RAISE fnd_api.g_exc_error;
4796: END IF;
4797: END IF;
4826: , p_is_loc_desc => TRUE --Changes for Bug 3989684
4827: );
4828:
4829: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4830: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4831: fnd_msg_pub.ADD;
4832: RAISE fnd_api.g_exc_unexpected_error;
4833: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4834: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4830: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4831: fnd_msg_pub.ADD;
4832: RAISE fnd_api.g_exc_unexpected_error;
4833: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4834: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4835: fnd_msg_pub.ADD;
4836: RAISE fnd_api.g_exc_error;
4837: END IF;
4838: END IF;
4965: IF (l_debug = 1) THEN
4966: mydebug('complete_putaway : Error callinf WF wrapper');
4967: END IF;
4968:
4969: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
4970: fnd_msg_pub.ADD;
4971: RAISE fnd_api.g_exc_unexpected_error;
4972: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4973: IF (l_debug = 1) THEN
4973: IF (l_debug = 1) THEN
4974: mydebug('complete_putaway : Error calling WF wrapper');
4975: END IF;
4976:
4977: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
4978: fnd_msg_pub.ADD;
4979: RAISE fnd_api.g_exc_error;
4980: END IF;
4981: END IF;
5047: IF (l_debug = 1) THEN
5048: mydebug('complete_putaway : Error callinf WF wrapper');
5049: END IF;
5050:
5051: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5052: fnd_msg_pub.ADD;
5053: RAISE fnd_api.g_exc_unexpected_error;
5054: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5055: IF (l_debug = 1) THEN
5055: IF (l_debug = 1) THEN
5056: mydebug('complete_putaway : Error calling WF wrapper');
5057: END IF;
5058:
5059: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5060: fnd_msg_pub.ADD;
5061: RAISE fnd_api.g_exc_error;
5062: END IF;
5063: END IF;--END IF l_wf > 0 THEN
5102: l_drop_sub_type := wms_putaway_utils.get_subinventory_type(p_organization_id => p_org_id
5103: , p_subinventory_code => p_sub);
5104:
5105: IF (l_drop_sub_type < 0) THEN
5106: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
5107: fnd_msg_pub.add;
5108: IF (l_debug = 1) THEN
5109: mydebug('complete_putaway: Error fetching drop subinventory type');
5110: END IF;
5157: mydebug('complete_putaway: After Karuns Delivery API');
5158: END IF;
5159:
5160: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5161: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5162: fnd_msg_pub.ADD;
5163: RAISE fnd_api.g_exc_unexpected_error;
5164: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5165: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5161: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5162: fnd_msg_pub.ADD;
5163: RAISE fnd_api.g_exc_unexpected_error;
5164: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5165: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5166: fnd_msg_pub.ADD;
5167: RAISE fnd_api.g_exc_error;
5168: END IF;
5169: --Receiving subinventory - Call Transfer API
5204: mydebug('complete_putaway: After Transfer API');
5205: END IF;
5206:
5207: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5208: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
5209: fnd_msg_pub.ADD;
5210: RAISE fnd_api.g_exc_unexpected_error;
5211: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5212: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
5208: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
5209: fnd_msg_pub.ADD;
5210: RAISE fnd_api.g_exc_unexpected_error;
5211: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5212: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
5213: fnd_msg_pub.ADD;
5214: RAISE fnd_api.g_exc_error;
5215: END IF;
5216: END IF; --END IF check sub type to call the corresponding API
5293: period_id => l_acct_period_id,
5294: open_past_period => l_open_past_period);
5295:
5296: IF l_acct_period_id <= 0 THEN
5297: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
5298: fnd_msg_pub.ADD;
5299: RAISE fnd_api.g_exc_unexpected_error;
5300: END IF;
5301: --End of changes for bug 5403420
5418: IF (l_debug = 1) THEN
5419: mydebug('complete_putaway : Error callinf WF wrapper');
5420: END IF;
5421:
5422: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5423: fnd_msg_pub.ADD;
5424: RAISE fnd_api.g_exc_unexpected_error;
5425: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5426: IF (l_debug = 1) THEN
5426: IF (l_debug = 1) THEN
5427: mydebug('complete_putaway : Error calling WF wrapper');
5428: END IF;
5429:
5430: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5431: fnd_msg_pub.ADD;
5432: RAISE fnd_api.g_exc_error;
5433: END IF;
5434: END IF; --IF l_wf > 0 THEN
5512: IF (l_debug = 1) THEN
5513: mydebug('complete_putaway : Error callinf WF wrapper');
5514: END IF;
5515:
5516: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5517: fnd_msg_pub.ADD;
5518: RAISE fnd_api.g_exc_unexpected_error;
5519: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5520: IF (l_debug = 1) THEN
5520: IF (l_debug = 1) THEN
5521: mydebug('complete_putaway : Error calling WF wrapper');
5522: END IF;
5523:
5524: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5525: fnd_msg_pub.ADD;
5526: RAISE fnd_api.g_exc_error;
5527: END IF;
5528: END IF;--END IF l_wf > 0 THEN
5837: WHEN NO_DATA_FOUND THEN
5838: IF (l_debug = 1) THEN
5839: mydebug('check_lpn_validity: LPN does not belong to ' || l_org_id || ' organization');
5840: END IF;
5841: fnd_message.set_name('INV', 'INV_NO_RESULT_FOUND');
5842: fnd_msg_pub.ADD;
5843: RAISE fnd_api.g_exc_unexpected_error;
5844: END;
5845:
5866: IF (l_debug = 1) THEN
5867: mydebug('check_lpn_validity: LPN does not belong to ' || l_org_id || ' organization');
5868: END IF;
5869:
5870: fnd_message.set_name('INV', 'INV_NO_RESULT_FOUND');
5871: fnd_msg_pub.ADD;
5872: RAISE fnd_api.g_exc_unexpected_error;
5873: WHEN record_locked THEN
5874: IF (l_debug = 1) THEN
5874: IF (l_debug = 1) THEN
5875: mydebug('check_lpn_validity: LPN not available. locked by someone else');
5876: END IF;
5877:
5878: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
5879: fnd_msg_pub.ADD;
5880: RAISE fnd_api.g_exc_unexpected_error;
5881: END;
5882: END IF;
6199: mydebug('check_lpn_validity: LPN is being processed by somebody else and hence cannot be putaway');
6200: END IF;
6201:
6202: x_ret := 3;
6203: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
6204: fnd_msg_pub.ADD;
6205: RAISE fnd_api.g_exc_unexpected_error;
6206: END IF;
6207: END IF;
6333: END IF;
6334: EXCEPTION
6335: WHEN OTHERS THEN
6336: x_return_status := fnd_api.g_ret_sts_error;
6337: fnd_message.set_name('WMS', 'WMS_TD_AT_FAIL');
6338: fnd_msg_pub.ADD;
6339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6340: END archive_task;
6341:
6467: mydebug('Other exception occurred: ' || sqlerrm);
6468: END IF;
6469:
6470: x_return_status := fnd_api.g_ret_sts_error;
6471: fnd_message.set_name('WMS', 'WMS_TD_AT_FAIL');
6472: fnd_msg_pub.ADD;
6473: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6474: END archive_task;
6475:
6771: END IF;
6772: EXCEPTION
6773: WHEN OTHERS THEN
6774: x_return_status := fnd_api.g_ret_sts_error;
6775: fnd_message.set_name('WMS', 'WMS_TD_PUT_CLEAN_FAIL');
6776: fnd_msg_pub.ADD;
6777: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6778: END putaway_cleanup;
6779:
6839: , x_msg_data => x_msg_data
6840: );
6841:
6842: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6843: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6844: fnd_msg_pub.ADD;
6845: RAISE fnd_api.g_exc_unexpected_error;
6846: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6847: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6843: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6844: fnd_msg_pub.ADD;
6845: RAISE fnd_api.g_exc_unexpected_error;
6846: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6847: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6848: fnd_msg_pub.ADD;
6849: RAISE fnd_api.g_exc_error;
6850: END IF;
6851:
7091: mydebug('validate_putaway_to_lpn : Exception : ' || SQLERRM);
7092: END IF;
7093:
7094: x_return_status := fnd_api.g_ret_sts_error;
7095: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
7096: fnd_msg_pub.ADD;
7097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7098: END validate_putaway_to_lpn;
7099:
7565: END LOOP;
7566: END IF;
7567:
7568: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7569: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
7570: fnd_msg_pub.ADD;
7571: RAISE fnd_api.g_exc_error;
7572: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
7573: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
7569: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
7570: fnd_msg_pub.ADD;
7571: RAISE fnd_api.g_exc_error;
7572: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
7573: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
7574: fnd_msg_pub.ADD;
7575: RAISE fnd_api.g_exc_error;
7576: END IF;
7577: