[Home] [Help]
408: WHERE header_id = p_move_order_header_id;
409: EXCEPTION
410: WHEN no_data_found THEN
411: ROLLBACK TO Assign_Pick_slip;
412: FND_MESSAGE.SET_NAME('INV','INV_NO_HEADER_FOUND');
413: FND_MESSAGE.SET_TOKEN('MO_LINE_ID','');
414: FND_MSG_PUB.Add;
415: RAISE fnd_api.g_exc_unexpected_error;
416: END;
409: EXCEPTION
410: WHEN no_data_found THEN
411: ROLLBACK TO Assign_Pick_slip;
412: FND_MESSAGE.SET_NAME('INV','INV_NO_HEADER_FOUND');
413: FND_MESSAGE.SET_TOKEN('MO_LINE_ID','');
414: FND_MSG_PUB.Add;
415: RAISE fnd_api.g_exc_unexpected_error;
416: END;
417:
425: WHERE organization_id = l_organization_id;
426: EXCEPTION
427: WHEN no_data_found THEN
428: ROLLBACK TO Assign_pick_slip;
429: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
430: FND_MSG_PUB.Add;
431: RAISE fnd_api.g_exc_unexpected_error;
432: END;
433: END IF; -- get header rule
496: -- proper document set
497:
498: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
499: ROLLBACK TO assign_pick_slip;
500: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
501: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
502: fnd_msg_pub.ADD;
503: RAISE fnd_api.g_exc_unexpected_error;
504: END IF;
497:
498: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
499: ROLLBACK TO assign_pick_slip;
500: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
501: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
502: fnd_msg_pub.ADD;
503: RAISE fnd_api.g_exc_unexpected_error;
504: END IF;
505: END IF;
538:
539: IF l_api_return_status <> fnd_api.g_ret_sts_success
540: OR l_pick_slip_number = -1 THEN
541: ROLLBACK TO assign_pick_slip;
542: fnd_message.set_name('INV', 'INV_NO_PICK_SLIP_NUMBER');
543: fnd_msg_pub.ADD;
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546:
609: );
610:
611: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
612: ROLLBACK TO process_line_pvt;
613: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
614: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
615: fnd_msg_pub.ADD;
616: RAISE fnd_api.g_exc_unexpected_error;
617: END IF;
610:
611: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
612: ROLLBACK TO process_line_pvt;
613: fnd_message.set_name('INV', 'INV_PRINT_PICK_SLIP_FAILED');
614: fnd_message.set_token('PICK_SLIP_NUM', TO_CHAR(l_pick_slip_number));
615: fnd_msg_pub.ADD;
616: RAISE fnd_api.g_exc_unexpected_error;
617: END IF;
618: END IF;
1007: print_debug('No Lines to pick', 'INV_Pick_Release_Pub.Pick_Release');
1008: End If;
1009:
1010: ROLLBACK TO Pick_Release_PUB;
1011: FND_MESSAGE.SET_NAME('INV','INV_NO_LINES_TO_PICK');
1012: FND_MSG_PUB.Add;
1013: RAISE fnd_api.g_exc_unexpected_error;
1014: END IF;
1015:
1049: 'INV_Pick_Release_Pub.Pick_Release');
1050: End If;
1051:
1052: ROLLBACK TO Pick_Release_PUB;
1053: FND_MESSAGE.SET_NAME('INV','INV_PICK_DIFFERENT_ORG');
1054: FND_MSG_PUB.Add;
1055: RAISE fnd_api.g_exc_unexpected_error;
1056: END IF;
1057:
1062: 'INV_Pick_Release_Pub.Pick_Release');
1063: End If;
1064:
1065: ROLLBACK TO Pick_Release_PUB;
1066: FND_MESSAGE.SET_NAME('INV','INV_PICK_LINE_STATUS');
1067: FND_MSG_PUB.Add;
1068: RAISE fnd_api.g_exc_unexpected_error;
1069: END IF;
1070:
1089: 'INV_Pick_Release_Pub.Pick_Release');
1090: End If;
1091:
1092: ROLLBACK TO Pick_Release_PUB;
1093: FND_MESSAGE.SET_NAME('INV','INV_NON_PICK_WAVE_MO');
1094: FND_MESSAGE.SET_TOKEN('MO_NUMBER',l_mo_number);
1095: FND_MSG_PUB.Add;
1096: RAISE fnd_api.g_exc_unexpected_error;
1097: END IF;
1090: End If;
1091:
1092: ROLLBACK TO Pick_Release_PUB;
1093: FND_MESSAGE.SET_NAME('INV','INV_NON_PICK_WAVE_MO');
1094: FND_MESSAGE.SET_TOKEN('MO_NUMBER',l_mo_number);
1095: FND_MSG_PUB.Add;
1096: RAISE fnd_api.g_exc_unexpected_error;
1097: END IF;
1098: l_mol_id_tbl(l_mol_id_index) := l_mo_line.line_id;
1287: print_debug('No data found-Delivery Info',
1288: 'Inv_Pick_Release_PUB.Pick_release');
1289: End If;
1290: --ROLLBACK TO Pick_Release_PUB;
1291: --FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
1292: -- FND_MSG_PUB.Add;
1293: -- RAISE fnd_api.g_exc_unexpected_error;
1294: END;
1295:
1402: print_debug('Error: Invalid auto_pick_confirm flag',
1403: 'INV_Pick_Release_Pub.Pick_Release');
1404: End If;
1405: ROLLBACK TO Pick_Release_PUB;
1406: FND_MESSAGE.SET_NAME('INV','INV_AUTO_PICK_CONFIRM_PARAM');
1407: FND_MSG_PUB.Add;
1408: RAISE fnd_api.g_exc_unexpected_error;
1409: ELSE
1410: l_auto_pick_confirm := p_auto_pick_confirm;
1441: print_debug('Error: print_pick_slip_mode not defined',
1442: 'INV_Pick_Release_Pub.Pick_Release');
1443: End If;
1444: ROLLBACK TO Pick_Release_PUB;
1445: FND_MESSAGE.SET_NAME('INV','INV_WSH_ORG_NOT_FOUND');
1446: FND_MSG_PUB.Add;
1447: RAISE fnd_api.g_exc_unexpected_error;
1448: END;
1449:
1459: print_debug('Error: invalid partial pick parameter',
1460: 'INV_Pick_Release_Pub.Pick_Release');
1461: End If;
1462: ROLLBACK TO Pick_Release_PUB;
1463: FND_MESSAGE.SET_NAME('INV','INV_INVALID_PARTIAL_PICK_PARAM');
1464: FND_MSG_PUB.Add;
1465: RAISE fnd_api.g_exc_unexpected_error;
1466: END IF;
1467:
1593: print_debug('Error finding org grouping rules',
1594: 'INV_Pick_Release_Pub.Pick_Release');
1595: End If;
1596: ROLLBACK TO Pick_Release_PUB;
1597: FND_MESSAGE.SET_NAME('INV','INV-NO ORG INFORMATION');
1598: FND_MSG_PUB.Add;
1599: RAISE fnd_api.g_exc_unexpected_error;
1600: END;
1601:
1763: -- allow_partial_pick is false, since we can't pick full quantity
1764: IF p_allow_partial_pick = fnd_api.g_false THEN
1765: x_pick_release_status.delete;
1766: ROLLBACK TO Pick_Release_PUB;
1767: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_PICK_FULL');
1768: FND_MSG_PUB.Add;
1769: RAISE fnd_api.g_exc_unexpected_error;
1770: END IF;
1771: END IF;
2114: print_debug('No Order Line Quantity found',
2115: 'Inv_Pick_Release_Pub.Pick_Release');
2116: End If;
2117: ROLLBACK TO Pick_Release_PUB;
2118: FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
2119: FND_MSG_PUB.Add;
2120: RAISE fnd_api.g_exc_unexpected_error;
2121: END;
2122:
2235: print_debug('No Order Line Quantity found',
2236: 'Inv_Pick_Release_Pub.Pick_Release');
2237: End If;
2238: ROLLBACK TO Pick_Release_PUB;
2239: FND_MESSAGE.SET_NAME('INV','INV_DELIV_INFO_MISSING');
2240: FND_MSG_PUB.Add;
2241: RAISE fnd_api.g_exc_unexpected_error;
2242: END;
2243:
3157: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
3158: IF (l_debug = 1) THEN
3159: print_debug('failed to print labels', 'Inv_Pick_Release_Pub.Pick_Release');
3160: END IF;
3161: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
3162: fnd_msg_pub.ADD;
3163: END IF;
3164: END IF;
3165: EXCEPTION
3166: WHEN OTHERS THEN
3167: IF (l_debug = 1) THEN
3168: print_debug('Exception occured while calling print_label', 'Inv_Pick_Release_Pub.Pick_Release');
3169: END IF;
3170: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
3171: fnd_msg_pub.ADD;
3172: END;
3173: END IF;
3174: --END Bug 6696594
3485: -- Validate parameters
3486:
3487: -- First make sure that missing quantity is not <= 0
3488: IF p_missing_quantity <= 0 THEN
3489: FND_MESSAGE.SET_NAME('INV','INV_NO_QTY_TO_TRANSFER');
3490: FND_MSG_PUB.Add;
3491: RAISE fnd_api.g_exc_unexpected_error;
3492: END IF;
3493:
3509: p_demand_source_header_id = fnd_api.g_miss_num OR
3510: p_demand_source_header_id IS NULL OR
3511: p_demand_source_line_id = fnd_api.g_miss_num OR
3512: p_demand_source_line_id IS NULL THEN
3513: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_ID_RSV');
3514: FND_MSG_PUB.Add;
3515: RAISE fnd_api.g_exc_unexpected_error;
3516: END IF;
3517:
3519: -- (the OE header id) to the MTL_SALES_ORDERS id to be used.
3520: /*l_mso_header_id :=
3521: inv_salesorder.get_salesorder_for_oeheader(p_demand_source_header_id);
3522: IF l_mso_header_id IS NULL THEN
3523: FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_GET_MSO_HEADER');
3524: FND_MSG_PUB.Add;
3525: RAISE fnd_api.g_exc_unexpected_error;
3526: END IF;*/
3527:
3573: , x_error_code => l_api_error_code
3574: );
3575: -- Return an error if the query reservations call failed
3576: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3577: FND_MESSAGE.SET_NAME('INV','INV_QRY_RSV_FAILED');
3578: FND_MSG_PUB.Add;
3579: RAISE fnd_api.g_exc_unexpected_error;
3580: END IF;
3581:
3581:
3582: -- Only 1 reservation record should have been returned, since the parameters
3583: -- passed are supposed to uniquely identify a reservation record.
3584: IF l_reservation_count = 0 THEN
3585: FND_MESSAGE.SET_NAME('INV','INV_NO_RSVS_FOUND');
3586: FND_MSG_PUB.Add;
3587: RAISE fnd_api.g_exc_unexpected_error;
3588: END IF;
3589:
3587: RAISE fnd_api.g_exc_unexpected_error;
3588: END IF;
3589:
3590: IF l_reservation_count > 1 THEN
3591: FND_MESSAGE.SET_NAME('INV','INV_NON_UNIQUE_RSV');
3592: FND_MSG_PUB.Add;
3593: RAISE fnd_api.g_exc_unexpected_error;
3594: END IF;
3595:
3595:
3596: -- Determine whether the quantity to transfer is greater
3597: -- than the currently reserved quantity
3598: IF p_missing_quantity > l_reservations_tbl(1).primary_reservation_quantity THEN
3599: FND_MESSAGE.SET_NAME('INV','INV_INSUFF_QTY_RSV');
3600: FND_MSG_PUB.Add;
3601: RAISE fnd_api.g_exc_unexpected_error;
3602: END IF;
3603:
3641: , x_to_reservation_id => l_new_rsv_id
3642: );
3643: -- Return an error if the transfer reservations call failed
3644: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3645: FND_MESSAGE.SET_NAME('INV','INV_TRANSFER_RSV_FAILED');
3646: FND_MSG_PUB.Add;
3647: RAISE fnd_api.g_exc_unexpected_error;
3648: END IF;
3649:
3741: print_debug('Error: print_pick_slip_mode not defined',
3742: 'INV_Pick_Release_Pub.Pick_Release');
3743: End If;
3744: --ROLLBACK TO Pick_Release_PUB;
3745: FND_MESSAGE.SET_NAME('INV','INV_WSH_ORG_NOT_FOUND');
3746: FND_MSG_PUB.Add;
3747: RAISE fnd_api.g_exc_unexpected_error;
3748: END;
3749: