[Home] [Help]
42: Open cur_old_ref_values;
43: Fetch cur_old_ref_values INTO old_references;
44: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
45: Close cur_old_ref_values;
46: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
47: IGS_GE_MSG_STACK.ADD;
48: App_Exception.Raise_Exception;
49: Return;
50: END IF;
142: new_references.acai_admission_appl_number,
143: new_references.acai_nominated_course_cd,
144: new_references.acai_sequence_number,
145: v_message_name) = FALSE THEN
146: Fnd_Message.Set_Name ('IGS', v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
154: IF IGS_RE_VAL_CA.resp_val_ca_upd(
155: new_references.person_id,
156: new_references.sca_course_cd,
157: v_message_name) = FALSE THEN
158: Fnd_Message.Set_Name ('IGS', v_message_name);
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162: END IF;
188: new_references.attendance_percentage,
189: NULL, -- commencement date should already be updated
190: v_message_name,
191: 'N') = FALSE THEN
192: Fnd_Message.Set_Name ('IGS', v_message_name);
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
211: new_references.attendance_percentage,
212: NULL, -- commencement date should already be updated
213: v_message_name,
214: 'N') = FALSE THEN
215: Fnd_Message.Set_Name ('IGS', v_message_name);
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: END IF;
219: END IF;
226: NVL(new_references.govt_type_of_activity_cd,'NULL')) THEN
227: IF IGS_RE_VAL_CA.resp_val_gtcc_closed (
228: new_references.govt_type_of_activity_cd,
229: v_message_name) = FALSE THEN
230: Fnd_Message.Set_Name ('IGS', v_message_name);
231: IGS_GE_MSG_STACK.ADD;
232: App_Exception.Raise_Exception;
233: END IF;
234: END IF;
244: new_references.acai_sequence_number,
245: new_references.research_topic,
246: v_message_name,
247: 'N') = FALSE THEN
248: Fnd_Message.Set_Name ('IGS', v_message_name);
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252: END IF;
257: IF IGS_RE_VAL_CA.resp_val_ca_sca_del (
258: old_references.person_id,
259: old_references.sca_course_cd,
260: v_message_name) = FALSE THEN
261: Fnd_Message.Set_Name ('IGS', v_message_name);
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: -- Validate ACAI link.
268: old_references.acai_admission_appl_number,
269: old_references.acai_nominated_course_cd,
270: old_references.acai_sequence_number,
271: v_message_name) = FALSE THEN
272: Fnd_Message.Set_Name ('IGS', v_message_name);
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: END IF;
399: New_References.sequence_number,
400: New_References.sca_course_cd,
401: New_References.attendance_percentage,
402: v_message_name) = FALSE THEN
403: Fnd_Message.Set_Name ('IGS', v_message_name);
404: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
405: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,'igs.plsql.igs_re_candidature_pkg.AfterStmtInsertUpdate5.ERR',FALSE);
406: END IF;
407: IGS_GE_MSG_STACK.ADD;
421: New_References.attendance_percentage,
422: NULL, -- commencement date
423: v_message_name,
424: 'N') = FALSE THEN
425: Fnd_Message.Set_Name ('IGS', v_message_name);
426: IGS_GE_MSG_STACK.ADD;
427: App_Exception.Raise_Exception;
428: END IF;
429: END IF;
440: New_References.attendance_percentage,
441: NULL, -- commencement date
442: v_message_name,
443: 'N') = FALSE THEN
444: Fnd_Message.Set_Name ('IGS', v_message_name);
445: IGS_GE_MSG_STACK.ADD;
446: App_Exception.Raise_Exception;
447: END IF;
448: END IF;
464: New_References.acai_admission_appl_number,
465: New_References.acai_nominated_course_cd,
466: New_References.acai_sequence_number,
467: v_message_name) = FALSE THEN
468: Fnd_Message.Set_Name ('IGS', v_message_name);
469: IGS_GE_MSG_STACK.ADD;
470: App_Exception.Raise_Exception;
471: END IF;
472: END IF;
489: New_References.acai_admission_appl_number,
490: New_References.acai_nominated_course_cd,
491: New_References.acai_sequence_number,
492: v_message_name) = FALSE THEN
493: Fnd_Message.Set_Name ('IGS', v_message_name);
494: IGS_GE_MSG_STACK.ADD;
495: App_Exception.Raise_Exception;
496: END IF;
497: END IF;
520: END IF;
521:
522: IF upper(column_name) = 'ACAI_NOMINATED_COURSE_CD' OR COLUMN_NAME IS NULL THEN
523: IF new_references.ACAI_NOMINATED_COURSE_CD <> upper(NEW_REFERENCES.ACAI_NOMINATED_COURSE_CD) then
524: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
525: IGS_GE_MSG_STACK.ADD;
526: App_Exception.Raise_Exception ;
527: END IF;
528: END IF;
527: END IF;
528: END IF;
529: IF upper(column_name) = 'GOVT_TYPE_OF_ACTIVITY_CD' OR COLUMN_NAME IS NULL THEN
530: IF new_references.GOVT_TYPE_OF_ACTIVITY_CD <> upper(NEW_REFERENCES.GOVT_TYPE_OF_ACTIVITY_CD) then
531: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
532: IGS_GE_MSG_STACK.ADD;
533: App_Exception.Raise_Exception ;
534: END IF;
535: END IF;
534: END IF;
535: END IF;
536: IF upper(column_name) = 'SCA_COURSE_CD' OR COLUMN_NAME IS NULL THEN
537: IF new_references.SCA_COURSE_CD <> upper(NEW_REFERENCES.SCA_COURSE_CD) then
538: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
539: IGS_GE_MSG_STACK.ADD;
540: App_Exception.Raise_Exception ;
541: END IF;
542: END IF;
541: END IF;
542: END IF;
543: IF upper(column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
544: IF new_references.SEQUENCE_NUMBER < 1 OR new_references.SEQUENCE_NUMBER > 999999 then
545: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
546: IGS_GE_MSG_STACK.ADD;
547: App_Exception.Raise_Exception ;
548: END IF;
549: END IF;
548: END IF;
549: END IF;
550: IF upper(column_name) = 'ACAI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
551: IF new_references.ACAI_SEQUENCE_NUMBER < 1 OR new_references.ACAI_SEQUENCE_NUMBER > 999999 then
552: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
553: IGS_GE_MSG_STACK.ADD;
554: App_Exception.Raise_Exception ;
555: END IF;
556: END IF;
555: END IF;
556: END IF;
557: IF upper(column_name) = 'ATTENDANCE_PERCENTAGE' OR COLUMN_NAME IS NULL THEN
558: IF new_references.ATTENDANCE_PERCENTAGE < 1 OR new_references.ATTENDANCE_PERCENTAGE > 100 then
559: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
560: IGS_GE_MSG_STACK.ADD;
561: App_Exception.Raise_Exception ;
562: END IF;
563: END IF;
581: new_references.acai_admission_appl_number,
582: new_references.acai_nominated_course_cd,
583: new_references.acai_sequence_number
584: ) THEN
585: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
586: IGS_GE_MSG_STACK.ADD;
587: App_Exception.Raise_Exception;
588: END IF;
589: END IF;
594: ELSE
595: IF NOT IGS_RE_GV_TOA_CLS_CD_PKG.Get_PK_For_Validation (
596: new_references.govt_type_of_activity_cd
597: ) THEN
598: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
599: IGS_GE_MSG_STACK.ADD;
600: App_Exception.Raise_Exception;
601: END IF;
602: END IF;
606: ELSE
607: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
608: new_references.person_id
609: ) THEN
610: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
611: IGS_GE_MSG_STACK.ADD;
612: App_Exception.Raise_Exception;
613: END IF;
614: END IF;
621: IF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (
622: new_references.person_id,
623: new_references.sca_course_cd
624: ) THEN
625: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
626: IGS_GE_MSG_STACK.ADD;
627: App_Exception.Raise_Exception;
628: END IF;
629: END IF;
704: Open cur_rowid;
705: Fetch cur_rowid INTO lv_rowid;
706: IF (cur_rowid%FOUND) THEN
707: Close cur_rowid;
708: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CA_ACAI_FK');
709: IGS_GE_MSG_STACK.ADD;
710: App_Exception.Raise_Exception;
711: Return;
712: END IF;
725: Open cur_rowid;
726: Fetch cur_rowid INTO lv_rowid;
727: IF (cur_rowid%FOUND) THEN
728: Close cur_rowid;
729: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CA_GTCC_FK');
730: IGS_GE_MSG_STACK.ADD;
731: App_Exception.Raise_Exception;
732: Return;
733: END IF;
745: Open cur_rowid;
746: Fetch cur_rowid INTO lv_rowid;
747: IF (cur_rowid%FOUND) THEN
748: Close cur_rowid;
749: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CA_PE_FK');
750: IGS_GE_MSG_STACK.ADD;
751: App_Exception.Raise_Exception;
752: Return;
753: END IF;
768: Open cur_rowid;
769: Fetch cur_rowid INTO lv_rowid;
770: IF (cur_rowid%FOUND) THEN
771: Close cur_rowid;
772: Fnd_Message.Set_Name ('IGS', 'IGS_RE_CA_SCA_FK');
773: IGS_GE_MSG_STACK.ADD;
774: App_Exception.Raise_Exception;
775: Return;
776: END IF;
835: new_references.person_id,
836: new_references.sequence_number
837: ) THEN
838:
839: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
840: IGS_GE_MSG_STACK.ADD;
841: App_Exception.Raise_Exception;
842: END IF;
843: Check_Constraints;
864: new_references.person_id,
865: new_references.sequence_number
866: ) THEN
867:
868: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
869: IGS_GE_MSG_STACK.ADD;
870: App_Exception.Raise_Exception;
871: END IF;
872: Check_Constraints;
961: else
962: X_PROGRAM_UPDATE_DATE := SYSDATE;
963: end if;
964: else
965: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
966: IGS_GE_MSG_STACK.ADD;
967: app_exception.raise_exception;
968: end if;
969: Before_DML (
1055: );
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1059: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1060: fnd_message.set_token ('ERR_CD', SQLCODE);
1061: igs_ge_msg_stack.add;
1062: igs_sc_gen_001.unset_ctx('R');
1063: app_exception.raise_exception;
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1059: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1060: fnd_message.set_token ('ERR_CD', SQLCODE);
1061: igs_ge_msg_stack.add;
1062: igs_sc_gen_001.unset_ctx('R');
1063: app_exception.raise_exception;
1064: ELSE
1101: open c1;
1102: fetch c1 into tlinfo;
1103: if (c1%notfound) then
1104: close c1;
1105: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1106: app_exception.raise_exception;
1107: return;
1108: end if;
1109: close c1;
1139: AND (X_INDUSTRY_LINKS is null)))
1140: ) then
1141: null;
1142: else
1143: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1144: app_exception.raise_exception;
1145: end if;
1146: return;
1147: end LOCK_ROW;
1182: if X_LAST_UPDATE_LOGIN is NULL then
1183: X_LAST_UPDATE_LOGIN := -1;
1184: end if;
1185: else
1186: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1187: IGS_GE_MSG_STACK.ADD;
1188: app_exception.raise_exception;
1189: end if;
1190: Before_DML (
1243: PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
1244: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
1245: where ROWID = X_ROWID;
1246: if (sql%notfound) then
1247: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1248: igs_ge_msg_stack.add;
1249: igs_sc_gen_001.unset_ctx('R');
1250: app_exception.raise_exception;
1251: end if;
1259: );
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: IF (SQLCODE = (-28115)) THEN
1263: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1264: fnd_message.set_token ('ERR_CD', SQLCODE);
1265: igs_ge_msg_stack.add;
1266: igs_sc_gen_001.unset_ctx('R');
1267: app_exception.raise_exception;
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: IF (SQLCODE = (-28115)) THEN
1263: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1264: fnd_message.set_token ('ERR_CD', SQLCODE);
1265: igs_ge_msg_stack.add;
1266: igs_sc_gen_001.unset_ctx('R');
1267: app_exception.raise_exception;
1268: ELSE
1346: END IF;
1347: delete from IGS_RE_CANDIDATURE_ALL
1348: where ROWID = X_ROWID;
1349: if (sql%notfound) then
1350: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1351: igs_ge_msg_stack.add;
1352: igs_sc_gen_001.unset_ctx('R');
1353: app_exception.raise_exception;
1354: end if;