DBA Data[Home] [Help]

APPS.INV_RSV_SYNCH dependencies on FND_API

Line 23: x_return_status := fnd_api.g_ret_sts_success ;

19:
20: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
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:

Line 415: when fnd_api.g_exc_error then

411: inv_rsv_trigger_global.g_from_trigger := FALSE;
412: end if;
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

Line 416: x_return_status := fnd_api.g_ret_sts_error ;

412: end if;
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 ;

Line 419: when fnd_api.g_exc_unexpected_error then

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;
422:
423: when others then

Line 420: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;
422:
423: when others then
424: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 424: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;
426:
427: if (fnd_msg_pub.check_msg_level
428: (fnd_msg_pub.g_msg_lvl_unexp_error)) then

Line 448: x_return_status := fnd_api.g_ret_sts_success ;

444: l_demand_source_type_id number;
445:
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:

Line 818: when fnd_api.g_exc_error then

814: inv_rsv_trigger_global.g_from_trigger := FALSE;
815: end if;
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

Line 819: x_return_status := fnd_api.g_ret_sts_error ;

815: end if;
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 ;

Line 822: when fnd_api.g_exc_unexpected_error then

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;
825:
826: when others then

Line 823: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;
825:
826: when others then
827: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 827: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;
829:
830: if (fnd_msg_pub.check_msg_level
831: (fnd_msg_pub.g_msg_lvl_unexp_error)) then

Line 851: x_return_status := fnd_api.g_ret_sts_success ;

847: l_demand_source_type_id number;
848:
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:

Line 879: when fnd_api.g_exc_error then

875: inv_rsv_trigger_global.g_from_trigger := FALSE;
876: end if;
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

Line 880: x_return_status := fnd_api.g_ret_sts_error ;

876: end if;
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 ;

Line 883: when fnd_api.g_exc_unexpected_error then

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;
886:
887: when others then

Line 884: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;
886:
887: when others then
888: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 888: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;
890:
891: if (fnd_msg_pub.check_msg_level
892: (fnd_msg_pub.g_msg_lvl_unexp_error)) then

Line 916: x_return_status := fnd_api.g_ret_sts_success ;

912: begin
913: --inv_debug.message('tst115', 'in for_relieve');
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:

Line 960: when fnd_api.g_exc_error then

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
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

Line 961: x_return_status := fnd_api.g_ret_sts_error ;

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
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 ;

Line 964: when fnd_api.g_exc_unexpected_error then

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;
967:
968: when others then

Line 965: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;
967:
968: when others then
969: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 969: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;
971:
972: if (fnd_msg_pub.check_msg_level
973: (fnd_msg_pub.g_msg_lvl_unexp_error)) then