163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
164:
165: if l_funds_reserved_flag = 'Y' then
166:
167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
168: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
169: values (l_event_id, 'FAIL');
170:
171: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
164:
165: if l_funds_reserved_flag = 'Y' then
166:
167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
168: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
169: values (l_event_id, 'FAIL');
170:
171: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
172: -- always pass P_BC_MODE = reserve as per shaniqua williams
538: fetch c_events into l_event_id;
539: EXIT WHEN c_events%NOTFOUND;
540:
541: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
542: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
543: insert
544: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
545: values (l_event_id, 'FAIL');
546:
540:
541: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
542: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
543: insert
544: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
545: values (l_event_id, 'FAIL');
546:
547: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
548: PSA_BC_XLA_PUB.Budgetary_Control(p_api_version => 1.0