DBA Data[Home] [Help]

APPS.XLA_CONTEXT_PKG dependencies on XLA_CONTEXT_PKG

Line 1: PACKAGE BODY XLA_CONTEXT_PKG AS

1: PACKAGE BODY XLA_CONTEXT_PKG AS
2: -- $Header: xlacmctx.pkb 120.7 2011/01/12 03:12:26 vkasina ship $
3: /*===========================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 12: | xla_context_pkg |

8: | FILENAME |
9: | xlacmctx.pkb |
10: | |
11: | PACKAGE NAME |
12: | xla_context_pkg |
13: | |
14: | DESCRIPTION |
15: | This context package is used to set the attribute values for the |
16: | application context namespace "XLA" |

Line 82: (p_location => 'xla_context_pkgset_security_context');

78: WHEN xla_exceptions_pkg.application_exception THEN
79: RAISE;
80: WHEN OTHERS THEN
81: xla_exceptions_pkg.raise_message
82: (p_location => 'xla_context_pkgset_security_context');
83: END set_security_context;
84:
85: --=============================================================================
86: --

Line 110: (p_location => 'xla_context_pkgset_security_context');

106: WHEN xla_exceptions_pkg.application_exception THEN
107: RAISE;
108: WHEN OTHERS THEN
109: xla_exceptions_pkg.raise_message
110: (p_location => 'xla_context_pkgset_security_context');
111: END set_acct_err_context;
112:
113: --=============================================================================
114: --

Line 127: (p_location => 'xla_context_pkg.get_acct_err_context');

123: WHEN xla_exceptions_pkg.application_exception THEN
124: RAISE;
125: WHEN OTHERS THEN
126: xla_exceptions_pkg.raise_message
127: (p_location => 'xla_context_pkg.get_acct_err_context');
128: END get_acct_err_context;
129:
130:
131: FUNCTION increment_acct_err_context

Line 136: l_current_count := xla_context_pkg.get_acct_err_context()

132: (p_error_count_increment IN NUMBER
133: ,p_client_id IN VARCHAR2) RETURN NUMBER IS
134: l_current_count NUMBER;
135: BEGIN
136: l_current_count := xla_context_pkg.get_acct_err_context()
137: + p_error_count_increment;
138:
139: xla_context_pkg.set_acct_err_context(l_current_count,
140: p_client_id);

Line 139: xla_context_pkg.set_acct_err_context(l_current_count,

135: BEGIN
136: l_current_count := xla_context_pkg.get_acct_err_context()
137: + p_error_count_increment;
138:
139: xla_context_pkg.set_acct_err_context(l_current_count,
140: p_client_id);
141:
142: RETURN(l_current_count);
143: EXCEPTION

Line 148: (p_location => 'xla_context_pkg.increment_acct_err_context');

144: WHEN xla_exceptions_pkg.application_exception THEN
145: RAISE;
146: WHEN OTHERS THEN
147: xla_exceptions_pkg.raise_message
148: (p_location => 'xla_context_pkg.increment_acct_err_context');
149: END increment_acct_err_context;
150:
151: --=============================================================================
152: --

Line 173: (p_location => 'xla_context_pkgset_security_context');

169: WHEN xla_exceptions_pkg.application_exception THEN
170: RAISE;
171: WHEN OTHERS THEN
172: xla_exceptions_pkg.raise_message
173: (p_location => 'xla_context_pkgset_security_context');
174: END clear_acct_err_context;
175:
176:
177: ------------------------------------------------------------------------------

Line 199: (p_location => 'xla_context_pkg.set_mpa_accrual_context');

195: WHEN xla_exceptions_pkg.application_exception THEN
196: RAISE;
197: WHEN OTHERS THEN
198: xla_exceptions_pkg.raise_message
199: (p_location => 'xla_context_pkg.set_mpa_accrual_context');
200: END set_mpa_accrual_context;
201:
202: ------------------------------------------------------------------------------
203: -- 4645092 To get MPA-accrual context

Line 214: (p_location => 'xla_context_pkgget_mpa_accrual_context');

210: WHEN xla_exceptions_pkg.application_exception THEN
211: RAISE;
212: WHEN OTHERS THEN
213: xla_exceptions_pkg.raise_message
214: (p_location => 'xla_context_pkgget_mpa_accrual_context');
215: END get_mpa_accrual_context;
216:
217:
218: ------------------------------------------------------------------------------

Line 237: (p_location => 'xla_context_pkgclear_mpa_accrual_context');

233: WHEN xla_exceptions_pkg.application_exception THEN
234: RAISE;
235: WHEN OTHERS THEN
236: xla_exceptions_pkg.raise_message
237: (p_location => 'xla_context_pkgclear_mpa_accrual_context');
238: END clear_mpa_accrual_context;
239:
240: ---------------------------------------------------------------------
241: -- 4865292 Event context

Line 267: (p_location => 'xla_context_pkg.set_event_count_context');

263: WHEN xla_exceptions_pkg.application_exception THEN
264: RAISE;
265: WHEN OTHERS THEN
266: xla_exceptions_pkg.raise_message
267: (p_location => 'xla_context_pkg.set_event_count_context');
268: END set_event_count_context;
269:
270: FUNCTION get_event_count_context
271: RETURN NUMBER IS

Line 298: (p_location => 'xla_context_pkg.set_event_nohdr_context');

294: WHEN xla_exceptions_pkg.application_exception THEN
295: RAISE;
296: WHEN OTHERS THEN
297: xla_exceptions_pkg.raise_message
298: (p_location => 'xla_context_pkg.set_event_nohdr_context');
299: END set_event_nohdr_context;
300:
301: FUNCTION get_event_nohdr_context
302: RETURN VARCHAR2 IS

Line 312: (p_location => 'xla_context_pkg.get_event_nohdr_context');

308: WHEN xla_exceptions_pkg.application_exception THEN
309: RAISE;
310: WHEN OTHERS THEN
311: xla_exceptions_pkg.raise_message
312: (p_location => 'xla_context_pkg.get_event_nohdr_context');
313: END get_event_nohdr_context;
314:
315: PROCEDURE clear_event_context
316: (p_client_id IN VARCHAR2) IS

Line 339: (p_location => 'xla_context_pkg.clear_event_context');

335: WHEN xla_exceptions_pkg.application_exception THEN
336: RAISE;
337: WHEN OTHERS THEN
338: xla_exceptions_pkg.raise_message
339: (p_location => 'xla_context_pkg.clear_event_context');
340: END clear_event_context;
341:
342: --=============================================================================
343: --

Line 361: (p_location => 'xla_context_pkg.set_event_set_id_context');

357: WHEN xla_exceptions_pkg.application_exception THEN
358: RAISE;
359: WHEN OTHERS THEN
360: xla_exceptions_pkg.raise_message
361: (p_location => 'xla_context_pkg.set_event_set_id_context');
362: END set_event_set_id_context;
363:
364: --=============================================================================
365: --

Line 383: (p_location => 'xla_context_pkg.set_request_id_context');

379: WHEN xla_exceptions_pkg.application_exception THEN
380: RAISE;
381: WHEN OTHERS THEN
382: xla_exceptions_pkg.raise_message
383: (p_location => 'xla_context_pkg.set_request_id_context');
384: END set_request_id_context;
385:
386: --=============================================================================
387: --

Line 405: (p_location => 'xla_context_pkg.set_report_request_id_context');

401: WHEN xla_exceptions_pkg.application_exception THEN
402: RAISE;
403: WHEN OTHERS THEN
404: xla_exceptions_pkg.raise_message
405: (p_location => 'xla_context_pkg.set_report_request_id_context');
406: END set_report_request_id_context;
407:
408: --=============================================================================
409: --

Line 427: (p_location => 'xla_context_pkg.set_processing_order_context');

423: WHEN xla_exceptions_pkg.application_exception THEN
424: RAISE;
425: WHEN OTHERS THEN
426: xla_exceptions_pkg.raise_message
427: (p_location => 'xla_context_pkg.set_processing_order_context');
428: END set_processing_order_context;
429:
430: ---------------------------------------------------------------------
431: -- 4865292 Event context

Line 454: (p_location => 'xla_context_pkg.set_gen_bal_context');

450: WHEN xla_exceptions_pkg.application_exception THEN
451: RAISE;
452: WHEN OTHERS THEN
453: xla_exceptions_pkg.raise_message
454: (p_location => 'xla_context_pkg.set_gen_bal_context');
455: END set_gen_bal_context;
456:
457: FUNCTION get_gen_bal_context RETURN VARCHAR2 IS
458: BEGIN

Line 477: (p_location => 'xla_context_pkg.clear_gen_bal_context');

473: WHEN xla_exceptions_pkg.application_exception THEN
474: RAISE;
475: WHEN OTHERS THEN
476: xla_exceptions_pkg.raise_message
477: (p_location => 'xla_context_pkg.clear_gen_bal_context');
478: END clear_gen_bal_context;
479:
480: --=============================================================================
481: --

Line 505: (p_location => 'xla_context_pkg.set_msg_count_context');

501: WHEN xla_exceptions_pkg.application_exception THEN
502: RAISE;
503: WHEN OTHERS THEN
504: xla_exceptions_pkg.raise_message
505: (p_location => 'xla_context_pkg.set_msg_count_context');
506: END set_msg_count_context;
507:
508: --=============================================================================
509: --

Line 522: (p_location => 'xla_context_pkg.get_msg_count_context');

518: WHEN xla_exceptions_pkg.application_exception THEN
519: RAISE;
520: WHEN OTHERS THEN
521: xla_exceptions_pkg.raise_message
522: (p_location => 'xla_context_pkg.get_msg_count_context');
523: END get_msg_count_context;
524:
525:
526: PROCEDURE increment_msg_count_context

Line 536: l_current_count := xla_context_pkg.get_msg_count_context()

532: BEGIN
533: dbms_lock.allocate_unique('XLA_MESG_COUNT_LOCK', handle);
534: retval := dbms_lock.request(handle, 6, 300, TRUE);
535:
536: l_current_count := xla_context_pkg.get_msg_count_context()
537: + p_msg_count_increment;
538:
539: xla_context_pkg.set_msg_count_context(l_current_count,
540: p_client_id);

Line 539: xla_context_pkg.set_msg_count_context(l_current_count,

535:
536: l_current_count := xla_context_pkg.get_msg_count_context()
537: + p_msg_count_increment;
538:
539: xla_context_pkg.set_msg_count_context(l_current_count,
540: p_client_id);
541:
542: retval := dbms_lock.release(handle);
543:

Line 550: (p_location => 'xla_context_pkg.increment_msg_count_context');

546: WHEN xla_exceptions_pkg.application_exception THEN
547: RAISE;
548: WHEN OTHERS THEN
549: xla_exceptions_pkg.raise_message
550: (p_location => 'xla_context_pkg.increment_msg_count_context');
551: END increment_msg_count_context;
552:
553: FUNCTION get_and_clr_msg_count_context
554: (p_client_id IN VARCHAR2) RETURN NUMBER IS

Line 562: l_current_count := xla_context_pkg.get_msg_count_context;

558: BEGIN
559: dbms_lock.allocate_unique('XLA_MESG_COUNT_LOCK', handle);
560: retval := dbms_lock.request(handle, 6, 300, TRUE);
561:
562: l_current_count := xla_context_pkg.get_msg_count_context;
563:
564: xla_context_pkg.set_msg_count_context(0,
565: p_client_id);
566:

Line 564: xla_context_pkg.set_msg_count_context(0,

560: retval := dbms_lock.request(handle, 6, 300, TRUE);
561:
562: l_current_count := xla_context_pkg.get_msg_count_context;
563:
564: xla_context_pkg.set_msg_count_context(0,
565: p_client_id);
566:
567: retval := dbms_lock.release(handle);
568:

Line 575: (p_location => 'xla_context_pkg.get_and_clr_msg_count_context');

571: WHEN xla_exceptions_pkg.application_exception THEN
572: RAISE;
573: WHEN OTHERS THEN
574: xla_exceptions_pkg.raise_message
575: (p_location => 'xla_context_pkg.get_and_clr_msg_count_context');
576: END get_and_clr_msg_count_context;
577:
578: --=============================================================================
579: --

Line 600: (p_location => 'xla_context_pkgset_security_context');

596: WHEN xla_exceptions_pkg.application_exception THEN
597: RAISE;
598: WHEN OTHERS THEN
599: xla_exceptions_pkg.raise_message
600: (p_location => 'xla_context_pkgset_security_context');
601: END clear_msg_count_context;
602:
603:
604: END xla_context_pkg;

Line 604: END xla_context_pkg;

600: (p_location => 'xla_context_pkgset_security_context');
601: END clear_msg_count_context;
602:
603:
604: END xla_context_pkg;