eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_REPLENISH_DETAIL_PUB dependencies on FND_API

Line 124: l_init_msg_list VARCHAR2(255) := fnd_api.g_true;

120: , p_auto_pick_confirm IN BOOLEAN
121: , p_commit IN BOOLEAN DEFAULT FALSE
122: ) IS
123: l_api_version_number CONSTANT NUMBER := 1.0;
124: l_init_msg_list VARCHAR2(255) := fnd_api.g_true;
125: l_api_name CONSTANT VARCHAR2(30) := 'Line_Details_PUB';
126: l_num_of_rows NUMBER := 0;
127: l_detailed_qty NUMBER := 0;
128: -- HW INVCONV

Line 235: RAISE fnd_api.g_exc_unexpected_error;

231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN
233: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
234: fnd_msg_pub.ADD;
235: RAISE fnd_api.g_exc_unexpected_error;
236: END;
237:
238: BEGIN
239: SELECT auto_pick_confirm_flag INTO l_auto_pick_flag

Line 255: RAISE fnd_api.g_exc_unexpected_error;

251: EXCEPTION
252: WHEN NO_DATA_FOUND THEN
253: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
254: fnd_msg_pub.ADD;
255: RAISE fnd_api.g_exc_unexpected_error;
256: END;
257: END IF;
258:
259: SAVEPOINT inv_before_pick_release;

Line 267: l_commit := fnd_api.g_true;

263: print_debug('Picking Batch - Auto Pick Confirm = ' || l_auto_pick_flag);
264: END IF;
265:
266: IF (l_auto_pick_flag = 'Y') THEN
267: l_commit := fnd_api.g_true;
268: ELSE
269: l_commit := fnd_api.g_false;
270: END IF;
271:

Line 269: l_commit := fnd_api.g_false;

265:
266: IF (l_auto_pick_flag = 'Y') THEN
267: l_commit := fnd_api.g_true;
268: ELSE
269: l_commit := fnd_api.g_false;
270: END IF;
271:
272: inv_pick_release_pub.pick_release(
273: p_api_version => 1.0

Line 274: , p_init_msg_list => fnd_api.g_false

270: END IF;
271:
272: inv_pick_release_pub.pick_release(
273: p_api_version => 1.0
274: , p_init_msg_list => fnd_api.g_false
275: , p_commit => l_commit
276: , x_return_status => l_return_status
277: , x_msg_data => x_msg_data
278: , x_msg_count => x_msg_count

Line 291: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

287: IF (l_debug = 1) THEN
288: print_debug('l_return_status from inv_pick_release_pub.pick_release is ' || l_return_status);
289: END IF;
290:
291: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
292: IF (l_debug = 1) THEN
293: print_debug('return error');
294: END IF;
295: RAISE fnd_api.g_exc_unexpected_error;

Line 295: RAISE fnd_api.g_exc_unexpected_error;

291: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
292: IF (l_debug = 1) THEN
293: print_debug('return error');
294: END IF;
295: RAISE fnd_api.g_exc_unexpected_error;
296: END IF;
297:
298: IF (l_debug = 1) THEN
299: print_debug(l_pick_release_status.COUNT);

Line 309: IF (l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_unexp_error) THEN

305: print_debug('detail record count is ' || l_detail_rec_count);
306: END IF;
307:
308: FOR l_index IN 1 .. l_pick_release_status.COUNT LOOP
309: IF (l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_unexp_error) THEN
310: l_return_status := fnd_api.g_ret_sts_unexp_error;
311: ELSIF l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_error THEN
312: l_return_status := fnd_api.g_ret_sts_error;
313: ELSE

Line 310: l_return_status := fnd_api.g_ret_sts_unexp_error;

306: END IF;
307:
308: FOR l_index IN 1 .. l_pick_release_status.COUNT LOOP
309: IF (l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_unexp_error) THEN
310: l_return_status := fnd_api.g_ret_sts_unexp_error;
311: ELSIF l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_error THEN
312: l_return_status := fnd_api.g_ret_sts_error;
313: ELSE
314: IF (l_debug = 1) THEN

Line 311: ELSIF l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_error THEN

307:
308: FOR l_index IN 1 .. l_pick_release_status.COUNT LOOP
309: IF (l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_unexp_error) THEN
310: l_return_status := fnd_api.g_ret_sts_unexp_error;
311: ELSIF l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_error THEN
312: l_return_status := fnd_api.g_ret_sts_error;
313: ELSE
314: IF (l_debug = 1) THEN
315: print_debug('return status is ' || l_return_status);

Line 312: l_return_status := fnd_api.g_ret_sts_error;

308: FOR l_index IN 1 .. l_pick_release_status.COUNT LOOP
309: IF (l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_unexp_error) THEN
310: l_return_status := fnd_api.g_ret_sts_unexp_error;
311: ELSIF l_pick_release_status(l_index).return_status = fnd_api.g_ret_sts_error THEN
312: l_return_status := fnd_api.g_ret_sts_error;
313: ELSE
314: IF (l_debug = 1) THEN
315: print_debug('return status is ' || l_return_status);
316: END IF;

Line 317: l_return_status := fnd_api.g_ret_sts_success;

313: ELSE
314: IF (l_debug = 1) THEN
315: print_debug('return status is ' || l_return_status);
316: END IF;
317: l_return_status := fnd_api.g_ret_sts_success;
318: END IF;
319: END LOOP;
320: END IF;
321:

Line 333: RAISE fnd_api.g_exc_error;

329: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
330: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
331: fnd_message.set_token('MO_NUMBER', l_request_number);
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_error;
334: END IF;
335:
336: /*Bug 1588529*/
337: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'N') THEN

Line 356: l_return_status := fnd_api.g_ret_sts_unexp_error;

352: l_mold_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_tbl(1).line_id);
353: l_mold_tbl_temp := l_mold_tbl;
354:
355: IF (l_mold_tbl.COUNT = 0) THEN
356: l_return_status := fnd_api.g_ret_sts_unexp_error;
357: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');
358: fnd_msg_pub.ADD;
359: RAISE fnd_api.g_exc_unexpected_error;
360: ELSE

Line 359: RAISE fnd_api.g_exc_unexpected_error;

355: IF (l_mold_tbl.COUNT = 0) THEN
356: l_return_status := fnd_api.g_ret_sts_unexp_error;
357: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');
358: fnd_msg_pub.ADD;
359: RAISE fnd_api.g_exc_unexpected_error;
360: ELSE
361: IF (l_debug = 1) THEN
362: print_debug('number of mold record is ' || l_mold_tbl.COUNT);
363: print_debug('calling pick confirm');

Line 368: , p_init_msg_list => fnd_api.g_false

364: END IF;
365:
366: inv_pick_wave_pick_confirm_pub.pick_confirm(
367: p_api_version_number => 1.0
368: , p_init_msg_list => fnd_api.g_false
369: , p_commit => fnd_api.g_true
370: , x_return_status => l_return_status
371: , x_msg_count => x_msg_count
372: , x_msg_data => x_msg_data

Line 369: , p_commit => fnd_api.g_true

365:
366: inv_pick_wave_pick_confirm_pub.pick_confirm(
367: p_api_version_number => 1.0
368: , p_init_msg_list => fnd_api.g_false
369: , p_commit => fnd_api.g_true
370: , x_return_status => l_return_status
371: , x_msg_count => x_msg_count
372: , x_msg_data => x_msg_data
373: , p_move_order_type => p_move_order_type

Line 386: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

382: print_debug('after pick confirm with return status = ' || l_return_status);
383: print_debug('l_return_status = ' || l_return_status);
384: END IF;
385:
386: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
387: l_success := 0;
388: IF (l_debug = 1) THEN
389: print_debug('rollback changes');
390: print_debug('l_mold_tbl_temp.count = ' || l_mold_tbl_temp.COUNT);

Line 414: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

410: IF (l_debug = 1) THEN
411: print_debug('after detele details with return status ' || l_return_status);
412: END IF;
413:
414: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
415: RAISE fnd_api.g_exc_unexpected_error;
416: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
417: RAISE fnd_api.g_exc_error;
418: END IF;

Line 415: RAISE fnd_api.g_exc_unexpected_error;

411: print_debug('after detele details with return status ' || l_return_status);
412: END IF;
413:
414: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
415: RAISE fnd_api.g_exc_unexpected_error;
416: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
417: RAISE fnd_api.g_exc_error;
418: END IF;
419:

Line 416: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

412: END IF;
413:
414: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
415: RAISE fnd_api.g_exc_unexpected_error;
416: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
417: RAISE fnd_api.g_exc_error;
418: END IF;
419:
420: -- HW INVCONV - Update Qty2 fields

Line 417: RAISE fnd_api.g_exc_error;

413:
414: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
415: RAISE fnd_api.g_exc_unexpected_error;
416: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
417: RAISE fnd_api.g_exc_error;
418: END IF;
419:
420: -- HW INVCONV - Update Qty2 fields
421: UPDATE mtl_txn_request_lines

Line 424: , secondary_quantity_detailed = decode(secondary_quantity_detailed,FND_API.G_MISS_NUM, NULL, secondary_quantity_detailed - l_mold_tbl_temp(l_index).secondary_transaction_quantity)

420: -- HW INVCONV - Update Qty2 fields
421: UPDATE mtl_txn_request_lines
422: SET quantity_detailed = quantity_detailed - l_mold_tbl_temp(l_index).transaction_quantity
423: , quantity_delivered = quantity_delivered - l_mold_tbl_temp(l_index).transaction_quantity
424: , secondary_quantity_detailed = decode(secondary_quantity_detailed,FND_API.G_MISS_NUM, NULL, secondary_quantity_detailed - l_mold_tbl_temp(l_index).secondary_transaction_quantity)
425: , secondary_quantity_delivered =decode(secondary_quantity_delivered,FND_API.G_MISS_NUM, NULL, secondary_quantity_delivered - l_mold_tbl_temp(l_index).secondary_transaction_quantity)
426: WHERE line_id = l_mold_tbl_temp(l_index).move_order_line_id;
427: END LOOP;
428:

Line 425: , secondary_quantity_delivered =decode(secondary_quantity_delivered,FND_API.G_MISS_NUM, NULL, secondary_quantity_delivered - l_mold_tbl_temp(l_index).secondary_transaction_quantity)

421: UPDATE mtl_txn_request_lines
422: SET quantity_detailed = quantity_detailed - l_mold_tbl_temp(l_index).transaction_quantity
423: , quantity_delivered = quantity_delivered - l_mold_tbl_temp(l_index).transaction_quantity
424: , secondary_quantity_detailed = decode(secondary_quantity_detailed,FND_API.G_MISS_NUM, NULL, secondary_quantity_detailed - l_mold_tbl_temp(l_index).secondary_transaction_quantity)
425: , secondary_quantity_delivered =decode(secondary_quantity_delivered,FND_API.G_MISS_NUM, NULL, secondary_quantity_delivered - l_mold_tbl_temp(l_index).secondary_transaction_quantity)
426: WHERE line_id = l_mold_tbl_temp(l_index).move_order_line_id;
427: END LOOP;
428:
429: UPDATE mtl_txn_request_lines

Line 457: , p_commit => fnd_api.g_false

453: inv_wip_picking_pvt.pick_release(
454: x_return_status => x_return_status
455: , x_msg_count => x_msg_count
456: , x_msg_data => x_msg_data
457: , p_commit => fnd_api.g_false
458: , p_init_msg_lst => fnd_api.g_false
459: , p_mo_line_tbl => l_trolin_tbl
460: , p_allow_partial_pick => fnd_api.g_true
461: , p_grouping_rule_id => l_grouping_rule_id

Line 458: , p_init_msg_lst => fnd_api.g_false

454: x_return_status => x_return_status
455: , x_msg_count => x_msg_count
456: , x_msg_data => x_msg_data
457: , p_commit => fnd_api.g_false
458: , p_init_msg_lst => fnd_api.g_false
459: , p_mo_line_tbl => l_trolin_tbl
460: , p_allow_partial_pick => fnd_api.g_true
461: , p_grouping_rule_id => l_grouping_rule_id
462: , p_plan_tasks => p_plan_tasks

Line 460: , p_allow_partial_pick => fnd_api.g_true

456: , x_msg_data => x_msg_data
457: , p_commit => fnd_api.g_false
458: , p_init_msg_lst => fnd_api.g_false
459: , p_mo_line_tbl => l_trolin_tbl
460: , p_allow_partial_pick => fnd_api.g_true
461: , p_grouping_rule_id => l_grouping_rule_id
462: , p_plan_tasks => p_plan_tasks
463: , p_call_wip_api => FALSE
464: );

Line 466: IF x_return_status = fnd_api.g_ret_sts_error THEN

462: , p_plan_tasks => p_plan_tasks
463: , p_call_wip_api => FALSE
464: );
465:
466: IF x_return_status = fnd_api.g_ret_sts_error THEN
467: RAISE fnd_api.g_exc_error;
468: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;

Line 467: RAISE fnd_api.g_exc_error;

463: , p_call_wip_api => FALSE
464: );
465:
466: IF x_return_status = fnd_api.g_ret_sts_error THEN
467: RAISE fnd_api.g_exc_error;
468: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
471: ELSE

Line 468: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

464: );
465:
466: IF x_return_status = fnd_api.g_ret_sts_error THEN
467: RAISE fnd_api.g_exc_error;
468: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
471: ELSE
472: IF l_debug = 1 THEN

Line 469: RAISE fnd_api.g_exc_unexpected_error;

465:
466: IF x_return_status = fnd_api.g_ret_sts_error THEN
467: RAISE fnd_api.g_exc_error;
468: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
471: ELSE
472: IF l_debug = 1 THEN
473: print_debug('Other types of MO. Calling INV_PPENGINE_PVT.CREATE_SUGGESTIONS to allocate');

Line 479: , p_commit => fnd_api.g_false

475:
476: inv_ppengine_pvt.create_suggestions(
477: p_api_version => l_api_version_number
478: , p_init_msg_list => l_init_msg_list
479: , p_commit => fnd_api.g_false
480: , p_validation_level => fnd_api.g_valid_level_full
481: , x_return_status => l_return_status
482: , x_msg_count => x_msg_count
483: , x_msg_data => x_msg_data

Line 480: , p_validation_level => fnd_api.g_valid_level_full

476: inv_ppengine_pvt.create_suggestions(
477: p_api_version => l_api_version_number
478: , p_init_msg_list => l_init_msg_list
479: , p_commit => fnd_api.g_false
480: , p_validation_level => fnd_api.g_valid_level_full
481: , x_return_status => l_return_status
482: , x_msg_count => x_msg_count
483: , x_msg_data => x_msg_data
484: , p_transaction_temp_id => p_line_id

Line 490: IF l_return_status = fnd_api.g_ret_sts_error THEN

486: , p_suggest_serial => p_serial_flag
487: , p_plan_tasks => p_plan_tasks
488: );
489:
490: IF l_return_status = fnd_api.g_ret_sts_error THEN
491: RAISE fnd_api.g_exc_error;
492: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
493: RAISE fnd_api.g_exc_unexpected_error;
494: END IF;

Line 491: RAISE fnd_api.g_exc_error;

487: , p_plan_tasks => p_plan_tasks
488: );
489:
490: IF l_return_status = fnd_api.g_ret_sts_error THEN
491: RAISE fnd_api.g_exc_error;
492: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
493: RAISE fnd_api.g_exc_unexpected_error;
494: END IF;
495:

Line 492: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

488: );
489:
490: IF l_return_status = fnd_api.g_ret_sts_error THEN
491: RAISE fnd_api.g_exc_error;
492: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
493: RAISE fnd_api.g_exc_unexpected_error;
494: END IF;
495:
496: --Start Bug 6696594

Line 493: RAISE fnd_api.g_exc_unexpected_error;

489:
490: IF l_return_status = fnd_api.g_ret_sts_error THEN
491: RAISE fnd_api.g_exc_error;
492: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
493: RAISE fnd_api.g_exc_unexpected_error;
494: END IF;
495:
496: --Start Bug 6696594
497: IF INV_CONTROL.G_CURRENT_RELEASE_LEVEL >= 120001 THEN

Line 539: l_return_status := fnd_api.g_ret_sts_success;

535: END IF;
536: END LOOP;
537:
538: IF l_counter > 1 THEN
539: l_return_status := fnd_api.g_ret_sts_success;
540:
541: inv_label.print_label (
542: x_return_status => x_return_status
543: , x_msg_count => x_msg_count

Line 551: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN

547: , p_print_mode => 1
548: , p_business_flow_code => 42 --Business Flow Pick Release
549: , p_transaction_id => v_transaction_id);
550:
551: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
552: IF (l_debug = 1) THEN
553: print_debug('failed to print labels');
554: END IF;
555: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');

Line 578: , p_init_msg_list => fnd_api.g_false

574: END IF;
575:
576: wms_cartnzn_pub.cartonize(
577: p_api_version => 1.0
578: , p_init_msg_list => fnd_api.g_false
579: , p_commit => fnd_api.g_false
580: , p_validation_level => fnd_api.g_valid_level_full
581: , x_return_status => l_return_status
582: , x_msg_count => x_msg_count

Line 579: , p_commit => fnd_api.g_false

575:
576: wms_cartnzn_pub.cartonize(
577: p_api_version => 1.0
578: , p_init_msg_list => fnd_api.g_false
579: , p_commit => fnd_api.g_false
580: , p_validation_level => fnd_api.g_valid_level_full
581: , x_return_status => l_return_status
582: , x_msg_count => x_msg_count
583: , x_msg_data => x_msg_data

Line 580: , p_validation_level => fnd_api.g_valid_level_full

576: wms_cartnzn_pub.cartonize(
577: p_api_version => 1.0
578: , p_init_msg_list => fnd_api.g_false
579: , p_commit => fnd_api.g_false
580: , p_validation_level => fnd_api.g_valid_level_full
581: , x_return_status => l_return_status
582: , x_msg_count => x_msg_count
583: , x_msg_data => x_msg_data
584: , p_out_bound => 'Y'

Line 590: IF l_return_status = fnd_api.g_ret_sts_error THEN

586: , p_move_order_header_id => l_trolin_tbl(1).header_id
587: , p_disable_cartonization => 'Y'
588: );
589:
590: IF l_return_status = fnd_api.g_ret_sts_error THEN
591: IF (l_debug = 1) THEN
592: print_debug('Error from WMS_CARTNZN_PUB.CARTONIZE');
593: END IF;
594:

Line 595: RAISE fnd_api.g_exc_error;

591: IF (l_debug = 1) THEN
592: print_debug('Error from WMS_CARTNZN_PUB.CARTONIZE');
593: END IF;
594:
595: RAISE fnd_api.g_exc_error;
596: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
597: IF (l_debug = 1) THEN
598: print_debug('error from WMS_CARTNZN_PUB.CARTONIZE');
599: END IF;

Line 596: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

592: print_debug('Error from WMS_CARTNZN_PUB.CARTONIZE');
593: END IF;
594:
595: RAISE fnd_api.g_exc_error;
596: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
597: IF (l_debug = 1) THEN
598: print_debug('error from WMS_CARTNZN_PUB.CARTONIZE');
599: END IF;
600:

Line 601: RAISE fnd_api.g_exc_unexpected_error;

597: IF (l_debug = 1) THEN
598: print_debug('error from WMS_CARTNZN_PUB.CARTONIZE');
599: END IF;
600:
601: RAISE fnd_api.g_exc_unexpected_error;
602: END IF;
603: END IF;
604: END IF;
605:

Line 733: x_return_status := fnd_api.g_ret_sts_success;

729: x_transfer_to_location := l_transfer_to_location;
730: x_lot_number := l_lot_number;
731: x_expiration_date := l_expiration_date;
732: x_transaction_temp_id := l_transaction_temp_id;
733: x_return_status := fnd_api.g_ret_sts_success;
734:
735: IF ( p_commit ) THEN
736: COMMIT;
737: END IF;

Line 741: x_return_status := fnd_api.g_ret_sts_success;

737: END IF;
738:
739: ELSIF(p_move_order_type = 3 AND l_auto_pick_confirm = 1) THEN
740: IF (l_success = 1) THEN
741: x_return_status := fnd_api.g_ret_sts_success;
742: ELSE
743: RAISE fnd_api.g_exc_error;
744: END IF;
745: END IF;

Line 743: RAISE fnd_api.g_exc_error;

739: ELSIF(p_move_order_type = 3 AND l_auto_pick_confirm = 1) THEN
740: IF (l_success = 1) THEN
741: x_return_status := fnd_api.g_ret_sts_success;
742: ELSE
743: RAISE fnd_api.g_exc_error;
744: END IF;
745: END IF;
746: EXCEPTION
747: WHEN fnd_api.g_exc_error THEN

Line 747: WHEN fnd_api.g_exc_error THEN

743: RAISE fnd_api.g_exc_error;
744: END IF;
745: END IF;
746: EXCEPTION
747: WHEN fnd_api.g_exc_error THEN
748: x_return_status := fnd_api.g_ret_sts_error;
749: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
750: WHEN fnd_api.g_exc_unexpected_error THEN
751: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 748: x_return_status := fnd_api.g_ret_sts_error;

744: END IF;
745: END IF;
746: EXCEPTION
747: WHEN fnd_api.g_exc_error THEN
748: x_return_status := fnd_api.g_ret_sts_error;
749: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
750: WHEN fnd_api.g_exc_unexpected_error THEN
751: x_return_status := fnd_api.g_ret_sts_unexp_error;
752: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 750: WHEN fnd_api.g_exc_unexpected_error THEN

746: EXCEPTION
747: WHEN fnd_api.g_exc_error THEN
748: x_return_status := fnd_api.g_ret_sts_error;
749: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
750: WHEN fnd_api.g_exc_unexpected_error THEN
751: x_return_status := fnd_api.g_ret_sts_unexp_error;
752: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
753: WHEN OTHERS THEN
754: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 751: x_return_status := fnd_api.g_ret_sts_unexp_error;

747: WHEN fnd_api.g_exc_error THEN
748: x_return_status := fnd_api.g_ret_sts_error;
749: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
750: WHEN fnd_api.g_exc_unexpected_error THEN
751: x_return_status := fnd_api.g_ret_sts_unexp_error;
752: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
753: WHEN OTHERS THEN
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755:

Line 754: x_return_status := fnd_api.g_ret_sts_unexp_error;

750: WHEN fnd_api.g_exc_unexpected_error THEN
751: x_return_status := fnd_api.g_ret_sts_unexp_error;
752: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
753: WHEN OTHERS THEN
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755:
756: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
757: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Line_Details_PUB');
758: END IF;

Line 849: , p_transaction_quantity2 IN NUMBER default FND_API.G_MISS_NUM

845: p_transaction_temp_id IN NUMBER
846: , p_move_order_line_id IN NUMBER
847: , p_reservation_id IN NUMBER
848: , p_transaction_quantity IN NUMBER
849: , p_transaction_quantity2 IN NUMBER default FND_API.G_MISS_NUM
850: , p_primary_trx_qty IN NUMBER
851: , x_return_status OUT NOCOPY VARCHAR2
852: , x_msg_count OUT NOCOPY NUMBER
853: , x_msg_data OUT NOCOPY VARCHAR2

Line 890: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

886: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
887: , x_error_code => l_error_code
888: );
889:
890: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
891: RAISE fnd_api.g_exc_error;
892: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
893: RAISE fnd_api.g_exc_unexpected_error;
894: END IF;

Line 891: RAISE fnd_api.g_exc_error;

887: , x_error_code => l_error_code
888: );
889:
890: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
891: RAISE fnd_api.g_exc_error;
892: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
893: RAISE fnd_api.g_exc_unexpected_error;
894: END IF;
895: END IF; --rsv id not null

Line 892: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

888: );
889:
890: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
891: RAISE fnd_api.g_exc_error;
892: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
893: RAISE fnd_api.g_exc_unexpected_error;
894: END IF;
895: END IF; --rsv id not null
896:

Line 893: RAISE fnd_api.g_exc_unexpected_error;

889:
890: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
891: RAISE fnd_api.g_exc_error;
892: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
893: RAISE fnd_api.g_exc_unexpected_error;
894: END IF;
895: END IF; --rsv id not null
896:
897: IF l_mtl_reservation_tbl_count > 0 THEN

Line 952: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

948: , p_original_serial_number => l_original_serial_number
949: , p_to_serial_number => l_to_serial_number
950: );
951:
952: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
953: RAISE fnd_api.g_exc_error;
954: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
955: RAISE fnd_api.g_exc_unexpected_error;
956: END IF;

Line 953: RAISE fnd_api.g_exc_error;

949: , p_to_serial_number => l_to_serial_number
950: );
951:
952: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
953: RAISE fnd_api.g_exc_error;
954: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
955: RAISE fnd_api.g_exc_unexpected_error;
956: END IF;
957: ELSE

Line 954: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

950: );
951:
952: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
953: RAISE fnd_api.g_exc_error;
954: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
955: RAISE fnd_api.g_exc_unexpected_error;
956: END IF;
957: ELSE
958: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);

Line 955: RAISE fnd_api.g_exc_unexpected_error;

951:
952: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
953: RAISE fnd_api.g_exc_error;
954: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
955: RAISE fnd_api.g_exc_unexpected_error;
956: END IF;
957: ELSE
958: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);
959: l_mtl_reservation_tbl(1).detailed_quantity :=

Line 971: IF ( p_transaction_quantity2 <> FND_API.G_MISS_NUM) THEN

967: - ABS(p_primary_trx_qty);
968:
969: -- HW INVCONV - Update Qty2s if they are present
970:
971: IF ( p_transaction_quantity2 <> FND_API.G_MISS_NUM) THEN
972: -- No need to use NVL similar to Qty1
973: l_mtl_reservation_tbl(1).secondary_detailed_quantity :=
974: l_mtl_reservation_tbl(1).secondary_detailed_quantity
975: - ABS(p_transaction_quantity2);

Line 992: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

988: , p_original_serial_number => l_original_serial_number
989: , p_to_serial_number => l_to_serial_number
990: );
991:
992: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
993: RAISE fnd_api.g_exc_error;
994: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
995: RAISE fnd_api.g_exc_unexpected_error;
996: END IF;

Line 993: RAISE fnd_api.g_exc_error;

989: , p_to_serial_number => l_to_serial_number
990: );
991:
992: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
993: RAISE fnd_api.g_exc_error;
994: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
995: RAISE fnd_api.g_exc_unexpected_error;
996: END IF;
997: END IF; -- ato item check

Line 994: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

990: );
991:
992: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
993: RAISE fnd_api.g_exc_error;
994: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
995: RAISE fnd_api.g_exc_unexpected_error;
996: END IF;
997: END IF; -- ato item check
998: END IF; --reservation count >0

Line 995: RAISE fnd_api.g_exc_unexpected_error;

991:
992: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
993: RAISE fnd_api.g_exc_error;
994: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
995: RAISE fnd_api.g_exc_unexpected_error;
996: END IF;
997: END IF; -- ato item check
998: END IF; --reservation count >0
999:

Line 1021: RAISE fnd_api.g_exc_error;

1017: IF (p_delete_temp_records) THEN
1018: CLEAR_RECORD(p_transaction_temp_id, l_success);
1019:
1020: IF (NOT l_success) THEN
1021: RAISE fnd_api.g_exc_error;
1022: END IF;
1023:
1024: inv_mo_line_detail_util.delete_row( x_return_status => l_return_status
1025: , p_line_id => p_move_order_line_id

Line 1034: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

1030: where move_order_line_id = p_move_order_line_id;
1031:
1032: --inv_debug.message('count = ' || l_count);
1033: */
1034: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1035: RAISE fnd_api.g_exc_error;
1036: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: END IF;

Line 1035: RAISE fnd_api.g_exc_error;

1031:
1032: --inv_debug.message('count = ' || l_count);
1033: */
1034: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1035: RAISE fnd_api.g_exc_error;
1036: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: END IF;
1039: END IF; --p_delete_temp_records

Line 1036: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1032: --inv_debug.message('count = ' || l_count);
1033: */
1034: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1035: RAISE fnd_api.g_exc_error;
1036: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: END IF;
1039: END IF; --p_delete_temp_records
1040:

Line 1037: RAISE fnd_api.g_exc_unexpected_error;

1033: */
1034: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1035: RAISE fnd_api.g_exc_error;
1036: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: END IF;
1039: END IF; --p_delete_temp_records
1040:
1041: COMMIT;

Line 1042: x_return_status := fnd_api.g_ret_sts_success;

1038: END IF;
1039: END IF; --p_delete_temp_records
1040:
1041: COMMIT;
1042: x_return_status := fnd_api.g_ret_sts_success;
1043: EXCEPTION
1044: WHEN fnd_api.g_exc_error THEN
1045: x_return_status := fnd_api.g_ret_sts_error;
1046: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1044: WHEN fnd_api.g_exc_error THEN

1040:
1041: COMMIT;
1042: x_return_status := fnd_api.g_ret_sts_success;
1043: EXCEPTION
1044: WHEN fnd_api.g_exc_error THEN
1045: x_return_status := fnd_api.g_ret_sts_error;
1046: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1047: WHEN fnd_api.g_exc_unexpected_error THEN
1048: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1045: x_return_status := fnd_api.g_ret_sts_error;

1041: COMMIT;
1042: x_return_status := fnd_api.g_ret_sts_success;
1043: EXCEPTION
1044: WHEN fnd_api.g_exc_error THEN
1045: x_return_status := fnd_api.g_ret_sts_error;
1046: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1047: WHEN fnd_api.g_exc_unexpected_error THEN
1048: x_return_status := fnd_api.g_ret_sts_unexp_error;
1049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1047: WHEN fnd_api.g_exc_unexpected_error THEN

1043: EXCEPTION
1044: WHEN fnd_api.g_exc_error THEN
1045: x_return_status := fnd_api.g_ret_sts_error;
1046: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1047: WHEN fnd_api.g_exc_unexpected_error THEN
1048: x_return_status := fnd_api.g_ret_sts_unexp_error;
1049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1050: WHEN OTHERS THEN
1051: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1048: x_return_status := fnd_api.g_ret_sts_unexp_error;

1044: WHEN fnd_api.g_exc_error THEN
1045: x_return_status := fnd_api.g_ret_sts_error;
1046: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1047: WHEN fnd_api.g_exc_unexpected_error THEN
1048: x_return_status := fnd_api.g_ret_sts_unexp_error;
1049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1050: WHEN OTHERS THEN
1051: x_return_status := fnd_api.g_ret_sts_unexp_error;
1052:

Line 1051: x_return_status := fnd_api.g_ret_sts_unexp_error;

1047: WHEN fnd_api.g_exc_unexpected_error THEN
1048: x_return_status := fnd_api.g_ret_sts_unexp_error;
1049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1050: WHEN OTHERS THEN
1051: x_return_status := fnd_api.g_ret_sts_unexp_error;
1052:
1053: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1054: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Line_Details_PUB');
1055: END IF;

Line 1288: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

1284: FROM mtl_material_transactions_temp
1285: WHERE move_order_line_id = l_mmtt_rec.move_order_line_id;
1286:
1287: --inv_debug.message(' total record = ' || l_count ||' for move order line id ' || l_mmtt_rec.move_order_line_id);
1288: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1289: RAISE fnd_api.g_exc_error;
1290: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1291: RAISE fnd_api.g_exc_unexpected_error;
1292: END IF;

Line 1289: RAISE fnd_api.g_exc_error;

1285: WHERE move_order_line_id = l_mmtt_rec.move_order_line_id;
1286:
1287: --inv_debug.message(' total record = ' || l_count ||' for move order line id ' || l_mmtt_rec.move_order_line_id);
1288: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1289: RAISE fnd_api.g_exc_error;
1290: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1291: RAISE fnd_api.g_exc_unexpected_error;
1292: END IF;
1293: EXCEPTION

Line 1290: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1286:
1287: --inv_debug.message(' total record = ' || l_count ||' for move order line id ' || l_mmtt_rec.move_order_line_id);
1288: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1289: RAISE fnd_api.g_exc_error;
1290: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1291: RAISE fnd_api.g_exc_unexpected_error;
1292: END IF;
1293: EXCEPTION
1294: WHEN fnd_api.g_exc_error THEN

Line 1291: RAISE fnd_api.g_exc_unexpected_error;

1287: --inv_debug.message(' total record = ' || l_count ||' for move order line id ' || l_mmtt_rec.move_order_line_id);
1288: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1289: RAISE fnd_api.g_exc_error;
1290: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1291: RAISE fnd_api.g_exc_unexpected_error;
1292: END IF;
1293: EXCEPTION
1294: WHEN fnd_api.g_exc_error THEN
1295: x_return_status := fnd_api.g_ret_sts_error;

Line 1294: WHEN fnd_api.g_exc_error THEN

1290: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1291: RAISE fnd_api.g_exc_unexpected_error;
1292: END IF;
1293: EXCEPTION
1294: WHEN fnd_api.g_exc_error THEN
1295: x_return_status := fnd_api.g_ret_sts_error;
1296: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1295: x_return_status := fnd_api.g_ret_sts_error;

1291: RAISE fnd_api.g_exc_unexpected_error;
1292: END IF;
1293: EXCEPTION
1294: WHEN fnd_api.g_exc_error THEN
1295: x_return_status := fnd_api.g_ret_sts_error;
1296: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1299: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1299: WHEN fnd_api.g_exc_unexpected_error THEN

1295: x_return_status := fnd_api.g_ret_sts_error;
1296: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1299: WHEN fnd_api.g_exc_unexpected_error THEN
1300: x_return_status := fnd_api.g_ret_sts_unexp_error;
1301: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1302: fnd_msg_pub.ADD;
1303: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1300: x_return_status := fnd_api.g_ret_sts_unexp_error;

1296: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1299: WHEN fnd_api.g_exc_unexpected_error THEN
1300: x_return_status := fnd_api.g_ret_sts_unexp_error;
1301: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1302: fnd_msg_pub.ADD;
1303: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1304: WHEN OTHERS THEN

Line 1305: x_return_status := fnd_api.g_ret_sts_unexp_error;

1301: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1302: fnd_msg_pub.ADD;
1303: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1304: WHEN OTHERS THEN
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306:
1307: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1308: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Split_Line_Details');
1309: END IF;

Line 1338: , p_init_msg_list => fnd_api.g_false

1334: l_mold_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_line_id);
1335: --inv_debug.message('number of mold record is ' || l_mold_tbl.count);
1336: inv_pick_wave_pick_confirm_pub.pick_confirm(
1337: p_api_version_number => 1.0
1338: , p_init_msg_list => fnd_api.g_false
1339: , p_commit => fnd_api.g_true
1340: , x_return_status => l_return_status
1341: , x_msg_count => x_msg_count
1342: , x_msg_data => x_msg_data

Line 1339: , p_commit => fnd_api.g_true

1335: --inv_debug.message('number of mold record is ' || l_mold_tbl.count);
1336: inv_pick_wave_pick_confirm_pub.pick_confirm(
1337: p_api_version_number => 1.0
1338: , p_init_msg_list => fnd_api.g_false
1339: , p_commit => fnd_api.g_true
1340: , x_return_status => l_return_status
1341: , x_msg_count => x_msg_count
1342: , x_msg_data => x_msg_data
1343: , p_move_order_type => p_move_order_type

Line 1352: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1348: , x_trolin_tbl => l_trolin_tbl
1349: );
1350:
1351: --inv_debug.message('l_return_status = ' || l_return_status);
1352: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1353: RAISE fnd_api.g_exc_unexpected_error;
1354: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1355: RAISE fnd_api.g_exc_error;
1356: END IF;

Line 1353: RAISE fnd_api.g_exc_unexpected_error;

1349: );
1350:
1351: --inv_debug.message('l_return_status = ' || l_return_status);
1352: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1353: RAISE fnd_api.g_exc_unexpected_error;
1354: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1355: RAISE fnd_api.g_exc_error;
1356: END IF;
1357:

Line 1354: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1350:
1351: --inv_debug.message('l_return_status = ' || l_return_status);
1352: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1353: RAISE fnd_api.g_exc_unexpected_error;
1354: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1355: RAISE fnd_api.g_exc_error;
1356: END IF;
1357:
1358: --null;

Line 1355: RAISE fnd_api.g_exc_error;

1351: --inv_debug.message('l_return_status = ' || l_return_status);
1352: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1353: RAISE fnd_api.g_exc_unexpected_error;
1354: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1355: RAISE fnd_api.g_exc_error;
1356: END IF;
1357:
1358: --null;
1359: x_return_status := l_return_status;

Line 1361: WHEN fnd_api.g_exc_error THEN

1357:
1358: --null;
1359: x_return_status := l_return_status;
1360: EXCEPTION
1361: WHEN fnd_api.g_exc_error THEN
1362: x_return_status := fnd_api.g_ret_sts_error;
1363: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1364: fnd_msg_pub.ADD;
1365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1362: x_return_status := fnd_api.g_ret_sts_error;

1358: --null;
1359: x_return_status := l_return_status;
1360: EXCEPTION
1361: WHEN fnd_api.g_exc_error THEN
1362: x_return_status := fnd_api.g_ret_sts_error;
1363: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1364: fnd_msg_pub.ADD;
1365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1366: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1366: WHEN fnd_api.g_exc_unexpected_error THEN

1362: x_return_status := fnd_api.g_ret_sts_error;
1363: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1364: fnd_msg_pub.ADD;
1365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1366: WHEN fnd_api.g_exc_unexpected_error THEN
1367: x_return_status := fnd_api.g_ret_sts_unexp_error;
1368: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1369: fnd_msg_pub.ADD;
1370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1367: x_return_status := fnd_api.g_ret_sts_unexp_error;

1363: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1364: fnd_msg_pub.ADD;
1365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1366: WHEN fnd_api.g_exc_unexpected_error THEN
1367: x_return_status := fnd_api.g_ret_sts_unexp_error;
1368: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1369: fnd_msg_pub.ADD;
1370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1371: WHEN OTHERS THEN

Line 1372: x_return_status := fnd_api.g_ret_sts_unexp_error;

1368: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1369: fnd_msg_pub.ADD;
1370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1371: WHEN OTHERS THEN
1372: x_return_status := fnd_api.g_ret_sts_unexp_error;
1373:
1374: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1375: fnd_msg_pub.add_exc_msg(g_pkg_name, 'AUTO_PICK_CONFIRM');
1376: END IF;

Line 1401: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

1397: , p_missing_quantity => l_missing_quantity
1398: , p_reservation_id => l_reservation_id
1399: );
1400:
1401: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1402: RAISE fnd_api.g_exc_error;
1403: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1404: RAISE fnd_api.g_exc_unexpected_error;
1405: END IF;

Line 1402: RAISE fnd_api.g_exc_error;

1398: , p_reservation_id => l_reservation_id
1399: );
1400:
1401: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1402: RAISE fnd_api.g_exc_error;
1403: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1404: RAISE fnd_api.g_exc_unexpected_error;
1405: END IF;
1406:

Line 1403: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1399: );
1400:
1401: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1402: RAISE fnd_api.g_exc_error;
1403: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1404: RAISE fnd_api.g_exc_unexpected_error;
1405: END IF;
1406:
1407: x_return_status := l_return_status;

Line 1404: RAISE fnd_api.g_exc_unexpected_error;

1400:
1401: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
1402: RAISE fnd_api.g_exc_error;
1403: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1404: RAISE fnd_api.g_exc_unexpected_error;
1405: END IF;
1406:
1407: x_return_status := l_return_status;
1408: EXCEPTION

Line 1409: WHEN fnd_api.g_exc_error THEN

1405: END IF;
1406:
1407: x_return_status := l_return_status;
1408: EXCEPTION
1409: WHEN fnd_api.g_exc_error THEN
1410: x_return_status := fnd_api.g_ret_sts_error;
1411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1412: WHEN fnd_api.g_exc_unexpected_error THEN
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1410: x_return_status := fnd_api.g_ret_sts_error;

1406:
1407: x_return_status := l_return_status;
1408: EXCEPTION
1409: WHEN fnd_api.g_exc_error THEN
1410: x_return_status := fnd_api.g_ret_sts_error;
1411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1412: WHEN fnd_api.g_exc_unexpected_error THEN
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1412: WHEN fnd_api.g_exc_unexpected_error THEN

1408: EXCEPTION
1409: WHEN fnd_api.g_exc_error THEN
1410: x_return_status := fnd_api.g_ret_sts_error;
1411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1412: WHEN fnd_api.g_exc_unexpected_error THEN
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1415: WHEN OTHERS THEN
1416: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1413: x_return_status := fnd_api.g_ret_sts_unexp_error;

1409: WHEN fnd_api.g_exc_error THEN
1410: x_return_status := fnd_api.g_ret_sts_error;
1411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1412: WHEN fnd_api.g_exc_unexpected_error THEN
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1415: WHEN OTHERS THEN
1416: x_return_status := fnd_api.g_ret_sts_unexp_error;
1417:

Line 1416: x_return_status := fnd_api.g_ret_sts_unexp_error;

1412: WHEN fnd_api.g_exc_unexpected_error THEN
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1415: WHEN OTHERS THEN
1416: x_return_status := fnd_api.g_ret_sts_unexp_error;
1417:
1418: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1419: fnd_msg_pub.add_exc_msg(g_pkg_name, 'AUTO_PICK_CONFIRM');
1420: END IF;

Line 1497: IF l_return_status = fnd_api.g_ret_sts_error THEN

1493: , x_mtl_reservation_tbl_count => l_mtl_reservation_tbl_count
1494: , x_error_code => l_error_code
1495: );
1496:
1497: IF l_return_status = fnd_api.g_ret_sts_error THEN
1498: RAISE fnd_api.g_exc_error;
1499: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1500: RAISE fnd_api.g_exc_unexpected_error;
1501: END IF;

Line 1498: RAISE fnd_api.g_exc_error;

1494: , x_error_code => l_error_code
1495: );
1496:
1497: IF l_return_status = fnd_api.g_ret_sts_error THEN
1498: RAISE fnd_api.g_exc_error;
1499: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1500: RAISE fnd_api.g_exc_unexpected_error;
1501: END IF;
1502:

Line 1499: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1495: );
1496:
1497: IF l_return_status = fnd_api.g_ret_sts_error THEN
1498: RAISE fnd_api.g_exc_error;
1499: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1500: RAISE fnd_api.g_exc_unexpected_error;
1501: END IF;
1502:
1503: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);

Line 1500: RAISE fnd_api.g_exc_unexpected_error;

1496:
1497: IF l_return_status = fnd_api.g_ret_sts_error THEN
1498: RAISE fnd_api.g_exc_error;
1499: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1500: RAISE fnd_api.g_exc_unexpected_error;
1501: END IF;
1502:
1503: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);
1504:

Line 1529: , p_init_msg_lst => fnd_api.g_false

1525: END IF;
1526:
1527: inv_reservation_pub.update_reservation(
1528: p_api_version_number => 1.0
1529: , p_init_msg_lst => fnd_api.g_false
1530: , x_return_status => l_return_status
1531: , x_msg_count => x_msg_count
1532: , x_msg_data => x_msg_data
1533: , p_original_rsv_rec => l_mtl_reservation_tbl(1)

Line 1537: , p_validation_flag => fnd_api.g_true

1533: , p_original_rsv_rec => l_mtl_reservation_tbl(1)
1534: , p_to_rsv_rec => l_mtl_reservation_rec
1535: , p_original_serial_number => l_original_serial_number
1536: , p_to_serial_number => l_to_serial_number
1537: , p_validation_flag => fnd_api.g_true
1538: );
1539:
1540: IF (l_debug = 1) THEN
1541: print_debug('after update reservation return status is ' || l_return_status);

Line 1544: IF l_return_status = fnd_api.g_ret_sts_error THEN

1540: IF (l_debug = 1) THEN
1541: print_debug('after update reservation return status is ' || l_return_status);
1542: END IF;
1543:
1544: IF l_return_status = fnd_api.g_ret_sts_error THEN
1545: RAISE fnd_api.g_exc_error;
1546: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1547: RAISE fnd_api.g_exc_unexpected_error;
1548: END IF;

Line 1545: RAISE fnd_api.g_exc_error;

1541: print_debug('after update reservation return status is ' || l_return_status);
1542: END IF;
1543:
1544: IF l_return_status = fnd_api.g_ret_sts_error THEN
1545: RAISE fnd_api.g_exc_error;
1546: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1547: RAISE fnd_api.g_exc_unexpected_error;
1548: END IF;
1549: ELSE

Line 1546: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1542: END IF;
1543:
1544: IF l_return_status = fnd_api.g_ret_sts_error THEN
1545: RAISE fnd_api.g_exc_error;
1546: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1547: RAISE fnd_api.g_exc_unexpected_error;
1548: END IF;
1549: ELSE
1550: IF (l_debug = 1) THEN

Line 1547: RAISE fnd_api.g_exc_unexpected_error;

1543:
1544: IF l_return_status = fnd_api.g_ret_sts_error THEN
1545: RAISE fnd_api.g_exc_error;
1546: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1547: RAISE fnd_api.g_exc_unexpected_error;
1548: END IF;
1549: ELSE
1550: IF (l_debug = 1) THEN
1551: print_debug('reservable staging subinventory, transfer reservation to staging');

Line 1582: , p_init_msg_lst => fnd_api.g_false

1578: l_mtl_reservation_rec.lot_number := l_lot_number;
1579: l_mtl_reservation_rec.revision := l_mmtt_rec.revision;
1580: inv_reservation_pub.transfer_reservation(
1581: p_api_version_number => 1.0
1582: , p_init_msg_lst => fnd_api.g_false
1583: , x_return_status => l_return_status
1584: , x_msg_count => x_msg_count
1585: , x_msg_data => x_msg_data
1586: , p_original_rsv_rec => l_mtl_reservation_tbl(1)

Line 1606: IF l_return_status = fnd_api.g_ret_sts_error THEN

1602: IF (l_debug = 1) THEN
1603: print_debug(l_message);
1604: END IF;
1605: end loop; */
1606: IF l_return_status = fnd_api.g_ret_sts_error THEN
1607: IF (l_debug = 1) THEN
1608: print_debug('return from transfer_reservation with error E');
1609: END IF;
1610:

Line 1611: RAISE fnd_api.g_exc_error;

1607: IF (l_debug = 1) THEN
1608: print_debug('return from transfer_reservation with error E');
1609: END IF;
1610:
1611: RAISE fnd_api.g_exc_error;
1612: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1613: IF (l_debug = 1) THEN
1614: print_debug('return from transfer_reservation with error U');
1615: END IF;

Line 1612: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1608: print_debug('return from transfer_reservation with error E');
1609: END IF;
1610:
1611: RAISE fnd_api.g_exc_error;
1612: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1613: IF (l_debug = 1) THEN
1614: print_debug('return from transfer_reservation with error U');
1615: END IF;
1616:

Line 1617: RAISE fnd_api.g_exc_unexpected_error;

1613: IF (l_debug = 1) THEN
1614: print_debug('return from transfer_reservation with error U');
1615: END IF;
1616:
1617: RAISE fnd_api.g_exc_unexpected_error;
1618: END IF;
1619: END LOOP;
1620:
1621: IF (l_debug = 1) THEN

Line 1642: , p_init_msg_lst => fnd_api.g_false

1638: l_mtl_reservation_rec.revision := l_mmtt_rec.revision;
1639: --print_debug('lot number is ' || l_mtl_reservation_rec.lot_number);
1640: inv_reservation_pub.transfer_reservation(
1641: p_api_version_number => 1.0
1642: , p_init_msg_lst => fnd_api.g_false
1643: , x_return_status => l_return_status
1644: , x_msg_count => x_msg_count
1645: , x_msg_data => x_msg_data
1646: , p_original_rsv_rec => l_mtl_reservation_tbl(1)

Line 1666: IF l_return_status = fnd_api.g_ret_sts_error THEN

1662: IF (l_debug = 1) THEN
1663: print_debug(l_message);
1664: END IF;
1665: end loop; */
1666: IF l_return_status = fnd_api.g_ret_sts_error THEN
1667: IF (l_debug = 1) THEN
1668: print_debug('return from transfer_reservation with error E');
1669: END IF;
1670:

Line 1671: RAISE fnd_api.g_exc_error;

1667: IF (l_debug = 1) THEN
1668: print_debug('return from transfer_reservation with error E');
1669: END IF;
1670:
1671: RAISE fnd_api.g_exc_error;
1672: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1673: IF (l_debug = 1) THEN
1674: print_debug('return from transfer_reservation with error U');
1675: END IF;

Line 1672: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1668: print_debug('return from transfer_reservation with error E');
1669: END IF;
1670:
1671: RAISE fnd_api.g_exc_error;
1672: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1673: IF (l_debug = 1) THEN
1674: print_debug('return from transfer_reservation with error U');
1675: END IF;
1676:

Line 1677: RAISE fnd_api.g_exc_unexpected_error;

1673: IF (l_debug = 1) THEN
1674: print_debug('return from transfer_reservation with error U');
1675: END IF;
1676:
1677: RAISE fnd_api.g_exc_unexpected_error;
1678: END IF;
1679:
1680: IF (l_debug = 1) THEN
1681: print_debug('still inside if no lot records');

Line 1763: l_return_status := fnd_api.g_ret_sts_success;

1759: record_locked EXCEPTION;
1760: PRAGMA EXCEPTION_INIT(record_locked, -54);
1761: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1762: BEGIN
1763: l_return_status := fnd_api.g_ret_sts_success;
1764:
1765: BEGIN
1766: SELECT organization_id
1767: INTO l_organization_id

Line 1772: RAISE fnd_api.g_exc_unexpected_error;

1768: FROM mtl_txn_request_lines
1769: WHERE line_id = p_line_id;
1770: EXCEPTION
1771: WHEN NO_DATA_FOUND THEN
1772: RAISE fnd_api.g_exc_unexpected_error;
1773: END;
1774:
1775: -- If overpicking is not turned on then the maximum quanitity that is
1776: -- allowed is the move order quantity

Line 1819: RAISE fnd_api.g_exc_error;

1815: OPEN c_txn_source;
1816: FETCH c_txn_source INTO l_txn_source_line_id, l_inventory_item_id;
1817:
1818: IF c_txn_source%NOTFOUND THEN
1819: RAISE fnd_api.g_exc_error;
1820: END IF;
1821:
1822: CLOSE c_txn_source;
1823:

Line 1848: RAISE fnd_api.g_exc_error;

1844: EXCEPTION
1845: WHEN record_locked THEN
1846: fnd_message.set_name('INV', 'INV_MO_LOCKED_SO');
1847: fnd_msg_pub.ADD;
1848: RAISE fnd_api.g_exc_error;
1849: END;
1850:
1851: SELECT NVL(SUM(ABS(transaction_quantity)), 0)
1852: INTO l_allocation_quantity

Line 1869: IF l_return_status = fnd_api.g_ret_sts_error THEN

1865: , x_return_status => l_return_status
1866: , x_avail_req_quantity => l_avail_req_qty
1867: );
1868:
1869: IF l_return_status = fnd_api.g_ret_sts_error THEN
1870: RAISE fnd_api.g_exc_error;
1871: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1872: RAISE fnd_api.g_exc_unexpected_error;
1873: END IF;

Line 1870: RAISE fnd_api.g_exc_error;

1866: , x_avail_req_quantity => l_avail_req_qty
1867: );
1868:
1869: IF l_return_status = fnd_api.g_ret_sts_error THEN
1870: RAISE fnd_api.g_exc_error;
1871: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1872: RAISE fnd_api.g_exc_unexpected_error;
1873: END IF;
1874: END IF;

Line 1871: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1867: );
1868:
1869: IF l_return_status = fnd_api.g_ret_sts_error THEN
1870: RAISE fnd_api.g_exc_error;
1871: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1872: RAISE fnd_api.g_exc_unexpected_error;
1873: END IF;
1874: END IF;
1875:

Line 1872: RAISE fnd_api.g_exc_unexpected_error;

1868:
1869: IF l_return_status = fnd_api.g_ret_sts_error THEN
1870: RAISE fnd_api.g_exc_error;
1871: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1872: RAISE fnd_api.g_exc_unexpected_error;
1873: END IF;
1874: END IF;
1875:
1876: x_max_quantity := l_max_quantity;

Line 1880: WHEN fnd_api.g_exc_error THEN

1876: x_max_quantity := l_max_quantity;
1877: x_allowed := l_allowed;
1878: x_return_status := l_return_status;
1879: EXCEPTION
1880: WHEN fnd_api.g_exc_error THEN
1881: x_return_status := fnd_api.g_ret_sts_error;
1882: x_allowed := 'N';
1883: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1884: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1881: x_return_status := fnd_api.g_ret_sts_error;

1877: x_allowed := l_allowed;
1878: x_return_status := l_return_status;
1879: EXCEPTION
1880: WHEN fnd_api.g_exc_error THEN
1881: x_return_status := fnd_api.g_ret_sts_error;
1882: x_allowed := 'N';
1883: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1884: WHEN fnd_api.g_exc_unexpected_error THEN
1885: x_return_status := fnd_api.g_ret_sts_error;

Line 1884: WHEN fnd_api.g_exc_unexpected_error THEN

1880: WHEN fnd_api.g_exc_error THEN
1881: x_return_status := fnd_api.g_ret_sts_error;
1882: x_allowed := 'N';
1883: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1884: WHEN fnd_api.g_exc_unexpected_error THEN
1885: x_return_status := fnd_api.g_ret_sts_error;
1886: x_allowed := 'N';
1887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1888: WHEN OTHERS THEN

Line 1885: x_return_status := fnd_api.g_ret_sts_error;

1881: x_return_status := fnd_api.g_ret_sts_error;
1882: x_allowed := 'N';
1883: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1884: WHEN fnd_api.g_exc_unexpected_error THEN
1885: x_return_status := fnd_api.g_ret_sts_error;
1886: x_allowed := 'N';
1887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1888: WHEN OTHERS THEN
1889: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1889: x_return_status := fnd_api.g_ret_sts_unexp_error;

1885: x_return_status := fnd_api.g_ret_sts_error;
1886: x_allowed := 'N';
1887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1888: WHEN OTHERS THEN
1889: x_return_status := fnd_api.g_ret_sts_unexp_error;
1890: x_allowed := 'N';
1891:
1892: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1893: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1948: x_return_status := fnd_api.g_ret_sts_success;

1944: l_return_status VARCHAR2(1);
1945: --For DB log
1946: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1947: BEGIN
1948: x_return_status := fnd_api.g_ret_sts_success;
1949:
1950: --Resolve org_id and move_order_type from the passed transaction_temp_id
1951: SELECT mmtt.organization_id
1952: , mtrh.move_order_type

Line 2095: IF l_return_status = fnd_api.g_ret_sts_error THEN

2091: print_debug('OVPK: x_return_status = ' || l_return_status);
2092: print_debug('OVPK: x_max_quantity = ' || l_max_quantity_allowed);
2093: END IF;
2094:
2095: IF l_return_status = fnd_api.g_ret_sts_error THEN
2096: RAISE fnd_api.g_exc_error;
2097: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2098: RAISE fnd_api.g_exc_unexpected_error;
2099: END IF;

Line 2096: RAISE fnd_api.g_exc_error;

2092: print_debug('OVPK: x_max_quantity = ' || l_max_quantity_allowed);
2093: END IF;
2094:
2095: IF l_return_status = fnd_api.g_ret_sts_error THEN
2096: RAISE fnd_api.g_exc_error;
2097: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2098: RAISE fnd_api.g_exc_unexpected_error;
2099: END IF;
2100: END IF;

Line 2097: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2093: END IF;
2094:
2095: IF l_return_status = fnd_api.g_ret_sts_error THEN
2096: RAISE fnd_api.g_exc_error;
2097: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2098: RAISE fnd_api.g_exc_unexpected_error;
2099: END IF;
2100: END IF;
2101:

Line 2098: RAISE fnd_api.g_exc_unexpected_error;

2094:
2095: IF l_return_status = fnd_api.g_ret_sts_error THEN
2096: RAISE fnd_api.g_exc_error;
2097: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2098: RAISE fnd_api.g_exc_unexpected_error;
2099: END IF;
2100: END IF;
2101:
2102: /*

Line 2135: WHEN fnd_api.g_exc_error THEN

2131:
2132: RETURN;
2133: END IF;
2134: EXCEPTION
2135: WHEN fnd_api.g_exc_error THEN
2136: x_return_status := fnd_api.g_ret_sts_error;
2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2138: WHEN fnd_api.g_exc_unexpected_error THEN
2139: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2136: x_return_status := fnd_api.g_ret_sts_error;

2132: RETURN;
2133: END IF;
2134: EXCEPTION
2135: WHEN fnd_api.g_exc_error THEN
2136: x_return_status := fnd_api.g_ret_sts_error;
2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2138: WHEN fnd_api.g_exc_unexpected_error THEN
2139: x_return_status := fnd_api.g_ret_sts_unexp_error;
2140: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2138: WHEN fnd_api.g_exc_unexpected_error THEN

2134: EXCEPTION
2135: WHEN fnd_api.g_exc_error THEN
2136: x_return_status := fnd_api.g_ret_sts_error;
2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2138: WHEN fnd_api.g_exc_unexpected_error THEN
2139: x_return_status := fnd_api.g_ret_sts_unexp_error;
2140: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2141: WHEN OTHERS THEN
2142: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2139: x_return_status := fnd_api.g_ret_sts_unexp_error;

2135: WHEN fnd_api.g_exc_error THEN
2136: x_return_status := fnd_api.g_ret_sts_error;
2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2138: WHEN fnd_api.g_exc_unexpected_error THEN
2139: x_return_status := fnd_api.g_ret_sts_unexp_error;
2140: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2141: WHEN OTHERS THEN
2142: x_return_status := fnd_api.g_ret_sts_unexp_error;
2143:

Line 2142: x_return_status := fnd_api.g_ret_sts_unexp_error;

2138: WHEN fnd_api.g_exc_unexpected_error THEN
2139: x_return_status := fnd_api.g_ret_sts_unexp_error;
2140: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2141: WHEN OTHERS THEN
2142: x_return_status := fnd_api.g_ret_sts_unexp_error;
2143:
2144: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2145: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get_Overpick_Qty');
2146: END IF;

Line 2219: x_return_status := fnd_api.g_ret_sts_success;

2215: --l_txn_qty NUMBER;
2216: --For DB log
2217: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2218: BEGIN
2219: x_return_status := fnd_api.g_ret_sts_success;
2220: x_check_overpick_passed := 'N';
2221:
2222: --l_txn_qty := p_overpicked_qty;
2223: --Resolve org_id,transaction_quantity, move_order_line_id

Line 2288: IF x_return_status = fnd_api.g_ret_sts_error THEN

2284: print_debug('OVPK: l_ovpk_allowed = ' || l_ovpk_allowed);
2285: print_debug('OVPK: l_max_qty_allowed = ' || l_max_qty_allowed);
2286: END IF;
2287:
2288: IF x_return_status = fnd_api.g_ret_sts_error THEN
2289: RAISE fnd_api.g_exc_error;
2290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2291: RAISE fnd_api.g_exc_unexpected_error;
2292: END IF;

Line 2289: RAISE fnd_api.g_exc_error;

2285: print_debug('OVPK: l_max_qty_allowed = ' || l_max_qty_allowed);
2286: END IF;
2287:
2288: IF x_return_status = fnd_api.g_ret_sts_error THEN
2289: RAISE fnd_api.g_exc_error;
2290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2291: RAISE fnd_api.g_exc_unexpected_error;
2292: END IF;
2293:

Line 2290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2286: END IF;
2287:
2288: IF x_return_status = fnd_api.g_ret_sts_error THEN
2289: RAISE fnd_api.g_exc_error;
2290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2291: RAISE fnd_api.g_exc_unexpected_error;
2292: END IF;
2293:
2294: --Overpicked quantity is passed as one of the params to this procedure

Line 2291: RAISE fnd_api.g_exc_unexpected_error;

2287:
2288: IF x_return_status = fnd_api.g_ret_sts_error THEN
2289: RAISE fnd_api.g_exc_error;
2290: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2291: RAISE fnd_api.g_exc_unexpected_error;
2292: END IF;
2293:
2294: --Overpicked quantity is passed as one of the params to this procedure
2295: --so no need of any code here to determine overpicked quantity

Line 2363: IF x_return_status = fnd_api.g_ret_sts_error THEN

2359: print_debug('OVPK: x_return_status = ' || x_return_status);
2360: print_debug('OVPK: x_att = ' || x_att);
2361: END IF;
2362:
2363: IF x_return_status = fnd_api.g_ret_sts_error THEN
2364: RAISE fnd_api.g_exc_error;
2365: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2366: RAISE fnd_api.g_exc_unexpected_error;
2367: END IF;

Line 2364: RAISE fnd_api.g_exc_error;

2360: print_debug('OVPK: x_att = ' || x_att);
2361: END IF;
2362:
2363: IF x_return_status = fnd_api.g_ret_sts_error THEN
2364: RAISE fnd_api.g_exc_error;
2365: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2366: RAISE fnd_api.g_exc_unexpected_error;
2367: END IF;
2368:

Line 2365: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2361: END IF;
2362:
2363: IF x_return_status = fnd_api.g_ret_sts_error THEN
2364: RAISE fnd_api.g_exc_error;
2365: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2366: RAISE fnd_api.g_exc_unexpected_error;
2367: END IF;
2368:
2369: -- Bug 3361293 There are 3 cases for a user to pick

Line 2366: RAISE fnd_api.g_exc_unexpected_error;

2362:
2363: IF x_return_status = fnd_api.g_ret_sts_error THEN
2364: RAISE fnd_api.g_exc_error;
2365: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2366: RAISE fnd_api.g_exc_unexpected_error;
2367: END IF;
2368:
2369: -- Bug 3361293 There are 3 cases for a user to pick
2370: 1. Allocations are for loose quantity or LPN- User is trying to pick

Line 2421: RAISE fnd_api.g_exc_error;

2417:
2418: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
2419: x_ovpk_error_code := 3;
2420: fnd_msg_pub.ADD;
2421: RAISE fnd_api.g_exc_error;
2422: ELSE
2423: --Allow the user to overpick
2424: x_check_overpick_passed := 'Y';
2425:

Line 2454: RAISE fnd_api.g_exc_error;*/

2450:
2451: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
2452: x_ovpk_error_code := 2;
2453: fnd_msg_pub.ADD;
2454: RAISE fnd_api.g_exc_error;*/
2455: --END IF;
2456: ELSE
2457: --ERROR Overpicking is not allowed in this org and for this Move Order type
2458: IF l_debug = 1 THEN

Line 2466: RAISE fnd_api.g_exc_error;

2462:
2463: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
2464: x_ovpk_error_code := 1;
2465: fnd_msg_pub.ADD;
2466: RAISE fnd_api.g_exc_error;
2467: END IF;
2468: EXCEPTION
2469: WHEN fnd_api.g_exc_error THEN
2470: x_return_status := fnd_api.g_ret_sts_error;

Line 2469: WHEN fnd_api.g_exc_error THEN

2465: fnd_msg_pub.ADD;
2466: RAISE fnd_api.g_exc_error;
2467: END IF;
2468: EXCEPTION
2469: WHEN fnd_api.g_exc_error THEN
2470: x_return_status := fnd_api.g_ret_sts_error;
2471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2472: WHEN fnd_api.g_exc_unexpected_error THEN
2473: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2470: x_return_status := fnd_api.g_ret_sts_error;

2466: RAISE fnd_api.g_exc_error;
2467: END IF;
2468: EXCEPTION
2469: WHEN fnd_api.g_exc_error THEN
2470: x_return_status := fnd_api.g_ret_sts_error;
2471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2472: WHEN fnd_api.g_exc_unexpected_error THEN
2473: x_return_status := fnd_api.g_ret_sts_unexp_error;
2474: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2472: WHEN fnd_api.g_exc_unexpected_error THEN

2468: EXCEPTION
2469: WHEN fnd_api.g_exc_error THEN
2470: x_return_status := fnd_api.g_ret_sts_error;
2471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2472: WHEN fnd_api.g_exc_unexpected_error THEN
2473: x_return_status := fnd_api.g_ret_sts_unexp_error;
2474: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2475: WHEN OTHERS THEN
2476: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2473: x_return_status := fnd_api.g_ret_sts_unexp_error;

2469: WHEN fnd_api.g_exc_error THEN
2470: x_return_status := fnd_api.g_ret_sts_error;
2471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2472: WHEN fnd_api.g_exc_unexpected_error THEN
2473: x_return_status := fnd_api.g_ret_sts_unexp_error;
2474: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2475: WHEN OTHERS THEN
2476: x_return_status := fnd_api.g_ret_sts_unexp_error;
2477:

Line 2476: x_return_status := fnd_api.g_ret_sts_unexp_error;

2472: WHEN fnd_api.g_exc_unexpected_error THEN
2473: x_return_status := fnd_api.g_ret_sts_unexp_error;
2474: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2475: WHEN OTHERS THEN
2476: x_return_status := fnd_api.g_ret_sts_unexp_error;
2477:
2478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2479: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Check_Overpick');
2480: END IF;

Line 2561: x_return_status := fnd_api.g_ret_sts_success;

2557: l_atr NUMBER;
2558: --For DB log
2559: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2560: BEGIN
2561: x_return_status := fnd_api.g_ret_sts_success;
2562: x_check_overpick_passed := 'N';
2563:
2564: --Resolve org_id,transaction_quantity, move_order_line_id
2565: --from the transaction_temp_id

Line 2627: IF x_return_status = fnd_api.g_ret_sts_error THEN

2623: print_debug('OVPK: l_ovpk_allowed = ' || l_ovpk_allowed);
2624: print_debug('OVPK: l_max_qty_allowed = ' || l_max_qty_allowed);
2625: END IF;
2626:
2627: IF x_return_status = fnd_api.g_ret_sts_error THEN
2628: RAISE fnd_api.g_exc_error;
2629: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2630: RAISE fnd_api.g_exc_unexpected_error;
2631: END IF;

Line 2628: RAISE fnd_api.g_exc_error;

2624: print_debug('OVPK: l_max_qty_allowed = ' || l_max_qty_allowed);
2625: END IF;
2626:
2627: IF x_return_status = fnd_api.g_ret_sts_error THEN
2628: RAISE fnd_api.g_exc_error;
2629: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2630: RAISE fnd_api.g_exc_unexpected_error;
2631: END IF;
2632:

Line 2629: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2625: END IF;
2626:
2627: IF x_return_status = fnd_api.g_ret_sts_error THEN
2628: RAISE fnd_api.g_exc_error;
2629: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2630: RAISE fnd_api.g_exc_unexpected_error;
2631: END IF;
2632:
2633: --Overpicked quantity is passed as one of the params to this procedure

Line 2630: RAISE fnd_api.g_exc_unexpected_error;

2626:
2627: IF x_return_status = fnd_api.g_ret_sts_error THEN
2628: RAISE fnd_api.g_exc_error;
2629: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2630: RAISE fnd_api.g_exc_unexpected_error;
2631: END IF;
2632:
2633: --Overpicked quantity is passed as one of the params to this procedure
2634: --so no need of any code here to determine overpicked quantity

Line 2704: IF x_return_status = fnd_api.g_ret_sts_error THEN

2700: print_debug('OVPK: x_return_status = ' || x_return_status);
2701: print_debug('OVPK: x_att = ' || x_att);
2702: END IF;
2703:
2704: IF x_return_status = fnd_api.g_ret_sts_error THEN
2705: RAISE fnd_api.g_exc_error;
2706: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2707: RAISE fnd_api.g_exc_unexpected_error;
2708: END IF;

Line 2705: RAISE fnd_api.g_exc_error;

2701: print_debug('OVPK: x_att = ' || x_att);
2702: END IF;
2703:
2704: IF x_return_status = fnd_api.g_ret_sts_error THEN
2705: RAISE fnd_api.g_exc_error;
2706: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2707: RAISE fnd_api.g_exc_unexpected_error;
2708: END IF;
2709:

Line 2706: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2702: END IF;
2703:
2704: IF x_return_status = fnd_api.g_ret_sts_error THEN
2705: RAISE fnd_api.g_exc_error;
2706: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2707: RAISE fnd_api.g_exc_unexpected_error;
2708: END IF;
2709:
2710: IF (x_att >= p_overpicked_qty) THEN

Line 2707: RAISE fnd_api.g_exc_unexpected_error;

2703:
2704: IF x_return_status = fnd_api.g_ret_sts_error THEN
2705: RAISE fnd_api.g_exc_error;
2706: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2707: RAISE fnd_api.g_exc_unexpected_error;
2708: END IF;
2709:
2710: IF (x_att >= p_overpicked_qty) THEN
2711: IF (l_max_qty_allowed <> -1

Line 2722: RAISE fnd_api.g_exc_error;

2718:
2719: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
2720: x_ovpk_error_code := 3;
2721: fnd_msg_pub.ADD;
2722: RAISE fnd_api.g_exc_error;
2723: ELSE
2724: --Allow the user to overpick
2725: x_check_overpick_passed := 'Y';
2726:

Line 2755: RAISE fnd_api.g_exc_error;

2751:
2752: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
2753: x_ovpk_error_code := 2;
2754: fnd_msg_pub.ADD;
2755: RAISE fnd_api.g_exc_error;
2756: END IF;
2757: ELSE
2758: --ERROR Overpicking is not allowed in this org and for this Move Order type
2759: IF l_debug = 1 THEN

Line 2767: RAISE fnd_api.g_exc_error;

2763:
2764: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
2765: x_ovpk_error_code := 1;
2766: fnd_msg_pub.ADD;
2767: RAISE fnd_api.g_exc_error;
2768: END IF;
2769: EXCEPTION
2770: WHEN fnd_api.g_exc_error THEN
2771: x_return_status := fnd_api.g_ret_sts_error;

Line 2770: WHEN fnd_api.g_exc_error THEN

2766: fnd_msg_pub.ADD;
2767: RAISE fnd_api.g_exc_error;
2768: END IF;
2769: EXCEPTION
2770: WHEN fnd_api.g_exc_error THEN
2771: x_return_status := fnd_api.g_ret_sts_error;
2772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2773: WHEN fnd_api.g_exc_unexpected_error THEN
2774: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2771: x_return_status := fnd_api.g_ret_sts_error;

2767: RAISE fnd_api.g_exc_error;
2768: END IF;
2769: EXCEPTION
2770: WHEN fnd_api.g_exc_error THEN
2771: x_return_status := fnd_api.g_ret_sts_error;
2772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2773: WHEN fnd_api.g_exc_unexpected_error THEN
2774: x_return_status := fnd_api.g_ret_sts_unexp_error;
2775: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2773: WHEN fnd_api.g_exc_unexpected_error THEN

2769: EXCEPTION
2770: WHEN fnd_api.g_exc_error THEN
2771: x_return_status := fnd_api.g_ret_sts_error;
2772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2773: WHEN fnd_api.g_exc_unexpected_error THEN
2774: x_return_status := fnd_api.g_ret_sts_unexp_error;
2775: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2776: WHEN OTHERS THEN
2777: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2774: x_return_status := fnd_api.g_ret_sts_unexp_error;

2770: WHEN fnd_api.g_exc_error THEN
2771: x_return_status := fnd_api.g_ret_sts_error;
2772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2773: WHEN fnd_api.g_exc_unexpected_error THEN
2774: x_return_status := fnd_api.g_ret_sts_unexp_error;
2775: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2776: WHEN OTHERS THEN
2777: x_return_status := fnd_api.g_ret_sts_unexp_error;
2778:

Line 2777: x_return_status := fnd_api.g_ret_sts_unexp_error;

2773: WHEN fnd_api.g_exc_unexpected_error THEN
2774: x_return_status := fnd_api.g_ret_sts_unexp_error;
2775: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2776: WHEN OTHERS THEN
2777: x_return_status := fnd_api.g_ret_sts_unexp_error;
2778:
2779: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2780: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Check_Overpick');
2781: END IF;

Line 2830: x_return_status := fnd_api.g_ret_sts_success;

2826: l_return_status VARCHAR2(1);
2827: --For DB log
2828: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2829: BEGIN
2830: x_return_status := fnd_api.g_ret_sts_success;
2831:
2832: --Resolve org_id and move_order_type from the passed transaction_temp_id
2833: SELECT mmtt.organization_id
2834: , mtrh.move_order_type

Line 2978: IF l_return_status = fnd_api.g_ret_sts_error THEN

2974: print_debug('OVPK: x_return_status = ' || l_return_status);
2975: print_debug('OVPK: x_max_quantity = ' || l_max_quantity_allowed);
2976: END IF;
2977:
2978: IF l_return_status = fnd_api.g_ret_sts_error THEN
2979: RAISE fnd_api.g_exc_error;
2980: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2981: RAISE fnd_api.g_exc_unexpected_error;
2982: END IF;

Line 2979: RAISE fnd_api.g_exc_error;

2975: print_debug('OVPK: x_max_quantity = ' || l_max_quantity_allowed);
2976: END IF;
2977:
2978: IF l_return_status = fnd_api.g_ret_sts_error THEN
2979: RAISE fnd_api.g_exc_error;
2980: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2981: RAISE fnd_api.g_exc_unexpected_error;
2982: END IF;
2983: END IF;

Line 2980: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2976: END IF;
2977:
2978: IF l_return_status = fnd_api.g_ret_sts_error THEN
2979: RAISE fnd_api.g_exc_error;
2980: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2981: RAISE fnd_api.g_exc_unexpected_error;
2982: END IF;
2983: END IF;
2984:

Line 2981: RAISE fnd_api.g_exc_unexpected_error;

2977:
2978: IF l_return_status = fnd_api.g_ret_sts_error THEN
2979: RAISE fnd_api.g_exc_error;
2980: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2981: RAISE fnd_api.g_exc_unexpected_error;
2982: END IF;
2983: END IF;
2984:
2985: /*

Line 3048: WHEN fnd_api.g_exc_error THEN

3044:
3045: RETURN;
3046: END IF;
3047: EXCEPTION
3048: WHEN fnd_api.g_exc_error THEN
3049: x_return_status := fnd_api.g_ret_sts_error;
3050: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3051: WHEN fnd_api.g_exc_unexpected_error THEN
3052: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3049: x_return_status := fnd_api.g_ret_sts_error;

3045: RETURN;
3046: END IF;
3047: EXCEPTION
3048: WHEN fnd_api.g_exc_error THEN
3049: x_return_status := fnd_api.g_ret_sts_error;
3050: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3051: WHEN fnd_api.g_exc_unexpected_error THEN
3052: x_return_status := fnd_api.g_ret_sts_unexp_error;
3053: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3051: WHEN fnd_api.g_exc_unexpected_error THEN

3047: EXCEPTION
3048: WHEN fnd_api.g_exc_error THEN
3049: x_return_status := fnd_api.g_ret_sts_error;
3050: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3051: WHEN fnd_api.g_exc_unexpected_error THEN
3052: x_return_status := fnd_api.g_ret_sts_unexp_error;
3053: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3054: WHEN OTHERS THEN
3055: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3052: x_return_status := fnd_api.g_ret_sts_unexp_error;

3048: WHEN fnd_api.g_exc_error THEN
3049: x_return_status := fnd_api.g_ret_sts_error;
3050: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3051: WHEN fnd_api.g_exc_unexpected_error THEN
3052: x_return_status := fnd_api.g_ret_sts_unexp_error;
3053: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3054: WHEN OTHERS THEN
3055: x_return_status := fnd_api.g_ret_sts_unexp_error;
3056:

Line 3055: x_return_status := fnd_api.g_ret_sts_unexp_error;

3051: WHEN fnd_api.g_exc_unexpected_error THEN
3052: x_return_status := fnd_api.g_ret_sts_unexp_error;
3053: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3054: WHEN OTHERS THEN
3055: x_return_status := fnd_api.g_ret_sts_unexp_error;
3056:
3057: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3058: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Get_Overpick_Qty');
3059: END IF;

Line 3105: x_return_status := fnd_api.g_ret_sts_success;

3101: l_atr NUMBER;
3102: --For DB log
3103: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3104: BEGIN
3105: x_return_status := fnd_api.g_ret_sts_success;
3106: x_check_overpick_passed := 'N';
3107:
3108: --Resolve org_id,transaction_quantity, move_order_line_id
3109: --from the transaction_temp_id

Line 3171: IF x_return_status = fnd_api.g_ret_sts_error THEN

3167: print_debug('OVPK: l_max_qty_allowed = ' || l_max_qty_allowed);
3168: print_debug('OVPK: x_other_mtlt = ' || l_other_mtlt);
3169: END IF;
3170:
3171: IF x_return_status = fnd_api.g_ret_sts_error THEN
3172: RAISE fnd_api.g_exc_error;
3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;

Line 3172: RAISE fnd_api.g_exc_error;

3168: print_debug('OVPK: x_other_mtlt = ' || l_other_mtlt);
3169: END IF;
3170:
3171: IF x_return_status = fnd_api.g_ret_sts_error THEN
3172: RAISE fnd_api.g_exc_error;
3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;
3176:

Line 3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3169: END IF;
3170:
3171: IF x_return_status = fnd_api.g_ret_sts_error THEN
3172: RAISE fnd_api.g_exc_error;
3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;
3176:
3177: --Overpicked quantity is passed as one of the params to this procedure

Line 3174: RAISE fnd_api.g_exc_unexpected_error;

3170:
3171: IF x_return_status = fnd_api.g_ret_sts_error THEN
3172: RAISE fnd_api.g_exc_error;
3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;
3176:
3177: --Overpicked quantity is passed as one of the params to this procedure
3178: --so no need of any code here to determine overpicked quantity

Line 3245: IF x_return_status = fnd_api.g_ret_sts_error THEN

3241: print_debug('OVPK: x_return_status = ' || x_return_status);
3242: print_debug('OVPK: x_att = ' || x_att);
3243: END IF;
3244:
3245: IF x_return_status = fnd_api.g_ret_sts_error THEN
3246: RAISE fnd_api.g_exc_error;
3247: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3248: RAISE fnd_api.g_exc_unexpected_error;
3249: END IF;*/

Line 3246: RAISE fnd_api.g_exc_error;

3242: print_debug('OVPK: x_att = ' || x_att);
3243: END IF;
3244:
3245: IF x_return_status = fnd_api.g_ret_sts_error THEN
3246: RAISE fnd_api.g_exc_error;
3247: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3248: RAISE fnd_api.g_exc_unexpected_error;
3249: END IF;*/
3250:

Line 3247: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3243: END IF;
3244:
3245: IF x_return_status = fnd_api.g_ret_sts_error THEN
3246: RAISE fnd_api.g_exc_error;
3247: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3248: RAISE fnd_api.g_exc_unexpected_error;
3249: END IF;*/
3250:
3251: --comment out the if condition and else part since system do att check already

Line 3248: RAISE fnd_api.g_exc_unexpected_error;

3244:
3245: IF x_return_status = fnd_api.g_ret_sts_error THEN
3246: RAISE fnd_api.g_exc_error;
3247: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3248: RAISE fnd_api.g_exc_unexpected_error;
3249: END IF;*/
3250:
3251: --comment out the if condition and else part since system do att check already
3252: --IF (x_att >= p_overpicked_qty) THEN

Line 3264: RAISE fnd_api.g_exc_error;

3260:
3261: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
3262: x_ovpk_error_code := 3;
3263: fnd_msg_pub.ADD;
3264: RAISE fnd_api.g_exc_error;
3265: ELSE
3266: --Allow the user to overpick
3267: x_check_overpick_passed := 'Y';
3268:

Line 3297: RAISE fnd_api.g_exc_error;

3293:
3294: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
3295: x_ovpk_error_code := 2;
3296: fnd_msg_pub.ADD;
3297: RAISE fnd_api.g_exc_error;
3298: END IF;*/
3299: ELSE
3300: --ERROR Overpicking is not allowed in this org and for this Move Order type
3301: IF l_debug = 1 THEN

Line 3309: RAISE fnd_api.g_exc_error;

3305:
3306: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
3307: x_ovpk_error_code := 1;
3308: fnd_msg_pub.ADD;
3309: RAISE fnd_api.g_exc_error;
3310: END IF;
3311: EXCEPTION
3312: WHEN fnd_api.g_exc_error THEN
3313: x_return_status := fnd_api.g_ret_sts_error;

Line 3312: WHEN fnd_api.g_exc_error THEN

3308: fnd_msg_pub.ADD;
3309: RAISE fnd_api.g_exc_error;
3310: END IF;
3311: EXCEPTION
3312: WHEN fnd_api.g_exc_error THEN
3313: x_return_status := fnd_api.g_ret_sts_error;
3314: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3315: WHEN fnd_api.g_exc_unexpected_error THEN
3316: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3313: x_return_status := fnd_api.g_ret_sts_error;

3309: RAISE fnd_api.g_exc_error;
3310: END IF;
3311: EXCEPTION
3312: WHEN fnd_api.g_exc_error THEN
3313: x_return_status := fnd_api.g_ret_sts_error;
3314: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3315: WHEN fnd_api.g_exc_unexpected_error THEN
3316: x_return_status := fnd_api.g_ret_sts_unexp_error;
3317: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3315: WHEN fnd_api.g_exc_unexpected_error THEN

3311: EXCEPTION
3312: WHEN fnd_api.g_exc_error THEN
3313: x_return_status := fnd_api.g_ret_sts_error;
3314: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3315: WHEN fnd_api.g_exc_unexpected_error THEN
3316: x_return_status := fnd_api.g_ret_sts_unexp_error;
3317: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3318: WHEN OTHERS THEN
3319: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3316: x_return_status := fnd_api.g_ret_sts_unexp_error;

3312: WHEN fnd_api.g_exc_error THEN
3313: x_return_status := fnd_api.g_ret_sts_error;
3314: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3315: WHEN fnd_api.g_exc_unexpected_error THEN
3316: x_return_status := fnd_api.g_ret_sts_unexp_error;
3317: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3318: WHEN OTHERS THEN
3319: x_return_status := fnd_api.g_ret_sts_unexp_error;
3320:

Line 3319: x_return_status := fnd_api.g_ret_sts_unexp_error;

3315: WHEN fnd_api.g_exc_unexpected_error THEN
3316: x_return_status := fnd_api.g_ret_sts_unexp_error;
3317: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3318: WHEN OTHERS THEN
3319: x_return_status := fnd_api.g_ret_sts_unexp_error;
3320:
3321: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3322: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Check_Overpick');
3323: END IF;