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.WMS_RULE_EXTN_PVT dependencies on FND_API

Line 169: --,p_init_msg_list => fnd_api.g_false

165:
166: INV_Quantity_Tree_PVT.Create_Tree
167: (
168: p_api_version_number => 1.0
169: --,p_init_msg_list => fnd_api.g_false
170: ,x_return_status => x_return_status
171: ,x_msg_count => x_msg_count
172: ,x_msg_data => x_msg_data
173: ,p_organization_id => p_organization_id

Line 212: x_return_status := fnd_api.g_ret_sts_unexp_error;

208: when others then
209: if iteminfo%isopen then
210: close iteminfo;
211: end if;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
214: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
215: end if;
216: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 377: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

373: SAVEPOINT suggest_reservations_sa;
374:
375: --
376: -- Standard Call to check for call compatibility
377: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
378: RAISE fnd_api.g_exc_unexpected_error;
379: END IF;
380:
381: --

Line 378: RAISE fnd_api.g_exc_unexpected_error;

374:
375: --
376: -- Standard Call to check for call compatibility
377: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
378: RAISE fnd_api.g_exc_unexpected_error;
379: END IF;
380:
381: --
382: -- Initialize message list if p_init_msg_list is set to true

Line 383: IF fnd_api.to_boolean(p_init_msg_list) THEN

379: END IF;
380:
381: --
382: -- Initialize message list if p_init_msg_list is set to true
383: IF fnd_api.to_boolean(p_init_msg_list) THEN
384: fnd_msg_pub.initialize;
385: END IF;
386:
387: log_procedure(l_api_name, 'start', 'Start suggest_reservations');

Line 390: x_return_status := fnd_api.g_ret_sts_success;

386:
387: log_procedure(l_api_name, 'start', 'Start suggest_reservations');
388: --
389: -- Initialisize API return status to access
390: x_return_status := fnd_api.g_ret_sts_success;
391: --
392:
393: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id,
394: p_mo_line_rec.inventory_item_id);

Line 402: RAISE fnd_api.g_exc_error;

398: IF (l_debug = 1) THEN
399: log_error(l_api_name, 'Process_Reservations','Error - Item is not reservable');
400: END IF;
401:
402: RAISE fnd_api.g_exc_error;
403: END IF;
404:
405: /* Set Demand Info Record */
406: l_demand_info.oe_line_id := p_demand_source_line_id;

Line 426: IF x_return_status <> fnd_api.g_ret_sts_success THEN

422: ,x_rsv_qty2_available => l_rsv_qty2_available);
423:
424:
425: -- Return an error if the query reservations call failed
426: IF x_return_status <> fnd_api.g_ret_sts_success THEN
427: IF ( l_debug = 1 ) THEN
428: log_error(l_api_name, 'Suggest Reservations', 'l_return_status = '|| x_return_status);
429: log_error(l_api_name, 'Suggest Reservations', 'Process Reservations Failed ' || x_msg_data);
430: END IF;

Line 431: RAISE fnd_api.g_exc_unexpected_error;

427: IF ( l_debug = 1 ) THEN
428: log_error(l_api_name, 'Suggest Reservations', 'l_return_status = '|| x_return_status);
429: log_error(l_api_name, 'Suggest Reservations', 'Process Reservations Failed ' || x_msg_data);
430: END IF;
431: RAISE fnd_api.g_exc_unexpected_error;
432: END IF;
433: /* Place reservation IDs into a table for easy access when creating new reservations */
434: IF l_demand_rsvs_ordered.count > 0 THEN
435: log_event(l_api_name, 'Suggest Reservations','# Reservations returned from Process Reservation : ' || l_demand_rsvs_ordered.count);

Line 447: , p_init_msg_list => fnd_api.g_true

443:
444: /* Call create suggestions */
445: wms_engine_pvt.create_suggestions(
446: p_api_version => 1.0
447: , p_init_msg_list => fnd_api.g_true
448: , p_commit => fnd_api.g_false
449: , p_validation_level => NULL
450: , x_return_status => x_return_status
451: , x_msg_count => x_msg_count

Line 448: , p_commit => fnd_api.g_false

444: /* Call create suggestions */
445: wms_engine_pvt.create_suggestions(
446: p_api_version => 1.0
447: , p_init_msg_list => fnd_api.g_true
448: , p_commit => fnd_api.g_false
449: , p_validation_level => NULL
450: , x_return_status => x_return_status
451: , x_msg_count => x_msg_count
452: , x_msg_data => x_msg_data

Line 461: IF x_return_status <> fnd_api.g_ret_sts_success THEN

457: , p_simulation_id => NULL
458: , p_plan_tasks => FALSE
459: , p_quick_pick_flag => 'N'
460: );
461: IF x_return_status <> fnd_api.g_ret_sts_success THEN
462: IF ( l_debug = 1 ) THEN
463: log_error(l_api_name, 'Suggest Reservations', 'l_return_status = '|| x_return_status);
464: log_error(l_api_name, 'Suggest Reservations', 'Detailing Failed ');
465: END IF;

Line 493: RAISE fnd_api.g_exc_unexpected_error;

489: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
490: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
491: fnd_msg_pub.ADD;
492: x_msg_count := 1;
493: RAISE fnd_api.g_exc_unexpected_error;
494: END IF;
495:
496: l_suggested_serials := l_dummy_sn;
497: l_requirement_date := nvl(p_requirement_date, sysdate);

Line 516: if x_return_status = fnd_api.g_ret_sts_unexp_error then

512: ,p_demand_source_name
513: ,INV_Quantity_Tree_PVT.g_transaction_mode
514: ,l_tree_id
515: );
516: if x_return_status = fnd_api.g_ret_sts_unexp_error then
517: raise fnd_api.g_exc_unexpected_error;
518: elsif x_return_status = fnd_api.g_ret_sts_error then
519: raise fnd_api.g_exc_error;
520: end if;

Line 517: raise fnd_api.g_exc_unexpected_error;

513: ,INV_Quantity_Tree_PVT.g_transaction_mode
514: ,l_tree_id
515: );
516: if x_return_status = fnd_api.g_ret_sts_unexp_error then
517: raise fnd_api.g_exc_unexpected_error;
518: elsif x_return_status = fnd_api.g_ret_sts_error then
519: raise fnd_api.g_exc_error;
520: end if;
521: first_pass := FALSE;

Line 518: elsif x_return_status = fnd_api.g_ret_sts_error then

514: ,l_tree_id
515: );
516: if x_return_status = fnd_api.g_ret_sts_unexp_error then
517: raise fnd_api.g_exc_unexpected_error;
518: elsif x_return_status = fnd_api.g_ret_sts_error then
519: raise fnd_api.g_exc_error;
520: end if;
521: first_pass := FALSE;
522: END IF;

Line 519: raise fnd_api.g_exc_error;

515: );
516: if x_return_status = fnd_api.g_ret_sts_unexp_error then
517: raise fnd_api.g_exc_unexpected_error;
518: elsif x_return_status = fnd_api.g_ret_sts_error then
519: raise fnd_api.g_exc_error;
520: end if;
521: first_pass := FALSE;
522: END IF;
523:

Line 532: , p_init_msg_lst => fnd_api.g_false

528:
529: inv_quantity_tree_pvt.update_quantities
530: (
531: p_api_version_number => 1.0
532: , p_init_msg_lst => fnd_api.g_false
533: , x_return_status => x_return_status
534: , x_msg_count => x_msg_count
535: , x_msg_data => x_msg_data
536: , p_tree_id => l_tree_id

Line 561: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

557: , p_cost_group_id => null
558: , p_lpn_id => l_grp_sugg_rec.lpn_id
559: );
560:
561: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
562: IF l_debug = 1 THEN
563: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
564: END IF;
565:

Line 566: RAISE fnd_api.g_exc_unexpected_error;

562: IF l_debug = 1 THEN
563: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
564: END IF;
565:
566: RAISE fnd_api.g_exc_unexpected_error;
567: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
568: IF l_debug = 1 THEN
569: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
570: END IF;

Line 567: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

563: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
564: END IF;
565:
566: RAISE fnd_api.g_exc_unexpected_error;
567: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
568: IF l_debug = 1 THEN
569: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
570: END IF;
571: RAISE fnd_api.g_exc_error;

Line 571: RAISE fnd_api.g_exc_error;

567: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
568: IF l_debug = 1 THEN
569: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
570: END IF;
571: RAISE fnd_api.g_exc_error;
572: END IF;
573:
574: /* Get Original reservation for which these grouped suggestions were created */
575: -- {{ Test Case # UTK- REALLOC

Line 658: , p_init_msg_lst => fnd_api.g_true

654: l_new_reservation.reservation_id := NULL;
655:
656: inv_reservation_pvt.Transfer_Reservation (
657: p_api_version_number => 1.0
658: , p_init_msg_lst => fnd_api.g_true
659: , x_return_status => x_return_status
660: , x_msg_count => x_msg_count
661: , x_msg_data => x_msg_data
662: , p_original_rsv_rec => l_orig_reservation

Line 665: , p_validation_flag => fnd_api.g_false

661: , x_msg_data => x_msg_data
662: , p_original_rsv_rec => l_orig_reservation
663: , p_to_rsv_rec => l_new_reservation
664: , p_original_serial_number => l_dummy_sn
665: , p_validation_flag => fnd_api.g_false
666: , x_reservation_id => l_new_reservation_id
667: );
668:
669: -- Bug 6719290 Return an error if the transfer reservation call failed

Line 670: IF x_return_status = fnd_api.g_ret_sts_error THEN

666: , x_reservation_id => l_new_reservation_id
667: );
668:
669: -- Bug 6719290 Return an error if the transfer reservation call failed
670: IF x_return_status = fnd_api.g_ret_sts_error THEN
671: IF (l_debug = 1) THEN
672: log_error(l_api_name, 'Suggest_Reservations','expected error in transfer reservation');
673: END IF;
674: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

Line 676: RAISE fnd_api.g_exc_error;

672: log_error(l_api_name, 'Suggest_Reservations','expected error in transfer reservation');
673: END IF;
674: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
675: fnd_msg_pub.ADD;
676: RAISE fnd_api.g_exc_error;
677: END IF;
678:
679: -- Return an error if the transfer reservation call failed
680: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 680: IF x_return_status <> fnd_api.g_ret_sts_success THEN

676: RAISE fnd_api.g_exc_error;
677: END IF;
678:
679: -- Return an error if the transfer reservation call failed
680: IF x_return_status <> fnd_api.g_ret_sts_success THEN
681: IF (l_debug = 1) THEN
682: log_error(l_api_name, 'Suggest_Reservations','error in transfer reservation');
683: END IF;
684: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

Line 686: RAISE fnd_api.g_exc_unexpected_error;

682: log_error(l_api_name, 'Suggest_Reservations','error in transfer reservation');
683: END IF;
684: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
685: fnd_msg_pub.ADD;
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688: IF l_debug = 1 THEN
689: log_event(l_api_name, 'Suggest Reservations', 'After calling transfer from ' || l_orig_reservation.reservation_id || ' to ' || l_new_reservation_id);
690: END IF;

Line 704: , p_init_msg_lst => fnd_api.g_false

700: l_new_reservation.secondary_reservation_quantity := l_last_reservation.secondary_reservation_quantity + l_new_reservation.secondary_reservation_quantity;
701:
702: inv_reservation_pvt.update_reservation(
703: p_api_version_number => 1.0
704: , p_init_msg_lst => fnd_api.g_false
705: , x_return_status => x_return_status
706: , x_msg_count => x_msg_count
707: , x_msg_data => x_msg_data
708: , p_original_rsv_rec => l_last_reservation

Line 713: , p_check_availability => fnd_api.g_false

709: , p_to_rsv_rec => l_new_reservation
710: , p_original_serial_number => l_dummy_sn
711: , p_to_serial_number => l_reserved_serials
712: , p_validation_flag => 'Q'
713: , p_check_availability => fnd_api.g_false
714: );
715:
716:
717: -- Return an error if the update reservation call failed

Line 718: IF x_return_status <> fnd_api.g_ret_sts_success THEN

714: );
715:
716:
717: -- Return an error if the update reservation call failed
718: IF x_return_status <> fnd_api.g_ret_sts_success THEN
719: IF (l_debug = 1) THEN
720: log_error(l_api_name, 'Suggest_Reservations','error in update reservation');
721: END IF;
722: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

Line 724: RAISE fnd_api.g_exc_unexpected_error;

720: log_error(l_api_name, 'Suggest_Reservations','error in update reservation');
721: END IF;
722: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
723: fnd_msg_pub.ADD;
724: RAISE fnd_api.g_exc_unexpected_error;
725: END IF;
726:
727: ELSE -- reservtion ID is null
728: /* Create new reservation and set as current reservation */

Line 771: , p_init_msg_lst => fnd_api.g_false

767: l_new_reservation.detailed_quantity := 0;
768:
769: inv_reservation_pub.create_reservation(
770: p_api_version_number => 1.0
771: , p_init_msg_lst => fnd_api.g_false
772: , x_return_status => x_return_status
773: , x_msg_count => x_msg_count
774: , x_msg_data => x_msg_data
775: , p_rsv_rec => l_new_reservation

Line 778: , p_partial_reservation_flag => fnd_api.g_true

774: , x_msg_data => x_msg_data
775: , p_rsv_rec => l_new_reservation
776: , p_serial_number => l_suggested_serials
777: , x_serial_number => l_reserved_serials
778: , p_partial_reservation_flag => fnd_api.g_true
779: , p_force_reservation_flag => fnd_api.g_false
780: , p_validation_flag => 'Q'
781: , x_quantity_reserved => l_qty_succ_reserved
782: , x_reservation_id => l_new_reservation_id

Line 779: , p_force_reservation_flag => fnd_api.g_false

775: , p_rsv_rec => l_new_reservation
776: , p_serial_number => l_suggested_serials
777: , x_serial_number => l_reserved_serials
778: , p_partial_reservation_flag => fnd_api.g_true
779: , p_force_reservation_flag => fnd_api.g_false
780: , p_validation_flag => 'Q'
781: , x_quantity_reserved => l_qty_succ_reserved
782: , x_reservation_id => l_new_reservation_id
783: );

Line 790: IF x_return_status <> fnd_api.g_ret_sts_success THEN

786: log_event(l_api_name, 'Suggest Reservations', 'After creating the reservations: status =' || x_return_status);
787: log_event(l_api_name, 'Suggest Reservations', 'After creating the reservations: Reservation ID =' || l_new_reservation_id);
788: END IF;
789: -- Return an error if the create reservation call failed
790: IF x_return_status <> fnd_api.g_ret_sts_success THEN
791: IF (l_debug = 1) THEN
792: log_error(l_api_name, 'Process_Reservations','error in create reservation');
793: END IF;
794: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

Line 796: RAISE fnd_api.g_exc_unexpected_error;

792: log_error(l_api_name, 'Process_Reservations','error in create reservation');
793: END IF;
794: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_unexpected_error;
797: END IF;
798: END IF;
799: END LOOP;
800:

Line 826: WHEN fnd_api.g_exc_error THEN

822: , p_suggestions.secondary_quantity;
823: CLOSE c_suggestions;
824:
825: EXCEPTION
826: WHEN fnd_api.g_exc_error THEN
827: --ROLLBACK TO suggest_reservations_sa;
828: x_return_status := fnd_api.g_ret_sts_error;
829: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
830: IF l_debug = 1 THEN

Line 828: x_return_status := fnd_api.g_ret_sts_error;

824:
825: EXCEPTION
826: WHEN fnd_api.g_exc_error THEN
827: --ROLLBACK TO suggest_reservations_sa;
828: x_return_status := fnd_api.g_ret_sts_error;
829: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
830: IF l_debug = 1 THEN
831: log_error(l_api_name, 'error', 'Error in suggest_reservations - ' || x_msg_data);
832: END IF ;

Line 834: WHEN fnd_api.g_exc_unexpected_error THEN

830: IF l_debug = 1 THEN
831: log_error(l_api_name, 'error', 'Error in suggest_reservations - ' || x_msg_data);
832: END IF ;
833: --
834: WHEN fnd_api.g_exc_unexpected_error THEN
835: --ROLLBACK TO suggest_reservations_sa;
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
838: IF l_debug = 1 THEN

Line 836: x_return_status := fnd_api.g_ret_sts_unexp_error;

832: END IF ;
833: --
834: WHEN fnd_api.g_exc_unexpected_error THEN
835: --ROLLBACK TO suggest_reservations_sa;
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
838: IF l_debug = 1 THEN
839: log_error(l_api_name, 'unexp_error', 'Unexpected error ' || 'in suggest_reservations - ' || x_msg_data);
840: END IF;

Line 844: x_return_status := fnd_api.g_ret_sts_unexp_error;

840: END IF;
841: --
842: WHEN OTHERS THEN
843: ROLLBACK TO suggest_reservations_sa;
844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
847: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
848: END IF;