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_MESSAGE

Line 106: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_CMNT_TYP_NULL');

102: nullify_inappropriate_fields(p_lgcy_trncmt_rec);
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

Line 112: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_CMNT_NULL');

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);
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

Line 118: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PER_NUM_NULL');

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);
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

Line 127: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_CMNT_TYP_INVALID');

123: OPEN cur_lookup_code(p_lgcy_trncmt_rec.comment_type_code);
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;

Line 140: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

136: p_lgcy_trncmt_rec.comment_type_code = 'CAREER_TERM' ) AND
137: p_lgcy_trncmt_rec.program_type IS NULL
138: THEN
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;

Line 141: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'program_type');

137: p_lgcy_trncmt_rec.program_type IS NULL
138: THEN
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:

Line 142: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

138: THEN
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

Line 154: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

150: p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_AWARD' ) AND
151: p_lgcy_trncmt_rec.program_cd IS NULL
152: THEN
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;

Line 155: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'program_cd');

151: p_lgcy_trncmt_rec.program_cd IS NULL
152: THEN
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:

Line 156: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

152: THEN
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

Line 164: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

160: IF p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_AWARD' AND
161: p_lgcy_trncmt_rec.award_cd IS NULL
162: THEN
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;

Line 165: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'award_cd');

161: p_lgcy_trncmt_rec.award_cd IS NULL
162: THEN
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:

Line 166: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

162: THEN
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

Line 174: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

170: IF p_lgcy_trncmt_rec.comment_type_code = 'CAREER_TERM' AND
171: p_lgcy_trncmt_rec.load_cal_alternate_cd IS NULL
172: THEN
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;

Line 175: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'load_cal_alternate_cd');

171: p_lgcy_trncmt_rec.load_cal_alternate_cd IS NULL
172: THEN
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:

Line 176: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

172: THEN
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

Line 183: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

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
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;

Line 184: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'unit_set_cd');

180: IF p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_YEAR' THEN
181: IF p_lgcy_trncmt_rec.unit_set_cd IS NULL THEN
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

Line 185: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

181: IF p_lgcy_trncmt_rec.unit_set_cd IS NULL THEN
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);

Line 190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

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');
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;

Line 191: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'us_version_number');

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');
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;

Line 192: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

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');
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:

Line 200: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

196:
197: IF p_lgcy_trncmt_rec.comment_type_code = 'UNIT_ATTEMPT' THEN
198: IF p_lgcy_trncmt_rec.unit_cd IS NULL THEN
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;

Line 201: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'unit_cd');

197: IF p_lgcy_trncmt_rec.comment_type_code = 'UNIT_ATTEMPT' THEN
198: IF p_lgcy_trncmt_rec.unit_cd IS NULL THEN
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

Line 202: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

198: IF p_lgcy_trncmt_rec.unit_cd IS NULL THEN
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);

Line 207: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

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');
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;

Line 208: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'version_number');

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');
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

Line 209: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

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');
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);

Line 214: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

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');
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;

Line 215: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'teach_cal_alternate_cd');

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');
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

Line 216: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

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');
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);

Line 221: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

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');
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;

Line 222: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'location_cd');

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');
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

Line 223: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

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');
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);

Line 228: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

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');
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;

Line 229: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'unit_class');

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');
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;

Line 230: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

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');
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:

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

288:
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;

Line 308: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');

304: l_start_dt,
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;

Line 325: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');

321: l_start_dt,
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;

Line 344: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');

340: p_lgcy_trncmt_rec.unit_class);
341: FETCH cur_uoo_id INTO p_uoo_id;
342: IF cur_uoo_id%NOTFOUND THEN
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;

Line 345: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'uoo_id');

341: FETCH cur_uoo_id INTO p_uoo_id;
342: IF cur_uoo_id%NOTFOUND THEN
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;

Line 346: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);

342: IF cur_uoo_id%NOTFOUND THEN
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;

Line 441: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_EXISTS');

437: x_us_version_number => p_lgcy_trncmt_rec.us_version_number,
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;

Line 453: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_STPRATPT_FK_NOT_EXISTS');

449: NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation(
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:

Line 465: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_STD_ENRL_NOT_EXISTS');

461: p_lgcy_trncmt_rec.program_cd,
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;

Line 478: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PR_AWD_AWARD_FK');

474: x_person_id => p_person_id,
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:

Line 492: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_UNTST_VERSION_BET_0_999');

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

Line 502: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_BAS_CRS_TYP_FK_EXISTS');

498: --Foreign key validation with IGS_PS_TYPE
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:

Line 514: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_US_CHK');

510: p_lgcy_trncmt_rec.program_cd,
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;

Line 529: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_STD_ENRL_NOT_EXISTS');

525: p_load_cal_type,
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;

Line 541: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_BAS_CRS_TYP_FK_EXISTS');

537: IF substr(p_lgcy_trncmt_rec.comment_type_code, 0, 7) = 'CAREER_' THEN
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;

Line 715: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_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');
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:

Line 716: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

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');
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 ;