APPS.IGS_HE_SPA_LGCY_PUB dependencies on IGS_HE_ST_SPA_ALL_PKG

Line 70: IF igs_he_st_spa_all_pkg.get_uk_for_validation(x_person_id => p_person_id,

66: l_db_val_failed BOOLEAN := FALSE;
67: BEGIN
68:
69: -- Check whether Hesa program statistics details already exists for the given program attempt
70: IF igs_he_st_spa_all_pkg.get_uk_for_validation(x_person_id => p_person_id,
71: x_course_cd => p_hesa_spa_stats_rec.program_cd) THEN
72: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SPA_STATS_EXIST');
73: FND_MSG_PUB.ADD;
74: RETURN 'W';

Line 416: igs_he_st_spa_all_pkg.check_constraints (column_name => 'ASSOCIATE_UCAS_NUMBER',

412: --
413: -- Check whether the Associate UCAS Number has valid value
414: IF p_hesa_spa_stats_rec.associate_ucas_number IS NOT NULL THEN
415: BEGIN
416: igs_he_st_spa_all_pkg.check_constraints (column_name => 'ASSOCIATE_UCAS_NUMBER',
417: column_value => p_hesa_spa_stats_rec.associate_ucas_number);
418:
419: EXCEPTION
420: WHEN OTHERS THEN

Line 432: igs_he_st_spa_all_pkg.check_constraints (column_name => 'ASSOCIATE_SCOTT_CAND',

428: END IF;
429: -- Check whether the Associate Scottish Candidate has valid value
430: IF p_hesa_spa_stats_rec.associate_scott_cand IS NOT NULL THEN
431: BEGIN
432: igs_he_st_spa_all_pkg.check_constraints (column_name => 'ASSOCIATE_SCOTT_CAND',
433: column_value => p_hesa_spa_stats_rec.associate_scott_cand);
434: EXCEPTION
435: WHEN OTHERS THEN
436: FND_MSG_PUB.COUNT_AND_GET ( p_count => l_msg_count ,

Line 447: igs_he_st_spa_all_pkg.check_constraints (column_name => 'ASSOCIATE_TEACH_REF_NUM',

443: END IF;
444: -- Check whether the Associate Teaching Reference Number has valid value
445: IF p_hesa_spa_stats_rec.associate_teach_ref_num IS NOT NULL THEN
446: BEGIN
447: igs_he_st_spa_all_pkg.check_constraints (column_name => 'ASSOCIATE_TEACH_REF_NUM',
448: column_value => p_hesa_spa_stats_rec.associate_teach_ref_num);
449: EXCEPTION
450: WHEN OTHERS THEN
451: FND_MSG_PUB.COUNT_AND_GET ( p_count => l_msg_count ,

Line 462: igs_he_st_spa_all_pkg.check_constraints (column_name => 'ASSOCIATE_NHS_REG_NUM',

458: END IF;
459: -- Check whether the Associate NHS Registration Number has valid value
460: IF p_hesa_spa_stats_rec.associate_nhs_reg_num IS NOT NULL THEN
461: BEGIN
462: igs_he_st_spa_all_pkg.check_constraints (column_name => 'ASSOCIATE_NHS_REG_NUM',
463: column_value => p_hesa_spa_stats_rec.associate_nhs_reg_num);
464: EXCEPTION
465: WHEN OTHERS THEN
466: FND_MSG_PUB.COUNT_AND_GET ( p_count => l_msg_count ,