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

Line 25: FND_MSG_PUB.ADD;

21: BEGIN
22: -- Check if person_number value is null then log error message
23: IF p_awd_aim_rec.person_number IS NULL THEN
24: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PER_NUM_NULL');
25: FND_MSG_PUB.ADD;
26: l_val_param := 'INVALID';
27: END IF;
28:
29: -- Check if program_cd value is null then log error message

Line 32: FND_MSG_PUB.ADD;

28:
29: -- Check if program_cd value is null then log error message
30: IF p_awd_aim_rec.program_cd IS NULL THEN
31: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PRGM_CD_NULL');
32: FND_MSG_PUB.ADD;
33: l_val_param := 'INVALID';
34: -- Check if program_cd is not an upper case value then log error message
35: ELSIF p_awd_aim_rec.program_cd <> UPPER(p_awd_aim_rec.program_cd) THEN
36: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PRGM_CD_UCASE');

Line 37: FND_MSG_PUB.ADD;

33: l_val_param := 'INVALID';
34: -- Check if program_cd is not an upper case value then log error message
35: ELSIF p_awd_aim_rec.program_cd <> UPPER(p_awd_aim_rec.program_cd) THEN
36: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PRGM_CD_UCASE');
37: FND_MSG_PUB.ADD;
38: l_val_param := 'INVALID';
39: END IF;
40:
41: -- Check if award_cd value is null then log error message

Line 44: FND_MSG_PUB.ADD;

40:
41: -- Check if award_cd value is null then log error message
42: IF p_awd_aim_rec.award_cd IS NULL THEN
43: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_AWD_CD_NULL');
44: FND_MSG_PUB.ADD;
45: l_val_param := 'INVALID';
46: -- Check if award_cd is not an upper case value then log error message
47: ELSIF p_awd_aim_rec.award_cd <> UPPER(p_awd_aim_rec.award_cd) THEN
48: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_AWD_CD_UCASE');

Line 49: FND_MSG_PUB.ADD;

45: l_val_param := 'INVALID';
46: -- Check if award_cd is not an upper case value then log error message
47: ELSIF p_awd_aim_rec.award_cd <> UPPER(p_awd_aim_rec.award_cd) THEN
48: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_AWD_CD_UCASE');
49: FND_MSG_PUB.ADD;
50: l_val_param := 'INVALID';
51: END IF;
52:
53: -- Check if start_dt value is null then log error message

Line 56: FND_MSG_PUB.ADD;

52:
53: -- Check if start_dt value is null then log error message
54: IF p_awd_aim_rec.start_dt IS NULL THEN
55: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PS_STARDT_NOT_NULL');
56: FND_MSG_PUB.ADD;
57: l_val_param := 'INVALID';
58: END IF;
59:
60: -- Check if complete_ind is available and is not 'Y' or 'N' then log error message

Line 64: FND_MSG_PUB.ADD;

60: -- Check if complete_ind is available and is not 'Y' or 'N' then log error message
61: IF p_awd_aim_rec.complete_ind IS NOT NULL THEN
62: IF p_awd_aim_rec.complete_ind NOT IN('Y','N') THEN
63: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_COMPLT_IND_INVALID');
64: FND_MSG_PUB.ADD;
65: l_val_param := 'INVALID';
66: END IF;
67: END IF;
68:

Line 73: FND_MSG_PUB.ADD;

69: -- Check if award_mark is available and is in 0-100 range
70: IF p_awd_aim_rec.award_mark IS NOT NULL THEN
71: IF NOT (p_awd_aim_rec.award_mark >= 0 AND p_awd_aim_rec.award_mark <= 100 ) THEN
72: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_MARK_INV_0_100');
73: FND_MSG_PUB.ADD;
74: l_val_param := 'INVALID';
75: END IF;
76: END IF;
77:

Line 118: FND_MSG_PUB.ADD;

114: x_award_cd => p_awd_aim_rec.award_cd,
115: x_course_cd => p_awd_aim_rec.program_cd,
116: x_person_id => p_person_id ) THEN
117: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_AWD_AIM_EXISTS');
118: FND_MSG_PUB.ADD;
119: l_ret_status := 'W';
120: RETURN l_ret_status;
121: END IF;
122:

Line 128: FND_MSG_PUB.ADD;

124: IF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation (
125: x_person_id => p_person_id,
126: x_course_cd => p_awd_aim_rec.program_cd ) THEN
127: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PRGM_ATT_NOT_EXIST');
128: FND_MSG_PUB.ADD;
129: l_ret_status := FND_API.G_RET_STS_ERROR;
130: END IF;
131:
132: -- FK check in the Award Code table

Line 136: FND_MSG_PUB.ADD;

132: -- FK check in the Award Code table
133: IF NOT igs_ps_awd_pkg.get_pk_for_validation (
134: x_award_cd => p_awd_aim_rec.award_cd ) THEN
135: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_AWD_NOT_EXIST');
136: FND_MSG_PUB.ADD;
137: l_ret_status := FND_API.G_RET_STS_ERROR;
138: END IF;
139:
140: -- Check if grading schema matches one stored at the award

Line 150: FND_MSG_PUB.ADD;

146: p_awd_aim_rec.gs_version_number);
147: FETCH cur_awd_grd_sch INTO l_dummy;
148: IF (cur_awd_grd_sch%NOTFOUND) THEN
149: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWD_GRD_SCH_NO_MTCH');
150: FND_MSG_PUB.ADD;
151: l_ret_status := FND_API.G_RET_STS_ERROR;
152: END IF;
153: END IF;
154:

Line 165: FND_MSG_PUB.ADD;

161: x_version_number => p_awd_aim_rec.gs_version_number,
162: x_grade => p_awd_aim_rec.award_grade )
163: THEN
164: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_GRD_NOT_IN_SCHEMA');
165: FND_MSG_PUB.ADD;
166: l_ret_status := FND_API.G_RET_STS_ERROR;
167: END IF;
168: ELSE
169: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_GRD_NOT_IN_SCHEMA');

Line 170: FND_MSG_PUB.ADD;

166: l_ret_status := FND_API.G_RET_STS_ERROR;
167: END IF;
168: ELSE
169: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_GRD_NOT_IN_SCHEMA');
170: FND_MSG_PUB.ADD;
171: l_ret_status := FND_API.G_RET_STS_ERROR;
172: END IF;
173: END IF;
174:

Line 204: FND_MSG_PUB.ADD;

200: p_start_dt => p_awd_aim_rec.start_dt,
201: p_end_dt => p_awd_aim_rec.end_dt,
202: p_message_name => l_message) THEN
203: FND_MESSAGE.SET_NAME ('IGS', l_message);
204: FND_MSG_PUB.ADD;
205: l_val_awd_aim := 'INVALID';
206: END IF;
207: END IF;
208:

Line 216: FND_MSG_PUB.ADD;

212: p_person_id => p_person_id,
213: p_program_cd => p_awd_aim_rec.program_cd,
214: p_award_cd => p_awd_aim_rec.award_cd) THEN
215: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_AWD_AVAIL_STU_PGM');
216: FND_MSG_PUB.ADD;
217: l_val_awd_aim := 'INVALID';
218: END IF;
219:
220: RETURN l_val_awd_aim;

Line 270: FND_MSG_PUB.INITIALIZE;

266: END IF;
267:
268: -- Initialize message list if p_init_msg_list is set to TRUE.
269: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
270: FND_MSG_PUB.INITIALIZE;
271: END IF;
272:
273: -- Initialize API return status to success
274: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 286: FND_MSG_PUB.ADD;

282: l_person_id := igs_ge_gen_003.get_person_id( p_person_number => p_awd_aim_rec.person_number);
283: -- If person id value returned is NULL then log error message.
284: IF l_person_id IS NULL THEN
285: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
286: FND_MSG_PUB.ADD;
287: l_stdnt_awd_aim_status := 'INVALID';
288: END IF;
289: END IF;
290:

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

373: END IF;
374: END IF;
375:
376: -- Standard call to get message count and if count is 1, get message info.
377: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
378: p_data => x_msg_data );
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: ROLLBACK TO awd_aim_pub;

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

379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: ROLLBACK TO awd_aim_pub;
382: x_return_status := FND_API.G_RET_STS_ERROR ;
383: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
384: p_data => x_msg_data );
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK TO awd_aim_pub;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

384: p_data => x_msg_data );
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK TO awd_aim_pub;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
388: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count,
389: p_data => x_msg_data );
390: WHEN OTHERS THEN
391: ROLLBACK TO awd_aim_pub;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

389: p_data => x_msg_data );
390: WHEN OTHERS THEN
391: ROLLBACK TO awd_aim_pub;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name,
395: l_api_name );
396: END IF;
397: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count ,

Line 394: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name,

390: WHEN OTHERS THEN
391: ROLLBACK TO awd_aim_pub;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name,
395: l_api_name );
396: END IF;
397: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count ,
398: p_data => x_msg_data );

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

393: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name,
395: l_api_name );
396: END IF;
397: FND_MSG_PUB.COUNT_AND_GET ( p_count => x_msg_count ,
398: p_data => x_msg_data );
399: END create_student_awd_aim;
400:
401: END igs_en_spaa_lgcy_pub;