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_RE_THE_LGCY_PUB dependencies on FND_MSG_PUB

Line 36: FND_MSG_PUB.ADD;

32: p_the_status := 'VALID';
33: -- Check for value exists for person number
34: IF p_the_dtls_rec.person_number IS NULL THEN
35: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');
36: FND_MSG_PUB.ADD;
37: p_the_status := 'INVALID';
38: END IF;
39:
40: -- Check for value exists for Program Code

Line 43: FND_MSG_PUB.ADD;

39:
40: -- Check for value exists for Program Code
41: IF p_the_dtls_rec.program_cd IS NULL THEN
42: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');
43: FND_MSG_PUB.ADD;
44: p_the_status := 'INVALID';
45: END IF;
46:
47: -- Check for value exists for title

Line 50: FND_MSG_PUB.ADD;

46:
47: -- Check for value exists for title
48: IF p_the_dtls_rec.title IS NULL THEN
49: FND_MESSAGE.SET_NAME('IGS','IGS_RE_THE_TITLE_NUL');
50: FND_MSG_PUB.ADD;
51: p_the_status := 'INVALID';
52: END IF;
53:
54: --check constraint for final_title_ind, it should be 'Y' or 'N'

Line 60: l_msg_count := FND_MSG_PUB.COUNT_MSG;

56: BEGIN
57: igs_re_thesis_pkg.check_constraints('final_title_ind',p_the_dtls_rec.final_title_ind);
58: EXCEPTION
59: WHEN OTHERS THEN
60: l_msg_count := FND_MSG_PUB.COUNT_MSG;
61: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
62: FND_MESSAGE.SET_NAME('IGS','IGS_RE_FNL_TITLE_INV');
63: FND_MSG_PUB.ADD;
64: p_the_status := 'INVALID';

Line 61: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

57: igs_re_thesis_pkg.check_constraints('final_title_ind',p_the_dtls_rec.final_title_ind);
58: EXCEPTION
59: WHEN OTHERS THEN
60: l_msg_count := FND_MSG_PUB.COUNT_MSG;
61: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
62: FND_MESSAGE.SET_NAME('IGS','IGS_RE_FNL_TITLE_INV');
63: FND_MSG_PUB.ADD;
64: p_the_status := 'INVALID';
65: END;

Line 63: FND_MSG_PUB.ADD;

59: WHEN OTHERS THEN
60: l_msg_count := FND_MSG_PUB.COUNT_MSG;
61: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
62: FND_MESSAGE.SET_NAME('IGS','IGS_RE_FNL_TITLE_INV');
63: FND_MSG_PUB.ADD;
64: p_the_status := 'INVALID';
65: END;
66: END IF;
67:

Line 74: l_msg_count := FND_MSG_PUB.COUNT_MSG;

70: BEGIN
71: igs_re_thesis_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.final_thesis_result_cd);
72: EXCEPTION
73: WHEN OTHERS THEN
74: l_msg_count := FND_MSG_PUB.COUNT_MSG;
75: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
76: FND_MESSAGE.SET_NAME('IGS','IGS_RE_RESULT_CD_INVALID_VAL');
77: FND_MSG_PUB.ADD;
78: p_the_status := 'INVALID';

Line 75: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

71: igs_re_thesis_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.final_thesis_result_cd);
72: EXCEPTION
73: WHEN OTHERS THEN
74: l_msg_count := FND_MSG_PUB.COUNT_MSG;
75: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
76: FND_MESSAGE.SET_NAME('IGS','IGS_RE_RESULT_CD_INVALID_VAL');
77: FND_MSG_PUB.ADD;
78: p_the_status := 'INVALID';
79: END;

Line 77: FND_MSG_PUB.ADD;

73: WHEN OTHERS THEN
74: l_msg_count := FND_MSG_PUB.COUNT_MSG;
75: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
76: FND_MESSAGE.SET_NAME('IGS','IGS_RE_RESULT_CD_INVALID_VAL');
77: FND_MSG_PUB.ADD;
78: p_the_status := 'INVALID';
79: END;
80: END IF;
81:

Line 88: l_msg_count := FND_MSG_PUB.COUNT_MSG;

84: BEGIN
85: igs_re_thesis_exam_pkg.check_constraints('thesis_exam_type',p_the_dtls_rec.thesis_exam_type);
86: EXCEPTION
87: WHEN OTHERS THEN
88: l_msg_count := FND_MSG_PUB.COUNT_MSG;
89: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
90: FND_MESSAGE.SET_NAME('IGS','IGS_RE_EXAM_TYP_INVALID_VAL');
91: FND_MSG_PUB.ADD;
92: p_the_status := 'INVALID';

Line 89: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

85: igs_re_thesis_exam_pkg.check_constraints('thesis_exam_type',p_the_dtls_rec.thesis_exam_type);
86: EXCEPTION
87: WHEN OTHERS THEN
88: l_msg_count := FND_MSG_PUB.COUNT_MSG;
89: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
90: FND_MESSAGE.SET_NAME('IGS','IGS_RE_EXAM_TYP_INVALID_VAL');
91: FND_MSG_PUB.ADD;
92: p_the_status := 'INVALID';
93: END;

Line 91: FND_MSG_PUB.ADD;

87: WHEN OTHERS THEN
88: l_msg_count := FND_MSG_PUB.COUNT_MSG;
89: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
90: FND_MESSAGE.SET_NAME('IGS','IGS_RE_EXAM_TYP_INVALID_VAL');
91: FND_MSG_PUB.ADD;
92: p_the_status := 'INVALID';
93: END;
94: END IF;
95:

Line 102: l_msg_count := FND_MSG_PUB.COUNT_MSG;

98: BEGIN
99: igs_re_thesis_exam_pkg.check_constraints('thesis_panel_type',p_the_dtls_rec.thesis_panel_type);
100: EXCEPTION
101: WHEN OTHERS THEN
102: l_msg_count := FND_MSG_PUB.COUNT_MSG;
103: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
104: FND_MESSAGE.SET_NAME('IGS','IGS_RE_PNL_TYP_INVALID_VAL');
105: FND_MSG_PUB.ADD;
106: p_the_status := 'INVALID';

Line 103: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

99: igs_re_thesis_exam_pkg.check_constraints('thesis_panel_type',p_the_dtls_rec.thesis_panel_type);
100: EXCEPTION
101: WHEN OTHERS THEN
102: l_msg_count := FND_MSG_PUB.COUNT_MSG;
103: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
104: FND_MESSAGE.SET_NAME('IGS','IGS_RE_PNL_TYP_INVALID_VAL');
105: FND_MSG_PUB.ADD;
106: p_the_status := 'INVALID';
107: END;

Line 105: FND_MSG_PUB.ADD;

101: WHEN OTHERS THEN
102: l_msg_count := FND_MSG_PUB.COUNT_MSG;
103: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
104: FND_MESSAGE.SET_NAME('IGS','IGS_RE_PNL_TYP_INVALID_VAL');
105: FND_MSG_PUB.ADD;
106: p_the_status := 'INVALID';
107: END;
108: END IF;
109:

Line 116: l_msg_count := FND_MSG_PUB.COUNT_MSG;

112: BEGIN
113: igs_re_thesis_exam_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.thesis_result_cd);
114: EXCEPTION
115: WHEN OTHERS THEN
116: l_msg_count := FND_MSG_PUB.COUNT_MSG;
117: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
118: FND_MESSAGE.SET_NAME('IGS','IGS_RE_RESULT_CD_INVALID_VAL');
119: FND_MSG_PUB.ADD;
120: p_the_status := 'INVALID';

Line 117: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

113: igs_re_thesis_exam_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.thesis_result_cd);
114: EXCEPTION
115: WHEN OTHERS THEN
116: l_msg_count := FND_MSG_PUB.COUNT_MSG;
117: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
118: FND_MESSAGE.SET_NAME('IGS','IGS_RE_RESULT_CD_INVALID_VAL');
119: FND_MSG_PUB.ADD;
120: p_the_status := 'INVALID';
121: END;

Line 119: FND_MSG_PUB.ADD;

115: WHEN OTHERS THEN
116: l_msg_count := FND_MSG_PUB.COUNT_MSG;
117: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);
118: FND_MESSAGE.SET_NAME('IGS','IGS_RE_RESULT_CD_INVALID_VAL');
119: FND_MSG_PUB.ADD;
120: p_the_status := 'INVALID';
121: END;
122: END IF;
123:

Line 150: FND_MSG_PUB.ADD;

146: p_person_id ,
147: p_the_dtls_rec.title,
148: p_ca_sequence_number) THEN
149: FND_MESSAGE.SET_NAME('IGS','IGS_RE_THE_DUPLIDATE');
150: FND_MSG_PUB.ADD;
151: RETURN 'W';
152: END IF;
153:
154: -- FK check in the Thesis Result table

Line 159: FND_MSG_PUB.ADD;

155: IF p_the_dtls_rec.final_thesis_result_cd IS NOT NULL THEN
156: IF NOT IGS_RE_THESIS_RESULT_PKG.Get_PK_For_Validation (
157: p_the_dtls_rec.final_thesis_result_cd ) THEN
158: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_RESULT_CD_INVALID_VAL');
159: FND_MSG_PUB.ADD;
160: l_ret_status := 'E';
161: END IF;
162: END IF;
163: RETURN l_ret_status;

Line 243: FND_MSG_PUB.ADD;

239: l_thesis_status,
240: l_message);
241: IF l_message IS NOT NULL THEN
242: FND_MESSAGE.SET_NAME('IGS','IGS_RE_CANT_SUBMIT_THESIS');
243: FND_MSG_PUB.ADD;
244: p_the_status := 'INVALID';
245: END IF;
246:
247: l_message := NULL;

Line 265: FND_MSG_PUB.ADD;

261: -- If Thesis result code is not available and the thesis status is EXAMINED then log error message.
262: IF p_the_dtls_rec.thesis_result_cd IS NULL AND
263: l_thesis_status = 'EXAMINED' THEN
264: FND_MESSAGE.SET_NAME('IGS','IGS_RE_CHK_RES_OUTSTAND_EXAM');
265: FND_MSG_PUB.ADD;
266: p_the_status := 'INVALID';
267: END IF;
268:
269: -- If thesis status is PENDING.

Line 280: FND_MSG_PUB.ADD;

276: p_the_dtls_rec.citation,
277: l_message);
278: IF l_message IS NOT NULL THEN
279: FND_MESSAGE.SET_NAME('IGS','IGS_RE_CANT_ENTER_GRAD_CITAT');
280: FND_MSG_PUB.ADD;
281: p_the_status := 'INVALID';
282: END IF;
283:
284:

Line 298: FND_MSG_PUB.ADD;

294: l_thesis_status,
295: l_message);
296: IF l_message IS NOT NULL THEN
297: FND_MESSAGE.SET_NAME('IGS','IGS_RE_CANT_ENTER_LIBR_DETAIL');
298: FND_MSG_PUB.ADD;
299: p_the_status := 'INVALID';
300: END IF;
301:
302:

Line 316: FND_MSG_PUB.ADD;

312: 'Y',
313: l_message);
314: IF l_message IS NOT NULL THEN
315: FND_MESSAGE.SET_NAME('IGS','IGS_RE_CHK_RES_NOT_FINAL_RES');
316: FND_MSG_PUB.ADD;
317: p_the_status := 'INVALID';
318: END IF;
319: END IF;
320:

Line 351: FND_MSG_PUB.ADD;

347: IF p_the_dtls_rec.thesis_exam_type IS NOT NULL THEN
348: IF NOT igs_re_ths_exam_type_pkg.get_pk_for_validation (
349: p_the_dtls_rec.thesis_exam_type) THEN
350: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_THE_EXM_TYP_INV');
351: FND_MSG_PUB.ADD;
352: l_ret_status := 'E';
353: END IF;
354: END IF;
355:

Line 361: FND_MSG_PUB.ADD;

357: IF p_the_dtls_rec.thesis_result_cd IS NOT NULL THEN
358: IF NOT igs_re_thesis_result_pkg.get_pk_for_validation (
359: p_the_dtls_rec.thesis_result_cd ) THEN
360: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_THE_RES_CD_INV');
361: FND_MSG_PUB.ADD;
362: l_ret_status := 'E';
363: END IF;
364: END IF;
365:

Line 371: FND_MSG_PUB.ADD;

367: IF p_the_dtls_rec.thesis_panel_type IS NOT NULL THEN
368: IF NOT igs_re_ths_pnl_type_pkg.get_pk_for_validation (
369: p_the_dtls_rec.thesis_panel_type) THEN
370: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_THE_PNL_TYP_INV');
371: FND_MSG_PUB.ADD;
372: l_ret_status := 'E';
373: END IF;
374: END IF;
375: RETURN l_ret_status;

Line 413: FND_MSG_PUB.ADD;

409: p_the_dtls_rec.thesis_exam_type IS NOT NULL ) OR
410: ( p_the_dtls_rec.submission_dt IS NOT NULL AND
411: p_the_dtls_rec.thesis_exam_type IS NULL ) THEN
412: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INCOMP_THE_EXAM_DTLS');
413: FND_MSG_PUB.ADD;
414: p_exam_status := 'INVALID';
415: END IF;
416:
417: l_message := NULL;

Line 492: FND_MSG_PUB.INITIALIZE;

488: END IF;
489:
490: -- Initialize message list if p_init_msg_list is set to TRUE.
491: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
492: FND_MSG_PUB.INITIALIZE;
493: END IF;
494:
495: -- Initialize API return status to success
496: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 508: FND_MSG_PUB.ADD;

504: -- Calling the function to get the person_id
505: l_person_id := igs_ge_gen_003.get_person_id( p_the_dtls_rec.person_number);
506: IF l_person_id IS NULL THEN
507: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
508: FND_MSG_PUB.ADD;
509: l_the_exam_status := 'INVALID';
510: END IF;
511:
512: -- Calling the function to get the value for ca_sequence_number

Line 518: FND_MSG_PUB.ADD;

514: l_person_id,
515: p_the_dtls_rec.program_cd,
516: l_ca_sequence_number) THEN
517: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_CANT_LOCATE_CAND_DET');
518: FND_MSG_PUB.ADD;
519: l_the_exam_status := 'INVALID';
520: END IF;
521: END IF;
522:

Line 696: FND_MSG_PUB.Count_And_Get (

692: END IF;
693: END IF;
694:
695: -- Standard call to get message count and if count is 1, get message info.
696: FND_MSG_PUB.Count_And_Get (
697: p_count => x_msg_count,
698: p_data => x_msg_data );
699:
700: EXCEPTION

Line 704: FND_MSG_PUB.Count_And_Get (

700: EXCEPTION
701: WHEN FND_API.G_EXC_ERROR THEN
702: ROLLBACK TO THEDET_PUB;
703: x_return_status := FND_API.G_RET_STS_ERROR ;
704: FND_MSG_PUB.Count_And_Get (
705: p_count => x_msg_count,
706: p_data => x_msg_data );
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 711: FND_MSG_PUB.Count_And_Get (

707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO THEDET_PUB;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
711: FND_MSG_PUB.Count_And_Get (
712: p_count => x_msg_count,
713: p_data => x_msg_data );
714:
715: WHEN OTHERS THEN

Line 718: IF FND_MSG_PUB.Check_Msg_Level

714:
715: WHEN OTHERS THEN
716: ROLLBACK TO THEDET_PUB;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
718: IF FND_MSG_PUB.Check_Msg_Level
719: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg
722: (g_pkg_name,

Line 719: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

715: WHEN OTHERS THEN
716: ROLLBACK TO THEDET_PUB;
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
718: IF FND_MSG_PUB.Check_Msg_Level
719: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg
722: (g_pkg_name,
723: l_api_name );

Line 721: FND_MSG_PUB.Add_Exc_Msg

717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
718: IF FND_MSG_PUB.Check_Msg_Level
719: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
720: THEN
721: FND_MSG_PUB.Add_Exc_Msg
722: (g_pkg_name,
723: l_api_name );
724: END IF;
725: FND_MSG_PUB.Count_And_Get (

Line 725: FND_MSG_PUB.Count_And_Get (

721: FND_MSG_PUB.Add_Exc_Msg
722: (g_pkg_name,
723: l_api_name );
724: END IF;
725: FND_MSG_PUB.Count_And_Get (
726: p_count => x_msg_count,
727: p_data => x_msg_data );
728: END create_the;
729: