DBA Data[Home] [Help]

APPS.IGS_PE_PERS_NOTE_PKG dependencies on FND_MESSAGE

Line 37: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

33: -- Populate Old Values.
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;

Line 79: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');

75:
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;

Line 96: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

92: NULL;
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:

Line 109: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

105: NULL;
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:

Line 127: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

123: IF NOT IGS_LOOKUPS_view_Pkg.Get_PK_For_Validation (
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;

Line 179: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PN_NOTE_FK');

175:
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;

Line 205: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PN_PE_FK');

201:
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;

Line 231: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PN_PNT_FK');

227:
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;

Line 278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

274:
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

Line 296: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

292: ELSIF (p_action = 'VALIDATE_INSERT') THEN
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:

Line 360: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

356: if X_LAST_UPDATE_LOGIN is NULL then
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:

Line 427: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

423:
424: EXCEPTION
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;

Line 428: fnd_message.set_token ('ERR_CD', SQLCODE);

424: EXCEPTION
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

Line 460: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

456: begin
457: open c1;
458: fetch c1 into tlinfo;
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;

Line 474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

470: AND ((tlinfo.end_date = X_END_DATE) OR ((tlinfo.end_date IS NULL) AND (X_END_DATE IS NULL)))
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;

Line 507: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

503: if X_LAST_UPDATE_LOGIN is NULL then
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:

Line 539: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

535: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
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;

Line 557: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

553:
554: EXCEPTION
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;

Line 558: fnd_message.set_token ('ERR_CD', SQLCODE);

554: EXCEPTION
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

Line 626: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

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