APPS.IGS_EN_SPA_LGCY_PUB dependencies on FND_API

Line 924: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,

920: --Save point for whole procedure.
921: SAVEPOINT create_spa;
922:
923: -- Check for the Compatible API call
924: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,
925: p_api_version,
926: l_api_name,
927: g_pkg_name) THEN
928:

Line 929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

925: p_api_version,
926: l_api_name,
927: g_pkg_name) THEN
928:
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931:
932: -- If the calling program has passed the parameter for initializing the message list
933: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 933: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931:
932: -- If the calling program has passed the parameter for initializing the message list
933: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
934: FND_MSG_PUB.Initialize;
935: END IF;
936:
937: --Assign the parameter record type to local record type.

Line 941: x_return_status := FND_API.G_RET_STS_SUCCESS;

937: --Assign the parameter record type to local record type.
938: l_sca_re_rec := p_sca_re_rec;
939:
940: -- Set the return status to success
941: x_return_status := FND_API.G_RET_STS_SUCCESS;
942:
943: --Derive the concurrent program who column values.
944: l_request_id := fnd_global.conc_request_id;
945: l_program_id := fnd_global.conc_program_id;

Line 1353: x_return_status := FND_API.G_RET_STS_ERROR;

1349: IF ((l_err_flag ='Y') OR
1350: (l_execution_flag1 ='E') OR
1351: (l_execution_flag2 ='E')) THEN
1352: ROLLBACK TO create_spa;
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: ELSIF ((l_execution_flag1 = 'P') AND (l_execution_flag2 IS NULL)) OR
1355: ((l_execution_flag1 = 'P') AND (l_execution_flag2 ='P')) THEN
1356: x_return_status := 'W';
1357: ELSE

Line 1358: IF FND_API.TO_BOOLEAN(p_commit) THEN

1354: ELSIF ((l_execution_flag1 = 'P') AND (l_execution_flag2 IS NULL)) OR
1355: ((l_execution_flag1 = 'P') AND (l_execution_flag2 ='P')) THEN
1356: x_return_status := 'W';
1357: ELSE
1358: IF FND_API.TO_BOOLEAN(p_commit) THEN
1359: COMMIT WORK;
1360: END IF;
1361: x_return_status := FND_API.G_RET_STS_SUCCESS;
1362: END IF;

Line 1361: x_return_status := FND_API.G_RET_STS_SUCCESS;

1357: ELSE
1358: IF FND_API.TO_BOOLEAN(p_commit) THEN
1359: COMMIT WORK;
1360: END IF;
1361: x_return_status := FND_API.G_RET_STS_SUCCESS;
1362: END IF;
1363: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1364: p_data => x_msg_data);
1365: EXCEPTION

Line 1366: WHEN FND_API.G_EXC_ERROR THEN

1362: END IF;
1363: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1364: p_data => x_msg_data);
1365: EXCEPTION
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: ROLLBACK TO create_spa;
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1370: p_data => x_msg_data);

Line 1368: x_return_status := FND_API.G_RET_STS_ERROR;

1364: p_data => x_msg_data);
1365: EXCEPTION
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: ROLLBACK TO create_spa;
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1370: p_data => x_msg_data);
1371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1372: ROLLBACK TO create_spa;

Line 1371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1367: ROLLBACK TO create_spa;
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1370: p_data => x_msg_data);
1371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1372: ROLLBACK TO create_spa;
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1375: p_data => x_msg_data);

Line 1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1369: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1370: p_data => x_msg_data);
1371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1372: ROLLBACK TO create_spa;
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1375: p_data => x_msg_data);
1376: WHEN OTHERS THEN
1377: ROLLBACK TO create_spa;

Line 1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1374: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
1375: p_data => x_msg_data);
1376: WHEN OTHERS THEN
1377: ROLLBACK TO create_spa;
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1380: FND_MSG_PUB.ADD_Exc_Msg(g_pkg_name,
1381: l_api_name);
1382: END IF;