[Home] [Help]
40: -- Populate Old Values.
41: Open cur_old_ref_values;
42: Fetch cur_old_ref_values INTO old_references;
43: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
44: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
45: IGS_GE_MSG_STACK.ADD;
46: Close cur_old_ref_values;
47: APP_EXCEPTION.RAISE_EXCEPTION;
48:
97: new_references.ese_id);
98: -- Validate the venue closed indicator.
99: IF igs_gr_val_gc.assp_val_ve_closed( new_references.venue_cd,
100: v_message_name) = FALSE THEN
101: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
102: IGS_GE_MSG_STACK.ADD;
103: APP_EXCEPTION.RAISE_EXCEPTION;
104: END IF;
105: -- Validate other elements on insert.
106: IF IGS_AS_VAL_EI.assp_val_ei_ins( new_references.exam_cal_type,
107: new_references.exam_ci_sequence_number,
108: new_references.ass_id,
109: v_message_name) = FALSE THEN
110: FND_MESSAGE.SET_NAME('IGS',V_MESSAGE_NAME);
111: IGS_GE_MSG_STACK.ADD;
112: APP_EXCEPTION.RAISE_EXCEPTION;
113: END IF;
114: END BeforeRowInsert1;
118: ((new_references.ass_id IS NULL))) THEN
119: NULL;
120: ELSIF NOT IGS_AS_ASSESSMNT_ITM_PKG.Get_PK_For_Validation (
121: new_references.ass_id ) THEN
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: APP_EXCEPTION.RAISE_EXCEPTION;
125:
126: END IF;
143: new_references.dt_alias,
144: new_references.dai_sequence_number,
145: new_references.start_time,
146: new_references.end_time ) THEN
147: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: APP_EXCEPTION.RAISE_EXCEPTION;
150:
151: END IF;
153: ((new_references.ese_id IS NULL))) THEN
154: NULL;
155: ELSIF NOT IGS_AS_EXAM_SESSION_PKG.Get_UK_For_Validation (
156: new_references.ese_id ) THEN
157: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
158: IGS_GE_MSG_STACK.ADD;
159: APP_EXCEPTION.RAISE_EXCEPTION;
160:
161: END IF;
163: ((new_references.collect_person_id IS NULL))) THEN
164: NULL;
165: ELSIF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
166: new_references.collect_person_id ) THEN
167: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: APP_EXCEPTION.RAISE_EXCEPTION;
170:
171: END IF;
173: ((new_references.venue_cd IS NULL))) THEN
174: NULL;
175: ELSIF NOT IGS_GR_VENUE_PKG.Get_PK_For_Validation (
176: new_references.venue_cd ) THEN
177: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
178: IGS_GE_MSG_STACK.ADD;
179: APP_EXCEPTION.RAISE_EXCEPTION;
180:
181: END IF;
248: BEGIN
249: Open cur_rowid;
250: Fetch cur_rowid INTO lv_rowid;
251: IF (cur_rowid%FOUND) THEN
252: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_AI_FK');
253: IGS_GE_MSG_STACK.ADD;
254: Close cur_rowid;
255: APP_EXCEPTION.RAISE_EXCEPTION;
256:
279: BEGIN
280: Open cur_rowid;
281: Fetch cur_rowid INTO lv_rowid;
282: IF (cur_rowid%FOUND) THEN
283: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_ESE_UFK');
284: IGS_GE_MSG_STACK.ADD;
285: Close cur_rowid;
286: APP_EXCEPTION.RAISE_EXCEPTION;
287:
300: BEGIN
301: Open cur_rowid;
302: Fetch cur_rowid INTO lv_rowid;
303: IF (cur_rowid%FOUND) THEN
304: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_ESE_UFK');
305: IGS_GE_MSG_STACK.ADD;
306: Close cur_rowid;
307: APP_EXCEPTION.RAISE_EXCEPTION;
308:
321: BEGIN
322: Open cur_rowid;
323: Fetch cur_rowid INTO lv_rowid;
324: IF (cur_rowid%FOUND) THEN
325: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_PE_FK');
326: IGS_GE_MSG_STACK.ADD;
327: Close cur_rowid;
328: APP_EXCEPTION.RAISE_EXCEPTION;
329:
342: BEGIN
343: Open cur_rowid;
344: Fetch cur_rowid INTO lv_rowid;
345: IF (cur_rowid%FOUND) THEN
346: Fnd_Message.Set_Name ('IGS', 'IGS_AS_EI_VE_FK');
347: IGS_GE_MSG_STACK.ADD;
348: Close cur_rowid;
349: APP_EXCEPTION.RAISE_EXCEPTION;
350:
417: new_references.dai_sequence_number,
418: new_references.start_time,
419: new_references.end_time ,
420: new_references.venue_cd ) THEN
421: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
422: IGS_GE_MSG_STACK.ADD;
423: APP_EXCEPTION.RAISE_EXCEPTION;
424: END IF;
425:
440: new_references.dai_sequence_number,
441: new_references.start_time,
442: new_references.end_time ,
443: new_references.venue_cd ) THEN
444: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
445: IGS_GE_MSG_STACK.ADD;
446: APP_EXCEPTION.RAISE_EXCEPTION;
447: END IF;
448:
504: if X_LAST_UPDATE_LOGIN is NULL then
505: X_LAST_UPDATE_LOGIN := -1;
506: end if;
507: else
508: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
509: IGS_GE_MSG_STACK.ADD;
510: APP_EXCEPTION.RAISE_EXCEPTION;
511: end if;
512: Before_DML(
630: begin
631: open c1;
632: fetch c1 into tlinfo;
633: if (c1%notfound) then
634: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
635: IGS_GE_MSG_STACK.ADD;
636: APP_EXCEPTION.RAISE_EXCEPTION;
637: close c1;
638: return;
663: AND (X_COMMENTS is null)))
664: ) then
665: null;
666: else
667: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
668: IGS_GE_MSG_STACK.ADD;
669: APP_EXCEPTION.RAISE_EXCEPTION;
670: end if;
671: return;
708: if X_LAST_UPDATE_LOGIN is NULL then
709: X_LAST_UPDATE_LOGIN := -1;
710: end if;
711: else
712: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
713: IGS_GE_MSG_STACK.ADD;
714: APP_EXCEPTION.RAISE_EXCEPTION;
715: end if;
716: Before_DML(
882:
883: IF upper(column_name) = 'DT_ALIAS' OR
884: column_name is null Then
885: IF new_references.DT_ALIAS <> UPPER(new_references.DT_ALIAS) Then
886: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
887: IGS_GE_MSG_STACK.ADD;
888: APP_EXCEPTION.RAISE_EXCEPTION;
889: END IF;
890: END IF;
890: END IF;
891: IF upper(column_name) = 'EXAM_CAL_TYPE' OR
892: column_name is null Then
893: IF new_references.EXAM_CAL_TYPE <> UPPER(new_references.EXAM_CAL_TYPE) Then
894: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
895: IGS_GE_MSG_STACK.ADD;
896: APP_EXCEPTION.RAISE_EXCEPTION;
897: END IF;
898: END IF;
898: END IF;
899: IF upper(column_name) = 'SPECIAL_SESSION_IND' OR
900: column_name is null Then
901: IF new_references.SPECIAL_SESSION_IND <> UPPER(new_references.SPECIAL_SESSION_IND) Then
902: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
903: IGS_GE_MSG_STACK.ADD;
904: APP_EXCEPTION.RAISE_EXCEPTION;
905: END IF;
906: END IF;
906: END IF;
907: IF upper(column_name) = 'VENUE_CD' OR
908: column_name is null Then
909: IF new_references.VENUE_CD <> UPPER(new_references.VENUE_CD) Then
910: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
911: IGS_GE_MSG_STACK.ADD;
912: APP_EXCEPTION.RAISE_EXCEPTION;
913: END IF;
914: END IF;
915:
916: IF upper(column_name) = 'DAI_SEQUENCE_NUMBER' OR
917: column_name is null Then
918: IF new_references.DAI_SEQUENCE_NUMBER < 1 OR new_references.DAI_SEQUENCE_NUMBER > 99999 Then
919: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
920: IGS_GE_MSG_STACK.ADD;
921: APP_EXCEPTION.RAISE_EXCEPTION;
922: END IF;
923: END IF;
924:
925: IF upper(column_name) = 'EXAM_CI_SEQUENCE_NUMBER' OR
926: column_name is null Then
927: IF new_references.EXAM_CI_SEQUENCE_NUMBER < 1 OR new_references.EXAM_CI_SEQUENCE_NUMBER> 99999 Then
928: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
929: IGS_GE_MSG_STACK.ADD;
930: APP_EXCEPTION.RAISE_EXCEPTION;
931: END IF;
932: END IF;
933:
934: IF upper(column_name) = 'SPECIAL_SESSION_IND' OR
935: column_name is null Then
936: IF new_references.SPECIAL_SESSION_IND NOT IN ('Y','N') Then
937: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
938: IGS_GE_MSG_STACK.ADD;
939: APP_EXCEPTION.RAISE_EXCEPTION;
940: END IF;
941: END IF;
941: END IF;
942: IF upper(column_name) = 'ESE_ID' OR
943: column_name is null Then
944: IF new_references.ESE_ID < 1 OR new_references.ESE_ID > 999999 Then
945: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
946: IGS_GE_MSG_STACK.ADD;
947: APP_EXCEPTION.RAISE_EXCEPTION;
948: END IF;
949: END IF;