DBA Data[Home] [Help]

APPS.IGS_AS_SC_ATMPT_ENR_PKG dependencies on FND_MESSAGE

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

32: -- Populate Old Values.
33: Open cur_old_ref_values;
34: Fetch cur_old_ref_values INTO old_references;
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: Close cur_old_ref_values;
39: APP_EXCEPTION.RAISE_EXCEPTION;
40:

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

73: ELSIF NOT IGS_CA_INST_PKG.Get_PK_For_Validation (
74: new_references.CAL_TYPE,
75: new_references.ci_sequence_number
76: ) THEN
77: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
78: IGS_GE_MSG_STACK.ADD;
79: APP_EXCEPTION.RAISE_EXCEPTION;
80: END IF;
81: IF (((old_references.ENROLMENT_CAT = new_references.ENROLMENT_CAT)) OR

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

83: NULL;
84: ELSIF NOT IGS_EN_ENROLMENT_CAT_PKG.Get_PK_For_Validation (
85: new_references.ENROLMENT_CAT
86: ) THEN
87: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
88: IGS_GE_MSG_STACK.ADD;
89: APP_EXCEPTION.RAISE_EXCEPTION;
90: END IF;
91: IF (((old_references.person_id = new_references.person_id) OR

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

96: ELSIF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (
97: new_references.person_id,
98: new_references.course_cd
99: ) THEN
100: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
101: IGS_GE_MSG_STACK.ADD;
102: APP_EXCEPTION.RAISE_EXCEPTION;
103: END IF;
104: END Check_Parent_Existance;

Line 145: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SCAE_CI_FK');

141: BEGIN
142: Open cur_rowid;
143: Fetch cur_rowid INTO lv_rowid;
144: IF (cur_rowid%FOUND) THEN
145: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SCAE_CI_FK');
146: IGS_GE_MSG_STACK.ADD;
147: Close cur_rowid;
148: APP_EXCEPTION.RAISE_EXCEPTION;
149:

Line 166: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SCAE_EC_FK');

162: BEGIN
163: Open cur_rowid;
164: Fetch cur_rowid INTO lv_rowid;
165: IF (cur_rowid%FOUND) THEN
166: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SCAE_EC_FK');
167: IGS_GE_MSG_STACK.ADD;
168: Close cur_rowid;
169: APP_EXCEPTION.RAISE_EXCEPTION;
170:

Line 189: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SCAE_SCA_FK');

185: BEGIN
186: Open cur_rowid;
187: Fetch cur_rowid INTO lv_rowid;
188: IF (cur_rowid%FOUND) THEN
189: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SCAE_SCA_FK');
190: IGS_GE_MSG_STACK.ADD;
191: Close cur_rowid;
192: APP_EXCEPTION.RAISE_EXCEPTION;
193:

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

239: NEW_REFERENCES.course_cd ,
240: NEW_REFERENCES.cal_type ,
241: NEW_REFERENCES.ci_sequence_number
242: ) THEN
243: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
244: IGS_GE_MSG_STACK.ADD;
245: APP_EXCEPTION.RAISE_EXCEPTION;
246: END IF;
247:

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

259: NEW_REFERENCES.person_id ,
260: NEW_REFERENCES.course_cd ,
261: NEW_REFERENCES.cal_type ,
262: NEW_REFERENCES.ci_sequence_number ) THEN
263: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
264: IGS_GE_MSG_STACK.ADD;
265: APP_EXCEPTION.RAISE_EXCEPTION;
266: END IF;
267:

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

322: else
323: X_PROGRAM_UPDATE_DATE := SYSDATE;
324: end if;
325: else
326: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
327: IGS_GE_MSG_STACK.ADD;
328: APP_EXCEPTION.RAISE_EXCEPTION;
329: end if;
330: Before_DML(

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

401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
405: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
406: fnd_message.set_token ('ERR_CD', SQLCODE);
407: igs_ge_msg_stack.add;
408: igs_sc_gen_001.unset_ctx('R');
409: app_exception.raise_exception;

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

402: EXCEPTION
403: WHEN OTHERS THEN
404: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
405: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
406: fnd_message.set_token ('ERR_CD', SQLCODE);
407: igs_ge_msg_stack.add;
408: igs_sc_gen_001.unset_ctx('R');
409: app_exception.raise_exception;
410: ELSE

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

437: begin
438: open c1;
439: fetch c1 into tlinfo;
440: if (c1%notfound) then
441: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
442: IGS_GE_MSG_STACK.ADD;
443: APP_EXCEPTION.RAISE_EXCEPTION;
444: close c1;
445: return;

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

460: AND (X_ENR_FORM_RECEIVED_DT is null)))
461: ) then
462: null;
463: else
464: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
465: IGS_GE_MSG_STACK.ADD;
466: APP_EXCEPTION.RAISE_EXCEPTION;
467: end if;
468: return;

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

501: if X_LAST_UPDATE_LOGIN is NULL then
502: X_LAST_UPDATE_LOGIN := -1;
503: end if;
504: else
505: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
506: IGS_GE_MSG_STACK.ADD;
507: APP_EXCEPTION.RAISE_EXCEPTION;
508: end if;
509: Before_DML(

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

554: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
555: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
556: where ROWID = X_ROWID;
557: if (sql%notfound) then
558: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: end if;

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

567:
568: EXCEPTION
569: WHEN OTHERS THEN
570: IF (SQLCODE = (-28115)) THEN
571: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
572: fnd_message.set_token ('ERR_CD', SQLCODE);
573: igs_ge_msg_stack.add;
574: igs_sc_gen_001.unset_ctx('R');
575: app_exception.raise_exception;

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

568: EXCEPTION
569: WHEN OTHERS THEN
570: IF (SQLCODE = (-28115)) THEN
571: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
572: fnd_message.set_token ('ERR_CD', SQLCODE);
573: igs_ge_msg_stack.add;
574: igs_sc_gen_001.unset_ctx('R');
575: app_exception.raise_exception;
576: ELSE

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

644: END IF;
645: delete from IGS_AS_SC_ATMPT_ENR
646: where ROWID = X_ROWID;
647: if (sql%notfound) then
648: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
649: igs_ge_msg_stack.add;
650: igs_sc_gen_001.unset_ctx('R');
651: app_exception.raise_exception;
652: end if;

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

673: END IF ;
674: IF upper(column_name) = 'CAL_TYPE' OR
675: column_name is null Then
676: IF new_references.CAL_TYPE <> UPPER(new_references.CAL_TYPE) Then
677: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
678: IGS_GE_MSG_STACK.ADD;
679: APP_EXCEPTION.RAISE_EXCEPTION;
680: END IF;
681: END IF;

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

682:
683: IF upper(column_name) = 'COURSE_CD' OR
684: column_name is null Then
685: IF new_references.COURSE_CD <> UPPER(new_references.COURSE_CD) Then
686: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
687: IGS_GE_MSG_STACK.ADD;
688: APP_EXCEPTION.RAISE_EXCEPTION;
689: END IF;
690: END IF;

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

690: END IF;
691: IF upper(column_name) = 'ENROLMENT_CAT' OR
692: column_name is null Then
693: IF new_references.ENROLMENT_CAT <> UPPER(new_references.ENROLMENT_CAT) Then
694: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
695: IGS_GE_MSG_STACK.ADD;
696: APP_EXCEPTION.RAISE_EXCEPTION;
697: END IF;
698: END IF;