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_SPAT_LGCY_PUB dependencies on FND_API

Line 468: IF NOT FND_API.COMPATIBLE_API_CALL (

464: -- create a save point
465: SAVEPOINT create_spa_t_svpt;
466:
467: --check for compatible API call
468: IF NOT FND_API.COMPATIBLE_API_CALL (
469: l_api_version,
470: p_api_version,
471: l_api_name,
472: g_pkg_name) THEN

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: l_api_version,
470: p_api_version,
471: l_api_name,
472: g_pkg_name) THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476: -- If the calling program has passed the parameter for initializing the message list
477: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 477: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476: -- If the calling program has passed the parameter for initializing the message list
477: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
478: FND_MSG_PUB.INITIALIZE;
479: END IF;
480:
481: -- Set the return status to success

Line 482: x_return_status := FND_API.G_RET_STS_SUCCESS;

478: FND_MSG_PUB.INITIALIZE;
479: END IF;
480:
481: -- Set the return status to success
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483:
484: -- validate parameters
485: IF NOT validate_parameters(
486: p_spat_rec => p_spat_rec) THEN

Line 487: x_return_status := FND_API.G_RET_STS_ERROR;

483:
484: -- validate parameters
485: IF NOT validate_parameters(
486: p_spat_rec => p_spat_rec) THEN
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: l_validation_failed := TRUE;
489: END IF;
490:
491: -- if no validation has failed then derive person_id, term_cal_type, term_sequence_number

Line 498: x_return_status := FND_API.G_RET_STS_ERROR;

494: l_person_id := igs_ge_gen_003.get_person_id(p_spat_rec.person_number);
495: IF l_person_id IS NULL THEN
496: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');
497: FND_MSG_PUB.ADD;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: l_validation_failed := TRUE;
500: END IF;
501:
502: igs_ge_gen_003.get_calendar_instance(

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509: l_get_calendar_instance_return);
510: IF l_get_calendar_instance_return = 'INVALID' THEN
511: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ALT_CD_NO_TRM_FND');
512: FND_MSG_PUB.ADD;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: l_validation_failed := TRUE;
515: ELSE
516: IF l_get_calendar_instance_return = 'MULTIPLE' THEN
517: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MULTI_TRM_CAL_FND');

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: ELSE
516: IF l_get_calendar_instance_return = 'MULTIPLE' THEN
517: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MULTI_TRM_CAL_FND');
518: FND_MSG_PUB.ADD;
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: l_validation_failed := TRUE;
521: END IF;
522: END IF;
523:

Line 529: x_return_status := FND_API.G_RET_STS_ERROR;

525: l_class_standing_id := igs_en_gen_legacy.get_class_std_id(p_spat_rec.class_standing);
526: IF l_class_standing_id IS NULL THEN
527: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CLASS_STD_ID_NOT_FOUND');
528: FND_MSG_PUB.ADD;
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: l_validation_failed := TRUE;
531: END IF;
532: END IF;
533:

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: p_spat_rec.attendance_type);
541: IF l_coo_id IS NULL THEN
542: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PS_OFR_OPT_NOT_FOUND');
543: FND_MSG_PUB.ADD;
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: l_validation_failed := TRUE;
546: END IF;
547: END IF;
548:

Line 561: x_return_status := FND_API.G_RET_STS_ERROR;

557: x_return_status := 'W';
558: l_validation_failed := TRUE;
559: END IF;
560: IF l_validate_db_ret_status = 'E' THEN
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: l_validation_failed := TRUE;
563: END IF;
564: END IF; --end of database constraints validation
565:

Line 573: x_return_status := FND_API.G_RET_STS_ERROR;

569: l_person_id,
570: l_term_cal_type,
571: l_term_sequence_number,
572: p_spat_rec) THEN
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: l_validation_failed := TRUE;
575: END IF;
576: END IF;
577:

Line 703: x_return_status := FND_API.G_RET_STS_SUCCESS;

699: p_coo_id => l_coo_id,
700: p_spat_rec => p_spat_rec);
701:
702: -- setting the return value to success
703: x_return_status := FND_API.G_RET_STS_SUCCESS;
704: ELSE
705: ROLLBACK TO create_spa_t_svpt;
706: END IF;
707:

Line 709: IF NOT l_validation_failed AND FND_API.TO_BOOLEAN(p_commit) THEN

705: ROLLBACK TO create_spa_t_svpt;
706: END IF;
707:
708: -- if no validation failed and asked to commit through p_commit
709: IF NOT l_validation_failed AND FND_API.TO_BOOLEAN(p_commit) THEN
710: COMMIT;
711: END IF;
712:
713: FND_MSG_PUB.COUNT_AND_GET (

Line 721: WHEN FND_API.G_EXC_ERROR THEN

717: RETURN;
718:
719: EXCEPTION
720:
721: WHEN FND_API.G_EXC_ERROR THEN
722: ROLLBACK TO create_spa_t_svpt;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: FND_MSG_PUB.COUNT_AND_GET (
725: p_count => x_msg_count,

Line 723: x_return_status := FND_API.G_RET_STS_ERROR;

719: EXCEPTION
720:
721: WHEN FND_API.G_EXC_ERROR THEN
722: ROLLBACK TO create_spa_t_svpt;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: FND_MSG_PUB.COUNT_AND_GET (
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727:

Line 728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

724: FND_MSG_PUB.COUNT_AND_GET (
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO create_spa_t_svpt;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.COUNT_AND_GET (
732: p_count => x_msg_count,

Line 730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

726: p_data => x_msg_data);
727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO create_spa_t_svpt;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.COUNT_AND_GET (
732: p_count => x_msg_count,
733: p_data => x_msg_data);
734:

Line 737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

733: p_data => x_msg_data);
734:
735: WHEN OTHERS THEN
736: ROLLBACK TO create_spa_t_svpt;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
739: FND_MSG_PUB.ADD_EXC_MSG(
740: g_pkg_name,
741: l_api_name);