eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_SU_ATMPT_ITM_PKG dependencies on APP_EXCEPTION

Line 83: app_exception.raise_exception;

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;
85: END IF;
86: CLOSE cur_old_ref_values;
87: -- Populate New Values.

Line 200: app_exception.raise_exception;

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;
203: -- If p_updating the override_due_dt, check if a tracking item exists and update
204: -- the item. Validate that the tracking item is for an assignment.

Line 219: app_exception.raise_exception;

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,
222: NULL,
223: cst_assignment_due,

Line 235: app_exception.raise_exception;

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');
238: igs_ge_msg_stack.ADD;
239: app_exception.raise_exception;

Line 239: app_exception.raise_exception;

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;
242: END IF;
243: END IF;

Line 255: app_exception.raise_exception;

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;
258: END IF;
259: END IF;

Line 336: app_exception.raise_exception;

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.
339: -- Cannot call assp_val_suaai_atmpt because trigger will be mutating.
340: -- Save the rowid of the current row.

Line 360: app_exception.raise_exception;

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))
363: OR ((new_references.sua_ass_item_group_id IS NULL))
364: ) THEN

Line 371: app_exception.raise_exception;

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

Line 380: app_exception.raise_exception;

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;
383:
384: PROCEDURE check_child_existance AS

Line 454: app_exception.raise_exception;

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;
456: END IF;
457: CLOSE cur_rowid;
458: END get_fk_igs_as_assessmnt_itm;

Line 481: app_exception.raise_exception;

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;
483: END IF;
484: CLOSE cur_rowid;
485: END get_fk_igs_as_sua_ai_group;

Line 500: app_exception.raise_exception;

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;
502: END IF;
503: CLOSE cur_rowid;
504: END get_fk_igs_tr_item;

Line 526: app_exception.raise_exception;

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;
528: END IF;
529: CLOSE cur_rowid;
530: END get_fk_igs_as_grd_sch_grade;

Line 546: app_exception.raise_exception;

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;
548: END IF;
549: CLOSE cur_rowid;
550: END get_fk_igs_lookups_view;

Line 690: app_exception.raise_exception;

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;
693: check_parent_existance;
694: ELSIF (p_action = 'UPDATE') THEN

Line 712: app_exception.raise_exception;

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;
715: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
716: check_constraints;

Line 837: app_exception.raise_exception;

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 (
840: p_action => 'INSERT',
841: x_rowid => x_rowid,

Line 964: app_exception.raise_exception;

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
966: igs_sc_gen_001.unset_ctx('R');
967: RAISE;
968: END IF;

Line 1080: app_exception.raise_exception;

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;
1083: END IF;
1084: CLOSE c1;

Line 1302: app_exception.raise_exception;

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;
1305: END lock_row;
1306:

Line 1386: app_exception.raise_exception;

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 (
1389: p_action => 'UPDATE',
1390: x_rowid => x_rowid,

Line 1520: app_exception.raise_exception;

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;
1522: IF (x_mode = 'S') THEN
1523: igs_sc_gen_001.unset_ctx('R');
1524: END IF;

Line 1535: app_exception.raise_exception;

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
1537: igs_sc_gen_001.unset_ctx('R');
1538: RAISE;
1539: END IF;

Line 1738: app_exception.raise_exception;

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;
1740: IF (x_mode = 'S') THEN
1741: igs_sc_gen_001.unset_ctx('R');
1742: END IF;

Line 1765: app_exception.raise_exception;

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;
1768: IF UPPER (column_name) = 'COURSE_CD'
1769: OR column_name IS NULL THEN

Line 1773: app_exception.raise_exception;

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;
1776: IF UPPER (column_name) = 'UNIT_CD'
1777: OR column_name IS NULL THEN

Line 1781: app_exception.raise_exception;

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;
1784: IF UPPER (column_name) = 'S_DEFAULT_IND'
1785: OR column_name IS NULL THEN

Line 1789: app_exception.raise_exception;

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;
1792: END check_constraints;
1793: END igs_as_su_atmpt_itm_pkg;