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_PNMEMBR_DTLS_PKG dependencies on APP_EXCEPTION

Line 76: app_exception.raise_exception;

72: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
73: CLOSE cur_old_ref_values;
74: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
75: igs_ge_msg_stack.add;
76: app_exception.raise_exception;
77: RETURN;
78: END IF;
79: CLOSE cur_old_ref_values;
80:

Line 149: app_exception.raise_exception;

145: new_references.panel_dtls_id
146: ) THEN
147: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151:
152: IF (((old_references.member_decision_code = new_references.member_decision_code) AND
153: (old_references.member_decision_type = new_references.member_decision_type)) OR

Line 164: app_exception.raise_exception;

160: 'N'
161: ) THEN
162: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: END IF;
166:
167: IF (((old_references.location_cd = new_references.location_cd)) OR
168: ((new_references.location_cd IS NULL))) THEN

Line 176: app_exception.raise_exception;

172: 'N'
173: ) THEN
174: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: END IF;
178:
179: IF (((old_references.room_id = new_references.room_id)) OR
180: ((new_references.room_id IS NULL))) THEN

Line 188: app_exception.raise_exception;

184: 'N'
185: ) THEN
186: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
187: igs_ge_msg_stack.add;
188: app_exception.raise_exception;
189: END IF;
190:
191: IF (((old_references.member_person_id = new_references.member_person_id)) OR
192: ((new_references.member_person_id IS NULL))) THEN

Line 201: APP_EXCEPTION.RAISE_EXCEPTION;

197: )THEN
198: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
199: IGS_AD_GEN_001.SET_TOKEN('From IGS_PE_PERSON ->Parameter: Person_Id ');
200: IGS_GE_MSG_STACK.ADD;
201: APP_EXCEPTION.RAISE_EXCEPTION;
202: END IF;
203: END IF;
204:
205:

Line 291: app_exception.raise_exception;

287: IF (cur_rowid%FOUND) THEN
288: CLOSE cur_rowid;
289: fnd_message.set_name ('IGS', 'IGS_AD_PNLMBMR_PNDTLS_FK');
290: igs_ge_msg_stack.add;
291: app_exception.raise_exception;
292: RETURN;
293: END IF;
294: CLOSE cur_rowid;
295:

Line 328: app_exception.raise_exception;

324: IF (cur_rowid%FOUND) THEN
325: CLOSE cur_rowid;
326: fnd_message.set_name ('IGS', 'IGS_AD_PNLMBMR_CODE_CLS_FK');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: RETURN;
330: END IF;
331: CLOSE cur_rowid;
332:

Line 363: app_exception.raise_exception;

359: IF (cur_rowid%FOUND) THEN
360: CLOSE cur_rowid;
361: fnd_message.set_name ('IGS', 'IGS_AD_PNLMBMR_LOC_FK');
362: igs_ge_msg_stack.add;
363: app_exception.raise_exception;
364: RETURN;
365: END IF;
366: CLOSE cur_rowid;
367:

Line 398: app_exception.raise_exception;

394: IF (cur_rowid%FOUND) THEN
395: CLOSE cur_rowid;
396: fnd_message.set_name ('IGS', 'IGS_AD_PNLMBMR_ROOM_FK');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: RETURN;
400: END IF;
401: CLOSE cur_rowid;
402:

Line 533: app_exception.raise_exception;

529: IF c_interviewer_exist%NOTFOUND THEN
530: CLOSE c_interviewer_exist;
531: fnd_message.set_name('IGS','IGS_AD_NO_INTERVIEWER_PTY'); -- Message: The person you are adding does not have the person type of Interviewer.
532: igs_ge_msg_stack.add;
533: app_exception.raise_exception;
534: END IF;
535: IF c_interviewer_exist%ISOPEN THEN
536: CLOSE c_interviewer_exist;
537: END IF;

Line 569: app_exception.raise_exception;

565: fnd_message.set_name('IGS','IGS_AD_NO_DECISION_CD_SETUP'); -- Message: Unable to assign panel members to the application instance.
566: fnd_message.set_token('CLASS_MEANING', l_class_meaning);
567: fnd_message.set_token('SYS_STAT_MEANING', l_sys_stat_meaning);
568: igs_ge_msg_stack.add;
569: app_exception.raise_exception;
570: ELSE
571: --defaulting final_decision_type, final_decision_type
572: new_references.member_decision_code := rec_dflt_panlm_cd.name;
573: new_references.member_decision_type := rec_dflt_panlm_cd.class;

Line 591: app_exception.raise_exception;

587: (new_references.member_decision_date IS NOT NULL AND new_references.member_decision_code IS NULL)) THEN
588: -- Decision Date must be entered if a Decision is entered. If the Decision is saved without Decision Date then raise an error message.
589: fnd_message.set_name('IGS','IGS_AD_MAND_DECISION_INFO'); -- Message: Decision and Decision Date must be entered.
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593: ELSE
594: IF new_references.member_decision_date IS NOT NULL THEN
595: fnd_message.set_name('IGS','IGS_AD_MAND_DECISION_INFO'); -- Message: Decision and Decision Date must be entered.

Line 597: app_exception.raise_exception;

593: ELSE
594: IF new_references.member_decision_date IS NOT NULL THEN
595: fnd_message.set_name('IGS','IGS_AD_MAND_DECISION_INFO'); -- Message: Decision and Decision Date must be entered.
596: igs_ge_msg_stack.add;
597: app_exception.raise_exception;
598: END IF;
599: END IF;
600: IF cur_dflt_panl_cd%ISOPEN THEN
601: CLOSE cur_dflt_panl_cd;

Line 612: app_exception.raise_exception;

608: IF NVL(new_references.interview_date,sysdate) < l_appl_dt THEN
609: fnd_message.set_name('IGS','IGS_AD_APPL_DATE_ERROR'); -- NAME cannot be less than Application Date
610: fnd_message.set_token ('NAME',fnd_message.get_string('IGS','IGS_AD_INTVW_DATE')); -- Message: Decision Date
611: igs_ge_msg_stack.add;
612: app_exception.raise_exception;
613: END IF;
614:
615: IF new_references.member_decision_date IS NOT NULL THEN
616: -- Decision Date entered must be greater than or equal to the Application Date. Else raise an Error message.

Line 620: app_exception.raise_exception;

616: -- Decision Date entered must be greater than or equal to the Application Date. Else raise an Error message.
617: IF new_references.member_decision_date < l_appl_dt OR new_references.member_decision_date > SYSDATE THEN
618: fnd_message.set_name('IGS','IGS_AD_DECISION_DATE'); -- Decision Date Can Neither be greater than System Date nor be less than Application Date
619: igs_ge_msg_stack.add;
620: app_exception.raise_exception;
621: END IF;
622: END IF;
623: -- A screening decision for a reviewer may be updated if no final screening decision exists for the panel. Else raise an Error message.
624: -- Check final decision associated to panel code.

Line 634: app_exception.raise_exception;

630:
631: IF NVL(l_final_decision,'PENDING') <> 'PENDING' THEN
632: fnd_message.set_name('IGS','IGS_AD_PNL_FNL_DECISION_EXITS'); -- Message: Cannot update/insert panel member's information when the panel final decision is already recorded.
633: igs_ge_msg_stack.add;
634: app_exception.raise_exception;
635: END IF;
636: END IF;
637:
638: IF NVL(p_inserting,FALSE) OR NVL(p_updating,FALSE) OR NVL(p_deleting,FALSE) THEN

Line 650: app_exception.raise_exception;

646: IF c_intvw_pnl_exsts%FOUND THEN
647: CLOSE c_intvw_pnl_exsts;
648: fnd_message.set_name('IGS','IGS_AD_INTVW_PNL_EXITS'); -- Message: Cannot update screening information when interview panel is already associated to the application instance.
649: igs_ge_msg_stack.add;
650: app_exception.raise_exception;
651: END IF;
652: CLOSE c_intvw_pnl_exsts;
653: END IF;
654: -- If a panel is closed then the interviewer decisions cannot be entered/updated and adding/deleting of interviewers is prohibited.

Line 663: app_exception.raise_exception;

659:
660: IF NVL(rec_chk_final_decision.closed_flag,'N') <> 'N' THEN
661: fnd_message.set_name('IGS','IGS_AD_PNL_IS_CLOSED'); -- Message: Cannot update or delete a closed panel.
662: igs_ge_msg_stack.add;
663: app_exception.raise_exception;
664: END IF;
665: END IF;
666:
667: IF NVL(p_updating,FALSE) THEN

Line 680: app_exception.raise_exception;

676: old_references.member_decision_type);
677: IF l_old_member_decision = 'VOIDED' AND l_member_decision <> 'VOIDED' THEN
678: fnd_message.set_name('IGS','IGS_AD_NO_UPD_VOID_DECISION'); -- Message: Cannot update the reviewer's decision as it is mapped to a status of Voided.
679: igs_ge_msg_stack.add;
680: app_exception.raise_exception;
681: END IF;
682:
683: END IF;
684:

Line 703: app_exception.raise_exception;

699:
700: IF NVL(l_final_decision,'*') <> 'PENDING' OR NVL(l_member_decision,'*') <> 'PENDING' THEN
701: fnd_message.set_name('IGS','IGS_AD_PNL_DECISION_EXITS'); -- Message: Cannot delete the panel member when the decision is already recorded.
702: igs_ge_msg_stack.add;
703: app_exception.raise_exception;
704: END IF;
705: END IF;
706: END beforerowinsertupdatedelete1;
707:

Line 810: app_exception.raise_exception;

806: )
807: ) THEN
808: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
809: igs_ge_msg_stack.add;
810: app_exception.raise_exception;
811: END IF;
812: beforerowinsertupdatedelete1( p_inserting => TRUE , p_updating => FALSE, p_deleting=> FALSE);
813: check_parent_existance;
814: ELSIF (p_action = 'UPDATE') THEN

Line 831: app_exception.raise_exception;

827: )
828: ) THEN
829: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
830: igs_ge_msg_stack.add;
831: app_exception.raise_exception;
832: END IF;
833: beforerowinsertupdatedelete1( p_inserting => TRUE , p_updating => FALSE, p_deleting=> FALSE);
834: ELSIF (p_action = 'VALIDATE_DELETE') THEN
835: beforerowinsertupdatedelete1( p_inserting => FALSE , p_updating => FALSE, p_deleting=> TRUE);

Line 911: app_exception.raise_exception;

907: ELSE
908: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
909: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_DTLS_PKG.INSERT_ROW');
910: igs_ge_msg_stack.add;
911: app_exception.raise_exception;
912: END IF;
913:
914: before_dml(
915: p_action => 'INSERT',

Line 1052: app_exception.raise_exception;

1048: -- that the ownerof policy function does not have privilege to access.
1049: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1050: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1051: IGS_GE_MSG_STACK.ADD;
1052: app_exception.raise_exception;
1053: ELSE
1054: RAISE;
1055: END IF;
1056: END insert_row;

Line 1147: app_exception.raise_exception;

1143: IF (c1%notfound) THEN
1144: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1145: igs_ge_msg_stack.add;
1146: CLOSE c1;
1147: app_exception.raise_exception;
1148: RETURN;
1149: END IF;
1150: CLOSE c1;
1151:

Line 1187: app_exception.raise_exception;

1183: NULL;
1184: ELSE
1185: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1186: igs_ge_msg_stack.add;
1187: app_exception.raise_exception;
1188: END IF;
1189:
1190: RETURN;
1191:

Line 1263: app_exception.raise_exception;

1259: ELSE
1260: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1261: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_DTLS_PKG.UPDATE_ROW');
1262: igs_ge_msg_stack.add;
1263: app_exception.raise_exception;
1264: END IF;
1265:
1266: before_dml(
1267: p_action => 'UPDATE',

Line 1352: app_exception.raise_exception;

1348: igs_ge_msg_stack.add;
1349: IF (x_mode = 'S') THEN
1350: igs_sc_gen_001.unset_ctx('R');
1351: END IF;
1352: app_exception.raise_exception;
1353: END IF;
1354: IF (x_mode = 'S') THEN
1355: igs_sc_gen_001.unset_ctx('R');
1356: END IF;

Line 1373: app_exception.raise_exception;

1369: -- that the ownerof policy function does not have privilege to access.
1370: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1371: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1372: IGS_GE_MSG_STACK.ADD;
1373: app_exception.raise_exception;
1374: ELSE
1375: RAISE;
1376: END IF;
1377: END update_row;

Line 1548: app_exception.raise_exception;

1544: igs_ge_msg_stack.add;
1545: IF (x_mode = 'S') THEN
1546: igs_sc_gen_001.unset_ctx('R');
1547: END IF;
1548: app_exception.raise_exception;
1549: END IF;
1550: IF (x_mode = 'S') THEN
1551: igs_sc_gen_001.unset_ctx('R');
1552: END IF;

Line 1569: app_exception.raise_exception;

1565: -- that the ownerof policy function does not have privilege to access.
1566: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1567: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1568: IGS_GE_MSG_STACK.ADD;
1569: app_exception.raise_exception;
1570: ELSE
1571: RAISE;
1572: END IF;
1573: END delete_row;