[Home] [Help]
197: x_return_status := fnd_api.g_ret_sts_success;
198: EXCEPTION
199: WHEN OTHERS THEN
200: x_return_status := fnd_api.g_ret_sts_unexp_error;
201: fnd_message.set_name('WMS', 'WMS_TD_INSERT_TASK');
202: fnd_msg_pub.ADD;
203: END insert_task;
204:
205: PROCEDURE next_task(
320: IF (l_debug = 1) THEN
321: mydebug('next_task: Period is invalid');
322: END IF;
323:
324: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
325: fnd_msg_pub.ADD;
326: RAISE fnd_api.g_exc_unexpected_error;
327: END IF;
328:
911: END IF;
912:
913: COMMIT;
914: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
915: fnd_message.set_name('WMS', 'WMS_TD_TDENG_ERROR');
916: fnd_msg_pub.ADD;
917: RAISE fnd_api.g_exc_unexpected_error;
918: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
919: IF (l_debug = 1) THEN
1091: IF (l_debug = 1) THEN
1092: mydebug('next_CP_task: Period is invalid');
1093: END IF;
1094:
1095: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
1096: fnd_msg_pub.ADD;
1097: RAISE fnd_api.g_exc_unexpected_error;
1098: END IF;
1099:
1466: END IF;
1467:
1468: COMMIT;
1469: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1470: fnd_message.set_name('WMS', 'WMS_TD_TDENG_ERROR');
1471: fnd_msg_pub.ADD;
1472: RAISE fnd_api.g_exc_unexpected_error;
1473: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1474: IF (l_debug = 1) THEN
1836: END LOOP;
1837: END IF;
1838:
1839: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1840: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
1841: fnd_msg_pub.ADD;
1842: RAISE fnd_api.g_exc_unexpected_error;
1843: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1844: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
1840: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
1841: fnd_msg_pub.ADD;
1842: RAISE fnd_api.g_exc_unexpected_error;
1843: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1844: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
1845: fnd_msg_pub.ADD;
1846: RAISE fnd_api.g_exc_error;
1847: END IF;
1848: ELSE
2758: IF (l_debug = 1) THEN
2759: mydebug('lpn_match: lpn does not exist in org');
2760: END IF;
2761:
2762: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2763: fnd_msg_pub.ADD;
2764: RAISE fnd_api.g_exc_error;
2765: END;
2766:
2770: IF (l_debug = 1) THEN
2771: mydebug('lpn_match: lpn does not exist in org');
2772: END IF;
2773:
2774: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2775: fnd_msg_pub.ADD;
2776: RAISE fnd_api.g_exc_error;
2777: END IF;
2778:
2800: END;
2801:
2802: IF l_loaded > 0 THEN
2803: x_match := 7;
2804: fnd_message.set_name('WMS', 'WMS_LOADED_ERROR');
2805: fnd_msg_pub.ADD;
2806: RAISE fnd_api.g_exc_error;
2807: END IF;
2808:
2830: IF l_sub IS NULL THEN
2831: -- The calling java code treats this condition as an error
2832:
2833: x_match := 10;
2834: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
2835: fnd_msg_pub.ADD;
2836: RAISE fnd_api.g_exc_error;
2837: END IF;
2838:
2846: AND secondary_inventory_name = l_sub;
2847:
2848: IF l_sub_active = 0 THEN
2849: x_match := 10;
2850: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
2851: fnd_msg_pub.ADD;
2852: RAISE fnd_api.g_exc_error;
2853: END IF;
2854:
2862: AND inventory_location_id = l_loc_id;
2863:
2864: IF l_loc_active = 0 THEN
2865: x_match := 10;
2866: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOC');
2867: fnd_msg_pub.ADD;
2868: RAISE fnd_api.g_exc_error;
2869: END IF;
2870: -- Begin fix for 2774506
2892: mydebug('mil task id = '||l_mil_task_id);
2893:
2894: if ((l_mil_proj_id <> l_mmtt_proj_id ) or ( l_mil_task_id <> l_mmtt_task_id )) then
2895: mydebug('lpn : the project/tak information does not match');
2896: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_INVALID_LPN');
2897: FND_MSG_PUB.ADD;
2898: RAISE FND_API.G_EXC_ERROR;
2899: end if ;
2900:
2906: x_loc_id := l_loc_id;
2907: EXCEPTION
2908: WHEN NO_DATA_FOUND THEN
2909: x_match := 6;
2910: fnd_message.set_name('WMS', 'WMS_TD_LPN_LOC_NOT_FOUND');
2911: fnd_msg_pub.ADD;
2912: RAISE fnd_api.g_exc_error;
2913: END;
2914:
2937: END;
2938:
2939: IF l_so_cnt > 0 THEN
2940: x_match := 12;
2941: fnd_message.set_name('WMS', 'WMS_LPN_STAGED');
2942: fnd_msg_pub.ADD;
2943: RAISE fnd_api.g_exc_error;
2944: END IF;
2945:
2988: mydebug('lpn_match: item lot rev combo does not exist');
2989: END IF;
2990:
2991: x_match := 5;
2992: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2993: fnd_msg_pub.ADD;
2994: RAISE fnd_api.g_exc_error;
2995: END;
2996:
3019: mydebug('lpn_match:lot rev combo for the item does not exist');
3020: END IF;
3021:
3022: x_match := 5;
3023: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LOT_LPN');
3024: fnd_msg_pub.ADD;
3025: RAISE fnd_api.g_exc_error;
3026: END;
3027: END IF;
3068: IF (l_debug = 1) THEN
3069: mydebug('lpn_match: transaction does not exist in mmtt');
3070: END IF;
3071:
3072: fnd_message.set_name('INV', 'INV_INVALID_TRANSACTION');
3073: fnd_msg_pub.ADD;
3074: RAISE fnd_api.g_exc_error;
3075: END;
3076:
3218: IF (l_debug = 1) THEN
3219: mydebug('lpn_match: calling update qty tree with lpn 1st time failed ');
3220: END IF;
3221:
3222: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3223: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3224: fnd_msg_pub.ADD;
3225: RAISE fnd_api.g_exc_error;
3226: END IF;
3219: mydebug('lpn_match: calling update qty tree with lpn 1st time failed ');
3220: END IF;
3221:
3222: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3223: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3224: fnd_msg_pub.ADD;
3225: RAISE fnd_api.g_exc_error;
3226: END IF;
3227: ELSE
3261: IF (l_debug = 1) THEN
3262: mydebug('lpn_match: calling update qty tree back without lpn 1st time failed ');
3263: END IF;
3264:
3265: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3266: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3267: fnd_msg_pub.ADD;
3268: RAISE fnd_api.g_exc_error;
3269: END IF;
3262: mydebug('lpn_match: calling update qty tree back without lpn 1st time failed ');
3263: END IF;
3264:
3265: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3266: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3267: fnd_msg_pub.ADD;
3268: RAISE fnd_api.g_exc_error;
3269: END IF;
3270: END IF;
3333: IF (l_debug = 1) THEN
3334: mydebug('lpn_match: calling qty tree 1st time failed ');
3335: END IF;
3336:
3337: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3338: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3339: fnd_msg_pub.ADD;
3340: RAISE fnd_api.g_exc_error;
3341: END IF;
3334: mydebug('lpn_match: calling qty tree 1st time failed ');
3335: END IF;
3336:
3337: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3338: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3339: fnd_msg_pub.ADD;
3340: RAISE fnd_api.g_exc_error;
3341: END IF;
3342:
3379: IF (l_debug = 1) THEN
3380: mydebug('lpn_match: calling update qty tree back with lpn 1st time failed ');
3381: END IF;
3382:
3383: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3384: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3385: fnd_msg_pub.ADD;
3386: RAISE fnd_api.g_exc_error;
3387: END IF;
3380: mydebug('lpn_match: calling update qty tree back with lpn 1st time failed ');
3381: END IF;
3382:
3383: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3384: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3385: fnd_msg_pub.ADD;
3386: RAISE fnd_api.g_exc_error;
3387: END IF;
3388: ELSE
3422: IF (l_debug = 1) THEN
3423: mydebug('lpn_match: calling update qty tree back without lpn 1st time failed ');
3424: END IF;
3425:
3426: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3427: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3428: fnd_msg_pub.ADD;
3429: RAISE fnd_api.g_exc_error;
3430: END IF;
3423: mydebug('lpn_match: calling update qty tree back without lpn 1st time failed ');
3424: END IF;
3425:
3426: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3427: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3428: fnd_msg_pub.ADD;
3429: RAISE fnd_api.g_exc_error;
3430: END IF;
3431: END IF;
3459: END IF;
3460:
3461: -- Serial numbers missing for the transaction
3462: x_match := 9;
3463: fnd_message.set_name('INV', 'INV_INT_SERMISEXP');
3464: fnd_msg_pub.ADD;
3465: RAISE fnd_api.g_exc_error;
3466: END IF;
3467:
3555: IF (l_debug = 1) THEN
3556: mydebug('lpn_match: calling update qty tree with lpn 2nd time failed ');
3557: END IF;
3558:
3559: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3560: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3561: fnd_msg_pub.ADD;
3562: RAISE fnd_api.g_exc_error;
3563: END IF;
3556: mydebug('lpn_match: calling update qty tree with lpn 2nd time failed ');
3557: END IF;
3558:
3559: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3560: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3561: fnd_msg_pub.ADD;
3562: RAISE fnd_api.g_exc_error;
3563: END IF;
3564: ELSE
3598: IF (l_debug = 1) THEN
3599: mydebug('lpn_match: calling update qty tree back without lpn 2nd time failed ');
3600: END IF;
3601:
3602: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3603: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3604: fnd_msg_pub.ADD;
3605: RAISE fnd_api.g_exc_error;
3606: END IF;
3599: mydebug('lpn_match: calling update qty tree back without lpn 2nd time failed ');
3600: END IF;
3601:
3602: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3603: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3604: fnd_msg_pub.ADD;
3605: RAISE fnd_api.g_exc_error;
3606: END IF;
3607: END IF;
3639: IF (l_debug = 1) THEN
3640: mydebug('lpn_match: calling qty tree 2nd time failed ');
3641: END IF;
3642:
3643: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3644: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3645: fnd_msg_pub.ADD;
3646: RAISE fnd_api.g_exc_error;
3647: END IF;
3640: mydebug('lpn_match: calling qty tree 2nd time failed ');
3641: END IF;
3642:
3643: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3644: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3645: fnd_msg_pub.ADD;
3646: RAISE fnd_api.g_exc_error;
3647: END IF;
3648:
3685: IF (l_debug = 1) THEN
3686: mydebug('lpn_match: calling update qty tree with lpn 2nd time failed ');
3687: END IF;
3688:
3689: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3690: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3691: fnd_msg_pub.ADD;
3692: RAISE fnd_api.g_exc_error;
3693: END IF;
3686: mydebug('lpn_match: calling update qty tree with lpn 2nd time failed ');
3687: END IF;
3688:
3689: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3690: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3691: fnd_msg_pub.ADD;
3692: RAISE fnd_api.g_exc_error;
3693: END IF;
3694: ELSE
3728: IF (l_debug = 1) THEN
3729: mydebug('lpn_match: calling update qty tree back without lpn 2nd time failed ');
3730: END IF;
3731:
3732: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3733: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3734: fnd_msg_pub.ADD;
3735: RAISE fnd_api.g_exc_error;
3736: END IF;
3729: mydebug('lpn_match: calling update qty tree back without lpn 2nd time failed ');
3730: END IF;
3731:
3732: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3733: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3734: fnd_msg_pub.ADD;
3735: RAISE fnd_api.g_exc_error;
3736: END IF;
3737: END IF;
3793: END IF;
3794:
3795: -- Serial numbers missing for the transaction
3796: x_match := 9;
3797: fnd_message.set_name('INV', 'INV_INT_SERMISEXP');
3798: fnd_msg_pub.ADD;
3799: RAISE fnd_api.g_exc_error;
3800: END IF;
3801: END IF;
3938: IF (l_debug = 1) THEN
3939: mydebug('lpn_match: calling update qty tree with lpn 3rd time failed ');
3940: END IF;
3941:
3942: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3943: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3944: fnd_msg_pub.ADD;
3945: RAISE fnd_api.g_exc_error;
3946: END IF;
3939: mydebug('lpn_match: calling update qty tree with lpn 3rd time failed ');
3940: END IF;
3941:
3942: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3943: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3944: fnd_msg_pub.ADD;
3945: RAISE fnd_api.g_exc_error;
3946: END IF;
3947: ELSE
3981: IF (l_debug = 1) THEN
3982: mydebug('lpn_match: calling update qty tree back 3rd time without lpn 3rd time failed ');
3983: END IF;
3984:
3985: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3986: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3987: fnd_msg_pub.ADD;
3988: RAISE fnd_api.g_exc_error;
3989: END IF;
3982: mydebug('lpn_match: calling update qty tree back 3rd time without lpn 3rd time failed ');
3983: END IF;
3984:
3985: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3986: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3987: fnd_msg_pub.ADD;
3988: RAISE fnd_api.g_exc_error;
3989: END IF;
3990: END IF;
4064: IF (l_debug = 1) THEN
4065: mydebug('lpn_match: calling qty tree 3rd time failed ');
4066: END IF;
4067:
4068: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4069: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4070: fnd_msg_pub.ADD;
4071: RAISE fnd_api.g_exc_error;
4072: END IF;
4065: mydebug('lpn_match: calling qty tree 3rd time failed ');
4066: END IF;
4067:
4068: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4069: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4070: fnd_msg_pub.ADD;
4071: RAISE fnd_api.g_exc_error;
4072: END IF;
4073:
4159: IF (l_debug = 1) THEN
4160: mydebug('lpn_match: calling update qty tree with lpn 3rd time failed ');
4161: END IF;
4162:
4163: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4164: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4165: fnd_msg_pub.ADD;
4166: RAISE fnd_api.g_exc_error;
4167: END IF;
4160: mydebug('lpn_match: calling update qty tree with lpn 3rd time failed ');
4161: END IF;
4162:
4163: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4164: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4165: fnd_msg_pub.ADD;
4166: RAISE fnd_api.g_exc_error;
4167: END IF;
4168: ELSE
4202: IF (l_debug = 1) THEN
4203: mydebug('lpn_match: calling update qty tree back without lpn 3rd time failed ');
4204: END IF;
4205:
4206: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4207: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4208: fnd_msg_pub.ADD;
4209: RAISE fnd_api.g_exc_error;
4210: END IF;
4203: mydebug('lpn_match: calling update qty tree back without lpn 3rd time failed ');
4204: END IF;
4205:
4206: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4207: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4208: fnd_msg_pub.ADD;
4209: RAISE fnd_api.g_exc_error;
4210: END IF;
4211: END IF;
4289: END IF;
4290:
4291: -- Serial numbers missing for the transaction
4292: x_match := 9;
4293: fnd_message.set_name('INV', 'INV_INT_SERMISEXP');
4294: fnd_msg_pub.ADD;
4295: RAISE fnd_api.g_exc_error;
4296: END IF;
4297: END IF;
4388: IF (l_debug = 1) THEN
4389: mydebug('lpn_match: calling update qty tree with lpn 4th time failed ');
4390: END IF;
4391:
4392: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4393: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4394: fnd_msg_pub.ADD;
4395: RAISE fnd_api.g_exc_error;
4396: END IF;
4389: mydebug('lpn_match: calling update qty tree with lpn 4th time failed ');
4390: END IF;
4391:
4392: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4393: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4394: fnd_msg_pub.ADD;
4395: RAISE fnd_api.g_exc_error;
4396: END IF;
4397: ELSE
4431: IF (l_debug = 1) THEN
4432: mydebug('lpn_match: calling update qty tree without lpn 4th time failed ');
4433: END IF;
4434:
4435: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4436: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4437: fnd_msg_pub.ADD;
4438: RAISE fnd_api.g_exc_error;
4439: END IF;
4432: mydebug('lpn_match: calling update qty tree without lpn 4th time failed ');
4433: END IF;
4434:
4435: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4436: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4437: fnd_msg_pub.ADD;
4438: RAISE fnd_api.g_exc_error;
4439: END IF;
4440: END IF;
4512: IF (l_debug = 1) THEN
4513: mydebug('lpn_match: calling qty tree 4th time failed');
4514: END IF;
4515:
4516: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4517: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4518: fnd_msg_pub.ADD;
4519: RAISE fnd_api.g_exc_error;
4520: END IF;
4513: mydebug('lpn_match: calling qty tree 4th time failed');
4514: END IF;
4515:
4516: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4517: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4518: fnd_msg_pub.ADD;
4519: RAISE fnd_api.g_exc_error;
4520: END IF;
4521:
4558: IF (l_debug = 1) THEN
4559: mydebug('lpn_match: calling update qty tree back with lpn 4th time failed ');
4560: END IF;
4561:
4562: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4563: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4564: fnd_msg_pub.ADD;
4565: RAISE fnd_api.g_exc_error;
4566: END IF;
4559: mydebug('lpn_match: calling update qty tree back with lpn 4th time failed ');
4560: END IF;
4561:
4562: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4563: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4564: fnd_msg_pub.ADD;
4565: RAISE fnd_api.g_exc_error;
4566: END IF;
4567: ELSE
4601: IF (l_debug = 1) THEN
4602: mydebug('lpn_match: calling update qty tree back without lpn 4th time failed ');
4603: END IF;
4604:
4605: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4606: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4607: fnd_msg_pub.ADD;
4608: RAISE fnd_api.g_exc_error;
4609: END IF;
4602: mydebug('lpn_match: calling update qty tree back without lpn 4th time failed ');
4603: END IF;
4604:
4605: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4606: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4607: fnd_msg_pub.ADD;
4608: RAISE fnd_api.g_exc_error;
4609: END IF;
4610: END IF;
4686: END IF;
4687:
4688: x_match := 11;
4689: CLOSE ser_csr;
4690: fnd_message.set_name('INV', 'INV_SER_STATUS_NA');
4691: fnd_message.set_token('TOKEN', l_serial_number);
4692: fnd_msg_pub.ADD;
4693: RAISE fnd_api.g_exc_error;
4694: END IF;
4687:
4688: x_match := 11;
4689: CLOSE ser_csr;
4690: fnd_message.set_name('INV', 'INV_SER_STATUS_NA');
4691: fnd_message.set_token('TOKEN', l_serial_number);
4692: fnd_msg_pub.ADD;
4693: RAISE fnd_api.g_exc_error;
4694: END IF;
4695: END LOOP;
4715: ) = 'N' THEN
4716: x_match := 8;
4717: -- LPN status is invalid for this operation
4718:
4719: fnd_message.set_name('INV', 'INV_INVALID_LPN_STATUS');
4720: fnd_message.set_token('TOKEN1', TO_CHAR(p_lpn));
4721: fnd_msg_pub.ADD;
4722: RAISE fnd_api.g_exc_error;
4723: END IF;
4716: x_match := 8;
4717: -- LPN status is invalid for this operation
4718:
4719: fnd_message.set_name('INV', 'INV_INVALID_LPN_STATUS');
4720: fnd_message.set_token('TOKEN1', TO_CHAR(p_lpn));
4721: fnd_msg_pub.ADD;
4722: RAISE fnd_api.g_exc_error;
4723: END IF;
4724: END IF;
4801: IF (l_debug = 1) THEN
4802: mydebug('lpn_match: Serial numbers should not be allocated');
4803: END IF;
4804: x_match := 9;
4805: FND_MESSAGE.SET_NAME('INV','INV_INT_SERMISEXP');
4806: FND_MSG_PUB.ADD;
4807: RAISE FND_API.G_EXC_ERROR;
4808:
4809: END IF;
4911: , p_entire_lpn => 'Y'
4912: );
4913:
4914: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4915: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
4916: fnd_msg_pub.ADD;
4917: RAISE fnd_api.g_exc_unexpected_error;
4918: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
4919: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
4915: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
4916: fnd_msg_pub.ADD;
4917: RAISE fnd_api.g_exc_unexpected_error;
4918: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
4919: fnd_message.set_name('WMS', 'WMS_MULT_LPN_ERROR');
4920: fnd_msg_pub.ADD;
4921: RAISE fnd_api.g_exc_error;
4922: END IF;
4923:
5279: END LOOP;
5280: END IF;
5281:
5282: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5283: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
5284: fnd_msg_pub.ADD;
5285: RAISE fnd_api.g_exc_unexpected_error;
5286: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5287: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
5283: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
5284: fnd_msg_pub.ADD;
5285: RAISE fnd_api.g_exc_unexpected_error;
5286: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5287: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
5288: fnd_msg_pub.ADD;
5289: RAISE fnd_api.g_exc_error;
5290: END IF;
5291: ELSE
5320: IF (l_debug = 1) THEN
5321: mydebug('load_pick: LPN ' || p_from_lpn_id || ' has been already loaded so error out');
5322: END IF;
5323:
5324: fnd_message.set_name('WMS', 'WMS_LPN_LOADED_ERROR');
5325: fnd_msg_pub.ADD;
5326: RAISE fnd_api.g_exc_error;
5327: END;
5328: END IF;
5567: mydebug('after logging exception for qty discrepancy');
5568: END IF;
5569:
5570: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5571: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
5572: fnd_msg_pub.ADD;
5573: RAISE fnd_api.g_exc_unexpected_error;
5574: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5575: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
5571: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
5572: fnd_msg_pub.ADD;
5573: RAISE fnd_api.g_exc_unexpected_error;
5574: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5575: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
5576: fnd_msg_pub.ADD;
5577: RAISE fnd_api.g_exc_error;
5578: END IF;
5579: END IF;
5609: mydebug('after logging exception for loc discrepancy');
5610: END IF;
5611:
5612: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
5613: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
5614: fnd_msg_pub.ADD;
5615: RAISE fnd_api.g_exc_unexpected_error;
5616: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5617: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
5613: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
5614: fnd_msg_pub.ADD;
5615: RAISE fnd_api.g_exc_unexpected_error;
5616: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5617: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
5618: fnd_msg_pub.ADD;
5619: RAISE fnd_api.g_exc_error;
5620: END IF;
5621: END IF;
5674: IF (l_debug = 1) THEN
5675: mydebug('load_pick : Error callinf WF wrapper');
5676: END IF;
5677:
5678: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5679: fnd_msg_pub.ADD;
5680: RAISE fnd_api.g_exc_unexpected_error;
5681: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
5682: IF (l_debug = 1) THEN
5682: IF (l_debug = 1) THEN
5683: mydebug('load_pick : Error calling WF wrapper');
5684: END IF;
5685:
5686: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5687: fnd_msg_pub.ADD;
5688: RAISE fnd_api.g_exc_error;
5689: END IF;
5690: END IF;
6206: END LOOP;
6207: END IF;
6208:
6209: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6210: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6211: fnd_msg_pub.ADD;
6212: RAISE fnd_api.g_exc_unexpected_error;
6213: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6214: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6210: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6211: fnd_msg_pub.ADD;
6212: RAISE fnd_api.g_exc_unexpected_error;
6213: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6214: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6215: fnd_msg_pub.ADD;
6216: RAISE fnd_api.g_exc_error;
6217: END IF;
6218: ELSE
6788: , p_source_line_detail_id => NULL
6789: );
6790:
6791: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
6792: fnd_message.set_name('WMS', 'WMS_TD_MODIFY_LPN_ERROR');
6793: fnd_msg_pub.ADD;
6794: RAISE fnd_api.g_exc_unexpected_error;
6795: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6796: fnd_message.set_name('WMS', 'WMS_TD_MODIFY_LPN_ERROR');
6792: fnd_message.set_name('WMS', 'WMS_TD_MODIFY_LPN_ERROR');
6793: fnd_msg_pub.ADD;
6794: RAISE fnd_api.g_exc_unexpected_error;
6795: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
6796: fnd_message.set_name('WMS', 'WMS_TD_MODIFY_LPN_ERROR');
6797: fnd_msg_pub.ADD;
6798: RAISE fnd_api.g_exc_error;
6799: END IF;
6800: END IF;
8065: --
8066: -- Standard call to check for call compatibility
8067: --
8068: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
8069: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
8070: fnd_msg_pub.ADD;
8071: RAISE fnd_api.g_exc_error;
8072: END IF;
8073:
8193: mydebug(' lpn_id => ' || pick_to_lpn_rec.lpn_id);
8194: mydebug(' l_mmtt_mo_type => ' || l_mmtt_mo_type);
8195: mydebug(' l_mo_type_in_lpn => ' || l_mo_type_in_lpn);
8196: END IF;
8197: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_MO_TYPE');
8198: fnd_msg_pub.ADD;
8199: RAISE fnd_api.g_exc_error;
8200: ELSIF l_mmtt_txn_type_id = 35
8201: OR l_mmtt_txn_type_id = 51 THEN -- Mfg pick
8203: IF (l_debug = 1) THEN
8204: mydebug('validate_pick_to_lpn: This is a manufacturing component pick.');
8205: mydebug('WIP entity type IS NOT the same AS that OF the old mmtt RECORD');
8206: END IF;
8207: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_MFG_MODE');
8208: fnd_msg_pub.ADD;
8209: RAISE fnd_api.g_exc_error;
8210: END IF;
8211: END IF;
8274: mydebug('validate_pick_to_lpn: Drop LPN is going to an LPN controlled sub');
8275: mydebug('validate_pick_to_lpn: Cannot add picks not going to the same sub');
8276: END IF;
8277:
8278: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_SUBINV');
8279: fnd_msg_pub.ADD;
8280: RAISE fnd_api.g_exc_error;
8281: END IF;
8282: ELSE
8315: IF (l_debug = 1) THEN
8316: mydebug('validate_pick_to_lpn: Drop LPN has pick(s) for an LPN-controlled sub');
8317: END IF;
8318:
8319: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_SUBINV');
8320: fnd_msg_pub.ADD;
8321: RAISE fnd_api.g_exc_error;
8322: END IF;
8323: END IF;
8345: IF (l_debug = 1) THEN
8346: mydebug('validate_pick_to_lpn: Drop LPN is associated with material FOR a different operation plan');
8347: END IF;
8348:
8349: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_OPER_PLAN');
8350: fnd_msg_pub.ADD;
8351: RAISE fnd_api.g_exc_error;
8352: END IF;
8353:
8394: IF (l_debug = 1) THEN
8395: mydebug('validate_pick_to_lpn: can NOT find move order line for current task');
8396: END IF;
8397:
8398: fnd_message.set_name('WMS', 'WMS_NO_MOL');
8399: fnd_msg_pub.ADD;
8400: RAISE fnd_api.g_exc_error;
8401: END IF;
8402:
8439: IF (l_debug = 1) THEN
8440: mydebug('validate_pick_to_lpn: can NOT find either wdd or wda for tasks in the lpn');
8441: END IF;
8442:
8443: fnd_message.set_name('WMS', 'WMS_NO_WDD_WDA');
8444: fnd_msg_pub.ADD;
8445: RAISE fnd_api.g_exc_error;
8446: END IF;
8447:
8456: IF (l_debug = 1) THEN
8457: mydebug('validate_pick_to_lpn: other tasks in lpn have different deliveries');
8458: END IF;
8459:
8460: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
8461: fnd_msg_pub.ADD;
8462: RAISE fnd_api.g_exc_error;
8463: END IF;
8464: ELSE -- they have different carton_grouping_id
8510: l_same_carton_grouping := FALSE;
8511: END IF;
8512: END;
8513: IF (l_same_carton_grouping = FALSE) then
8514: fnd_message.set_name('WMS', 'WMS_DIFF_CARTON_GROUP');
8515: fnd_msg_pub.ADD;
8516: RAISE fnd_api.g_exc_error;
8517: END IF; --End of fix for bug#4440585.
8518:
8521: IF (l_debug = 1) THEN
8522: mydebug('validate_pick_to_lpn: some of tasks in lpn have NULL carton_grouping_id');
8523: END IF;
8524:
8525: fnd_message.set_name('WMS', 'WMS_CARTON_GROUP_NULL');
8526: fnd_msg_pub.ADD;
8527: RAISE fnd_api.g_exc_error;
8528: END IF;
8529: ELSE --carton_grouping_id is null
8531: mydebug('validate_pick_to_lpn: carton_grouping_id of current task is null');
8532: END IF;
8533: --bug3481923 only fail if it is not requisition on repl mo
8534: if (l_mmtt_mo_type not in(1,2)) then
8535: fnd_message.set_name('WMS', 'WMS_CARTON_GROUP_NULL');
8536: fnd_msg_pub.ADD;
8537: RAISE fnd_api.g_exc_error;
8538: end if;
8539: END IF;
8562: IF (l_debug = 1) THEN
8563: mydebug('validate_pick_to_lpn: Picked LPN and current MMTT go to different deliveries.');
8564: END IF;
8565:
8566: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
8567: fnd_msg_pub.ADD;
8568: RAISE fnd_api.g_exc_error;
8569: END IF;
8570: ELSIF l_pick_to_lpn_delivery_id2 IS NULL THEN
8577: mydebug('validate_pick_to_lpn: Current task has delivery.');
8578: mydebug('validate_pick_to_lpn: Picked LPN does not have delivery and current task has delivery.');
8579: END IF;
8580:
8581: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
8582: fnd_msg_pub.ADD;
8583: RAISE fnd_api.g_exc_error;
8584: END IF;
8585: ELSIF l_pick_to_lpn_delivery_id2 = -999 THEN
8608: IF (l_debug = 1) THEN
8609: mydebug('validate_pick_to_lpn: Picked LPN and current MMTT go to different deliveries.');
8610: END IF;
8611:
8612: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
8613: fnd_msg_pub.ADD;
8614: RAISE fnd_api.g_exc_error;
8615: ELSE
8616: --
8655: IF (l_debug = 1) THEN
8656: mydebug('validate_pick_to_lpn: LPNs are on diff deliveries.');
8657: END IF;
8658:
8659: fnd_message.set_name('WMS', 'WMS_PICK_TO_LPN_DIFF_DELIV');
8660: fnd_msg_pub.ADD;
8661: RAISE fnd_api.g_exc_error;
8662: ELSE
8663: --
9209: END LOOP;
9210: END IF;
9211:
9212: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
9213: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
9214: fnd_msg_pub.ADD;
9215: RAISE fnd_api.g_exc_unexpected_error;
9216: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
9217: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
9213: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
9214: fnd_msg_pub.ADD;
9215: RAISE fnd_api.g_exc_unexpected_error;
9216: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
9217: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
9218: fnd_msg_pub.ADD;
9219: RAISE fnd_api.g_exc_error;
9220: END IF;
9221: ELSIF p_to_lpn <> '-999' THEN
9324:
9325: l_progress := '160';
9326:
9327: IF l_pick_qty_remaining > l_mtl_reservation_tbl(1).primary_reservation_quantity THEN
9328: FND_MESSAGE.SET_NAME('INV','INV_INSUFF_QTY_RSV');
9329: FND_MSG_PUB.Add;
9330: RAISE fnd_api.g_exc_unexpected_error;
9331: END IF;
9332:
9352: l_progress := '170';
9353:
9354: -- Return an error if the transfer reservations call failed
9355: IF l_return_status <> fnd_api.g_ret_sts_success THEN
9356: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');
9357: FND_MSG_PUB.Add;
9358: RAISE fnd_api.g_exc_unexpected_error;
9359: END IF;
9360:
9369: IF (l_debug = 1) THEN
9370: mydebug('multiple_pick: Cannot transfer detailed reservation as confirmed sub is NOT reservable. cannot pick FROM NEW location. throw error');
9371: END IF;
9372:
9373: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');
9374: FND_MSG_PUB.ADD;
9375: RAISE FND_API.g_exc_unexpected_error;
9376:
9377: END IF;
9377: END IF;
9378:
9379: END IF;
9380: */
9381: fnd_message.set_name('INV', 'INV_TRANSFER_RSV_FAILED');
9382: fnd_msg_pub.ADD;
9383: RAISE fnd_api.g_exc_unexpected_error;
9384: END IF;
9385: END IF;
10162: WHERE MSNT.fm_serial_number = l_fm_serial;
10163:
10164: /*Bug#3957819.IF the serial number is already used , throw an error*/
10165: IF l_serial_count > 1 THEN
10166: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
10167: fnd_msg_pub.ADD;
10168: RAISE fnd_api.g_exc_error;
10169: END IF;
10170: /*End of fix for Bug#3957819 */
10244:
10245:
10246: /*Bug#3957819.IF the serial number is already used , throw an error*/
10247: IF l_serial_count > 1 THEN
10248: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
10249: fnd_msg_pub.ADD;
10250: RAISE fnd_api.g_exc_error;
10251: END IF;
10252: /*End of fix for Bug#3957819 */
10343: WHERE MSNT.fm_serial_number = l_fm_serial;
10344:
10345: /*Bug#3957819.IF the serial number is already used , throw an error*/
10346: IF l_serial_count > 1 THEN
10347: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
10348: fnd_msg_pub.ADD;
10349: RAISE fnd_api.g_exc_error;
10350: END IF;
10351: /*End of fix for Bug#3957819 */
10416: WHERE MSNT.fm_serial_number = l_fm_serial;
10417:
10418: /*Bug#3957819.IF the serial number is already used , throw an error*/
10419: IF l_serial_count > 1 THEN
10420: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
10421: fnd_msg_pub.ADD;
10422: RAISE fnd_api.g_exc_error;
10423: END IF;
10424: /*End of fix for Bug#3957819 */
10573: END LOOP;
10574: END IF;
10575:
10576: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
10577: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
10578: fnd_msg_pub.ADD;
10579: RAISE fnd_api.g_exc_unexpected_error;
10580: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
10581: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
10577: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
10578: fnd_msg_pub.ADD;
10579: RAISE fnd_api.g_exc_unexpected_error;
10580: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
10581: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
10582: fnd_msg_pub.ADD;
10583: RAISE fnd_api.g_exc_error;
10584: END IF;
10585: ELSE -- lpn exists
11268: IF (l_debug = 1) THEN
11269: mydebug('pick_drop: Period is invalid');
11270: END IF;
11271:
11272: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
11273: fnd_msg_pub.ADD;
11274: RAISE fnd_api.g_exc_unexpected_error;
11275: END IF;
11276:
11319: mydebug('pick_drop: after logging exception for temp_id: ' || rec_mmtt.transaction_temp_id);
11320: END IF;
11321:
11322: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
11323: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
11324: fnd_msg_pub.ADD;
11325: RAISE fnd_api.g_exc_unexpected_error;
11326: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
11327: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
11323: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
11324: fnd_msg_pub.ADD;
11325: RAISE fnd_api.g_exc_unexpected_error;
11326: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
11327: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
11328: fnd_msg_pub.ADD;
11329: RAISE fnd_api.g_exc_error;
11330: END IF;
11331:
11391: IF (l_debug = 1) THEN
11392: mydebug('pick_drop : Error callinf WF wrapper');
11393: END IF;
11394:
11395: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
11396: fnd_msg_pub.ADD;
11397: RAISE fnd_api.g_exc_unexpected_error;
11398: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
11399: IF (l_debug = 1) THEN
11399: IF (l_debug = 1) THEN
11400: mydebug('pick_drop : Error calling WF wrapper');
11401: END IF;
11402:
11403: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
11404: fnd_msg_pub.ADD;
11405: RAISE fnd_api.g_exc_error;
11406: END IF;
11407: END IF;
11537: mydebug('pick_drop: Txn proc ret' || l_txn_ret);
11538: END IF;
11539:
11540: IF l_txn_ret <> 0 THEN
11541: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
11542: fnd_msg_pub.ADD;
11543: RAISE fnd_api.g_exc_unexpected_error;
11544: END IF;
11545: ELSE
11560: mydebug('pick_drop: After Calling WIP txn proc STATUS' || l_return_status);
11561: END IF;
11562:
11563: IF l_return_status <> fnd_api.g_ret_sts_success THEN
11564: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
11565: fnd_msg_pub.ADD;
11566: RAISE fnd_api.g_exc_unexpected_error;
11567: END IF;
11568: END IF; -- end if release J
11593: mydebug('pick_drop: this LPN ' || l_content_lpn_id ||
11594: ' contains delivery details lines that have been ship confirmed.');
11595: END IF;
11596:
11597: fnd_message.set_name('WMS', 'WMS_STG_MV_LPN_SHIPPED');
11598: fnd_msg_pub.ADD;
11599: RAISE fnd_api.g_exc_unexpected_error;
11600: END IF;
11601: END IF;
11694: mydebug('pick_drop: Txn proc ret' || l_txn_ret);
11695: END IF;
11696:
11697: IF l_txn_ret <> 0 THEN
11698: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
11699: fnd_msg_pub.ADD;
11700: RAISE fnd_api.g_exc_unexpected_error;
11701: END IF;
11702: END IF; -- for l_tran_type_id <> 35
12399: IF (l_debug = 1) THEN
12400: mydebug('pick_drop: Error in pick_drop API: ' || SQLERRM);
12401: END IF;
12402:
12403: fnd_message.set_name('WMS', 'WMS_TD_PICK_DROP_FAIL');
12404: fnd_msg_pub.ADD;
12405: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12406: WHEN OTHERS THEN
12407: x_return_status := fnd_api.g_ret_sts_error;
12409: IF (l_debug = 1) THEN
12410: mydebug('pick_drop: Unexpected Error in pick_drop API: ' || SQLERRM);
12411: END IF;
12412:
12413: fnd_message.set_name('WMS', 'WMS_TD_PICK_DROP_FAIL');
12414: fnd_msg_pub.ADD;
12415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
12416: END pick_drop;
12417:
12723: END IF;
12724:
12725: COMMIT;
12726: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
12727: fnd_message.set_name('WMS', 'WMS_TD_TDENG_ERROR');
12728: fnd_msg_pub.ADD;
12729: RAISE fnd_api.g_exc_unexpected_error;
12730: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
12731: IF (l_debug = 1) THEN
12888: mydebug('manual_pick: No mmtt rows found for pick slip' || l_pick_slip_id);
12889: END IF;
12890:
12891: l_mmtt_rowcnt := 0;
12892: fnd_message.set_name('WMS', 'WMS_INVALID_PICKID');
12893: fnd_msg_pub.ADD;
12894: RAISE fnd_api.g_exc_error;
12895: END;
12896:
12918: mydebug('manual_pick: WDT rows' || l_wdt_rowcnt);
12919: mydebug('manual_pick: Task has been assigned to somebody else');
12920: END IF;
12921:
12922: fnd_message.set_name('WMS', 'WMS_TASK_UNAVAIL');
12923: fnd_msg_pub.ADD;
12924: RAISE fnd_api.g_exc_error;
12925: ELSE
12926: IF (l_debug = 1) THEN
13289: )
13290: ) THEN
13291: IF (l_debug = 1) THEN
13292: mydebug('check_pack_lpn: LPN already exists but with different context or Org');
13293: fnd_message.set_name('WMS', 'WMS_INVLD_PICKTO_LPN_CNTXT_ORG');
13294: fnd_msg_pub.ADD;
13295: END IF;
13296:
13297: x_return_status := fnd_api.g_ret_sts_error;
13338: END IF;
13339:
13340: IF l_return_status = fnd_api.g_ret_sts_unexp_error
13341: OR l_return_status = fnd_api.g_ret_sts_error THEN
13342: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
13343: fnd_msg_pub.ADD;
13344: RAISE fnd_api.g_exc_unexpected_error;
13345: END IF;
13346:
13628: , p_user_id => p_user_id
13629: );
13630:
13631: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
13632: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
13633: fnd_msg_pub.ADD;
13634: RAISE fnd_api.g_exc_unexpected_error;
13635: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13636: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
13632: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
13633: fnd_msg_pub.ADD;
13634: RAISE fnd_api.g_exc_unexpected_error;
13635: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
13636: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
13637: fnd_msg_pub.ADD;
13638: RAISE fnd_api.g_exc_error;
13639: END IF;
13640:
14226: AND msi.secondary_inventory_name = p_confirmed_drop_sub;
14227:
14228: IF l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN
14229: IF (l_mmtt_mo_type = 5) THEN
14230: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
14231: fnd_msg_pub.ADD;
14232: RAISE fnd_api.g_exc_error;
14233: END IF;
14234:
14258: IF (l_debug = 1) THEN
14259: mydebug('validate_pick_drop_sub: Drop LPN is going to a different sub');
14260: END IF;
14261:
14262: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
14263: fnd_msg_pub.ADD;
14264: RAISE fnd_api.g_exc_error;
14265: END IF;
14266: END IF;
14316: IF (l_debug = 1) THEN
14317: mydebug('timeout for the creation of user lock or deadlock');
14318: END IF;
14319:
14320: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_CHANGED');
14321: fnd_msg_pub.ADD;
14322: RAISE fnd_api.g_exc_error;
14323: END IF;
14324: EXCEPTION
15079: mydebug('call_workflow : After Calling WF Wrapper');
15080: -- Bug 2924823 H to I
15081: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
15082: mydebug('call_workflow : Error callinf WF wrapper');
15083: FND_MESSAGE.SET_NAME('WMS','WMS_WORK_FLOW_FAIL');
15084: FND_MSG_PUB.ADD;
15085: RAISE FND_API.g_exc_unexpected_error;
15086:
15087: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
15085: RAISE FND_API.g_exc_unexpected_error;
15086:
15087: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
15088: mydebug('call_workflow : Error calling WF wrapper');
15089: FND_MESSAGE.SET_NAME('WMS','WMS_WORK_FLOW_FAIL');
15090: FND_MSG_PUB.ADD;
15091: RAISE FND_API.G_EXC_ERROR;
15092: END IF;
15093: END IF;
15576: , p_api_version_number
15577: , l_api_name
15578: , G_PKG_NAME
15579: ) THEN
15580: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
15581: FND_MSG_PUB.ADD;
15582: RAISE FND_API.G_EXC_ERROR;
15583: END IF;
15584: