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 IGS_GE_MSG_STACK

Line 68: IGS_GE_MSG_STACK.ADD;

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;
72: Close cur_old_ref_values;

Line 160: IGS_GE_MSG_STACK.ADD;

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

Line 171: IGS_GE_MSG_STACK.ADD;

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

Line 181: IGS_GE_MSG_STACK.ADD;

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

Line 191: IGS_GE_MSG_STACK.ADD;

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

Line 203: IGS_GE_MSG_STACK.ADD;

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

Line 227: IGS_GE_MSG_STACK.ADD;

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

Line 256: IGS_GE_MSG_STACK.ADD;

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:
260: IF (((old_references.sec_school_location_id = new_references.sec_school_location_id)) OR

Line 270: IGS_GE_MSG_STACK.ADD;

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:
274: IF (((old_references.religion_cd = new_references.religion_cd)) OR

Line 282: IGS_GE_MSG_STACK.ADD;

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:
286: IF (((old_references.person_id = new_references.person_id)) OR

Line 294: IGS_GE_MSG_STACK.ADD;

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:
298: IF (((old_references.degree_goal_id = new_references.degree_goal_id)) OR

Line 308: IGS_GE_MSG_STACK.ADD;

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:
312: IF (((old_references.unit_set_id = new_references.unit_set_id)) OR

Line 322: IGS_GE_MSG_STACK.ADD;

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:
326: IF (((old_references.institution_setting_id = new_references.institution_setting_id)) OR

Line 336: IGS_GE_MSG_STACK.ADD;

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:
340: IF (((old_references.program_interest_id = new_references.program_interest_id)) OR

Line 350: IGS_GE_MSG_STACK.ADD;

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:
354: IF (((old_references.certainty_of_choice_id = new_references.certainty_of_choice_id)) OR

Line 364: IGS_GE_MSG_STACK.ADD;

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:
368: IF (((old_references.special_services_id = new_references.special_services_id)) OR

Line 378: IGS_GE_MSG_STACK.ADD;

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:
382: IF (((old_references.employment_id = new_references.employment_id)) OR

Line 392: IGS_GE_MSG_STACK.ADD;

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:
396: IF (((old_references.institution_size_id = new_references.institution_size_id)) OR

Line 406: IGS_GE_MSG_STACK.ADD;

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:
410: IF (((old_references.special_interest_id = new_references.special_interest_id)) OR

Line 420: IGS_GE_MSG_STACK.ADD;

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:
424: IF (((old_references.housing_id = new_references.housing_id)) OR

Line 434: IGS_GE_MSG_STACK.ADD;

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:
438: IF (((old_references.institution_control_id = new_references.institution_control_id)) OR

Line 448: IGS_GE_MSG_STACK.ADD;

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:
452: END Check_Parent_Existance;

Line 609: IGS_GE_MSG_STACK.ADD;

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;
613: Close cur_rowid1;

Line 620: IGS_GE_MSG_STACK.ADD;

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;
624: Close cur_rowid2;

Line 631: IGS_GE_MSG_STACK.ADD;

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;
635: Close cur_rowid3;

Line 642: IGS_GE_MSG_STACK.ADD;

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;
646: Close cur_rowid4;

Line 653: IGS_GE_MSG_STACK.ADD;

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;
657: Close cur_rowid5;

Line 664: IGS_GE_MSG_STACK.ADD;

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;
668: Close cur_rowid6;

Line 675: IGS_GE_MSG_STACK.ADD;

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;
679: Close cur_rowid7;

Line 686: IGS_GE_MSG_STACK.ADD;

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;
690: Close cur_rowid8;

Line 697: IGS_GE_MSG_STACK.ADD;

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;
701: Close cur_rowid9;

Line 708: IGS_GE_MSG_STACK.ADD;

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;
712: Close cur_rowid10;

Line 719: IGS_GE_MSG_STACK.ADD;

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;
723: Close cur_rowid11;

Line 730: IGS_GE_MSG_STACK.ADD;

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;
734: Close cur_rowid12;

Line 768: IGS_GE_MSG_STACK.ADD;

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;
772: Close cur_rowid;

Line 861: IGS_GE_MSG_STACK.ADD;

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;
865: Check_Constraints;

Line 880: IGS_GE_MSG_STACK.ADD;

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;
884: Check_Constraints;

Line 988: IGS_GE_MSG_STACK.ADD;

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:
992: X_RECRUITMENT_ID := -1;

Line 1163: IGS_GE_MSG_STACK.ADD;

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;
1167: end if;

Line 1237: IGS_GE_MSG_STACK.ADD;

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;
1241: end LOCK_ROW;

Line 1300: IGS_GE_MSG_STACK.ADD;

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(
1304: p_action=>'UPDATE',