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_PRODUCT_RULES_PKG dependencies on XLA_UTILITY_PKG

Line 71: xla_utility_pkg.trace('> xla_product_rules_pkg.is_accounting_reversal' , 10);

67: AND e.accounting_attribute_code = 'ACCOUNTING_REVERSAL_OPTION';
68:
69: BEGIN
70:
71: xla_utility_pkg.trace('> xla_product_rules_pkg.is_accounting_reversal' , 10);
72:
73: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
74: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
75: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

69: BEGIN
70:
71: xla_utility_pkg.trace('> xla_product_rules_pkg.is_accounting_reversal' , 10);
72:
73: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
74: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
75: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
76:
77: l_application_id := p_application_id;

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

70:
71: xla_utility_pkg.trace('> xla_product_rules_pkg.is_accounting_reversal' , 10);
72:
73: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
74: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
75: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
76:
77: l_application_id := p_application_id;
78: l_entity_code := p_entity_code;

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

71: xla_utility_pkg.trace('> xla_product_rules_pkg.is_accounting_reversal' , 10);
72:
73: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
74: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
75: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
76:
77: l_application_id := p_application_id;
78: l_entity_code := p_entity_code;
79: l_event_class_code := p_event_class_code;

Line 91: xla_utility_pkg.trace('< xla_product_rules_pkg.is_accounting_reversal' , 10);

87: l_return := FALSE;
88: END IF;
89: CLOSE c_event_sources;
90:
91: xla_utility_pkg.trace('< xla_product_rules_pkg.is_accounting_reversal' , 10);
92:
93: return l_return;
94:
95: EXCEPTION

Line 186: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_ac' , 10);

182: l_analytical_der_sources c_analytical_der_sources%rowtype;
183:
184: BEGIN
185:
186: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_ac' , 10);
187:
188: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
189: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
190: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);

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

184: BEGIN
185:
186: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_ac' , 10);
187:
188: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
189: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
190: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);
191: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);
192:

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

185:
186: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_ac' , 10);
187:
188: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
189: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
190: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);
191: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);
192:
193: OPEN c_anal;

Line 190: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);

186: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_ac' , 10);
187:
188: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
189: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
190: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);
191: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);
192:
193: OPEN c_anal;
194: FETCH c_anal

Line 191: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);

187:
188: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
189: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
190: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);
191: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);
192:
193: OPEN c_anal;
194: FETCH c_anal
195: INTO l_exist;

Line 254: xla_utility_pkg.trace('< xla_product_rules_pkg.invalid_hdr_ac' , 10);

250: END LOOP;
251: CLOSE c_analytical_der_sources;
252: END IF;
253:
254: xla_utility_pkg.trace('< xla_product_rules_pkg.invalid_hdr_ac' , 10);
255:
256: return l_return;
257:
258: EXCEPTION

Line 405: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_desc' , 10);

401: l_desc_condition_der_sources c_desc_condition_der_sources%rowtype;
402:
403: BEGIN
404:
405: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_desc' , 10);
406:
407: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
408: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
409: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

403: BEGIN
404:
405: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_desc' , 10);
406:
407: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
408: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
409: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
410: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
411: xla_utility_pkg.trace('description_code = '||p_description_code , 20);

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

404:
405: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_desc' , 10);
406:
407: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
408: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
409: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
410: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
411: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
412:

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

405: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_desc' , 10);
406:
407: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
408: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
409: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
410: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
411: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
412:
413: --

Line 410: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);

406:
407: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
408: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
409: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
410: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
411: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
412:
413: --
414: -- check description has seeded sources that do not belong to the event class

Line 411: xla_utility_pkg.trace('description_code = '||p_description_code , 20);

407: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
408: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
409: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
410: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
411: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
412:
413: --
414: -- check description has seeded sources that do not belong to the event class
415: --

Line 492: xla_utility_pkg.trace('< xla_product_rules_pkg.invalid_header_desc' , 10);

488: END LOOP;
489: CLOSE c_desc_condition_der_sources;
490: END IF;
491:
492: xla_utility_pkg.trace('< xla_product_rules_pkg.invalid_header_desc' , 10);
493:
494: return l_return;
495:
496: EXCEPTION

Line 538: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_product_rule_details' , 10);

534: IS
535:
536: BEGIN
537:
538: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_product_rule_details' , 10);
539:
540: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
541: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
542: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

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

536: BEGIN
537:
538: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_product_rule_details' , 10);
539:
540: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
541: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
542: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
543:
544: DELETE

Line 541: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);

537:
538: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_product_rule_details' , 10);
539:
540: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
541: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
542: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
543:
544: DELETE
545: FROM xla_aad_header_ac_assgns

Line 542: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

538: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_product_rule_details' , 10);
539:
540: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
541: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
542: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
543:
544: DELETE
545: FROM xla_aad_header_ac_assgns
546: WHERE application_id = p_application_id

Line 572: xla_utility_pkg.trace('< xla_product_rules_pkg.delete_product_rule_details' , 10);

568: AND amb_context_code = p_amb_context_code
569: AND product_rule_type_code = p_product_rule_type_code
570: AND product_rule_code = p_product_rule_code;
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;

Line 604: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_prod_header_details' , 10);

600: IS
601:
602: BEGIN
603:
604: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_prod_header_details' , 10);
605:
606: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
607: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
608: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

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

602: BEGIN
603:
604: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_prod_header_details' , 10);
605:
606: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
607: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
608: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
609:
610: DELETE

Line 607: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);

603:
604: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_prod_header_details' , 10);
605:
606: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
607: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
608: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
609:
610: DELETE
611: FROM xla_aad_header_ac_assgns

Line 608: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

604: xla_utility_pkg.trace('> xla_product_rules_pkg.delete_prod_header_details' , 10);
605:
606: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
607: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
608: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
609:
610: DELETE
611: FROM xla_aad_header_ac_assgns
612: WHERE application_id = p_application_id

Line 637: xla_utility_pkg.trace('< xla_product_rules_pkg.delete_prod_header_details' , 10);

633: AND product_rule_code = p_product_rule_code
634: AND event_class_code = p_event_class_code
635: AND event_type_code = p_event_type_code;
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;

Line 676: xla_utility_pkg.trace('> xla_product_rules_pkg.copy_product_rule_details' , 10);

672: l_last_updated_by INTEGER;
673:
674: BEGIN
675:
676: xla_utility_pkg.trace('> xla_product_rules_pkg.copy_product_rule_details' , 10);
677:
678: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
679: xla_utility_pkg.trace('old_product_rule_type_code = '||p_old_product_rule_type_code , 20);
680: xla_utility_pkg.trace('old_product_rule_code = '||p_old_product_rule_code , 20);

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

674: BEGIN
675:
676: xla_utility_pkg.trace('> xla_product_rules_pkg.copy_product_rule_details' , 10);
677:
678: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
679: xla_utility_pkg.trace('old_product_rule_type_code = '||p_old_product_rule_type_code , 20);
680: xla_utility_pkg.trace('old_product_rule_code = '||p_old_product_rule_code , 20);
681: xla_utility_pkg.trace('new_product_rule_type_code = '||p_new_product_rule_type_code , 20);
682: xla_utility_pkg.trace('new_product_rule_code = '||p_new_product_rule_code , 20);

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

675:
676: xla_utility_pkg.trace('> xla_product_rules_pkg.copy_product_rule_details' , 10);
677:
678: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
679: xla_utility_pkg.trace('old_product_rule_type_code = '||p_old_product_rule_type_code , 20);
680: xla_utility_pkg.trace('old_product_rule_code = '||p_old_product_rule_code , 20);
681: xla_utility_pkg.trace('new_product_rule_type_code = '||p_new_product_rule_type_code , 20);
682: xla_utility_pkg.trace('new_product_rule_code = '||p_new_product_rule_code , 20);
683: xla_utility_pkg.trace('include_header_assignments = '||p_include_header_assignments , 20);

Line 680: xla_utility_pkg.trace('old_product_rule_code = '||p_old_product_rule_code , 20);

676: xla_utility_pkg.trace('> xla_product_rules_pkg.copy_product_rule_details' , 10);
677:
678: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
679: xla_utility_pkg.trace('old_product_rule_type_code = '||p_old_product_rule_type_code , 20);
680: xla_utility_pkg.trace('old_product_rule_code = '||p_old_product_rule_code , 20);
681: xla_utility_pkg.trace('new_product_rule_type_code = '||p_new_product_rule_type_code , 20);
682: xla_utility_pkg.trace('new_product_rule_code = '||p_new_product_rule_code , 20);
683: xla_utility_pkg.trace('include_header_assignments = '||p_include_header_assignments , 20);
684: xla_utility_pkg.trace('include_line_assignments = '||p_include_line_assignments , 20);

Line 681: xla_utility_pkg.trace('new_product_rule_type_code = '||p_new_product_rule_type_code , 20);

677:
678: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
679: xla_utility_pkg.trace('old_product_rule_type_code = '||p_old_product_rule_type_code , 20);
680: xla_utility_pkg.trace('old_product_rule_code = '||p_old_product_rule_code , 20);
681: xla_utility_pkg.trace('new_product_rule_type_code = '||p_new_product_rule_type_code , 20);
682: xla_utility_pkg.trace('new_product_rule_code = '||p_new_product_rule_code , 20);
683: xla_utility_pkg.trace('include_header_assignments = '||p_include_header_assignments , 20);
684: xla_utility_pkg.trace('include_line_assignments = '||p_include_line_assignments , 20);
685:

Line 682: xla_utility_pkg.trace('new_product_rule_code = '||p_new_product_rule_code , 20);

678: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
679: xla_utility_pkg.trace('old_product_rule_type_code = '||p_old_product_rule_type_code , 20);
680: xla_utility_pkg.trace('old_product_rule_code = '||p_old_product_rule_code , 20);
681: xla_utility_pkg.trace('new_product_rule_type_code = '||p_new_product_rule_type_code , 20);
682: xla_utility_pkg.trace('new_product_rule_code = '||p_new_product_rule_code , 20);
683: xla_utility_pkg.trace('include_header_assignments = '||p_include_header_assignments , 20);
684: xla_utility_pkg.trace('include_line_assignments = '||p_include_line_assignments , 20);
685:
686: l_creation_date := sysdate;

Line 683: xla_utility_pkg.trace('include_header_assignments = '||p_include_header_assignments , 20);

679: xla_utility_pkg.trace('old_product_rule_type_code = '||p_old_product_rule_type_code , 20);
680: xla_utility_pkg.trace('old_product_rule_code = '||p_old_product_rule_code , 20);
681: xla_utility_pkg.trace('new_product_rule_type_code = '||p_new_product_rule_type_code , 20);
682: xla_utility_pkg.trace('new_product_rule_code = '||p_new_product_rule_code , 20);
683: xla_utility_pkg.trace('include_header_assignments = '||p_include_header_assignments , 20);
684: xla_utility_pkg.trace('include_line_assignments = '||p_include_line_assignments , 20);
685:
686: l_creation_date := sysdate;
687: l_last_update_date := sysdate;

Line 684: xla_utility_pkg.trace('include_line_assignments = '||p_include_line_assignments , 20);

680: xla_utility_pkg.trace('old_product_rule_code = '||p_old_product_rule_code , 20);
681: xla_utility_pkg.trace('new_product_rule_type_code = '||p_new_product_rule_type_code , 20);
682: xla_utility_pkg.trace('new_product_rule_code = '||p_new_product_rule_code , 20);
683: xla_utility_pkg.trace('include_header_assignments = '||p_include_header_assignments , 20);
684: xla_utility_pkg.trace('include_line_assignments = '||p_include_line_assignments , 20);
685:
686: l_creation_date := sysdate;
687: l_last_update_date := sysdate;
688: l_created_by := xla_environment_pkg.g_usr_id;

Line 847: xla_utility_pkg.trace('< xla_product_rules_pkg.copy_product_rule_details' , 10);

843: AND product_rule_type_code = p_old_product_rule_type_code
844: AND product_rule_code = p_old_product_rule_code;
845: END IF;
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;

Line 898: xla_utility_pkg.trace('> xla_product_rules_pkg.product_rule_in_use' , 10);

894: l_assignment_exist c_assignment_exist%rowtype;
895:
896: BEGIN
897:
898: xla_utility_pkg.trace('> xla_product_rules_pkg.product_rule_in_use' , 10);
899:
900: xla_utility_pkg.trace('event = '||p_event , 20);
901: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
902: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);

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

896: BEGIN
897:
898: xla_utility_pkg.trace('> xla_product_rules_pkg.product_rule_in_use' , 10);
899:
900: xla_utility_pkg.trace('event = '||p_event , 20);
901: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
902: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
903: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
904:

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

897:
898: xla_utility_pkg.trace('> xla_product_rules_pkg.product_rule_in_use' , 10);
899:
900: xla_utility_pkg.trace('event = '||p_event , 20);
901: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
902: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
903: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
904:
905: IF p_event in ('DELETE','UPDATE','DISABLE') THEN

Line 902: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);

898: xla_utility_pkg.trace('> xla_product_rules_pkg.product_rule_in_use' , 10);
899:
900: xla_utility_pkg.trace('event = '||p_event , 20);
901: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
902: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
903: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
904:
905: IF p_event in ('DELETE','UPDATE','DISABLE') THEN
906: OPEN c_assignment_exist;

Line 903: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

899:
900: xla_utility_pkg.trace('event = '||p_event , 20);
901: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
902: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
903: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
904:
905: IF p_event in ('DELETE','UPDATE','DISABLE') THEN
906: OPEN c_assignment_exist;
907: FETCH c_assignment_exist

Line 934: xla_utility_pkg.trace('< xla_product_rules_pkg.product_rule_in_use' , 10);

930:
931: p_accounting_method_name := l_accounting_method_name;
932: p_accounting_method_type := l_accounting_method_type;
933:
934: xla_utility_pkg.trace('< xla_product_rules_pkg.product_rule_in_use' , 10);
935:
936: return l_return;
937:
938: EXCEPTION

Line 990: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_description' , 10);

986: l_source_type varchar2(80) := null;
987:
988: BEGIN
989:
990: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_description' , 10);
991:
992: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
993: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
994: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

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

988: BEGIN
989:
990: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_description' , 10);
991:
992: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
993: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
994: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
995: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
996: xla_utility_pkg.trace('description_code = '||p_description_code , 20);

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

989:
990: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_description' , 10);
991:
992: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
993: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
994: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
995: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
996: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
997:

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

990: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_header_description' , 10);
991:
992: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
993: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
994: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
995: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
996: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
997:
998: l_application_id := p_application_id;

Line 995: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);

991:
992: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
993: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
994: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
995: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
996: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
997:
998: l_application_id := p_application_id;
999: l_entity_code := p_entity_code;

Line 996: xla_utility_pkg.trace('description_code = '||p_description_code , 20);

992: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
993: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
994: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
995: xla_utility_pkg.trace('description_type_code = '||p_description_type_code , 20);
996: xla_utility_pkg.trace('description_code = '||p_description_code , 20);
997:
998: l_application_id := p_application_id;
999: l_entity_code := p_entity_code;
1000: l_event_class_code := p_event_class_code;

Line 1021: xla_utility_pkg.trace('< xla_product_rules_pkg.invalid_header_description' , 10);

1017: ELSE
1018: l_return := 'FALSE';
1019: END IF;
1020:
1021: xla_utility_pkg.trace('< xla_product_rules_pkg.invalid_header_description' , 10);
1022:
1023: return l_return;
1024:
1025: EXCEPTION

Line 1070: xla_utility_pkg.trace('> xla_product_rules_pkg.uncompile_product_rule' , 10);

1066: FOR UPDATE of compile_status_code NOWAIT;
1067:
1068: BEGIN
1069:
1070: xla_utility_pkg.trace('> xla_product_rules_pkg.uncompile_product_rule' , 10);
1071:
1072: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1073: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
1074: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

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

1068: BEGIN
1069:
1070: xla_utility_pkg.trace('> xla_product_rules_pkg.uncompile_product_rule' , 10);
1071:
1072: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1073: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
1074: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
1075:
1076: OPEN c_prod_rules;

Line 1073: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);

1069:
1070: xla_utility_pkg.trace('> xla_product_rules_pkg.uncompile_product_rule' , 10);
1071:
1072: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1073: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
1074: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
1075:
1076: OPEN c_prod_rules;
1077: FETCH c_prod_rules INTO l_exist;

Line 1074: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

1070: xla_utility_pkg.trace('> xla_product_rules_pkg.uncompile_product_rule' , 10);
1071:
1072: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1073: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
1074: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
1075:
1076: OPEN c_prod_rules;
1077: FETCH c_prod_rules INTO l_exist;
1078: IF c_prod_rules%found then

Line 1090: xla_utility_pkg.trace('< xla_product_rules_pkg.uncompile_product_rule' , 10);

1086: l_return := FALSE;
1087: END IF;
1088: CLOSE c_prod_rules;
1089:
1090: xla_utility_pkg.trace('< xla_product_rules_pkg.uncompile_product_rule' , 10);
1091:
1092: return l_return;
1093:
1094: EXCEPTION

Line 1137: xla_utility_pkg.trace('> xla_product_rules_pkg.set_compile_status' , 10);

1133: FOR UPDATE of compile_status_code NOWAIT;
1134:
1135: BEGIN
1136:
1137: xla_utility_pkg.trace('> xla_product_rules_pkg.set_compile_status' , 10);
1138:
1139: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1140: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
1141: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

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

1135: BEGIN
1136:
1137: xla_utility_pkg.trace('> xla_product_rules_pkg.set_compile_status' , 10);
1138:
1139: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1140: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
1141: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
1142:
1143: OPEN c_prod_rules;

Line 1140: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);

1136:
1137: xla_utility_pkg.trace('> xla_product_rules_pkg.set_compile_status' , 10);
1138:
1139: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1140: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
1141: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
1142:
1143: OPEN c_prod_rules;
1144: FETCH c_prod_rules

Line 1141: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);

1137: xla_utility_pkg.trace('> xla_product_rules_pkg.set_compile_status' , 10);
1138:
1139: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1140: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
1141: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
1142:
1143: OPEN c_prod_rules;
1144: FETCH c_prod_rules
1145: INTO l_exist;

Line 1158: xla_utility_pkg.trace('< xla_product_rules_pkg.set_compile_status' , 10);

1154: l_return := FALSE;
1155: END IF;
1156: CLOSE c_prod_rules;
1157:
1158: xla_utility_pkg.trace('< xla_product_rules_pkg.set_compile_status' , 10);
1159:
1160: return l_return;
1161:
1162: EXCEPTION

Line 1199: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_analytical' , 10);

1195: l_source_type VARCHAR2(80) := null;
1196:
1197: BEGIN
1198:
1199: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_analytical' , 10);
1200:
1201: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1202: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1203: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);

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

1197: BEGIN
1198:
1199: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_analytical' , 10);
1200:
1201: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1202: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1203: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);
1204: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);
1205:

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

1198:
1199: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_analytical' , 10);
1200:
1201: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1202: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1203: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);
1204: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);
1205:
1206: --

Line 1203: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);

1199: xla_utility_pkg.trace('> xla_product_rules_pkg.invalid_hdr_analytical' , 10);
1200:
1201: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1202: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1203: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);
1204: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);
1205:
1206: --
1207: -- call invalid_hdr_analytical to see if header analytical criteria is invalid

Line 1204: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);

1200:
1201: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1202: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1203: xla_utility_pkg.trace('analytical_criterion_type_code = '||p_anal_criterion_type_code , 20);
1204: xla_utility_pkg.trace('analytical_criterion_code = '||p_analytical_criterion_code , 20);
1205:
1206: --
1207: -- call invalid_hdr_analytical to see if header analytical criteria is invalid
1208: --

Line 1221: xla_utility_pkg.trace('< xla_product_rules_pkg.invalid_hdr_analytical' , 10);

1217: ELSE
1218: l_return := 'FALSE';
1219: END IF;
1220:
1221: xla_utility_pkg.trace('< xla_product_rules_pkg.invalid_hdr_analytical' , 10);
1222:
1223: return l_return;
1224:
1225: EXCEPTION

Line 1288: xla_utility_pkg.trace('> xla_product_rules_pkg.create_accounting_attributes' , 10);

1284: AND l.assignment_level_code = 'EVT_CLASS_AAD';
1285:
1286: BEGIN
1287:
1288: xla_utility_pkg.trace('> xla_product_rules_pkg.create_accounting_attributes' , 10);
1289:
1290: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1291: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1292:

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

1286: BEGIN
1287:
1288: xla_utility_pkg.trace('> xla_product_rules_pkg.create_accounting_attributes' , 10);
1289:
1290: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1291: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1292:
1293: OPEN c_acct_sources;
1294: FETCH c_acct_sources

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

1287:
1288: xla_utility_pkg.trace('> xla_product_rules_pkg.create_accounting_attributes' , 10);
1289:
1290: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1291: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1292:
1293: OPEN c_acct_sources;
1294: FETCH c_acct_sources
1295: INTO l_exist;

Line 1387: xla_utility_pkg.trace('< xla_product_rules_pkg.create_accounting_attributes' , 10);

1383:
1384: END IF;
1385: CLOSE c_acct_sources;
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;

Line 1439: xla_utility_pkg.trace('> xla_product_rules_pkg.get_default_attr_assignment' , 10);

1435: AND l.lookup_type (+) = 'XLA_SOURCE_TYPE';
1436:
1437: BEGIN
1438:
1439: xla_utility_pkg.trace('> xla_product_rules_pkg.get_default_attr_assignment' , 10);
1440:
1441: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1442: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1443:

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

1437: BEGIN
1438:
1439: xla_utility_pkg.trace('> xla_product_rules_pkg.get_default_attr_assignment' , 10);
1440:
1441: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1442: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1443:
1444: OPEN c_dflt_source;
1445: FETCH c_dflt_source

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

1438:
1439: xla_utility_pkg.trace('> xla_product_rules_pkg.get_default_attr_assignment' , 10);
1440:
1441: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1442: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
1443:
1444: OPEN c_dflt_source;
1445: FETCH c_dflt_source
1446: INTO p_source_application_id, p_source_type_code, p_source_code,

Line 1458: xla_utility_pkg.trace('< xla_product_rules_pkg.get_default_attr_assignment' , 10);

1454:
1455: END IF;
1456: CLOSE c_dflt_source;
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;

Line 1514: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);

1510: l_locked_aad c_locked_aads%rowtype;
1511:
1512: BEGIN
1513:
1514: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);
1515:
1516: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1517:
1518: OPEN c_locked_aads;

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

1512: BEGIN
1513:
1514: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);
1515:
1516: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1517:
1518: OPEN c_locked_aads;
1519: FETCH c_locked_aads INTO l_locked_aad;
1520: IF (c_locked_aads%FOUND) THEN

Line 1574: xla_utility_pkg.trace('< xla_event_classes_pkg.uncompile_definitions' , 10);

1570: x_event_class_name := l_event_class_name;
1571: x_event_type_name := l_event_type_name;
1572: x_locking_status_flag := l_locking_status_flag;
1573:
1574: xla_utility_pkg.trace('< xla_event_classes_pkg.uncompile_definitions' , 10);
1575:
1576: return l_return;
1577:
1578: EXCEPTION