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_EN_SPA_TERMS_PKG dependencies on FND_MESSAGE

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

74: OPEN cur_old_ref_values;
75: FETCH cur_old_ref_values INTO old_references;
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;

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

155: ELSIF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (
156: new_references.person_id,
157: new_references.program_cd
158: ) THEN
159: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
160: IGS_GE_MSG_STACK.ADD;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162: END IF;
163:

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

169: ELSIF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
170: new_references.TERM_CAL_TYPE,
171: new_references.TERM_SEQUENCE_NUMBER
172: ) THEN
173: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177:

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

181: ELSE
182: IF NOT IGS_PS_OFR_OPT_PKG.Get_UK_For_Validation (
183: new_references.coo_id
184: ) THEN
185: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: END IF;

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

193: NULL;
194: ELSIF NOT IGS_FI_FEE_CAT_PKG.Get_PK_For_Validation (
195: new_references.fee_cat
196: ) THEN
197: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201:

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

204: NULL;
205: ELSIF NOT IGS_PR_CLASS_STD_PKG.Get_PK_For_Validation (
206: new_references.CLASS_STANDING_ID
207: ) THEN
208: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: END IF;
212:

Line 243: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_CI_FK');

239: BEGIN
240: OPEN cur_rowid;
241: FETCH cur_rowid INTO lv_rowid;
242: IF (cur_rowid%FOUND) THEN
243: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_CI_FK');
244: Igs_Ge_Msg_Stack.ADD;
245: CLOSE cur_rowid;
246: App_Exception.Raise_Exception;
247: RETURN;

Line 275: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_SPA_FK');

271: BEGIN
272: OPEN cur_rowid;
273: FETCH cur_rowid INTO lv_rowid;
274: IF (cur_rowid%FOUND) THEN
275: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_SPA_FK');
276: IGS_GE_MSG_STACK.ADD;
277: CLOSE cur_rowid;
278: APP_EXCEPTION.RAISE_EXCEPTION;
279: RETURN;

Line 308: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_CS_FK');

304: OPEN cur_rowid;
305: FETCH cur_rowid INTO lv_cur;
306: IF (cur_rowid%FOUND) THEN
307: CLOSE cur_rowid;
308: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_CS_FK');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: RETURN;
312: END IF;

Line 338: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_FC_FK');

334: OPEN cur_rowid;
335: FETCH cur_rowid INTO lv_rowid;
336: IF (cur_rowid%FOUND) THEN
337: CLOSE cur_rowid;
338: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_FC_FK');
339: IGS_GE_MSG_STACK.ADD;
340: App_Exception.Raise_Exception;
341: RETURN;
342: END IF;

Line 368: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_COO_FK');

364: OPEN cur_rowid;
365: FETCH cur_rowid INTO lv_rowid;
366: IF (cur_rowid%FOUND) THEN
367: CLOSE cur_rowid;
368: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SPAT_COO_FK');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: RETURN;
372: END IF;

Line 639: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

635: IF ( get_pk_for_validation(
636: new_references.term_record_id
637: )
638: ) THEN
639: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
640: igs_ge_msg_stack.add;
641: app_exception.raise_exception;
642: END IF;
643:

Line 658: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

654: IF ( get_pk_for_validation (
655: new_references.term_record_id
656: )
657: ) THEN
658: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
659: igs_ge_msg_stack.add;
660: app_exception.raise_exception;
661: END IF;
662: ELSIF (p_action = 'DELETE') THEN

Line 683: fnd_message.set_name('IGS','IGS_AD_NOMINATED_PRG_NOTEXIST');

679: OPEN cur_rowid(new_references.coo_id ,new_references.term_cal_type,new_references.term_sequence_number);
680: FETCH cur_rowid INTO l_val;
681: IF (cur_rowid%NOTFOUND) THEN
682: CLOSE cur_rowid;
683: fnd_message.set_name('IGS','IGS_AD_NOMINATED_PRG_NOTEXIST');
684: igs_ge_msg_stack.add;
685: app_exception.raise_exception;
686: END IF;
687: CLOSE cur_rowid;

Line 782: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

778: ELSE
779: x_program_update_date := sysdate;
780: END IF;
781: ELSE
782: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
783: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.INSERT_ROW');
784: igs_ge_msg_stack.add;
785: app_exception.raise_exception;
786: END IF;

Line 783: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.INSERT_ROW');

779: x_program_update_date := sysdate;
780: END IF;
781: ELSE
782: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
783: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.INSERT_ROW');
784: igs_ge_msg_stack.add;
785: app_exception.raise_exception;
786: END IF;
787:

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

937:
938: EXCEPTION
939: WHEN OTHERS THEN
940: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
941: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
942: fnd_message.set_token ('ERR_CD', SQLCODE);
943: igs_ge_msg_stack.add;
944: igs_sc_gen_001.unset_ctx('R');
945: app_exception.raise_exception;

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

938: EXCEPTION
939: WHEN OTHERS THEN
940: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
941: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
942: fnd_message.set_token ('ERR_CD', SQLCODE);
943: igs_ge_msg_stack.add;
944: igs_sc_gen_001.unset_ctx('R');
945: app_exception.raise_exception;
946: ELSE

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

1045:
1046: OPEN c1;
1047: FETCH c1 INTO tlinfo;
1048: IF (c1%notfound) THEN
1049: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1050: igs_ge_msg_stack.add;
1051: CLOSE c1;
1052: app_exception.raise_exception;
1053: RETURN;

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

1092: AND (tlinfo.plan_sht_status = x_plan_sht_status)
1093: ) THEN
1094: NULL;
1095: ELSE
1096: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1097: igs_ge_msg_stack.add;
1098: app_exception.raise_exception;
1099: END IF;
1100:

Line 1179: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

1175: IF (x_last_update_login IS NULL) THEN
1176: x_last_update_login := -1;
1177: END IF;
1178: ELSE
1179: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1180: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.UPDATE_ROW');
1181: igs_ge_msg_stack.add;
1182: app_exception.raise_exception;
1183: END IF;

Line 1180: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.UPDATE_ROW');

1176: x_last_update_login := -1;
1177: END IF;
1178: ELSE
1179: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1180: fnd_message.set_token ('ROUTINE', 'IGS_EN_SPA_TERMS_PKG.UPDATE_ROW');
1181: igs_ge_msg_stack.add;
1182: app_exception.raise_exception;
1183: END IF;
1184:

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

1291: plan_sht_status = new_references.plan_sht_status
1292: WHERE rowid = x_rowid;
1293:
1294: IF (SQL%NOTFOUND) THEN
1295: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1296: igs_ge_msg_stack.add;
1297: igs_sc_gen_001.unset_ctx('R');
1298: app_exception.raise_exception;
1299: END IF;

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

1305:
1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: IF (SQLCODE = (-28115)) THEN
1309: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1310: fnd_message.set_token ('ERR_CD', SQLCODE);
1311: igs_ge_msg_stack.add;
1312: igs_sc_gen_001.unset_ctx('R');
1313: app_exception.raise_exception;

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

1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: IF (SQLCODE = (-28115)) THEN
1309: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1310: fnd_message.set_token ('ERR_CD', SQLCODE);
1311: igs_ge_msg_stack.add;
1312: igs_sc_gen_001.unset_ctx('R');
1313: app_exception.raise_exception;
1314: ELSE

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

1493: DELETE FROM igs_en_spa_terms
1494: WHERE rowid = x_rowid;
1495:
1496: IF (SQL%NOTFOUND) THEN
1497: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1498: igs_ge_msg_stack.add;
1499: igs_sc_gen_001.unset_ctx('R');
1500: app_exception.raise_exception;
1501: END IF;