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
173: PSA_BC_XLA_PUB.Budgetary_Control(p_api_version => 1.0
174: ,p_init_msg_list => FND_API.G_FALSE
175: ,x_return_status => l_return_status
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
173: PSA_BC_XLA_PUB.Budgetary_Control(p_api_version => 1.0
174: ,p_init_msg_list => FND_API.G_FALSE
175: ,x_return_status => l_return_status
176: ,x_msg_count => l_msg_count
177: ,x_msg_data => l_msg_data
191: if (l_return_status <> 'S') then
192:
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
195: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
196: FND_MSG_PUB.ADD;
197: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
198: RAISE FND_API.G_EXC_ERROR;
199:
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
549: ,p_init_msg_list => FND_API.G_FALSE
550: ,x_return_status => l_return_status
551: ,x_msg_count => l_msg_count
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
549: ,p_init_msg_list => FND_API.G_FALSE
550: ,x_return_status => l_return_status
551: ,x_msg_count => l_msg_count
552: ,x_msg_data => l_msg_data
568: if (l_return_status <> 'S' ) then
569:
570: l_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
572: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
573: FND_MSG_PUB.ADD;
574: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
575: RAISE FND_API.G_EXC_ERROR;
576:
582: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
583: RAISE FND_API.G_EXC_ERROR;
584: ELSE
585: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
586: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to PSA_BC_XLA_PUB.Budgetary_Control failed with Status Code = ' || l_status_code);
587: FND_MSG_PUB.ADD;
588: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
589: RAISE FND_API.G_EXC_ERROR;
590: END IF;