411: fnd_log.string(p_level, p_module, p_msg);
412: END IF;
413:
414: EXCEPTION
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');
414: EXCEPTION
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: --=============================================================================
638: ----------------------------------------------------------------------------
639: -- check to see the API is not called for manual events
640: ----------------------------------------------------------------------------
641: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
642: xla_exceptions_pkg.raise_message
643: (p_appli_s_name => 'XLA'
644: ,p_msg_name => 'XLA_COMMON_ERROR'
645: ,p_token_1 => 'ERROR'
646: ,p_value_1 => 'For MANUAL events this API cannot be called'
650: g_context := C_REGULAR_EVENT_CONTEXT;
651: END IF;
652:
653: IF p_event_type_code IS NULL THEN
654: xla_exceptions_pkg.raise_message
655: (p_appli_s_name => 'XLA'
656: ,p_msg_name => 'XLA_COMMON_ERROR'
657: ,p_token_1 => 'ERROR'
658: ,p_value_1 =>
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'
666: ,p_msg_name => 'XLA_COMMON_ERROR'
667: ,p_token_1 => 'ERROR'
668: ,p_value_1 =>
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'
676: ,p_msg_name => 'XLA_COMMON_ERROR'
677: ,p_token_1 => 'ERROR'
678: ,p_value_1 =>
719: END IF;
720:
721: IF (g_gapless_flag = 'Y'
722: and (p_event_number is null or p_event_number<1)) THEN
723: xla_exceptions_pkg.raise_message
724: (p_appli_s_name => 'XLA'
725: ,p_msg_name => 'XLA_COMMON_ERROR'
726: ,p_token_1 => 'ERROR'
727: ,p_value_1 =>
790: END IF;
791: RETURN l_return_id;
792:
793: EXCEPTION
794: WHEN xla_exceptions_pkg.application_exception THEN
795: ROLLBACK to SAVEPOINT before_event_creation;
796: RAISE;
797: WHEN OTHERS THEN
798: ROLLBACK to SAVEPOINT before_event_creation;
795: ROLLBACK to SAVEPOINT before_event_creation;
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:
969: ----------------------------------------------------------------------------
970: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
971: g_context := C_MANUAL_EVENT_CONTEXT;
972: ELSE
973: xla_exceptions_pkg.raise_message
974: (p_appli_s_name => 'XLA'
975: ,p_msg_name => 'XLA_COMMON_ERROR'
976: ,p_token_1 => 'ERROR'
977: ,p_value_1 => 'For REGULAR events this API cannot be called'
982: ----------------------------------------------------------------------------
983: -- perform specific validations for 'creating events'
984: ----------------------------------------------------------------------------
985: IF p_event_type_code IS NULL THEN
986: xla_exceptions_pkg.raise_message
987: (p_appli_s_name => 'XLA'
988: ,p_msg_name => 'XLA_COMMON_ERROR'
989: ,p_token_1 => 'ERROR'
990: ,p_value_1 =>
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.'
1109: ,p_module =>l_log_module);
1110: END IF;
1111: RETURN l_return_id;
1112: EXCEPTION
1113: WHEN xla_exceptions_pkg.application_exception THEN
1114: ROLLBACK to SAVEPOINT before_event_creation;
1115: RAISE;
1116: WHEN OTHERS THEN
1117: ROLLBACK to SAVEPOINT before_event_creation;
1114: ROLLBACK to SAVEPOINT before_event_creation;
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:
1283: ----------------------------------------------------------------------------
1284: -- check to see the API is not called for manual events
1285: ----------------------------------------------------------------------------
1286: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
1287: xla_exceptions_pkg.raise_message
1288: (p_appli_s_name => 'XLA'
1289: ,p_msg_name => 'XLA_COMMON_ERROR'
1290: ,p_token_1 => 'ERROR'
1291: ,p_value_1 => 'For MANUAL events this API cannot be called'
1298: ----------------------------------------------------------------------------
1299: -- perform validations specific to 'updating event's status'
1300: ----------------------------------------------------------------------------
1301: IF p_event_status_code IS NULL THEN
1302: xla_exceptions_pkg.raise_message
1303: (p_appli_s_name => 'XLA'
1304: ,p_msg_name => 'XLA_COMMON_ERROR'
1305: ,p_token_1 => 'ERROR'
1306: ,p_value_1 => 'Event Status Code cannot have a NULL value.'
1345: ----------------------------------------------------------------------------
1346: -- Check entity existency
1347: ----------------------------------------------------------------------------
1348: IF g_entity_id IS NULL THEN
1349: xla_exceptions_pkg.raise_message
1350: (p_appli_s_name => 'XLA'
1351: ,p_msg_name => 'XLA_COMMON_ERROR'
1352: ,p_token_1 => 'ERROR'
1353: ,p_value_1 => 'No event exists for the document represented '||
1514: ,p_level => C_LEVEL_PROCEDURE
1515: ,p_module =>l_log_module);
1516: end if;
1517: EXCEPTION
1518: WHEN xla_exceptions_pkg.application_exception THEN
1519: ROLLBACK to SAVEPOINT before_event_update;
1520: RAISE;
1521: WHEN OTHERS THEN
1522: ROLLBACK to SAVEPOINT before_event_update;
1519: ROLLBACK to SAVEPOINT before_event_update;
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:
1706: ----------------------------------------------------------------------------
1707: -- check to see the API is not called for manual events
1708: ----------------------------------------------------------------------------
1709: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
1710: xla_exceptions_pkg.raise_message
1711: (p_appli_s_name => 'XLA'
1712: ,p_msg_name => 'XLA_COMMON_ERROR'
1713: ,p_token_1 => 'ERROR'
1714: ,p_value_1 => 'For MANUAL events this API cannot be called'
1721: ----------------------------------------------------------------------------
1722: -- perfrom validations specific to 'updating event'
1723: ----------------------------------------------------------------------------
1724: IF p_event_id IS NULL THEN
1725: xla_exceptions_pkg.raise_message
1726: (p_appli_s_name => 'XLA'
1727: ,p_msg_name => 'XLA_COMMON_ERROR'
1728: ,p_token_1 => 'ERROR'
1729: ,p_value_1 => 'Event ID cannot have a NULL value.'
1780: ----------------------------------------------------------------------------
1781: -- Check entity existency
1782: ----------------------------------------------------------------------------
1783: IF g_entity_id IS NULL THEN
1784: xla_exceptions_pkg.raise_message
1785: (p_appli_s_name => 'XLA'
1786: ,p_msg_name => 'XLA_COMMON_ERROR'
1787: ,p_token_1 => 'ERROR'
1788: ,p_value_1 => 'No event exists for the document represented '||
1793:
1794: if(g_gapless_flag='Y' and
1795: (p_overwrite_event_num=C_YES and
1796: (p_event_number is null or p_event_number<1))) then
1797: xla_exceptions_pkg.raise_message
1798: (p_appli_s_name => 'XLA'
1799: ,p_msg_name => 'XLA_COMMON_ERROR'
1800: ,p_token_1 => 'ERROR'
1801: ,p_value_1 =>
1849:
1850:
1851: Exception
1852: WHEN OTHERS THEN
1853: xla_exceptions_pkg.raise_message
1854: (p_appli_s_name => 'XLA'
1855: ,p_msg_name => 'XLA_COMMON_ERROR'
1856: ,p_token_1 => 'ERROR'
1857: ,p_value_1 =>
1907: AND entity_id = g_entity_id
1908: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
1909:
1910: IF SQL%ROWCOUNT <> 1 THEN
1911: xla_exceptions_pkg.raise_message
1912: (p_appli_s_name => 'XLA'
1913: ,p_msg_name => 'XLA_COMMON_ERROR'
1914: ,p_token_1 => 'ERROR'
1915: ,p_value_1 =>
2048: ,p_level => C_LEVEL_PROCEDURE
2049: ,p_module =>l_log_module);
2050: END IF;
2051: EXCEPTION
2052: WHEN xla_exceptions_pkg.application_exception THEN
2053: ROLLBACK to SAVEPOINT before_event_update;
2054: RAISE;
2055: WHEN OTHERS THEN
2056: ROLLBACK to SAVEPOINT before_event_update;
2053: ROLLBACK to SAVEPOINT before_event_update;
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:
2235: ----------------------------------------------------------------------------
2236: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
2237: g_context := C_MANUAL_EVENT_CONTEXT;
2238: ELSE
2239: xla_exceptions_pkg.raise_message
2240: (p_appli_s_name => 'XLA'
2241: ,p_msg_name => 'XLA_COMMON_ERROR'
2242: ,p_token_1 => 'ERROR'
2243: ,p_value_1 => 'For REGULAR events this API cannot be called'
2248: ----------------------------------------------------------------------------
2249: -- perfrom validations specific to 'updating event'
2250: ----------------------------------------------------------------------------
2251: IF p_event_id IS NULL THEN
2252: xla_exceptions_pkg.raise_message
2253: (p_appli_s_name => 'XLA'
2254: ,p_msg_name => 'XLA_COMMON_ERROR'
2255: ,p_token_1 => 'ERROR'
2256: ,p_value_1 => 'Event ID cannot have a NULL value.'
2264: ----------------------------------------------------------------------------
2265: IF (((p_event_status_code IS NOT NULL) AND (p_process_status_code IS NULL))OR
2266: ((p_event_status_code IS NULL) AND (p_process_status_code IS NOT NULL)))
2267: THEN
2268: xla_exceptions_pkg.raise_message
2269: (p_appli_s_name => 'XLA'
2270: ,p_msg_name => 'XLA_COMMON_ERROR'
2271: ,p_token_1 => 'ERROR'
2272: ,p_value_1 => 'Inconsistent values for event statuses: '||
2308: ,p_module =>l_log_module);
2309: END IF;
2310:
2311: IF g_entity_id IS NULL THEN
2312: xla_exceptions_pkg.raise_message
2313: (p_appli_s_name => 'XLA'
2314: ,p_msg_name => 'XLA_COMMON_ERROR'
2315: ,p_token_1 => 'ERROR'
2316: ,p_value_1 => 'No event exists for the document represented '||
2373: ,p_module =>l_log_module);
2374: END IF;
2375:
2376: IF l_rowcount <> 1 THEN
2377: xla_exceptions_pkg.raise_message
2378: (p_appli_s_name => 'XLA'
2379: ,p_msg_name => 'XLA_COMMON_ERROR'
2380: ,p_token_1 => 'ERROR'
2381: ,p_value_1 =>
2392: ,p_module =>l_log_module);
2393: END IF;
2394:
2395: EXCEPTION
2396: WHEN xla_exceptions_pkg.application_exception THEN
2397: ROLLBACK to SAVEPOINT before_event_update;
2398: RAISE;
2399: WHEN OTHERS THEN
2400: ROLLBACK to SAVEPOINT before_event_update;
2397: ROLLBACK to SAVEPOINT before_event_update;
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:
2558: ----------------------------------------------------------------------------
2559: -- perform validations specific to 'deleting event'
2560: ----------------------------------------------------------------------------
2561: IF p_event_id IS NULL THEN
2562: xla_exceptions_pkg.raise_message
2563: (p_appli_s_name => 'XLA'
2564: ,p_msg_name => 'XLA_COMMON_ERROR'
2565: ,p_token_1 => 'ERROR'
2566: ,p_value_1 => 'Event ID cannot have a NULL value.'
2592: ,p_module =>l_log_module);
2593: END IF;
2594:
2595: IF g_entity_id IS NULL THEN
2596: xla_exceptions_pkg.raise_message
2597: (p_appli_s_name => 'XLA'
2598: ,p_msg_name => 'XLA_COMMON_ERROR'
2599: ,p_token_1 => 'ERROR'
2600: ,p_value_1 => 'No event exists for the document represented '||
2618: WHERE event_id = p_event_id
2619: AND entity_id = g_entity_id
2620: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
2621: exception when others then
2622: xla_exceptions_pkg.raise_message
2623: (p_appli_s_name => 'XLA'
2624: ,p_msg_name => 'XLA_COMMON_ERROR'
2625: ,p_token_1 => 'ERROR'
2626: ,p_value_1 =>
2648: ,p_module =>l_log_module);
2649: END IF;
2650:
2651: IF l_rowcount <> 1 THEN
2652: xla_exceptions_pkg.raise_message
2653: (p_appli_s_name => 'XLA'
2654: ,p_msg_name => 'XLA_COMMON_ERROR'
2655: ,p_token_1 => 'ERROR'
2656: ,p_value_1 =>
2700: ,p_module =>l_log_module);
2701: END IF;
2702:
2703: EXCEPTION
2704: WHEN xla_exceptions_pkg.application_exception THEN
2705: ROLLBACK to SAVEPOINT before_event_delete;
2706: RAISE;
2707: WHEN OTHERS THEN
2708: ROLLBACK to SAVEPOINT before_event_delete;
2705: ROLLBACK to SAVEPOINT before_event_delete;
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:
2852: ----------------------------------------------------------------------------
2853: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
2854: g_context := C_MANUAL_EVENT_CONTEXT;
2855: ELSE
2856: xla_exceptions_pkg.raise_message
2857: (p_appli_s_name => 'XLA'
2858: ,p_msg_name => 'XLA_COMMON_ERROR'
2859: ,p_token_1 => 'ERROR'
2860: ,p_value_1 => 'For REGULAR events this API cannot be called'
2865: ----------------------------------------------------------------------------
2866: -- perform validations specific to 'deleting event'
2867: ----------------------------------------------------------------------------
2868: IF p_event_id IS NULL THEN
2869: xla_exceptions_pkg.raise_message
2870: (p_appli_s_name => 'XLA'
2871: ,p_msg_name => 'XLA_COMMON_ERROR'
2872: ,p_token_1 => 'ERROR'
2873: ,p_value_1 => 'Event ID cannot have a NULL value.'
2899: ,p_module =>l_log_module);
2900: END IF;
2901:
2902: IF g_entity_id IS NULL THEN
2903: xla_exceptions_pkg.raise_message
2904: (p_appli_s_name => 'XLA'
2905: ,p_msg_name => 'XLA_COMMON_ERROR'
2906: ,p_token_1 => 'ERROR'
2907: ,p_value_1 => 'No event exists for the document represented '||
2934: ,p_module =>l_log_module);
2935: END IF;
2936:
2937: IF l_rowcount <> 1 THEN
2938: xla_exceptions_pkg.raise_message
2939: (p_appli_s_name => 'XLA'
2940: ,p_msg_name => 'XLA_COMMON_ERROR'
2941: ,p_token_1 => 'ERROR'
2942: ,p_value_1 =>
2975: ,p_module =>l_log_module);
2976: END IF;
2977:
2978: EXCEPTION
2979: WHEN xla_exceptions_pkg.application_exception THEN
2980: ROLLBACK to SAVEPOINT before_event_delete;
2981: RAISE;
2982: WHEN OTHERS THEN
2983: ROLLBACK to SAVEPOINT before_event_delete;
2980: ROLLBACK to SAVEPOINT before_event_delete;
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:
3141: ----------------------------------------------------------------------------
3142: -- check to see the API is not called for manual events
3143: ----------------------------------------------------------------------------
3144: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
3145: xla_exceptions_pkg.raise_message
3146: (p_appli_s_name => 'XLA'
3147: ,p_msg_name => 'XLA_COMMON_ERROR'
3148: ,p_token_1 => 'ERROR'
3149: ,p_value_1 => 'For MANUAL events this API cannot be called'
3184: ,p_module =>l_log_module);
3185: END IF;
3186:
3187: IF g_entity_id IS NULL THEN
3188: xla_exceptions_pkg.raise_message
3189: (p_appli_s_name => 'XLA'
3190: ,p_msg_name => 'XLA_COMMON_ERROR'
3191: ,p_token_1 => 'ERROR'
3192: ,p_value_1 => 'No event exists for the document represented '||
3285: END IF;
3286:
3287: RETURN l_event_deleted;
3288: EXCEPTION
3289: WHEN xla_exceptions_pkg.application_exception THEN
3290: ROLLBACK to SAVEPOINT before_event_delete;
3291: RAISE;
3292: WHEN OTHERS THEN
3293: ROLLBACK to SAVEPOINT before_event_delete;
3290: ROLLBACK to SAVEPOINT before_event_delete;
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:
3472: NVL(xla_events_pub_pkg.g_security.security_id_char_2,C_CHAR)
3473: AND NVL(a.security_id_char_3,C_CHAR) =
3474: NVL(xla_events_pub_pkg.g_security.security_id_char_3,C_CHAR);
3475: EXCEPTION when others then
3476: xla_exceptions_pkg.raise_message
3477: (p_appli_s_name => 'XLA'
3478: ,p_msg_name => 'XLA_COMMON_ERROR'
3479: ,p_token_1 => 'ERROR'
3480: ,p_value_1 =>
3524: ,p_module =>l_log_module);
3525: END IF;
3526: RETURN 0;
3527: EXCEPTION
3528: WHEN xla_exceptions_pkg.application_exception THEN
3529: ROLLBACK to SAVEPOINT before_entity_delete;
3530: RAISE;
3531: WHEN OTHERS THEN
3532: ROLLBACK to SAVEPOINT before_entity_delete;
3529: ROLLBACK to SAVEPOINT before_entity_delete;
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: --=============================================================================
3572: --
3573: -- Check entity existency
3574: --
3575: IF g_entity_id IS NULL THEN
3576: xla_exceptions_pkg.raise_message
3577: (p_appli_s_name => 'XLA'
3578: ,p_msg_name => 'XLA_COMMON_ERROR'
3579: ,p_token_1 => 'ERROR'
3580: ,p_value_1 =>
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;
3591: WHEN OTHERS THEN
3592: ROLLBACK to SAVEPOINT before_entity_delete;
3589: ROLLBACK to SAVEPOINT before_entity_delete;
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:
3749: ----------------------------------------------------------------------------
3750: -- perform validation specific to 'get event information'
3751: ----------------------------------------------------------------------------
3752: IF p_event_id IS NULL THEN
3753: xla_exceptions_pkg.raise_message
3754: (p_appli_s_name => 'XLA'
3755: ,p_msg_name => 'XLA_COMMON_ERROR'
3756: ,p_token_1 => 'ERROR'
3757: ,p_value_1 =>
3784: ,p_module =>l_log_module);
3785: END IF;
3786:
3787: IF g_entity_id IS NULL THEN
3788: xla_exceptions_pkg.raise_message
3789: (p_appli_s_name => 'XLA'
3790: ,p_msg_name => 'XLA_COMMON_ERROR'
3791: ,p_token_1 => 'ERROR'
3792: ,p_value_1 => 'No event exists for the document represented '||
3844:
3845: RETURN (l_event_info);
3846: EXCEPTION
3847: WHEN NO_DATA_FOUND THEN
3848: xla_exceptions_pkg.raise_message
3849: (p_appli_s_name => 'XLA'
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'
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
3859: (p_location => 'xla_events_pkg.get_event_info (fn)');
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
3859: (p_location => 'xla_events_pkg.get_event_info (fn)');
3860: END get_event_info;
3861:
3862:
4008: END IF;
4009:
4010: RETURN l_event_info.event_status_code;
4011: EXCEPTION
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)');
4011: EXCEPTION
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:
4202: -- Changed to fix bug # 2899700
4203: ----------------------------------------------------------------------------
4204: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
4205: IF p_event_id IS NULL THEN
4206: xla_exceptions_pkg.raise_message
4207: (p_appli_s_name => 'XLA'
4208: ,p_msg_name => 'XLA_COMMON_ERROR'
4209: ,p_token_1 => 'ERROR'
4210: ,p_value_1 => 'For MANUAL events event_id cannot be NULL'
4263: ,p_module =>l_log_module);
4264: END IF;
4265: RETURN FALSE;
4266: /*
4267: xla_exceptions_pkg.raise_message
4268: (p_appli_s_name => 'XLA'
4269: ,p_msg_name => 'XLA_COMMON_ERROR'
4270: ,p_token_1 => 'ERROR'
4271: ,p_value_1 => 'No event exists for the document represented '||
4309: RETURN TRUE;
4310: END IF;
4311:
4312: EXCEPTION
4313: WHEN xla_exceptions_pkg.application_exception THEN
4314: IF c1%ISOPEN THEN
4315: CLOSE c1;
4316: END IF;
4317: RAISE;
4323: WHEN OTHERS THEN
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:
4474: -- Changed to fix bug # 2899700
4475: ----------------------------------------------------------------------------
4476: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
4477: IF p_event_id IS NULL THEN
4478: xla_exceptions_pkg.raise_message
4479: (p_appli_s_name => 'XLA'
4480: ,p_msg_name => 'XLA_COMMON_ERROR'
4481: ,p_token_1 => 'ERROR'
4482: ,p_value_1 => 'For MANUAL events event_id cannot be NULL'
4514: ,p_module =>l_log_module);
4515: END IF;
4516:
4517: IF g_entity_id IS NULL THEN
4518: xla_exceptions_pkg.raise_message
4519: (p_appli_s_name => 'XLA'
4520: ,p_msg_name => 'XLA_COMMON_ERROR'
4521: ,p_token_1 => 'ERROR'
4522: ,p_value_1 => 'No event exists for the document represented '||
4535: ,p_module =>l_log_module);
4536: END IF;
4537:
4538: EXCEPTION
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');
4538: EXCEPTION
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:
4685: -- Changed to fix bug # 2899700
4686: ----------------------------------------------------------------------------
4687: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
4688: IF p_event_id IS NULL THEN
4689: xla_exceptions_pkg.raise_message
4690: (p_appli_s_name => 'XLA'
4691: ,p_msg_name => 'XLA_COMMON_ERROR'
4692: ,p_token_1 => 'ERROR'
4693: ,p_value_1 => 'For MANUAL events event_id cannot be NULL'
4723: ,p_module =>l_log_module);
4724: END IF;
4725:
4726: IF g_entity_id IS NULL THEN
4727: xla_exceptions_pkg.raise_message
4728: (p_appli_s_name => 'XLA'
4729: ,p_msg_name => 'XLA_COMMON_ERROR'
4730: ,p_token_1 => 'ERROR'
4731: ,p_value_1 => 'No event exists for the document represented '||
4746: END IF;
4747:
4748: RETURN g_entity_id;
4749: EXCEPTION
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');
4749: EXCEPTION
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:
4947: ----------------------------------------------------------------------------
4948: -- This API cannot be called for manual events.
4949: ----------------------------------------------------------------------------
4950: IF p_entity_type_code = C_MANUAL_ENTITY THEN
4951: xla_exceptions_pkg.raise_message
4952: (p_appli_s_name => 'XLA'
4953: ,p_msg_name => 'XLA_COMMON_ERROR'
4954: ,p_token_1 => 'ERROR'
4955: ,p_value_1 => 'For MANUAL events this API cannot be called'
5004: open csr_xla_event_number;
5005: fetch csr_xla_event_number into l_last;
5006: if(csr_xla_event_number%FOUND) THEN
5007: close csr_xla_event_number;
5008: xla_exceptions_pkg.raise_message
5009: (p_appli_s_name => 'XLA'
5010: ,p_msg_name => 'XLA_COMMON_ERROR'
5011: ,p_token_1 => 'ERROR'
5012: ,p_value_1 =>
5053: open csr_parameter_mismatch(p_entity_type_code, p_application_id);
5054: fetch csr_parameter_mismatch into l_last;
5055: if(csr_parameter_mismatch%FOUND) THEN
5056: close csr_parameter_mismatch;
5057: xla_exceptions_pkg.raise_message
5058: (p_appli_s_name => 'XLA'
5059: ,p_msg_name => 'XLA_COMMON_ERROR'
5060: ,p_token_1 => 'ERROR'
5061: ,p_value_1 =>
5069: open csr_status_error;
5070: fetch csr_status_error into l_last;
5071: if(csr_status_error%FOUND) THEN
5072: close csr_status_error;
5073: xla_exceptions_pkg.raise_message
5074: (p_appli_s_name => 'XLA'
5075: ,p_msg_name => 'XLA_COMMON_ERROR'
5076: ,p_token_1 => 'ERROR'
5077: ,p_value_1 => 'Event status must be I, U or N'
5084: open csr_event_type_error(p_entity_type_code, p_application_id);
5085: fetch csr_event_type_error into l_last;
5086: if(csr_event_type_error%FOUND) THEN
5087: close csr_event_type_error;
5088: xla_exceptions_pkg.raise_message
5089: (p_appli_s_name => 'XLA'
5090: ,p_msg_name => 'XLA_COMMON_ERROR'
5091: ,p_token_1 => 'ERROR'
5092: ,p_value_1 => 'Event type must be a valid event type'
5095: return;
5096: end if;
5097: close csr_event_type_error;
5098:
5099: xla_exceptions_pkg.raise_message
5100: (p_appli_s_name => 'XLA'
5101: ,p_msg_name => 'XLA_COMMON_ERROR'
5102: ,p_token_1 => 'ERROR'
5103: ,p_value_1 =>
5469: ,p_module =>l_log_module);
5470: END IF;
5471:
5472: EXCEPTION
5473: WHEN xla_exceptions_pkg.application_exception THEN
5474: ROLLBACK to SAVEPOINT before_event_creation;
5475: RAISE;
5476: WHEN OTHERS THEN
5477: ROLLBACK to SAVEPOINT before_event_creation;
5474: ROLLBACK to SAVEPOINT before_event_creation;
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:
5636: open csr_invalid_app(p_application_id);
5637: fetch csr_invalid_app into l_temp;
5638: if(csr_invalid_app%FOUND) THEN
5639: close csr_invalid_app;
5640: xla_exceptions_pkg.raise_message
5641: (p_appli_s_name => 'XLA'
5642: ,p_msg_name => 'XLA_COMMON_ERROR'
5643: ,p_token_1 => 'ERROR'
5644: ,p_value_1 =>
5651: open csr_invalid_event_id(p_application_id);
5652: fetch csr_invalid_event_id into l_temp;
5653: if(csr_invalid_event_id%FOUND) THEN
5654: close csr_invalid_event_id;
5655: xla_exceptions_pkg.raise_message
5656: (p_appli_s_name => 'XLA'
5657: ,p_msg_name => 'XLA_COMMON_ERROR'
5658: ,p_token_1 => 'ERROR'
5659: ,p_value_1 => '(Application id, Event ID) is not valid'
5665: open csr_invalid_event_status(p_application_id);
5666: fetch csr_invalid_event_status into l_temp;
5667: if(csr_invalid_event_status%FOUND) THEN
5668: close csr_invalid_event_status;
5669: xla_exceptions_pkg.raise_message
5670: (p_appli_s_name => 'XLA'
5671: ,p_msg_name => 'XLA_COMMON_ERROR'
5672: ,p_token_1 => 'ERROR'
5673: ,p_value_1 =>
5677: end if;
5678: close csr_invalid_event_status;
5679:
5680: -- If reach here, must be entity code error
5681: xla_exceptions_pkg.raise_message
5682: (p_appli_s_name => 'XLA'
5683: ,p_msg_name => 'XLA_COMMON_ERROR'
5684: ,p_token_1 => 'ERROR'
5685: ,p_value_1 =>
5820: END IF;
5821:
5822: IF(NOT xla_balances_pkg.massive_update_for_events(p_application_id
5823: => p_application_id)) THEN
5824: xla_exceptions_pkg.raise_message
5825: (p_appli_s_name => 'XLA'
5826: ,p_msg_name => 'XLA_COMMON_ERROR'
5827: ,p_token_1 => 'ERROR'
5828: ,p_value_1 =>
5846: ,p_module =>l_log_module);
5847: END IF;
5848:
5849: EXCEPTION
5850: WHEN xla_exceptions_pkg.application_exception THEN
5851: ROLLBACK to SAVEPOINT before_update_bulk_statuses;
5852: RAISE;
5853: WHEN OTHERS THEN
5854: ROLLBACK to SAVEPOINT before_update_bulk_statuses;
5851: ROLLBACK to SAVEPOINT before_update_bulk_statuses;
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:
5979: open csr_invalid_app(p_application_id);
5980: fetch csr_invalid_app into l_temp;
5981: if(csr_invalid_app%FOUND) THEN
5982: close csr_invalid_app;
5983: xla_exceptions_pkg.raise_message
5984: (p_appli_s_name => 'XLA'
5985: ,p_msg_name => 'XLA_COMMON_ERROR'
5986: ,p_token_1 => 'ERROR'
5987: ,p_value_1 =>
5994: open csr_invalid_event_id(p_application_id);
5995: fetch csr_invalid_event_id into l_temp;
5996: if(csr_invalid_event_id%FOUND) THEN
5997: close csr_invalid_event_id;
5998: xla_exceptions_pkg.raise_message
5999: (p_appli_s_name => 'XLA'
6000: ,p_msg_name => 'XLA_COMMON_ERROR'
6001: ,p_token_1 => 'ERROR'
6002: ,p_value_1 => '(Application id, Event ID) is not valid'
6008: open csr_invalid_event_status(p_application_id);
6009: fetch csr_invalid_event_status into l_temp;
6010: if(csr_invalid_event_status%FOUND) THEN
6011: close csr_invalid_event_status;
6012: xla_exceptions_pkg.raise_message
6013: (p_appli_s_name => 'XLA'
6014: ,p_msg_name => 'XLA_COMMON_ERROR'
6015: ,p_token_1 => 'ERROR'
6016: ,p_value_1 =>
6020: end if;
6021: close csr_invalid_event_status;
6022:
6023: -- if reach here, it must be entity code problem
6024: xla_exceptions_pkg.raise_message
6025: (p_appli_s_name => 'XLA'
6026: ,p_msg_name => 'XLA_COMMON_ERROR'
6027: ,p_token_1 => 'ERROR'
6028: ,p_value_1 =>
6063: END IF;
6064:
6065: IF(NOT xla_balances_pkg.massive_update_for_events(p_application_id
6066: => p_application_id)) THEN
6067: xla_exceptions_pkg.raise_message
6068: (p_appli_s_name => 'XLA'
6069: ,p_msg_name => 'XLA_COMMON_ERROR'
6070: ,p_token_1 => 'ERROR'
6071: ,p_value_1 =>
6157: ,p_module =>l_log_module);
6158: END IF;
6159:
6160: EXCEPTION
6161: WHEN xla_exceptions_pkg.application_exception THEN
6162: ROLLBACK to SAVEPOINT before_delete_bulk_event;
6163: RAISE;
6164: WHEN OTHERS THEN
6165: ROLLBACK to SAVEPOINT before_delete_bulk_event;
6162: ROLLBACK to SAVEPOINT before_delete_bulk_event;
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: --=============================================================================
6353: ----------------------------------------------------------------------------
6354: xla_security_pkg.set_security_context(p_event_source_info.application_id);
6355:
6356: IF p_event_source_info.entity_type_code = C_MANUAL_ENTITY THEN
6357: xla_exceptions_pkg.raise_message
6358: (p_appli_s_name => 'XLA'
6359: ,p_msg_name => 'XLA_COMMON_ERROR'
6360: ,p_token_1 => 'ERROR'
6361: ,p_value_1 => 'For MANUAL events this API cannot be called'
6397: ,p_module =>l_log_module);
6398: END IF;
6399:
6400: IF g_entity_id IS NULL THEN
6401: xla_exceptions_pkg.raise_message
6402: (p_appli_s_name => 'XLA'
6403: ,p_msg_name => 'XLA_COMMON_ERROR'
6404: ,p_token_1 => 'ERROR'
6405: ,p_value_1 => 'No event exists for the document represented '||
6443: END IF;
6444:
6445: RETURN (l_array_event_info);
6446: EXCEPTION
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)');
6446: EXCEPTION
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:
6525: ,p_module =>l_log_module);
6526: END IF;
6527:
6528: EXCEPTION
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');
6528: EXCEPTION
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:
6662: END IF;
6663: RETURN FALSE;
6664: END IF;
6665: EXCEPTION
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');
6665: EXCEPTION
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:
6693: ,p_module =>l_log_module);
6694: END IF;
6695:
6696: IF p_application_id IS NULL THEN
6697: xla_exceptions_pkg.raise_message
6698: (p_appli_s_name => 'XLA'
6699: ,p_msg_name => 'XLA_COMMON_ERROR'
6700: ,p_token_1 => 'ERROR'
6701: ,p_value_1 =>
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
6709: (p_appli_s_name => 'XLA'
6710: ,p_msg_name => 'XLA_COMMON_ERROR'
6711: ,p_token_1 => 'ERROR'
6712: ,p_value_1 =>
6723:
6724: END IF;
6725:
6726: IF p_entity_type_code IS NULL THEN
6727: xla_exceptions_pkg.raise_message
6728: (p_appli_s_name => 'XLA'
6729: ,p_msg_name => 'XLA_COMMON_ERROR'
6730: ,p_token_1 => 'ERROR'
6731: ,p_value_1 =>
6740: ,p_module =>l_log_module);
6741: END IF;
6742:
6743: EXCEPTION
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');
6743: EXCEPTION
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:
6822: END IF;
6823: END IF;
6824:
6825: IF l_error THEN
6826: xla_exceptions_pkg.raise_message
6827: (p_appli_s_name => 'XLA'
6828: ,p_msg_name => 'XLA_COMMON_ERROR'
6829: ,p_token_1 => 'ERROR'
6830: ,p_value_1 => 'The setup for Entity Type, '||
6911: END IF;
6912:
6913: RETURN l_mapping;
6914: EXCEPTION
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');
6914: EXCEPTION
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:
7166: END IF;
7167: END IF;
7168:
7169: IF l_error THEN
7170: xla_exceptions_pkg.raise_message
7171: (p_appli_s_name => 'XLA'
7172: ,p_msg_name => 'XLA_COMMON_ERROR'
7173: ,p_token_1 => 'ERROR'
7174: ,p_value_1 =>
7206: ,p_module =>l_log_module);
7207: END IF;
7208:
7209: IF g_application_id IS NULL THEN
7210: xla_exceptions_pkg.raise_message
7211: (p_appli_s_name => 'XLA'
7212: ,p_msg_name => 'XLA_COMMON_ERROR'
7213: ,p_token_1 => 'ERROR'
7214: ,p_value_1 =>
7220: --
7221: -- Validate that the entity type code tables have been loaded
7222: --
7223: IF g_entity_type_code_tbl.FIRST IS NULL THEN
7224: xla_exceptions_pkg.raise_message
7225: (p_appli_s_name => 'XLA'
7226: ,p_msg_name => 'XLA_COMMON_ERROR'
7227: ,p_token_1 => 'ERROR'
7228: ,p_value_1 =>
7235: --
7236: -- Validate that the event class tables have been loaded
7237: --
7238: IF g_event_class_code_tbl.FIRST IS NULL THEN
7239: xla_exceptions_pkg.raise_message
7240: (p_appli_s_name => 'XLA'
7241: ,p_msg_name => 'XLA_COMMON_ERROR'
7242: ,p_token_1 => 'ERROR'
7243: ,p_value_1 =>
7250: --
7251: -- Validate that the event type code tables have been loaded
7252: --
7253: IF g_event_type_code_tbl.FIRST IS NULL THEN
7254: xla_exceptions_pkg.raise_message
7255: (p_appli_s_name => 'XLA'
7256: ,p_msg_name => 'XLA_COMMON_ERROR'
7257: ,p_token_1 => 'ERROR'
7258: ,p_value_1 =>
7387: ,p_level => C_LEVEL_PROCEDURE
7388: ,p_module =>l_log_module);
7389: END IF;
7390: EXCEPTION
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');
7390: EXCEPTION
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:
7427: g_id_mapping := g_entity_type_code_tbl(p_entity_type_code).id_mapping;
7428: ELSIF (l_enabled_flag = C_YES) THEN
7429: g_id_mapping := g_entity_type_code_tbl(p_entity_type_code).id_mapping;
7430: ELSIF (l_enabled_flag <> C_YES) THEN
7431: xla_exceptions_pkg.raise_message
7432: (p_appli_s_name => 'XLA'
7433: ,p_msg_name => 'XLA_COMMON_ERROR'
7434: ,p_token_1 => 'ERROR'
7435: ,p_value_1 =>
7446: END IF;
7447:
7448: EXCEPTION
7449: WHEN NO_DATA_FOUND THEN
7450: xla_exceptions_pkg.raise_message
7451: (p_appli_s_name => 'XLA'
7452: ,p_msg_name => 'XLA_COMMON_ERROR'
7453: ,p_token_1 => 'ERROR'
7454: ,p_value_1 => p_entity_type_code||
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
7462: (p_location => 'xla_events_pkg.validate_entity_type_code');
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
7462: (p_location => 'xla_events_pkg.validate_entity_type_code');
7463: END validate_entity_type_code;
7464:
7465:
7493: IF (((g_action = C_EVENT_CREATE) OR (g_action = C_EVENT_UPDATE)) AND
7494: (l_enabled_flag <> C_YES)
7495: )
7496: THEN
7497: xla_exceptions_pkg.raise_message
7498: (p_appli_s_name => 'XLA'
7499: ,p_msg_name => 'XLA_COMMON_ERROR'
7500: ,p_token_1 => 'ERROR'
7501: ,p_value_1 =>
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
7509: (p_appli_s_name => 'XLA'
7510: ,p_msg_name => 'XLA_COMMON_ERROR'
7511: ,p_token_1 => 'ERROR'
7512: ,p_value_1 => 'Event class '||p_event_class_code||
7523: ,p_module =>l_log_module);
7524: END IF;
7525: EXCEPTION
7526: WHEN NO_DATA_FOUND THEN
7527: xla_exceptions_pkg.raise_message
7528: (p_appli_s_name => 'XLA'
7529: ,p_msg_name => 'XLA_COMMON_ERROR'
7530: ,p_token_1 => 'ERROR'
7531: ,p_value_1 => p_event_class_code||
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
7539: (p_location => 'xla_events_pkg.validate_event_class_code');
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
7539: (p_location => 'xla_events_pkg.validate_event_class_code');
7540: END validate_event_class_code;
7541:
7542:
7574: IF (((g_action = C_EVENT_CREATE) OR (g_action = C_EVENT_UPDATE)) AND
7575: (l_enabled_flag <> C_YES)
7576: )
7577: THEN
7578: xla_exceptions_pkg.raise_message
7579: (p_appli_s_name => 'XLA'
7580: ,p_msg_name => 'XLA_COMMON_ERROR'
7581: ,p_token_1 => 'ERROR'
7582: ,p_value_1 =>
7588: IF ((p_entity_type_code <> l_entity_code) OR
7589: (NVL(p_event_class_code,l_event_class_code) <> l_event_class_code)
7590: )
7591: THEN
7592: xla_exceptions_pkg.raise_message
7593: (p_appli_s_name => 'XLA'
7594: ,p_msg_name => 'XLA_COMMON_ERROR'
7595: ,p_token_1 => 'ERROR'
7596: ,p_value_1 => 'Event type '||p_event_type_code||
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'
7616: ,p_msg_name => 'XLA_COMMON_ERROR'
7617: ,p_token_1 => 'ERROR'
7618: ,p_value_1 => p_event_type_code||
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
7626: (p_location => 'xla_events_pkg.validate_event_type_code');
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
7626: (p_location => 'xla_events_pkg.validate_event_type_code');
7627: END validate_event_type_code;
7628:
7629: --=============================================================================
7659: END IF;
7660: END LOOP;
7661:
7662: IF NOT l_found THEN
7663: xla_exceptions_pkg.raise_message
7664: (p_appli_s_name => 'XLA'
7665: ,p_msg_name => 'XLA_COMMON_ERROR'
7666: ,p_token_1 => 'ERROR'
7667: ,p_value_1 => 'Event Status Code cannot have a '||
7683: END IF;
7684: END LOOP;
7685:
7686: IF NOT l_found THEN
7687: xla_exceptions_pkg.raise_message
7688: (p_appli_s_name => 'XLA'
7689: ,p_msg_name => 'XLA_COMMON_ERROR'
7690: ,p_token_1 => 'ERROR'
7691: ,p_value_1 => 'Process Status Code cannot have a '||
7703: -------------------------------------------------------------------------
7704: -- for regular events
7705: -------------------------------------------------------------------------
7706: IF p_process_status_code <> C_INTERNAL_UNPROCESSED THEN
7707: xla_exceptions_pkg.raise_message
7708: (p_appli_s_name => 'XLA'
7709: ,p_msg_name => 'XLA_COMMON_ERROR'
7710: ,p_token_1 => 'ERROR'
7711: ,p_value_1 => 'Process Status Code has an invalid value. '||
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
7719: (p_appli_s_name => 'XLA'
7720: ,p_msg_name => 'XLA_COMMON_ERROR'
7721: ,p_token_1 => 'ERROR'
7722: ,p_value_1 => 'Event Status Code has an invalid value. '||
7731: -------------------------------------------------------------------------
7732:
7733: IF (p_process_status_code = C_INTERNAL_FINAL) THEN
7734: IF (p_event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED) THEN
7735: xla_exceptions_pkg.raise_message
7736: (p_appli_s_name => 'XLA'
7737: ,p_msg_name => 'XLA_COMMON_ERROR'
7738: ,p_token_1 => 'ERROR'
7739: ,p_value_1 => 'The following combination is invalid: '||
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
7749: (p_appli_s_name => 'XLA'
7750: ,p_msg_name => 'XLA_COMMON_ERROR'
7751: ,p_token_1 => 'ERROR'
7752: ,p_value_1 => 'The following combination is invalid: '||
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
7762: (p_appli_s_name => 'XLA'
7763: ,p_msg_name => 'XLA_COMMON_ERROR'
7764: ,p_token_1 => 'ERROR'
7765: ,p_value_1 => 'The following combination is invalid: '||
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'
7775: ,p_msg_name => 'XLA_COMMON_ERROR'
7776: ,p_token_1 => 'ERROR'
7777: ,p_value_1 => 'The following combination is invalid: '||
7789: ,p_level => C_LEVEL_PROCEDURE
7790: ,p_module =>l_log_module);
7791: END IF;
7792: EXCEPTION
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');
7792: EXCEPTION
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:
7899: ,p_module =>l_log_module);
7900: END IF;
7901:
7902: EXCEPTION
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');
7902: EXCEPTION
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:
7946: IF g_ledger_status_tbl.exists(p_ledger_id) THEN
7947: IF g_ledger_status_tbl(p_ledger_id) = 'Y' THEN
7948: NULL;
7949: ELSE
7950: xla_exceptions_pkg.raise_message
7951: (p_appli_s_name => 'XLA'
7952: ,p_msg_name => 'XLA_COMMON_ERROR'
7953: ,p_token_1 => 'ERROR'
7954: ,p_value_1 =>
7968: WHERE ledger_id = p_ledger_id
7969: AND application_id = p_application_id;
7970: EXCEPTION
7971: WHEN NO_DATA_FOUND THEN
7972: xla_exceptions_pkg.raise_message
7973: (p_appli_s_name => 'XLA'
7974: ,p_msg_name => 'XLA_SU_MISSING_SETUP'
7975: ,p_token_1 => 'LEDGER_NAME'
7976: ,p_value_1 => l_ledger_name
7986: ,p_module =>l_log_module);
7987: END IF;
7988:
7989: EXCEPTION
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');
7989: EXCEPTION
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:
8281: ,p_module =>l_log_module);
8282: END IF;
8283:
8284: EXCEPTION
8285: WHEN xla_exceptions_pkg.application_exception THEN
8286: IF c1%ISOPEN THEN
8287: CLOSE c1;
8288: END IF;
8289: IF c2%ISOPEN THEN
8296: END IF;
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:
8427:
8428: return l_return_id;
8429:
8430: EXCEPTION
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');
8430: EXCEPTION
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:
8468: ,p_module =>l_log_module);
8469: END IF;
8470:
8471: EXCEPTION
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');
8471: EXCEPTION
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: --=============================================================================
8642: ,p_module =>l_log_module);
8643: END IF;
8644: RETURN l_event_id;
8645: EXCEPTION
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)');
8645: EXCEPTION
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:
8702: ,p_module =>l_log_module);
8703: END IF;
8704:
8705: EXCEPTION
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');
8705: EXCEPTION
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:
8738: ,p_level => C_LEVEL_PROCEDURE
8739: ,p_module =>l_log_module);
8740: END IF;
8741: EXCEPTION
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');
8741: EXCEPTION
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:
8960: ,p_level => C_LEVEL_PROCEDURE
8961: ,p_module => l_log_module);
8962: END IF;
8963: EXCEPTION
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');
8963: EXCEPTION
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:
9103:
9104: commit; -- commit is mandatory after fnd_request.submit_request
9105:
9106: IF l_request_id = 0 THEN
9107: xla_exceptions_pkg.raise_message
9108: (p_appli_s_name => 'XLA'
9109: ,p_msg_name => 'XLA_REP_TECHNICAL_ERROR'
9110: ,p_token_1 => 'APPLICATION_NAME'
9111: ,p_value_1 => 'SLA');
9130:
9131: RETURN 'SUCCESS'; -- No Notification.
9132:
9133: EXCEPTION
9134: WHEN XLA_EXCEPTIONS_PKG.application_exception THEN
9135: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9136: trace('End of function Period Close with error', C_LEVEL_STATEMENT,
9137: l_log_module);
9138: END IF;