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_PR_MILESTONE_PKG dependencies on APP_EXCEPTION

Line 53: App_Exception.Raise_Exception;

49: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_GE_MSG_STACK.ADD;
52: Close cur_old_ref_values;
53: App_Exception.Raise_Exception;
54: Return;
55: END IF;
56: Close cur_old_ref_values;
57:

Line 108: App_Exception.Raise_Exception;

104: IF IGS_RE_VAL_MIL.resp_val_mil_mty( new_references.milestone_type,
105: v_message_name) = FALSE THEN
106: Fnd_Message.Set_Name('IGS',v_message_name);
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: END IF;
110: END IF;
111: IF p_inserting OR
112: ( p_updating AND

Line 120: App_Exception.Raise_Exception;

116: new_references.actual_reached_dt,
117: v_message_name) = FALSE THEN
118: Fnd_Message.Set_Name('IGS',v_message_name);
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception;
121: END IF;
122: END IF;
123: IF p_inserting OR
124: ( p_updating AND

Line 143: App_Exception.Raise_Exception;

139: new_references.ovrd_ntfctn_re_reminder_days,
140: v_message_name) = FALSE THEN
141: Fnd_Message.Set_Name('IGS',v_message_name);
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146: END IF;
147: IF p_deleting THEN

Line 155: App_Exception.Raise_Exception;

151: old_references.milestone_status,
152: v_message_name) = FALSE THEN
153: Fnd_Message.Set_Name('IGS',v_message_name);
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;
158:
159:

Line 276: App_Exception.Raise_Exception;

272: new_references.preced_sequence_number,
273: v_message_name) = FALSE THEN
274: Fnd_Message.Set_Name('IGS',v_message_name);
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception;
277: END IF;
278: -- Validate milestone status.
279: IF IGS_RE_VAL_MIL.resp_val_mil_mst(new_references.person_id,
280: new_references.ca_sequence_number,

Line 290: App_Exception.Raise_Exception;

286: 'TRIGGER',
287: v_message_name) = FALSE THEN
288: Fnd_Message.Set_Name('IGS',v_message_name);
289: IGS_GE_MSG_STACK.ADD;
290: App_Exception.Raise_Exception;
291: END IF;
292: -- Validate milestone due date.
293: IF IGS_RE_VAL_MIL.resp_val_mil_due(new_references.person_id,
294: new_references.ca_sequence_number,

Line 303: App_Exception.Raise_Exception;

299: new_references.due_dt,
300: v_message_name) = 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: END IF;
306:
307: END AfterStmtInsertUpdate3;

Line 325: App_Exception.Raise_Exception;

321: new_references.ca_sequence_number
322: ) THEN
323: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
324: IGS_GE_MSG_STACK.ADD;
325: App_Exception.Raise_Exception;
326: END IF;
327: END IF;
328:
329: IF (((old_references.person_id = new_references.person_id) AND

Line 344: App_Exception.Raise_Exception;

340: new_references.preced_sequence_number
341: ) THEN
342: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
343: IGS_GE_MSG_STACK.ADD;
344: App_Exception.Raise_Exception;
345: END IF;
346: END IF;
347:
348: IF (((old_references.milestone_status= new_references.milestone_status)) OR

Line 357: App_Exception.Raise_Exception;

353: new_references.milestone_status
354: ) THEN
355: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: END IF;
359: END IF;
360:
361: IF (((old_references.milestone_type = new_references.milestone_type)) OR

Line 370: App_Exception.Raise_Exception;

366: new_references.milestone_type
367: ) THEN
368: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: END IF;
372: END IF;
373:
374: END Check_Parent_Existance;

Line 436: App_Exception.Raise_Exception;

432: Fetch cur_rowid INTO lv_rowid;
433: IF (cur_rowid%FOUND) THEN
434: Fnd_Message.Set_Name ('IGS', 'IGS_PR_MIL_CA_FK');
435: IGS_GE_MSG_STACK.ADD;
436: App_Exception.Raise_Exception;
437: Close cur_rowid;
438: Return;
439: END IF;
440: Close cur_rowid;

Line 467: App_Exception.Raise_Exception;

463: IF (cur_rowid%FOUND) THEN
464: Fnd_Message.Set_Name ('IGS', 'IGS_PR_MIL_MIL_FK');
465: IGS_GE_MSG_STACK.ADD;
466: Close cur_rowid;
467: App_Exception.Raise_Exception;
468: Return;
469: END IF;
470: Close cur_rowid;
471:

Line 493: App_Exception.Raise_Exception;

489: IF (cur_rowid%FOUND) THEN
490: Fnd_Message.Set_Name ('IGS', 'IGS_PR_MIL_MST_FK');
491: IGS_GE_MSG_STACK.ADD;
492: Close cur_rowid;
493: App_Exception.Raise_Exception;
494: Return;
495: END IF;
496: Close cur_rowid;
497:

Line 519: App_Exception.Raise_Exception;

515: IF (cur_rowid%FOUND) THEN
516: Fnd_Message.Set_Name ('IGS', 'IGS_PR_MIL_MTY_FK');
517: IGS_GE_MSG_STACK.ADD;
518: Close cur_rowid;
519: App_Exception.Raise_Exception;
520: Return;
521: END IF;
522: Close cur_rowid;
523:

Line 585: App_Exception.Raise_Exception;

581: new_references.sequence_number
582: ) THEN
583: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
584: IGS_GE_MSG_STACK.ADD;
585: App_Exception.Raise_Exception;
586: END IF;
587: Check_Constraints;
588: Check_Parent_Existance;
589: ELSIF (p_action = 'UPDATE') THEN

Line 606: App_Exception.Raise_Exception;

602: new_references.sequence_number
603: ) THEN
604: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
605: IGS_GE_MSG_STACK.ADD;
606: App_Exception.Raise_Exception;
607: END IF;
608: Check_Constraints;
609: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
610: Check_Constraints;

Line 682: app_exception.raise_exception;

678: end if;
679: else
680: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
681: IGS_GE_MSG_STACK.ADD;
682: app_exception.raise_exception;
683: end if;
684:
685: Before_DML (
686: p_action => 'INSERT',

Line 775: app_exception.raise_exception;

771: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
772: fnd_message.set_token ('ERR_CD', SQLCODE);
773: igs_ge_msg_stack.add;
774: igs_sc_gen_001.unset_ctx('R');
775: app_exception.raise_exception;
776: ELSE
777: igs_sc_gen_001.unset_ctx('R');
778: RAISE;
779: END IF;

Line 821: app_exception.raise_exception;

817: if (c1%notfound) then
818: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
819: IGS_GE_MSG_STACK.ADD;
820: close c1;
821: app_exception.raise_exception;
822: return;
823: end if;
824: close c1;
825:

Line 855: app_exception.raise_exception;

851: null;
852: else
853: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
854: IGS_GE_MSG_STACK.ADD;
855: app_exception.raise_exception;
856: end if;
857: return;
858: end LOCK_ROW;
859:

Line 897: app_exception.raise_exception;

893: end if;
894: else
895: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
896: IGS_GE_MSG_STACK.ADD;
897: app_exception.raise_exception;
898: end if;
899: Before_DML (
900: p_action => 'UPDATE',
901: x_rowid => X_ROWID,

Line 946: app_exception.raise_exception;

942: if (sql%notfound) then
943: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
944: igs_ge_msg_stack.add;
945: igs_sc_gen_001.unset_ctx('R');
946: app_exception.raise_exception;
947: end if;
948: IF (x_mode = 'S') THEN
949: igs_sc_gen_001.unset_ctx('R');
950: END IF;

Line 964: app_exception.raise_exception;

960: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
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 1057: app_exception.raise_exception;

1053: if (sql%notfound) then
1054: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1055: igs_ge_msg_stack.add;
1056: igs_sc_gen_001.unset_ctx('R');
1057: app_exception.raise_exception;
1058: end if;
1059: IF (x_mode = 'S') THEN
1060: igs_sc_gen_001.unset_ctx('R');
1061: END IF;

Line 1101: App_Exception.Raise_Exception;

1097: column_name is NULL THEN
1098: IF new_references.milestone_status <> UPPER(new_references.milestone_status) THEN
1099: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
1100: IGS_GE_MSG_STACK.ADD;
1101: App_Exception.Raise_Exception;
1102: END IF;
1103: END IF;
1104:
1105:

Line 1112: App_Exception.Raise_Exception;

1108: IF TO_NUMBER(new_references.ca_sequence_number) < 1 OR
1109: TO_NUMBER(new_references.ca_sequence_number) > 999999 THEN
1110: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
1111: IGS_GE_MSG_STACK.ADD;
1112: App_Exception.Raise_Exception;
1113: END IF;
1114: END IF;
1115:
1116:

Line 1123: App_Exception.Raise_Exception;

1119: IF TO_NUMBER(new_references.sequence_number) < 1 OR
1120: TO_NUMBER(new_references.sequence_number) > 999999 THEN
1121: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
1122: IGS_GE_MSG_STACK.ADD;
1123: App_Exception.Raise_Exception;
1124: END IF;
1125: END IF;
1126:
1127:

Line 1134: App_Exception.Raise_Exception;

1130: IF TO_NUMBER(new_references.preced_sequence_number) < 1 OR
1131: TO_NUMBER(new_references.preced_sequence_number) > 999999 THEN
1132: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
1133: IGS_GE_MSG_STACK.ADD;
1134: App_Exception.Raise_Exception;
1135: END IF;
1136: END IF;
1137:
1138:

Line 1145: App_Exception.Raise_Exception;

1141: IF TO_NUMBER(new_references.ovrd_ntfctn_imminent_days) < 0 OR
1142: TO_NUMBER(new_references.ovrd_ntfctn_imminent_days) > 999 THEN
1143: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
1144: IGS_GE_MSG_STACK.ADD;
1145: App_Exception.Raise_Exception;
1146: END IF;
1147: END IF;
1148:
1149:

Line 1157: App_Exception.Raise_Exception;

1153: IF TO_NUMBER(new_references.ovrd_ntfctn_reminder_days) < 0 OR
1154: TO_NUMBER(new_references.ovrd_ntfctn_reminder_days) > 999 THEN
1155: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
1156: IGS_GE_MSG_STACK.ADD;
1157: App_Exception.Raise_Exception;
1158: END IF;
1159: END IF;
1160:
1161: IF upper(column_name) = 'OVRD_NTFCTN_RE_REMINDER_DAYS' OR

Line 1167: App_Exception.Raise_Exception;

1163: IF TO_NUMBER(new_references.ovrd_ntfctn_re_reminder_days) < 0 OR
1164: TO_NUMBER(new_references.ovrd_ntfctn_re_reminder_days) > 999 THEN
1165: Fnd_Message.Set_Name('IGS','IGS_INVALID_VALUE');
1166: IGS_GE_MSG_STACK.ADD;
1167: App_Exception.Raise_Exception;
1168: END IF;
1169: END IF;
1170:
1171: END Check_Constraints;