[Home] [Help]
76: OPEN cur_old_ref_values;
77: FETCH cur_old_ref_values INTO old_references;
78: IF (cur_old_ref_values%NOTFOUND)
79: AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
80: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
81: igs_ge_msg_stack.ADD;
82: CLOSE cur_old_ref_values;
83: app_exception.raise_exception;
84: RETURN;
194: -- when status is completed.
195: IF v_message_name = 'IGS_CA_AA_CIR_FK' THEN
196: NULL;
197: END IF;
198: fnd_message.set_name ('IGS', v_message_name);
199: igs_ge_msg_stack.ADD;
200: app_exception.raise_exception;
201: END IF;
202: END IF;
213: CLOSE cp_tri;
214: IF v_s_tracking_type = cst_assignment THEN
215: IF v_s_tracking_status <> 'ACTIVE' THEN
216: -- Tracking item is no longer active
217: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
218: igs_ge_msg_stack.ADD;
219: app_exception.raise_exception;
220: ELSIF igs_tr_gen_002.trkp_upd_trst (
221: new_references.tracking_id,
229: v_message_name
230: ) = FALSE THEN
231: -- Reset the message to be in context of p_updating the override due dt.
232: IF v_message_name = 'IGS_GE_RECORD_ALREADY_EXISTS' THEN
233: fnd_message.set_name ('IGS', 'IGS_AD_TE_TELOC_FK');
234: igs_ge_msg_stack.ADD;
235: app_exception.raise_exception;
236: ELSE
237: fnd_message.set_name ('IGS', 'IGS_AD_TE_TELOC_FK');
233: fnd_message.set_name ('IGS', 'IGS_AD_TE_TELOC_FK');
234: igs_ge_msg_stack.ADD;
235: app_exception.raise_exception;
236: ELSE
237: fnd_message.set_name ('IGS', 'IGS_AD_TE_TELOC_FK');
238: igs_ge_msg_stack.ADD;
239: app_exception.raise_exception;
240: END IF;
241: END IF;
249: OR old_references.mark IS NOT NULL THEN
250: IF NVL (new_references.grade, 0) <> old_references.grade
251: OR NVL (new_references.mark, 0) <> old_references.mark THEN
252: IF new_references.outcome_comment_code IS NULL THEN
253: fnd_message.set_name ('IGS', 'IGS_AS_OUT_COM_MANDATORY');
254: igs_ge_msg_stack.ADD;
255: app_exception.raise_exception;
256: END IF;
257: END IF;
330: new_references.attempt_number,
331: v_message_name,
332: new_references.uoo_id
333: ) = FALSE THEN
334: fnd_message.set_name ('IGS', v_message_name);
335: igs_ge_msg_stack.ADD;
336: app_exception.raise_exception;
337: END IF;
338: -- Validate the attempt number is unique within the student's assessment item.
354: OR ((new_references.ass_id IS NULL))
355: ) THEN
356: NULL;
357: ELSIF NOT igs_as_assessmnt_itm_pkg.get_pk_for_validation (new_references.ass_id) THEN
358: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
359: igs_ge_msg_stack.ADD;
360: app_exception.raise_exception;
361: END IF;
362: IF (((old_references.person_id = new_references.sua_ass_item_group_id))
365: NULL;
366: ELSIF NOT igs_as_sua_ai_group_pkg.get_pk_for_validation (
367: new_references.sua_ass_item_group_id
368: ) THEN
369: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
370: igs_ge_msg_stack.ADD;
371: app_exception.raise_exception;
372: END IF;
373: IF (((old_references.tracking_id = new_references.tracking_id))
374: OR ((new_references.tracking_id IS NULL))
375: ) THEN
376: NULL;
377: ELSIF NOT igs_tr_item_pkg.get_pk_for_validation (new_references.tracking_id) THEN
378: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
379: igs_ge_msg_stack.ADD;
380: app_exception.raise_exception;
381: END IF;
382: END check_parent_existance;
447: BEGIN
448: OPEN cur_rowid;
449: FETCH cur_rowid INTO lv_rowid;
450: IF (cur_rowid%FOUND) THEN
451: fnd_message.set_name ('IGS', 'IGS_AS_SUAAI_AI_FK');
452: igs_ge_msg_stack.ADD;
453: CLOSE cur_rowid;
454: app_exception.raise_exception;
455: RETURN;
474: BEGIN
475: OPEN cur_rowid;
476: FETCH cur_rowid INTO lv_rowid;
477: IF (cur_rowid%FOUND) THEN
478: fnd_message.set_name ('IGS', 'IGS_AS_SUAAI_SUAIG_FK');
479: igs_ge_msg_stack.ADD;
480: CLOSE cur_rowid;
481: app_exception.raise_exception;
482: RETURN;
493: BEGIN
494: OPEN cur_rowid;
495: FETCH cur_rowid INTO lv_rowid;
496: IF (cur_rowid%FOUND) THEN
497: fnd_message.set_name ('IGS', 'IGS_AS_SUAAI_TRI_FK');
498: igs_ge_msg_stack.ADD;
499: CLOSE cur_rowid;
500: app_exception.raise_exception;
501: RETURN;
519: BEGIN
520: OPEN cur_rowid;
521: FETCH cur_rowid INTO lv_rowid;
522: IF (cur_rowid%FOUND) THEN
523: fnd_message.set_name ('IGS', 'IGS_AS_SUAAI_GSG_FK');
524: igs_ge_msg_stack.ADD;
525: CLOSE cur_rowid;
526: app_exception.raise_exception;
527: RETURN;
539: BEGIN
540: OPEN cur_rowid;
541: FETCH cur_rowid INTO lv_rowid;
542: IF (cur_rowid%FOUND) THEN
543: fnd_message.set_name ('IGS', 'IGS_AS_SUAAI_LOV_FK');
544: igs_ge_msg_stack.ADD;
545: CLOSE cur_rowid;
546: app_exception.raise_exception;
547: RETURN;
684: new_references.ass_id,
685: new_references.creation_dt,
686: new_references.uoo_id
687: ) THEN
688: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
689: igs_ge_msg_stack.ADD;
690: app_exception.raise_exception;
691: END IF;
692: check_constraints;
706: new_references.ass_id,
707: new_references.creation_dt,
708: new_references.uoo_id
709: ) THEN
710: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
711: igs_ge_msg_stack.ADD;
712: app_exception.raise_exception;
713: END IF;
714: check_constraints;
831: ELSE
832: x_program_update_date := SYSDATE;
833: END IF;
834: ELSE
835: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
836: igs_ge_msg_stack.ADD;
837: app_exception.raise_exception;
838: END IF;
839: before_dml (
956:
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
960: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
961: fnd_message.set_token ('ERR_CD', SQLCODE);
962: igs_ge_msg_stack.add;
963: igs_sc_gen_001.unset_ctx('R');
964: app_exception.raise_exception;
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
960: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
961: fnd_message.set_token ('ERR_CD', SQLCODE);
962: igs_ge_msg_stack.add;
963: igs_sc_gen_001.unset_ctx('R');
964: app_exception.raise_exception;
965: ELSE
1074: BEGIN
1075: OPEN c1;
1076: FETCH c1 INTO tlinfo;
1077: IF (c1%NOTFOUND) THEN
1078: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1079: igs_ge_msg_stack.ADD;
1080: app_exception.raise_exception;
1081: CLOSE c1;
1082: RETURN;
1296: )
1297: ) THEN
1298: NULL;
1299: ELSE
1300: fnd_message.set_name ('FND', 'FORM_RECORD_CHANGED');
1301: igs_ge_msg_stack.ADD;
1302: app_exception.raise_exception;
1303: END IF;
1304: RETURN;
1380: IF x_last_update_login IS NULL THEN
1381: x_last_update_login := -1;
1382: END IF;
1383: ELSE
1384: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1385: igs_ge_msg_stack.ADD;
1386: app_exception.raise_exception;
1387: END IF;
1388: before_dml (
1513: waived_flag = new_references.waived_flag,
1514: penalty_applied_flag = new_references.penalty_applied_flag
1515: WHERE ROWID = x_rowid;
1516: IF (SQL%NOTFOUND) THEN
1517: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1518: igs_ge_msg_stack.add;
1519: igs_sc_gen_001.unset_ctx('R');
1520: app_exception.raise_exception;
1521: END IF;
1527:
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF (SQLCODE = (-28115)) THEN
1531: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1532: fnd_message.set_token ('ERR_CD', SQLCODE);
1533: igs_ge_msg_stack.add;
1534: igs_sc_gen_001.unset_ctx('R');
1535: app_exception.raise_exception;
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF (SQLCODE = (-28115)) THEN
1531: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1532: fnd_message.set_token ('ERR_CD', SQLCODE);
1533: igs_ge_msg_stack.add;
1534: igs_sc_gen_001.unset_ctx('R');
1535: app_exception.raise_exception;
1536: ELSE
1731: END IF;
1732: DELETE FROM igs_as_su_atmpt_itm
1733: WHERE ROWID = x_rowid;
1734: IF (SQL%NOTFOUND) THEN
1735: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1736: igs_ge_msg_stack.add;
1737: igs_sc_gen_001.unset_ctx('R');
1738: app_exception.raise_exception;
1739: END IF;
1759: END IF;
1760: IF UPPER (column_name) = 'CAL_TYPE'
1761: OR column_name IS NULL THEN
1762: IF new_references.cal_type <> UPPER (new_references.cal_type) THEN
1763: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1764: igs_ge_msg_stack.ADD;
1765: app_exception.raise_exception;
1766: END IF;
1767: END IF;
1767: END IF;
1768: IF UPPER (column_name) = 'COURSE_CD'
1769: OR column_name IS NULL THEN
1770: IF new_references.course_cd <> UPPER (new_references.course_cd) THEN
1771: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1772: igs_ge_msg_stack.ADD;
1773: app_exception.raise_exception;
1774: END IF;
1775: END IF;
1775: END IF;
1776: IF UPPER (column_name) = 'UNIT_CD'
1777: OR column_name IS NULL THEN
1778: IF new_references.unit_cd <> UPPER (new_references.unit_cd) THEN
1779: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1780: igs_ge_msg_stack.ADD;
1781: app_exception.raise_exception;
1782: END IF;
1783: END IF;
1783: END IF;
1784: IF UPPER (column_name) = 'S_DEFAULT_IND'
1785: OR column_name IS NULL THEN
1786: IF new_references.s_default_ind NOT IN ('Y', 'N') THEN
1787: fnd_message.set_name ('IGS', 'IGS_GE_INVALID_VALUE');
1788: igs_ge_msg_stack.ADD;
1789: app_exception.raise_exception;
1790: END IF;
1791: END IF;