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_AD_RECRUITMENTS_PKG dependencies on FND_MESSAGE

Line 67: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

63: Open cur_old_ref_values;
64: Fetch cur_old_ref_values INTO old_references;
65: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
66: Close cur_old_ref_values;
67: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
68: IGS_GE_MSG_STACK.ADD;
69: App_Exception.Raise_Exception;
70: Return;
71: END IF;

Line 149: Fnd_Message.Set_Name('IGS','IGS_AD_HONORS_CLS');

145: -- The following code checks for check constraints on the Columns.
146: IF Upper(Column_Name) = 'HONORS_CLASSES' OR
147: Column_Name IS NULL THEN
148: IF NOT (new_references.honors_classes >= 0) THEN
149: Fnd_Message.Set_Name('IGS','IGS_AD_HONORS_CLS');
150: App_Exception.Raise_Exception;
151: END IF;
152: END IF;
153:

Line 158: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

154: -- The following code checks for check constraints on the Columns.
155: IF Upper(Column_Name) = 'VIP' OR
156: Column_Name IS NULL THEN
157: IF NOT (new_references.vip IN ('Y','N')) THEN
158: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
159: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_VIP'));
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;

Line 159: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_VIP'));

155: IF Upper(Column_Name) = 'VIP' OR
156: Column_Name IS NULL THEN
157: IF NOT (new_references.vip IN ('Y','N')) THEN
158: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
159: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_VIP'));
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: END IF;

Line 169: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

165: -- The following code checks for check constraints on the Columns.
166: IF Upper(Column_Name) = 'DEACTIVATE_RECRUIT_STATUS' OR
167: Column_Name IS NULL THEN
168: IF NOT (new_references.deactivate_recruit_status IN ('Y','N')) THEN
169: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
170: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEACTIVATE_REC_STAT'));
171: IGS_GE_MSG_STACK.ADD;
172: App_Exception.Raise_Exception;
173: END IF;

Line 170: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEACTIVATE_REC_STAT'));

166: IF Upper(Column_Name) = 'DEACTIVATE_RECRUIT_STATUS' OR
167: Column_Name IS NULL THEN
168: IF NOT (new_references.deactivate_recruit_status IN ('Y','N')) THEN
169: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
170: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEACTIVATE_REC_STAT'));
171: IGS_GE_MSG_STACK.ADD;
172: App_Exception.Raise_Exception;
173: END IF;
174: END IF;

Line 180: Fnd_Message.Set_Name('IGS','IGS_AD_PER_HIGH_EDU');

176: -- The following code checks for check constraints on the Columns.
177: IF Upper(Column_Name) = 'PERCENT_PLAN_HIGHER_EDU' OR
178: Column_Name IS NULL THEN
179: IF NOT (new_references.percent_plan_higher_edu > 0) THEN
180: Fnd_Message.Set_Name('IGS','IGS_AD_PER_HIGH_EDU');
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF;
184: END IF;

Line 190: Fnd_Message.Set_Name('IGS','IGS_AD_CLASS_SIZE');

186: -- The following code checks for check constraints on the Columns.
187: IF Upper(Column_Name) = 'CLASS_SIZE' OR
188: Column_Name IS NULL THEN
189: IF NOT (new_references.class_size > 0) THEN
190: Fnd_Message.Set_Name('IGS','IGS_AD_CLASS_SIZE');
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: END IF;
194: END IF;

Line 202: Fnd_Message.Set_Name('IGS','IGS_AD_ADCLS_NOT_VAL');

198:
199: IF Upper(Column_Name) = 'ADV_STUDIES_CLASSES' OR
200: Column_Name IS NULL THEN
201: IF new_references.adv_studies_classes < 0 THEN
202: Fnd_Message.Set_Name('IGS','IGS_AD_ADCLS_NOT_VAL');
203: IGS_GE_MSG_STACK.ADD;
204: App_Exception.Raise_Exception;
205: END IF;
206: END IF;

Line 226: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

222: begin
223: IF Get_Uk_For_Validation (
224: new_references.person_id
225: ) THEN
226: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
227: IGS_GE_MSG_STACK.ADD;
228: app_exception.raise_exception;
229: END IF;
230: END Check_Uniqueness ;

Line 254: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

250: new_references.institution_location_id,
251: 'INSTITUTION_LOCATION',
252: 'N'
253: ) THEN
254: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
255: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_LOC'));
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;

Line 255: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_LOC'));

251: 'INSTITUTION_LOCATION',
252: 'N'
253: ) THEN
254: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
255: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_LOC'));
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;
259:

Line 268: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

264: new_references.sec_school_location_id,
265: 'SEC_SCHOOL_LOCATION',
266: 'N'
267: ) THEN
268: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEC_SCH_LOC'));
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;

Line 269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEC_SCH_LOC'));

265: 'SEC_SCHOOL_LOCATION',
266: 'N'
267: ) THEN
268: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SEC_SCH_LOC'));
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273:

Line 280: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

276: NULL;
277: ELSIF NOT Igs_lookups_view_pkg.Get_PK_For_Validation (
278: 'PE_RELIGION',new_references.religion_cd
279: ) THEN
280: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_RELG'));
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;

Line 281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_RELG'));

277: ELSIF NOT Igs_lookups_view_pkg.Get_PK_For_Validation (
278: 'PE_RELIGION',new_references.religion_cd
279: ) THEN
280: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_RELG'));
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285:

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

288: NULL;
289: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
290: new_references.person_id
291: ) THEN
292: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
293: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;

Line 293: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));

289: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
290: new_references.person_id
291: ) THEN
292: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
293: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;
297:

Line 306: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

302: new_references.degree_goal_id,
303: 'DESIRED_DEGREE',
304: 'N'
305: ) THEN
306: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEGREE_GOAL'));
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;

Line 307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEGREE_GOAL'));

303: 'DESIRED_DEGREE',
304: 'N'
305: ) THEN
306: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_DEGREE_GOAL'));
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311:

Line 320: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

316: new_references.unit_set_id,
317: 'DESIRED_UNIT_SET',
318: 'N'
319: ) THEN
320: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END IF;

Line 321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));

317: 'DESIRED_UNIT_SET',
318: 'N'
319: ) THEN
320: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END IF;
325:

Line 334: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

330: new_references.institution_setting_id ,
331: 'INSTITUTION_SETTING',
332: 'N'
333: ) THEN
334: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
335: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_SETTING'));
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END IF;

Line 335: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_SETTING'));

331: 'INSTITUTION_SETTING',
332: 'N'
333: ) THEN
334: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
335: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_SETTING'));
336: IGS_GE_MSG_STACK.ADD;
337: App_Exception.Raise_Exception;
338: END IF;
339:

Line 348: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

344: new_references.program_interest_id ,
345: 'PROGRAM_INTEREST',
346: 'N'
347: ) THEN
348: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_INTEREST'));
350: IGS_GE_MSG_STACK.ADD;
351: App_Exception.Raise_Exception;
352: END IF;

Line 349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_INTEREST'));

345: 'PROGRAM_INTEREST',
346: 'N'
347: ) THEN
348: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_INTEREST'));
350: IGS_GE_MSG_STACK.ADD;
351: App_Exception.Raise_Exception;
352: END IF;
353:

Line 362: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

358: new_references.certainty_of_choice_id ,
359: 'CERTAINTY_OF_CHOICE',
360: 'N'
361: ) THEN
362: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CERTAIN_OF_CHOICE'));
364: IGS_GE_MSG_STACK.ADD;
365: App_Exception.Raise_Exception;
366: END IF;

Line 363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CERTAIN_OF_CHOICE'));

359: 'CERTAINTY_OF_CHOICE',
360: 'N'
361: ) THEN
362: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CERTAIN_OF_CHOICE'));
364: IGS_GE_MSG_STACK.ADD;
365: App_Exception.Raise_Exception;
366: END IF;
367:

Line 376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

372: new_references.special_services_id ,
373: 'SPECIAL_SERVICES',
374: 'N'
375: ) THEN
376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_SERVICES'));
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: END IF;

Line 377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_SERVICES'));

373: 'SPECIAL_SERVICES',
374: 'N'
375: ) THEN
376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_SERVICES'));
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: END IF;
381:

Line 390: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

386: new_references.employment_id ,
387: 'DESIRED_EMPLOYMENT',
388: 'N'
389: ) THEN
390: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
391: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EMPLOYMENT_INF'));
392: IGS_GE_MSG_STACK.ADD;
393: App_Exception.Raise_Exception;
394: END IF;

Line 391: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EMPLOYMENT_INF'));

387: 'DESIRED_EMPLOYMENT',
388: 'N'
389: ) THEN
390: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
391: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EMPLOYMENT_INF'));
392: IGS_GE_MSG_STACK.ADD;
393: App_Exception.Raise_Exception;
394: END IF;
395:

Line 404: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

400: new_references.institution_size_id ,
401: 'INSTITUTION_SIZE',
402: 'N'
403: ) THEN
404: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
405: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_SIZE'));
406: IGS_GE_MSG_STACK.ADD;
407: App_Exception.Raise_Exception;
408: END IF;

Line 405: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_SIZE'));

401: 'INSTITUTION_SIZE',
402: 'N'
403: ) THEN
404: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
405: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_SIZE'));
406: IGS_GE_MSG_STACK.ADD;
407: App_Exception.Raise_Exception;
408: END IF;
409:

Line 418: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

414: new_references.special_interest_id ,
415: 'SPECIAL_INTEREST',
416: 'N'
417: ) THEN
418: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
419: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_INTEREST'));
420: IGS_GE_MSG_STACK.ADD;
421: App_Exception.Raise_Exception;
422: END IF;

Line 419: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_INTEREST'));

415: 'SPECIAL_INTEREST',
416: 'N'
417: ) THEN
418: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
419: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_INTEREST'));
420: IGS_GE_MSG_STACK.ADD;
421: App_Exception.Raise_Exception;
422: END IF;
423:

Line 432: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

428: new_references.housing_id ,
429: 'DESIRED_HOUSING',
430: 'N'
431: ) THEN
432: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_HOUSE_INF'));
434: IGS_GE_MSG_STACK.ADD;
435: App_Exception.Raise_Exception;
436: END IF;

Line 433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_HOUSE_INF'));

429: 'DESIRED_HOUSING',
430: 'N'
431: ) THEN
432: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_HOUSE_INF'));
434: IGS_GE_MSG_STACK.ADD;
435: App_Exception.Raise_Exception;
436: END IF;
437:

Line 446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');

442: new_references.institution_control_id ,
443: 'INSTITUTION_CONTROL',
444: 'N'
445: ) THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_CONTROL'));
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END IF;

Line 447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_CONTROL'));

443: 'INSTITUTION_CONTROL',
444: 'N'
445: ) THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INST_CONTROL'));
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END IF;
451:

Line 608: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK3');

604: Open cur_rowid1;
605: Fetch cur_rowid1 INTO lv_rowid;
606: IF (cur_rowid1%FOUND) THEN
607: Close cur_rowid1;
608: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK3');
609: IGS_GE_MSG_STACK.ADD;
610: App_Exception.Raise_Exception;
611: Return;
612: END IF;

Line 619: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK8');

615: Open cur_rowid2;
616: Fetch cur_rowid2 INTO lv_rowid;
617: IF (cur_rowid2%FOUND) THEN
618: Close cur_rowid2;
619: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK8');
620: IGS_GE_MSG_STACK.ADD;
621: App_Exception.Raise_Exception;
622: Return;
623: END IF;

Line 630: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK9');

626: Open cur_rowid3;
627: Fetch cur_rowid3 INTO lv_rowid;
628: IF (cur_rowid3%FOUND) THEN
629: Close cur_rowid3;
630: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK9');
631: IGS_GE_MSG_STACK.ADD;
632: App_Exception.Raise_Exception;
633: Return;
634: END IF;

Line 641: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK4');

637: Open cur_rowid4;
638: Fetch cur_rowid4 INTO lv_rowid;
639: IF (cur_rowid4%FOUND) THEN
640: Close cur_rowid4;
641: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK4');
642: IGS_GE_MSG_STACK.ADD;
643: App_Exception.Raise_Exception;
644: Return;
645: END IF;

Line 652: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK');

648: Open cur_rowid5;
649: Fetch cur_rowid5 INTO lv_rowid;
650: IF (cur_rowid5%FOUND) THEN
651: Close cur_rowid5;
652: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK');
653: IGS_GE_MSG_STACK.ADD;
654: App_Exception.Raise_Exception;
655: Return;
656: END IF;

Line 663: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK10');

659: Open cur_rowid6;
660: Fetch cur_rowid6 INTO lv_rowid;
661: IF (cur_rowid6%FOUND) THEN
662: Close cur_rowid6;
663: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK10');
664: IGS_GE_MSG_STACK.ADD;
665: App_Exception.Raise_Exception;
666: Return;
667: END IF;

Line 674: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK5');

670: Open cur_rowid7;
671: Fetch cur_rowid7 INTO lv_rowid;
672: IF (cur_rowid7%FOUND) THEN
673: Close cur_rowid7;
674: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK5');
675: IGS_GE_MSG_STACK.ADD;
676: App_Exception.Raise_Exception;
677: Return;
678: END IF;

Line 685: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK6');

681: Open cur_rowid8;
682: Fetch cur_rowid8 INTO lv_rowid;
683: IF (cur_rowid8%FOUND) THEN
684: Close cur_rowid8;
685: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK6');
686: IGS_GE_MSG_STACK.ADD;
687: App_Exception.Raise_Exception;
688: Return;
689: END IF;

Line 696: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK1');

692: Open cur_rowid9;
693: Fetch cur_rowid9 INTO lv_rowid;
694: IF (cur_rowid9%FOUND) THEN
695: Close cur_rowid9;
696: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK1');
697: IGS_GE_MSG_STACK.ADD;
698: App_Exception.Raise_Exception;
699: Return;
700: END IF;

Line 707: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK7');

703: Open cur_rowid10;
704: Fetch cur_rowid10 INTO lv_rowid;
705: IF (cur_rowid10%FOUND) THEN
706: Close cur_rowid10;
707: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK7');
708: IGS_GE_MSG_STACK.ADD;
709: App_Exception.Raise_Exception;
710: Return;
711: END IF;

Line 718: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK2');

714: Open cur_rowid11;
715: Fetch cur_rowid11 INTO lv_rowid;
716: IF (cur_rowid11%FOUND) THEN
717: Close cur_rowid11;
718: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK2');
719: IGS_GE_MSG_STACK.ADD;
720: App_Exception.Raise_Exception;
721: Return;
722: END IF;

Line 729: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK11');

725: Open cur_rowid12;
726: Fetch cur_rowid12 INTO lv_rowid;
727: IF (cur_rowid12%FOUND) THEN
728: Close cur_rowid12;
729: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_ACDC_FK11');
730: IGS_GE_MSG_STACK.ADD;
731: App_Exception.Raise_Exception;
732: Return;
733: END IF;

Line 767: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_PE_FK');

763: Open cur_rowid;
764: Fetch cur_rowid INTO lv_rowid;
765: IF (cur_rowid%FOUND) THEN
766: Close cur_rowid;
767: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AREC_PE_FK');
768: IGS_GE_MSG_STACK.ADD;
769: App_Exception.Raise_Exception;
770: Return;
771: END IF;

Line 860: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

856: -- Call all the procedures related to Before Insert.
857: Null;
858: IF Get_Pk_For_Validation(
859: new_references.recruitment_id) THEN
860: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
861: IGS_GE_MSG_STACK.ADD;
862: App_Exception.Raise_Exception;
863: END IF;
864: Check_Uniqueness;

Line 879: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

875: ELSIF (p_action = 'VALIDATE_INSERT') THEN
876: -- Call all the procedures related to Before Insert.
877: IF Get_PK_For_Validation (
878: new_references.recruitment_id) THEN
879: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
880: IGS_GE_MSG_STACK.ADD;
881: App_Exception.Raise_Exception;
882: END IF;
883: Check_Uniqueness;

Line 987: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

983: if X_LAST_UPDATE_LOGIN is NULL then
984: X_LAST_UPDATE_LOGIN := -1;
985: end if;
986: else
987: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
988: IGS_GE_MSG_STACK.ADD;
989: app_exception.raise_exception;
990: end if;
991:

Line 1162: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

1158: begin
1159: open c1;
1160: fetch c1 into tlinfo;
1161: if (c1%notfound) then
1162: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1163: IGS_GE_MSG_STACK.ADD;
1164: close c1;
1165: app_exception.raise_exception;
1166: return;

Line 1236: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

1232: AND (X_UNIT_SET_ID is null)))
1233: ) then
1234: null;
1235: else
1236: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1237: IGS_GE_MSG_STACK.ADD;
1238: app_exception.raise_exception;
1239: end if;
1240: return;

Line 1299: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

1295: if X_LAST_UPDATE_LOGIN is NULL then
1296: X_LAST_UPDATE_LOGIN := -1;
1297: end if;
1298: else
1299: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1300: IGS_GE_MSG_STACK.ADD;
1301: app_exception.raise_exception;
1302: end if;
1303: Before_DML(