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

Line 36: FND_MSG_PUB.ADD;

32:
33: -- Make sure the program code is in uppercase. If not throw Error
34: IF p_intm_rcond_rec.program_cd <> UPPER(p_intm_rcond_rec.program_cd) THEN
35: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRGM_CD_UCASE');
36: FND_MSG_PUB.ADD;
37: l_ret_val := 'E';
38: END IF;
39:
40: -- Ensure return condition is in uppercase. Otherwise throw Error

Line 43: FND_MSG_PUB.ADD;

39:
40: -- Ensure return condition is in uppercase. Otherwise throw Error
41: IF p_intm_rcond_rec.return_condition <> UPPER(p_intm_rcond_rec.return_condition) THEN
42: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_INTM_RCOND_UCASE');
43: FND_MSG_PUB.ADD;
44: l_ret_val := 'E';
45: END IF;
46:
47:

Line 88: FND_MSG_PUB.ADD;

84: -- Ensure the return condition is valid by checking the intermission
85: -- conditions. If not throw Error
86: IF NOT igs_en_intm_rconds_pkg.get_pk_for_validation(x_return_condition => p_intm_rcond_rec.return_condition) THEN
87: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_SPI_INV_RCOND');
88: FND_MSG_PUB.ADD;
89: l_ret_val := 'E';
90: END IF;
91:
92: -- Check whether the student intermission return condition already exists

Line 100: FND_MSG_PUB.ADD;

96: x_start_dt => p_intm_rcond_rec.start_dt,
97: x_logical_delete_date => to_date('31-12-4712','DD-MM-YYYY'),
98: x_return_condition => p_intm_rcond_rec.return_condition) THEN
99: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_STU_INTM_RCOND_EXISTS');
100: FND_MSG_PUB.ADD;
101: l_ret_val := 'W';
102: END IF;
103:
104: -- Ensure the return condition status is valid.

Line 110: FND_MSG_PUB.ADD;

106: OPEN chk_rcond_status;
107: FETCH chk_rcond_status INTO l_dummy;
108: IF chk_rcond_status%NOTFOUND THEN
109: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_RCOND_INV_STS');
110: FND_MSG_PUB.ADD;
111: l_ret_val := 'E';
112: END IF;
113: CLOSE chk_rcond_status;
114:

Line 123: FND_MSG_PUB.ADD;

119: CLOSE chk_intermission;
120:
121: IF l_dummy IS NULL THEN
122: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_STU_INTM_NOT_EXISTS');
123: FND_MSG_PUB.ADD;
124: l_ret_val := 'E';
125: ELSIF l_dummy = 'N' THEN
126: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NOT_VLD_RCOND');
127: FND_MSG_PUB.ADD;

Line 127: FND_MSG_PUB.ADD;

123: FND_MSG_PUB.ADD;
124: l_ret_val := 'E';
125: ELSIF l_dummy = 'N' THEN
126: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NOT_VLD_RCOND');
127: FND_MSG_PUB.ADD;
128: l_ret_val := 'E';
129: END IF;
130:
131: RETURN l_ret_val;

Line 202: FND_MSG_PUB.INITIALIZE;

198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: -- If parameter p_init_msg_list is passed as TRUE, then initialize the message list
201: IF FND_API.TO_BOOLEAN (p_init_msg_list) THEN
202: FND_MSG_PUB.INITIALIZE;
203: END IF;
204:
205:
206: -- Ensure Person Number is valid. Otherwise throw Error

Line 211: FND_MSG_PUB.ADD;

207: l_person_id := NULL;
208: l_person_id := Igs_Ge_Gen_003.get_person_id(p_intm_rcond_rec.person_number);
209: IF l_person_id IS NULL THEN
210: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
211: FND_MSG_PUB.ADD;
212: l_insert_flag := FALSE;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: END IF;
215:

Line 223: FND_MSG_PUB.ADD;

219: l_approver_id := NULL;
220: l_approver_id := Igs_Ge_Gen_003.get_person_id(p_intm_rcond_rec.approver_number);
221: IF l_approver_id IS NULL THEN
222: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NO_APPROV_PERSON');
223: FND_MSG_PUB.ADD;
224: l_insert_flag := FALSE;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: END IF;
227:

Line 336: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

332: IF (FND_API.TO_BOOLEAN(p_commit) AND l_insert_flag ) THEN
333: COMMIT WORK;
334: END IF;
335:
336: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
337: p_data => x_msg_data);
338:
339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN

Line 343: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

339: EXCEPTION
340: WHEN FND_API.G_EXC_ERROR THEN
341: ROLLBACK TO create_en_spi_rcond_pub;
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
344: p_data => x_msg_data);
345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO create_en_spi_rcond_pub;

Line 349: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

345:
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: ROLLBACK TO create_en_spi_rcond_pub;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
350: p_data => x_msg_data);
351:
352: WHEN OTHERS THEN
353: ROLLBACK TO create_en_spi_rcond_pub;

Line 355: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

351:
352: WHEN OTHERS THEN
353: ROLLBACK TO create_en_spi_rcond_pub;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
356: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
357: l_api_name);
358: END IF;
359: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

Line 356: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,

352: WHEN OTHERS THEN
353: ROLLBACK TO create_en_spi_rcond_pub;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
356: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
357: l_api_name);
358: END IF;
359: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
360: p_data => x_msg_data);

Line 359: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

355: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
356: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
357: l_api_name);
358: END IF;
359: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
360: p_data => x_msg_data);
361:
362: END create_student_intm_rcond;
363: