197: p_level => C_LEVEL_STATEMENT);
198: END IF;
199: UPDATE XLA_EVENTS
200: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
201: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
202: WHERE application_id = p_application_id
203: AND event_id = p_event_id;
204:
205:
648: l_event_source_info.ledger_id := l_ledger_id;
649: l_event_source_info.entity_type_code := 'MANUAL';
650:
651: ---------------------------------------------------------------------------------------------
652: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type
653: ---------------------------------------------------------------------------------------------
654: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type
655: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
656: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
650:
651: ---------------------------------------------------------------------------------------------
652: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type
653: ---------------------------------------------------------------------------------------------
654: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type
655: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
656: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
657: p_module => l_log_module,
658: p_level => C_LEVEL_STATEMENT);
652: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type
653: ---------------------------------------------------------------------------------------------
654: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type
655: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
656: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
657: p_module => l_log_module,
658: p_level => C_LEVEL_STATEMENT);
659: END IF;
660: x_new_event_id := xla_events_pkg.create_manual_event
656: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
657: p_module => l_log_module,
658: p_level => C_LEVEL_STATEMENT);
659: END IF;
660: x_new_event_id := xla_events_pkg.create_manual_event
661: (p_event_source_info => l_event_source_info
662: ,p_event_type_code => 'MANUAL'
663: ,p_event_date => l_pri_gl_date
664: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
661: (p_event_source_info => l_event_source_info
662: ,p_event_type_code => 'MANUAL'
663: ,p_event_date => l_pri_gl_date
664: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
665: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
666: ,p_event_number => 1
667: ,p_budgetary_control_flag => l_bc_flag);
668: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
669: trace(p_msg => 'Returned from xla_events_pkg.create_manual_event = event id '||x_new_event_id,
665: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
666: ,p_event_number => 1
667: ,p_budgetary_control_flag => l_bc_flag);
668: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
669: trace(p_msg => 'Returned from xla_events_pkg.create_manual_event = event id '||x_new_event_id,
670: p_module => l_log_module,
671: p_level => C_LEVEL_STATEMENT);
672: END IF;
673:
871: -- set original event to Unprocessed
872: ---------------------------------------------------------
873: UPDATE XLA_EVENTS
874: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
875: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
876: WHERE application_id = p_application_id
877: AND event_id = p_event_id;
878:
879: -------------------------------------------------------------------------------