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 242: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 250: IF FND_API.To_Boolean(p_init_msg_list) THEN

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

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

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

Line 273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1307: x_return_status := FND_API.G_RET_STS_SUCCESS;

1303: t NUMBER :=0;
1304: l_msg_index_out NUMBER;
1305:
1306: BEGIN
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308:
1309: IF p_submit_restriction_message IS NOT NULL THEN
1310:
1311: FND_MSG_PUB.get(p_encoded => 'F',

Line 1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1374: COMMIT;
1375:
1376: EXCEPTION
1377: WHEN OTHERS THEN
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1380: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1381: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1382: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);

Line 1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1471:
1472:
1473: EXCEPTION
1474: WHEN OTHERS THEN
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1476: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1477: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1478: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1479: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);

Line 1544: x_return_status := FND_API.G_RET_STS_SUCCESS;

1540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'verifying debrief status ..');
1541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1542:
1543:
1544: x_return_status := FND_API.G_RET_STS_SUCCESS;
1545: x_restriction_qualify_flag := 'N';
1546:
1547: csf_debrief_update_pkg.debrief_status_check(
1548: p_incident_id => p_incident_id,

Line 1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*********************************');
1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1655: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1656: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1657: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);