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_EVT_CLASS_ACCT_ATTRS_PKG dependencies on XLA_EVT_CLASS_ACCT_ATTRS_PKG

Line 1: PACKAGE BODY xla_evt_class_acct_attrs_pkg AS

1: PACKAGE BODY xla_evt_class_acct_attrs_pkg AS
2: /* $Header: xlaamaaa.pkb 120.13 2006/09/29 18:03:35 dcshah ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_evt_class_acct_attrs_pkg |

5: | Redwood Shores, CA, USA |
6: | ALL rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_evt_class_acct_attrs_pkg |
10: | |
11: | DESCRIPTION |
12: | XLA Event CLASS Acct Attrs PACKAGE |
13: | |

Line 41: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_evt_class_acct_attrs_pkg';

37: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
38: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
39: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
40: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
41: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_evt_class_acct_attrs_pkg';
42:
43: -------------------------------------------------------------------------------
44: -- Debug variables
45: -------------------------------------------------------------------------------

Line 75: (p_location => 'xla_evt_class_acct_attrs_pkg.trace');

71: WHEN xla_exceptions_pkg.application_exception THEN
72: RAISE;
73: WHEN OTHERS THEN
74: xla_exceptions_pkg.raise_message
75: (p_location => 'xla_evt_class_acct_attrs_pkg.trace');
76: END trace;
77:
78: /*======================================================================+
79: | |

Line 140: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line' , 10);

136: FOR UPDATE NOWAIT;
137:
138: BEGIN
139:
140: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line' , 10);
141:
142: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
143: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
144:

Line 244: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line' , 10);

240: x_event_class_name := l_event_class_name;
241: x_event_type_name := l_event_type_name;
242: x_locking_status_flag := l_locking_status_flag;
243:
244: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line' , 10);
245:
246: RETURN l_return;
247:
248: EXCEPTION

Line 261: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line');

257: CLOSE c_lock_aads;
258: END IF;
259:
260: xla_exceptions_pkg.raise_message
261: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line');
262:
263: END uncompile_defn_with_line;
264:
265:

Line 329: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line_acct' , 10);

325: FOR UPDATE NOWAIT;
326:
327: BEGIN
328:
329: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line_acct' , 10);
330:
331: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
332: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
333:

Line 457: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line_acct' , 10);

453: x_event_class_name := l_event_class_name;
454: x_event_type_name := l_event_type_name;
455: x_locking_status_flag := l_locking_status_flag;
456:
457: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line_acct' , 10);
458:
459: RETURN l_return;
460:
461: EXCEPTION

Line 474: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line_acct');

470: CLOSE c_lock_aads;
471: END IF;
472:
473: xla_exceptions_pkg.raise_message
474: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_line_acct');
475:
476: END uncompile_defn_with_line_acct;
477:
478:

Line 552: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt' , 10);

548: FOR UPDATE NOWAIT;
549:
550: BEGIN
551:
552: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt' , 10);
553:
554: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
555: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
556: xla_utility_pkg.trace('accounting_attribute_code = '||p_accounting_attribute_code , 20);

Line 686: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt' , 10);

682: x_event_class_name := l_event_class_name;
683: x_event_type_name := l_event_type_name;
684: x_locking_status_flag := l_locking_status_flag;
685:
686: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt' , 10);
687:
688: RETURN l_return;
689:
690: EXCEPTION

Line 703: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt');

699: CLOSE c_lock_aads;
700: END IF;
701:
702: xla_exceptions_pkg.raise_message
703: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt');
704:
705: END uncompile_defn_with_jlt;
706:
707: /*======================================================================+

Line 760: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_default' , 10);

756: FOR UPDATE NOWAIT;
757:
758: BEGIN
759:
760: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_default' , 10);
761:
762: l_return := TRUE;
763:
764: FOR l_lock_aad IN c_lock_aads LOOP

Line 840: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_default' , 10);

836: x_event_class_name := l_event_class_name;
837: x_event_type_name := l_event_type_name;
838: x_locking_status_flag := l_locking_status_flag;
839:
840: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_default' , 10);
841:
842: RETURN l_return;
843:
844: EXCEPTION

Line 857: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_default');

853: CLOSE c_lock_aads;
854: END IF;
855:
856: xla_exceptions_pkg.raise_message
857: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_default');
858:
859: END uncompile_defn_with_default;
860:
861:

Line 943: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt_source' , 10);

939: FOR UPDATE NOWAIT;
940:
941: BEGIN
942:
943: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt_source' , 10);
944:
945: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
946: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
947:

Line 1089: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt_source' , 10);

1085: x_event_class_name := l_event_class_name;
1086: x_event_type_name := l_event_type_name;
1087: x_locking_status_flag := l_locking_status_flag;
1088:
1089: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt_source' , 10);
1090:
1091: RETURN l_return;
1092:
1093: EXCEPTION

Line 1106: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt_source');

1102: CLOSE c_lock_aads;
1103: END IF;
1104:
1105: xla_exceptions_pkg.raise_message
1106: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_defn_with_jlt_source');
1107:
1108: END uncompile_defn_with_jlt_source;
1109: /*======================================================================+
1110: | |

Line 1239: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_evt_class_aads');

1235: WHEN xla_exceptions_pkg.application_exception THEN
1236: RAISE;
1237: WHEN OTHERS THEN
1238: xla_exceptions_pkg.raise_message
1239: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_evt_class_aads');
1240: END uncompile_evt_class_aads;
1241:
1242: /*======================================================================+
1243: | |

Line 1287: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_aads' , 10);

1283: FOR UPDATE NOWAIT;
1284:
1285: BEGIN
1286:
1287: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_aads' , 10);
1288:
1289: l_return := TRUE;
1290:
1291: FOR l_lock_aad IN c_lock_aads LOOP

Line 1350: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_aads' , 10);

1346: x_event_class_name := l_event_class_name;
1347: x_event_type_name := l_event_type_name;
1348: x_locking_status_flag := l_locking_status_flag;
1349:
1350: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_aads' , 10);
1351:
1352: RETURN l_return;
1353:
1354: EXCEPTION

Line 1367: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_aads');

1363: CLOSE c_lock_aads;
1364: END IF;
1365:
1366: xla_exceptions_pkg.raise_message
1367: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_aads');
1368:
1369: END uncompile_aads;
1370:
1371:

Line 1435: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_aads_with_source' , 10);

1431: FOR UPDATE NOWAIT;
1432:
1433: BEGIN
1434:
1435: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.uncompile_aads_with_source' , 10);
1436:
1437: l_return := TRUE;
1438:
1439: FOR l_lock_aad IN c_lock_aads LOOP

Line 1523: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_aads_with_source' , 10);

1519: x_event_class_name := l_event_class_name;
1520: x_event_type_name := l_event_type_name;
1521: x_locking_status_flag := l_locking_status_flag;
1522:
1523: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.uncompile_aads_with_source' , 10);
1524:
1525: RETURN l_return;
1526:
1527: EXCEPTION

Line 1540: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_aads_with_source');

1536: CLOSE c_lock_aads;
1537: END IF;
1538:
1539: xla_exceptions_pkg.raise_message
1540: (p_location => 'xla_evt_class_acct_attrs_pkg.uncompile_aads_with_source');
1541:
1542: END uncompile_aads_with_source;
1543:
1544:

Line 1648: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.insert_jlt_assignments' , 10);

1644:
1645: l_prior_entry_line_types c_prior_entry_line_types%ROWTYPE;
1646:
1647: BEGIN
1648: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.insert_jlt_assignments' , 10);
1649:
1650: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1651: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
1652:

Line 1864: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.insert_jlt_assignments' , 10);

1860: CLOSE c_prior_entry_line_types;
1861:
1862: END IF;
1863:
1864: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.insert_jlt_assignments' , 10);
1865:
1866: p_product_rule_name := l_product_rule_name;
1867: p_product_rule_type := l_product_rule_type;
1868: p_event_class_name := l_event_class_name;

Line 1878: (p_location => 'xla_evt_class_acct_attrs_pkg.insert_jlt_assignments');

1874: WHEN xla_exceptions_pkg.application_exception THEN
1875: RAISE;
1876: WHEN OTHERS THEN
1877: xla_exceptions_pkg.raise_message
1878: (p_location => 'xla_evt_class_acct_attrs_pkg.insert_jlt_assignments');
1879:
1880: END insert_jlt_assignments;
1881:
1882: /*======================================================================+

Line 1963: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.update_jlt_assignments' , 10);

1959:
1960: l_non_pe_line_types c_non_pe_line_types%ROWTYPE;
1961:
1962: BEGIN
1963: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.update_jlt_assignments' , 10);
1964:
1965: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1966: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
1967:

Line 2066: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.update_jlt_assignments' , 10);

2062: AND source_code = p_source_code;
2063:
2064: END IF;
2065:
2066: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.update_jlt_assignments' , 10);
2067:
2068: p_product_rule_name := l_product_rule_name;
2069: p_product_rule_type := l_product_rule_type;
2070: p_event_class_name := l_event_class_name;

Line 2080: (p_location => 'xla_evt_class_acct_attrs_pkg.update_jlt_assignments');

2076: WHEN xla_exceptions_pkg.application_exception THEN
2077: RAISE;
2078: WHEN OTHERS THEN
2079: xla_exceptions_pkg.raise_message
2080: (p_location => 'xla_evt_class_acct_attrs_pkg.update_jlt_assignments');
2081:
2082: END update_jlt_assignments;
2083:
2084: /*======================================================================+

Line 2135: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.delete_jlt_assignments' , 10);

2131: AND event_class_code = p_event_class_code
2132: AND accounting_attribute_code = p_accounting_attribute_code;
2133:
2134: BEGIN
2135: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.delete_jlt_assignments' , 10);
2136:
2137: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2138: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
2139:

Line 2195: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.delete_jlt_assignments' , 10);

2191: AND source_code = p_source_code;
2192:
2193: END IF;
2194: CLOSE c_last_assignment;
2195: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.delete_jlt_assignments' , 10);
2196:
2197: p_product_rule_name := l_product_rule_name;
2198: p_product_rule_type := l_product_rule_type;
2199: p_event_class_name := l_event_class_name;

Line 2208: (p_location => 'xla_evt_class_acct_attrs_pkg.delete_jlt_assignments');

2204: WHEN xla_exceptions_pkg.application_exception THEN
2205: RAISE;
2206: WHEN OTHERS THEN
2207: xla_exceptions_pkg.raise_message
2208: (p_location => 'xla_evt_class_acct_attrs_pkg.delete_jlt_assignments');
2209:
2210: END delete_jlt_assignments;
2211:
2212: /*======================================================================+

Line 2280: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.insert_aad_assignments' , 10);

2276: WHERE application_id = p_application_id
2277: AND event_class_code = p_event_class_code;
2278:
2279: BEGIN
2280: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.insert_aad_assignments' , 10);
2281:
2282: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2283: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
2284:

Line 2447: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.insert_aad_assignments' , 10);

2443: CLOSE c_aad_assgn_exist;
2444:
2445: END IF;
2446:
2447: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.insert_aad_assignments' , 10);
2448:
2449: p_product_rule_name := l_product_rule_name;
2450: p_product_rule_type := l_product_rule_type;
2451: p_event_class_name := l_event_class_name;

Line 2461: (p_location => 'xla_evt_class_acct_attrs_pkg.insert_aad_assignments');

2457: WHEN xla_exceptions_pkg.application_exception THEN
2458: RAISE;
2459: WHEN OTHERS THEN
2460: xla_exceptions_pkg.raise_message
2461: (p_location => 'xla_evt_class_acct_attrs_pkg.insert_aad_assignments');
2462:
2463: END insert_aad_assignments;
2464:
2465: /*======================================================================+

Line 2507: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.update_aad_assignments' , 10);

2503: l_event_class_code VARCHAR2(30);
2504: l_validation_status_code VARCHAR2(30);
2505:
2506: BEGIN
2507: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.update_aad_assignments' , 10);
2508:
2509: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2510: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
2511:

Line 2569: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.update_aad_assignments' , 10);

2565: AND source_code = p_source_code;
2566:
2567: END IF;
2568:
2569: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.update_aad_assignments' , 10);
2570:
2571: p_product_rule_name := l_product_rule_name;
2572: p_product_rule_type := l_product_rule_type;
2573: p_event_class_name := l_event_class_name;

Line 2583: (p_location => 'xla_evt_class_acct_attrs_pkg.update_aad_assignments');

2579: WHEN xla_exceptions_pkg.application_exception THEN
2580: RAISE;
2581: WHEN OTHERS THEN
2582: xla_exceptions_pkg.raise_message
2583: (p_location => 'xla_evt_class_acct_attrs_pkg.update_aad_assignments');
2584:
2585: END update_aad_assignments;
2586:
2587: /*======================================================================+

Line 2637: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.delete_aad_assignments' , 10);

2633: AND event_class_code = p_event_class_code
2634: AND accounting_attribute_code = p_accounting_attribute_code;
2635:
2636: BEGIN
2637: xla_utility_pkg.trace('> xla_evt_class_acct_attrs_pkg.delete_aad_assignments' , 10);
2638:
2639: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
2640: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
2641:

Line 2696: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.delete_aad_assignments' , 10);

2692: AND source_code = p_source_code;
2693:
2694: END IF;
2695: CLOSE c_last_assignment;
2696: xla_utility_pkg.trace('< xla_evt_class_acct_attrs_pkg.delete_aad_assignments' , 10);
2697:
2698: p_product_rule_name := l_product_rule_name;
2699: p_product_rule_type := l_product_rule_type;
2700: p_event_class_name := l_event_class_name;

Line 2709: (p_location => 'xla_evt_class_acct_attrs_pkg.delete_aad_assignments');

2705: WHEN xla_exceptions_pkg.application_exception THEN
2706: RAISE;
2707: WHEN OTHERS THEN
2708: xla_exceptions_pkg.raise_message
2709: (p_location => 'xla_evt_class_acct_attrs_pkg.delete_aad_assignments');
2710:
2711: END delete_aad_assignments;
2712: --=============================================================================
2713: --

Line 2735: END xla_evt_class_acct_attrs_pkg;

2731:
2732: IF NOT g_log_enabled THEN
2733: g_log_level := C_LEVEL_LOG_DISABLED;
2734: END IF;
2735: END xla_evt_class_acct_attrs_pkg;