[Home] [Help]
1: PACKAGE BODY xla_events_pkg AS
2: -- $Header: xlaevevt.pkb 120.99 2007/12/04 19:53:47 ssawhney ship $
3: /*===========================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |
8: | FILENAME |
9: | xlaevevt.pkb |
10: | |
11: | PACKAGE NAME |
12: | xla_events_pkg |
13: | |
14: | DESCRIPTION |
15: | This is a XLA private package, which contains all the APIs |
16: | required for processing accounting events. |
261: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
262:
263: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
264:
265: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_events_pkg';
266:
267: g_debug_flag VARCHAR2(1):= NVL(fnd_profile.value('XLA_DEBUG_TRACE'),'N');
268:
269: --l_log_module VARCHAR2(240);
415: WHEN xla_exceptions_pkg.application_exception THEN
416: RAISE;
417: WHEN OTHERS THEN
418: xla_exceptions_pkg.raise_message
419: (p_location => 'xla_events_pkg.trace');
420: END trace;
421:
422: --=============================================================================
423: -- *********** public procedures and functions **********
644: ,p_msg_name => 'XLA_COMMON_ERROR'
645: ,p_token_1 => 'ERROR'
646: ,p_value_1 => 'For MANUAL events this API cannot be called'
647: ,p_token_2 => 'LOCATION'
648: ,p_value_2 => 'xla_events_pkg.get_array_event_info (fn)');
649: ELSE
650: g_context := C_REGULAR_EVENT_CONTEXT;
651: END IF;
652:
657: ,p_token_1 => 'ERROR'
658: ,p_value_1 =>
659: 'Event Type Code has an invalid value. It cannot have a NULL value.'
660: ,p_token_2 => 'LOCATION'
661: ,p_value_2 => 'xla_events_pkg.create_event');
662: END IF;
663: IF p_event_date IS NULL THEN
664: xla_exceptions_pkg.raise_message
665: (p_appli_s_name => 'XLA'
667: ,p_token_1 => 'ERROR'
668: ,p_value_1 =>
669: 'Event Date has an invalid value. It cannot have a NULL value.'
670: ,p_token_2 => 'LOCATION'
671: ,p_value_2 => 'xla_events_pkg.create_event');
672: END IF;
673: IF p_event_status_code IS NULL THEN
674: xla_exceptions_pkg.raise_message
675: (p_appli_s_name => 'XLA'
677: ,p_token_1 => 'ERROR'
678: ,p_value_1 =>
679: 'Event Status Code has an invalid value. It cannot have a NULL value.'
680: ,p_token_2 => 'LOCATION'
681: ,p_value_2 => 'xla_events_pkg.create_event');
682: END IF;
683:
684: ----------------------------------------------------------------------------
685: -- truncate date
726: ,p_token_1 => 'ERROR'
727: ,p_value_1 =>
728: 'The developer has to give the event number greater than 0 when create new event for gapless processing.'
729: ,p_token_2 => 'LOCATION'
730: ,p_value_2 => 'xla_events_pkg.create_event');
731: END IF;
732: ----------------------------------------------------------------------------
733: -- If the PK is NULL, create an entity as well as the event. Otherwise,
734: -- add a new event to the entity.
796: RAISE;
797: WHEN OTHERS THEN
798: ROLLBACK to SAVEPOINT before_event_creation;
799: xla_exceptions_pkg.raise_message
800: (p_location => 'xla_events_pkg.create_event (fn)');
801: END create_event;
802:
803:
804: --=============================================================================
975: ,p_msg_name => 'XLA_COMMON_ERROR'
976: ,p_token_1 => 'ERROR'
977: ,p_value_1 => 'For REGULAR events this API cannot be called'
978: ,p_token_2 => 'LOCATION'
979: ,p_value_2 => 'xla_events_pkg.get_array_event_info (fn)');
980: END IF;
981:
982: ----------------------------------------------------------------------------
983: -- perform specific validations for 'creating events'
989: ,p_token_1 => 'ERROR'
990: ,p_value_1 =>
991: 'Event Type Code has an invalid value. It cannot have a NULL value.'
992: ,p_token_2 => 'LOCATION'
993: ,p_value_2 => 'xla_events_pkg.create_manual_event');
994: END IF;
995: IF p_event_date IS NULL THEN
996: xla_exceptions_pkg.raise_message
997: (p_appli_s_name => 'XLA'
998: ,p_msg_name => 'XLA_COMMON_ERROR'
999: ,p_token_1 => 'ERROR'
1000: ,p_value_1 => 'Event Date cannot have a NULL value.'
1001: ,p_token_2 => 'LOCATION'
1002: ,p_value_2 => 'xla_events_pkg.create_manual_event');
1003: END IF;
1004: IF p_event_status_code IS NULL THEN
1005: xla_exceptions_pkg.raise_message
1006: (p_appli_s_name => 'XLA'
1007: ,p_msg_name => 'XLA_COMMON_ERROR'
1008: ,p_token_1 => 'ERROR'
1009: ,p_value_1 => 'Event Status Code cannot have a NULL value.'
1010: ,p_token_2 => 'LOCATION'
1011: ,p_value_2 => 'xla_events_pkg.create_manual_event');
1012: END IF;
1013: IF p_process_status_code IS NULL THEN
1014: xla_exceptions_pkg.raise_message
1015: (p_appli_s_name => 'XLA'
1016: ,p_msg_name => 'XLA_COMMON_ERROR'
1017: ,p_token_1 => 'ERROR'
1018: ,p_value_1 => 'Process Status Code cannot have a NULL value.'
1019: ,p_token_2 => 'LOCATION'
1020: ,p_value_2 => 'xla_events_pkg.create_manual_event');
1021: END IF;
1022:
1023: ----------------------------------------------------------------------------
1024: -- truncate date
1115: RAISE;
1116: WHEN OTHERS THEN
1117: ROLLBACK to SAVEPOINT before_event_creation;
1118: xla_exceptions_pkg.raise_message
1119: (p_location => 'xla_events_pkg.create_manual_event (fn)');
1120: END create_manual_event;
1121:
1122:
1123:
1289: ,p_msg_name => 'XLA_COMMON_ERROR'
1290: ,p_token_1 => 'ERROR'
1291: ,p_value_1 => 'For MANUAL events this API cannot be called'
1292: ,p_token_2 => 'LOCATION'
1293: ,p_value_2 => 'xla_events_pkg.get_array_event_info (fn)');
1294: ELSE
1295: g_context := C_REGULAR_EVENT_CONTEXT;
1296: END IF;
1297:
1304: ,p_msg_name => 'XLA_COMMON_ERROR'
1305: ,p_token_1 => 'ERROR'
1306: ,p_value_1 => 'Event Status Code cannot have a NULL value.'
1307: ,p_token_2 => 'LOCATION'
1308: ,p_value_2 => 'xla_events_pkg.update_event_status');
1309: END IF;
1310:
1311: ----------------------------------------------------------------------------
1312: -- truncate date
1352: ,p_token_1 => 'ERROR'
1353: ,p_value_1 => 'No event exists for the document represented '||
1354: 'by the given source information.'
1355: ,p_token_2 => 'LOCATION'
1356: ,p_value_2 => 'xla_events_pkg.update_event_status');
1357: END IF;
1358:
1359: ----------------------------------------------------------------------------
1360: -- Fetching event ids for the events that are going to be updated
1520: RAISE;
1521: WHEN OTHERS THEN
1522: ROLLBACK to SAVEPOINT before_event_update;
1523: xla_exceptions_pkg.raise_message
1524: (p_location => 'xla_events_pkg.update_event_status');
1525: END update_event_status;
1526:
1527:
1528: --=============================================================================
1712: ,p_msg_name => 'XLA_COMMON_ERROR'
1713: ,p_token_1 => 'ERROR'
1714: ,p_value_1 => 'For MANUAL events this API cannot be called'
1715: ,p_token_2 => 'LOCATION'
1716: ,p_value_2 => 'xla_events_pkg.update_event');
1717: ELSE
1718: g_context := C_REGULAR_EVENT_CONTEXT;
1719: END IF;
1720:
1727: ,p_msg_name => 'XLA_COMMON_ERROR'
1728: ,p_token_1 => 'ERROR'
1729: ,p_value_1 => 'Event ID cannot have a NULL value.'
1730: ,p_token_2 => 'LOCATION'
1731: ,p_value_2 => 'xla_events_pkg.update_event');
1732: END IF;
1733:
1734:
1735: IF p_event_status_code IS NOT NULL THEN
1787: ,p_token_1 => 'ERROR'
1788: ,p_value_1 => 'No event exists for the document represented '||
1789: 'by the given source information.'
1790: ,p_token_2 => 'LOCATION'
1791: ,p_value_2 => 'xla_events_pkg.update_event');
1792: END IF;
1793:
1794: if(g_gapless_flag='Y' and
1795: (p_overwrite_event_num=C_YES and
1800: ,p_token_1 => 'ERROR'
1801: ,p_value_1 =>
1802: 'The developer has to give the event number when change event number for gapless processing.'
1803: ,p_token_2 => 'LOCATION'
1804: ,p_value_2 => 'xla_events_pkg.update_event');
1805:
1806: end if;
1807: ----------------------------------------------------------------------------
1808: -- Following statement make sure that when event type and/or event date
1857: ,p_value_1 =>
1858: 'Unable to perform UPDATE on the event. The event ('||p_event_id ||
1859: ') is either invalid or has been final accounted.'
1860: ,p_token_2 => 'LOCATION'
1861: ,p_value_2 => 'xla_events_pkg.update_event');
1862: END;
1863: END IF;
1864: ----------------------------------------------------------------------------
1865: -- Actual update
1915: ,p_value_1 =>
1916: 'Unable to perform UPDATE on the event. The event ('||p_event_id ||
1917: ') is either invalid or has been final accounted.'
1918: ,p_token_2 => 'LOCATION'
1919: ,p_value_2 => 'xla_events_pkg.update_event');
1920: END IF;
1921:
1922: if(g_gapless_flag='Y' and
1923: ((p_overwrite_event_num=C_YES
2054: RAISE;
2055: WHEN OTHERS THEN
2056: ROLLBACK to SAVEPOINT before_event_update;
2057: xla_exceptions_pkg.raise_message
2058: (p_location => 'xla_events_pkg.update_event');
2059: END update_event;
2060:
2061:
2062: --=============================================================================
2241: ,p_msg_name => 'XLA_COMMON_ERROR'
2242: ,p_token_1 => 'ERROR'
2243: ,p_value_1 => 'For REGULAR events this API cannot be called'
2244: ,p_token_2 => 'LOCATION'
2245: ,p_value_2 => 'xla_events_pkg.update_manual_event');
2246: END IF;
2247:
2248: ----------------------------------------------------------------------------
2249: -- perfrom validations specific to 'updating event'
2254: ,p_msg_name => 'XLA_COMMON_ERROR'
2255: ,p_token_1 => 'ERROR'
2256: ,p_value_1 => 'Event ID cannot have a NULL value.'
2257: ,p_token_2 => 'LOCATION'
2258: ,p_value_2 => 'xla_events_pkg.update_manual_event');
2259: END IF;
2260:
2261: ----------------------------------------------------------------------------
2262: -- validate to make sure that both p_event_status_code and
2272: ,p_value_1 => 'Inconsistent values for event statuses: '||
2273: 'p_event_status_code = '||p_event_status_code||
2274: 'p_process_status_code = '||p_process_status_code
2275: ,p_token_2 => 'LOCATION'
2276: ,p_value_2 => 'xla_events_pkg.update_manual_event');
2277: END IF;
2278:
2279: ----------------------------------------------------------------------------
2280: -- truncate date
2315: ,p_token_1 => 'ERROR'
2316: ,p_value_1 => 'No event exists for the document represented '||
2317: 'by the given source information.'
2318: ,p_token_2 => 'LOCATION'
2319: ,p_value_2 => 'xla_events_pkg.update_manual_event');
2320: END IF;
2321:
2322: ----------------------------------------------------------------------------
2323: -- Actual status update
2381: ,p_value_1 =>
2382: 'Unable to perform UPDATE on the event. The event ('||p_event_id ||
2383: ') is invalid'
2384: ,p_token_2 => 'LOCATION'
2385: ,p_value_2 => 'xla_events_pkg.update_manual_event');
2386: END IF;
2387:
2388: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2389: trace
2398: RAISE;
2399: WHEN OTHERS THEN
2400: ROLLBACK to SAVEPOINT before_event_update;
2401: xla_exceptions_pkg.raise_message
2402: (p_location => 'xla_events_pkg.update_manual_event');
2403: END update_manual_event;
2404:
2405:
2406: --=============================================================================
2564: ,p_msg_name => 'XLA_COMMON_ERROR'
2565: ,p_token_1 => 'ERROR'
2566: ,p_value_1 => 'Event ID cannot have a NULL value.'
2567: ,p_token_2 => 'LOCATION'
2568: ,p_value_2 => 'xla_events_pkg.delete_event');
2569: END IF;
2570:
2571: ----------------------------------------------------------------------------
2572: -- Validate parameters
2599: ,p_token_1 => 'ERROR'
2600: ,p_value_1 => 'No event exists for the document represented '||
2601: 'by the given source information.'
2602: ,p_token_2 => 'LOCATION'
2603: ,p_value_2 => 'xla_events_pkg.delete_event');
2604: END IF;
2605:
2606: ----------------------------------------------------------------------------
2607: -- Call routine to delete errors/JEs related to the event bug # 2701681
2626: ,p_value_1 =>
2627: 'Unable to perform DELETE on the event. The event ('|| p_event_id ||
2628: ') is either invalid or has been final accounted.'
2629: ,p_token_2 => 'LOCATION'
2630: ,p_value_2 => 'xla_events_pkg.delete_event');
2631: end;
2632: end if;
2633:
2634: ----------------------------------------------------------------------------
2656: ,p_value_1 =>
2657: 'Unable to perform DELETE on the event. The event ('|| p_event_id ||
2658: ') is either invalid or has been final accounted.'
2659: ,p_token_2 => 'LOCATION'
2660: ,p_value_2 => 'xla_events_pkg.delete_event');
2661:
2662: ELSIF g_context = C_MANUAL_EVENT_CONTEXT THEN
2663: --------------------------------------------------------------------------
2664: -- this if condition is added to make sure that the entity row is
2706: RAISE;
2707: WHEN OTHERS THEN
2708: ROLLBACK to SAVEPOINT before_event_delete;
2709: xla_exceptions_pkg.raise_message
2710: (p_location => 'xla_events_pkg.delete_event');
2711: END delete_event;
2712:
2713:
2714: --=============================================================================
2835: ,p_level => C_LEVEL_PROCEDURE
2836: ,p_module =>l_log_module);
2837: END IF;
2838:
2839: trace('> xla_events_pkg.delete_processed_event' , 20);
2840:
2841: SAVEPOINT before_event_delete;
2842: g_action := C_EVENT_DELETE;
2843:
2858: ,p_msg_name => 'XLA_COMMON_ERROR'
2859: ,p_token_1 => 'ERROR'
2860: ,p_value_1 => 'For REGULAR events this API cannot be called'
2861: ,p_token_2 => 'LOCATION'
2862: ,p_value_2 => 'xla_events_pkg.delete_processed_event');
2863: END IF;
2864:
2865: ----------------------------------------------------------------------------
2866: -- perform validations specific to 'deleting event'
2871: ,p_msg_name => 'XLA_COMMON_ERROR'
2872: ,p_token_1 => 'ERROR'
2873: ,p_value_1 => 'Event ID cannot have a NULL value.'
2874: ,p_token_2 => 'LOCATION'
2875: ,p_value_2 => 'xla_events_pkg.delete_processed_event');
2876: END IF;
2877:
2878: ----------------------------------------------------------------------------
2879: -- Validate parameters
2906: ,p_token_1 => 'ERROR'
2907: ,p_value_1 => 'No event exists for the document represented '||
2908: 'by the given source information.'
2909: ,p_token_2 => 'LOCATION'
2910: ,p_value_2 => 'xla_events_pkg.delete_processed_event');
2911: END IF;
2912:
2913: ----------------------------------------------------------------------------
2914: -- Call routine to delete errors/JEs related to the event bug # 2701681
2942: ,p_value_1 =>
2943: 'Unable to perform DELETE on the event. The event ('|| p_event_id ||
2944: ') is either invalid or has not been final accounted.'
2945: ,p_token_2 => 'LOCATION'
2946: ,p_value_2 => 'xla_events_pkg.delete_processed_event');
2947: ELSE
2948: -------------------------------------------------------------------------
2949: -- following will delete the row from entities if there is no
2950: -- event exists for the entity
2981: RAISE;
2982: WHEN OTHERS THEN
2983: ROLLBACK to SAVEPOINT before_event_delete;
2984: xla_exceptions_pkg.raise_message
2985: (p_location => 'xla_events_pkg.delete_processed_event');
2986: END delete_processed_event;
2987:
2988:
2989: --=============================================================================
3147: ,p_msg_name => 'XLA_COMMON_ERROR'
3148: ,p_token_1 => 'ERROR'
3149: ,p_value_1 => 'For MANUAL events this API cannot be called'
3150: ,p_token_2 => 'LOCATION'
3151: ,p_value_2 => 'xla_events_pkg.delete_events');
3152: ELSE
3153: g_context := C_REGULAR_EVENT_CONTEXT;
3154: END IF;
3155:
3191: ,p_token_1 => 'ERROR'
3192: ,p_value_1 => 'No event exists for the document represented '||
3193: 'by the given source information.'
3194: ,p_token_2 => 'LOCATION'
3195: ,p_value_2 => 'xla_events_pkg.delete_events (fn)');
3196: END IF;
3197:
3198: ----------------------------------------------------------------------------
3199: -- Fetching event ids for the events that are going to be deleted
3291: RAISE;
3292: WHEN OTHERS THEN
3293: ROLLBACK to SAVEPOINT before_event_delete;
3294: xla_exceptions_pkg.raise_message
3295: (p_location => 'xla_events_pkg.delete_events (fn)');
3296: END delete_events;
3297:
3298:
3299: --============================================================================
3479: ,p_token_1 => 'ERROR'
3480: ,p_value_1 =>
3481: 'Unable to perform DELETE on the entity. The entity does not exist'
3482: ,p_token_2 => 'LOCATION'
3483: ,p_value_2 => 'xla_events_pkg.delete_entity');
3484: END;
3485:
3486: OPEN c_existing_events;
3487: FETCH c_existing_events into l_temp;
3530: RAISE;
3531: WHEN OTHERS THEN
3532: ROLLBACK to SAVEPOINT before_entity_delete;
3533: xla_exceptions_pkg.raise_message
3534: (p_location => 'xla_events_pkg.delete_entity');
3535: END delete_entity;
3536:
3537: --=============================================================================
3538: --
3543:
3544: PROCEDURE purge_entity
3545: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info) IS
3546: BEGIN
3547: trace('> xla_events_pkg.delete_entity' , 20);
3548:
3549: SAVEPOINT before_entity_delete;
3550: g_action := C_EVENT_DELETE;
3551:
3579: ,p_token_1 => 'ERROR'
3580: ,p_value_1 =>
3581: 'No event exists for the document represented by the given source information.'
3582: ,p_token_2 => 'LOCATION'
3583: ,p_value_2 => 'xla_events_pkg.delete_entity');
3584: END IF;
3585:
3586: trace('< xla_events_pkg.delete_entity' , 20);
3587: EXCEPTION
3582: ,p_token_2 => 'LOCATION'
3583: ,p_value_2 => 'xla_events_pkg.delete_entity');
3584: END IF;
3585:
3586: trace('< xla_events_pkg.delete_entity' , 20);
3587: EXCEPTION
3588: WHEN xla_exceptions_pkg.application_exception THEN
3589: ROLLBACK to SAVEPOINT before_entity_delete;
3590: RAISE;
3590: RAISE;
3591: WHEN OTHERS THEN
3592: ROLLBACK to SAVEPOINT before_entity_delete;
3593: xla_exceptions_pkg.raise_message
3594: (p_location => 'xla_events_pkg.delete_entity');
3595: END purge_entity;
3596:
3597:
3598: --=============================================================================
3756: ,p_token_1 => 'ERROR'
3757: ,p_value_1 =>
3758: 'Event ID has an invalid value. It cannot have a NULL value.'
3759: ,p_token_2 => 'LOCATION'
3760: ,p_value_2 => 'xla_events_pkg.get_event_info');
3761: END IF;
3762:
3763: ----------------------------------------------------------------------------
3764: -- Validate parameters
3791: ,p_token_1 => 'ERROR'
3792: ,p_value_1 => 'No event exists for the document represented '||
3793: 'by the given source information.'
3794: ,p_token_2 => 'LOCATION'
3795: ,p_value_2 => 'xla_events_pkg.get_event_info');
3796: END IF;
3797:
3798: SELECT event_id
3799: ,event_number
3850: ,p_msg_name => 'XLA_COMMON_ERROR'
3851: ,p_token_1 => 'ERROR'
3852: ,p_value_1 => 'The event id '||p_event_id||' does not exist'
3853: ,p_token_2 => 'LOCATION'
3854: ,p_value_2 => 'xla_events_pkg.get_event_info');
3855: WHEN xla_exceptions_pkg.application_exception THEN
3856: RAISE;
3857: WHEN OTHERS THEN
3858: xla_exceptions_pkg.raise_message
3855: WHEN xla_exceptions_pkg.application_exception THEN
3856: RAISE;
3857: WHEN OTHERS THEN
3858: xla_exceptions_pkg.raise_message
3859: (p_location => 'xla_events_pkg.get_event_info (fn)');
3860: END get_event_info;
3861:
3862:
3863: --=============================================================================
4012: WHEN xla_exceptions_pkg.application_exception THEN
4013: RAISE;
4014: WHEN OTHERS THEN
4015: xla_exceptions_pkg.raise_message
4016: (p_location => 'xla_events_pkg.get_event_status (fn)');
4017: END get_event_status ;
4018:
4019:
4020: --=============================================================================
4208: ,p_msg_name => 'XLA_COMMON_ERROR'
4209: ,p_token_1 => 'ERROR'
4210: ,p_value_1 => 'For MANUAL events event_id cannot be NULL'
4211: ,p_token_2 => 'LOCATION'
4212: ,p_value_2 => 'xla_events_pkg.event_exists');
4213: END IF;
4214: g_context := C_MANUAL_EVENT_CONTEXT;
4215: ELSE
4216: g_context := C_REGULAR_EVENT_CONTEXT;
4270: ,p_token_1 => 'ERROR'
4271: ,p_value_1 => 'No event exists for the document represented '||
4272: 'by the given source information.'
4273: ,p_token_2 => 'LOCATION'
4274: ,p_value_2 => 'xla_events_pkg.event_exists (fn)');
4275: */
4276: END IF;
4277:
4278: OPEN c1;
4324: IF c1%ISOPEN THEN
4325: CLOSE c1;
4326: END IF;
4327: xla_exceptions_pkg.raise_message
4328: (p_location => 'xla_events_pkg.event_exists (fn)');
4329: END event_exists;
4330:
4331:
4332: --=============================================================================
4480: ,p_msg_name => 'XLA_COMMON_ERROR'
4481: ,p_token_1 => 'ERROR'
4482: ,p_value_1 => 'For MANUAL events event_id cannot be NULL'
4483: ,p_token_2 => 'LOCATION'
4484: ,p_value_2 => 'xla_events_pkg.update_transaction_number');
4485: END IF;
4486: g_context := C_MANUAL_EVENT_CONTEXT;
4487: ELSE
4488: g_context := C_REGULAR_EVENT_CONTEXT;
4521: ,p_token_1 => 'ERROR'
4522: ,p_value_1 => 'No event exists for the document represented '||
4523: 'by the given source information.'
4524: ,p_token_2 => 'LOCATION'
4525: ,p_value_2 => 'xla_events_pkg.update_transaction_number');
4526: END IF;
4527:
4528: update_entity_trx_number
4529: (p_transaction_number => p_transaction_number);
4539: WHEN xla_exceptions_pkg.application_exception THEN
4540: RAISE;
4541: WHEN OTHERS THEN
4542: xla_exceptions_pkg.raise_message
4543: (p_location => 'xla_events_pkg.update_transaction_number');
4544: END update_transaction_number;
4545:
4546:
4547: --=============================================================================
4691: ,p_msg_name => 'XLA_COMMON_ERROR'
4692: ,p_token_1 => 'ERROR'
4693: ,p_value_1 => 'For MANUAL events event_id cannot be NULL'
4694: ,p_token_2 => 'LOCATION'
4695: ,p_value_2 => 'xla_events_pkg.get_entity_id');
4696: END IF;
4697: g_context := C_MANUAL_EVENT_CONTEXT;
4698: ELSE
4699: g_context := C_REGULAR_EVENT_CONTEXT;
4730: ,p_token_1 => 'ERROR'
4731: ,p_value_1 => 'No event exists for the document represented '||
4732: 'by the given source information.'
4733: ,p_token_2 => 'LOCATION'
4734: ,p_value_2 => 'xla_events_pkg.get_entity_id');
4735: END IF;
4736:
4737: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4738: trace
4750: WHEN xla_exceptions_pkg.application_exception THEN
4751: RAISE;
4752: WHEN OTHERS THEN
4753: xla_exceptions_pkg.raise_message
4754: (p_location => 'xla_events_pkg.get_entity_id');
4755: END get_entity_id;
4756:
4757:
4758: --=============================================================================
4953: ,p_msg_name => 'XLA_COMMON_ERROR'
4954: ,p_token_1 => 'ERROR'
4955: ,p_value_1 => 'For MANUAL events this API cannot be called'
4956: ,p_token_2 => 'LOCATION'
4957: ,p_value_2 => 'xla_events_pkg.get_array_event_info (fn)');
4958: ELSE
4959: g_context := C_REGULAR_EVENT_CONTEXT;
4960: END IF;
4961:
5011: ,p_token_1 => 'ERROR'
5012: ,p_value_1 =>
5013: 'Event Number must be a number greater than 0 for entities that are subject to gapless processing'
5014: ,p_token_2 => 'LOCATION'
5015: ,p_value_2 => 'xla_events_pkg.create_bulk_events');
5016: return;
5017: end if;
5018: close csr_xla_event_number;
5019: end if;
5060: ,p_token_1 => 'ERROR'
5061: ,p_value_1 =>
5062: 'The parameters passed to the procedure do not match with the data in the xla_events_int_gt table'
5063: ,p_token_2 => 'LOCATION'
5064: ,p_value_2 => 'xla_events_pkg.create_bulk_events');
5065: return;
5066: end if;
5067: close csr_parameter_mismatch;
5068:
5075: ,p_msg_name => 'XLA_COMMON_ERROR'
5076: ,p_token_1 => 'ERROR'
5077: ,p_value_1 => 'Event status must be I, U or N'
5078: ,p_token_2 => 'LOCATION'
5079: ,p_value_2 => 'xla_events_pkg.create_bulk_events');
5080: return;
5081: end if;
5082: close csr_status_error;
5083:
5090: ,p_msg_name => 'XLA_COMMON_ERROR'
5091: ,p_token_1 => 'ERROR'
5092: ,p_value_1 => 'Event type must be a valid event type'
5093: ,p_token_2 => 'LOCATION'
5094: ,p_value_2 => 'xla_events_pkg.create_bulk_events');
5095: return;
5096: end if;
5097: close csr_event_type_error;
5098:
5102: ,p_token_1 => 'ERROR'
5103: ,p_value_1 =>
5104: 'Please check transaction ids in gt table. Mapped ids must have a not-null value, while unmapped ids cannot have value'
5105: ,p_token_2 => 'LOCATION'
5106: ,p_value_2 => 'xla_events_pkg.create_bulk_events');
5107: EXCEPTION
5108: WHEN others then
5109: --exception means the data is good
5110: null;
5475: RAISE;
5476: WHEN OTHERS THEN
5477: ROLLBACK to SAVEPOINT before_event_creation;
5478: xla_exceptions_pkg.raise_message
5479: (p_location => 'xla_events_pkg.create_bulk_events(blk)');
5480: END create_bulk_events;
5481:
5482:
5483: --=============================================================================
5643: ,p_token_1 => 'ERROR'
5644: ,p_value_1 =>
5645: 'The parameter application_id does not match with the data in xla_events_int_gt table'
5646: ,p_token_2 => 'LOCATION'
5647: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses(fn)');
5648: end if;
5649: close csr_invalid_app;
5650:
5651: open csr_invalid_event_id(p_application_id);
5657: ,p_msg_name => 'XLA_COMMON_ERROR'
5658: ,p_token_1 => 'ERROR'
5659: ,p_value_1 => '(Application id, Event ID) is not valid'
5660: ,p_token_2 => 'LOCATION'
5661: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses(fn)');
5662: end if;
5663: close csr_invalid_event_id;
5664:
5665: open csr_invalid_event_status(p_application_id);
5672: ,p_token_1 => 'ERROR'
5673: ,p_value_1 =>
5674: 'Both the new and the old event status must be valid and cannot be P'
5675: ,p_token_2 => 'LOCATION'
5676: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses(fn)');
5677: end if;
5678: close csr_invalid_event_status;
5679:
5680: -- If reach here, must be entity code error
5684: ,p_token_1 => 'ERROR'
5685: ,p_value_1 =>
5686: 'The entity_code is not valid. Either it does not match with the event id, or it is MANUAL entity. This API cannot be called for MANUAL entity'
5687: ,p_token_2 => 'LOCATION'
5688: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses(fn)');
5689: end if;
5690: close csr_manual_processed_events;
5691:
5692:
5827: ,p_token_1 => 'ERROR'
5828: ,p_value_1 =>
5829: 'Error in the routine that does balance reversals'
5830: ,p_token_2 => 'LOCATION'
5831: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses');
5832: END IF;
5833: */
5834: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
5835: trace
5852: RAISE;
5853: WHEN OTHERS THEN
5854: ROLLBACK to SAVEPOINT before_update_bulk_statuses;
5855: xla_exceptions_pkg.raise_message
5856: (p_location => 'xla_events_pkg.update_bulk_event_statuses(blk)');
5857: END update_bulk_event_statuses;
5858:
5859:
5860: --=============================================================================
5986: ,p_token_1 => 'ERROR'
5987: ,p_value_1 =>
5988: 'The parameter application_id does not match with the data in xla_events_int_gt table'
5989: ,p_token_2 => 'LOCATION'
5990: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses(fn)');
5991: end if;
5992: close csr_invalid_app;
5993:
5994: open csr_invalid_event_id(p_application_id);
6000: ,p_msg_name => 'XLA_COMMON_ERROR'
6001: ,p_token_1 => 'ERROR'
6002: ,p_value_1 => '(Application id, Event ID) is not valid'
6003: ,p_token_2 => 'LOCATION'
6004: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses(fn)');
6005: end if;
6006: close csr_invalid_event_id;
6007:
6008: open csr_invalid_event_status(p_application_id);
6015: ,p_token_1 => 'ERROR'
6016: ,p_value_1 =>
6017: 'The events to be deleted must be in status I, N or U'
6018: ,p_token_2 => 'LOCATION'
6019: ,p_value_2 => 'xla_events_pkg.update_bulk_event_statuses(fn)');
6020: end if;
6021: close csr_invalid_event_status;
6022:
6023: -- if reach here, it must be entity code problem
6027: ,p_token_1 => 'ERROR'
6028: ,p_value_1 =>
6029: 'Either the entity code does not match with the event id, or the entity code is MANUAL. This API cannot be called to delete event for MANUAL entity'
6030: ,p_token_2 => 'LOCATION'
6031: ,p_value_2 => 'xla_events_pkg.get_array_event_info (fn)');
6032: end if;
6033: close csr_manual_processed_events;
6034:
6035: ----------------------------------------------------------------------------
6070: ,p_token_1 => 'ERROR'
6071: ,p_value_1 =>
6072: 'Error in the routine that does balance reversals'
6073: ,p_token_2 => 'LOCATION'
6074: ,p_value_2 => 'xla_events_pkg.delete_bulk_events');
6075: END IF;
6076: */
6077:
6078: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
6163: RAISE;
6164: WHEN OTHERS THEN
6165: ROLLBACK to SAVEPOINT before_delete_bulk_event;
6166: xla_exceptions_pkg.raise_message
6167: (p_location => 'xla_events_pkg.delete_bulk_events(blk)');
6168: END delete_bulk_events;
6169:
6170: --=============================================================================
6171: --
6359: ,p_msg_name => 'XLA_COMMON_ERROR'
6360: ,p_token_1 => 'ERROR'
6361: ,p_value_1 => 'For MANUAL events this API cannot be called'
6362: ,p_token_2 => 'LOCATION'
6363: ,p_value_2 => 'xla_events_pkg.get_array_event_info (fn)');
6364: ELSE
6365: g_context := C_REGULAR_EVENT_CONTEXT;
6366: END IF;
6367:
6404: ,p_token_1 => 'ERROR'
6405: ,p_value_1 => 'No event exists for the document represented '||
6406: 'by the given source information.'
6407: ,p_token_2 => 'LOCATION'
6408: ,p_value_2 => 'xla_events_pkg.get_array_event_info (fn)');
6409: END IF;
6410:
6411: FOR lc_evt IN c1 LOOP
6412: l_count := l_count + 1;
6447: WHEN xla_exceptions_pkg.application_exception THEN
6448: RAISE;
6449: WHEN OTHERS THEN
6450: xla_exceptions_pkg.raise_message
6451: (p_location => 'xla_events_pkg.get_array_event_info (fn)');
6452: END get_array_event_info;
6453:
6454:
6455: --=============================================================================
6529: WHEN xla_exceptions_pkg.application_exception THEN
6530: RAISE;
6531: WHEN OTHERS THEN
6532: xla_exceptions_pkg.raise_message
6533: (p_location => 'xla_events_pkg.initialize');
6534: END initialize;
6535:
6536:
6537: --=============================================================================
6666: WHEN xla_exceptions_pkg.application_exception THEN
6667: RAISE;
6668: WHEN OTHERS THEN
6669: xla_exceptions_pkg.raise_message
6670: (p_location => 'xla_events_pkg.source_info_changed');
6671: END;
6672:
6673:
6674: --=============================================================================
6700: ,p_token_1 => 'ERROR'
6701: ,p_value_1 =>
6702: 'Application ID has an invalid value. It cannot have a NULL value.'
6703: ,p_token_2 => 'LOCATION'
6704: ,p_value_2 => 'xla_events_pkg.validate_context');
6705: END IF;
6706:
6707: IF p_ledger_id IS NULL THEN
6708: xla_exceptions_pkg.raise_message
6711: ,p_token_1 => 'ERROR'
6712: ,p_value_1 =>
6713: 'Ledger ID has an invalid value. It cannot have a NULL value.'
6714: ,p_token_2 => 'LOCATION'
6715: ,p_value_2 => 'xla_events_pkg.validate_context');
6716: ELSE
6717: -------------------------------------------------------------------------
6718: -- Validate ledger
6719: -------------------------------------------------------------------------
6730: ,p_token_1 => 'ERROR'
6731: ,p_value_1 =>
6732: 'Entity Type Code has an invalid value. It cannot have a NULL value.'
6733: ,p_token_2 => 'LOCATION'
6734: ,p_value_2 => 'xla_events_pkg.validate_context');
6735: END IF;
6736: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6737: trace
6738: (p_msg => 'end of procedure validate_context'
6744: WHEN xla_exceptions_pkg.application_exception THEN
6745: RAISE;
6746: WHEN OTHERS THEN
6747: xla_exceptions_pkg.raise_message
6748: (p_location => 'xla_events_pkg.validate_context');
6749: END validate_context;
6750:
6751:
6752: --=============================================================================
6829: ,p_token_1 => 'ERROR'
6830: ,p_value_1 => 'The setup for Entity Type, '||
6831: p_entity_type_code ||', is incorrect. Internal Error.'
6832: ,p_token_2 => 'LOCATION'
6833: ,p_value_2 => 'xla_events_pkg.get_id_mapping');
6834: END IF;
6835:
6836: IF p_source_id_code_1 = 'SOURCE_ID_INT_1'
6837: OR p_source_id_code_2 = 'SOURCE_ID_INT_1'
6915: WHEN xla_exceptions_pkg.application_exception THEN
6916: RAISE;
6917: WHEN OTHERS THEN
6918: xla_exceptions_pkg.raise_message
6919: (p_location => 'xla_events_pkg.get_id_mapping');
6920: END;
6921:
6922:
6923: --=============================================================================
7174: ,p_value_1 =>
7175: 'The source information passed does not map to the setups for Entity Type '
7176: || p_entity_type_code
7177: ,p_token_2 => 'LOCATION'
7178: ,p_value_2 => 'xla_events_pkg.validate_ids');
7179: END IF;
7180:
7181: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7182: trace
7213: ,p_token_1 => 'ERROR'
7214: ,p_value_1 =>
7215: 'The application is not registerd with subledger accounting architectre'
7216: ,p_token_2 => 'LOCATION'
7217: ,p_value_2 => 'xla_events_pkg.validate_cached_setup');
7218: END IF;
7219:
7220: --
7221: -- Validate that the entity type code tables have been loaded
7228: ,p_value_1 =>
7229: 'There is no Entity Type Code defined for the application '
7230: ||g_application_id
7231: ,p_token_2 => 'LOCATION'
7232: ,p_value_2 => 'xla_events_pkg.validate_cached_setup');
7233: END IF;
7234:
7235: --
7236: -- Validate that the event class tables have been loaded
7243: ,p_value_1 =>
7244: 'There is no Event Class defined for the application '
7245: ||g_application_id
7246: ,p_token_2 => 'LOCATION'
7247: ,p_value_2 => 'xla_events_pkg.validate_cached_setup');
7248: END IF;
7249:
7250: --
7251: -- Validate that the event type code tables have been loaded
7258: ,p_value_1 =>
7259: 'There is no Event Type Code defined for the application '
7260: ||g_application_id
7261: ,p_token_2 => 'LOCATION'
7262: ,p_value_2 => 'xla_events_pkg.validate_cached_setup');
7263: END IF;
7264:
7265: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7266: trace
7325: ,p_level => C_LEVEL_PROCEDURE
7326: ,p_module =>l_log_module);
7327: END IF;
7328:
7329: trace('> xla_events_pkg.cache_application_setup' , 20);
7330:
7331: g_application_id := null;
7332: g_entity_type_code_tbl.delete; --clear cache first
7333: g_event_class_code_tbl.delete; --clear cache first
7391: WHEN xla_exceptions_pkg.application_exception THEN
7392: RAISE;
7393: WHEN OTHERS THEN
7394: xla_exceptions_pkg.raise_message
7395: (p_location => 'xla_events_pkg.cache_application_setup');
7396: END cache_application_setup;
7397:
7398:
7399: --=============================================================================
7434: ,p_token_1 => 'ERROR'
7435: ,p_value_1 =>
7436: 'The entity Type is not enabled. Disabled entity types are not allowed for create/update APIs.'
7437: ,p_token_2 => 'LOCATION'
7438: ,p_value_2 => 'xla_events_pkg.validate_entity_type_code');
7439: END IF;
7440:
7441: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7442: trace
7453: ,p_token_1 => 'ERROR'
7454: ,p_value_1 => p_entity_type_code||
7455: ' is not a defined entity type for the application '||g_application_id
7456: ,p_token_2 => 'LOCATION'
7457: ,p_value_2 => 'xla_events_pkg.validate_entity_type_code');
7458: WHEN xla_exceptions_pkg.application_exception THEN
7459: RAISE;
7460: WHEN OTHERS THEN
7461: xla_exceptions_pkg.raise_message
7458: WHEN xla_exceptions_pkg.application_exception THEN
7459: RAISE;
7460: WHEN OTHERS THEN
7461: xla_exceptions_pkg.raise_message
7462: (p_location => 'xla_events_pkg.validate_entity_type_code');
7463: END validate_entity_type_code;
7464:
7465:
7466: --=============================================================================
7500: ,p_token_1 => 'ERROR'
7501: ,p_value_1 =>
7502: 'The Event Class is not enabled. Disabled event classes are not allowed for create/update APIs.'
7503: ,p_token_2 => 'LOCATION'
7504: ,p_value_2 => 'xla_events_pkg.validate_event_class_code');
7505: END IF;
7506:
7507: IF p_entity_type_code <> l_entity_code THEN
7508: xla_exceptions_pkg.raise_message
7512: ,p_value_1 => 'Event class '||p_event_class_code||
7513: ' is not defined for the entity type '||p_entity_type_code||
7514: ' and application '||g_application_id
7515: ,p_token_2 => 'LOCATION'
7516: ,p_value_2 => 'xla_events_pkg.validate_event_class_code');
7517: END IF;
7518:
7519: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7520: trace
7530: ,p_token_1 => 'ERROR'
7531: ,p_value_1 => p_event_class_code||
7532: ' is not a defined event class for the application '||g_application_id
7533: ,p_token_2 => 'LOCATION'
7534: ,p_value_2 => 'xla_events_pkg.validate_event_class_code');
7535: WHEN xla_exceptions_pkg.application_exception THEN
7536: RAISE;
7537: WHEN OTHERS THEN
7538: xla_exceptions_pkg.raise_message
7535: WHEN xla_exceptions_pkg.application_exception THEN
7536: RAISE;
7537: WHEN OTHERS THEN
7538: xla_exceptions_pkg.raise_message
7539: (p_location => 'xla_events_pkg.validate_event_class_code');
7540: END validate_event_class_code;
7541:
7542:
7543: --=============================================================================
7581: ,p_token_1 => 'ERROR'
7582: ,p_value_1 =>
7583: 'The Event Type is not enabled. Disabled event types are not allowed for create/update APIs.'
7584: ,p_token_2 => 'LOCATION'
7585: ,p_value_2 => 'xla_events_pkg.validate_event_type_code');
7586: END IF;
7587:
7588: IF ((p_entity_type_code <> l_entity_code) OR
7589: (NVL(p_event_class_code,l_event_class_code) <> l_event_class_code)
7597: ' is not defined for the entity type '||p_entity_type_code||
7598: ', event class '||p_event_class_code||
7599: ' and application '||g_application_id
7600: ,p_token_2 => 'LOCATION'
7601: ,p_value_2 => 'xla_events_pkg.validate_event_type_code');
7602: END IF;
7603:
7604: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7605: trace
7607: ,p_level => C_LEVEL_PROCEDURE
7608: ,p_module =>l_log_module);
7609: END IF;
7610:
7611: trace('< xla_events_pkg.validate_event_type_code' , 20);
7612: EXCEPTION
7613: WHEN NO_DATA_FOUND THEN
7614: xla_exceptions_pkg.raise_message
7615: (p_appli_s_name => 'XLA'
7617: ,p_token_1 => 'ERROR'
7618: ,p_value_1 => p_event_type_code||
7619: ' is not a defined event type for the application '||g_application_id
7620: ,p_token_2 => 'LOCATION'
7621: ,p_value_2 => 'xla_events_pkg.validate_event_type_code');
7622: WHEN xla_exceptions_pkg.application_exception THEN
7623: RAISE;
7624: WHEN OTHERS THEN
7625: xla_exceptions_pkg.raise_message
7622: WHEN xla_exceptions_pkg.application_exception THEN
7623: RAISE;
7624: WHEN OTHERS THEN
7625: xla_exceptions_pkg.raise_message
7626: (p_location => 'xla_events_pkg.validate_event_type_code');
7627: END validate_event_type_code;
7628:
7629: --=============================================================================
7630: --
7667: ,p_value_1 => 'Event Status Code cannot have a '||
7668: p_event_status_code ||
7669: ' value.'
7670: ,p_token_2 => 'LOCATION'
7671: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7672: END IF;
7673:
7674: ----------------------------------------------------------------------------
7675: -- Validate process status code against the possible valid statuses
7691: ,p_value_1 => 'Process Status Code cannot have a '||
7692: p_process_status_code ||
7693: ' value.'
7694: ,p_token_2 => 'LOCATION'
7695: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7696: END IF;
7697:
7698: ----------------------------------------------------------------------------
7699: -- following code is modified to fix bug # 2899700
7710: ,p_token_1 => 'ERROR'
7711: ,p_value_1 => 'Process Status Code has an invalid value. '||
7712: 'It should always have a ''Unprocessed'' value.'
7713: ,p_token_2 => 'LOCATION'
7714: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7715: END IF;
7716:
7717: IF p_event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED THEN
7718: xla_exceptions_pkg.raise_message
7721: ,p_token_1 => 'ERROR'
7722: ,p_value_1 => 'Event Status Code has an invalid value. '||
7723: 'It cannot have a ''Processed'' value.'
7724: ,p_token_2 => 'LOCATION'
7725: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7726: END IF;
7727: ELSIF g_context = C_MANUAL_EVENT_CONTEXT THEN
7728:
7729: -------------------------------------------------------------------------
7740: 'Process Status Code = '|| p_process_status_code ||
7741: ', '||
7742: 'Event Status Code = '|| p_event_status_code
7743: ,p_token_2 => 'LOCATION'
7744: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7745: END IF;
7746: ELSIF (p_process_status_code = C_INTERNAL_DRAFT) THEN
7747: IF (p_event_status_code <> xla_events_pub_pkg.C_EVENT_UNPROCESSED) THEN
7748: xla_exceptions_pkg.raise_message
7753: 'Process Status Code = '|| p_process_status_code ||
7754: ', '||
7755: 'Event Status Code = '|| p_event_status_code
7756: ,p_token_2 => 'LOCATION'
7757: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7758: END IF;
7759: ELSIF (p_process_status_code = C_INTERNAL_UNPROCESSED) THEN
7760: IF (p_event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED) THEN
7761: xla_exceptions_pkg.raise_message
7766: 'Process Status Code = '|| p_process_status_code ||
7767: ', '||
7768: 'Event Status Code = '|| p_event_status_code
7769: ,p_token_2 => 'LOCATION'
7770: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7771: END IF;
7772: ELSE
7773: xla_exceptions_pkg.raise_message
7774: (p_appli_s_name => 'XLA'
7778: 'Process Status Code = '|| p_process_status_code ||
7779: ', '||
7780: 'Event Status Code = '|| p_event_status_code
7781: ,p_token_2 => 'LOCATION'
7782: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7783: END IF;
7784: END IF;
7785:
7786: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
7793: WHEN xla_exceptions_pkg.application_exception THEN
7794: RAISE;
7795: WHEN OTHERS THEN
7796: xla_exceptions_pkg.raise_message
7797: (p_location => 'xla_events_pkg.validate_status_code');
7798: END validate_status_code;
7799:
7800:
7801: --=============================================================================
7903: WHEN xla_exceptions_pkg.application_exception THEN
7904: RAISE;
7905: WHEN OTHERS THEN
7906: xla_exceptions_pkg.raise_message
7907: (p_location => 'xla_events_pkg.validate_params');
7908: END validate_params;
7909:
7910:
7911:
7955: 'The ledger is either not enabled or is marked as not to create events.'||
7956: 'ledger_id = '||p_ledger_id||
7957: 'application_id = '|| p_application_id
7958: ,p_token_2 => 'LOCATION'
7959: ,p_value_2 => 'xla_events_pkg.validate_ledger');
7960: END IF;
7961: ELSE
7962: BEGIN
7963: SELECT DECODE(enabled_flag
7990: WHEN xla_exceptions_pkg.application_exception THEN
7991: RAISE;
7992: WHEN OTHERS THEN
7993: xla_exceptions_pkg.raise_message
7994: (p_location => 'xla_events_pkg.validate_ledger');
7995: END validate_ledger;
7996:
7997:
7998: --=============================================================================
8297: IF c2%ISOPEN THEN
8298: CLOSE c2;
8299: END IF;
8300: xla_exceptions_pkg.raise_message
8301: (p_location => 'xla_events_pkg.cache_entity_info');
8302: END cache_entity_info;
8303:
8304:
8305: --=============================================================================
8431: WHEN xla_exceptions_pkg.application_exception THEN
8432: RAISE;
8433: WHEN OTHERS THEN
8434: xla_exceptions_pkg.raise_message
8435: (p_location => 'xla_events_pkg.create_entity_event');
8436: END create_entity_event;
8437:
8438:
8439: --=============================================================================
8472: WHEN xla_exceptions_pkg.application_exception THEN
8473: RAISE;
8474: WHEN OTHERS THEN
8475: xla_exceptions_pkg.raise_message
8476: (p_location => 'xla_events_pkg.update_entity_trx_number');
8477: END update_entity_trx_number;
8478:
8479: --=============================================================================
8480: --
8646: WHEN xla_exceptions_pkg.application_exception THEN
8647: RAISE;
8648: WHEN OTHERS THEN
8649: xla_exceptions_pkg.raise_message
8650: (p_location => 'xla_events_pkg.add_event (fn)');
8651: END add_entity_event;
8652:
8653:
8654: --=============================================================================
8706: WHEN xla_exceptions_pkg.application_exception THEN
8707: RAISE;
8708: WHEN OTHERS THEN
8709: xla_exceptions_pkg.raise_message
8710: (p_location => 'xla_events_pkg.reset_cache');
8711: END reset_cache;
8712:
8713:
8714: --=============================================================================
8742: WHEN xla_exceptions_pkg.application_exception THEN
8743: RAISE;
8744: WHEN OTHERS THEN
8745: xla_exceptions_pkg.raise_message
8746: (p_location => 'xla_events_pkg.set_context');
8747: END set_context;
8748:
8749:
8750: --=============================================================================
8964: WHEN xla_exceptions_pkg.application_exception THEN
8965: RAISE;
8966: WHEN OTHERS THEN
8967: xla_exceptions_pkg.raise_message
8968: (p_location => 'xla_events_pkg.delete_je');
8969: END delete_je;
8970:
8971:
8972:
9357: END IF;
9358:
9359: initialize;
9360:
9361: END xla_events_pkg;