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 IGS_GE_MSG_STACK

Line 75: igs_ge_msg_stack.add;

71: FETCH cur_old_ref_values INTO old_references;
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;

Line 148: igs_ge_msg_stack.add;

144: ELSIF NOT igs_ad_panel_dtls_pkg.get_pk_for_validation (
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

Line 163: igs_ge_msg_stack.add;

159: new_references.member_decision_type ,
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

Line 175: igs_ge_msg_stack.add;

171: new_references.location_cd ,
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

Line 187: igs_ge_msg_stack.add;

183: new_references.room_id ,
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

Line 200: IGS_GE_MSG_STACK.ADD;

196: new_references.member_person_id
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:

Line 290: igs_ge_msg_stack.add;

286: FETCH cur_rowid INTO lv_rowid;
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;

Line 327: igs_ge_msg_stack.add;

323: FETCH cur_rowid INTO lv_rowid;
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;

Line 362: igs_ge_msg_stack.add;

358: FETCH cur_rowid INTO lv_rowid;
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;

Line 397: igs_ge_msg_stack.add;

393: FETCH cur_rowid INTO lv_rowid;
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;

Line 532: igs_ge_msg_stack.add;

528: FETCH c_interviewer_exist INTO l_interviewer_exist;
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;

Line 568: igs_ge_msg_stack.add;

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

Line 590: igs_ge_msg_stack.add;

586: IF ((new_references.member_decision_date IS NULL AND new_references.member_decision_code IS NOT NULL) OR
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

Line 596: igs_ge_msg_stack.add;

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

Line 611: igs_ge_msg_stack.add;

607:
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

Line 619: igs_ge_msg_stack.add;

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

Line 633: igs_ge_msg_stack.add;

629: rec_chk_final_decision.final_decision_type);
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:

Line 649: igs_ge_msg_stack.add;

645: FETCH c_intvw_pnl_exsts INTO intvw_pnl_exsts_rec;
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;

Line 662: igs_ge_msg_stack.add;

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

Line 679: igs_ge_msg_stack.add;

675: l_old_member_decision := igs_ad_gen_013.get_sys_code_status(old_references.member_decision_code,
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;

Line 702: igs_ge_msg_stack.add;

698: old_references.member_decision_type);
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;

Line 809: igs_ge_msg_stack.add;

805: new_references.member_person_id
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;

Line 830: igs_ge_msg_stack.add;

826: new_references.member_person_id
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

Line 910: igs_ge_msg_stack.add;

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

Line 1051: IGS_GE_MSG_STACK.ADD;

1047: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;

Line 1145: igs_ge_msg_stack.add;

1141: OPEN c1;
1142: FETCH c1 INTO tlinfo;
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;

Line 1186: igs_ge_msg_stack.add;

1182: ) THEN
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;

Line 1262: igs_ge_msg_stack.add;

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

Line 1348: igs_ge_msg_stack.add;

1344: WHERE rowid = x_rowid;
1345:
1346: IF (SQL%NOTFOUND) THEN
1347: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
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;

Line 1372: IGS_GE_MSG_STACK.ADD;

1368: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;

Line 1544: igs_ge_msg_stack.add;

1540: WHERE rowid = x_rowid;
1541:
1542: IF (SQL%NOTFOUND) THEN
1543: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
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;

Line 1568: IGS_GE_MSG_STACK.ADD;

1564: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
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;