DBA Data[Home] [Help]

APPS.IGS_EN_STDNT_PS_INTM_PKG dependencies on FND_MESSAGE

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

64: Open cur_old_ref_values;
65: Fetch cur_old_ref_values INTO old_references;
66: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
67: Close cur_old_ref_values;
68: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
69: IGS_GE_MSG_STACK.ADD;
70: App_Exception.Raise_Exception;
71: Return;
72: END IF;

Line 150: fnd_message.set_name('IGS',v_message_name);

146: IF IGS_EN_VAL_SCI.enrp_val_sci_alwd (
147: new_references.person_id,
148: new_references.course_cd,
149: v_message_name) = FALSE THEN
150: fnd_message.set_name('IGS',v_message_name);
151: IGS_GE_MSG_STACK.ADD;
152: app_exception.raise_exception;
153: END IF;
154: -- Validate for start_dt > end_dt

Line 159: fnd_message.set_name('IGS',v_message_name);

155: IF igs_ad_val_edtl.genp_val_strt_end_dt (
156: new_references.start_dt,
157: new_references.end_dt,
158: v_message_name) = FALSE THEN
159: fnd_message.set_name('IGS',v_message_name);
160: IGS_GE_MSG_STACK.ADD;
161: app_exception.raise_exception;
162: END IF;
163: END IF;

Line 195: fnd_message.set_name('IGS',v_message_name);

191: NEW_REFERENCES.course_cd,
192: NEW_REFERENCES.start_dt,
193: NEW_REFERENCES.end_dt,
194: v_message_name) = FALSE THEN
195: fnd_message.set_name('IGS',v_message_name);
196: IGS_GE_MSG_STACK.ADD;
197: app_exception.raise_exception;
198: END IF;
199: END IF;

Line 285: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

281: IF upper(column_name) = 'VOLUNTARY_IND' OR
282: column_name is null then
283: if new_references.voluntary_ind not IN ('Y','N') OR
284: new_references.voluntary_ind <> upper(new_references.voluntary_ind) then
285: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
286: IGS_GE_MSG_STACK.ADD;
287: App_Exception.Raise_Exception;
288: end if;
289: end if;

Line 296: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

292: column_name is null THEN
293: IF new_references.COND_RETURN_FLAG NOT IN ('Y','N')
294: AND new_references.COND_RETURN_FLAG IS NOT NULL THEN
295: --
296: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: END IF;
300: END IF;

Line 305: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

301:
302: IF upper(column_name) = 'APPROVED' OR
303: column_name is null then
304: if new_references.approved NOT IN ('Y','N') THEN
305: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
306: IGS_GE_MSG_STACK.ADD;
307: App_Exception.Raise_Exception;
308: end if;
309: end if;

Line 314: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

310:
311: IF upper(column_name) = 'COURSE_CD' OR
312: column_name is null then
313: if new_references.course_cd <> upper(new_references.course_cd) then
314: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
315: IGS_GE_MSG_STACK.ADD;
316: App_Exception.Raise_Exception;
317: end if;
318: end if;

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

351: IF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (
352: new_references.person_id,
353: new_references.course_cd
354: ) Then
355: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: end if;
359: END IF;

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

364: ELSE
365: IF NOT IGS_EN_INTM_TYPES_PKG.Get_UK_For_Validation (
366: new_references.intermission_type
367: ) Then
368: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: end if;
372: END IF;

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

380: IF (cur_rowid_HP%FOUND) THEN
381: Close cur_rowid_HP;
382: ELSE
383: Close cur_rowid_HP;
384: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
385: IGS_GE_MSG_STACK.ADD;
386: App_Exception.Raise_Exception;
387: END IF;
388: END IF;

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

396: IF (cur_exists_ioie%FOUND) THEN
397: Close cur_exists_ioie;
398: ELSE
399: Close cur_exists_ioie;
400: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
401: IGS_GE_MSG_STACK.ADD;
402: App_Exception.Raise_Exception;
403: END IF;
404: END IF;

Line 460: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SCI_SCA_FK');

456: Open cur_rowid;
457: Fetch cur_rowid INTO lv_rowid;
458: IF (cur_rowid%FOUND) THEN
459: Close cur_rowid;
460: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SCI_SCA_FK');
461: IGS_GE_MSG_STACK.ADD;
462: Return;
463: END IF;
464: Close cur_rowid;

Line 593: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

589: new_references.course_cd ,
590: new_references.start_dt,
591: new_references.logical_delete_date
592: ) THEN
593: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
594: IGS_GE_MSG_STACK.ADD;
595: App_Exception.Raise_Exception;
596: end if;
597: Check_constraints;

Line 621: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

617: new_references.course_cd,
618: new_references.start_dt,
619: new_references.logical_delete_date
620: ) THEN
621: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
622: IGS_GE_MSG_STACK.ADD;
623: App_Exception.Raise_Exception;
624: end if;
625: Check_constraints;

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

736: if X_LAST_UPDATE_LOGIN is NULL then
737: X_LAST_UPDATE_LOGIN := -1;
738: end if;
739: else
740: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
741: IGS_GE_MSG_STACK.ADD;
742: app_exception.raise_exception;
743: end if;
744:

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

896:
897: EXCEPTION
898: WHEN OTHERS THEN
899: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
900: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
901: fnd_message.set_token ('ERR_CD', SQLCODE);
902: igs_ge_msg_stack.add;
903: igs_sc_gen_001.unset_ctx('R');
904: app_exception.raise_exception;

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

897: EXCEPTION
898: WHEN OTHERS THEN
899: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
900: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
901: fnd_message.set_token ('ERR_CD', SQLCODE);
902: igs_ge_msg_stack.add;
903: igs_sc_gen_001.unset_ctx('R');
904: app_exception.raise_exception;
905: ELSE

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

991: open c1;
992: fetch c1 into tlinfo;
993: if (c1%notfound) then
994: close c1;
995: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
996: IGS_GE_MSG_STACK.ADD;
997: app_exception.raise_exception;
998: return;
999: end if;

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

1092: AND (tlinfo.COND_RETURN_FLAG = X_COND_RETURN_FLAG)
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: return;

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

1157: if X_LAST_UPDATE_LOGIN is NULL then
1158: X_LAST_UPDATE_LOGIN := -1;
1159: end if;
1160: else
1161: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1162: IGS_GE_MSG_STACK.ADD;
1163: app_exception.raise_exception;
1164: end if;
1165:

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

1251: COND_RETURN_FLAG = NEW_REFERENCES.COND_RETURN_FLAG
1252: where ROWID = X_ROWID
1253: ;
1254: if (sql%notfound) then
1255: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1256: igs_ge_msg_stack.add;
1257: igs_sc_gen_001.unset_ctx('R');
1258: app_exception.raise_exception;
1259: end if;

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

1269: );
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: IF (SQLCODE = (-28115)) THEN
1273: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1274: fnd_message.set_token ('ERR_CD', SQLCODE);
1275: igs_ge_msg_stack.add;
1276: igs_sc_gen_001.unset_ctx('R');
1277: app_exception.raise_exception;

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

1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: IF (SQLCODE = (-28115)) THEN
1273: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1274: fnd_message.set_token ('ERR_CD', SQLCODE);
1275: igs_ge_msg_stack.add;
1276: igs_sc_gen_001.unset_ctx('R');
1277: app_exception.raise_exception;
1278: ELSE

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

1435: END IF;
1436: delete from IGS_EN_STDNT_PS_INTM
1437: where ROWID = X_ROWID;
1438: if (sql%notfound) then
1439: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1440: igs_ge_msg_stack.add;
1441: igs_sc_gen_001.unset_ctx('R');
1442: app_exception.raise_exception;
1443: end if;