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

Line 36: xla_utility_pkg.trace('> xla_mapping_sets_pkg.delete_mapping_set_details' , 10);

32: IS
33:
34: BEGIN
35:
36: xla_utility_pkg.trace('> xla_mapping_sets_pkg.delete_mapping_set_details' , 10);
37:
38: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
39:
40: DELETE

Line 38: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);

34: BEGIN
35:
36: xla_utility_pkg.trace('> xla_mapping_sets_pkg.delete_mapping_set_details' , 10);
37:
38: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
39:
40: DELETE
41: FROM xla_mapping_set_values
42: WHERE mapping_set_code = p_mapping_set_code

Line 45: xla_utility_pkg.trace('< xla_mapping_sets_pkg.delete_mapping_set_details' , 10);

41: FROM xla_mapping_set_values
42: WHERE mapping_set_code = p_mapping_set_code
43: AND amb_context_code = p_amb_context_code;
44:
45: xla_utility_pkg.trace('< xla_mapping_sets_pkg.delete_mapping_set_details' , 10);
46:
47: EXCEPTION
48: WHEN xla_exceptions_pkg.application_exception THEN
49: RAISE;

Line 91: xla_utility_pkg.trace('> xla_mapping_sets_pkg.mapping_set_in_use' , 10);

87: l_assignment_exist c_assignment_exist%rowtype;
88:
89: BEGIN
90:
91: xla_utility_pkg.trace('> xla_mapping_sets_pkg.mapping_set_in_use' , 10);
92:
93: xla_utility_pkg.trace('event = '||p_event , 20);
94: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
95:

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

89: BEGIN
90:
91: xla_utility_pkg.trace('> xla_mapping_sets_pkg.mapping_set_in_use' , 10);
92:
93: xla_utility_pkg.trace('event = '||p_event , 20);
94: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
95:
96: IF p_event in ('DELETE','UPDATE','DISABLE') THEN
97: OPEN c_assignment_exist;

Line 94: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);

90:
91: xla_utility_pkg.trace('> xla_mapping_sets_pkg.mapping_set_in_use' , 10);
92:
93: xla_utility_pkg.trace('event = '||p_event , 20);
94: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
95:
96: IF p_event in ('DELETE','UPDATE','DISABLE') THEN
97: OPEN c_assignment_exist;
98: FETCH c_assignment_exist

Line 123: xla_utility_pkg.trace('< xla_mapping_sets_pkg.mapping_set_in_use' , 10);

119: ,'LOCATION' ,'xla_mapping_sets_pkg.mapping_set_in_use');
120:
121: END IF;
122:
123: xla_utility_pkg.trace('< xla_mapping_sets_pkg.mapping_set_in_use' , 10);
124:
125: return l_return;
126:
127: EXCEPTION

Line 213: xla_utility_pkg.trace('> xla_mapping_sets_pkg.mapping_set_is_locked' , 10);

209: AND a.locking_status_flag = 'Y');
210:
211: BEGIN
212:
213: xla_utility_pkg.trace('> xla_mapping_sets_pkg.mapping_set_is_locked' , 10);
214:
215: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
216:
217: OPEN c_frozen_assignment_exist;

Line 215: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);

211: BEGIN
212:
213: xla_utility_pkg.trace('> xla_mapping_sets_pkg.mapping_set_is_locked' , 10);
214:
215: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
216:
217: OPEN c_frozen_assignment_exist;
218: FETCH c_frozen_assignment_exist
219: INTO l_exist;

Line 239: xla_utility_pkg.trace('< xla_mapping_sets_pkg.mapping_set_is_locked' , 10);

235: END IF;
236: CLOSE c_tab_assignment_exist;
237: END IF;
238:
239: xla_utility_pkg.trace('< xla_mapping_sets_pkg.mapping_set_is_locked' , 10);
240:
241: return l_return;
242:
243: EXCEPTION

Line 286: xla_utility_pkg.trace('> xla_mapping_sets_pkg.uncompile_product_rule' , 10);

282: l_return BOOLEAN := TRUE;
283:
284: BEGIN
285:
286: xla_utility_pkg.trace('> xla_mapping_sets_pkg.uncompile_product_rule' , 10);
287:
288: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
289:
290: l_return := uncompile_definitions

Line 288: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);

284: BEGIN
285:
286: xla_utility_pkg.trace('> xla_mapping_sets_pkg.uncompile_product_rule' , 10);
287:
288: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
289:
290: l_return := uncompile_definitions
291: (p_mapping_set_code => p_mapping_set_code
292: ,p_amb_context_code => p_amb_context_code

Line 299: xla_utility_pkg.trace('< xla_mapping_sets_pkg.uncompile_product_rule' , 10);

295: ,x_event_class_name => l_event_class_name
296: ,x_event_type_name => l_event_type_name
297: ,x_locking_status_flag => l_locking_status_flag);
298:
299: xla_utility_pkg.trace('< xla_mapping_sets_pkg.uncompile_product_rule' , 10);
300:
301: return l_return;
302:
303: EXCEPTION

Line 355: xla_utility_pkg.trace('> xla_mapping_sets_pkg.uncompile_definitions' , 10);

351: l_prod_rule c_prod_rules%rowtype;
352:
353: BEGIN
354:
355: xla_utility_pkg.trace('> xla_mapping_sets_pkg.uncompile_definitions' , 10);
356:
357: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
358:
359: OPEN c_prod_rules;

Line 357: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);

353: BEGIN
354:
355: xla_utility_pkg.trace('> xla_mapping_sets_pkg.uncompile_definitions' , 10);
356:
357: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
358:
359: OPEN c_prod_rules;
360: LOOP
361: FETCH c_prod_rules

Line 389: xla_utility_pkg.trace('< xla_mapping_sets_pkg.uncompile_definitions' , 10);

385: x_event_class_name := l_event_class_name;
386: x_event_type_name := l_event_type_name;
387: x_locking_status_flag := l_locking_status_flag;
388:
389: xla_utility_pkg.trace('< xla_mapping_sets_pkg.uncompile_definitions' , 10);
390:
391: return l_return;
392:
393: EXCEPTION

Line 450: xla_utility_pkg.trace('> xla_mapping_sets_pkg.uncompile_tran_acct_def' , 10);

446: l_prod_rule c_prod_rules%rowtype;
447:
448: BEGIN
449:
450: xla_utility_pkg.trace('> xla_mapping_sets_pkg.uncompile_tran_acct_def' , 10);
451:
452: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
453:
454: OPEN c_prod_rules;

Line 452: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);

448: BEGIN
449:
450: xla_utility_pkg.trace('> xla_mapping_sets_pkg.uncompile_tran_acct_def' , 10);
451:
452: xla_utility_pkg.trace('mapping_set_code = '||p_mapping_set_code , 20);
453:
454: OPEN c_prod_rules;
455: LOOP
456: FETCH c_prod_rules

Line 478: xla_utility_pkg.trace('< xla_mapping_sets_pkg.uncompile_tran_acct_def' , 10);

474:
475: p_trx_acct_def := l_trx_acct_def;
476: p_trx_acct_def_type := l_trx_acct_def_type;
477:
478: xla_utility_pkg.trace('< xla_mapping_sets_pkg.uncompile_tran_acct_def' , 10);
479:
480: return l_return;
481:
482: EXCEPTION