eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_SPI_LGCY_PUB dependencies on FND_API

Line 399: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,

395:
396: SAVEPOINT create_en_spi_pub;
397:
398: -- Check for the Compatible API call
399: IF NOT FND_API.COMPATIBLE_API_CALL( l_api_version,
400: p_api_version,
401: l_api_name,
402: g_pkg_name) THEN
403:

Line 404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

400: p_api_version,
401: l_api_name,
402: g_pkg_name) THEN
403:
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406:
407: -- If the calling program has passed the parameter for initializing the message list
408: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 408: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406:
407: -- If the calling program has passed the parameter for initializing the message list
408: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
409: FND_MSG_PUB.INITIALIZE;
410: END IF;
411:
412: -- Set the return status to success

Line 413: x_return_status := FND_API.G_RET_STS_SUCCESS;

409: FND_MSG_PUB.INITIALIZE;
410: END IF;
411:
412: -- Set the return status to success
413: x_return_status := FND_API.G_RET_STS_SUCCESS;
414:
415: -- Validate the parameters
416: IF NOT validate_parameter(p_intermiss_rec) THEN
417: l_insert_flag := FALSE;

Line 418: x_return_status := FND_API.G_RET_STS_ERROR;

414:
415: -- Validate the parameters
416: IF NOT validate_parameter(p_intermiss_rec) THEN
417: l_insert_flag := FALSE;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: END IF;
420:
421: IF p_intermiss_rec.COND_RETURN_FLAG IS NULL THEN
422: l_cond_return_flag:= 'N';

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431: l_person_id := Igs_Ge_Gen_003.get_person_id (p_intermiss_rec.person_number);
432: IF l_person_id IS NULL THEN
433: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');
434: FND_MSG_PUB.ADD;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: l_insert_flag := FALSE;
437: END IF;
438: END IF;
439:

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: l_approver_person_id := Igs_Ge_Gen_003.get_person_id (p_intermiss_rec.approver_person_number);
445: IF l_approver_person_id IS NULL THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_APPROV_PERSON');
447: FND_MSG_PUB.ADD;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: l_insert_flag := FALSE;
450: END IF;
451: END IF;
452: END IF;

Line 458: x_return_status := FND_API.G_RET_STS_ERROR;

454: -- If all the validations are passed then check for DB constraints. It either returns Warning or Error.
455: IF l_insert_flag = TRUE THEN
456: l_ret_val := validate_db_cons ( l_person_id, p_intermiss_rec);
457: IF l_ret_val = 'E' THEN
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: l_insert_flag := FALSE;
460: ELSIF l_ret_val = 'W' THEN
461: x_return_status := 'W';
462: l_insert_flag := FALSE;

Line 470: x_return_status := FND_API.G_RET_STS_ERROR;

466: -- Check for the business rules.
467: IF l_insert_flag = TRUE THEN
468: IF NOT validate_stu_intm (l_person_id, p_intermiss_rec, l_approver_person_id) THEN
469: l_insert_flag := FALSE;
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: END IF;
472: END IF;
473:
474:

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

617: ROLLBACK TO create_en_spi_pub;
618: END IF;
619:
620: -- Commit the record which is inserted in the table.
621: IF (FND_API.TO_BOOLEAN(p_commit) AND l_insert_flag ) THEN
622: COMMIT WORK;
623: END IF;
624:
625: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

Line 630: WHEN FND_API.G_EXC_ERROR THEN

626: p_data => x_msg_data);
627:
628:
629: EXCEPTION
630: WHEN FND_API.G_EXC_ERROR THEN
631: ROLLBACK TO create_en_spi_pub;
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
634: p_data => x_msg_data);

Line 632: x_return_status := FND_API.G_RET_STS_ERROR;

628:
629: EXCEPTION
630: WHEN FND_API.G_EXC_ERROR THEN
631: ROLLBACK TO create_en_spi_pub;
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
634: p_data => x_msg_data);
635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

632: x_return_status := FND_API.G_RET_STS_ERROR;
633: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
634: p_data => x_msg_data);
635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
637: ROLLBACK TO create_en_spi_pub;
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
640: p_data => x_msg_data);

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

634: p_data => x_msg_data);
635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
637: ROLLBACK TO create_en_spi_pub;
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
640: p_data => x_msg_data);
641:
642: WHEN OTHERS THEN

Line 644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

640: p_data => x_msg_data);
641:
642: WHEN OTHERS THEN
643: ROLLBACK TO create_en_spi_pub;
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
646: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
647: l_api_name);
648: END IF;