APPS.IGS_HE_SPA_LGCY_PUB dependencies on FND_API

Line 585: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

581: -- Create save point
582: SAVEPOINT create_hesa_spa_pub;
583:
584: -- Check for the Compatible API call
585: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
586: p_api_version,
587: l_api_name,
588: g_pkg_name) THEN
589:

Line 590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

586: p_api_version,
587: l_api_name,
588: g_pkg_name) THEN
589:
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END IF;
592:
593: -- If the calling program has passed the parameter for initializing the message list
594: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 594: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END IF;
592:
593: -- If the calling program has passed the parameter for initializing the message list
594: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
595: FND_MSG_PUB.INITIALIZE;
596: END IF;
597:
598: -- Set the return status to success

Line 599: x_return_status := FND_API.G_RET_STS_SUCCESS;

595: FND_MSG_PUB.INITIALIZE;
596: END IF;
597:
598: -- Set the return status to success
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
600:
601:
602: -- Check whether the counry profile value is GB
603: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'NONE') <> 'GB' THEN

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602: -- Check whether the counry profile value is GB
603: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'NONE') <> 'GB' THEN
604: FND_MESSAGE.SET_NAME ('IGS','IGS_UC_HE_NOT_ENABLED');
605: FND_MSG_PUB.ADD;
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: l_validation_failed := TRUE;
608: END IF;
609:
610: -- If no validation failed then validate parameters

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

621: l_person_id := igs_ge_gen_003.get_person_id(p_person_number => p_hesa_spa_stats_rec.person_number);
622: IF l_person_id IS NULL THEN
623: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_PERSON_NUMBER');
624: FND_MSG_PUB.ADD;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: l_validation_failed := TRUE;
627: END IF;
628:
629: -- Check whether person ID found then only version number can be derived

Line 637: x_return_status := FND_API.G_RET_STS_ERROR;

633: p_program_cd => p_hesa_spa_stats_rec.program_cd);
634: IF l_version_number IS NULL THEN
635: FND_MESSAGE.SET_NAME ('IGS','IGS_HE_EXT_SPA_DTL_NOT_FOUND');
636: FND_MSG_PUB.ADD;
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: l_validation_failed := TRUE;
639: END IF;
640: END IF;
641: END IF; -- end, derivations

Line 652: x_return_status := FND_API.G_RET_STS_ERROR;

648: IF l_db_val_status = 'W' THEN
649: x_return_status := 'W';
650: l_validation_failed := TRUE;
651: ELSIF l_db_val_status = 'E' THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: l_validation_failed := TRUE;
654: END IF;
655: END IF; -- end, validate database constraints
656:

Line 660: x_return_status := FND_API.G_RET_STS_ERROR;

656:
657: -- If no validation failed then validate the business rules for Hesa program statistics
658: IF NOT l_validation_failed THEN
659: IF NOT validate_hesa_spa(p_hesa_spa_stats_rec => p_hesa_spa_stats_rec) THEN
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: l_validation_failed := TRUE;
662: END IF;
663: END IF;
664:

Line 809: x_return_status := FND_API.G_RET_STS_SUCCESS;

805: p_hesa_spa_stats_rec.disadv_uplift_factor,
806: p_hesa_spa_stats_rec.enh_fund_elig_cd,
807: 'N');
808: -- Set the return status to success.
809: x_return_status := FND_API.G_RET_STS_SUCCESS;
810:
811: ELSE
812: ROLLBACK TO create_hesa_spa_pub;
813: END IF;

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

812: ROLLBACK TO create_hesa_spa_pub;
813: END IF;
814:
815: -- If no validation failed and p_commit is passed as 'Y' then commit the changes.
816: IF NOT l_validation_failed AND FND_API.TO_BOOLEAN(p_commit) THEN
817: COMMIT;
818: END IF;
819:
820: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

Line 826: WHEN FND_API.G_EXC_ERROR THEN

822:
823: RETURN;
824:
825: EXCEPTION
826: WHEN FND_API.G_EXC_ERROR THEN
827: ROLLBACK TO create_hesa_spa_pub;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
830: p_data => x_msg_data);

Line 828: x_return_status := FND_API.G_RET_STS_ERROR;

824:
825: EXCEPTION
826: WHEN FND_API.G_EXC_ERROR THEN
827: ROLLBACK TO create_hesa_spa_pub;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
830: p_data => x_msg_data);
831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832: ROLLBACK TO create_hesa_spa_pub;

Line 831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

827: ROLLBACK TO create_hesa_spa_pub;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
830: p_data => x_msg_data);
831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832: ROLLBACK TO create_hesa_spa_pub;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
835: p_data => x_msg_data);

Line 833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

829: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
830: p_data => x_msg_data);
831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832: ROLLBACK TO create_hesa_spa_pub;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
835: p_data => x_msg_data);
836: WHEN OTHERS THEN
837: ROLLBACK TO create_hesa_spa_pub;

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

834: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
835: p_data => x_msg_data);
836: WHEN OTHERS THEN
837: ROLLBACK TO create_hesa_spa_pub;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839:
840: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
841: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
842: l_api_name);