78:
79: xla_utility_pkg.trace('< xla_seg_rules_pkg.delete_seg_rule_details' , 10);
80:
81: EXCEPTION
82: WHEN xla_exceptions_pkg.application_exception THEN
83: IF c_seg_rule_details%ISOPEN THEN
84: CLOSE c_seg_rule_details;
85: END IF;
86:
89: IF c_seg_rule_details%ISOPEN THEN
90: CLOSE c_seg_rule_details;
91: END IF;
92:
93: xla_exceptions_pkg.raise_message
94: (p_location => 'xla_seg_rules_pkg.delete_seg_rule_details');
95:
96: END delete_seg_rule_details;
97:
447:
448: xla_utility_pkg.trace('< xla_seg_rules_pkg.copy_seg_rule_details' , 10);
449:
450: EXCEPTION
451: WHEN xla_exceptions_pkg.application_exception THEN
452: IF c_detail_conditions%ISOPEN THEN
453: CLOSE c_detail_conditions;
454: END IF;
455: IF c_seg_rule_details%ISOPEN THEN
462: END IF;
463: IF c_seg_rule_details%ISOPEN THEN
464: CLOSE c_seg_rule_details;
465: END IF;
466: xla_exceptions_pkg.raise_message
467: (p_location => 'xla_seg_rules_pkg.copy_seg_rule_details');
468:
469: END copy_seg_rule_details;
470:
580: END IF;
581: CLOSE c_active_assignment_exist;
582:
583: ELSE
584: xla_exceptions_pkg.raise_message
585: ('XLA' ,'XLA_COMMON_ERROR'
586: ,'ERROR' ,'Invalid event passed'
587: ,'LOCATION' ,'xla_seg_rules_pkg.rule_in_use');
588:
595:
596: return l_return;
597:
598: EXCEPTION
599: WHEN xla_exceptions_pkg.application_exception THEN
600: IF c_assignment_exist%ISOPEN THEN
601: CLOSE c_assignment_exist;
602: END IF;
603: IF c_active_assignment_exist%ISOPEN THEN
612: IF c_active_assignment_exist%ISOPEN THEN
613: CLOSE c_active_assignment_exist;
614: END IF;
615:
616: xla_exceptions_pkg.raise_message
617: (p_location => 'xla_seg_rules_pkg.rule_in_use');
618:
619: END rule_in_use;
620:
681:
682: return l_return;
683:
684: EXCEPTION
685: WHEN xla_exceptions_pkg.application_exception THEN
686: RAISE;
687:
688: WHEN OTHERS THEN
689: xla_exceptions_pkg.raise_message
685: WHEN xla_exceptions_pkg.application_exception THEN
686: RAISE;
687:
688: WHEN OTHERS THEN
689: xla_exceptions_pkg.raise_message
690: (p_location => 'xla_seg_rules_pkg.rule_is_invalid');
691:
692: END rule_is_invalid;
693:
787:
788: return l_return;
789:
790: EXCEPTION
791: WHEN xla_exceptions_pkg.application_exception THEN
792: IF c_frozen_assignment_exist%ISOPEN THEN
793: CLOSE c_frozen_assignment_exist;
794: END IF;
795:
798: IF c_frozen_assignment_exist%ISOPEN THEN
799: CLOSE c_frozen_assignment_exist;
800: END IF;
801:
802: xla_exceptions_pkg.raise_message
803: (p_location => 'xla_seg_rules_pkg.seg_rule_is_locked');
804:
805: END seg_rule_is_locked;
806:
1016:
1017: return l_return;
1018:
1019: EXCEPTION
1020: WHEN xla_exceptions_pkg.application_exception THEN
1021: IF c_lock_aads%ISOPEN THEN
1022: CLOSE c_lock_aads;
1023: END IF;
1024: IF c_update_aads%ISOPEN THEN
1033: IF c_update_aads%ISOPEN THEN
1034: CLOSE c_update_aads;
1035: END IF;
1036:
1037: xla_exceptions_pkg.raise_message
1038: (p_location => 'xla_seg_rules_pkg.uncompile_definitions');
1039:
1040: END uncompile_definitions;
1041:
1118: END IF;
1119: CLOSE c_assignment_exist;
1120:
1121: ELSE
1122: xla_exceptions_pkg.raise_message
1123: ('XLA' ,'XLA_COMMON_ERROR'
1124: ,'ERROR' ,'Invalid event passed'
1125: ,'LOCATION' ,'xla_seg_rules_pkg.rule_in_use_by_tab');
1126:
1134:
1135: return l_return;
1136:
1137: EXCEPTION
1138: WHEN xla_exceptions_pkg.application_exception THEN
1139: IF c_assignment_exist%ISOPEN THEN
1140: CLOSE c_assignment_exist;
1141: END IF;
1142:
1145: IF c_assignment_exist%ISOPEN THEN
1146: CLOSE c_assignment_exist;
1147: END IF;
1148:
1149: xla_exceptions_pkg.raise_message
1150: (p_location => 'xla_seg_rules_pkg.rule_in_use_by_tab');
1151:
1152: END rule_in_use_by_tab;
1153:
1246:
1247: return l_return;
1248:
1249: EXCEPTION
1250: WHEN xla_exceptions_pkg.application_exception THEN
1251: IF c_trx_defs%ISOPEN THEN
1252: CLOSE c_trx_defs;
1253: END IF;
1254:
1257: IF c_trx_defs%ISOPEN THEN
1258: CLOSE c_trx_defs;
1259: END IF;
1260:
1261: xla_exceptions_pkg.raise_message
1262: (p_location => 'xla_seg_rules_pkg.uncompile_tran_acct_def');
1263:
1264: END uncompile_tran_acct_def;
1265:
1548:
1549: return l_return;
1550:
1551: EXCEPTION
1552: WHEN xla_exceptions_pkg.application_exception THEN
1553: IF c_detail_conditions%ISOPEN THEN
1554: CLOSE c_detail_conditions;
1555: END IF;
1556: IF c_seg_rule_details%ISOPEN THEN
1563: END IF;
1564: IF c_seg_rule_details%ISOPEN THEN
1565: CLOSE c_seg_rule_details;
1566: END IF;
1567: xla_exceptions_pkg.raise_message
1568: (p_location => 'xla_seg_rules_pkg.check_copy_seg_rule_details');
1569:
1570: END check_copy_seg_rule_details;
1571:
1637:
1638: return l_return;
1639:
1640: EXCEPTION
1641: WHEN xla_exceptions_pkg.application_exception THEN
1642: RAISE;
1643: WHEN OTHERS THEN
1644: xla_exceptions_pkg.raise_message
1645: (p_location => 'xla_seg_rules_pkg.rule_in_use_by_adr');
1640: EXCEPTION
1641: WHEN xla_exceptions_pkg.application_exception THEN
1642: RAISE;
1643: WHEN OTHERS THEN
1644: xla_exceptions_pkg.raise_message
1645: (p_location => 'xla_seg_rules_pkg.rule_in_use_by_adr');
1646:
1647: END rule_in_use_by_adr;
1648:
1700:
1701: return l_return;
1702:
1703: EXCEPTION
1704: WHEN xla_exceptions_pkg.application_exception THEN
1705: RAISE;
1706: WHEN OTHERS THEN
1707: xla_exceptions_pkg.raise_message
1708: (p_location => 'xla_seg_rules_pkg.parent_seg_rule_is_locked');
1703: EXCEPTION
1704: WHEN xla_exceptions_pkg.application_exception THEN
1705: RAISE;
1706: WHEN OTHERS THEN
1707: xla_exceptions_pkg.raise_message
1708: (p_location => 'xla_seg_rules_pkg.parent_seg_rule_is_locked');
1709:
1710: END parent_seg_rule_is_locked;
1711: