DBA Data[Home] [Help]

APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on FND_API

Line 40: p_init_msg_list => fnd_api.g_false,

36: --added for r12 to populate temporary tables
37: MO_GLOBAL.INIT('CS_CHARGES') ;
38:
39: Auto_Submit_Chg_Lines(p_api_version => 1.0,
40: p_init_msg_list => fnd_api.g_false,
41: p_commit => fnd_api.g_false,
42: x_return_status => lx_return_status,
43: x_msg_count => lx_msg_count,
44: x_msg_data => lx_msg_data);

Line 41: p_commit => fnd_api.g_false,

37: MO_GLOBAL.INIT('CS_CHARGES') ;
38:
39: Auto_Submit_Chg_Lines(p_api_version => 1.0,
40: p_init_msg_list => fnd_api.g_false,
41: p_commit => fnd_api.g_false,
42: x_return_status => lx_return_status,
43: x_msg_count => lx_msg_count,
44: x_msg_data => lx_msg_data);
45:

Line 46: IF (lx_return_status <> FND_API.G_RET_STS_SUCCESS)

42: x_return_status => lx_return_status,
43: x_msg_count => lx_msg_count,
44: x_msg_data => lx_msg_data);
45:
46: IF (lx_return_status <> FND_API.G_RET_STS_SUCCESS)
47: THEN
48: conc_status := fnd_concurrent.set_completion_status('WARNING','Warning');
49: END IF;
50:

Line 244: x_return_status := FND_API.G_RET_STS_SUCCESS;

240:
241: BEGIN
242:
243: -- Initialize API return status to success
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246: -- Standard call to check for call compatibility
247: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 247: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN

243: -- Initialize API return status to success
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246: -- Standard call to check for call compatibility
247: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251: -- Initialize message list if p_init_msg_list is set to TRUE

Line 248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246: -- Standard call to check for call compatibility
247: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,G_PKG_NAME) THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251: -- Initialize message list if p_init_msg_list is set to TRUE
252: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 252: IF FND_API.To_Boolean(p_init_msg_list) THEN

248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251: -- Initialize message list if p_init_msg_list is set to TRUE
252: IF FND_API.To_Boolean(p_init_msg_list) THEN
253: FND_MSG_PUB.Initialize;
254: END IF;
255:
256: l_auto_submit_mode := fnd_profile.value('CS_CHG_AUTO_SUBMIT_MODE');

Line 274: -- x_return_status := FND_API.G_RET_STS_ERROR;

270: FND_MSG_PUB.Initialize;
271: FND_MESSAGE.Set_Name('CS','CS_CHG_DEFINE_PROFILE_OPTION');
272: FND_MESSAGE.Set_Token('PROFILE_OPTION','CS_CHG_AUTO_SUBMIT_MODE');
273: FND_MSG_PUB.Add;
274: -- x_return_status := FND_API.G_RET_STS_ERROR;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: EXCEPTION

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: FND_MESSAGE.Set_Name('CS','CS_CHG_DEFINE_PROFILE_OPTION');
272: FND_MESSAGE.Set_Token('PROFILE_OPTION','CS_CHG_AUTO_SUBMIT_MODE');
273: FND_MSG_PUB.Add;
274: -- x_return_status := FND_API.G_RET_STS_ERROR;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: EXCEPTION
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: EXCEPTION
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: FND_MSG_PUB.get(p_encoded => 'F',
281: p_data=>x_msg_data,
282: p_msg_index_out=> l_msg_index_out);
283:

Line 1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1235: WHEN OTHERS THEN
1236: IF l_found = 'N' THEN
1237: FND_FILE.put_line(FND_FILE.LOG,'There are no eligible Charge lines available for submission to Order Management');
1238: ELSE
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1241: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');
1242: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1243: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);

Line 1317: x_return_status := FND_API.G_RET_STS_SUCCESS;

1313: t NUMBER :=0;
1314: l_msg_index_out NUMBER;
1315:
1316: BEGIN
1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318:
1319: IF p_submit_restriction_message IS NOT NULL THEN
1320:
1321: FND_MSG_PUB.get(p_encoded => 'F',

Line 1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1393: COMMIT;
1394:
1395: EXCEPTION
1396: WHEN OTHERS THEN
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1399: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1400: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1401: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);

Line 1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1490:
1491:
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1495: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1496: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1497: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1498: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);

Line 1563: x_return_status := FND_API.G_RET_STS_SUCCESS;

1559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'verifying debrief status ..');
1560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1561:
1562:
1563: x_return_status := FND_API.G_RET_STS_SUCCESS;
1564: x_restriction_qualify_flag := 'N';
1565:
1566: csf_debrief_update_pkg.debrief_status_check(
1567: p_incident_id => p_incident_id,

Line 1672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1669:
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1673: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1674: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1675: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1676: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);