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.

[Home] [Help]

APPS.XLA_EVENTS_PUB_PKG dependencies on XLA_EVENTS_PUB_PKG

Line 1: PACKAGE BODY xla_events_pub_pkg AS

1: PACKAGE BODY xla_events_pub_pkg AS
2: -- $Header: xlaevevp.pkb 120.37 2011/05/05 13:51:56 sgullape ship $
3: /*===========================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 12: | xla_events_pub_pkg |

8: | FILENAME |
9: | xlaevevp.pkb |
10: | |
11: | PACKAGE NAME |
12: | xla_events_pub_pkg |
13: | |
14: | DESCRIPTION |
15: | This is a public package for product teams, which contains all the |
16: | APIs required for processing accounting events. |

Line 84: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_events_pub_pkg';

80: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
81:
82: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
83:
84: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_events_pub_pkg';
85:
86: g_debug_flag VARCHAR2(1) := NVL(fnd_profile.value('XLA_DEBUG_TRACE'),'N');
87:
88: --l_log_module VARCHAR2(240);

Line 154: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

150: --
151: --============================================================================
152:
153: FUNCTION create_event
154: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
155: ,p_event_type_code IN VARCHAR2
156: ,p_event_date IN DATE
157: ,p_event_status_code IN VARCHAR2
158: ,p_event_number IN INTEGER DEFAULT NULL

Line 160: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL

156: ,p_event_date IN DATE
157: ,p_event_status_code IN VARCHAR2
158: ,p_event_number IN INTEGER DEFAULT NULL
159: ,p_transaction_date IN DATE DEFAULT NULL
160: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
161: ,p_valuation_method IN VARCHAR2
162: ,p_security_context IN xla_events_pub_pkg.t_security)
163: RETURN INTEGER IS
164: BEGIN

Line 162: ,p_security_context IN xla_events_pub_pkg.t_security)

158: ,p_event_number IN INTEGER DEFAULT NULL
159: ,p_transaction_date IN DATE DEFAULT NULL
160: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
161: ,p_valuation_method IN VARCHAR2
162: ,p_security_context IN xla_events_pub_pkg.t_security)
163: RETURN INTEGER IS
164: BEGIN
165: trace('@ xla_events_pub_pkg.create_event (fn)' , 20);
166:

Line 165: trace('@ xla_events_pub_pkg.create_event (fn)' , 20);

161: ,p_valuation_method IN VARCHAR2
162: ,p_security_context IN xla_events_pub_pkg.t_security)
163: RETURN INTEGER IS
164: BEGIN
165: trace('@ xla_events_pub_pkg.create_event (fn)' , 20);
166:
167: xla_events_pub_pkg.g_security := p_security_context;
168: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
169:

Line 167: xla_events_pub_pkg.g_security := p_security_context;

163: RETURN INTEGER IS
164: BEGIN
165: trace('@ xla_events_pub_pkg.create_event (fn)' , 20);
166:
167: xla_events_pub_pkg.g_security := p_security_context;
168: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
169:
170: RETURN xla_events_pkg.create_event
171: (p_event_source_info => p_event_source_info

Line 168: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

164: BEGIN
165: trace('@ xla_events_pub_pkg.create_event (fn)' , 20);
166:
167: xla_events_pub_pkg.g_security := p_security_context;
168: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
169:
170: RETURN xla_events_pkg.create_event
171: (p_event_source_info => p_event_source_info
172: ,p_valuation_method => p_valuation_method

Line 185: (p_location => 'xla_events_pub_pkg.create_event (fn)');

181: WHEN xla_exceptions_pkg.application_exception THEN
182: RAISE;
183: WHEN OTHERS THEN
184: xla_exceptions_pkg.raise_message
185: (p_location => 'xla_events_pub_pkg.create_event (fn)');
186: END create_event;
187:
188: --============================================================================
189: --

Line 197: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

193: -- - create a new event
194: --
195: --============================================================================
196: FUNCTION create_event
197: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
198: ,p_event_type_code IN VARCHAR2
199: ,p_event_date IN DATE
200: ,p_event_status_code IN VARCHAR2
201: ,p_event_number IN INTEGER DEFAULT NULL

Line 203: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL

199: ,p_event_date IN DATE
200: ,p_event_status_code IN VARCHAR2
201: ,p_event_number IN INTEGER DEFAULT NULL
202: ,p_transaction_date IN DATE DEFAULT NULL
203: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
204: ,p_valuation_method IN VARCHAR2
205: ,p_security_context IN xla_events_pub_pkg.t_security
206: ,p_budgetary_control_flag IN VARCHAR2)
207: RETURN INTEGER IS

Line 205: ,p_security_context IN xla_events_pub_pkg.t_security

201: ,p_event_number IN INTEGER DEFAULT NULL
202: ,p_transaction_date IN DATE DEFAULT NULL
203: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
204: ,p_valuation_method IN VARCHAR2
205: ,p_security_context IN xla_events_pub_pkg.t_security
206: ,p_budgetary_control_flag IN VARCHAR2)
207: RETURN INTEGER IS
208: BEGIN
209: trace('@ xla_events_pub_pkg.create_event (fn)' , 20);

Line 209: trace('@ xla_events_pub_pkg.create_event (fn)' , 20);

205: ,p_security_context IN xla_events_pub_pkg.t_security
206: ,p_budgetary_control_flag IN VARCHAR2)
207: RETURN INTEGER IS
208: BEGIN
209: trace('@ xla_events_pub_pkg.create_event (fn)' , 20);
210:
211: xla_events_pub_pkg.g_security := p_security_context;
212:
213: RETURN xla_events_pkg.create_event

Line 211: xla_events_pub_pkg.g_security := p_security_context;

207: RETURN INTEGER IS
208: BEGIN
209: trace('@ xla_events_pub_pkg.create_event (fn)' , 20);
210:
211: xla_events_pub_pkg.g_security := p_security_context;
212:
213: RETURN xla_events_pkg.create_event
214: (p_event_source_info => p_event_source_info
215: ,p_valuation_method => p_valuation_method

Line 228: (p_location => 'xla_events_pub_pkg.create_event (fn)');

224: WHEN xla_exceptions_pkg.application_exception THEN
225: RAISE;
226: WHEN OTHERS THEN
227: xla_exceptions_pkg.raise_message
228: (p_location => 'xla_events_pub_pkg.create_event (fn)');
229: END create_event;
230:
231:
232: -------------------------------------------------------------------------------

Line 247: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

243: --
244: --============================================================================
245:
246: PROCEDURE update_event_status
247: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
248: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
249: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
250: ,p_event_date IN DATE DEFAULT NULL
251: ,p_event_status_code IN VARCHAR2

Line 253: ,p_security_context IN xla_events_pub_pkg.t_security) IS

249: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
250: ,p_event_date IN DATE DEFAULT NULL
251: ,p_event_status_code IN VARCHAR2
252: ,p_valuation_method IN VARCHAR2
253: ,p_security_context IN xla_events_pub_pkg.t_security) IS
254: BEGIN
255: trace('> xla_events_pub_pkg.update_event_status' , 20);
256:
257: xla_events_pub_pkg.g_security := p_security_context;

Line 255: trace('> xla_events_pub_pkg.update_event_status' , 20);

251: ,p_event_status_code IN VARCHAR2
252: ,p_valuation_method IN VARCHAR2
253: ,p_security_context IN xla_events_pub_pkg.t_security) IS
254: BEGIN
255: trace('> xla_events_pub_pkg.update_event_status' , 20);
256:
257: xla_events_pub_pkg.g_security := p_security_context;
258: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
259:

Line 257: xla_events_pub_pkg.g_security := p_security_context;

253: ,p_security_context IN xla_events_pub_pkg.t_security) IS
254: BEGIN
255: trace('> xla_events_pub_pkg.update_event_status' , 20);
256:
257: xla_events_pub_pkg.g_security := p_security_context;
258: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
259:
260: xla_events_pkg.update_event_status
261: (p_event_source_info => p_event_source_info

Line 258: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

254: BEGIN
255: trace('> xla_events_pub_pkg.update_event_status' , 20);
256:
257: xla_events_pub_pkg.g_security := p_security_context;
258: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
259:
260: xla_events_pkg.update_event_status
261: (p_event_source_info => p_event_source_info
262: ,p_valuation_method => p_valuation_method

Line 268: trace('< xla_events_pub_pkg.update_event_status' , 20);

264: ,p_event_type_code => p_event_type_code
265: ,p_event_date => p_event_date
266: ,p_event_status_code => p_event_status_code);
267:
268: trace('< xla_events_pub_pkg.update_event_status' , 20);
269: EXCEPTION
270: WHEN xla_exceptions_pkg.application_exception THEN
271: RAISE;
272: WHEN OTHERS THEN

Line 274: (p_location => 'xla_events_pub_pkg.update_event_status');

270: WHEN xla_exceptions_pkg.application_exception THEN
271: RAISE;
272: WHEN OTHERS THEN
273: xla_exceptions_pkg.raise_message
274: (p_location => 'xla_events_pub_pkg.update_event_status');
275: END update_event_status;
276:
277:
278: --============================================================================

Line 290: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

286: --
287: --============================================================================
288:
289: PROCEDURE update_event
290: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
291: ,p_event_id IN INTEGER
292: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
293: ,p_event_date IN DATE DEFAULT NULL
294: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 296: ,p_security_context IN xla_events_pub_pkg.t_security

292: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
293: ,p_event_date IN DATE DEFAULT NULL
294: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
295: ,p_valuation_method IN VARCHAR2
296: ,p_security_context IN xla_events_pub_pkg.t_security
297: ,p_transaction_date IN DATE DEFAULT NULL) IS
298: BEGIN
299: trace('> xla_events_pub_pkg.update_event' , 20);
300:

Line 299: trace('> xla_events_pub_pkg.update_event' , 20);

295: ,p_valuation_method IN VARCHAR2
296: ,p_security_context IN xla_events_pub_pkg.t_security
297: ,p_transaction_date IN DATE DEFAULT NULL) IS
298: BEGIN
299: trace('> xla_events_pub_pkg.update_event' , 20);
300:
301: xla_events_pub_pkg.g_security := p_security_context;
302: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
303:

Line 301: xla_events_pub_pkg.g_security := p_security_context;

297: ,p_transaction_date IN DATE DEFAULT NULL) IS
298: BEGIN
299: trace('> xla_events_pub_pkg.update_event' , 20);
300:
301: xla_events_pub_pkg.g_security := p_security_context;
302: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
303:
304: xla_events_pkg.update_event
305: (p_event_source_info => p_event_source_info

Line 302: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

298: BEGIN
299: trace('> xla_events_pub_pkg.update_event' , 20);
300:
301: xla_events_pub_pkg.g_security := p_security_context;
302: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
303:
304: xla_events_pkg.update_event
305: (p_event_source_info => p_event_source_info
306: ,p_valuation_method => p_valuation_method

Line 313: trace('< xla_events_pub_pkg.update_event' , 20);

309: ,p_event_date => p_event_date
310: ,p_event_status_code => p_event_status_code
311: ,p_transaction_date => p_transaction_date);
312:
313: trace('< xla_events_pub_pkg.update_event' , 20);
314: EXCEPTION
315: WHEN xla_exceptions_pkg.application_exception THEN
316: RAISE;
317: WHEN OTHERS THEN

Line 319: (p_location => 'xla_events_pub_pkg.update_event');

315: WHEN xla_exceptions_pkg.application_exception THEN
316: RAISE;
317: WHEN OTHERS THEN
318: xla_exceptions_pkg.raise_message
319: (p_location => 'xla_events_pub_pkg.update_event');
320: END update_event;
321:
322:
323: --============================================================================

Line 335: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

331: --
332: --============================================================================
333:
334: PROCEDURE update_event
335: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
336: ,p_event_id IN INTEGER
337: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
338: ,p_event_date IN DATE DEFAULT NULL
339: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 342: ,p_security_context IN xla_events_pub_pkg.t_security

338: ,p_event_date IN DATE DEFAULT NULL
339: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
340: ,p_event_number IN INTEGER
341: ,p_valuation_method IN VARCHAR2
342: ,p_security_context IN xla_events_pub_pkg.t_security
343: ,p_transaction_date IN DATE DEFAULT NULL) IS
344: BEGIN
345: trace('> xla_events_pub_pkg.update_event' , 20);
346:

Line 345: trace('> xla_events_pub_pkg.update_event' , 20);

341: ,p_valuation_method IN VARCHAR2
342: ,p_security_context IN xla_events_pub_pkg.t_security
343: ,p_transaction_date IN DATE DEFAULT NULL) IS
344: BEGIN
345: trace('> xla_events_pub_pkg.update_event' , 20);
346:
347: xla_events_pub_pkg.g_security := p_security_context;
348: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
349:

Line 347: xla_events_pub_pkg.g_security := p_security_context;

343: ,p_transaction_date IN DATE DEFAULT NULL) IS
344: BEGIN
345: trace('> xla_events_pub_pkg.update_event' , 20);
346:
347: xla_events_pub_pkg.g_security := p_security_context;
348: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
349:
350: xla_events_pkg.update_event
351: (p_event_source_info => p_event_source_info

Line 348: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

344: BEGIN
345: trace('> xla_events_pub_pkg.update_event' , 20);
346:
347: xla_events_pub_pkg.g_security := p_security_context;
348: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
349:
350: xla_events_pkg.update_event
351: (p_event_source_info => p_event_source_info
352: ,p_valuation_method => p_valuation_method

Line 361: trace('< xla_events_pub_pkg.update_event' , 20);

357: ,p_transaction_date => p_transaction_date
358: ,p_event_number => p_event_number
359: ,p_overwrite_event_num => 'Y');
360:
361: trace('< xla_events_pub_pkg.update_event' , 20);
362: EXCEPTION
363: WHEN xla_exceptions_pkg.application_exception THEN
364: RAISE;
365: WHEN OTHERS THEN

Line 367: (p_location => 'xla_events_pub_pkg.update_event');

363: WHEN xla_exceptions_pkg.application_exception THEN
364: RAISE;
365: WHEN OTHERS THEN
366: xla_exceptions_pkg.raise_message
367: (p_location => 'xla_events_pub_pkg.update_event');
368: END update_event;
369:
370:
371: --============================================================================

Line 383: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

379: --
380: --============================================================================
381:
382: PROCEDURE update_event
383: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
384: ,p_event_id IN INTEGER
385: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
386: ,p_event_date IN DATE DEFAULT NULL
387: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 388: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

384: ,p_event_id IN INTEGER
385: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
386: ,p_event_date IN DATE DEFAULT NULL
387: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
388: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
389: ,p_valuation_method IN VARCHAR2
390: ,p_security_context IN xla_events_pub_pkg.t_security
391: ,p_transaction_date IN DATE DEFAULT NULL) IS
392: BEGIN

Line 390: ,p_security_context IN xla_events_pub_pkg.t_security

386: ,p_event_date IN DATE DEFAULT NULL
387: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
388: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
389: ,p_valuation_method IN VARCHAR2
390: ,p_security_context IN xla_events_pub_pkg.t_security
391: ,p_transaction_date IN DATE DEFAULT NULL) IS
392: BEGIN
393: trace('> xla_events_pub_pkg.update_event' , 20);
394:

Line 393: trace('> xla_events_pub_pkg.update_event' , 20);

389: ,p_valuation_method IN VARCHAR2
390: ,p_security_context IN xla_events_pub_pkg.t_security
391: ,p_transaction_date IN DATE DEFAULT NULL) IS
392: BEGIN
393: trace('> xla_events_pub_pkg.update_event' , 20);
394:
395: xla_events_pub_pkg.g_security := p_security_context;
396: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
397:

Line 395: xla_events_pub_pkg.g_security := p_security_context;

391: ,p_transaction_date IN DATE DEFAULT NULL) IS
392: BEGIN
393: trace('> xla_events_pub_pkg.update_event' , 20);
394:
395: xla_events_pub_pkg.g_security := p_security_context;
396: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
397:
398: xla_events_pkg.update_event
399: (p_event_source_info => p_event_source_info

Line 396: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

392: BEGIN
393: trace('> xla_events_pub_pkg.update_event' , 20);
394:
395: xla_events_pub_pkg.g_security := p_security_context;
396: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
397:
398: xla_events_pkg.update_event
399: (p_event_source_info => p_event_source_info
400: ,p_valuation_method => p_valuation_method

Line 409: trace('< xla_events_pub_pkg.update_event' , 20);

405: ,p_transaction_date => p_transaction_date
406: ,p_reference_info => p_reference_info
407: ,p_overwrite_ref_info => 'Y' );
408:
409: trace('< xla_events_pub_pkg.update_event' , 20);
410: EXCEPTION
411: WHEN xla_exceptions_pkg.application_exception THEN
412: RAISE;
413: WHEN OTHERS THEN

Line 415: (p_location => 'xla_events_pub_pkg.update_event');

411: WHEN xla_exceptions_pkg.application_exception THEN
412: RAISE;
413: WHEN OTHERS THEN
414: xla_exceptions_pkg.raise_message
415: (p_location => 'xla_events_pub_pkg.update_event');
416: END update_event;
417:
418:
419: --============================================================================

Line 431: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

427: --
428: --============================================================================
429:
430: PROCEDURE update_event
431: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
432: ,p_event_id IN INTEGER
433: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
434: ,p_event_date IN DATE DEFAULT NULL
435: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 437: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

433: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
434: ,p_event_date IN DATE DEFAULT NULL
435: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
436: ,p_event_number IN INTEGER
437: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
438: ,p_valuation_method IN VARCHAR2
439: ,p_security_context IN xla_events_pub_pkg.t_security
440: ,p_transaction_date IN DATE DEFAULT NULL) IS
441: BEGIN

Line 439: ,p_security_context IN xla_events_pub_pkg.t_security

435: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
436: ,p_event_number IN INTEGER
437: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
438: ,p_valuation_method IN VARCHAR2
439: ,p_security_context IN xla_events_pub_pkg.t_security
440: ,p_transaction_date IN DATE DEFAULT NULL) IS
441: BEGIN
442: trace('> xla_events_pub_pkg.update_event' , 20);
443:

Line 442: trace('> xla_events_pub_pkg.update_event' , 20);

438: ,p_valuation_method IN VARCHAR2
439: ,p_security_context IN xla_events_pub_pkg.t_security
440: ,p_transaction_date IN DATE DEFAULT NULL) IS
441: BEGIN
442: trace('> xla_events_pub_pkg.update_event' , 20);
443:
444: xla_events_pub_pkg.g_security := p_security_context;
445: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
446:

Line 444: xla_events_pub_pkg.g_security := p_security_context;

440: ,p_transaction_date IN DATE DEFAULT NULL) IS
441: BEGIN
442: trace('> xla_events_pub_pkg.update_event' , 20);
443:
444: xla_events_pub_pkg.g_security := p_security_context;
445: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
446:
447: xla_events_pkg.update_event
448: (p_event_source_info => p_event_source_info

Line 445: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

441: BEGIN
442: trace('> xla_events_pub_pkg.update_event' , 20);
443:
444: xla_events_pub_pkg.g_security := p_security_context;
445: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
446:
447: xla_events_pkg.update_event
448: (p_event_source_info => p_event_source_info
449: ,p_valuation_method => p_valuation_method

Line 460: trace('< xla_events_pub_pkg.update_event' , 20);

456: ,p_reference_info => p_reference_info
457: ,p_overwrite_event_num => 'Y'
458: ,p_overwrite_ref_info => 'Y');
459:
460: trace('< xla_events_pub_pkg.update_event' , 20);
461: EXCEPTION
462: WHEN xla_exceptions_pkg.application_exception THEN
463: RAISE;
464: WHEN OTHERS THEN

Line 466: (p_location => 'xla_events_pub_pkg.update_event');

462: WHEN xla_exceptions_pkg.application_exception THEN
463: RAISE;
464: WHEN OTHERS THEN
465: xla_exceptions_pkg.raise_message
466: (p_location => 'xla_events_pub_pkg.update_event');
467: END update_event;
468:
469:
470: -------------------------------------------------------------------------------

Line 485: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

481: --
482: --============================================================================
483:
484: PROCEDURE delete_event
485: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
486: ,p_event_id IN INTEGER
487: ,p_valuation_method IN VARCHAR2
488: ,p_security_context IN xla_events_pub_pkg.t_security) IS
489: BEGIN

Line 488: ,p_security_context IN xla_events_pub_pkg.t_security) IS

484: PROCEDURE delete_event
485: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
486: ,p_event_id IN INTEGER
487: ,p_valuation_method IN VARCHAR2
488: ,p_security_context IN xla_events_pub_pkg.t_security) IS
489: BEGIN
490: trace('> xla_events_pub_pkg.delete_event' , 20);
491:
492: xla_events_pub_pkg.g_security := p_security_context;

Line 490: trace('> xla_events_pub_pkg.delete_event' , 20);

486: ,p_event_id IN INTEGER
487: ,p_valuation_method IN VARCHAR2
488: ,p_security_context IN xla_events_pub_pkg.t_security) IS
489: BEGIN
490: trace('> xla_events_pub_pkg.delete_event' , 20);
491:
492: xla_events_pub_pkg.g_security := p_security_context;
493: --xla_events_pub_pkg.g_valuation_method := p_valuation_method;
494:

Line 492: xla_events_pub_pkg.g_security := p_security_context;

488: ,p_security_context IN xla_events_pub_pkg.t_security) IS
489: BEGIN
490: trace('> xla_events_pub_pkg.delete_event' , 20);
491:
492: xla_events_pub_pkg.g_security := p_security_context;
493: --xla_events_pub_pkg.g_valuation_method := p_valuation_method;
494:
495: xla_events_pkg.delete_event
496: (p_event_source_info => p_event_source_info

Line 493: --xla_events_pub_pkg.g_valuation_method := p_valuation_method;

489: BEGIN
490: trace('> xla_events_pub_pkg.delete_event' , 20);
491:
492: xla_events_pub_pkg.g_security := p_security_context;
493: --xla_events_pub_pkg.g_valuation_method := p_valuation_method;
494:
495: xla_events_pkg.delete_event
496: (p_event_source_info => p_event_source_info
497: ,p_valuation_method => p_valuation_method

Line 500: trace('< xla_events_pub_pkg.delete_event' , 20);

496: (p_event_source_info => p_event_source_info
497: ,p_valuation_method => p_valuation_method
498: ,p_event_id => p_event_id );
499:
500: trace('< xla_events_pub_pkg.delete_event' , 20);
501: EXCEPTION
502: WHEN xla_exceptions_pkg.application_exception THEN
503: RAISE;
504: WHEN OTHERS THEN

Line 506: (p_location => 'xla_events_pub_pkg.delete_event');

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

Line 522: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

518: --
519: --============================================================================
520:
521: FUNCTION delete_events
522: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
523: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
524: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
525: ,p_event_date IN DATE DEFAULT NULL
526: ,p_valuation_method IN VARCHAR2

Line 527: ,p_security_context IN xla_events_pub_pkg.t_security)

523: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
524: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
525: ,p_event_date IN DATE DEFAULT NULL
526: ,p_valuation_method IN VARCHAR2
527: ,p_security_context IN xla_events_pub_pkg.t_security)
528: RETURN INTEGER IS
529: BEGIN
530: trace('@ xla_events_pub_pkg.delete_events (fn)' , 20);
531:

Line 530: trace('@ xla_events_pub_pkg.delete_events (fn)' , 20);

526: ,p_valuation_method IN VARCHAR2
527: ,p_security_context IN xla_events_pub_pkg.t_security)
528: RETURN INTEGER IS
529: BEGIN
530: trace('@ xla_events_pub_pkg.delete_events (fn)' , 20);
531:
532: xla_events_pub_pkg.g_security := p_security_context;
533: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
534:

Line 532: xla_events_pub_pkg.g_security := p_security_context;

528: RETURN INTEGER IS
529: BEGIN
530: trace('@ xla_events_pub_pkg.delete_events (fn)' , 20);
531:
532: xla_events_pub_pkg.g_security := p_security_context;
533: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
534:
535: RETURN xla_events_pkg.delete_events
536: (p_event_source_info => p_event_source_info

Line 533: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

529: BEGIN
530: trace('@ xla_events_pub_pkg.delete_events (fn)' , 20);
531:
532: xla_events_pub_pkg.g_security := p_security_context;
533: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
534:
535: RETURN xla_events_pkg.delete_events
536: (p_event_source_info => p_event_source_info
537: ,p_event_class_code => p_event_class_code

Line 546: (p_location => 'xla_events_pub_pkg.delete_events(fn)');

542: WHEN xla_exceptions_pkg.application_exception THEN
543: RAISE;
544: WHEN OTHERS THEN
545: xla_exceptions_pkg.raise_message
546: (p_location => 'xla_events_pub_pkg.delete_events(fn)');
547: END delete_events;
548:
549:
550: --============================================================================

Line 560: (p_source_info IN xla_events_pub_pkg.t_event_source_info

556: -- - else delete entity, return 0
557: --
558: --============================================================================
559: FUNCTION delete_entity
560: (p_source_info IN xla_events_pub_pkg.t_event_source_info
561: ,p_valuation_method IN VARCHAR2
562: ,p_security_context IN xla_events_pub_pkg.t_security)
563: RETURN INTEGER IS
564: l_result INTEGER;

Line 562: ,p_security_context IN xla_events_pub_pkg.t_security)

558: --============================================================================
559: FUNCTION delete_entity
560: (p_source_info IN xla_events_pub_pkg.t_event_source_info
561: ,p_valuation_method IN VARCHAR2
562: ,p_security_context IN xla_events_pub_pkg.t_security)
563: RETURN INTEGER IS
564: l_result INTEGER;
565: BEGIN
566: trace('> xla_events_pub_pkg.delete_entty' , 20);

Line 566: trace('> xla_events_pub_pkg.delete_entty' , 20);

562: ,p_security_context IN xla_events_pub_pkg.t_security)
563: RETURN INTEGER IS
564: l_result INTEGER;
565: BEGIN
566: trace('> xla_events_pub_pkg.delete_entty' , 20);
567:
568: xla_events_pub_pkg.g_security := p_security_context;
569: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
570:

Line 568: xla_events_pub_pkg.g_security := p_security_context;

564: l_result INTEGER;
565: BEGIN
566: trace('> xla_events_pub_pkg.delete_entty' , 20);
567:
568: xla_events_pub_pkg.g_security := p_security_context;
569: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
570:
571: l_result := xla_events_pkg.delete_entity
572: (p_source_info => p_source_info

Line 569: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

565: BEGIN
566: trace('> xla_events_pub_pkg.delete_entty' , 20);
567:
568: xla_events_pub_pkg.g_security := p_security_context;
569: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
570:
571: l_result := xla_events_pkg.delete_entity
572: (p_source_info => p_source_info
573: ,p_valuation_method => p_valuation_method);

Line 575: trace('< xla_events_pub_pkg.delete_entity' , 20);

571: l_result := xla_events_pkg.delete_entity
572: (p_source_info => p_source_info
573: ,p_valuation_method => p_valuation_method);
574:
575: trace('< xla_events_pub_pkg.delete_entity' , 20);
576: return l_result;
577: EXCEPTION
578: WHEN xla_exceptions_pkg.application_exception THEN
579: RAISE;

Line 582: (p_location => 'xla_events_pub_pkg.delete_entity');

578: WHEN xla_exceptions_pkg.application_exception THEN
579: RAISE;
580: WHEN OTHERS THEN
581: xla_exceptions_pkg.raise_message
582: (p_location => 'xla_events_pub_pkg.delete_entity');
583: END delete_entity;
584:
585: -------------------------------------------------------------------------------
586: -- Event information routines

Line 599: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

595: --
596: --============================================================================
597:
598: FUNCTION get_event_info
599: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
600: ,p_event_id IN INTEGER
601: ,p_valuation_method IN VARCHAR2
602: ,p_security_context IN xla_events_pub_pkg.t_security)
603: RETURN xla_events_pub_pkg.t_event_info IS

Line 602: ,p_security_context IN xla_events_pub_pkg.t_security)

598: FUNCTION get_event_info
599: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
600: ,p_event_id IN INTEGER
601: ,p_valuation_method IN VARCHAR2
602: ,p_security_context IN xla_events_pub_pkg.t_security)
603: RETURN xla_events_pub_pkg.t_event_info IS
604: BEGIN
605: trace('@ xla_events_pub_pkg.get_event_info' , 20);
606:

Line 603: RETURN xla_events_pub_pkg.t_event_info IS

599: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
600: ,p_event_id IN INTEGER
601: ,p_valuation_method IN VARCHAR2
602: ,p_security_context IN xla_events_pub_pkg.t_security)
603: RETURN xla_events_pub_pkg.t_event_info IS
604: BEGIN
605: trace('@ xla_events_pub_pkg.get_event_info' , 20);
606:
607: xla_events_pub_pkg.g_security := p_security_context;

Line 605: trace('@ xla_events_pub_pkg.get_event_info' , 20);

601: ,p_valuation_method IN VARCHAR2
602: ,p_security_context IN xla_events_pub_pkg.t_security)
603: RETURN xla_events_pub_pkg.t_event_info IS
604: BEGIN
605: trace('@ xla_events_pub_pkg.get_event_info' , 20);
606:
607: xla_events_pub_pkg.g_security := p_security_context;
608: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
609:

Line 607: xla_events_pub_pkg.g_security := p_security_context;

603: RETURN xla_events_pub_pkg.t_event_info IS
604: BEGIN
605: trace('@ xla_events_pub_pkg.get_event_info' , 20);
606:
607: xla_events_pub_pkg.g_security := p_security_context;
608: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
609:
610: RETURN xla_events_pkg.get_event_info
611: (p_event_source_info => p_event_source_info

Line 608: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

604: BEGIN
605: trace('@ xla_events_pub_pkg.get_event_info' , 20);
606:
607: xla_events_pub_pkg.g_security := p_security_context;
608: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
609:
610: RETURN xla_events_pkg.get_event_info
611: (p_event_source_info => p_event_source_info
612: ,p_valuation_method => p_valuation_method

Line 619: (p_location => 'xla_events_pub_pkg.get_event_info');

615: WHEN xla_exceptions_pkg.application_exception THEN
616: RAISE;
617: WHEN OTHERS THEN
618: xla_exceptions_pkg.raise_message
619: (p_location => 'xla_events_pub_pkg.get_event_info');
620: END get_event_info;
621:
622:
623: --============================================================================

Line 632: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

628: --
629: --============================================================================
630:
631: FUNCTION get_event_status
632: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
633: ,p_event_id IN INTEGER
634: ,p_valuation_method IN VARCHAR2
635: ,p_security_context IN xla_events_pub_pkg.t_security)
636: RETURN VARCHAR2 IS

Line 635: ,p_security_context IN xla_events_pub_pkg.t_security)

631: FUNCTION get_event_status
632: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
633: ,p_event_id IN INTEGER
634: ,p_valuation_method IN VARCHAR2
635: ,p_security_context IN xla_events_pub_pkg.t_security)
636: RETURN VARCHAR2 IS
637: BEGIN
638: trace('@ xla_events_pub_pkg.get_event_status' , 20);
639:

Line 638: trace('@ xla_events_pub_pkg.get_event_status' , 20);

634: ,p_valuation_method IN VARCHAR2
635: ,p_security_context IN xla_events_pub_pkg.t_security)
636: RETURN VARCHAR2 IS
637: BEGIN
638: trace('@ xla_events_pub_pkg.get_event_status' , 20);
639:
640: xla_events_pub_pkg.g_security := p_security_context;
641: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
642:

Line 640: xla_events_pub_pkg.g_security := p_security_context;

636: RETURN VARCHAR2 IS
637: BEGIN
638: trace('@ xla_events_pub_pkg.get_event_status' , 20);
639:
640: xla_events_pub_pkg.g_security := p_security_context;
641: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
642:
643: RETURN xla_events_pkg.get_event_status
644: (p_event_source_info => p_event_source_info

Line 641: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

637: BEGIN
638: trace('@ xla_events_pub_pkg.get_event_status' , 20);
639:
640: xla_events_pub_pkg.g_security := p_security_context;
641: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
642:
643: RETURN xla_events_pkg.get_event_status
644: (p_event_source_info => p_event_source_info
645: ,p_valuation_method => p_valuation_method

Line 652: (p_location => 'xla_events_pub_pkg.get_event_status');

648: WHEN xla_exceptions_pkg.application_exception THEN
649: RAISE;
650: WHEN OTHERS THEN
651: xla_exceptions_pkg.raise_message
652: (p_location => 'xla_events_pub_pkg.get_event_status');
653: END get_event_status;
654:
655:
656: --============================================================================

Line 663: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

659: --
660: --============================================================================
661:
662: FUNCTION event_exists
663: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
664: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
665: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
666: ,p_event_date IN DATE DEFAULT NULL
667: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 670: ,p_security_context IN xla_events_pub_pkg.t_security)

666: ,p_event_date IN DATE DEFAULT NULL
667: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
668: ,p_event_number IN INTEGER DEFAULT NULL
669: ,p_valuation_method IN VARCHAR2
670: ,p_security_context IN xla_events_pub_pkg.t_security)
671: RETURN BOOLEAN IS
672: BEGIN
673: trace('@ xla_events_pub_pkg.event_exists' , 20);
674:

Line 673: trace('@ xla_events_pub_pkg.event_exists' , 20);

669: ,p_valuation_method IN VARCHAR2
670: ,p_security_context IN xla_events_pub_pkg.t_security)
671: RETURN BOOLEAN IS
672: BEGIN
673: trace('@ xla_events_pub_pkg.event_exists' , 20);
674:
675: xla_events_pub_pkg.g_security := p_security_context;
676: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
677:

Line 675: xla_events_pub_pkg.g_security := p_security_context;

671: RETURN BOOLEAN IS
672: BEGIN
673: trace('@ xla_events_pub_pkg.event_exists' , 20);
674:
675: xla_events_pub_pkg.g_security := p_security_context;
676: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
677:
678: RETURN xla_events_pkg.event_exists
679: (p_event_source_info => p_event_source_info

Line 676: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

672: BEGIN
673: trace('@ xla_events_pub_pkg.event_exists' , 20);
674:
675: xla_events_pub_pkg.g_security := p_security_context;
676: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
677:
678: RETURN xla_events_pkg.event_exists
679: (p_event_source_info => p_event_source_info
680: ,p_valuation_method => p_valuation_method

Line 691: (p_location => 'xla_events_pub_pkg.event_exists');

687: WHEN xla_exceptions_pkg.application_exception THEN
688: RAISE;
689: WHEN OTHERS THEN
690: xla_exceptions_pkg.raise_message
691: (p_location => 'xla_events_pub_pkg.event_exists');
692: END event_exists;
693:
694:
695: --============================================================================

Line 706: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

702: --
703: --============================================================================
704:
705: FUNCTION get_array_event_info
706: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
707: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
708: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
709: ,p_event_date IN DATE DEFAULT NULL
710: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 712: ,p_security_context IN xla_events_pub_pkg.t_security)

708: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
709: ,p_event_date IN DATE DEFAULT NULL
710: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
711: ,p_valuation_method IN VARCHAR2
712: ,p_security_context IN xla_events_pub_pkg.t_security)
713: RETURN xla_events_pub_pkg.t_array_event_info IS
714: BEGIN
715: trace('@ xla_events_pub_pkg.get_array_event_info' , 20);
716:

Line 713: RETURN xla_events_pub_pkg.t_array_event_info IS

709: ,p_event_date IN DATE DEFAULT NULL
710: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
711: ,p_valuation_method IN VARCHAR2
712: ,p_security_context IN xla_events_pub_pkg.t_security)
713: RETURN xla_events_pub_pkg.t_array_event_info IS
714: BEGIN
715: trace('@ xla_events_pub_pkg.get_array_event_info' , 20);
716:
717: xla_events_pub_pkg.g_security := p_security_context;

Line 715: trace('@ xla_events_pub_pkg.get_array_event_info' , 20);

711: ,p_valuation_method IN VARCHAR2
712: ,p_security_context IN xla_events_pub_pkg.t_security)
713: RETURN xla_events_pub_pkg.t_array_event_info IS
714: BEGIN
715: trace('@ xla_events_pub_pkg.get_array_event_info' , 20);
716:
717: xla_events_pub_pkg.g_security := p_security_context;
718: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
719:

Line 717: xla_events_pub_pkg.g_security := p_security_context;

713: RETURN xla_events_pub_pkg.t_array_event_info IS
714: BEGIN
715: trace('@ xla_events_pub_pkg.get_array_event_info' , 20);
716:
717: xla_events_pub_pkg.g_security := p_security_context;
718: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
719:
720: RETURN xla_events_pkg.get_array_event_info
721: (p_event_source_info => p_event_source_info

Line 718: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;

714: BEGIN
715: trace('@ xla_events_pub_pkg.get_array_event_info' , 20);
716:
717: xla_events_pub_pkg.g_security := p_security_context;
718: -- xla_events_pub_pkg.g_valuation_method := p_valuation_method;
719:
720: RETURN xla_events_pkg.get_array_event_info
721: (p_event_source_info => p_event_source_info
722: ,p_valuation_method => p_valuation_method

Line 732: (p_location => 'xla_events_pub_pkg.get_array_event_info');

728: WHEN xla_exceptions_pkg.application_exception THEN
729: RAISE;
730: WHEN OTHERS THEN
731: xla_exceptions_pkg.raise_message
732: (p_location => 'xla_events_pub_pkg.get_array_event_info');
733: END get_array_event_info;
734:
735: PROCEDURE create_bulk_events
736: (p_source_application_id IN INTEGER DEFAULT NULL

Line 742: trace('>BEGIN of procedure xla_events_pub_pkg.create_bulk_events' , 20);

738: ,p_legal_entity_id IN INTEGER DEFAULT NULL
739: ,p_ledger_id IN INTEGER
740: ,p_entity_type_code IN VARCHAR2) IS
741: BEGIN
742: trace('>BEGIN of procedure xla_events_pub_pkg.create_bulk_events' , 20);
743: xla_events_pkg.create_bulk_events(
744: p_source_application_id => p_source_application_id
745: , p_application_id => p_application_id
746: , p_legal_entity_id => p_legal_entity_id

Line 749: trace('>END of procedure xla_events_pub_pkg.create_bulk_events' , 20);

745: , p_application_id => p_application_id
746: , p_legal_entity_id => p_legal_entity_id
747: , p_ledger_id => p_ledger_id
748: , p_entity_type_code => p_entity_type_code);
749: trace('>END of procedure xla_events_pub_pkg.create_bulk_events' , 20);
750:
751: EXCEPTION
752: WHEN xla_exceptions_pkg.application_exception THEN
753: RAISE;

Line 756: (p_location => 'xla_events_pub_pkg.create_bulk_events');

752: WHEN xla_exceptions_pkg.application_exception THEN
753: RAISE;
754: WHEN OTHERS THEN
755: xla_exceptions_pkg.raise_message
756: (p_location => 'xla_events_pub_pkg.create_bulk_events');
757: END create_bulk_events;
758:
759:
760: PROCEDURE create_bulk_events

Line 768: trace('>BEGIN of procedure xla_events_pub_pkg.create_bulk_events' , 20);

764: ,p_ledger_id IN INTEGER
765: ,p_entity_type_code IN VARCHAR2
766: ,p_limit_size IN INTEGER) IS
767: BEGIN
768: trace('>BEGIN of procedure xla_events_pub_pkg.create_bulk_events' , 20);
769: xla_events_pkg.create_bulk_events(
770: p_source_application_id => p_source_application_id
771: , p_application_id => p_application_id
772: , p_legal_entity_id => p_legal_entity_id

Line 776: trace('>END of procedure xla_events_pub_pkg.create_bulk_events' , 20);

772: , p_legal_entity_id => p_legal_entity_id
773: , p_ledger_id => p_ledger_id
774: , p_entity_type_code => p_entity_type_code
775: , p_limit_size => p_limit_size);
776: trace('>END of procedure xla_events_pub_pkg.create_bulk_events' , 20);
777: EXCEPTION
778: WHEN xla_exceptions_pkg.application_exception THEN
779: RAISE;
780: WHEN OTHERS THEN

Line 782: (p_location => 'xla_events_pub_pkg.create_bulk_events');

778: WHEN xla_exceptions_pkg.application_exception THEN
779: RAISE;
780: WHEN OTHERS THEN
781: xla_exceptions_pkg.raise_message
782: (p_location => 'xla_events_pub_pkg.create_bulk_events');
783: END create_bulk_events;
784:
785: PROCEDURE update_bulk_event_statuses(p_application_id INTEGER) IS
786: BEGIN

Line 787: trace('>BEGIN of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);

783: END create_bulk_events;
784:
785: PROCEDURE update_bulk_event_statuses(p_application_id INTEGER) IS
786: BEGIN
787: trace('>BEGIN of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
788: xla_events_pkg.update_bulk_event_statuses(
789: p_application_id => p_application_id);
790: trace('>END of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
791:

Line 790: trace('>END of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);

786: BEGIN
787: trace('>BEGIN of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
788: xla_events_pkg.update_bulk_event_statuses(
789: p_application_id => p_application_id);
790: trace('>END of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
791:
792: EXCEPTION
793: WHEN xla_exceptions_pkg.application_exception THEN
794: RAISE;

Line 797: (p_location => 'xla_events_pub_pkg.update_bulk_event_statuses');

793: WHEN xla_exceptions_pkg.application_exception THEN
794: RAISE;
795: WHEN OTHERS THEN
796: xla_exceptions_pkg.raise_message
797: (p_location => 'xla_events_pub_pkg.update_bulk_event_statuses');
798: END update_bulk_event_statuses;
799:
800:
801: PROCEDURE update_bulk_event_statuses(p_application_id IN INTEGER

Line 804: trace('>BEGIN of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);

800:
801: PROCEDURE update_bulk_event_statuses(p_application_id IN INTEGER
802: ,p_limit_size IN INTEGER) IS
803: BEGIN
804: trace('>BEGIN of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
805: xla_events_pkg.update_bulk_event_statuses(
806: p_application_id => p_application_id
807: ,p_limit_size => p_limit_size);
808: trace('>END of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);

Line 808: trace('>END of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);

804: trace('>BEGIN of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
805: xla_events_pkg.update_bulk_event_statuses(
806: p_application_id => p_application_id
807: ,p_limit_size => p_limit_size);
808: trace('>END of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
809: EXCEPTION
810: WHEN xla_exceptions_pkg.application_exception THEN
811: RAISE;
812: WHEN OTHERS THEN

Line 814: (p_location => 'xla_events_pub_pkg.update_bulk_event_statuses');

810: WHEN xla_exceptions_pkg.application_exception THEN
811: RAISE;
812: WHEN OTHERS THEN
813: xla_exceptions_pkg.raise_message
814: (p_location => 'xla_events_pub_pkg.update_bulk_event_statuses');
815: END update_bulk_event_statuses;
816:
817:
818:

Line 829: (p_location => 'xla_events_pub_pkg.delete_bulk_events');

825: WHEN xla_exceptions_pkg.application_exception THEN
826: RAISE;
827: WHEN OTHERS THEN
828: xla_exceptions_pkg.raise_message
829: (p_location => 'xla_events_pub_pkg.delete_bulk_events');
830: END delete_bulk_events;
831:
832: -- For subledger teams uptake of Period Close validation.
833: PROCEDURE period_close (p_api_version IN NUMBER

Line 989: WF_CORE.CONTEXT( 'xla_events_pub_pkg', 'period_close',

985: EXCEPTION
986:
987: WHEN xla_exceptions_pkg.application_exception THEN
988:
989: WF_CORE.CONTEXT( 'xla_events_pub_pkg', 'period_close',
990: p_event.getEventName( ), p_subscription_guid);
991: WF_EVENT.setErrorInfo(p_event, 'ERROR');
992: RETURN 'ERROR';
993: -- Added for Bug 12312395

Line 1012: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

1008: --
1009: --============================================================================
1010:
1011: PROCEDURE update_transaction_number
1012: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
1013: ,p_transaction_number IN VARCHAR2
1014: ,p_valuation_method IN VARCHAR2
1015: ,p_security_context IN xla_events_pub_pkg.t_security
1016: ,p_event_id IN NUMBER DEFAULT NULL) IS -- 8761772

Line 1015: ,p_security_context IN xla_events_pub_pkg.t_security

1011: PROCEDURE update_transaction_number
1012: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
1013: ,p_transaction_number IN VARCHAR2
1014: ,p_valuation_method IN VARCHAR2
1015: ,p_security_context IN xla_events_pub_pkg.t_security
1016: ,p_event_id IN NUMBER DEFAULT NULL) IS -- 8761772
1017: BEGIN
1018: trace('> xla_events_pub_pkg.update_transaction_number' , 20);
1019:

Line 1018: trace('> xla_events_pub_pkg.update_transaction_number' , 20);

1014: ,p_valuation_method IN VARCHAR2
1015: ,p_security_context IN xla_events_pub_pkg.t_security
1016: ,p_event_id IN NUMBER DEFAULT NULL) IS -- 8761772
1017: BEGIN
1018: trace('> xla_events_pub_pkg.update_transaction_number' , 20);
1019:
1020: xla_events_pub_pkg.g_security := p_security_context;
1021: xla_events_pub_pkg.g_valuation_method := p_valuation_method;
1022:

Line 1020: xla_events_pub_pkg.g_security := p_security_context;

1016: ,p_event_id IN NUMBER DEFAULT NULL) IS -- 8761772
1017: BEGIN
1018: trace('> xla_events_pub_pkg.update_transaction_number' , 20);
1019:
1020: xla_events_pub_pkg.g_security := p_security_context;
1021: xla_events_pub_pkg.g_valuation_method := p_valuation_method;
1022:
1023: xla_events_pkg.update_transaction_number
1024: (p_event_source_info => p_event_source_info

Line 1021: xla_events_pub_pkg.g_valuation_method := p_valuation_method;

1017: BEGIN
1018: trace('> xla_events_pub_pkg.update_transaction_number' , 20);
1019:
1020: xla_events_pub_pkg.g_security := p_security_context;
1021: xla_events_pub_pkg.g_valuation_method := p_valuation_method;
1022:
1023: xla_events_pkg.update_transaction_number
1024: (p_event_source_info => p_event_source_info
1025: ,p_transaction_number => p_transaction_number

Line 1030: trace('< xla_events_pub_pkg.update_transaction_number' , 20);

1026: ,p_valuation_method => p_valuation_method
1027: ,p_event_id => p_event_id
1028: );
1029:
1030: trace('< xla_events_pub_pkg.update_transaction_number' , 20);
1031: EXCEPTION
1032: WHEN xla_exceptions_pkg.application_exception THEN
1033: RAISE;
1034: WHEN OTHERS THEN

Line 1036: (p_location => 'xla_events_pub_pkg.update_transaction_number');

1032: WHEN xla_exceptions_pkg.application_exception THEN
1033: RAISE;
1034: WHEN OTHERS THEN
1035: xla_exceptions_pkg.raise_message
1036: (p_location => 'xla_events_pub_pkg.update_transaction_number');
1037: END update_transaction_number;
1038:
1039:
1040: -------------------------------------------------------------------------------

Line 1051: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

1047: -- based on whether it has any accounted information for a Control Account.
1048: --============================================================================
1049:
1050: FUNCTION allow_third_party_update
1051: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
1052: ,p_valuation_method IN VARCHAR2
1053: ,p_security_context IN xla_events_pub_pkg.t_security)
1054: RETURN BOOLEAN IS
1055: BEGIN

Line 1053: ,p_security_context IN xla_events_pub_pkg.t_security)

1049:
1050: FUNCTION allow_third_party_update
1051: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
1052: ,p_valuation_method IN VARCHAR2
1053: ,p_security_context IN xla_events_pub_pkg.t_security)
1054: RETURN BOOLEAN IS
1055: BEGIN
1056: trace('> xla_events_pub_pkg.allow_third_party_update' , 20);
1057:

Line 1056: trace('> xla_events_pub_pkg.allow_third_party_update' , 20);

1052: ,p_valuation_method IN VARCHAR2
1053: ,p_security_context IN xla_events_pub_pkg.t_security)
1054: RETURN BOOLEAN IS
1055: BEGIN
1056: trace('> xla_events_pub_pkg.allow_third_party_update' , 20);
1057:
1058: xla_events_pub_pkg.g_security := p_security_context;
1059: xla_events_pub_pkg.g_valuation_method := p_valuation_method;
1060:

Line 1058: xla_events_pub_pkg.g_security := p_security_context;

1054: RETURN BOOLEAN IS
1055: BEGIN
1056: trace('> xla_events_pub_pkg.allow_third_party_update' , 20);
1057:
1058: xla_events_pub_pkg.g_security := p_security_context;
1059: xla_events_pub_pkg.g_valuation_method := p_valuation_method;
1060:
1061: RETURN xla_events_pkg.allow_third_party_update
1062: (p_event_source_info => p_event_source_info

Line 1059: xla_events_pub_pkg.g_valuation_method := p_valuation_method;

1055: BEGIN
1056: trace('> xla_events_pub_pkg.allow_third_party_update' , 20);
1057:
1058: xla_events_pub_pkg.g_security := p_security_context;
1059: xla_events_pub_pkg.g_valuation_method := p_valuation_method;
1060:
1061: RETURN xla_events_pkg.allow_third_party_update
1062: (p_event_source_info => p_event_source_info
1063: ,p_valuation_method => p_valuation_method);

Line 1065: trace('< xla_events_pub_pkg.allow_third_party_update' , 20);

1061: RETURN xla_events_pkg.allow_third_party_update
1062: (p_event_source_info => p_event_source_info
1063: ,p_valuation_method => p_valuation_method);
1064:
1065: trace('< xla_events_pub_pkg.allow_third_party_update' , 20);
1066: EXCEPTION
1067: WHEN xla_exceptions_pkg.application_exception THEN
1068: RAISE;
1069: WHEN OTHERS THEN

Line 1071: (p_location => 'xla_events_pub_pkg.allow_third_party_update');

1067: WHEN xla_exceptions_pkg.application_exception THEN
1068: RAISE;
1069: WHEN OTHERS THEN
1070: xla_exceptions_pkg.raise_message
1071: (p_location => 'xla_events_pub_pkg.allow_third_party_update');
1072: END allow_third_party_update;
1073:
1074:
1075: BEGIN

Line 1085: END xla_events_pub_pkg;

1081: IF NOT g_log_enabled THEN
1082: g_log_level := C_LEVEL_LOG_DISABLED;
1083: END IF;
1084:
1085: END xla_events_pub_pkg;