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_SUB_CG_UTIL dependencies on FND_API

Line 64: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

60: select count(*)
61: from mtl_material_transactions_temp mmtt
62: where mmtt.cost_group_id = v_cost_group_id;
63:
64: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
65: l_return_value boolean := FALSE;
66:
67: l_moq_count number;
68: l_mmt_count number;

Line 71: x_return_status := fnd_api.g_ret_sts_success;

67: l_moq_count number;
68: l_mmt_count number;
69: l_mmtt_count number;
70: begin
71: x_return_status := fnd_api.g_ret_sts_success;
72:
73: --
74: -- This shouldn't happen
75: --

Line 153: when fnd_api.g_exc_error THEN

149:
150: return l_return_value;
151:
152: exception
153: when fnd_api.g_exc_error THEN
154: x_return_status := fnd_api.g_ret_sts_error;
155:
156: -- Get message count and data
157: fnd_msg_pub.count_and_get

Line 154: x_return_status := fnd_api.g_ret_sts_error;

150: return l_return_value;
151:
152: exception
153: when fnd_api.g_exc_error THEN
154: x_return_status := fnd_api.g_ret_sts_error;
155:
156: -- Get message count and data
157: fnd_msg_pub.count_and_get
158: ( p_count => x_msg_count

Line 164: when fnd_api.g_exc_unexpected_error THEN

160: );
161:
162: return FALSE;
163: --
164: when fnd_api.g_exc_unexpected_error THEN
165: x_return_status := fnd_api.g_ret_sts_unexp_error ;
166:
167: -- Get message count and data
168: fnd_msg_pub.count_and_get

Line 165: x_return_status := fnd_api.g_ret_sts_unexp_error ;

161:
162: return FALSE;
163: --
164: when fnd_api.g_exc_unexpected_error THEN
165: x_return_status := fnd_api.g_ret_sts_unexp_error ;
166:
167: -- Get message count and data
168: fnd_msg_pub.count_and_get
169: ( p_count => x_msg_count

Line 176: x_return_status := fnd_api.g_ret_sts_unexp_error ;

172:
173: return FALSE;
174: --
175: when others THEN
176: x_return_status := fnd_api.g_ret_sts_unexp_error ;
177: --
178: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
179: THEN
180: fnd_msg_pub.add_exc_msg

Line 243: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

239: , p_cost_group_id IN NUMBER
240: , p_organization_id IN NUMBER) return boolean
241: is
242:
243: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
244: l_return_value boolean := FALSE;
245: l_cannot_delete VARCHAR2(1) := 'N';
246:
247: BEGIN

Line 249: x_return_status := fnd_api.g_ret_sts_success;

245: l_cannot_delete VARCHAR2(1) := 'N';
246:
247: BEGIN
248:
249: x_return_status := fnd_api.g_ret_sts_success;
250:
251: if p_cost_group_id is null then
252: return FALSE;
253: end if;

Line 411: when fnd_api.g_exc_error THEN

407: RETURN TRUE;
408: END IF;
409:
410: EXCEPTION
411: when fnd_api.g_exc_error THEN
412: x_return_status := fnd_api.g_ret_sts_error;
413:
414: -- Get message count and data
415: fnd_msg_pub.count_and_get

Line 412: x_return_status := fnd_api.g_ret_sts_error;

408: END IF;
409:
410: EXCEPTION
411: when fnd_api.g_exc_error THEN
412: x_return_status := fnd_api.g_ret_sts_error;
413:
414: -- Get message count and data
415: fnd_msg_pub.count_and_get
416: ( p_count => x_msg_count

Line 422: when fnd_api.g_exc_unexpected_error THEN

418: );
419:
420: return FALSE;
421: --
422: when fnd_api.g_exc_unexpected_error THEN
423: x_return_status := fnd_api.g_ret_sts_unexp_error ;
424:
425: -- Get message count and data
426: fnd_msg_pub.count_and_get

Line 423: x_return_status := fnd_api.g_ret_sts_unexp_error ;

419:
420: return FALSE;
421: --
422: when fnd_api.g_exc_unexpected_error THEN
423: x_return_status := fnd_api.g_ret_sts_unexp_error ;
424:
425: -- Get message count and data
426: fnd_msg_pub.count_and_get
427: ( p_count => x_msg_count

Line 434: x_return_status := fnd_api.g_ret_sts_unexp_error ;

430:
431: return FALSE;
432: --
433: when others THEN
434: x_return_status := fnd_api.g_ret_sts_unexp_error ;
435: --
436: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
437: THEN
438: fnd_msg_pub.add_exc_msg

Line 494: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

490: l_outside_processing_account number;
491: l_expense_account number;
492: l_encumbrance_account number;
493:
494: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
495: l_msg_count number;
496: l_msg_data varchar2(240);
497:
498: l_average_cost_var_account number;

Line 506: x_return_status := fnd_api.g_ret_sts_success;

502: l_payback_moh_var_account number;
503: l_payback_ovh_var_account number;
504:
505: begin
506: x_return_status := fnd_api.g_ret_sts_success;
507:
508: SAVEPOINT upd_sub_sa;
509:
510: --

Line 533: IF l_return_status = fnd_api.g_ret_sts_error THEN

529: , x_payback_ovh_var_account => l_payback_ovh_var_account
530: , p_cost_group_id => p_cost_group_id
531: , p_organization_id => p_organization_id);
532:
533: IF l_return_status = fnd_api.g_ret_sts_error THEN
534: RAISE fnd_api.g_exc_error;
535: END IF ;
536:
537: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 534: RAISE fnd_api.g_exc_error;

530: , p_cost_group_id => p_cost_group_id
531: , p_organization_id => p_organization_id);
532:
533: IF l_return_status = fnd_api.g_ret_sts_error THEN
534: RAISE fnd_api.g_exc_error;
535: END IF ;
536:
537: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
538: RAISE fnd_api.g_exc_unexpected_error;

Line 537: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

533: IF l_return_status = fnd_api.g_ret_sts_error THEN
534: RAISE fnd_api.g_exc_error;
535: END IF ;
536:
537: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
538: RAISE fnd_api.g_exc_unexpected_error;
539: END IF;
540:
541: --

Line 538: RAISE fnd_api.g_exc_unexpected_error;

534: RAISE fnd_api.g_exc_error;
535: END IF ;
536:
537: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
538: RAISE fnd_api.g_exc_unexpected_error;
539: END IF;
540:
541: --
542: -- Update the subinventory with the cost group's accounts

Line 560: WHEN fnd_api.g_exc_error THEN

556:
557: x_return_status := l_return_status;
558:
559: exception
560: WHEN fnd_api.g_exc_error THEN
561: ROLLBACK TO upd_sub_sa;
562: x_return_status := fnd_api.g_ret_sts_error;
563:
564: -- Get message count and data

Line 562: x_return_status := fnd_api.g_ret_sts_error;

558:
559: exception
560: WHEN fnd_api.g_exc_error THEN
561: ROLLBACK TO upd_sub_sa;
562: x_return_status := fnd_api.g_ret_sts_error;
563:
564: -- Get message count and data
565: fnd_msg_pub.count_and_get
566: ( p_count => x_msg_count

Line 570: WHEN fnd_api.g_exc_unexpected_error THEN

566: ( p_count => x_msg_count
567: , p_data => x_msg_data
568: );
569:
570: WHEN fnd_api.g_exc_unexpected_error THEN
571: ROLLBACK TO upd_sub_sa;
572: x_return_status := fnd_api.g_ret_sts_unexp_error ;
573:
574: -- Get message count and data

Line 572: x_return_status := fnd_api.g_ret_sts_unexp_error ;

568: );
569:
570: WHEN fnd_api.g_exc_unexpected_error THEN
571: ROLLBACK TO upd_sub_sa;
572: x_return_status := fnd_api.g_ret_sts_unexp_error ;
573:
574: -- Get message count and data
575: fnd_msg_pub.count_and_get
576: ( p_count => x_msg_count

Line 582: x_return_status := fnd_api.g_ret_sts_unexp_error ;

578: );
579:
580: WHEN OTHERS THEN
581: ROLLBACK TO upd_sub_sa;
582: x_return_status := fnd_api.g_ret_sts_unexp_error ;
583:
584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
585: THEN
586: fnd_msg_pub.add_exc_msg

Line 639: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

635: l_outside_processing_account number;
636: l_expense_account number;
637: l_encumbrance_account number;
638:
639: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
640: l_msg_count number;
641: l_msg_data varchar2(240);
642:
643: l_average_cost_var_account number;

Line 650: x_return_status := fnd_api.g_ret_sts_success;

646: l_payback_osp_var_account number;
647: l_payback_moh_var_account number;
648: l_payback_ovh_var_account number;
649: begin
650: x_return_status := fnd_api.g_ret_sts_success;
651:
652: SAVEPOINT upd_org_sa;
653:
654: --

Line 677: IF l_return_status = fnd_api.g_ret_sts_error THEN

673: , x_payback_ovh_var_account => l_payback_ovh_var_account
674: , p_cost_group_id => p_cost_group_id
675: , p_organization_id => p_organization_id);
676:
677: IF l_return_status = fnd_api.g_ret_sts_error THEN
678: RAISE fnd_api.g_exc_error;
679: END IF ;
680:
681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 678: RAISE fnd_api.g_exc_error;

674: , p_cost_group_id => p_cost_group_id
675: , p_organization_id => p_organization_id);
676:
677: IF l_return_status = fnd_api.g_ret_sts_error THEN
678: RAISE fnd_api.g_exc_error;
679: END IF ;
680:
681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
682: RAISE fnd_api.g_exc_unexpected_error;

Line 681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

677: IF l_return_status = fnd_api.g_ret_sts_error THEN
678: RAISE fnd_api.g_exc_error;
679: END IF ;
680:
681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
682: RAISE fnd_api.g_exc_unexpected_error;
683: END IF;
684:
685: --

Line 682: RAISE fnd_api.g_exc_unexpected_error;

678: RAISE fnd_api.g_exc_error;
679: END IF ;
680:
681: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
682: RAISE fnd_api.g_exc_unexpected_error;
683: END IF;
684:
685: --
686: -- Update the organization with the cost group's accounts

Line 703: WHEN fnd_api.g_exc_error THEN

699:
700: x_return_status := l_return_status;
701:
702: exception
703: WHEN fnd_api.g_exc_error THEN
704: ROLLBACK TO upd_org_sa;
705: x_return_status := fnd_api.g_ret_sts_error;
706:
707: -- Get message count and data

Line 705: x_return_status := fnd_api.g_ret_sts_error;

701:
702: exception
703: WHEN fnd_api.g_exc_error THEN
704: ROLLBACK TO upd_org_sa;
705: x_return_status := fnd_api.g_ret_sts_error;
706:
707: -- Get message count and data
708: fnd_msg_pub.count_and_get
709: ( p_count => x_msg_count

Line 713: WHEN fnd_api.g_exc_unexpected_error THEN

709: ( p_count => x_msg_count
710: , p_data => x_msg_data
711: );
712:
713: WHEN fnd_api.g_exc_unexpected_error THEN
714: ROLLBACK TO upd_org_sa;
715: x_return_status := fnd_api.g_ret_sts_unexp_error ;
716:
717: -- Get message count and data

Line 715: x_return_status := fnd_api.g_ret_sts_unexp_error ;

711: );
712:
713: WHEN fnd_api.g_exc_unexpected_error THEN
714: ROLLBACK TO upd_org_sa;
715: x_return_status := fnd_api.g_ret_sts_unexp_error ;
716:
717: -- Get message count and data
718: fnd_msg_pub.count_and_get
719: ( p_count => x_msg_count

Line 725: x_return_status := fnd_api.g_ret_sts_unexp_error ;

721: );
722:
723: WHEN OTHERS THEN
724: ROLLBACK TO upd_org_sa;
725: x_return_status := fnd_api.g_ret_sts_unexp_error ;
726:
727: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
728: THEN
729: fnd_msg_pub.add_exc_msg

Line 785: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

781: select organization_id, secondary_inventory_name
782: from mtl_secondary_inventories
783: where default_cost_group_id = p_cost_group_id;
784:
785: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
786: l_count integer := 0;
787: begin
788: x_return_status := fnd_api.g_ret_sts_success;
789:

Line 788: x_return_status := fnd_api.g_ret_sts_success;

784:
785: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
786: l_count integer := 0;
787: begin
788: x_return_status := fnd_api.g_ret_sts_success;
789:
790: for c1 in subinventory_cursor
791: loop
792: l_count := l_count + 1;

Line 799: WHEN fnd_api.g_exc_error THEN

795: end loop;
796:
797: x_count := l_count;
798: exception
799: WHEN fnd_api.g_exc_error THEN
800: x_return_status := fnd_api.g_ret_sts_error;
801: x_count := 0;
802:
803: -- Get message count and data

Line 800: x_return_status := fnd_api.g_ret_sts_error;

796:
797: x_count := l_count;
798: exception
799: WHEN fnd_api.g_exc_error THEN
800: x_return_status := fnd_api.g_ret_sts_error;
801: x_count := 0;
802:
803: -- Get message count and data
804: fnd_msg_pub.count_and_get

Line 809: WHEN fnd_api.g_exc_unexpected_error THEN

805: ( p_count => x_msg_count
806: , p_data => x_msg_data
807: );
808:
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: x_return_status := fnd_api.g_ret_sts_unexp_error ;
811: x_count := 0;
812:
813: -- Get message count and data

Line 810: x_return_status := fnd_api.g_ret_sts_unexp_error ;

806: , p_data => x_msg_data
807: );
808:
809: WHEN fnd_api.g_exc_unexpected_error THEN
810: x_return_status := fnd_api.g_ret_sts_unexp_error ;
811: x_count := 0;
812:
813: -- Get message count and data
814: fnd_msg_pub.count_and_get

Line 820: x_return_status := fnd_api.g_ret_sts_unexp_error ;

816: , p_data => x_msg_data
817: );
818:
819: WHEN OTHERS THEN
820: x_return_status := fnd_api.g_ret_sts_unexp_error ;
821: x_count := 0;
822:
823: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
824: THEN

Line 879: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

875: select organization_id
876: from mtl_parameters
877: where default_cost_group_id = p_cost_group_id;
878:
879: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
880: l_count integer := 0;
881: begin
882: x_return_status := fnd_api.g_ret_sts_success;
883:

Line 882: x_return_status := fnd_api.g_ret_sts_success;

878:
879: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
880: l_count integer := 0;
881: begin
882: x_return_status := fnd_api.g_ret_sts_success;
883:
884: for c1 in org_cursor
885: loop
886: l_count := l_count + 1;

Line 892: WHEN fnd_api.g_exc_error THEN

888: end loop;
889:
890: x_count := l_count;
891: exception
892: WHEN fnd_api.g_exc_error THEN
893: x_return_status := fnd_api.g_ret_sts_error;
894: x_count := 0;
895:
896: -- Get message count and data

Line 893: x_return_status := fnd_api.g_ret_sts_error;

889:
890: x_count := l_count;
891: exception
892: WHEN fnd_api.g_exc_error THEN
893: x_return_status := fnd_api.g_ret_sts_error;
894: x_count := 0;
895:
896: -- Get message count and data
897: fnd_msg_pub.count_and_get

Line 902: WHEN fnd_api.g_exc_unexpected_error THEN

898: ( p_count => x_msg_count
899: , p_data => x_msg_data
900: );
901:
902: WHEN fnd_api.g_exc_unexpected_error THEN
903: x_return_status := fnd_api.g_ret_sts_unexp_error ;
904: x_count := 0;
905:
906: -- Get message count and data

Line 903: x_return_status := fnd_api.g_ret_sts_unexp_error ;

899: , p_data => x_msg_data
900: );
901:
902: WHEN fnd_api.g_exc_unexpected_error THEN
903: x_return_status := fnd_api.g_ret_sts_unexp_error ;
904: x_count := 0;
905:
906: -- Get message count and data
907: fnd_msg_pub.count_and_get

Line 913: x_return_status := fnd_api.g_ret_sts_unexp_error ;

909: , p_data => x_msg_data
910: );
911:
912: WHEN OTHERS THEN
913: x_return_status := fnd_api.g_ret_sts_unexp_error ;
914: x_count := 0;
915:
916: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
917: THEN

Line 962: x_return_status := fnd_api.g_ret_sts_success;

958: , p_organization_id IN NUMBER) return number
959: is
960: l_cost_group_id number := 0;
961: begin
962: x_return_status := fnd_api.g_ret_sts_success;
963:
964: select nvl(default_cost_group_id,0)
965: into l_cost_group_id
966: from mtl_parameters

Line 971: WHEN fnd_api.g_exc_error THEN

967: where organization_id = p_organization_id;
968:
969: return l_cost_group_id;
970: exception
971: WHEN fnd_api.g_exc_error THEN
972: x_return_status := fnd_api.g_ret_sts_error;
973:
974: -- Get message count and data
975: fnd_msg_pub.count_and_get

Line 972: x_return_status := fnd_api.g_ret_sts_error;

968:
969: return l_cost_group_id;
970: exception
971: WHEN fnd_api.g_exc_error THEN
972: x_return_status := fnd_api.g_ret_sts_error;
973:
974: -- Get message count and data
975: fnd_msg_pub.count_and_get
976: ( p_count => x_msg_count

Line 982: WHEN fnd_api.g_exc_unexpected_error THEN

978: );
979:
980: return 0;
981:
982: WHEN fnd_api.g_exc_unexpected_error THEN
983: x_return_status := fnd_api.g_ret_sts_unexp_error ;
984:
985: -- Get message count and data
986: fnd_msg_pub.count_and_get

Line 983: x_return_status := fnd_api.g_ret_sts_unexp_error ;

979:
980: return 0;
981:
982: WHEN fnd_api.g_exc_unexpected_error THEN
983: x_return_status := fnd_api.g_ret_sts_unexp_error ;
984:
985: -- Get message count and data
986: fnd_msg_pub.count_and_get
987: ( p_count => x_msg_count

Line 994: x_return_status := fnd_api.g_ret_sts_unexp_error ;

990:
991: return 0;
992:
993: WHEN OTHERS THEN
994: x_return_status := fnd_api.g_ret_sts_unexp_error ;
995:
996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
997: THEN
998: fnd_msg_pub.add_exc_msg

Line 1047: x_return_status := fnd_api.g_ret_sts_success;

1043: , p_subinventory IN VARCHAR2) return number
1044: is
1045: l_cost_group_id number := 0;
1046: begin
1047: x_return_status := fnd_api.g_ret_sts_success;
1048:
1049: select nvl(default_cost_group_id,0)
1050: into l_cost_group_id
1051: from mtl_secondary_inventories

Line 1057: WHEN fnd_api.g_exc_error THEN

1053: and secondary_inventory_name = p_subinventory;
1054:
1055: return l_cost_group_id;
1056: exception
1057: WHEN fnd_api.g_exc_error THEN
1058: x_return_status := fnd_api.g_ret_sts_error;
1059:
1060: -- Get message count and data
1061: fnd_msg_pub.count_and_get

Line 1058: x_return_status := fnd_api.g_ret_sts_error;

1054:
1055: return l_cost_group_id;
1056: exception
1057: WHEN fnd_api.g_exc_error THEN
1058: x_return_status := fnd_api.g_ret_sts_error;
1059:
1060: -- Get message count and data
1061: fnd_msg_pub.count_and_get
1062: ( p_count => x_msg_count

Line 1068: WHEN fnd_api.g_exc_unexpected_error THEN

1064: );
1065:
1066: return 0;
1067:
1068: WHEN fnd_api.g_exc_unexpected_error THEN
1069: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1070:
1071: -- Get message count and data
1072: fnd_msg_pub.count_and_get

Line 1069: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1065:
1066: return 0;
1067:
1068: WHEN fnd_api.g_exc_unexpected_error THEN
1069: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1070:
1071: -- Get message count and data
1072: fnd_msg_pub.count_and_get
1073: ( p_count => x_msg_count

Line 1080: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1076:
1077: return 0;
1078:
1079: WHEN OTHERS THEN
1080: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1081:
1082: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1083: THEN
1084: fnd_msg_pub.add_exc_msg

Line 1129: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1125: , x_msg_count OUT NOCOPY NUMBER
1126: , x_msg_data OUT NOCOPY VARCHAR2
1127: , p_cost_group_id IN NUMBER)
1128: is
1129: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1130: l_msg_count number;
1131: l_msg_data varchar2(240);
1132:
1133: l_sub_tbl inv_sub_cg_util.sub_rec_tbl;

Line 1136: x_return_status := fnd_api.g_ret_sts_success;

1132:
1133: l_sub_tbl inv_sub_cg_util.sub_rec_tbl;
1134: l_count number;
1135: begin
1136: x_return_status := fnd_api.g_ret_sts_success;
1137:
1138: SAVEPOINT upd_subs_accs_sa;
1139:
1140: --

Line 1152: IF l_return_status = fnd_api.g_ret_sts_error THEN

1148: , x_sub_tbl => l_sub_tbl
1149: , x_count => l_count
1150: , p_cost_group_id => p_cost_group_id);
1151:
1152: IF l_return_status = fnd_api.g_ret_sts_error THEN
1153: RAISE fnd_api.g_exc_error;
1154: END IF ;
1155:
1156: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1153: RAISE fnd_api.g_exc_error;

1149: , x_count => l_count
1150: , p_cost_group_id => p_cost_group_id);
1151:
1152: IF l_return_status = fnd_api.g_ret_sts_error THEN
1153: RAISE fnd_api.g_exc_error;
1154: END IF ;
1155:
1156: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1157: RAISE fnd_api.g_exc_unexpected_error;

Line 1156: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1152: IF l_return_status = fnd_api.g_ret_sts_error THEN
1153: RAISE fnd_api.g_exc_error;
1154: END IF ;
1155:
1156: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1157: RAISE fnd_api.g_exc_unexpected_error;
1158: END IF;
1159:
1160: if (l_count > 0) then

Line 1157: RAISE fnd_api.g_exc_unexpected_error;

1153: RAISE fnd_api.g_exc_error;
1154: END IF ;
1155:
1156: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1157: RAISE fnd_api.g_exc_unexpected_error;
1158: END IF;
1159:
1160: if (l_count > 0) then
1161: for i in 1..l_count loop

Line 1174: IF l_return_status = fnd_api.g_ret_sts_error THEN

1170: , p_cost_group_id => p_cost_group_id
1171: , p_organization_id => l_sub_tbl(i).organization_id
1172: , p_subinventory => l_sub_tbl(i).subinventory);
1173:
1174: IF l_return_status = fnd_api.g_ret_sts_error THEN
1175: RAISE fnd_api.g_exc_error;
1176: END IF ;
1177:
1178: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1175: RAISE fnd_api.g_exc_error;

1171: , p_organization_id => l_sub_tbl(i).organization_id
1172: , p_subinventory => l_sub_tbl(i).subinventory);
1173:
1174: IF l_return_status = fnd_api.g_ret_sts_error THEN
1175: RAISE fnd_api.g_exc_error;
1176: END IF ;
1177:
1178: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1179: RAISE fnd_api.g_exc_unexpected_error;

Line 1178: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1174: IF l_return_status = fnd_api.g_ret_sts_error THEN
1175: RAISE fnd_api.g_exc_error;
1176: END IF ;
1177:
1178: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1179: RAISE fnd_api.g_exc_unexpected_error;
1180: END IF;
1181: end loop;
1182: end if;

Line 1179: RAISE fnd_api.g_exc_unexpected_error;

1175: RAISE fnd_api.g_exc_error;
1176: END IF ;
1177:
1178: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1179: RAISE fnd_api.g_exc_unexpected_error;
1180: END IF;
1181: end loop;
1182: end if;
1183:

Line 1186: WHEN fnd_api.g_exc_error THEN

1182: end if;
1183:
1184: x_return_status := l_return_status;
1185: exception
1186: WHEN fnd_api.g_exc_error THEN
1187: ROLLBACK to upd_subs_accs_sa;
1188: x_return_status := fnd_api.g_ret_sts_error;
1189:
1190: -- Get message count and data

Line 1188: x_return_status := fnd_api.g_ret_sts_error;

1184: x_return_status := l_return_status;
1185: exception
1186: WHEN fnd_api.g_exc_error THEN
1187: ROLLBACK to upd_subs_accs_sa;
1188: x_return_status := fnd_api.g_ret_sts_error;
1189:
1190: -- Get message count and data
1191: fnd_msg_pub.count_and_get
1192: ( p_count => x_msg_count

Line 1196: WHEN fnd_api.g_exc_unexpected_error THEN

1192: ( p_count => x_msg_count
1193: , p_data => x_msg_data
1194: );
1195:
1196: WHEN fnd_api.g_exc_unexpected_error THEN
1197: ROLLBACK to upd_subs_accs_sa;
1198: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1199:
1200: -- Get message count and data

Line 1198: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1194: );
1195:
1196: WHEN fnd_api.g_exc_unexpected_error THEN
1197: ROLLBACK to upd_subs_accs_sa;
1198: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1199:
1200: -- Get message count and data
1201: fnd_msg_pub.count_and_get
1202: ( p_count => x_msg_count

Line 1208: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1204: );
1205:
1206: WHEN OTHERS THEN
1207: ROLLBACK to upd_subs_accs_sa;
1208: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1209:
1210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1211: THEN
1212: fnd_msg_pub.add_exc_msg

Line 1255: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1251: , x_msg_count OUT NOCOPY NUMBER
1252: , x_msg_data OUT NOCOPY VARCHAR2
1253: , p_cost_group_id IN NUMBER)
1254: is
1255: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1256: l_msg_count number;
1257: l_msg_data varchar2(240);
1258:
1259: l_org_tbl inv_sub_cg_util.org_rec_tbl;

Line 1262: x_return_status := fnd_api.g_ret_sts_success;

1258:
1259: l_org_tbl inv_sub_cg_util.org_rec_tbl;
1260: l_count number;
1261: begin
1262: x_return_status := fnd_api.g_ret_sts_success;
1263:
1264: SAVEPOINT upd_orgs_accs_sa;
1265:
1266: --

Line 1278: IF l_return_status = fnd_api.g_ret_sts_error THEN

1274: , x_org_tbl => l_org_tbl
1275: , x_count => l_count
1276: , p_cost_group_id => p_cost_group_id);
1277:
1278: IF l_return_status = fnd_api.g_ret_sts_error THEN
1279: RAISE fnd_api.g_exc_error;
1280: END IF ;
1281:
1282: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1279: RAISE fnd_api.g_exc_error;

1275: , x_count => l_count
1276: , p_cost_group_id => p_cost_group_id);
1277:
1278: IF l_return_status = fnd_api.g_ret_sts_error THEN
1279: RAISE fnd_api.g_exc_error;
1280: END IF ;
1281:
1282: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1283: RAISE fnd_api.g_exc_unexpected_error;

Line 1282: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1278: IF l_return_status = fnd_api.g_ret_sts_error THEN
1279: RAISE fnd_api.g_exc_error;
1280: END IF ;
1281:
1282: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1283: RAISE fnd_api.g_exc_unexpected_error;
1284: END IF;
1285:
1286: if (l_count > 0) then

Line 1283: RAISE fnd_api.g_exc_unexpected_error;

1279: RAISE fnd_api.g_exc_error;
1280: END IF ;
1281:
1282: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1283: RAISE fnd_api.g_exc_unexpected_error;
1284: END IF;
1285:
1286: if (l_count > 0) then
1287: for i in 1..l_count loop

Line 1299: IF l_return_status = fnd_api.g_ret_sts_error THEN

1295: , x_msg_data => l_msg_data
1296: , p_cost_group_id => p_cost_group_id
1297: , p_organization_id => l_org_tbl(i).organization_id);
1298:
1299: IF l_return_status = fnd_api.g_ret_sts_error THEN
1300: RAISE fnd_api.g_exc_error;
1301: END IF ;
1302:
1303: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1300: RAISE fnd_api.g_exc_error;

1296: , p_cost_group_id => p_cost_group_id
1297: , p_organization_id => l_org_tbl(i).organization_id);
1298:
1299: IF l_return_status = fnd_api.g_ret_sts_error THEN
1300: RAISE fnd_api.g_exc_error;
1301: END IF ;
1302:
1303: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1304: RAISE fnd_api.g_exc_unexpected_error;

Line 1303: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1299: IF l_return_status = fnd_api.g_ret_sts_error THEN
1300: RAISE fnd_api.g_exc_error;
1301: END IF ;
1302:
1303: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1304: RAISE fnd_api.g_exc_unexpected_error;
1305: END IF;
1306: end loop;
1307: end if;

Line 1304: RAISE fnd_api.g_exc_unexpected_error;

1300: RAISE fnd_api.g_exc_error;
1301: END IF ;
1302:
1303: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1304: RAISE fnd_api.g_exc_unexpected_error;
1305: END IF;
1306: end loop;
1307: end if;
1308:

Line 1311: WHEN fnd_api.g_exc_error THEN

1307: end if;
1308:
1309: x_return_status := l_return_status;
1310: exception
1311: WHEN fnd_api.g_exc_error THEN
1312: ROLLBACK to upd_orgs_accs_sa;
1313: x_return_status := fnd_api.g_ret_sts_error;
1314:
1315: -- Get message count and data

Line 1313: x_return_status := fnd_api.g_ret_sts_error;

1309: x_return_status := l_return_status;
1310: exception
1311: WHEN fnd_api.g_exc_error THEN
1312: ROLLBACK to upd_orgs_accs_sa;
1313: x_return_status := fnd_api.g_ret_sts_error;
1314:
1315: -- Get message count and data
1316: fnd_msg_pub.count_and_get
1317: ( p_count => x_msg_count

Line 1321: WHEN fnd_api.g_exc_unexpected_error THEN

1317: ( p_count => x_msg_count
1318: , p_data => x_msg_data
1319: );
1320:
1321: WHEN fnd_api.g_exc_unexpected_error THEN
1322: ROLLBACK to upd_orgs_accs_sa;
1323: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1324:
1325: -- Get message count and data

Line 1323: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1319: );
1320:
1321: WHEN fnd_api.g_exc_unexpected_error THEN
1322: ROLLBACK to upd_orgs_accs_sa;
1323: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1324:
1325: -- Get message count and data
1326: fnd_msg_pub.count_and_get
1327: ( p_count => x_msg_count

Line 1333: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1329: );
1330:
1331: WHEN OTHERS THEN
1332: ROLLBACK to upd_orgs_accs_sa;
1333: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1334:
1335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1336: THEN
1337: fnd_msg_pub.add_exc_msg