[Home] [Help]
61: AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
62: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
63: igs_ge_msg_stack.ADD;
64: CLOSE cur_old_ref_values;
65: app_exception.raise_exception;
66: RETURN;
67: END IF;
68: CLOSE cur_old_ref_values;
69: -- Populate New Values.
129: v_message_name
130: ) = FALSE THEN
131: fnd_message.set_name ('IGS', v_message_name);
132: igs_ge_msg_stack.ADD;
133: app_exception.raise_exception;
134: END IF;
135: --<
136: --
137: -- If the IGS_PS_UNIT version status is inactive then prevent inserts, updates and
143: v_message_name
144: ) = FALSE THEN
145: fnd_message.set_name ('IGS', v_message_name);
146: igs_ge_msg_stack.ADD;
147: app_exception.raise_exception;
148: END IF;
149: --<
150: --
151: -- If calendar instance is inactive, then prevent inserts, updates and
157: v_message_name
158: ) = 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: --<
164: --
165: -- If item is examinable then validate that reference is set.
173: 'ASSIGNMENT'
174: ) THEN
175: fnd_message.set_name ('IGS', 'IGS_AS_REF_ASSITEM_EXAM');
176: igs_ge_msg_stack.ADD;
177: app_exception.raise_exception;
178: END IF;
179: --<
180: --
181: -- Validate the examination calendar type/sequence number if they have
189: v_message_name
190: ) = FALSE THEN
191: fnd_message.set_name ('IGS', v_message_name);
192: igs_ge_msg_stack.ADD;
193: app_exception.raise_exception;
194: END IF;
195: END IF;
196: --<
197: IF p_inserting THEN
202: v_message_name
203: ) = FALSE THEN
204: fnd_message.set_name ('IGS', v_message_name);
205: igs_ge_msg_stack.ADD;
206: app_exception.raise_exception;
207: END IF;
208: --<
209: END IF;
210: END IF;
299: v_message_name
300: ) = FALSE THEN
301: fnd_message.set_name ('IGS', v_message_name);
302: igs_ge_msg_stack.ADD;
303: app_exception.raise_exception;
304: END IF;
305: ELSE
306: --
307: -- if record has not been deleted
322: v_message_name
323: ) = FALSE THEN
324: fnd_message.set_name ('IGS', v_message_name);
325: igs_ge_msg_stack.ADD;
326: app_exception.raise_exception;
327: END IF;
328: END IF;
329: END IF;
330: -- Save the rowid of the current row.
343: )
344: ) THEN
345: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
346: igs_ge_msg_stack.ADD;
347: app_exception.raise_exception;
348: END IF;
349: END IF;
350: IF (((old_references.exam_cal_type = new_references.exam_cal_type))
351: OR ((new_references.exam_cal_type IS NULL))
357: )
358: ) THEN
359: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
360: igs_ge_msg_stack.ADD;
361: app_exception.raise_exception;
362: END IF;
363: END IF;
364: IF (((old_references.exam_cal_type = new_references.exam_cal_type)
365: AND (old_references.exam_ci_sequence_number =
378: )
379: ) THEN
380: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
381: igs_ge_msg_stack.ADD;
382: app_exception.raise_exception;
383: END IF;
384: END IF;
385: IF (((old_references.unit_cd = new_references.unit_cd)
386: OR (old_references.version_number = new_references.version_number)
402: )
403: ) THEN
404: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
405: igs_ge_msg_stack.ADD;
406: app_exception.raise_exception;
407: END IF;
408: END IF;
409: END check_parent_existance;
410:
440: IF new_references.ci_sequence_number < 1
441: AND new_references.ci_sequence_number > 999999 THEN
442: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
443: igs_ge_msg_stack.ADD;
444: app_exception.raise_exception;
445: END IF;
446: END IF;
447: IF UPPER (column_name) = 'SEQUENCE_NUMBER'
448: OR column_name IS NULL THEN
449: IF new_references.sequence_number < 1
450: AND new_references.sequence_number > 999999 THEN
451: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
452: igs_ge_msg_stack.ADD;
453: app_exception.raise_exception;
454: END IF;
455: END IF;
456: IF UPPER (column_name) = 'EXAM_CI_SEQUENCE_NUMBER'
457: OR column_name IS NULL THEN
458: IF new_references.exam_ci_sequence_number < 1
459: AND new_references.exam_ci_sequence_number > 999999 THEN
460: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
461: igs_ge_msg_stack.ADD;
462: app_exception.raise_exception;
463: END IF;
464: END IF;
465: IF UPPER (column_name) = 'DFLT_ITEM_IND'
466: OR column_name IS NULL THEN
467: IF new_references.dflt_item_ind <> UPPER (new_references.dflt_item_ind)
468: OR new_references.dflt_item_ind NOT IN ('Y', 'N') THEN
469: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
470: igs_ge_msg_stack.ADD;
471: app_exception.raise_exception;
472: END IF;
473: END IF;
474: IF UPPER (column_name) = 'CAL_TYPE'
475: OR column_name IS NULL THEN
475: OR column_name IS NULL THEN
476: IF new_references.cal_type <> UPPER (new_references.cal_type) THEN
477: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
478: igs_ge_msg_stack.ADD;
479: app_exception.raise_exception;
480: END IF;
481: END IF;
482: IF UPPER (column_name) = 'DFLT_ITEM_IND'
483: OR column_name IS NULL THEN
483: OR column_name IS NULL THEN
484: IF new_references.dflt_item_ind <> UPPER (new_references.dflt_item_ind) THEN
485: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
486: igs_ge_msg_stack.ADD;
487: app_exception.raise_exception;
488: END IF;
489: END IF;
490: IF UPPER (column_name) = 'EXAM_CAL_TYPE'
491: OR column_name IS NULL THEN
491: OR column_name IS NULL THEN
492: IF new_references.exam_cal_type <> UPPER (new_references.exam_cal_type) THEN
493: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
494: igs_ge_msg_stack.ADD;
495: app_exception.raise_exception;
496: END IF;
497: END IF;
498: IF UPPER (column_name) = 'REFERENCE'
499: OR column_name IS NULL THEN
499: OR column_name IS NULL THEN
500: IF new_references.REFERENCE <> UPPER (new_references.REFERENCE) THEN
501: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
502: igs_ge_msg_stack.ADD;
503: app_exception.raise_exception;
504: END IF;
505: END IF;
506: IF UPPER (column_name) = 'UNIT_CD'
507: OR column_name IS NULL THEN
507: OR column_name IS NULL THEN
508: IF new_references.unit_cd <> UPPER (new_references.unit_cd) THEN
509: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
510: igs_ge_msg_stack.ADD;
511: app_exception.raise_exception;
512: END IF;
513: END IF;
514: END check_constraints;
515:
578: x_sequence_number => new_references.sequence_number
579: ) THEN
580: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
581: igs_ge_msg_stack.ADD;
582: app_exception.raise_exception;
583: END IF;
584: END check_uniqueness;
585:
586: PROCEDURE get_fk_igs_as_assessmnt_itm (x_ass_id IN NUMBER) AS
595: IF (cur_rowid%FOUND) THEN
596: fnd_message.set_name ('IGS', 'IGS_AS_UAI_AI_FK');
597: igs_ge_msg_stack.ADD;
598: CLOSE cur_rowid;
599: app_exception.raise_exception;
600: RETURN;
601: END IF;
602: CLOSE cur_rowid;
603: END get_fk_igs_as_assessmnt_itm;
614: IF (cur_rowid%FOUND) THEN
615: fnd_message.set_name ('IGS', 'IGS_AS_UAI_CAT_FK');
616: igs_ge_msg_stack.ADD;
617: CLOSE cur_rowid;
618: app_exception.raise_exception;
619: RETURN;
620: END IF;
621: CLOSE cur_rowid;
622: END get_fk_igs_ca_type;
638: IF (cur_rowid%FOUND) THEN
639: fnd_message.set_name ('IGS', 'IGS_AS_UAI_GS_FK');
640: igs_ge_msg_stack.ADD;
641: CLOSE cur_rowid;
642: app_exception.raise_exception;
643: RETURN;
644: END IF;
645: CLOSE cur_rowid;
646: END get_fk_igs_as_grd_schema;
661: IF (cur_rowid%FOUND) THEN
662: fnd_message.set_name ('IGS', 'IGS_AS_UAI_CI_FK');
663: igs_ge_msg_stack.ADD;
664: CLOSE cur_rowid;
665: app_exception.raise_exception;
666: RETURN;
667: END IF;
668: CLOSE cur_rowid;
669: END get_fk_igs_ca_inst;
709: IF (cur_rowid%FOUND) THEN
710: fnd_message.set_name ('IGS', 'IGS_AS_UAI_UOP_FK');
711: igs_ge_msg_stack.ADD;
712: CLOSE cur_rowid;
713: app_exception.raise_exception;
714: RETURN;
715: END IF;
716: CLOSE cur_rowid;
717: END get_fk_igs_ps_unit_ofr_pat;
730: IF (cur_rowid%FOUND) THEN
731: fnd_message.set_name ('IGS', 'IGS_AS_UAI_UAIG_FK');
732: igs_ge_msg_stack.ADD;
733: CLOSE cur_rowid;
734: app_exception.raise_exception;
735: RETURN;
736: END IF;
737: CLOSE cur_rowid;
738: END get_fk_igs_as_unit_ai_grp;
820: beforerowinsertupdate2 (p_inserting => TRUE);
821: IF get_pk_for_validation (new_references.unit_ass_item_id) THEN
822: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
823: igs_ge_msg_stack.ADD;
824: app_exception.raise_exception;
825: END IF;
826: check_uniqueness;
827: check_constraints;
828: check_parent_existance;
839: ELSIF (p_action = 'VALIDATE_INSERT') THEN
840: IF get_pk_for_validation (new_references.unit_ass_item_id) THEN
841: fnd_message.set_name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
842: igs_ge_msg_stack.ADD;
843: app_exception.raise_exception;
844: END IF;
845: check_constraints;
846: check_uniqueness;
847: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
940: END IF;
941: ELSE
942: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
943: igs_ge_msg_stack.ADD;
944: app_exception.raise_exception;
945: END IF;
946: before_dml (
947: p_action => 'INSERT',
948: x_rowid => x_rowid,
1099: IF (c1%NOTFOUND) THEN
1100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1101: igs_ge_msg_stack.ADD;
1102: CLOSE c1;
1103: app_exception.raise_exception;
1104: RETURN;
1105: END IF;
1106: CLOSE c1;
1107: IF ((TRUNC (tlinfo.ci_start_dt) = TRUNC (x_ci_start_dt))
1185: NULL;
1186: ELSE
1187: fnd_message.set_name ('FND', 'FORM_RECORD_CHANGED');
1188: igs_ge_msg_stack.ADD;
1189: app_exception.raise_exception;
1190: END IF;
1191:
1192: RETURN;
1193: END lock_row;
1247: END IF;
1248: ELSE
1249: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1250: igs_ge_msg_stack.ADD;
1251: app_exception.raise_exception;
1252: END IF;
1253: before_dml (
1254: p_action => 'UPDATE',
1255: x_rowid => x_rowid,