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_LINE_TYPES_PKG dependencies on XLA_LINE_TYPES_PKG

Line 1: PACKAGE BODY xla_line_types_pkg AS

1: PACKAGE BODY xla_line_types_pkg AS
2: /* $Header: xlaamdlt.pkb 120.31 2006/02/15 19:51:51 dcshah ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_line_types_pkg |

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

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 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 123: (p_location => 'xla_line_types_pkg.delete_line_type_details');

119: WHEN xla_exceptions_pkg.application_exception THEN
120: RAISE;
121: WHEN OTHERS THEN
122: xla_exceptions_pkg.raise_message
123: (p_location => 'xla_line_types_pkg.delete_line_type_details');
124:
125: END delete_line_type_details;
126:
127: /*======================================================================+

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 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 406: (p_location => 'xla_line_types_pkg.copy_line_type_details');

402: IF c_conditions%ISOPEN THEN
403: CLOSE c_conditions;
404: END IF;
405: xla_exceptions_pkg.raise_message
406: (p_location => 'xla_line_types_pkg.copy_line_type_details');
407:
408: END copy_line_type_details;
409:
410: /*======================================================================+

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 595: ,'LOCATION' ,'xla_line_types_pkg.line_type_in_use');

591: ELSE
592: xla_exceptions_pkg.raise_message
593: ('XLA' ,'XLA_COMMON_ERROR'
594: ,'ERROR' ,'Invalid event passed'
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);

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 622: (p_location => 'xla_line_types_pkg.line_type_in_use');

618: CLOSE c_active_assignment_exist;
619: END IF;
620:
621: xla_exceptions_pkg.raise_message
622: (p_location => 'xla_line_types_pkg.line_type_in_use');
623:
624: END line_type_in_use;
625:
626: /*======================================================================+

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 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 727: (p_location => 'xla_line_types_pkg.line_type_is_invalid');

723: RAISE;
724:
725: WHEN OTHERS THEN
726: xla_exceptions_pkg.raise_message
727: (p_location => 'xla_line_types_pkg.line_type_is_invalid');
728:
729: END line_type_is_invalid;
730:
731: /*======================================================================+

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 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 817: (p_location => 'xla_line_types_pkg.line_type_is_locked');

813: CLOSE c_frozen_assignment_exist;
814: END IF;
815:
816: xla_exceptions_pkg.raise_message
817: (p_location => 'xla_line_types_pkg.line_type_is_locked');
818:
819: END line_type_is_locked;
820:
821: /* ---------------------------------------------------------------------

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 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 862: (p_location => 'xla_line_types_pkg.delete_non_gain_acct_attrs');

858: WHEN xla_exceptions_pkg.application_exception THEN
859: RAISE;
860: WHEN OTHERS THEN
861: xla_exceptions_pkg.raise_message
862: (p_location => 'xla_line_types_pkg.delete_non_gain_acct_attrs');
863: END delete_non_gain_acct_attrs;
864:
865:
866: /* ---------------------------------------------------------------------

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 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 985: (p_location => 'xla_line_types_pkg.insert_non_gain_acct_attrs');

981: WHEN xla_exceptions_pkg.application_exception THEN
982: RAISE;
983: WHEN OTHERS THEN
984: xla_exceptions_pkg.raise_message
985: (p_location => 'xla_line_types_pkg.insert_non_gain_acct_attrs');
986:
987: END insert_non_gain_acct_attrs;
988:
989: /* ---------------------------------------------------------------------

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 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 1047: (p_location => 'xla_line_types_pkg.non_gain_acct_attrs_exists');

1043: WHEN xla_exceptions_pkg.application_exception THEN
1044: RAISE;
1045: WHEN OTHERS THEN
1046: xla_exceptions_pkg.raise_message
1047: (p_location => 'xla_line_types_pkg.non_gain_acct_attrs_exists');
1048: END non_gain_acct_attrs_exists;
1049:
1050:
1051:

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

1315: WHEN xla_exceptions_pkg.application_exception THEN
1316: RAISE;
1317: WHEN OTHERS THEN
1318: xla_exceptions_pkg.raise_message
1319: (p_location => 'xla_line_types_pkg.create_accounting_attributes');
1320:
1321: END create_accounting_attributes;
1322:
1323: /*======================================================================+

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 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 1558: (p_location => 'xla_line_types_pkg.uncompile_definitions');

1554: CLOSE c_locked_aads;
1555: END IF;
1556:
1557: xla_exceptions_pkg.raise_message
1558: (p_location => 'xla_line_types_pkg.uncompile_definitions');
1559:
1560: END uncompile_definitions;
1561:
1562: /*======================================================================+

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

1625: WHEN xla_exceptions_pkg.application_exception THEN
1626: RAISE;
1627: WHEN OTHERS THEN
1628: xla_exceptions_pkg.raise_message
1629: (p_location => 'xla_line_types_pkg.get_default_attr_assignment');
1630:
1631: END get_default_attr_assignment;
1632:
1633: /*======================================================================+

Line 1797: (p_location => 'xla_line_types_pkg.Chk_line_accting_sources');

1793:
1794: WHEN OTHERS THEN
1795:
1796: xla_exceptions_pkg.raise_message
1797: (p_location => 'xla_line_types_pkg.Chk_line_accting_sources');
1798:
1799: END Chk_line_accting_sources;
1800:
1801: /*======================================================================+

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 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 1977: (p_location => 'xla_line_types_pkg.check_copy_line_type_details');

1973: IF c_conditions%ISOPEN THEN
1974: CLOSE c_conditions;
1975: END IF;
1976: xla_exceptions_pkg.raise_message
1977: (p_location => 'xla_line_types_pkg.check_copy_line_type_details');
1978:
1979: END check_copy_line_type_details;
1980:
1981: /*======================================================================+

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 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 2104: (p_location => 'xla_line_types_pkg.update_acct_attrs');

2100: WHEN xla_exceptions_pkg.application_exception THEN
2101: RAISE;
2102: WHEN OTHERS THEN
2103: xla_exceptions_pkg.raise_message
2104: (p_location => 'xla_line_types_pkg.update_acct_attrs');
2105:
2106: END update_acct_attrs;
2107:
2108: /*======================================================================+

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:

Line 2242: (p_location => 'xla_line_types_pkg.mpa_line_type_in_use');

2238: CLOSE c_assignment_exist;
2239: END IF;
2240:
2241: xla_exceptions_pkg.raise_message
2242: (p_location => 'xla_line_types_pkg.mpa_line_type_in_use');
2243:
2244: END mpa_line_type_in_use;
2245:
2246: END xla_line_types_pkg;

Line 2246: END xla_line_types_pkg;

2242: (p_location => 'xla_line_types_pkg.mpa_line_type_in_use');
2243:
2244: END mpa_line_type_in_use;
2245:
2246: END xla_line_types_pkg;