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 IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

34: Open cur_old_ref_values;
35: Fetch cur_old_ref_values INTO old_references;
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;

Line 80: IGS_GE_MSG_STACK.ADD;

76: IF upper(column_name) = 'PE_NOTE_TYPE' OR
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:

Line 97: IGS_GE_MSG_STACK.ADD;

93: ELSE
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;

Line 110: IGS_GE_MSG_STACK.ADD;

106: ELSE
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;

Line 128: IGS_GE_MSG_STACK.ADD;

124: 'PE_NOTE_TYPE',
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:

Line 180: IGS_GE_MSG_STACK.ADD;

176: Open cur_rowid;
177: Fetch cur_rowid INTO lv_rowid;
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;

Line 206: IGS_GE_MSG_STACK.ADD;

202: Open cur_rowid;
203: Fetch cur_rowid INTO lv_rowid;
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;

Line 232: IGS_GE_MSG_STACK.ADD;

228: Open cur_rowid;
229: Fetch cur_rowid INTO lv_rowid;
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;

Line 279: IGS_GE_MSG_STACK.ADD;

275: IF Get_PK_For_Validation (
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

Line 297: IGS_GE_MSG_STACK.ADD;

293: IF Get_PK_For_Validation (
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

Line 361: IGS_GE_MSG_STACK.ADD;

357: X_LAST_UPDATE_LOGIN := -1;
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(

Line 429: igs_ge_msg_stack.add;

425: WHEN OTHERS THEN
426: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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');

Line 508: IGS_GE_MSG_STACK.ADD;

504: X_LAST_UPDATE_LOGIN := -1;
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(

Line 540: igs_ge_msg_stack.add;

536: where ROWID = X_ROWID
537: ;
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

Line 559: igs_ge_msg_stack.add;

555: WHEN OTHERS THEN
556: IF (SQLCODE = (-28115)) THEN
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');

Line 627: igs_ge_msg_stack.add;

623: delete from IGS_PE_PERS_NOTE
624: where ROWID = X_ROWID;
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