DBA Data[Home] [Help]

APPS.XLA_SEG_RULES_PKG dependencies on XLA_UTILITY_PKG

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 55: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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);
58:
59: OPEN c_seg_rule_details;

Line 56: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);

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);
58:
59: OPEN c_seg_rule_details;
60: LOOP

Line 57: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);

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);
58:
59: OPEN c_seg_rule_details;
60: LOOP
61: FETCH c_seg_rule_details

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 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 199: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);

Line 200: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);

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);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);
204:

Line 201: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);

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);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);
204:
205:

Line 202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);

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);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);
204:
205:
206: l_creation_date := sysdate;

Line 203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);

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);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);
204:
205:
206: l_creation_date := sysdate;
207: l_last_update_date := sysdate;

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 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 534: xla_utility_pkg.trace('event = '||p_event , 20);

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);
537: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
538:

Line 535: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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);
537: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
538:
539: IF p_event in ('DELETE','UPDATE') THEN

Line 536: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);

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);
537: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
538:
539: IF p_event in ('DELETE','UPDATE') THEN
540: OPEN c_assignment_exist;

Line 537: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);

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);
537: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
538:
539: IF p_event in ('DELETE','UPDATE') THEN
540: OPEN c_assignment_exist;
541: FETCH c_assignment_exist

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 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 656: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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);
659:
660: l_application_id := p_application_id;

Line 657: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);

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);
659:
660: l_application_id := p_application_id;
661: l_amb_context_code := p_amb_context_code;

Line 658: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);

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);
659:
660: l_application_id := p_application_id;
661: l_amb_context_code := p_amb_context_code;
662: l_segment_rule_type_code := p_segment_rule_type_code;

Line 679: xla_utility_pkg.trace('p_message_name = '||p_message_name , 20);

675: p_message_name := NULL;
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:

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 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 760: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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);
763:
764: OPEN c_frozen_assignment_exist;

Line 761: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);

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);
763:
764: OPEN c_frozen_assignment_exist;
765: FETCH c_frozen_assignment_exist

Line 762: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);

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);
763:
764: OPEN c_frozen_assignment_exist;
765: FETCH c_frozen_assignment_exist
766: INTO l_exist;

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 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 900: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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);
903: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
904:

Line 901: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);

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);
903: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
904:
905: l_return := TRUE;

Line 902: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);

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);
903: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
904:
905: l_return := TRUE;
906:

Line 903: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);

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);
903: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
904:
905: l_return := TRUE;
906:
907: FOR l_lock_aad IN c_lock_aads LOOP

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 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 1088: xla_utility_pkg.trace('event = '||p_event , 20);

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
1091: , 20);
1092: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,

Line 1089: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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
1091: , 20);
1092: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1093: 20);

Line 1090: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code

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
1091: , 20);
1092: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1093: 20);
1094:

Line 1092: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,

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
1091: , 20);
1092: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1093: 20);
1094:
1095: IF p_event in ('DELETE','UPDATE','DISABLE') THEN
1096: OPEN c_assignment_exist;

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 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 1206: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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);
1209: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1210: 20);

Line 1207: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code

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);
1209: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1210: 20);
1211:

Line 1209: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,

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);
1209: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1210: 20);
1211:
1212: OPEN c_trx_defs;
1213: LOOP

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 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 1378: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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);
1381:
1382: IF p_new_flex_value_set_id is not null then

Line 1379: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);

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);
1381:
1382: IF p_new_flex_value_set_id is not null then
1383: IF p_old_flex_value_set_id <> p_new_flex_value_set_id THEN

Line 1380: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);

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);
1381:
1382: IF p_new_flex_value_set_id is not null then
1383: IF p_old_flex_value_set_id <> p_new_flex_value_set_id THEN
1384: OPEN c_flex_value;

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