DBA Data[Home] [Help]

APPS.IGS_EN_SPI_RCOND_LGCY_PUB dependencies on FND_MESSAGE

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

31: l_ret_val := 'S';
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:

Line 42: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_INTM_RCOND_UCASE');

38: END IF;
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:

Line 87: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_SPI_INV_RCOND');

83:
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:

Line 99: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_STU_INTM_RCOND_EXISTS');

95: x_course_cd => p_intm_rcond_rec.program_cd,
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:

Line 109: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_RCOND_INV_STS');

105: -- Use lookup Type IGS_EN_INTM_RCOND_STS to determine the valid statuses
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;

Line 122: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_STU_INTM_NOT_EXISTS');

118: FETCH chk_intermission INTO l_dummy;
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');

Line 126: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NOT_VLD_RCOND');

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;
128: l_ret_val := 'E';
129: END IF;
130:

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

206: -- Ensure Person Number is valid. Otherwise throw Error
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;

Line 222: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_NO_APPROV_PERSON');

218: IF p_intm_rcond_rec.approver_number IS NOT NULL THEN
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;