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 FND_MESSAGE

Line 60: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

56: Open cur_old_ref_values;
57: Fetch cur_old_ref_values INTO old_references;
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;

Line 213: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROSPCT_XST_NO_EVAL');

209: OPEN pros_eval_cur(p_person_id,'PROSPECT');
210: FETCH pros_eval_cur INTO l_pros_eval_exist;
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;

Line 225: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EVAL_XST_NO_PROSPCT');

221: OPEN pros_eval_cur(p_person_id,'EVALUATOR');
222: FETCH pros_eval_cur INTO l_pros_eval_exist;
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;

Line 345: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSON_TYPE_N_MAPPED');

341: person_type_rec person_type_cur%ROWTYPE;
342: BEGIN
343: -- No need to show the System Type when code is passed as null.
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;

Line 346: FND_MESSAGE.SET_TOKEN('SYSTEM_TYPE',NULL);

342: BEGIN
343: -- No need to show the System Type when code is passed as null.
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:

Line 369: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSON_TYPE_N_MAPPED');

365: CLOSE meaning_cur;
366:
367: meaning_rec.meaning := ''''||meaning_rec.meaning||'''';
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

Line 370: FND_MESSAGE.SET_TOKEN('SYSTEM_TYPE',meaning_rec.meaning);

366:
367: meaning_rec.meaning := ''''||meaning_rec.meaning||'''';
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;

Line 435: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

431: new_references.admission_appl_number,
432: new_references.nominated_course_cd,
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:

Line 446: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

442: NULL;
443: ELSIF NOT Igs_Pe_Person_Types_Pkg.Get_PK_For_Validation (
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:

Line 460: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

456: ELSIF NOT Igs_Ps_Ver_Pkg.Get_PK_For_Validation (
457: new_references.course_cd,
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:

Line 471: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

467: NULL;
468: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
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:

Line 548: Fnd_Message.Set_Name ('IGS', 'IGS_PE_TYP_APPLINST');

544: Open cur_rowid;
545: Fetch cur_rowid INTO lv_rowid;
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;

Line 585: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PTI_PPT_FK');

581: Open cur_rowid;
582: Fetch cur_rowid INTO lv_rowid;
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;

Line 624: Fnd_Message.Set_Name ('IGS', 'IGS_PE_TYP_VER');

620: Open cur_rowid;
621: Fetch cur_rowid INTO lv_rowid;
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;

Line 661: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PTI_PE_FK');

657: Open cur_rowid;
658: Fetch cur_rowid INTO lv_rowid;
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;

Line 832: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_CHECK_MAND_DATA');

828:
829: IF lnRows = 0 THEN
830: -- Next line modified due to Bug no# 1496059
831: DBMS_SQL.CLOSE_CURSOR(l_Ext_Cursor);
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;

Line 833: FND_MESSAGE.SET_TOKEN ('Person_Type_Code', INITCAP(c_Mand_Emt.person_type_code));

829: IF lnRows = 0 THEN
830: -- Next line modified due to Bug no# 1496059
831: DBMS_SQL.CLOSE_CURSOR(l_Ext_Cursor);
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:

Line 834: FND_MESSAGE.SET_TOKEN ('DataElement', lv_DataEmt);

830: -- Next line modified due to Bug no# 1496059
831: DBMS_SQL.CLOSE_CURSOR(l_Ext_Cursor);
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;

Line 919: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

915: -- Call all the procedures related to Before Insert.
916: Null;
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;

Line 946: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_INVALID_FUNSTAT');

942: -- Added the following code for the Bug 2168915
943:
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

Line 952: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_INVALID_FUNSTAT');

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');
953: IGS_GE_MSG_STACK.ADD;
954: APP_EXCEPTION.RAISE_EXCEPTION;
955: END IF;
956: END IF;

Line 973: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

969: ELSIF (p_action = 'VALIDATE_INSERT') THEN
970: -- Call all the procedures related to Before Insert.
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;

Line 1182: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

1178: if X_LAST_UPDATE_LOGIN is NULL then
1179: X_LAST_UPDATE_LOGIN := -1;
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:

Line 1281: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

1277: x_rowid => X_ROWID );
1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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;

Line 1282: fnd_message.set_token ('ERR_CD', SQLCODE);

1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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

Line 1349: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

1345: begin
1346: open c1;
1347: fetch c1 into tlinfo;
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;

Line 1402: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

1398: AND ((tlinfo.EMPLMNT_CATEGORY_CODE <> X_EMPLMNT_CATEGORY_CODE)
1399: OR ((tlinfo.EMPLMNT_CATEGORY_CODE is null)
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;

Line 1460: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

1456: if X_LAST_UPDATE_LOGIN is NULL then
1457: X_LAST_UPDATE_LOGIN := -1;
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(

Line 1513: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1509: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1510: EMPLMNT_CATEGORY_CODE = X_EMPLMNT_CATEGORY_CODE
1511: where ROWID = X_ROWID;
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;

Line 1530: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

1526: );
1527: EXCEPTION
1528: WHEN OTHERS THEN
1529: IF (SQLCODE = (-28115)) THEN
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;

Line 1531: fnd_message.set_token ('ERR_CD', SQLCODE);

1527: EXCEPTION
1528: WHEN OTHERS THEN
1529: IF (SQLCODE = (-28115)) THEN
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

Line 1655: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1651: END IF;
1652: delete from IGS_PE_TYP_INSTANCES_ALL
1653: where ROWID = X_ROWID;
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;