92:
93: return l_return;
94:
95: EXCEPTION
96: WHEN xla_exceptions_pkg.application_exception THEN
97: RAISE;
98:
99: WHEN OTHERS THEN
100:
97: RAISE;
98:
99: WHEN OTHERS THEN
100:
101: xla_exceptions_pkg.raise_message
102: (p_location => 'xla_product_rules_pkg.is_accounting_reversal');
103:
104: END is_accounting_reversal;
105:
255:
256: return l_return;
257:
258: EXCEPTION
259: WHEN xla_exceptions_pkg.application_exception THEN
260: RAISE;
261:
262: WHEN OTHERS THEN
263:
260: RAISE;
261:
262: WHEN OTHERS THEN
263:
264: xla_exceptions_pkg.raise_message
265: (p_location => 'xla_product_rules_pkg.invalid_hdr_ac');
266:
267: END invalid_hdr_ac;
268:
493:
494: return l_return;
495:
496: EXCEPTION
497: WHEN xla_exceptions_pkg.application_exception THEN
498: IF c_desc_condition_sources%ISOPEN THEN
499: CLOSE c_desc_condition_sources;
500: END IF;
501: IF c_desc_detail_sources%ISOPEN THEN
510: IF c_desc_detail_sources%ISOPEN THEN
511: CLOSE c_desc_detail_sources;
512: END IF;
513:
514: xla_exceptions_pkg.raise_message
515: (p_location => 'xla_product_rules_pkg.invalid_header_desc');
516:
517: END invalid_header_desc;
518:
571:
572: xla_utility_pkg.trace('< xla_product_rules_pkg.delete_product_rule_details' , 10);
573:
574: EXCEPTION
575: WHEN xla_exceptions_pkg.application_exception THEN
576: RAISE;
577: WHEN OTHERS THEN
578: xla_exceptions_pkg.raise_message
579: (p_location => 'xla_product_rules_pkg.delete_product_rule_details');
574: EXCEPTION
575: WHEN xla_exceptions_pkg.application_exception THEN
576: RAISE;
577: WHEN OTHERS THEN
578: xla_exceptions_pkg.raise_message
579: (p_location => 'xla_product_rules_pkg.delete_product_rule_details');
580:
581: END delete_product_rule_details;
582:
636:
637: xla_utility_pkg.trace('< xla_product_rules_pkg.delete_prod_header_details' , 10);
638:
639: EXCEPTION
640: WHEN xla_exceptions_pkg.application_exception THEN
641: RAISE;
642: WHEN OTHERS THEN
643: xla_exceptions_pkg.raise_message
644: (p_location => 'xla_product_rules_pkg.delete_prod_header_details');
639: EXCEPTION
640: WHEN xla_exceptions_pkg.application_exception THEN
641: RAISE;
642: WHEN OTHERS THEN
643: xla_exceptions_pkg.raise_message
644: (p_location => 'xla_product_rules_pkg.delete_prod_header_details');
645:
646: END delete_prod_header_details;
647:
846:
847: xla_utility_pkg.trace('< xla_product_rules_pkg.copy_product_rule_details' , 10);
848:
849: EXCEPTION
850: WHEN xla_exceptions_pkg.application_exception THEN
851: RAISE;
852:
853: WHEN OTHERS THEN
854: xla_exceptions_pkg.raise_message
850: WHEN xla_exceptions_pkg.application_exception THEN
851: RAISE;
852:
853: WHEN OTHERS THEN
854: xla_exceptions_pkg.raise_message
855: (p_location => 'xla_product_rules_pkg.copy_product_rule_details');
856:
857: END copy_product_rule_details;
858:
920: END IF;
921: CLOSE c_assignment_exist;
922:
923: ELSE
924: xla_exceptions_pkg.raise_message
925: ('XLA' ,'XLA_COMMON_ERROR'
926: ,'ERROR' ,'Invalid event passed'
927: ,'LOCATION' ,'xla_product_rules_pkg.product_rule_in_use');
928:
935:
936: return l_return;
937:
938: EXCEPTION
939: WHEN xla_exceptions_pkg.application_exception THEN
940: IF c_assignment_exist%ISOPEN THEN
941: CLOSE c_assignment_exist;
942: END IF;
943:
946: IF c_assignment_exist%ISOPEN THEN
947: CLOSE c_assignment_exist;
948: END IF;
949:
950: xla_exceptions_pkg.raise_message
951: (p_location => 'xla_product_rules_pkg.product_rule_in_use');
952:
953: END product_rule_in_use;
954:
1022:
1023: return l_return;
1024:
1025: EXCEPTION
1026: WHEN xla_exceptions_pkg.application_exception THEN
1027: RAISE;
1028:
1029: WHEN OTHERS THEN
1030: xla_exceptions_pkg.raise_message
1026: WHEN xla_exceptions_pkg.application_exception THEN
1027: RAISE;
1028:
1029: WHEN OTHERS THEN
1030: xla_exceptions_pkg.raise_message
1031: (p_location => 'xla_product_rules_pkg.invalid_header_description');
1032:
1033: END invalid_header_description;
1034:
1091:
1092: return l_return;
1093:
1094: EXCEPTION
1095: WHEN xla_exceptions_pkg.application_exception THEN
1096: RAISE;
1097: WHEN OTHERS THEN
1098: xla_exceptions_pkg.raise_message
1099: (p_location => 'xla_product_rules_pkg.uncompile_product_rule');
1094: EXCEPTION
1095: WHEN xla_exceptions_pkg.application_exception THEN
1096: RAISE;
1097: WHEN OTHERS THEN
1098: xla_exceptions_pkg.raise_message
1099: (p_location => 'xla_product_rules_pkg.uncompile_product_rule');
1100:
1101: END uncompile_product_rule;
1102:
1159:
1160: return l_return;
1161:
1162: EXCEPTION
1163: WHEN xla_exceptions_pkg.application_exception THEN
1164: RAISE;
1165: WHEN OTHERS THEN
1166: xla_exceptions_pkg.raise_message
1167: (p_location => 'xla_product_rules_pkg.set_compile_status');
1162: EXCEPTION
1163: WHEN xla_exceptions_pkg.application_exception THEN
1164: RAISE;
1165: WHEN OTHERS THEN
1166: xla_exceptions_pkg.raise_message
1167: (p_location => 'xla_product_rules_pkg.set_compile_status');
1168:
1169: END set_compile_status;
1170:
1222:
1223: return l_return;
1224:
1225: EXCEPTION
1226: WHEN xla_exceptions_pkg.application_exception THEN
1227: RAISE;
1228:
1229: WHEN OTHERS THEN
1230:
1227: RAISE;
1228:
1229: WHEN OTHERS THEN
1230:
1231: xla_exceptions_pkg.raise_message
1232: (p_location => 'xla_product_rules_pkg.invalid_hdr_analytical');
1233:
1234: END invalid_hdr_analytical;
1235:
1386:
1387: xla_utility_pkg.trace('< xla_product_rules_pkg.create_accounting_attributes' , 10);
1388:
1389: EXCEPTION
1390: WHEN xla_exceptions_pkg.application_exception THEN
1391: RAISE;
1392: WHEN OTHERS THEN
1393: xla_exceptions_pkg.raise_message
1394: (p_location => 'xla_product_rules_pkg.create_accounting_attributes');
1389: EXCEPTION
1390: WHEN xla_exceptions_pkg.application_exception THEN
1391: RAISE;
1392: WHEN OTHERS THEN
1393: xla_exceptions_pkg.raise_message
1394: (p_location => 'xla_product_rules_pkg.create_accounting_attributes');
1395:
1396: END create_accounting_attributes;
1397:
1457:
1458: xla_utility_pkg.trace('< xla_product_rules_pkg.get_default_attr_assignment' , 10);
1459:
1460: EXCEPTION
1461: WHEN xla_exceptions_pkg.application_exception THEN
1462: RAISE;
1463: WHEN OTHERS THEN
1464: xla_exceptions_pkg.raise_message
1465: (p_location => 'xla_product_rules_pkg.get_default_attr_assignment');
1460: EXCEPTION
1461: WHEN xla_exceptions_pkg.application_exception THEN
1462: RAISE;
1463: WHEN OTHERS THEN
1464: xla_exceptions_pkg.raise_message
1465: (p_location => 'xla_product_rules_pkg.get_default_attr_assignment');
1466:
1467: END get_default_attr_assignment;
1468:
1575:
1576: return l_return;
1577:
1578: EXCEPTION
1579: WHEN xla_exceptions_pkg.application_exception THEN
1580: IF c_locked_aads%ISOPEN THEN
1581: CLOSE c_locked_aads;
1582: END IF;
1583:
1586: IF c_locked_aads%ISOPEN THEN
1587: CLOSE c_locked_aads;
1588: END IF;
1589:
1590: xla_exceptions_pkg.raise_message
1591: (p_location => 'xla_event_classes_pkg.uncompile_definitions');
1592:
1593: END uncompile_definitions;
1594: