DBA Data[Home] [Help]

APPS.XLA_LINE_TYPES_PKG dependencies on XLA_UTILITY_PKG

Line 91: xla_utility_pkg.trace('> xla_line_types_pkg.delete_line_type_details' , 10);

87: l_accounting_line_type_code VARCHAR2(1) := p_accounting_line_type_code;
88:
89: BEGIN
90:
91: xla_utility_pkg.trace('> xla_line_types_pkg.delete_line_type_details' , 10);
92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

89: BEGIN
90:
91: xla_utility_pkg.trace('> xla_line_types_pkg.delete_line_type_details' , 10);
92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

Line 94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

90:
91: xla_utility_pkg.trace('> xla_line_types_pkg.delete_line_type_details' , 10);
92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
98:

Line 95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

91: xla_utility_pkg.trace('> xla_line_types_pkg.delete_line_type_details' , 10);
92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
98:
99: xla_conditions_pkg.delete_condition

Line 96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

92:
93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
98:
99: xla_conditions_pkg.delete_condition
100: (p_context => 'A'

Line 97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

93: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
94: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
95: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
96: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
97: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
98:
99: xla_conditions_pkg.delete_condition
100: (p_context => 'A'
101: ,p_application_id => l_application_id

Line 116: xla_utility_pkg.trace('< xla_line_types_pkg.delete_line_type_details' , 10);

112: AND event_class_code = p_event_class_code
113: AND accounting_line_type_code = p_accounting_line_type_code
114: AND accounting_line_code = p_accounting_line_code;
115:
116: xla_utility_pkg.trace('< xla_line_types_pkg.delete_line_type_details' , 10);
117:
118: EXCEPTION
119: WHEN xla_exceptions_pkg.application_exception THEN
120: RAISE;

Line 212: xla_utility_pkg.trace('> xla_line_types_pkg.copy_line_type_details' , 10);

208: AND source_code = l_condition.value_source_code;
209:
210: BEGIN
211:
212: xla_utility_pkg.trace('> xla_line_types_pkg.copy_line_type_details' , 10);
213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

210: BEGIN
211:
212: xla_utility_pkg.trace('> xla_line_types_pkg.copy_line_type_details' , 10);
213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);

Line 215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

211:
212: xla_utility_pkg.trace('> xla_line_types_pkg.copy_line_type_details' , 10);
213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);

Line 216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

212: xla_utility_pkg.trace('> xla_line_types_pkg.copy_line_type_details' , 10);
213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);

Line 217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);

213:
214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);
221:

Line 218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);

214: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);
221:
222:

Line 219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);

215: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);
221:
222:
223: OPEN c_conditions;

Line 220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);

216: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
217: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
218: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
219: xla_utility_pkg.trace('new_accounting_line_type_code = '||p_new_accting_line_type_code , 20);
220: xla_utility_pkg.trace('new_accounting_line_code = '||p_new_accounting_line_code , 20);
221:
222:
223: OPEN c_conditions;
224: LOOP

Line 393: xla_utility_pkg.trace('< xla_line_types_pkg.copy_line_type_details' , 10);

389: ,l_last_update_login);
390: END LOOP;
391: CLOSE c_acct_sources;
392:
393: xla_utility_pkg.trace('< xla_line_types_pkg.copy_line_type_details' , 10);
394:
395: EXCEPTION
396: WHEN xla_exceptions_pkg.application_exception THEN
397: IF c_conditions%ISOPEN THEN

Line 500: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_in_use' , 10);

496: l_mpa_active_assignment_exist c_mpa_active_assignment_exist%rowtype;
497:
498: BEGIN
499:
500: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_in_use' , 10);
501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);

Line 502: xla_utility_pkg.trace('event = '||p_event , 20);

498: BEGIN
499:
500: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_in_use' , 10);
501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

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

499:
500: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_in_use' , 10);
501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

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

500: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_in_use' , 10);
501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
508:

Line 505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

501:
502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
508:
509: IF p_event in ('DELETE','UPDATE') THEN

Line 506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

502: xla_utility_pkg.trace('event = '||p_event , 20);
503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
508:
509: IF p_event in ('DELETE','UPDATE') THEN
510: OPEN c_assignment_exist;

Line 507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

503: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
504: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
505: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
506: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
507: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
508:
509: IF p_event in ('DELETE','UPDATE') THEN
510: OPEN c_assignment_exist;
511: FETCH c_assignment_exist

Line 599: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_in_use' , 10);

595: ,'LOCATION' ,'xla_line_types_pkg.line_type_in_use');
596:
597: END IF;
598:
599: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_in_use' , 10);
600:
601: return l_return;
602:
603: EXCEPTION

Line 666: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_invalid' , 10);

662: l_accounting_line_type_code VARCHAR2(1) := p_accounting_line_type_code;
663:
664: BEGIN
665:
666: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_invalid' , 10);
667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

664: BEGIN
665:
666: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_invalid' , 10);
667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

Line 669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

665:
666: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_invalid' , 10);
667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
673:

Line 670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

666: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_invalid' , 10);
667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
673:
674: --

Line 671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

667:
668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
673:
674: --
675: -- check if condition is invalid

Line 672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

668: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
669: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
670: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
671: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
672: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
673:
674: --
675: -- check if condition is invalid
676: --

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

712: l_return := FALSE;
713: END IF;
714: END IF;
715:
716: xla_utility_pkg.trace('p_message_name = '||p_message_name , 20);
717: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_is_invalid' , 10);
718:
719: return l_return;
720:

Line 717: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_is_invalid' , 10);

713: END IF;
714: END IF;
715:
716: xla_utility_pkg.trace('p_message_name = '||p_message_name , 20);
717: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_is_invalid' , 10);
718:
719: return l_return;
720:
721: EXCEPTION

Line 782: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_locked' , 10);

778: AND a.line_definition_code = s.line_definition_code);
779:
780: BEGIN
781:
782: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_locked' , 10);
783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

780: BEGIN
781:
782: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_locked' , 10);
783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

Line 785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

781:
782: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_locked' , 10);
783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
789:

Line 786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

782: xla_utility_pkg.trace('> xla_line_types_pkg.line_type_is_locked' , 10);
783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
789:
790: OPEN c_frozen_assignment_exist;

Line 787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

783:
784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
789:
790: OPEN c_frozen_assignment_exist;
791: FETCH c_frozen_assignment_exist

Line 788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

784: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
785: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
786: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
787: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
788: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
789:
790: OPEN c_frozen_assignment_exist;
791: FETCH c_frozen_assignment_exist
792: INTO l_exist;

Line 800: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_is_locked' , 10);

796: l_return := FALSE;
797: END IF;
798: CLOSE c_frozen_assignment_exist;
799:
800: xla_utility_pkg.trace('< xla_line_types_pkg.line_type_is_locked' , 10);
801:
802: return l_return;
803:
804: EXCEPTION

Line 836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);

832: ,p_accounting_line_type_code IN VARCHAR2
833: ,p_accounting_line_code IN VARCHAR2)
834: IS
835: BEGIN
836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

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

833: ,p_accounting_line_code IN VARCHAR2)
834: IS
835: BEGIN
836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
841:

Line 838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

834: IS
835: BEGIN
836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
841:
842: delete xla_jlt_acct_attrs

Line 839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

835: BEGIN
836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
841:
842: delete xla_jlt_acct_attrs
843: WHERE application_id = p_application_id

Line 840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

836: xla_utility_pkg.trace('> xla_line_types_pkg.delete_non_gain_acct_attrs' , 10); xla_utility_pkg.trace('application_id = '||p_application_id , 20);
837: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
841:
842: delete xla_jlt_acct_attrs
843: WHERE application_id = p_application_id
844: AND amb_context_code = p_amb_context_code

Line 855: xla_utility_pkg.trace('< xla_line_types_pkg.delete_non_gain_acct_attrs' , 10);

851: ,'EXCHANGE_RATE_TYPE'
852: ,'EXCHANGE_DATE'
853: ,'EXCHANGE_RATE'
854: );
855: xla_utility_pkg.trace('< xla_line_types_pkg.delete_non_gain_acct_attrs' , 10);
856:
857: EXCEPTION
858: WHEN xla_exceptions_pkg.application_exception THEN
859: RAISE;

Line 904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);

900: l_arr_source_type_code t_array_codes;
901: l_arr_source_code t_array_codes;
902:
903: BEGIN
904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

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

901: l_arr_source_code t_array_codes;
902:
903: BEGIN
904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

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

902:
903: BEGIN
904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
910:

Line 907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

903: BEGIN
904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
910:
911: INSERT into xla_jlt_acct_attrs(

Line 908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

904: xla_utility_pkg.trace('> xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
910:
911: INSERT into xla_jlt_acct_attrs(
912: application_id

Line 909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

905: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
906: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
910:
911: INSERT into xla_jlt_acct_attrs(
912: application_id
913: ,amb_context_code

Line 978: xla_utility_pkg.trace('< xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);

974: AND event_class_default_flag = 'Y';
975: END IF;
976: CLOSE c_attr_source;
977:
978: xla_utility_pkg.trace('< xla_line_types_pkg.insert_non_gain_acct_attrs' , 10);
979:
980: EXCEPTION
981: WHEN xla_exceptions_pkg.application_exception THEN
982: RAISE;

Line 1022: xla_utility_pkg.trace('> xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);

1018: ,'EXCHANGE_RATE'
1019: );
1020: BEGIN
1021:
1022: xla_utility_pkg.trace('> xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

1020: BEGIN
1021:
1022: xla_utility_pkg.trace('> xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

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

1021:
1022: xla_utility_pkg.trace('> xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1029:

Line 1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

1022: xla_utility_pkg.trace('> xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1029:
1030: open c_non_gain_acct_attrs;

Line 1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

1023:
1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1029:
1030: open c_non_gain_acct_attrs;
1031: fetch c_non_gain_acct_attrs into l_temp;

Line 1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

1024: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1025: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1026: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1027: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1028: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1029:
1030: open c_non_gain_acct_attrs;
1031: fetch c_non_gain_acct_attrs into l_temp;
1032: IF c_non_gain_acct_attrs%notfound THEN

Line 1040: xla_utility_pkg.trace('< xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);

1036: END IF;
1037:
1038: return l_result;
1039:
1040: xla_utility_pkg.trace('< xla_line_types_pkg.non_gain_acct_attrs_exists' , 10);
1041:
1042: EXCEPTION
1043: WHEN xla_exceptions_pkg.application_exception THEN
1044: RAISE;

Line 1122: xla_utility_pkg.trace('> xla_line_types_pkg.create_accounting_attributes' , 10);

1118: AND l.inherited_flag = 'N';
1119:
1120: BEGIN
1121:
1122: xla_utility_pkg.trace('> xla_line_types_pkg.create_accounting_attributes' , 10);
1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);

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

1120: BEGIN
1121:
1122: xla_utility_pkg.trace('> xla_line_types_pkg.create_accounting_attributes' , 10);
1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);
1127: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1128:

Line 1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

1121:
1122: xla_utility_pkg.trace('> xla_line_types_pkg.create_accounting_attributes' , 10);
1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);
1127: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1128:
1129: OPEN c_acct_sources;

Line 1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);

1122: xla_utility_pkg.trace('> xla_line_types_pkg.create_accounting_attributes' , 10);
1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);
1127: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1128:
1129: OPEN c_acct_sources;
1130: FETCH c_acct_sources

Line 1127: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

1123:
1124: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1125: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1126: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code, 20);
1127: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1128:
1129: OPEN c_acct_sources;
1130: FETCH c_acct_sources
1131: INTO l_exist;

Line 1312: xla_utility_pkg.trace('< xla_line_types_pkg.create_accounting_attributes' , 10);

1308: END IF;
1309: END IF;
1310: CLOSE c_acct_sources;
1311:
1312: xla_utility_pkg.trace('< xla_line_types_pkg.create_accounting_attributes' , 10);
1313:
1314: EXCEPTION
1315: WHEN xla_exceptions_pkg.application_exception THEN
1316: RAISE;

Line 1419: xla_utility_pkg.trace('> xla_line_types_pkg.uncompile_definitions' , 10);

1415: l_product_rule_type_codes t_array_type_codes;
1416: l_product_rule_codes t_array_codes;
1417: BEGIN
1418:
1419: xla_utility_pkg.trace('> xla_line_types_pkg.uncompile_definitions' , 10);
1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

1417: BEGIN
1418:
1419: xla_utility_pkg.trace('> xla_line_types_pkg.uncompile_definitions' , 10);
1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

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

1418:
1419: xla_utility_pkg.trace('> xla_line_types_pkg.uncompile_definitions' , 10);
1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1426:

Line 1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

1419: xla_utility_pkg.trace('> xla_line_types_pkg.uncompile_definitions' , 10);
1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1426:
1427: l_return := TRUE;

Line 1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

1420:
1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1426:
1427: l_return := TRUE;
1428:

Line 1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

1421: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1422: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
1423: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1424: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
1425: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
1426:
1427: l_return := TRUE;
1428:
1429: FOR l_lock_aad IN c_locked_aads LOOP

Line 1535: xla_utility_pkg.trace('< xla_line_types_pkg.uncompile_definitions' , 10);

1531: x_event_class_name := l_event_class_name;
1532: x_event_type_name := l_event_type_name;
1533: x_locking_status_flag := l_locking_status_flag;
1534:
1535: xla_utility_pkg.trace('< xla_line_types_pkg.uncompile_definitions' , 10);
1536:
1537: return l_return;
1538:
1539: EXCEPTION

Line 1603: xla_utility_pkg.trace('> xla_line_types_pkg.get_default_attr_assignment' , 10);

1599: AND l.lookup_type (+) = 'XLA_SOURCE_TYPE';
1600:
1601: BEGIN
1602:
1603: xla_utility_pkg.trace('> xla_line_types_pkg.get_default_attr_assignment' , 10);
1604:
1605: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1606: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1607:

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

1601: BEGIN
1602:
1603: xla_utility_pkg.trace('> xla_line_types_pkg.get_default_attr_assignment' , 10);
1604:
1605: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1606: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1607:
1608: OPEN c_dflt_source;
1609: FETCH c_dflt_source

Line 1606: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

1602:
1603: xla_utility_pkg.trace('> xla_line_types_pkg.get_default_attr_assignment' , 10);
1604:
1605: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1606: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1607:
1608: OPEN c_dflt_source;
1609: FETCH c_dflt_source
1610: INTO p_source_application_id, p_source_type_code, p_source_code,

Line 1622: xla_utility_pkg.trace('< xla_line_types_pkg.get_default_attr_assignment' , 10);

1618:
1619: END IF;
1620: CLOSE c_dflt_source;
1621:
1622: xla_utility_pkg.trace('< xla_line_types_pkg.get_default_attr_assignment' , 10);
1623:
1624: EXCEPTION
1625: WHEN xla_exceptions_pkg.application_exception THEN
1626: RAISE;

Line 1879: xla_utility_pkg.trace('> xla_line_types_pkg.check_copy_line_type_details' , 10);

1875: AND source_code = l_condition.value_source_code;
1876:
1877: BEGIN
1878:
1879: xla_utility_pkg.trace('> xla_line_types_pkg.check_copy_line_type_details' , 10);
1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

1877: BEGIN
1878:
1879: xla_utility_pkg.trace('> xla_line_types_pkg.check_copy_line_type_details' , 10);
1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);

Line 1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

1878:
1879: xla_utility_pkg.trace('> xla_line_types_pkg.check_copy_line_type_details' , 10);
1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
1886:

Line 1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

1879: xla_utility_pkg.trace('> xla_line_types_pkg.check_copy_line_type_details' , 10);
1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
1886:
1887: OPEN c_conditions;

Line 1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);

1880:
1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
1886:
1887: OPEN c_conditions;
1888: LOOP

Line 1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);

1881: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1882: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
1883: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1884: xla_utility_pkg.trace('old_accounting_line_type_code = '||p_old_accting_line_type_code , 20);
1885: xla_utility_pkg.trace('old_accounting_line_code = '||p_old_accounting_line_code , 20);
1886:
1887: OPEN c_conditions;
1888: LOOP
1889: FETCH c_conditions

Line 1962: xla_utility_pkg.trace('< xla_line_types_pkg.check_copy_line_type_details' , 10);

1958: END IF;
1959: END LOOP;
1960: CLOSE c_conditions;
1961:
1962: xla_utility_pkg.trace('< xla_line_types_pkg.check_copy_line_type_details' , 10);
1963:
1964: RETURN l_return;
1965:
1966: EXCEPTION

Line 2040: xla_utility_pkg.trace('> xla_line_types_pkg.update_acct_attrs' , 10);

2036: AND l.inherited_flag = 'Y';
2037:
2038: BEGIN
2039:
2040: xla_utility_pkg.trace('> xla_line_types_pkg.update_acct_attrs' , 10);
2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

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

2038: BEGIN
2039:
2040: xla_utility_pkg.trace('> xla_line_types_pkg.update_acct_attrs' , 10);
2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
2045: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
2046:

Line 2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

2039:
2040: xla_utility_pkg.trace('> xla_line_types_pkg.update_acct_attrs' , 10);
2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
2045: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
2046:
2047: IF p_business_method_code = 'PRIOR_ENTRY' THEN

Line 2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);

2040: xla_utility_pkg.trace('> xla_line_types_pkg.update_acct_attrs' , 10);
2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
2045: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
2046:
2047: IF p_business_method_code = 'PRIOR_ENTRY' THEN
2048: -- Update the inherited accounting attributes to null source mapping

Line 2045: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);

2041:
2042: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2043: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
2044: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
2045: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
2046:
2047: IF p_business_method_code = 'PRIOR_ENTRY' THEN
2048: -- Update the inherited accounting attributes to null source mapping
2049:

Line 2097: xla_utility_pkg.trace('< xla_line_types_pkg.update_acct_attrs' , 10);

2093: END IF;
2094: CLOSE c_non_prior_entry;
2095: END IF;
2096:
2097: xla_utility_pkg.trace('< xla_line_types_pkg.update_acct_attrs' , 10);
2098:
2099: EXCEPTION
2100: WHEN xla_exceptions_pkg.application_exception THEN
2101: RAISE;

Line 2171: xla_utility_pkg.trace('> xla_line_types_pkg.mpa_line_type_in_use' , 10);

2167: l_mpa_assignment_exist c_mpa_assignment_exist%rowtype;
2168:
2169: BEGIN
2170:
2171: xla_utility_pkg.trace('> xla_line_types_pkg.mpa_line_type_in_use' , 10);
2172:
2173: OPEN c_mpa_option_code;
2174: FETCH c_mpa_option_code
2175: INTO l_mpa_option_code;

Line 2224: xla_utility_pkg.trace('< xla_line_types_pkg.mpa_line_type_in_use' , 10);

2220: CLOSE c_mpa_assignment_exist;
2221:
2222: END IF;
2223:
2224: xla_utility_pkg.trace('< xla_line_types_pkg.mpa_line_type_in_use' , 10);
2225: x_mpa_option_code := l_mpa_option_code;
2226:
2227: return l_return;
2228: