DBA Data[Home] [Help]

APPS.IGS_CO_S_LTR_PKG dependencies on FND_MESSAGE

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

46: OPEN cur_old_ref_values;
47: FETCH cur_old_ref_values INTO old_references;
48: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
49: CLOSE cur_old_ref_values;
50: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
51: igs_ge_msg_stack.add;
52: app_exception.raise_exception;
53: RETURN;
54: END IF;

Line 105: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

101: END IF;
102:
103: IF (UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL) THEN
104: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
105: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: END IF;
109: END IF;

Line 130: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_LKUP_FK');

126: Open cur_rowid;
127: Fetch cur_rowid INTO lv_rowid;
128: IF (cur_rowid%FOUND) THEN
129: Close cur_rowid;
130: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_LKUP_FK');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: Return;
134: END IF;

Line 156: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_LKUP_FK');

152: Open cur_rowid;
153: Fetch cur_rowid INTO lv_rowid;
154: IF (cur_rowid%FOUND) THEN
155: Close cur_rowid;
156: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_LKUP_FK');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: Return;
160: END IF;

Line 183: Fnd_Message.Set_Name('IGS',v_message_name);

179: -- Validate Correspondence Type closed.
180: IF igs_ad_val_aal.corp_val_cort_closed(
181: new_references.correspondence_type,
182: v_message_name) = FALSE THEN
183: Fnd_Message.Set_Name('IGS',v_message_name);
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187: -- Validate Correspondence Type is system generated.

Line 191: Fnd_Message.Set_Name('IGS',v_message_name);

187: -- Validate Correspondence Type is system generated.
188: IF IGS_CO_VAL_SLET.corp_val_cort_sysgen(
189: new_references.correspondence_type,
190: v_message_name) = FALSE THEN
191: Fnd_Message.Set_Name('IGS',v_message_name);
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195: END IF;

Line 203: Fnd_Message.Set_Name('IGS',v_message_name);

199: new_references.s_letter_object <> old_references.s_letter_object) THEN
200: IF IGS_CO_VAL_SLET.corp_val_slo_closed(
201: new_references.s_letter_object,
202: v_message_name) = FALSE THEN
203: Fnd_Message.Set_Name('IGS',v_message_name);
204: IGS_GE_MSG_STACK.ADD;
205: App_Exception.Raise_Exception;
206: END IF;
207: END IF;

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

228: NULL;
229: ELSIF NOT igs_co_type_pkg.get_pk_for_validation (
230: new_references.correspondence_type
231: ) THEN
232: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
233: igs_ge_msg_stack.add;
234: app_exception.raise_exception;
235: END IF;
236:

Line 327: fnd_message.set_name ('IGS', 'IGS_CO_CORT_SLET_FK');

323: OPEN cur_rowid;
324: FETCH cur_rowid INTO lv_rowid;
325: IF (cur_rowid%FOUND) THEN
326: CLOSE cur_rowid;
327: fnd_message.set_name ('IGS', 'IGS_CO_CORT_SLET_FK');
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: RETURN;
331: END IF;

Line 393: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

389: new_references.correspondence_type,
390: new_references.letter_reference_number
391: )
392: ) THEN
393: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
394: igs_ge_msg_stack.add;
395: app_exception.raise_exception;
396: END IF;
397: check_constraints;

Line 414: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

410: new_references.correspondence_type,
411: new_references.letter_reference_number
412: )
413: ) THEN
414: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418: check_constraints;

Line 475: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

471: IF (x_last_update_login IS NULL) THEN
472: x_last_update_login := -1;
473: END IF;
474: ELSE
475: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
476: igs_ge_msg_stack.add;
477: app_exception.raise_exception;
478: END IF;
479:

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

574:
575: OPEN c1;
576: FETCH c1 INTO tlinfo;
577: IF (c1%notfound) THEN
578: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
579: igs_ge_msg_stack.add;
580: CLOSE c1;
581: app_exception.raise_exception;
582: RETURN;

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

592: AND (tlinfo.closed_ind = x_closed_ind)
593: ) THEN
594: NULL;
595: ELSE
596: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
597: igs_ge_msg_stack.add;
598: app_exception.raise_exception;
599: END IF;
600:

Line 647: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

643: IF (x_last_update_login IS NULL) THEN
644: x_last_update_login := -1;
645: END IF;
646: ELSE
647: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
648: igs_ge_msg_stack.add;
649: app_exception.raise_exception;
650: END IF;
651: