APPS.IGS_HE_SUSA_LGCY_PUB dependencies on IGS_PS_UNIT_LEVEL_PKG

Line 328: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved1) THEN

324: END IF;
325:
326: -- Check if the Credit Level Achieved 1 exists
327: IF p_hesa_susa_rec.credit_level_achieved1 IS NOT NULL THEN
328: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved1) THEN
329: -- ADD excep to stack
330: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CR_LEVEL_ACHD1_NEX');
331: FND_MSG_PUB.ADD;
332: l_ret_value := 'E';

Line 338: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved2) THEN

334: END IF;
335:
336: -- Check if the Credit Level Achieved 2 exists
337: IF p_hesa_susa_rec.credit_level_achieved2 IS NOT NULL THEN
338: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved2) THEN
339: -- ADD excep to stack
340: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CR_LEVEL_ACHD2_NEX');
341: FND_MSG_PUB.ADD;
342: l_ret_value := 'E';

Line 348: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved3) THEN

344: END IF;
345:
346: -- Check if the Credit Level Achieved 3 exists
347: IF p_hesa_susa_rec.credit_level_achieved3 IS NOT NULL THEN
348: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved3) THEN
349: -- ADD excep to stack
350: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CR_LEVEL_ACHD3_NEX');
351: FND_MSG_PUB.ADD;
352: l_ret_value := 'E';

Line 358: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved4) THEN

354: END IF;
355:
356: -- Check if the Credit Level Achieved 4 exists
357: IF p_hesa_susa_rec.credit_level_achieved4 IS NOT NULL THEN
358: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level_achieved4) THEN
359: -- ADD excep to stack
360: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CR_LEVEL_ACHD4_NEX');
361: FND_MSG_PUB.ADD;
362: l_ret_value := 'E';

Line 368: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level1) THEN

364: END IF;
365:
366: -- Check if the Credit Level 1 exists
367: IF p_hesa_susa_rec.credit_level1 IS NOT NULL THEN
368: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level1) THEN
369: -- ADD excep to stack
370: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CREDIT_LEVEL1_NEX');
371: FND_MSG_PUB.ADD;
372: l_ret_value := 'E';

Line 378: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level2) THEN

374: END IF;
375:
376: -- Check if the Credit Level 2 exists
377: IF p_hesa_susa_rec.credit_level2 IS NOT NULL THEN
378: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level2) THEN
379: -- ADD excep to stack
380: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CREDIT_LEVEL2_NEX');
381: FND_MSG_PUB.ADD;
382: l_ret_value := 'E';

Line 388: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level3) THEN

384: END IF;
385:
386: -- Check if the Credit Level 3 exists
387: IF p_hesa_susa_rec.credit_level3 IS NOT NULL THEN
388: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level3) THEN
389: -- ADD excep to stack
390: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CREDIT_LEVEL3_NEX');
391: FND_MSG_PUB.ADD;
392: l_ret_value := 'E';

Line 398: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level4) THEN

394: END IF;
395:
396: -- Check if the Credit Level 4 exists
397: IF p_hesa_susa_rec.credit_level4 IS NOT NULL THEN
398: IF NOT igs_ps_unit_level_pkg.get_pk_for_validation (x_unit_level => p_hesa_susa_rec.credit_level4) THEN
399: -- ADD excep to stack
400: FND_MESSAGE.SET_NAME('IGS','IGS_HE_CREDIT_LEVEL4_NEX');
401: FND_MSG_PUB.ADD;
402: l_ret_value := 'E';