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.XLA_SEG_RULES_PKG dependencies on XLA_SEG_RULES_PKG

Line 1: PACKAGE BODY xla_seg_rules_pkg AS

1: PACKAGE BODY xla_seg_rules_pkg AS
2: /* $Header: xlaamadr.pkb 120.25 2006/01/19 21:10:15 dcshah ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_seg_rules_pkg |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_seg_rules_pkg |
10: | |
11: | DESCRIPTION |
12: | XLA Segment Rules Package |
13: | |

Line 53: xla_utility_pkg.trace('> xla_seg_rules_pkg.delete_seg_rule_details' , 10);

49: AND segment_rule_code = p_segment_rule_code;
50:
51: BEGIN
52:
53: xla_utility_pkg.trace('> xla_seg_rules_pkg.delete_seg_rule_details' , 10);
54:
55: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
56: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
57: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);

Line 79: xla_utility_pkg.trace('< xla_seg_rules_pkg.delete_seg_rule_details' , 10);

75: AND amb_context_code = p_amb_context_code
76: AND segment_rule_type_code = p_segment_rule_type_code
77: AND segment_rule_code = p_segment_rule_code;
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

Line 94: (p_location => 'xla_seg_rules_pkg.delete_seg_rule_details');

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:
98: /*======================================================================+

Line 197: xla_utility_pkg.trace('> xla_seg_rules_pkg.copy_seg_rule_details' , 10);

193: AND source_code = l_detail_condition.value_source_code;
194:
195: BEGIN
196:
197: xla_utility_pkg.trace('> xla_seg_rules_pkg.copy_seg_rule_details' , 10);
198:
199: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
200: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
201: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);

Line 448: xla_utility_pkg.trace('< xla_seg_rules_pkg.copy_seg_rule_details' , 10);

444:
445: END LOOP;
446: CLOSE c_seg_rule_details;
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

Line 467: (p_location => 'xla_seg_rules_pkg.copy_seg_rule_details');

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:
471: /*======================================================================+

Line 532: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use' , 10);

528: l_active_assignment_exist c_active_assignment_exist%rowtype;
529:
530: BEGIN
531:
532: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use' , 10);
533:
534: xla_utility_pkg.trace('event = '||p_event , 20);
535: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
536: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);

Line 587: ,'LOCATION' ,'xla_seg_rules_pkg.rule_in_use');

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:
589: END IF;
590:
591: x_line_definition_name := l_line_definition_name;

Line 594: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_in_use' , 10);

590:
591: x_line_definition_name := l_line_definition_name;
592: x_line_definition_owner := l_line_definition_owner;
593:
594: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_in_use' , 10);
595:
596: return l_return;
597:
598: EXCEPTION

Line 617: (p_location => 'xla_seg_rules_pkg.rule_in_use');

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:
621: /*======================================================================+

Line 654: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_is_invalid' , 10);

650: l_segment_rule_code VARCHAR2(30);
651:
652: BEGIN
653:
654: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_is_invalid' , 10);
655:
656: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
657: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
658: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);

Line 680: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_is_invalid' , 10);

676: l_return := FALSE;
677: END IF;
678:
679: xla_utility_pkg.trace('p_message_name = '||p_message_name , 20);
680: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_is_invalid' , 10);
681:
682: return l_return;
683:
684: EXCEPTION

Line 690: (p_location => 'xla_seg_rules_pkg.rule_is_invalid');

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:
694: /*======================================================================+

Line 758: xla_utility_pkg.trace('> xla_seg_rules_pkg.seg_rule_is_locked' , 10);

754: AND a.locking_status_flag = 'Y');
755:
756: BEGIN
757:
758: xla_utility_pkg.trace('> xla_seg_rules_pkg.seg_rule_is_locked' , 10);
759:
760: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
761: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
762: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);

Line 786: xla_utility_pkg.trace('< xla_seg_rules_pkg.seg_rule_is_locked' , 10);

782: END IF;
783: CLOSE c_tab_assignment_exist;
784: END IF;
785:
786: xla_utility_pkg.trace('< xla_seg_rules_pkg.seg_rule_is_locked' , 10);
787:
788: return l_return;
789:
790: EXCEPTION

Line 803: (p_location => 'xla_seg_rules_pkg.seg_rule_is_locked');

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:
807: /*======================================================================+

Line 898: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_definitions' , 10);

894: l_product_rule_type_codes t_array_type_codes;
895: l_product_rule_codes t_array_codes;
896: BEGIN
897:
898: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_definitions' , 10);
899:
900: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
901: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
902: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);

Line 1015: xla_utility_pkg.trace('< xla_seg_rules_pkg.uncompile_definitions' , 10);

1011: x_event_class_name := l_event_class_name;
1012: x_event_type_name := l_event_type_name;
1013: x_locking_status_flag := l_locking_status_flag;
1014:
1015: xla_utility_pkg.trace('< xla_seg_rules_pkg.uncompile_definitions' , 10);
1016:
1017: return l_return;
1018:
1019: EXCEPTION

Line 1038: (p_location => 'xla_seg_rules_pkg.uncompile_definitions');

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:
1042: /*======================================================================+

Line 1086: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use_by_tab' , 10);

1082: l_assignment_exist c_assignment_exist%rowtype;
1083:
1084: BEGIN
1085:
1086: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use_by_tab' , 10);
1087:
1088: xla_utility_pkg.trace('event = '||p_event , 20);
1089: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1090: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code

Line 1125: ,'LOCATION' ,'xla_seg_rules_pkg.rule_in_use_by_tab');

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:
1127: END IF;
1128:
1129: p_trx_acct_def := l_trx_acct_def;

Line 1133: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_in_use_by_tab' , 10);

1129: p_trx_acct_def := l_trx_acct_def;
1130: p_trx_acct_def_type := l_trx_acct_def_type;
1131: p_trx_acct_type := l_trx_acct_type;
1132:
1133: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_in_use_by_tab' , 10);
1134:
1135: return l_return;
1136:
1137: EXCEPTION

Line 1150: (p_location => 'xla_seg_rules_pkg.rule_in_use_by_tab');

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:
1154: /*======================================================================+

Line 1204: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_tran_acct_def' , 10);

1200: l_trx_def c_trx_defs%rowtype;
1201:
1202: BEGIN
1203:
1204: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_tran_acct_def' , 10);
1205:
1206: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1207: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1208: , 20);

Line 1245: xla_utility_pkg.trace('< xla_seg_rules_pkg.uncompile_tran_acct_def' , 10);

1241: p_application_name := l_application_name;
1242: p_trx_acct_def := l_trx_acct_def;
1243: p_trx_acct_def_type := l_trx_acct_def_type;
1244:
1245: xla_utility_pkg.trace('< xla_seg_rules_pkg.uncompile_tran_acct_def' , 10);
1246:
1247: return l_return;
1248:
1249: EXCEPTION

Line 1262: (p_location => 'xla_seg_rules_pkg.uncompile_tran_acct_def');

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:
1266: /*======================================================================+

Line 1376: xla_utility_pkg.trace('> xla_seg_rules_pkg.check_copy_seg_rule_details' , 10);

1372: AND source_code = l_detail_condition.value_source_code;
1373:
1374: BEGIN
1375:
1376: xla_utility_pkg.trace('> xla_seg_rules_pkg.check_copy_seg_rule_details' , 10);
1377:
1378: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1379: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
1380: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);

Line 1547: xla_utility_pkg.trace('< xla_seg_rules_pkg.check_copy_seg_rule_details' , 10);

1543: END LOOP;
1544: CLOSE c_seg_rule_details;
1545: END IF;
1546:
1547: xla_utility_pkg.trace('< xla_seg_rules_pkg.check_copy_seg_rule_details' , 10);
1548:
1549: return l_return;
1550:
1551: EXCEPTION

Line 1568: (p_location => 'xla_seg_rules_pkg.check_copy_seg_rule_details');

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:
1572: /*======================================================================+

Line 1645: (p_location => 'xla_seg_rules_pkg.rule_in_use_by_adr');

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:
1649: /*======================================================================+

Line 1708: (p_location => 'xla_seg_rules_pkg.parent_seg_rule_is_locked');

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

Line 1713: END xla_seg_rules_pkg;

1709:
1710: END parent_seg_rule_is_locked;
1711:
1712:
1713: END xla_seg_rules_pkg;