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_RSV_SYNCH dependencies on INV_RSV_TRIGGER_GLOBAL

Line 25: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then

21: begin
22:
23: x_return_status := fnd_api.g_ret_sts_success ;
24:
25: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then
26: inv_rsv_trigger_global.g_from_trigger := TRUE;
27:
28: /*
29: ** Get sequence value for demand_id and parent_demand_id

Line 26: inv_rsv_trigger_global.g_from_trigger := TRUE;

22:
23: x_return_status := fnd_api.g_ret_sts_success ;
24:
25: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then
26: inv_rsv_trigger_global.g_from_trigger := TRUE;
27:
28: /*
29: ** Get sequence value for demand_id and parent_demand_id
30: */

Line 411: inv_rsv_trigger_global.g_from_trigger := FALSE;

407: update mtl_reservations
408: set n_column1 = l_demand_id_rsv
409: where reservation_id = p_reservation_id;
410:
411: inv_rsv_trigger_global.g_from_trigger := FALSE;
412: end if;
413:
414: exception
415: when fnd_api.g_exc_error then

Line 417: inv_rsv_trigger_global.g_from_trigger := FALSE;

413:
414: exception
415: when fnd_api.g_exc_error then
416: x_return_status := fnd_api.g_ret_sts_error ;
417: inv_rsv_trigger_global.g_from_trigger := FALSE;
418:
419: when fnd_api.g_exc_unexpected_error then
420: x_return_status := fnd_api.g_ret_sts_unexp_error ;
421: inv_rsv_trigger_global.g_from_trigger := FALSE;

Line 421: inv_rsv_trigger_global.g_from_trigger := FALSE;

417: inv_rsv_trigger_global.g_from_trigger := FALSE;
418:
419: when fnd_api.g_exc_unexpected_error then
420: x_return_status := fnd_api.g_ret_sts_unexp_error ;
421: inv_rsv_trigger_global.g_from_trigger := FALSE;
422:
423: when others then
424: x_return_status := fnd_api.g_ret_sts_unexp_error ;
425: inv_rsv_trigger_global.g_from_trigger := FALSE;

Line 425: inv_rsv_trigger_global.g_from_trigger := FALSE;

421: inv_rsv_trigger_global.g_from_trigger := FALSE;
422:
423: when others then
424: x_return_status := fnd_api.g_ret_sts_unexp_error ;
425: inv_rsv_trigger_global.g_from_trigger := FALSE;
426:
427: if (fnd_msg_pub.check_msg_level
428: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
429: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);

Line 450: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then

446: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
447: begin
448: x_return_status := fnd_api.g_ret_sts_success ;
449:
450: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then
451: inv_rsv_trigger_global.g_from_trigger := TRUE;
452:
453: select demand_source_type_id
454: into l_demand_source_type_id

Line 451: inv_rsv_trigger_global.g_from_trigger := TRUE;

447: begin
448: x_return_status := fnd_api.g_ret_sts_success ;
449:
450: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then
451: inv_rsv_trigger_global.g_from_trigger := TRUE;
452:
453: select demand_source_type_id
454: into l_demand_source_type_id
455: from mtl_reservations

Line 814: inv_rsv_trigger_global.g_from_trigger := FALSE;

810: where a.n_column1 = p_reservation_id
811: and a.reservation_type in (2,3)
812: and a.parent_demand_id is not null;
813:
814: inv_rsv_trigger_global.g_from_trigger := FALSE;
815: end if;
816:
817: exception
818: when fnd_api.g_exc_error then

Line 820: inv_rsv_trigger_global.g_from_trigger := FALSE;

816:
817: exception
818: when fnd_api.g_exc_error then
819: x_return_status := fnd_api.g_ret_sts_error ;
820: inv_rsv_trigger_global.g_from_trigger := FALSE;
821:
822: when fnd_api.g_exc_unexpected_error then
823: x_return_status := fnd_api.g_ret_sts_unexp_error ;
824: inv_rsv_trigger_global.g_from_trigger := FALSE;

Line 824: inv_rsv_trigger_global.g_from_trigger := FALSE;

820: inv_rsv_trigger_global.g_from_trigger := FALSE;
821:
822: when fnd_api.g_exc_unexpected_error then
823: x_return_status := fnd_api.g_ret_sts_unexp_error ;
824: inv_rsv_trigger_global.g_from_trigger := FALSE;
825:
826: when others then
827: x_return_status := fnd_api.g_ret_sts_unexp_error ;
828: inv_rsv_trigger_global.g_from_trigger := FALSE;

Line 828: inv_rsv_trigger_global.g_from_trigger := FALSE;

824: inv_rsv_trigger_global.g_from_trigger := FALSE;
825:
826: when others then
827: x_return_status := fnd_api.g_ret_sts_unexp_error ;
828: inv_rsv_trigger_global.g_from_trigger := FALSE;
829:
830: if (fnd_msg_pub.check_msg_level
831: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
832: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);

Line 853: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then

849: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
850: begin
851: x_return_status := fnd_api.g_ret_sts_success ;
852:
853: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then
854: inv_rsv_trigger_global.g_from_trigger := TRUE;
855:
856: select demand_source_type_id
857: into l_demand_source_type_id

Line 854: inv_rsv_trigger_global.g_from_trigger := TRUE;

850: begin
851: x_return_status := fnd_api.g_ret_sts_success ;
852:
853: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then
854: inv_rsv_trigger_global.g_from_trigger := TRUE;
855:
856: select demand_source_type_id
857: into l_demand_source_type_id
858: from mtl_reservations

Line 875: inv_rsv_trigger_global.g_from_trigger := FALSE;

871: where n_column1 = p_reservation_id
872: and reservation_type in (2,3)
873: and parent_demand_id is not null;
874:
875: inv_rsv_trigger_global.g_from_trigger := FALSE;
876: end if;
877:
878: exception
879: when fnd_api.g_exc_error then

Line 881: inv_rsv_trigger_global.g_from_trigger := FALSE;

877:
878: exception
879: when fnd_api.g_exc_error then
880: x_return_status := fnd_api.g_ret_sts_error ;
881: inv_rsv_trigger_global.g_from_trigger := FALSE;
882:
883: when fnd_api.g_exc_unexpected_error then
884: x_return_status := fnd_api.g_ret_sts_unexp_error ;
885: inv_rsv_trigger_global.g_from_trigger := FALSE;

Line 885: inv_rsv_trigger_global.g_from_trigger := FALSE;

881: inv_rsv_trigger_global.g_from_trigger := FALSE;
882:
883: when fnd_api.g_exc_unexpected_error then
884: x_return_status := fnd_api.g_ret_sts_unexp_error ;
885: inv_rsv_trigger_global.g_from_trigger := FALSE;
886:
887: when others then
888: x_return_status := fnd_api.g_ret_sts_unexp_error ;
889: inv_rsv_trigger_global.g_from_trigger := FALSE;

Line 889: inv_rsv_trigger_global.g_from_trigger := FALSE;

885: inv_rsv_trigger_global.g_from_trigger := FALSE;
886:
887: when others then
888: x_return_status := fnd_api.g_ret_sts_unexp_error ;
889: inv_rsv_trigger_global.g_from_trigger := FALSE;
890:
891: if (fnd_msg_pub.check_msg_level
892: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
893: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);

Line 918: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then

914: --inv_debug.message('tst115', 'p_reservation_id is ' || p_reservation_id);
915:
916: x_return_status := fnd_api.g_ret_sts_success ;
917:
918: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then
919: inv_rsv_trigger_global.g_from_trigger := TRUE;
920:
921: select demand_source_type_id
922: into l_demand_source_type_id

Line 919: inv_rsv_trigger_global.g_from_trigger := TRUE;

915:
916: x_return_status := fnd_api.g_ret_sts_success ;
917:
918: if (inv_rsv_trigger_global.g_from_trigger = FALSE) then
919: inv_rsv_trigger_global.g_from_trigger := TRUE;
920:
921: select demand_source_type_id
922: into l_demand_source_type_id
923: from mtl_reservations

Line 956: inv_rsv_trigger_global.g_from_trigger := FALSE;

952: when no_data_found then
953: null;
954: end;
955:
956: inv_rsv_trigger_global.g_from_trigger := FALSE;
957: end if;
958: --inv_debug.message('tst115', 'return from inv_rsv_synch.for_relieve');
959: exception
960: when fnd_api.g_exc_error then

Line 962: inv_rsv_trigger_global.g_from_trigger := FALSE;

958: --inv_debug.message('tst115', 'return from inv_rsv_synch.for_relieve');
959: exception
960: when fnd_api.g_exc_error then
961: x_return_status := fnd_api.g_ret_sts_error ;
962: inv_rsv_trigger_global.g_from_trigger := FALSE;
963:
964: when fnd_api.g_exc_unexpected_error then
965: x_return_status := fnd_api.g_ret_sts_unexp_error ;
966: inv_rsv_trigger_global.g_from_trigger := FALSE;

Line 966: inv_rsv_trigger_global.g_from_trigger := FALSE;

962: inv_rsv_trigger_global.g_from_trigger := FALSE;
963:
964: when fnd_api.g_exc_unexpected_error then
965: x_return_status := fnd_api.g_ret_sts_unexp_error ;
966: inv_rsv_trigger_global.g_from_trigger := FALSE;
967:
968: when others then
969: x_return_status := fnd_api.g_ret_sts_unexp_error ;
970: inv_rsv_trigger_global.g_from_trigger := FALSE;

Line 970: inv_rsv_trigger_global.g_from_trigger := FALSE;

966: inv_rsv_trigger_global.g_from_trigger := FALSE;
967:
968: when others then
969: x_return_status := fnd_api.g_ret_sts_unexp_error ;
970: inv_rsv_trigger_global.g_from_trigger := FALSE;
971:
972: if (fnd_msg_pub.check_msg_level
973: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
974: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);