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

Line 40: App_Exception.Raise_Exception;

36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
38: IGS_GE_MSG_STACK.ADD;
39: Close cur_old_ref_values;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;
44:

Line 81: App_Exception.Raise_Exception;

77: column_name is null Then
78: IF new_references.pe_note_type <>UPPER(new_references.pe_note_type)Then
79: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: END IF;
84:
85: END Check_Constraints;

Line 98: App_Exception.Raise_Exception;

94: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
95: new_references.reference_number ) THEN
96: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100:
101: END IF;
102:

Line 111: App_Exception.Raise_Exception;

107: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
108: new_references.person_id ) THEN
109: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113:
114: END IF;
115:

Line 129: App_Exception.Raise_Exception;

125: new_references.pe_note_type
126: ) THEN
127: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132:
133: END Check_Parent_Existance;

Line 182: App_Exception.Raise_Exception;

178: IF (cur_rowid%FOUND) THEN
179: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PN_NOTE_FK');
180: IGS_GE_MSG_STACK.ADD;
181: Close cur_rowid;
182: App_Exception.Raise_Exception;
183: Return;
184: END IF;
185: Close cur_rowid;
186:

Line 208: App_Exception.Raise_Exception;

204: IF (cur_rowid%FOUND) THEN
205: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PN_PE_FK');
206: IGS_GE_MSG_STACK.ADD;
207: Close cur_rowid;
208: App_Exception.Raise_Exception;
209: Return;
210: END IF;
211: Close cur_rowid;
212:

Line 234: App_Exception.Raise_Exception;

230: IF (cur_rowid%FOUND) THEN
231: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PN_PNT_FK');
232: IGS_GE_MSG_STACK.ADD;
233: Close cur_rowid;
234: App_Exception.Raise_Exception;
235: Return;
236: END IF;
237: Close cur_rowid;
238:

Line 280: App_Exception.Raise_Exception;

276: new_references.person_id,
277: new_references.reference_number )THEN
278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: Check_Constraints; -- if procedure present
283: Check_Parent_Existance; -- if procedure present
284: ELSIF (p_action = 'UPDATE') THEN

Line 298: App_Exception.Raise_Exception;

294: new_references.person_id,
295: new_references.reference_number ) THEN
296: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: END IF;
300:
301: Check_Constraints; -- if procedure present
302: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 362: app_exception.raise_exception;

358: end if;
359: else
360: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
361: IGS_GE_MSG_STACK.ADD;
362: app_exception.raise_exception;
363: end if;
364:
365: Before_DML(
366: p_action=>'INSERT',

Line 431: app_exception.raise_exception;

427: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
428: fnd_message.set_token ('ERR_CD', SQLCODE);
429: igs_ge_msg_stack.add;
430: igs_sc_gen_001.unset_ctx('R');
431: app_exception.raise_exception;
432: ELSE
433: igs_sc_gen_001.unset_ctx('R');
434: RAISE;
435: END IF;

Line 463: App_Exception.Raise_Exception;

459: if (c1%notfound) then
460: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
461:
462: close c1;
463: App_Exception.Raise_Exception;
464: return;
465: end if;
466: close c1;
467:

Line 475: app_exception.raise_exception;

471: ) then
472: NULL;
473: else
474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
475: app_exception.raise_exception;
476: end if;
477: return;
478: end LOCK_ROW;
479:

Line 509: app_exception.raise_exception;

505: end if;
506: else
507: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
508: IGS_GE_MSG_STACK.ADD;
509: app_exception.raise_exception;
510: end if;
511:
512: Before_DML(
513: p_action=>'UPDATE',

Line 542: app_exception.raise_exception;

538: if (sql%notfound) then
539: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
540: igs_ge_msg_stack.add;
541: igs_sc_gen_001.unset_ctx('R');
542: app_exception.raise_exception;
543: end if;
544: IF (x_mode = 'S') THEN
545: igs_sc_gen_001.unset_ctx('R');
546: END IF;

Line 561: app_exception.raise_exception;

557: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
558: fnd_message.set_token ('ERR_CD', SQLCODE);
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: ELSE
563: igs_sc_gen_001.unset_ctx('R');
564: RAISE;
565: END IF;

Line 629: app_exception.raise_exception;

625: if (sql%notfound) then
626: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
627: igs_ge_msg_stack.add;
628: igs_sc_gen_001.unset_ctx('R');
629: app_exception.raise_exception;
630: end if;
631: IF (x_mode = 'S') THEN
632: igs_sc_gen_001.unset_ctx('R');
633: END IF;