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_PRODUCT_RULES_PKG

Line 1: PACKAGE BODY xla_product_rules_pkg AS

1: PACKAGE BODY xla_product_rules_pkg AS
2: /* $Header: xlaampad.pkb 120.48 2006/02/22 22:35:33 dcshah ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_product_rules_pkg |

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

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 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 102: (p_location => 'xla_product_rules_pkg.is_accounting_reversal');

98:
99: WHEN OTHERS THEN
100:
101: xla_exceptions_pkg.raise_message
102: (p_location => 'xla_product_rules_pkg.is_accounting_reversal');
103:
104: END is_accounting_reversal;
105:
106: /*======================================================================+

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 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 265: (p_location => 'xla_product_rules_pkg.invalid_hdr_ac');

261:
262: WHEN OTHERS THEN
263:
264: xla_exceptions_pkg.raise_message
265: (p_location => 'xla_product_rules_pkg.invalid_hdr_ac');
266:
267: END invalid_hdr_ac;
268:
269: /*======================================================================+

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 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 515: (p_location => 'xla_product_rules_pkg.invalid_header_desc');

511: CLOSE c_desc_detail_sources;
512: END IF;
513:
514: xla_exceptions_pkg.raise_message
515: (p_location => 'xla_product_rules_pkg.invalid_header_desc');
516:
517: END invalid_header_desc;
518:
519: /*======================================================================+

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 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 579: (p_location => 'xla_product_rules_pkg.delete_product_rule_details');

575: WHEN xla_exceptions_pkg.application_exception THEN
576: RAISE;
577: WHEN OTHERS THEN
578: xla_exceptions_pkg.raise_message
579: (p_location => 'xla_product_rules_pkg.delete_product_rule_details');
580:
581: END delete_product_rule_details;
582:
583: /*======================================================================+

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 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 644: (p_location => 'xla_product_rules_pkg.delete_prod_header_details');

640: WHEN xla_exceptions_pkg.application_exception THEN
641: RAISE;
642: WHEN OTHERS THEN
643: xla_exceptions_pkg.raise_message
644: (p_location => 'xla_product_rules_pkg.delete_prod_header_details');
645:
646: END delete_prod_header_details;
647:
648: /*======================================================================+

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 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 855: (p_location => 'xla_product_rules_pkg.copy_product_rule_details');

851: RAISE;
852:
853: WHEN OTHERS THEN
854: xla_exceptions_pkg.raise_message
855: (p_location => 'xla_product_rules_pkg.copy_product_rule_details');
856:
857: END copy_product_rule_details;
858:
859: /*======================================================================+

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 927: ,'LOCATION' ,'xla_product_rules_pkg.product_rule_in_use');

923: ELSE
924: xla_exceptions_pkg.raise_message
925: ('XLA' ,'XLA_COMMON_ERROR'
926: ,'ERROR' ,'Invalid event passed'
927: ,'LOCATION' ,'xla_product_rules_pkg.product_rule_in_use');
928:
929: END IF;
930:
931: p_accounting_method_name := l_accounting_method_name;

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 951: (p_location => 'xla_product_rules_pkg.product_rule_in_use');

947: CLOSE c_assignment_exist;
948: END IF;
949:
950: xla_exceptions_pkg.raise_message
951: (p_location => 'xla_product_rules_pkg.product_rule_in_use');
952:
953: END product_rule_in_use;
954:
955: /*======================================================================+

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 1008: IF xla_product_rules_pkg.invalid_header_desc

1004:
1005: --
1006: -- call invalid_header_desc to see if description is invalid
1007: --
1008: IF xla_product_rules_pkg.invalid_header_desc
1009: (p_application_id => l_application_id
1010: ,p_amb_context_code => l_amb_context_code
1011: ,p_entity_code => l_entity_code
1012: ,p_event_class_code => l_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 1031: (p_location => 'xla_product_rules_pkg.invalid_header_description');

1027: RAISE;
1028:
1029: WHEN OTHERS THEN
1030: xla_exceptions_pkg.raise_message
1031: (p_location => 'xla_product_rules_pkg.invalid_header_description');
1032:
1033: END invalid_header_description;
1034:
1035: /*======================================================================+

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 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 1099: (p_location => 'xla_product_rules_pkg.uncompile_product_rule');

1095: WHEN xla_exceptions_pkg.application_exception THEN
1096: RAISE;
1097: WHEN OTHERS THEN
1098: xla_exceptions_pkg.raise_message
1099: (p_location => 'xla_product_rules_pkg.uncompile_product_rule');
1100:
1101: END uncompile_product_rule;
1102:
1103: /*======================================================================+

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 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 1167: (p_location => 'xla_product_rules_pkg.set_compile_status');

1163: WHEN xla_exceptions_pkg.application_exception THEN
1164: RAISE;
1165: WHEN OTHERS THEN
1166: xla_exceptions_pkg.raise_message
1167: (p_location => 'xla_product_rules_pkg.set_compile_status');
1168:
1169: END set_compile_status;
1170:
1171: /*======================================================================+

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 1209: IF xla_product_rules_pkg.invalid_hdr_ac

1205:
1206: --
1207: -- call invalid_hdr_analytical to see if header analytical criteria is invalid
1208: --
1209: IF xla_product_rules_pkg.invalid_hdr_ac
1210: (p_application_id => p_application_id
1211: ,p_amb_context_code => p_amb_context_code
1212: ,p_event_class_code => p_event_class_code
1213: ,p_anal_criterion_type_code => p_anal_criterion_type_code

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 1232: (p_location => 'xla_product_rules_pkg.invalid_hdr_analytical');

1228:
1229: WHEN OTHERS THEN
1230:
1231: xla_exceptions_pkg.raise_message
1232: (p_location => 'xla_product_rules_pkg.invalid_hdr_analytical');
1233:
1234: END invalid_hdr_analytical;
1235:
1236: /*======================================================================+

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 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 1394: (p_location => 'xla_product_rules_pkg.create_accounting_attributes');

1390: WHEN xla_exceptions_pkg.application_exception THEN
1391: RAISE;
1392: WHEN OTHERS THEN
1393: xla_exceptions_pkg.raise_message
1394: (p_location => 'xla_product_rules_pkg.create_accounting_attributes');
1395:
1396: END create_accounting_attributes;
1397:
1398: /*======================================================================+

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 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 1465: (p_location => 'xla_product_rules_pkg.get_default_attr_assignment');

1461: WHEN xla_exceptions_pkg.application_exception THEN
1462: RAISE;
1463: WHEN OTHERS THEN
1464: xla_exceptions_pkg.raise_message
1465: (p_location => 'xla_product_rules_pkg.get_default_attr_assignment');
1466:
1467: END get_default_attr_assignment;
1468:
1469: /*======================================================================+

Line 1603: END xla_product_rules_pkg;

1599: g_created_by := xla_environment_pkg.g_usr_id;
1600: g_last_update_login := xla_environment_pkg.g_login_id;
1601: g_last_updated_by := xla_environment_pkg.g_usr_id;
1602:
1603: END xla_product_rules_pkg;