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

Line 62: App_Exception.Raise_Exception;

58: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
59: Close cur_old_ref_values;
60: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
61: IGS_GE_MSG_STACK.ADD;
62: App_Exception.Raise_Exception;
63: Return;
64: END IF;
65: Close cur_old_ref_values;
66:

Line 215: APP_EXCEPTION.RAISE_EXCEPTION;

211: IF pros_eval_cur%FOUND THEN
212: CLOSE pros_eval_cur;
213: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROSPCT_XST_NO_EVAL');
214: IGS_GE_MSG_STACK.ADD;
215: APP_EXCEPTION.RAISE_EXCEPTION;
216: END IF;
217: CLOSE pros_eval_cur;
218:
219: ELSIF l_system_type = 'PROSPECT' THEN

Line 227: APP_EXCEPTION.RAISE_EXCEPTION;

223: IF pros_eval_cur%FOUND THEN
224: CLOSE pros_eval_cur;
225: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EVAL_XST_NO_PROSPCT');
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;
229: CLOSE pros_eval_cur;
230:
231: END IF;

Line 348: APP_EXCEPTION.RAISE_EXCEPTION;

344: IF new_references.person_type_code IS NULL THEN
345: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSON_TYPE_N_MAPPED');
346: FND_MESSAGE.SET_TOKEN('SYSTEM_TYPE',NULL);
347: IGS_GE_MSG_STACK.ADD;
348: APP_EXCEPTION.RAISE_EXCEPTION;
349: END IF;
350:
351: OPEN system_type_cur;
352: FETCH system_type_cur INTO system_type_rec;

Line 372: APP_EXCEPTION.RAISE_EXCEPTION;

368:
369: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSON_TYPE_N_MAPPED');
370: FND_MESSAGE.SET_TOKEN('SYSTEM_TYPE',meaning_rec.meaning);
371: IGS_GE_MSG_STACK.ADD;
372: APP_EXCEPTION.RAISE_EXCEPTION;
373: ELSE
374: CLOSE person_type_cur;
375: new_references.person_type_code := person_type_rec.person_type_code;
376: END IF;

Line 437: App_Exception.Raise_Exception;

433: new_references.sequence_number
434: ) THEN
435: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
436: IGS_GE_MSG_STACK.ADD;
437: App_Exception.Raise_Exception;
438: END IF;
439:
440: IF (((old_references.person_type_code = new_references.person_type_code)) OR
441: ((new_references.person_type_code IS NULL))) THEN

Line 448: App_Exception.Raise_Exception;

444: new_references.person_type_code
445: ) THEN
446: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
447: IGS_GE_MSG_STACK.ADD;
448: App_Exception.Raise_Exception;
449: END IF;
450:
451: IF (((old_references.course_cd = new_references.course_cd) AND
452: (old_references.cc_version_number = new_references.cc_version_number)) OR

Line 462: App_Exception.Raise_Exception;

458: new_references.cc_version_number
459: ) THEN
460: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
461: IGS_GE_MSG_STACK.ADD;
462: App_Exception.Raise_Exception;
463: END IF;
464:
465: IF (((old_references.person_id = new_references.person_id)) OR
466: ((new_references.person_id IS NULL))) THEN

Line 473: App_Exception.Raise_Exception;

469: new_references.person_id
470: ) THEN
471: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
472: IGS_GE_MSG_STACK.ADD;
473: App_Exception.Raise_Exception;
474: END IF;
475:
476: END Check_Parent_Existance;
477:

Line 550: App_Exception.Raise_Exception;

546: IF (cur_rowid%FOUND) THEN
547: Close cur_rowid;
548: Fnd_Message.Set_Name ('IGS', 'IGS_PE_TYP_APPLINST');
549: IGS_GE_MSG_STACK.ADD;
550: App_Exception.Raise_Exception;
551: Return;
552: END IF;
553: Close cur_rowid;
554:

Line 587: App_Exception.Raise_Exception;

583: IF (cur_rowid%FOUND) THEN
584: Close cur_rowid;
585: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PTI_PPT_FK');
586: IGS_GE_MSG_STACK.ADD;
587: App_Exception.Raise_Exception;
588: Return;
589: END IF;
590: Close cur_rowid;
591:

Line 626: App_Exception.Raise_Exception;

622: IF (cur_rowid%FOUND) THEN
623: Close cur_rowid;
624: Fnd_Message.Set_Name ('IGS', 'IGS_PE_TYP_VER');
625: IGS_GE_MSG_STACK.ADD;
626: App_Exception.Raise_Exception;
627: Return;
628: END IF;
629: Close cur_rowid;
630:

Line 663: App_Exception.Raise_Exception;

659: IF (cur_rowid%FOUND) THEN
660: Close cur_rowid;
661: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PTI_PE_FK');
662: IGS_GE_MSG_STACK.ADD;
663: App_Exception.Raise_Exception;
664: Return;
665: END IF;
666: Close cur_rowid;
667:

Line 836: App_Exception.Raise_Exception;

832: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_CHECK_MAND_DATA');
833: FND_MESSAGE.SET_TOKEN ('Person_Type_Code', INITCAP(c_Mand_Emt.person_type_code));
834: FND_MESSAGE.SET_TOKEN ('DataElement', lv_DataEmt);
835: IGS_GE_MSG_STACK.ADD;
836: App_Exception.Raise_Exception;
837:
838: END IF;
839:
840: DBMS_SQL.CLOSE_CURSOR(l_Ext_Cursor);

Line 921: App_Exception.Raise_Exception;

917: IF Get_Pk_For_Validation(
918: new_references.type_instance_id) THEN
919: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
920: IGS_GE_MSG_STACK.ADD;
921: App_Exception.Raise_Exception;
922: END IF;
923: Check_Constraints;
924: Check_Parent_Existance;
925: -- takes the current active person type code for the system person type

Line 948: APP_EXCEPTION.RAISE_EXCEPTION;

944: IF old_references.funnel_status = '300-INQUIRED' THEN
945: IF new_references.funnel_status <> '300-INQUIRED' THEN
946: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_INVALID_FUNSTAT');
947: IGS_GE_MSG_STACK.ADD;
948: APP_EXCEPTION.RAISE_EXCEPTION;
949: END IF;
950: ELSIF old_references.funnel_status = '200-CONTACTED' THEN
951: IF new_references.funnel_status = '100-IDENTIFIED' THEN
952: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_INVALID_FUNSTAT');

Line 954: APP_EXCEPTION.RAISE_EXCEPTION;

950: ELSIF old_references.funnel_status = '200-CONTACTED' THEN
951: IF new_references.funnel_status = '100-IDENTIFIED' THEN
952: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_INVALID_FUNSTAT');
953: IGS_GE_MSG_STACK.ADD;
954: APP_EXCEPTION.RAISE_EXCEPTION;
955: END IF;
956: END IF;
957:
958: Check_Mand_Person_Type (

Line 975: App_Exception.Raise_Exception;

971: IF Get_PK_For_Validation (
972: new_references.type_instance_id) THEN
973: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
974: IGS_GE_MSG_STACK.ADD;
975: App_Exception.Raise_Exception;
976: END IF;
977: Check_Constraints;
978: Check_Mand_Person_Type (
979: new_references.person_type_code,

Line 1184: app_exception.raise_exception;

1180: end if;
1181: else
1182: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1183: IGS_GE_MSG_STACK.ADD;
1184: app_exception.raise_exception;
1185: end if;
1186:
1187: select IGS_PE_TYPE_INSTANCES_S.NEXTVAL INTO x_type_instance_id FROM DUAL;
1188: Before_DML(

Line 1285: app_exception.raise_exception;

1281: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1282: fnd_message.set_token ('ERR_CD', SQLCODE);
1283: igs_ge_msg_stack.add;
1284: igs_sc_gen_001.unset_ctx('R');
1285: app_exception.raise_exception;
1286: ELSE
1287: igs_sc_gen_001.unset_ctx('R');
1288: RAISE;
1289: END IF;

Line 1352: app_exception.raise_exception;

1348: if (c1%notfound) then
1349: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1350: IGS_GE_MSG_STACK.ADD;
1351: close c1;
1352: app_exception.raise_exception;
1353: return;
1354: end if;
1355: close c1;
1356: if ( ( (tlinfo.PERSON_ID <> X_PERSON_ID)

Line 1404: app_exception.raise_exception;

1400: AND (X_EMPLMNT_CATEGORY_CODE is null)))
1401: ) then
1402: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1403: IGS_GE_MSG_STACK.ADD;
1404: app_exception.raise_exception;
1405: else
1406: null;
1407: end if;
1408: return;

Line 1462: app_exception.raise_exception;

1458: end if;
1459: else
1460: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1461: IGS_GE_MSG_STACK.ADD;
1462: app_exception.raise_exception;
1463: end if;
1464: Before_DML(
1465: p_action=>'UPDATE',
1466: x_rowid=>X_ROWID,

Line 1516: app_exception.raise_exception;

1512: if (sql%notfound) then
1513: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1514: igs_ge_msg_stack.add;
1515: igs_sc_gen_001.unset_ctx('R');
1516: app_exception.raise_exception;
1517: end if;
1518: IF (x_mode = 'S') THEN
1519: igs_sc_gen_001.unset_ctx('R');
1520: END IF;

Line 1534: app_exception.raise_exception;

1530: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1531: fnd_message.set_token ('ERR_CD', SQLCODE);
1532: igs_ge_msg_stack.add;
1533: igs_sc_gen_001.unset_ctx('R');
1534: app_exception.raise_exception;
1535: ELSE
1536: igs_sc_gen_001.unset_ctx('R');
1537: RAISE;
1538: END IF;

Line 1658: app_exception.raise_exception;

1654: if (sql%notfound) then
1655: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1656: igs_ge_msg_stack.add;
1657: igs_sc_gen_001.unset_ctx('R');
1658: app_exception.raise_exception;
1659: end if;
1660: IF (x_mode = 'S') THEN
1661: igs_sc_gen_001.unset_ctx('R');
1662: END IF;