DBA Data[Home] [Help]

APPS.XLA_MAPPING_SETS_PKG dependencies on XLA_MAPPING_SETS_PKG

Line 1: PACKAGE BODY xla_mapping_sets_pkg AS

1: PACKAGE BODY xla_mapping_sets_pkg AS
2: /* $Header: xlaamdms.pkb 120.7 2004/11/02 18:59:34 wychan ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_mapping_sets_pkg |

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

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 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 52: (p_location => 'xla_mapping_sets_pkg.delete_seg_rule_details');

48: WHEN xla_exceptions_pkg.application_exception THEN
49: RAISE;
50: WHEN OTHERS THEN
51: xla_exceptions_pkg.raise_message
52: (p_location => 'xla_mapping_sets_pkg.delete_seg_rule_details');
53:
54: END delete_mapping_set_details;
55:
56: /*======================================================================+

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 119: ,'LOCATION' ,'xla_mapping_sets_pkg.mapping_set_in_use');

115: ELSE
116: xla_exceptions_pkg.raise_message
117: ('XLA' ,'XLA_COMMON_ERROR'
118: ,'ERROR' ,'Invalid event passed'
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);

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 140: (p_location => 'xla_mapping_sets_pkg.mapping_set_in_use');

136: CLOSE c_assignment_exist;
137: END IF;
138:
139: xla_exceptions_pkg.raise_message
140: (p_location => 'xla_mapping_sets_pkg.mapping_set_in_use');
141:
142: END mapping_set_in_use;
143:
144: /*======================================================================+

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 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 256: (p_location => 'xla_mapping_sets_pkg.mapping_set_is_locked');

252: CLOSE c_frozen_assignment_exist;
253: END IF;
254:
255: xla_exceptions_pkg.raise_message
256: (p_location => 'xla_mapping_sets_pkg.mapping_set_is_locked');
257:
258: END mapping_set_is_locked;
259:
260: /*======================================================================+

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

305: RAISE;
306:
307: WHEN OTHERS THEN
308: xla_exceptions_pkg.raise_message
309: (p_location => 'xla_mapping_sets_pkg.uncompile_product_rule');
310:
311: END uncompile_product_rule;
312:
313: /*======================================================================+

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

402: CLOSE c_prod_rules;
403: END IF;
404:
405: xla_exceptions_pkg.raise_message
406: (p_location => 'xla_mapping_sets_pkg.uncompile_definitions');
407:
408: END uncompile_definitions;
409:
410: /*======================================================================+

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 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

Line 495: (p_location => 'xla_mapping_sets_pkg.uncompile_tran_acct_def');

491: CLOSE c_prod_rules;
492: END IF;
493:
494: xla_exceptions_pkg.raise_message
495: (p_location => 'xla_mapping_sets_pkg.uncompile_tran_acct_def');
496:
497: END uncompile_tran_acct_def;
498:
499: END xla_mapping_sets_pkg;

Line 499: END xla_mapping_sets_pkg;

495: (p_location => 'xla_mapping_sets_pkg.uncompile_tran_acct_def');
496:
497: END uncompile_tran_acct_def;
498:
499: END xla_mapping_sets_pkg;