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 APP_EXCEPTION

Line 69: App_Exception.Raise_Exception;

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

Line 150: App_Exception.Raise_Exception;

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:
154: -- The following code checks for check constraints on the Columns.

Line 161: App_Exception.Raise_Exception;

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:
165: -- The following code checks for check constraints on the Columns.

Line 172: App_Exception.Raise_Exception;

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:
176: -- The following code checks for check constraints on the Columns.

Line 182: App_Exception.Raise_Exception;

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:
186: -- The following code checks for check constraints on the Columns.

Line 192: App_Exception.Raise_Exception;

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:
196: -- The following code checks for check constraints on the Columns.

Line 204: App_Exception.Raise_Exception;

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:
208: END Check_Constraints;

Line 228: app_exception.raise_exception;

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:
232: PROCEDURE Check_Parent_Existance AS

Line 257: App_Exception.Raise_Exception;

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
261: ((new_references.sec_school_location_id IS NULL))) THEN

Line 271: App_Exception.Raise_Exception;

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
275: ((new_references.religion_cd IS NULL))) THEN

Line 283: App_Exception.Raise_Exception;

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
287: ((new_references.person_id IS NULL))) THEN

Line 295: App_Exception.Raise_Exception;

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
299: ((new_references.degree_goal_id IS NULL))) THEN

Line 309: App_Exception.Raise_Exception;

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
313: ((new_references.unit_set_id IS NULL))) THEN

Line 323: App_Exception.Raise_Exception;

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
327: ((new_references.institution_setting_id IS NULL))) THEN

Line 337: App_Exception.Raise_Exception;

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
341: ((new_references.program_interest_id IS NULL))) THEN

Line 351: App_Exception.Raise_Exception;

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
355: ((new_references.certainty_of_choice_id IS NULL))) THEN

Line 365: App_Exception.Raise_Exception;

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
369: ((new_references.special_services_id IS NULL))) THEN

Line 379: App_Exception.Raise_Exception;

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
383: ((new_references.employment_id IS NULL))) THEN

Line 393: App_Exception.Raise_Exception;

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
397: ((new_references.institution_size_id IS NULL))) THEN

Line 407: App_Exception.Raise_Exception;

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
411: ((new_references.special_interest_id IS NULL))) THEN

Line 421: App_Exception.Raise_Exception;

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
425: ((new_references.housing_id IS NULL))) THEN

Line 435: App_Exception.Raise_Exception;

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
439: ((new_references.institution_control_id IS NULL))) THEN

Line 449: App_Exception.Raise_Exception;

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

Line 610: App_Exception.Raise_Exception;

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

Line 621: App_Exception.Raise_Exception;

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

Line 632: App_Exception.Raise_Exception;

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

Line 643: App_Exception.Raise_Exception;

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

Line 654: App_Exception.Raise_Exception;

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

Line 665: App_Exception.Raise_Exception;

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

Line 676: App_Exception.Raise_Exception;

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

Line 687: App_Exception.Raise_Exception;

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

Line 698: App_Exception.Raise_Exception;

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

Line 709: App_Exception.Raise_Exception;

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

Line 720: App_Exception.Raise_Exception;

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

Line 731: App_Exception.Raise_Exception;

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

Line 769: App_Exception.Raise_Exception;

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

Line 862: App_Exception.Raise_Exception;

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;
866: Check_Parent_Existance;

Line 881: App_Exception.Raise_Exception;

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;
885: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 989: app_exception.raise_exception;

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;
993: Before_DML(

Line 1165: app_exception.raise_exception;

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;
1168: close c1;
1169: if ( ( (tlinfo.CERTAINTY_OF_CHOICE_ID = X_CERTAINTY_OF_CHOICE_ID)

Line 1238: app_exception.raise_exception;

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;
1242: Procedure UPDATE_ROW (

Line 1301: app_exception.raise_exception;

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',
1305: x_rowid=>X_ROWID,