DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_LGCY_PVT dependencies on FND_API

Line 55: IF NOT FND_API.Compatible_API_Call(l_api_version ,

51: --Standard start of API savepoint
52: SAVEPOINT Create_Unit_PVT;
53:
54: --Standard call to check for call compatibility
55: IF NOT FND_API.Compatible_API_Call(l_api_version ,
56: p_api_version ,
57: l_api_name ,
58: G_PKG_NAME ) THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: IF NOT FND_API.Compatible_API_Call(l_api_version ,
56: p_api_version ,
57: l_api_name ,
58: G_PKG_NAME ) THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: --Initialize message list if p_init_msg_list is set to TRUE
63: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 63: IF FND_API.to_Boolean(p_init_msg_list) THEN

59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61:
62: --Initialize message list if p_init_msg_list is set to TRUE
63: IF FND_API.to_Boolean(p_init_msg_list) THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:
67:

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: END IF;
66:
67:
68: --Initialize API return status to success
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: --API body
72: --Call Unit Version sub process
73: IF p_unit_ver_rec.unit_cd IS NOT NULL AND p_unit_ver_rec.version_number IS NOT NULL THEN

Line 77: RAISE FND_API.G_EXC_ERROR;

73: IF p_unit_ver_rec.unit_cd IS NOT NULL AND p_unit_ver_rec.version_number IS NOT NULL THEN
74: igs_ps_unit_lgcy_pkg.create_unit_version(p_unit_ver_rec,l_rec_status);
75: l_record_exists := TRUE;
76: IF l_rec_status = 'E' THEN
77: RAISE FND_API.G_EXC_ERROR;
78: END IF;
79: END IF;
80:
81: --Call the Unit teaching responsibility sub process

Line 175: RAISE FND_API.G_EXC_ERROR;

171: --If none of the PL/SQL data has been passed then raise error
172: IF NOT l_record_exists THEN
173: FND_MESSAGE.SET_NAME('IGS','IGS_PS_LGCY_DATA_NOT_PASSED');
174: FND_MSG_PUB.ADD;
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:
178: --If return status is error then raise expected exception to rollback the changes
179: IF x_return_status = 'E' THEN

Line 180: RAISE FND_API.G_EXC_ERROR;

176: END IF;
177:
178: --If return status is error then raise expected exception to rollback the changes
179: IF x_return_status = 'E' THEN
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182:
183: --End of API body
184:

Line 186: IF FND_API.TO_Boolean( p_commit) THEN

182:
183: --End of API body
184:
185: --Standard check of p_commit
186: IF FND_API.TO_Boolean( p_commit) THEN
187: COMMIT WORK;
188: END IF;
189:
190: --Standard call to get message count and if count is 1, get message info.

Line 201: WHEN FND_API.G_EXC_ERROR THEN

197: END IF;
198:
199:
200: EXCEPTION
201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO Create_Unit_PVT;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
205: p_data => x_msg_data );

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

199:
200: EXCEPTION
201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO Create_Unit_PVT;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
205: p_data => x_msg_data );
206:
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

203: x_return_status := FND_API.G_RET_STS_ERROR;
204: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
205: p_data => x_msg_data );
206:
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: ROLLBACK TO Create_Unit_PVT;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
211: p_data => x_msg_data );

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

205: p_data => x_msg_data );
206:
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: ROLLBACK TO Create_Unit_PVT;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,
211: p_data => x_msg_data );
212:
213: WHEN OTHERS THEN

Line 216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212:
213: WHEN OTHERS THEN
214: ROLLBACK TO Create_Unit_PVT;
215:
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
218: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
219: l_api_name);
220: END IF;