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

Line 107: FND_MSG_PUB.ADD;

103:
104: IF p_lgcy_trncmt_rec.comment_type_code IS NULL THEN
105: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
106: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_CMNT_TYP_NULL');
107: FND_MSG_PUB.ADD;
108: END IF;
109:
110: IF p_lgcy_trncmt_rec.comment_txt IS NULL THEN
111: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

Line 113: FND_MSG_PUB.ADD;

109:
110: IF p_lgcy_trncmt_rec.comment_txt IS NULL THEN
111: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
112: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_CMNT_NULL');
113: FND_MSG_PUB.ADD;
114: END IF;
115:
116: IF p_lgcy_trncmt_rec.person_number IS NULL THEN
117: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

Line 119: FND_MSG_PUB.ADD;

115:
116: IF p_lgcy_trncmt_rec.person_number IS NULL THEN
117: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
118: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PER_NUM_NULL');
119: FND_MSG_PUB.ADD;
120: END IF;
121:
122: IF p_lgcy_trncmt_rec.comment_type_code IS NOT NULL THEN
123: OPEN cur_lookup_code(p_lgcy_trncmt_rec.comment_type_code);

Line 128: FND_MSG_PUB.ADD;

124: FETCH cur_lookup_code INTO l_dummy;
125: IF cur_lookup_code%NOTFOUND THEN
126: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
127: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_CMNT_TYP_INVALID');
128: FND_MSG_PUB.ADD;
129: RETURN l_return_value ;
130: END IF;
131: CLOSE cur_lookup_code;
132:

Line 143: FND_MSG_PUB.ADD;

139: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
140: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
141: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'program_type');
142: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
143: FND_MSG_PUB.ADD;
144: END IF;
145:
146: IF (p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_HEADER' OR
147: p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_FOOTER' OR

Line 157: FND_MSG_PUB.ADD;

153: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
154: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
155: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'program_cd');
156: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
157: FND_MSG_PUB.ADD;
158: END IF;
159:
160: IF p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_AWARD' AND
161: p_lgcy_trncmt_rec.award_cd IS NULL

Line 167: FND_MSG_PUB.ADD;

163: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
164: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
165: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'award_cd');
166: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
167: FND_MSG_PUB.ADD;
168: END IF;
169:
170: IF p_lgcy_trncmt_rec.comment_type_code = 'CAREER_TERM' AND
171: p_lgcy_trncmt_rec.load_cal_alternate_cd IS NULL

Line 177: FND_MSG_PUB.ADD;

173: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
174: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
175: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'load_cal_alternate_cd');
176: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
177: FND_MSG_PUB.ADD;
178: END IF;
179:
180: IF p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_YEAR' THEN
181: IF p_lgcy_trncmt_rec.unit_set_cd IS NULL THEN

Line 186: FND_MSG_PUB.ADD;

182: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
183: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
184: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'unit_set_cd');
185: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
186: FND_MSG_PUB.ADD;
187: END IF;
188: IF p_lgcy_trncmt_rec.us_version_number IS NULL THEN
189: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

Line 193: FND_MSG_PUB.ADD;

189: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
191: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'us_version_number');
192: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
193: FND_MSG_PUB.ADD;
194: END IF;
195: END IF;
196:
197: IF p_lgcy_trncmt_rec.comment_type_code = 'UNIT_ATTEMPT' THEN

Line 203: FND_MSG_PUB.ADD;

199: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
200: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
201: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'unit_cd');
202: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
203: FND_MSG_PUB.ADD;
204: END IF;
205: IF p_lgcy_trncmt_rec.version_number IS NULL THEN
206: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
207: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

Line 210: FND_MSG_PUB.ADD;

206: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
207: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
208: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'version_number');
209: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
210: FND_MSG_PUB.ADD;
211: END IF;
212: IF p_lgcy_trncmt_rec.teach_cal_alternate_cd IS NULL THEN
213: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
214: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

Line 217: FND_MSG_PUB.ADD;

213: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
214: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
215: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'teach_cal_alternate_cd');
216: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
217: FND_MSG_PUB.ADD;
218: END IF;
219: IF p_lgcy_trncmt_rec.location_cd IS NULL THEN
220: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
221: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

Line 224: FND_MSG_PUB.ADD;

220: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
221: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
222: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'location_cd');
223: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
224: FND_MSG_PUB.ADD;
225: END IF;
226: IF p_lgcy_trncmt_rec.unit_class IS NULL THEN
227: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
228: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

Line 231: FND_MSG_PUB.ADD;

227: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
228: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
229: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'unit_class');
230: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
231: FND_MSG_PUB.ADD;
232: END IF;
233: END IF;
234:
235: END IF;

Line 293: FND_MSG_PUB.ADD;

289: --Get person id
290: p_person_id := igs_ge_gen_003.get_person_id(p_lgcy_trncmt_rec.person_number);
291: IF p_person_id IS NULL THEN
292: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
293: FND_MSG_PUB.ADD;
294: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
295: RETURN l_return_value;
296: END IF;
297:

Line 309: FND_MSG_PUB.ADD;

305: l_end_dt,
306: l_message) ;
307: IF p_load_cal_type IS NULL OR p_load_sequence_number IS NULL THEN
308: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');
309: FND_MSG_PUB.ADD;
310: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
311: RETURN l_return_value;
312: END IF;
313: END IF;

Line 326: FND_MSG_PUB.ADD;

322: l_end_dt,
323: l_message) ;
324: IF l_teach_cal_type IS NULL OR l_teach_sequence_number IS NULL THEN
325: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');
326: FND_MSG_PUB.ADD;
327: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
328: RETURN l_return_value;
329: END IF;
330: END IF;

Line 347: FND_MSG_PUB.ADD;

343: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
344: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
345: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'uoo_id');
346: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
347: FND_MSG_PUB.ADD;
348: END IF;
349: CLOSE cur_uoo_id;
350: END IF;
351:

Line 442: FND_MSG_PUB.ADD;

438: x_uoo_id => p_uoo_id
439: )
440: THEN
441: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_EXISTS');
442: FND_MSG_PUB.ADD;
443: l_return_value := 'E'; -- Error out
444: RETURN l_return_value;
445: END IF;
446:

Line 454: FND_MSG_PUB.ADD;

450: x_person_id => p_person_id ,
451: x_course_cd => p_lgcy_trncmt_rec.program_cd)
452: THEN
453: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_STPRATPT_FK_NOT_EXISTS');
454: FND_MSG_PUB.ADD;
455: l_return_value := 'E';
456: END IF;
457:
458: -- Foreign key validation with IGS_HE_EN_SUSA

Line 466: FND_MSG_PUB.ADD;

462: p_lgcy_trncmt_rec.unit_set_cd);
463: FETCH cur_igs_he_en_susa into l_dummy;
464: IF cur_igs_he_en_susa%NOTFOUND THEN
465: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_STD_ENRL_NOT_EXISTS');
466: FND_MSG_PUB.ADD;
467: l_return_value := 'E';
468: END IF;
469: END IF;
470:

Line 479: FND_MSG_PUB.ADD;

475: x_course_cd => p_lgcy_trncmt_rec.program_cd,
476: x_award_cd => p_lgcy_trncmt_rec.award_cd)
477: THEN
478: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_AWD_AWARD_FK');
479: FND_MSG_PUB.ADD;
480: l_return_value := 'E';
481: END IF;
482:
483: -- unit_set_cd should be in range (0, 999)

Line 491: FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.COUNT_MSG);

487: column_name => 'UNIT_SET_CD',
488: column_value => p_lgcy_trncmt_rec.unit_set_cd);
489: EXCEPTION
490: WHEN OTHERS THEN
491: FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.COUNT_MSG);
492: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_UNTST_VERSION_BET_0_999');
493: FND_MSG_PUB.ADD;
494: l_return_value := 'E';
495: END;

Line 493: FND_MSG_PUB.ADD;

489: EXCEPTION
490: WHEN OTHERS THEN
491: FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.COUNT_MSG);
492: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_UNTST_VERSION_BET_0_999');
493: FND_MSG_PUB.ADD;
494: l_return_value := 'E';
495: END;
496: END IF;
497:

Line 503: FND_MSG_PUB.ADD;

499: IF p_lgcy_trncmt_rec.program_type IS NOT NULL AND
500: NOT igs_ps_type_pkg.get_pk_for_validation(x_course_type => p_lgcy_trncmt_rec.program_type)
501: THEN
502: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_BAS_CRS_TYP_FK_EXISTS');
503: FND_MSG_PUB.ADD;
504: l_return_value := 'E';
505: END IF;
506:
507: --Foreign key validation with IGS_AS_SU_SETATMPT

Line 515: FND_MSG_PUB.ADD;

511: p_lgcy_trncmt_rec.unit_set_cd);
512: FETCH cur_igs_as_su_setatmpt into l_dummy;
513: IF cur_igs_as_su_setatmpt%NOTFOUND THEN
514: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_US_CHK');
515: FND_MSG_PUB.ADD;
516: l_return_value := 'E';
517: END IF;
518: END IF;
519:

Line 530: FND_MSG_PUB.ADD;

526: p_load_sequence_number);
527: FETCH cur_check_career_term into l_dummy;
528: IF cur_check_career_term%NOTFOUND THEN
529: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_STD_ENRL_NOT_EXISTS');
530: FND_MSG_PUB.ADD;
531: l_return_value := 'E';
532: END IF;
533: CLOSE cur_check_career_term;
534: END IF;

Line 542: FND_MSG_PUB.ADD;

538: OPEN cur_check_course_type(p_person_id, p_lgcy_trncmt_rec.program_type);
539: FETCH cur_check_course_type into l_dummy;
540: IF cur_check_course_type%NOTFOUND THEN
541: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_BAS_CRS_TYP_FK_EXISTS');
542: FND_MSG_PUB.ADD;
543: l_return_value := 'E';
544: END IF;
545: CLOSE cur_check_course_type;
546: END IF;

Line 603: FND_MSG_PUB.INITIALIZE;

599: END IF;
600:
601: --Initialize message list if p_init_msg_list is set to TRUE.
602: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
603: FND_MSG_PUB.INITIALIZE;
604: END IF;
605:
606: --Initialize API return status to success.
607: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 695: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);

691: IF FND_API.to_Boolean(p_commit) THEN
692: commit;
693: END IF;
694:
695: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
696:
697:
698: EXCEPTION
699: WHEN WARN_TYPE_ERR THEN

Line 702: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);

698: EXCEPTION
699: WHEN WARN_TYPE_ERR THEN
700: ROLLBACK TO create_trncmt;
701: x_return_status := 'W';
702: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
703: WHEN FND_API.G_EXC_ERROR THEN
704: ROLLBACK TO create_trncmt;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);

Line 706: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);

702: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
703: WHEN FND_API.G_EXC_ERROR THEN
704: ROLLBACK TO create_trncmt;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO create_trncmt;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 711: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);

707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO create_trncmt;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
712: WHEN OTHERS THEN
713: ROLLBACK TO create_trncmt;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');

Line 717: FND_MSG_PUB.ADD;

713: ROLLBACK TO create_trncmt;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
716: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
717: FND_MSG_PUB.ADD;
718: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
719:
720: END create_trncmt ;
721:

Line 718: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);

714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
716: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
717: FND_MSG_PUB.ADD;
718: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
719:
720: END create_trncmt ;
721:
722: