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

Line 80: app_exception.raise_exception;

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

Line 159: app_exception.raise_exception;

155: )
156: ) THEN
157: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
158: igs_ge_msg_stack.add;
159: app_exception.raise_exception;
160: END IF;
161:
162: END check_uniqueness;
163:

Line 186: app_exception.raise_exception;

182: new_references.panel_code
183: ) THEN
184: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: END IF;
188:
189:
190: IF (((old_references.person_id = new_references.person_id)) OR

Line 200: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 222: app_exception.raise_exception;

218: new_references.sequence_number
219: ) THEN
220: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
221: igs_ge_msg_stack.add;
222: app_exception.raise_exception;
223: END IF;
224:
225: IF (((old_references.location_cd = new_references.location_cd)) OR
226: ((new_references.location_cd IS NULL))) THEN

Line 234: app_exception.raise_exception;

230: 'N'
231: ) THEN
232: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
233: igs_ge_msg_stack.add;
234: app_exception.raise_exception;
235: END IF;
236:
237: IF (((old_references.room_id = new_references.room_id)) OR
238: ((new_references.room_id IS NULL))) THEN

Line 246: app_exception.raise_exception;

242: 'N'
243: ) THEN
244: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: END IF;
248:
249: IF (((old_references.final_decision_code = new_references.final_decision_code) AND
250: (old_references.final_decision_type = new_references.final_decision_type)) OR

Line 261: app_exception.raise_exception;

257: 'N'
258: ) THEN
259: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
260: igs_ge_msg_stack.add;
261: app_exception.raise_exception;
262: END IF;
263:
264: END check_parent_existance;
265:

Line 395: app_exception.raise_exception;

391: IF (cur_rowid%FOUND) THEN
392: CLOSE cur_rowid;
393: fnd_message.set_name ('IGS', 'IGS_AD_PNLDTLS_PNL_FK');
394: igs_ge_msg_stack.add;
395: app_exception.raise_exception;
396: RETURN;
397: END IF;
398: CLOSE cur_rowid;
399:

Line 430: app_exception.raise_exception;

426: IF (cur_rowid%FOUND) THEN
427: CLOSE cur_rowid;
428: fnd_message.set_name ('IGS', 'IGS_AD_PNLDTLS_LOC_FK');
429: igs_ge_msg_stack.add;
430: app_exception.raise_exception;
431: RETURN;
432: END IF;
433: CLOSE cur_rowid;
434:

Line 465: app_exception.raise_exception;

461: IF (cur_rowid%FOUND) THEN
462: CLOSE cur_rowid;
463: fnd_message.set_name ('IGS', 'IGS_AD_PNLDTLS_ROOM_FK');
464: igs_ge_msg_stack.add;
465: app_exception.raise_exception;
466: RETURN;
467: END IF;
468: CLOSE cur_rowid;
469:

Line 502: app_exception.raise_exception;

498: IF (cur_rowid%FOUND) THEN
499: CLOSE cur_rowid;
500: fnd_message.set_name ('IGS', 'IGS_AD_PNLDTLS_CODE_CLS_FK');
501: igs_ge_msg_stack.add;
502: app_exception.raise_exception;
503: RETURN;
504: END IF;
505: CLOSE cur_rowid;
506:

Line 682: APP_EXCEPTION.RAISE_EXCEPTION;

678: IF c_panel_membr_exist%NOTFOUND THEN
679: CLOSE c_panel_membr_exist;
680: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PNL_NO_MBR'); -- Message: The panel inserted has no members.
681: IGS_GE_MSG_STACK.ADD;
682: APP_EXCEPTION.RAISE_EXCEPTION;
683: END IF;
684: IF c_panel_membr_exist%ISOPEN THEN
685: CLOSE c_panel_membr_exist;
686: END IF;

Line 694: APP_EXCEPTION.RAISE_EXCEPTION;

690: IF c_panel_type_code%NOTFOUND THEN
691: CLOSE c_panel_type_code;
692: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PNL_CLSD'); -- Message: The panel is closed or non-existing
693: IGS_GE_MSG_STACK.ADD;
694: APP_EXCEPTION.RAISE_EXCEPTION;
695: END IF;
696: CLOSE c_panel_type_code;
697:
698: --If process category step 'Screening required before Interview' is not selected for application category

Line 707: app_exception.raise_exception;

703: CLOSE c_apcs_step_exist;
704: IF l_panel_type_Code = 'SCREENING' THEN
705: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NO_SCRN_STEP'); -- Message: 'Screening required before Interview step
706: igs_ge_msg_stack.add; -- is not selected for this admission category
707: app_exception.raise_exception;
708: END IF;
709: ELSE
710: CLOSE c_apcs_step_exist;
711: IF l_panel_type_Code = 'INTERVIEW' THEN

Line 719: app_exception.raise_exception;

715: CLOSE c_final_decison;
716: fnd_message.set_name('IGS','IGS_AD_FNLSCRN_DEC_NOT_INTVW'); -- Message: Application cannot be assigned to interview panel
717: -- unless Final Screening decision for at least one panel is INTERVIEW
718: igs_ge_msg_stack.add;
719: app_exception.raise_exception;
720: END IF;
721: CLOSE c_final_decison;
722:
723: END IF;

Line 750: app_exception.raise_exception;

746: fnd_message.set_name('IGS','IGS_AD_NO_DECISION_CD_SETUP'); -- Message: Unable to assign panel members to the application instance.
747: fnd_message.set_token('CLASS_MEANING', l_class_meaning);
748: fnd_message.set_token('SYS_STAT_MEANING', l_sys_stat_meaning);
749: igs_ge_msg_stack.add;
750: app_exception.raise_exception;
751: ELSE
752: --defaulting final_decision_type, final_decision_type
753: new_references.final_decision_code := rec_dflt_panl_cd.name;
754: new_references.final_decision_type := rec_dflt_panl_cd.class;

Line 768: app_exception.raise_exception;

764: IF c_intvw_pnl_exsts%FOUND THEN
765: CLOSE c_intvw_pnl_exsts;
766: 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.
767: igs_ge_msg_stack.add;
768: app_exception.raise_exception;
769: END IF;
770: CLOSE c_intvw_pnl_exsts;
771: END IF;
772: END IF;

Line 785: app_exception.raise_exception;

781: IF c_mem_dec %FOUND THEN
782: CLOSE c_mem_dec;
783: fnd_message.set_name('IGS','IGS_AD_MEM_DEC_PEND');
784: igs_ge_msg_stack.add;
785: app_exception.raise_exception;
786: END IF;
787: CLOSE c_mem_dec;
788: END IF;
789:

Line 801: app_exception.raise_exception;

797: new_references.room_id IS NOT NULL)
798: THEN -- PANEL_MEMBER
799: fnd_message.set_name('IGS','IGS_AD_INVALID_PNL_LVL'); -- Message: Cannot record interview details at panel level as the panel code is mapped to a panel level of Panel Member.
800: igs_ge_msg_stack.add;
801: app_exception.raise_exception;
802: END IF;
803:
804: -- Check if member Decisions is mapped to the system defaulted Decisions of 'PENDING'
805: OPEN cur_chk_dflt_panl_cd;

Line 815: app_exception.raise_exception;

811: (new_references.final_decision_date IS NOT NULL AND new_references.final_decision_code IS NULL)) THEN
812: -- Decision Date must be entered if a Decision is entered. If the Decision is saved without Decision Date then raise an error message.
813: fnd_message.set_name('IGS','IGS_AD_MAND_DECISION_INFO'); -- Message: Decision and Decision Date must be entered.
814: igs_ge_msg_stack.add;
815: app_exception.raise_exception;
816: END IF;
817: ELSE
818: IF new_references.final_decision_date IS NOT NULL THEN
819: fnd_message.set_name('IGS','IGS_AD_MAND_DECISION_INFO'); -- Message: Decision and Decision Date must be entered.

Line 821: app_exception.raise_exception;

817: ELSE
818: IF new_references.final_decision_date IS NOT NULL THEN
819: fnd_message.set_name('IGS','IGS_AD_MAND_DECISION_INFO'); -- Message: Decision and Decision Date must be entered.
820: igs_ge_msg_stack.add;
821: app_exception.raise_exception;
822: END IF;
823: END IF;
824: IF cur_chk_dflt_panl_cd%ISOPEN THEN
825: CLOSE cur_chk_dflt_panl_cd;

Line 836: app_exception.raise_exception;

832: IF NVL(new_references.interview_date,sysdate) < l_appl_dt THEN
833: fnd_message.set_name('IGS','IGS_AD_APPL_DATE_ERROR'); -- NAME cannot be less than Application Date
834: fnd_message.set_token ('NAME',fnd_message.get_string('IGS','IGS_AD_INTVW_DATE')); -- Message: Decision Date
835: igs_ge_msg_stack.add;
836: app_exception.raise_exception;
837: END IF;
838:
839: IF new_references.final_decision_date IS NOT NULL THEN
840: -- Decision Date entered must be greater than or equal to the Application Date. Else raise an Error message.

Line 844: app_exception.raise_exception;

840: -- Decision Date entered must be greater than or equal to the Application Date. Else raise an Error message.
841: IF new_references.final_decision_date < l_appl_dt OR new_references.final_decision_date > SYSDATE THEN
842: fnd_message.set_name('IGS','IGS_AD_DECISION_DATE'); -- Decision Date Can Neither be greater than System Date nor be less than Application Date
843: igs_ge_msg_stack.add;
844: app_exception.raise_exception;
845: END IF;
846: END IF;
847:
848: END IF;

Line 859: APP_EXCEPTION.RAISE_EXCEPTION;

855: IF c_memb_exsts%NOTFOUND THEN
856: CLOSE c_memb_exsts;
857: FND_MESSAGE.SET_NAME('IGS','IGS_AD_NO_MBR_APPL_EXTS'); -- Message: Cannot update the final decision when no member exists for this panel.
858: IGS_GE_MSG_STACK.ADD;
859: APP_EXCEPTION.RAISE_EXCEPTION;
860: END IF;
861: CLOSE c_memb_exsts;
862: END IF;
863: END IF;

Line 875: app_exception.raise_exception;

871:
872: IF NVL(rec_chk_final_decision.closed_flag,'N') <> 'N' THEN
873: fnd_message.set_name('IGS','IGS_AD_PNL_IS_CLOSED'); -- Message: Closed panel details cannot be updated or deleted.
874: igs_ge_msg_stack.add;
875: app_exception.raise_exception;
876: END IF;
877: END IF;
878:
879: IF NVL(p_deleting,FALSE) THEN

Line 892: APP_EXCEPTION.RAISE_EXCEPTION;

888: IF c_panel_type_code%NOTFOUND THEN
889: CLOSE c_panel_type_code;
890: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PNL_CLSD'); -- Message: The panel is closed or non-existing
891: IGS_GE_MSG_STACK.ADD;
892: APP_EXCEPTION.RAISE_EXCEPTION;
893: END IF;
894: CLOSE c_panel_type_code;
895:
896: END IF;

Line 997: app_exception.raise_exception;

993: fnd_message.set_name('IGS','IGS_AD_NO_DECISION_CD_SETUP'); -- Message: Unable to assign panel members to the application instance.
994: fnd_message.set_token('CLASS_MEANING', l_class_meaning);
995: fnd_message.set_token('SYS_STAT_MEANING', l_sys_stat_meaning);
996: igs_ge_msg_stack.add;
997: app_exception.raise_exception;
998: END IF;
999:
1000: IF cur_dflt_panl_cd%ISOPEN THEN
1001: CLOSE cur_dflt_panl_cd;

Line 1200: app_exception.raise_exception;

1196: )
1197: ) THEN
1198: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1199: igs_ge_msg_stack.add;
1200: app_exception.raise_exception;
1201: END IF;
1202: beforerowinsertupdatedelete1( p_inserting => TRUE , p_updating => FALSE, p_deleting=> FALSE);
1203: check_uniqueness;
1204: check_parent_existance;

Line 1222: app_exception.raise_exception;

1218: )
1219: ) THEN
1220: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1221: igs_ge_msg_stack.add;
1222: app_exception.raise_exception;
1223: END IF;
1224: beforerowinsertupdatedelete1( p_inserting => TRUE , p_updating => FALSE, p_deleting=> FALSE);
1225: check_uniqueness;
1226: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 1310: app_exception.raise_exception;

1306: ELSE
1307: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1308: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_DTLS_PKG.INSERT_ROW');
1309: igs_ge_msg_stack.add;
1310: app_exception.raise_exception;
1311: END IF;
1312:
1313: x_panel_dtls_id := NULL;
1314:

Line 1467: app_exception.raise_exception;

1463: -- that the ownerof policy function does not have privilege to access.
1464: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1465: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1466: IGS_GE_MSG_STACK.ADD;
1467: app_exception.raise_exception;
1468: ELSE
1469: RAISE;
1470: END IF;
1471: END insert_row;

Line 1571: app_exception.raise_exception;

1567: IF (c1%notfound) THEN
1568: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1569: igs_ge_msg_stack.add;
1570: CLOSE c1;
1571: app_exception.raise_exception;
1572: RETURN;
1573: END IF;
1574: CLOSE c1;
1575:

Line 1616: app_exception.raise_exception;

1612: NULL;
1613: ELSE
1614: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1615: igs_ge_msg_stack.add;
1616: app_exception.raise_exception;
1617: END IF;
1618:
1619: RETURN;
1620:

Line 1697: app_exception.raise_exception;

1693: ELSE
1694: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1695: fnd_message.set_token ('ROUTINE', 'IGS_AD_PANEL_DTLS_PKG.UPDATE_ROW');
1696: igs_ge_msg_stack.add;
1697: app_exception.raise_exception;
1698: END IF;
1699:
1700: before_dml(
1701: p_action => 'UPDATE',

Line 1795: app_exception.raise_exception;

1791: igs_ge_msg_stack.add;
1792: IF (x_mode = 'S') THEN
1793: igs_sc_gen_001.unset_ctx('R');
1794: END IF;
1795: app_exception.raise_exception;
1796: END IF;
1797: IF (x_mode = 'S') THEN
1798: igs_sc_gen_001.unset_ctx('R');
1799: END IF;

Line 1818: app_exception.raise_exception;

1814: -- that the ownerof policy function does not have privilege to access.
1815: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1816: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
1817: IGS_GE_MSG_STACK.ADD;
1818: app_exception.raise_exception;
1819: ELSE
1820: RAISE;
1821: END IF;
1822: END update_row;

Line 2004: app_exception.raise_exception;

2000: igs_ge_msg_stack.add;
2001: IF (x_mode = 'S') THEN
2002: igs_sc_gen_001.unset_ctx('R');
2003: END IF;
2004: app_exception.raise_exception;
2005: END IF;
2006: IF (x_mode = 'S') THEN
2007: igs_sc_gen_001.unset_ctx('R');
2008: END IF;

Line 2025: app_exception.raise_exception;

2021: -- that the ownerof policy function does not have privilege to access.
2022: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
2023: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
2024: IGS_GE_MSG_STACK.ADD;
2025: app_exception.raise_exception;
2026: ELSE
2027: RAISE;
2028: END IF;
2029: END delete_row;