DBA Data[Home] [Help]

APPS.XLA_EVT_CLASS_ACCT_ATTRS_PKG dependencies on XLA_UTILITY_PKG

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 142: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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:
145: l_return := TRUE;
146:

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

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:
145: l_return := TRUE;
146:
147: FOR l_lock_aad IN c_lock_aads LOOP

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 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 331: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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:
334: l_return := TRUE;
335:

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

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:
334: l_return := TRUE;
335:
336: FOR l_lock_aad IN c_lock_aads LOOP

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 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 554: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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);
557:
558: l_return := TRUE;

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

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);
557:
558: l_return := TRUE;
559:

Line 556: xla_utility_pkg.trace('accounting_attribute_code = '||p_accounting_attribute_code , 20);

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);
557:
558: l_return := TRUE;
559:
560: FOR l_lock_aad IN c_lock_aads LOOP

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 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 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 945: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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:
948: l_return := TRUE;
949:

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

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:
948: l_return := TRUE;
949:
950: FOR l_lock_aad IN c_lock_aads LOOP

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 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 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 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 1650: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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:
1653:
1654: IF p_default_flag = 'Y' THEN

Line 1651: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);

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:
1653:
1654: IF p_default_flag = 'Y' THEN
1655:

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 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 1965: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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:
1968: IF p_default_flag = 'Y' THEN
1969:

Line 1966: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);

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:
1968: IF p_default_flag = 'Y' THEN
1969:
1970: -- Check if accounting attribute is inherited

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 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 2137: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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:
2140: OPEN c_last_assignment;
2141: FETCH c_last_assignment

Line 2138: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);

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:
2140: OPEN c_last_assignment;
2141: FETCH c_last_assignment
2142: INTO l_count;

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 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 2282: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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:
2285: l_application_id := p_application_id;
2286: l_event_class_code := p_event_class_code;

Line 2283: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);

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:
2285: l_application_id := p_application_id;
2286: l_event_class_code := p_event_class_code;
2287:

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 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 2509: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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:
2512: l_application_id := p_application_id;
2513: l_event_class_code := p_event_class_code;

Line 2510: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);

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:
2512: l_application_id := p_application_id;
2513: l_event_class_code := p_event_class_code;
2514:

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 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 2639: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

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:
2642: OPEN c_last_assignment;
2643: FETCH c_last_assignment

Line 2640: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);

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:
2642: OPEN c_last_assignment;
2643: FETCH c_last_assignment
2644: INTO l_count;

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;