[Home] [Help]
46: Open cur_old_ref_values;
47: Fetch cur_old_ref_values INTO old_references;
48: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_GE_MSG_STACK.ADD;
52: App_Exception.Raise_Exception;
53: Return;
54: END IF;
92: IF p_inserting THEN
93: -- Validate if IGS_RE_SCHOLARSHIP type is closed
94: IF IGS_RE_VAL_SCH.resp_val_scht_closed ( new_references.scholarship_type,
95: v_message_name) = FALSE THEN
96: Fnd_Message.Set_Name ('IGS', v_message_name);
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
103: -- Validate if start date is before end date
104: IF igs_ad_val_edtl.genp_val_strt_end_dt ( new_references.start_dt,
105: new_references.end_dt,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name ('IGS', v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
131: new_references.scholarship_type,
132: new_references.start_dt,
133: new_references.end_dt,
134: v_message_name) = FALSE THEN
135: Fnd_Message.Set_Name ('IGS', v_message_name);
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: END IF;
139: END IF;
156: END IF;
157:
158: IF upper(column_name) = 'SCHOLARSHIP_TYPE' OR COLUMN_NAME IS NULL THEN
159: IF new_references.SCHOLARSHIP_TYPE <> upper(NEW_REFERENCES.SCHOLARSHIP_TYPE) then
160: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception ;
163: END IF;
164: END IF;
163: END IF;
164: END IF;
165: IF upper(column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
166: IF new_references.CA_SEQUENCE_NUMBER < 1 OR new_references.CA_SEQUENCE_NUMBER > 999999 then
167: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception ;
170: END IF;
171: END IF;
170: END IF;
171: END IF;
172: IF upper(column_name) = 'DOLLAR_VALUE' OR COLUMN_NAME IS NULL THEN
173: IF new_references.DOLLAR_VALUE < 0 OR new_references.DOLLAR_VALUE > 999999.99 then
174: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception ;
177: END IF;
178: END IF;
191: IF NOT IGS_RE_CANDIDATURE_PKG.Get_PK_For_Validation (
192: new_references.person_id,
193: new_references.ca_sequence_number
194: ) THEN
195: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199:
205: ELSE
206: IF NOT IGS_RE_SCHL_TYPE_PKG.Get_PK_For_Validation (
207: new_references.scholarship_type
208: ) THEN
209: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END IF;
213:
266: Open cur_rowid;
267: Fetch cur_rowid INTO lv_rowid;
268: IF (cur_rowid%FOUND) THEN
269: Close cur_rowid;
270: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SCH_CA_FK');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: Return;
274: END IF;
292: Open cur_rowid;
293: Fetch cur_rowid INTO lv_rowid;
294: IF (cur_rowid%FOUND) THEN
295: Close cur_rowid;
296: Fnd_Message.Set_Name ('IGS', 'IGS_RE_SCH_SCHT_FK');
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: Return;
300: END IF;
351: new_references.ca_sequence_number,
352: new_references.scholarship_type,
353: new_references.start_dt
354: ) THEN
355: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: END IF;
359: Check_Constraints;
369: new_references.ca_sequence_number,
370: new_references.scholarship_type,
371: new_references.start_dt
372: ) THEN
373: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377: Check_Constraints;
430: if X_LAST_UPDATE_LOGIN is NULL then
431: X_LAST_UPDATE_LOGIN := -1;
432: end if;
433: else
434: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
435: IGS_GE_MSG_STACK.ADD;
436: app_exception.raise_exception;
437: end if;
438:
513:
514: EXCEPTION
515: WHEN OTHERS THEN
516: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
517: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
518: fnd_message.set_token ('ERR_CD', SQLCODE);
519: igs_ge_msg_stack.add;
520: igs_sc_gen_001.unset_ctx('R');
521: app_exception.raise_exception;
514: EXCEPTION
515: WHEN OTHERS THEN
516: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
517: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
518: fnd_message.set_token ('ERR_CD', SQLCODE);
519: igs_ge_msg_stack.add;
520: igs_sc_gen_001.unset_ctx('R');
521: app_exception.raise_exception;
522: ELSE
553: open c1;
554: fetch c1 into tlinfo;
555: if (c1%notfound) then
556: close c1;
557: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
558: app_exception.raise_exception;
559: return;
560: end if;
561: close c1;
578:
579: ) then
580: null;
581: else
582: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
583: app_exception.raise_exception;
584: end if;
585: return;
586: end LOCK_ROW;
615: if X_LAST_UPDATE_LOGIN is NULL then
616: X_LAST_UPDATE_LOGIN := -1;
617: end if;
618: else
619: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
620: IGS_GE_MSG_STACK.ADD;
621: app_exception.raise_exception;
622: end if;
623:
653: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
654: where ROWID = X_ROWID
655: ;
656: if (sql%notfound) then
657: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
658: igs_ge_msg_stack.add;
659: igs_sc_gen_001.unset_ctx('R');
660: app_exception.raise_exception;
661: end if;
666:
667: EXCEPTION
668: WHEN OTHERS THEN
669: IF (SQLCODE = (-28115)) THEN
670: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
671: fnd_message.set_token ('ERR_CD', SQLCODE);
672: igs_ge_msg_stack.add;
673: igs_sc_gen_001.unset_ctx('R');
674: app_exception.raise_exception;
667: EXCEPTION
668: WHEN OTHERS THEN
669: IF (SQLCODE = (-28115)) THEN
670: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
671: fnd_message.set_token ('ERR_CD', SQLCODE);
672: igs_ge_msg_stack.add;
673: igs_sc_gen_001.unset_ctx('R');
674: app_exception.raise_exception;
675: ELSE
750: END IF;
751: delete from IGS_RE_SCHOLARSHIP_ALL
752: where ROWID = X_ROWID;
753: if (sql%notfound) then
754: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
755: igs_ge_msg_stack.add;
756: igs_sc_gen_001.unset_ctx('R');
757: app_exception.raise_exception;
758: end if;