APPS.IGS_EN_SPI_RCOND_LGCY_PUB dependencies on FND_API

Line 186: IF NOT FND_API.COMPATIBLE_API_CALL( p_current_version_number => l_api_version,

182: -- return condition to true
183: l_insert_flag := TRUE;
184:
185: -- Check if the api version and the parameter p_api_version are compatible. If not raise and FND unexpected error.
186: IF NOT FND_API.COMPATIBLE_API_CALL( p_current_version_number => l_api_version,
187: p_caller_version_number => p_api_version,
188: p_api_name => l_api_name,
189: p_pkg_name => 'IGS_EN_SPI_RCOND_LGCY_PUB')
190: THEN

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189: p_pkg_name => 'IGS_EN_SPI_RCOND_LGCY_PUB')
190: THEN
191:
192: l_insert_flag := FALSE;
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194:
195: END IF;
196:
197: -- initialize the return status to success

Line 198: x_return_status := FND_API.G_RET_STS_SUCCESS;

194:
195: END IF;
196:
197: -- initialize the return status to success
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: -- If parameter p_init_msg_list is passed as TRUE, then initialize the message list
201: IF FND_API.TO_BOOLEAN (p_init_msg_list) THEN
202: FND_MSG_PUB.INITIALIZE;

Line 201: IF FND_API.TO_BOOLEAN (p_init_msg_list) THEN

197: -- initialize the return status to success
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: -- If parameter p_init_msg_list is passed as TRUE, then initialize the message list
201: IF FND_API.TO_BOOLEAN (p_init_msg_list) THEN
202: FND_MSG_PUB.INITIALIZE;
203: END IF;
204:
205:

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

209: IF l_person_id IS NULL THEN
210: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
211: FND_MSG_PUB.ADD;
212: l_insert_flag := FALSE;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: END IF;
215:
216: -- If Approver Number is provided then ensure that it is valid.
217: -- Otherwise throw Error

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: IF l_approver_id IS NULL THEN
222: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NO_APPROV_PERSON');
223: FND_MSG_PUB.ADD;
224: l_insert_flag := FALSE;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: END IF;
227:
228: END IF;
229:

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232: IF l_insert_flag THEN
233: -- validate the parameters passed
234: IF validate_parameters(l_person_id,p_intm_rcond_rec) = 'E' THEN
235: l_insert_flag := FALSE;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: END IF;
238: END IF;
239:
240: OPEN c_crs_status ( l_person_id);

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243:
244: IF l_insert_flag THEN
245: l_ret_val := validate_db_cons( l_person_id, p_intm_rcond_rec);
246: IF l_ret_val = 'E' THEN
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: l_insert_flag := FALSE;
249: ELSIF l_ret_val = 'W' THEN
250: x_return_status := 'W';
251: l_insert_flag := FALSE;

Line 332: IF (FND_API.TO_BOOLEAN(p_commit) AND l_insert_flag ) THEN

328:
329: END IF; -- IF l_insert_flag
330:
331: -- Commit the record which is inserted in the table.
332: IF (FND_API.TO_BOOLEAN(p_commit) AND l_insert_flag ) THEN
333: COMMIT WORK;
334: END IF;
335:
336: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

Line 340: WHEN FND_API.G_EXC_ERROR THEN

336: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
337: p_data => x_msg_data);
338:
339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN
341: ROLLBACK TO create_en_spi_rcond_pub;
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
344: p_data => x_msg_data);

Line 342: x_return_status := FND_API.G_RET_STS_ERROR;

338:
339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN
341: ROLLBACK TO create_en_spi_rcond_pub;
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
344: p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

342: x_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
344: p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO create_en_spi_rcond_pub;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
350: p_data => x_msg_data);

Line 348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

344: p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO create_en_spi_rcond_pub;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
350: p_data => x_msg_data);
351:
352: WHEN OTHERS THEN

Line 354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

350: p_data => x_msg_data);
351:
352: WHEN OTHERS THEN
353: ROLLBACK TO create_en_spi_rcond_pub;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
356: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
357: l_api_name);
358: END IF;