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_AS_SUARC_LGCY_PUB dependencies on FND_MESSAGE

Line 37: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');

33: l_grade_msg FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
34: BEGIN
35: -- Person Number is Mandatory
36: IF p_suarc_dtls_rec.person_number IS NULL THEN
37: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');
38: FND_MSG_PUB.Add;
39: g_suarc_status := 'INVALID';
40: END IF;
41: -- Program Code is Mandatory

Line 43: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');

39: g_suarc_status := 'INVALID';
40: END IF;
41: -- Program Code is Mandatory
42: IF p_suarc_dtls_rec.program_cd IS NULL THEN
43: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');
44: FND_MSG_PUB.Add;
45: g_suarc_status := 'INVALID';
46: END IF;
47: -- Unit Code is Mandatory

Line 49: FND_MESSAGE.SET_NAME('IGS','IGS_EN_UNITCD_SPECIFIED');

45: g_suarc_status := 'INVALID';
46: END IF;
47: -- Unit Code is Mandatory
48: IF p_suarc_dtls_rec.unit_cd IS NULL THEN
49: FND_MESSAGE.SET_NAME('IGS','IGS_EN_UNITCD_SPECIFIED');
50: FND_MSG_PUB.Add;
51: g_suarc_status := 'INVALID';
52: END IF;
53: -- Calendar Alternate Code is Mandatory

Line 55: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CAL_TYP_NULL');

51: g_suarc_status := 'INVALID';
52: END IF;
53: -- Calendar Alternate Code is Mandatory
54: IF p_suarc_dtls_rec.teach_cal_alt_code IS NULL THEN
55: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CAL_TYP_NULL');
56: FND_MSG_PUB.Add;
57: g_suarc_status := 'INVALID';
58: END IF;
59: -- Location Code is Mandatory

Line 61: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LOC_CD_NULL');

57: g_suarc_status := 'INVALID';
58: END IF;
59: -- Location Code is Mandatory
60: IF p_suarc_dtls_rec.location_cd IS NULL THEN
61: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LOC_CD_NULL');
62: FND_MSG_PUB.Add;
63: g_suarc_status := 'INVALID';
64: END IF;
65: -- Unit Class is Mandatory

Line 67: FND_MESSAGE.SET_NAME('IGS','IGS_EN_UNT_CLS_NULL');

63: g_suarc_status := 'INVALID';
64: END IF;
65: -- Unit Class is Mandatory
66: IF p_suarc_dtls_rec.unit_class IS NULL THEN
67: FND_MESSAGE.SET_NAME('IGS','IGS_EN_UNT_CLS_NULL');
68: FND_MSG_PUB.Add;
69: g_suarc_status := 'INVALID';
70: END IF;
71: -- Reference Code Type is Mandatory

Line 73: FND_MESSAGE.SET_NAME('IGS','IGS_AS_REFERENCE_CD_NULL');

69: g_suarc_status := 'INVALID';
70: END IF;
71: -- Reference Code Type is Mandatory
72: IF p_suarc_dtls_rec.reference_cd_type IS NULL THEN
73: FND_MESSAGE.SET_NAME('IGS','IGS_AS_REFERENCE_CD_NULL');
74: FND_MSG_PUB.Add;
75: g_suarc_status := 'INVALID';
76: END IF;
77: -- Reference Code is Mandatory

Line 79: FND_MESSAGE.SET_NAME('IGS','IGS_AS_REFERENCE_CD_NULL');

75: g_suarc_status := 'INVALID';
76: END IF;
77: -- Reference Code is Mandatory
78: IF p_suarc_dtls_rec.reference_cd IS NULL THEN
79: FND_MESSAGE.SET_NAME('IGS','IGS_AS_REFERENCE_CD_NULL');
80: FND_MSG_PUB.Add;
81: g_suarc_status := 'INVALID';
82: END IF;
83: -- Applied Program Code is Mandatory

Line 85: FND_MESSAGE.SET_NAME('IGS','IGS_AS_APPLIED_PROGRAM_CD_NULL');

81: g_suarc_status := 'INVALID';
82: END IF;
83: -- Applied Program Code is Mandatory
84: IF p_suarc_dtls_rec.applied_program_cd IS NULL THEN
85: FND_MESSAGE.SET_NAME('IGS','IGS_AS_APPLIED_PROGRAM_CD_NULL');
86: FND_MSG_PUB.Add;
87: g_suarc_status := 'INVALID';
88: END IF;
89: -- If Program Code is specified , it should be in Upper Case.

Line 100: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_PRGM_CD_UCASE');

96: WHEN OTHERS THEN
97: FND_MSG_PUB.COUNT_AND_GET ( p_count => l_msg_count ,
98: p_data => l_msg_data);
99: FND_MSG_PUB.DELETE_MSG(l_msg_count);
100: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_PRGM_CD_UCASE');
101: FND_MSG_PUB.ADD;
102: g_suarc_status := 'INVALID';
103: END;
104: END IF;

Line 116: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_PRGM_CD_UCASE');

112: WHEN OTHERS THEN
113: FND_MSG_PUB.COUNT_AND_GET ( p_count => l_msg_count ,
114: p_data => l_msg_data);
115: FND_MSG_PUB.DELETE_MSG(l_msg_count);
116: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_PRGM_CD_UCASE');
117: FND_MSG_PUB.ADD;
118: g_suarc_status := 'INVALID';
119: END;
120: END IF;

Line 132: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_UNT_CD_UCASE');

128: WHEN OTHERS THEN
129: FND_MSG_PUB.COUNT_AND_GET ( p_count => l_msg_count ,
130: p_data => l_msg_data);
131: FND_MSG_PUB.DELETE_MSG(l_msg_count);
132: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_UNT_CD_UCASE');
133: FND_MSG_PUB.ADD;
134: g_suarc_status := 'INVALID';
135: END;
136: END IF;

Line 148: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_LOC_CD_UCASE');

144: WHEN OTHERS THEN
145: FND_MSG_PUB.COUNT_AND_GET ( p_count => l_msg_count ,
146: p_data => l_msg_data);
147: FND_MSG_PUB.DELETE_MSG(l_msg_count);
148: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_LOC_CD_UCASE');
149: FND_MSG_PUB.ADD;
150: g_suarc_status := 'INVALID';
151: END;
152: END IF;

Line 164: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_UNT_CLS_UCASE');

160: WHEN OTHERS THEN
161: FND_MSG_PUB.COUNT_AND_GET ( p_count => l_msg_count ,
162: p_data => l_msg_data);
163: FND_MSG_PUB.DELETE_MSG(l_msg_count);
164: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_UNT_CLS_UCASE');
165: FND_MSG_PUB.ADD;
166: g_suarc_status := 'INVALID';
167: END;
168: END IF;

Line 227: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_AS_UK_CHK_REF_CD' );

223: X_REFERENCE_CODE_ID => l_number,
224: X_APPLIED_COURSE_CD => p_suarc_dtls_rec.applied_program_cd,
225: X_DELETED_DATE => TO_DATE(null)
226: ) THEN
227: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_AS_UK_CHK_REF_CD' );
228: FND_MSG_PUB.ADD;
229: g_suarc_status := 'INVALID';
230: END IF;
231:

Line 234: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_LOC_CD_INV' );

230: END IF;
231:
232: -- Foreign Key Validation - Check if Location Code exists.
233: IF NOT igs_ad_location_pkg.get_pk_for_validation ( x_location_cd => p_suarc_dtls_rec.location_cd) THEN
234: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_LOC_CD_INV' );
235: FND_MSG_PUB.ADD;
236: g_suarc_status := 'INVALID';
237: END IF;
238:

Line 244: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_FI_PRSNID_PRGCD_NOT_MATCH');

240: IF NOT igs_en_su_attempt_pkg.get_pk_for_validation (
241: x_person_id => p_person_id,
242: x_course_cd => p_suarc_dtls_rec.program_cd,
243: x_uoo_id => p_uoo_id) THEN
244: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_FI_PRSNID_PRGCD_NOT_MATCH');
245: FND_MSG_PUB.ADD;
246: g_suarc_status := 'INVALID';
247: END IF ;
248:

Line 253: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_FI_PRSNID_PRGCD_NOT_MATCH');

249: -- Foreign Key Validation - Check if Student Program Attempt exists.
250: IF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation (
251: x_person_id => p_person_id,
252: x_course_cd => p_suarc_dtls_rec.program_cd) THEN
253: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_FI_PRSNID_PRGCD_NOT_MATCH');
254: FND_MSG_PUB.ADD;
255: g_suarc_status := 'INVALID';
256: END IF ;
257:

Line 262: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_AS_NO_PROGRAM_ATTEMPT');

258: -- Foreign Key Validation - Check if Student (Applied )Program Attempt exists.
259: IF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation (
260: x_person_id => p_person_id,
261: x_course_cd => p_suarc_dtls_rec.applied_program_cd)THEN
262: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_AS_NO_PROGRAM_ATTEMPT');
263: FND_MSG_PUB.ADD;
264: g_suarc_status := 'INVALID';
265: END IF ;
266:

Line 269: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_IN_INVALID_UNIT_CODE');

265: END IF ;
266:
267: -- Foreign Key Validation - Check if Unit Code exists.
268: IF NOT igs_ps_unit_pkg.get_pk_for_validation ( x_unit_cd => p_suarc_dtls_rec.unit_cd)THEN
269: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_IN_INVALID_UNIT_CODE');
270: FND_MSG_PUB.ADD;
271: g_suarc_status := 'INVALID';
272: END IF;
273:

Line 278: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_PS_UNITCODE_UNITVER_NE');

274: -- Foreign Key Validation - Check if Unit Code / Version exists.
275: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (
276: x_unit_cd => p_suarc_dtls_rec.unit_cd,
277: x_version_number => NVL ( p_suarc_dtls_rec.version_number,p_unit_version_number)) THEN
278: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_PS_UNITCODE_UNITVER_NE');
279: FND_MSG_PUB.ADD;
280: g_suarc_status := 'INVALID';
281: END IF;
282: END validate_db_cons;

Line 373: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_GE_INVALID_PERSON_NUMBER');

369: IF g_suarc_status <> 'INVALID' THEN
370: -- Derive Person ID
371: l_person_id := igs_ge_gen_003.get_person_id ( p_person_number => p_suarc_dtls_rec.person_number) ;
372: IF l_person_id IS NULL THEN
373: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_GE_INVALID_PERSON_NUMBER');
374: FND_MSG_PUB.ADD;
375: g_suarc_status := 'INVALID';
376: END IF;
377: -- Derive Calendar Details.

Line 387: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_ALT_CD_NO_CAL_FND');

383: p_start_dt => l_ci_start_dt ,
384: p_end_dt => l_ci_end_dt ,
385: p_return_status => l_return_status );
386: IF l_return_status = 'INVALID' THEN
387: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_ALT_CD_NO_CAL_FND');
388: FND_MSG_PUB.ADD;
389: g_suarc_status := 'INVALID';
390: ELSIF l_return_status = 'MULTIPLE' THEN
391: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_MULTI_TCH_CAL_FND');

Line 391: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_MULTI_TCH_CAL_FND');

387: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_ALT_CD_NO_CAL_FND');
388: FND_MSG_PUB.ADD;
389: g_suarc_status := 'INVALID';
390: ELSIF l_return_status = 'MULTIPLE' THEN
391: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_MULTI_TCH_CAL_FND');
392: FND_MSG_PUB.ADD;
393: g_suarc_status := 'INVALID';
394: END IF ;
395: -- Derive Unit version if parameter is NULL.

Line 424: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_SUA_STS_NT_ALLOWED');

420: -- swaghmar 4327987 - To check for the status of the SUA
421: OPEN cur_sua_status;
422: FETCH cur_sua_status INTO l_sua_status;
423: IF l_sua_status IN ('WAITLISTED','UNCONFIRM') THEN
424: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_SUA_STS_NT_ALLOWED');
425: FND_MSG_PUB.ADD;
426: g_suarc_status := 'INVALID';
427: END IF;
428: CLOSE cur_sua_status;

Line 438: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_REFERENCE_CD_NT_EXIST');

434: --- check if reference code exists
435: OPEN cur_check_ref_cd;
436: FETCH cur_check_ref_cd INTO l_exists;
437: IF cur_check_ref_cd%NOTFOUND THEN
438: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_REFERENCE_CD_NT_EXIST');
439: FND_MSG_PUB.ADD;
440: g_suarc_status := 'INVALID';
441: END IF;
442: CLOSE cur_check_ref_cd;

Line 447: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_REFERENCE_CODE_NOT_SET');

443: -- check if reference code can be used for the unit set
444: OPEN cur_check_ref_cd_section_abv;
445: FETCH cur_check_ref_cd_section_abv INTO l_exists;
446: IF cur_check_ref_cd_section_abv%NOTFOUND THEN
447: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_REFERENCE_CODE_NOT_SET');
448: FND_MSG_PUB.ADD;
449: g_suarc_status := 'INVALID';
450: END IF;
451: CLOSE cur_check_ref_cd_section_abv;