[Home] [Help]
413: WHERE header_id = p_move_order_header_id;
414: EXCEPTION
415: WHEN no_data_found THEN
416: ROLLBACK TO Assign_Pick_slip;
417: FND_MESSAGE.SET_NAME('INV','INV_NO_HEADER_FOUND');
418: FND_MESSAGE.SET_TOKEN('MO_LINE_ID','');
419: FND_MSG_PUB.Add;
420: RAISE fnd_api.g_exc_unexpected_error;
421: END;
414: EXCEPTION
415: WHEN no_data_found THEN
416: ROLLBACK TO Assign_Pick_slip;
417: FND_MESSAGE.SET_NAME('INV','INV_NO_HEADER_FOUND');
418: FND_MESSAGE.SET_TOKEN('MO_LINE_ID','');
419: FND_MSG_PUB.Add;
420: RAISE fnd_api.g_exc_unexpected_error;
421: END;
422:
435: WHERE organization_id = l_organization_id;
436: EXCEPTION
437: WHEN no_data_found THEN
438: ROLLBACK TO Assign_pick_slip;
439: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
440: FND_MSG_PUB.Add;
441: RAISE fnd_api.g_exc_unexpected_error;
442: END;
443: END IF; -- get header rule
506: -- proper document set
507:
508: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
509: ROLLBACK TO assign_pick_slip;
510: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
511: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
512: fnd_msg_pub.ADD;
513: RAISE fnd_api.g_exc_unexpected_error;
514: END IF;
507:
508: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
509: ROLLBACK TO assign_pick_slip;
510: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
511: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
512: fnd_msg_pub.ADD;
513: RAISE fnd_api.g_exc_unexpected_error;
514: END IF;
515: END IF;
548:
549: IF l_api_return_status <> fnd_api.g_ret_sts_success
550: OR l_pick_slip_number = -1 THEN
551: ROLLBACK TO assign_pick_slip;
552: fnd_message.set_name('INV', 'INV_NO_PICK_SLIP_NUMBER');
553: fnd_msg_pub.ADD;
554: RAISE fnd_api.g_exc_unexpected_error;
555: END IF;
556:
619: );
620:
621: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
622: ROLLBACK TO process_line_pvt;
623: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
624: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
625: fnd_msg_pub.ADD;
626: RAISE fnd_api.g_exc_unexpected_error;
627: END IF;
620:
621: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
622: ROLLBACK TO process_line_pvt;
623: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
624: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
625: fnd_msg_pub.ADD;
626: RAISE fnd_api.g_exc_unexpected_error;
627: END IF;
628: END IF;
1051: print_debug('No Lines to pick', 'INV_Pick_Release_Pub.Pick_Release');
1052: End If;
1053:
1054: ROLLBACK TO Pick_Release_PUB;
1055: FND_MESSAGE.SET_NAME('INV','INV_NO_LINES_TO_PICK');
1056: FND_MSG_PUB.Add;
1057: RAISE fnd_api.g_exc_unexpected_error;
1058: END IF;
1059:
1092: print_debug('Error: Trying to pick for different org','INV_Pick_Release_Pub.Pick_Release');
1093: End If;
1094:
1095: ROLLBACK TO Pick_Release_PUB;
1096: FND_MESSAGE.SET_NAME('INV','INV_PICK_DIFFERENT_ORG');
1097: FND_MSG_PUB.Add;
1098: RAISE fnd_api.g_exc_unexpected_error;
1099: END IF;
1100:
1104: print_debug('Error: Invalid Move Order Line Status','INV_Pick_Release_Pub.Pick_Release');
1105: End If;
1106:
1107: ROLLBACK TO Pick_Release_PUB;
1108: FND_MESSAGE.SET_NAME('INV','INV_PICK_LINE_STATUS');
1109: FND_MSG_PUB.Add;
1110: RAISE fnd_api.g_exc_unexpected_error;
1111: END IF;
1112:
1129: print_debug('Error: Trying to release non pick wave move order','INV_Pick_Release_Pub.Pick_Release');
1130: End If;
1131:
1132: ROLLBACK TO Pick_Release_PUB;
1133: FND_MESSAGE.SET_NAME('INV','INV_NON_PICK_WAVE_MO');
1134: FND_MESSAGE.SET_TOKEN('MO_NUMBER',l_mo_number);
1135: FND_MSG_PUB.Add;
1136: RAISE fnd_api.g_exc_unexpected_error;
1137: END IF;
1130: End If;
1131:
1132: ROLLBACK TO Pick_Release_PUB;
1133: FND_MESSAGE.SET_NAME('INV','INV_NON_PICK_WAVE_MO');
1134: FND_MESSAGE.SET_TOKEN('MO_NUMBER',l_mo_number);
1135: FND_MSG_PUB.Add;
1136: RAISE fnd_api.g_exc_unexpected_error;
1137: END IF;
1138: l_mol_id_tbl(l_mol_id_index) := l_mo_line.line_id;
1322: print_debug('No data found-Delivery Info',
1323: 'Inv_Pick_Release_PUB.Pick_release');
1324: End If;
1325: --ROLLBACK TO Pick_Release_PUB;
1326: --FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
1327: -- FND_MSG_PUB.Add;
1328: -- RAISE fnd_api.g_exc_unexpected_error;
1329: END;
1330:
1430: If is_debug then
1431: print_debug('Error: Invalid auto_pick_confirm flag','INV_Pick_Release_Pub.Pick_Release');
1432: End If;
1433: ROLLBACK TO Pick_Release_PUB;
1434: FND_MESSAGE.SET_NAME('INV','INV_AUTO_PICK_CONFIRM_PARAM');
1435: FND_MSG_PUB.Add;
1436: RAISE fnd_api.g_exc_unexpected_error;
1437: ELSE
1438: l_auto_pick_confirm := p_auto_pick_confirm;
1468: If is_debug then
1469: print_debug('Error: print_pick_slip_mode not defined','INV_Pick_Release_Pub.Pick_Release');
1470: End If;
1471: ROLLBACK TO Pick_Release_PUB;
1472: FND_MESSAGE.SET_NAME('INV','INV_WSH_ORG_NOT_FOUND');
1473: FND_MSG_PUB.Add;
1474: RAISE fnd_api.g_exc_unexpected_error;
1475: END;
1476:
1485: If is_debug then
1486: print_debug('Error: invalid partial pick parameter','INV_Pick_Release_Pub.Pick_Release');
1487: End If;
1488: ROLLBACK TO Pick_Release_PUB;
1489: FND_MESSAGE.SET_NAME('INV','INV_INVALID_PARTIAL_PICK_PARAM');
1490: FND_MSG_PUB.Add;
1491: RAISE fnd_api.g_exc_unexpected_error;
1492: END IF;
1493:
1636: print_debug('Error finding org grouping rules',
1637: 'INV_Pick_Release_Pub.Pick_Release');
1638: End If;
1639: ROLLBACK TO Pick_Release_PUB;
1640: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
1641: FND_MSG_PUB.Add;
1642: RAISE fnd_api.g_exc_unexpected_error;
1643: END;
1644:
1812: -- allow_partial_pick is false, since we can't pick full quantity
1813: IF p_allow_partial_pick = fnd_api.g_false THEN
1814: x_pick_release_status.delete;
1815: ROLLBACK TO Pick_Release_PUB;
1816: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_PICK_FULL');
1817: FND_MSG_PUB.Add;
1818: RAISE fnd_api.g_exc_unexpected_error;
1819: END IF;
1820: END IF;
2203: print_debug('No Order Line Quantity found',
2204: 'Inv_Pick_Release_Pub.Pick_Release');
2205: End If;
2206: ROLLBACK TO Pick_Release_PUB;
2207: FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
2208: FND_MSG_PUB.Add;
2209: RAISE fnd_api.g_exc_unexpected_error;
2210: END;
2211:
2324: print_debug('No Order Line Quantity found',
2325: 'Inv_Pick_Release_Pub.Pick_Release');
2326: End If;
2327: ROLLBACK TO Pick_Release_PUB;
2328: FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
2329: FND_MSG_PUB.Add;
2330: RAISE fnd_api.g_exc_unexpected_error;
2331: END;
2332:
3309: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
3310: IF (l_debug = 1) THEN
3311: print_debug('failed to print labels', 'Inv_Pick_Release_Pub.Pick_Release');
3312: END IF;
3313: fnd_message.set_name('WMS','WMS_PRINT_LABEL_FAIL');
3314: fnd_msg_pub.ADD;
3315: END IF;
3316:
3317:
3325: WHEN OTHERS THEN
3326: IF (l_debug = 1) THEN
3327: print_debug('Exception occured while calling print_label', 'Inv_Pick_Release_Pub.Pick_Release');
3328: END IF;
3329: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
3330: fnd_msg_pub.ADD;
3331:
3332: IF c_wpr_casepick_labels%ISOPEN THEN
3333: CLOSE c_wpr_casepick_labels;
3653: -- Validate parameters
3654:
3655: -- First make sure that missing quantity is not <= 0
3656: IF p_missing_quantity <= 0 THEN
3657: FND_MESSAGE.SET_NAME('INV','INV_NO_QTY_TO_TRANSFER');
3658: FND_MSG_PUB.Add;
3659: RAISE fnd_api.g_exc_unexpected_error;
3660: END IF;
3661:
3677: p_demand_source_header_id = fnd_api.g_miss_num OR
3678: p_demand_source_header_id IS NULL OR
3679: p_demand_source_line_id = fnd_api.g_miss_num OR
3680: p_demand_source_line_id IS NULL THEN
3681: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_ID_RSV');
3682: FND_MSG_PUB.Add;
3683: RAISE fnd_api.g_exc_unexpected_error;
3684: END IF;
3685:
3687: -- (the OE header id) to the MTL_SALES_ORDERS id to be used.
3688: /*l_mso_header_id :=
3689: inv_salesorder.get_salesorder_for_oeheader(p_demand_source_header_id);
3690: IF l_mso_header_id IS NULL THEN
3691: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
3692: FND_MSG_PUB.Add;
3693: RAISE fnd_api.g_exc_unexpected_error;
3694: END IF;*/
3695:
3741: , x_error_code => l_api_error_code
3742: );
3743: -- Return an error if the query reservations call failed
3744: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3745: FND_MESSAGE.SET_NAME('INV','INV_QRY_RSV_FAILED');
3746: FND_MSG_PUB.Add;
3747: RAISE fnd_api.g_exc_unexpected_error;
3748: END IF;
3749:
3749:
3750: -- Only 1 reservation record should have been returned, since the parameters
3751: -- passed are supposed to uniquely identify a reservation record.
3752: IF l_reservation_count = 0 THEN
3753: FND_MESSAGE.SET_NAME('INV','INV_NO_RSVS_FOUND');
3754: FND_MSG_PUB.Add;
3755: RAISE fnd_api.g_exc_unexpected_error;
3756: END IF;
3757:
3755: RAISE fnd_api.g_exc_unexpected_error;
3756: END IF;
3757:
3758: IF l_reservation_count > 1 THEN
3759: FND_MESSAGE.SET_NAME('INV','INV_NON_UNIQUE_RSV');
3760: FND_MSG_PUB.Add;
3761: RAISE fnd_api.g_exc_unexpected_error;
3762: END IF;
3763:
3763:
3764: -- Determine whether the quantity to transfer is greater
3765: -- than the currently reserved quantity
3766: IF p_missing_quantity > l_reservations_tbl(1).primary_reservation_quantity THEN
3767: FND_MESSAGE.SET_NAME('INV','INV_INSUFF_QTY_RSV');
3768: FND_MSG_PUB.Add;
3769: RAISE fnd_api.g_exc_unexpected_error;
3770: END IF;
3771:
3809: , x_to_reservation_id => l_new_rsv_id
3810: );
3811: -- Return an error if the transfer reservations call failed
3812: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3813: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');
3814: FND_MSG_PUB.Add;
3815: RAISE fnd_api.g_exc_unexpected_error;
3816: END IF;
3817:
3909: print_debug('Error: print_pick_slip_mode not defined',
3910: 'INV_Pick_Release_Pub.Pick_Release');
3911: End If;
3912: --ROLLBACK TO Pick_Release_PUB;
3913: FND_MESSAGE.SET_NAME('INV','INV_WSH_ORG_NOT_FOUND');
3914: FND_MSG_PUB.Add;
3915: RAISE fnd_api.g_exc_unexpected_error;
3916: END;
3917:
4100: -- Validate parameters
4101:
4102: -- First make sure that missing quantity is not <= 0
4103: IF p_missing_quantity <= 0 THEN
4104: FND_MESSAGE.SET_NAME('INV','INV_NO_QTY_TO_TRANSFER');
4105: FND_MSG_PUB.Add;
4106: RAISE fnd_api.g_exc_unexpected_error;
4107: END IF;
4108:
4124: p_demand_source_header_id = fnd_api.g_miss_num OR
4125: p_demand_source_header_id IS NULL OR
4126: p_demand_source_line_id = fnd_api.g_miss_num OR
4127: p_demand_source_line_id IS NULL THEN
4128: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_ID_RSV');
4129: FND_MSG_PUB.Add;
4130: RAISE fnd_api.g_exc_unexpected_error;
4131: END IF;
4132:
4134: -- (the OE header id) to the MTL_SALES_ORDERS id to be used.
4135: /*l_mso_header_id :=
4136: inv_salesorder.get_salesorder_for_oeheader(p_demand_source_header_id);
4137: IF l_mso_header_id IS NULL THEN
4138: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
4139: FND_MSG_PUB.Add;
4140: RAISE fnd_api.g_exc_unexpected_error;
4141: END IF;*/
4142:
4193: , x_error_code => l_api_error_code
4194: );
4195: -- Return an error if the query reservations call failed
4196: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
4197: FND_MESSAGE.SET_NAME('INV','INV_QRY_RSV_FAILED');
4198: FND_MSG_PUB.Add;
4199: RAISE fnd_api.g_exc_unexpected_error;
4200: END IF;
4201:
4201:
4202: -- Only 1 reservation record should have been returned, since the parameters
4203: -- passed are supposed to uniquely identify a reservation record.
4204: IF l_reservation_count = 0 THEN
4205: FND_MESSAGE.SET_NAME('INV','INV_NO_RSVS_FOUND');
4206: FND_MSG_PUB.Add;
4207: RAISE fnd_api.g_exc_unexpected_error;
4208: END IF;
4209:
4207: RAISE fnd_api.g_exc_unexpected_error;
4208: END IF;
4209:
4210: IF l_reservation_count > 1 THEN
4211: FND_MESSAGE.SET_NAME('INV','INV_NON_UNIQUE_RSV');
4212: FND_MSG_PUB.Add;
4213: RAISE fnd_api.g_exc_unexpected_error;
4214: END IF;
4215:
4215:
4216: -- Determine whether the quantity to transfer is greater
4217: -- than the currently reserved quantity
4218: IF p_missing_quantity > l_reservations_tbl(1).primary_reservation_quantity THEN
4219: FND_MESSAGE.SET_NAME('INV','INV_INSUFF_QTY_RSV');
4220: FND_MSG_PUB.Add;
4221: RAISE fnd_api.g_exc_unexpected_error;
4222: END IF;
4223:
4257: , x_to_reservation_id => l_new_rsv_id
4258: );
4259: -- Return an error if the transfer reservations call failed
4260: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
4261: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');
4262: FND_MSG_PUB.Add;
4263: RAISE fnd_api.g_exc_unexpected_error;
4264: END IF;
4265: x_new_rsv_id := l_new_rsv_id ; --Bug#8301348