DBA Data[Home] [Help]

APPS.IGS_PE_ACT_SITE_PKG dependencies on FND_MESSAGE

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

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

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

93: NULL;
94: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
95: new_references.person_id
96: ) THEN
97: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101:

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

105: ELSIF NOT igs_ad_location_pkg.get_pk_for_validation (
106: new_references.activity_site_cd ,
107: 'N'
108: ) 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 181: fnd_message.set_name ('IGS', 'IGS_PE_EAS_LOC_FK');

177: OPEN cur_rowid;
178: FETCH cur_rowid INTO lv_rowid;
179: IF (cur_rowid%FOUND) THEN
180: CLOSE cur_rowid;
181: fnd_message.set_name ('IGS', 'IGS_PE_EAS_LOC_FK');
182: igs_ge_msg_stack.add;
183: app_exception.raise_exception;
184: RETURN;
185: END IF;

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

240: new_references.activity_site_cd,
241: new_references.start_date
242: )
243: ) THEN
244: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: END IF;
248: check_parent_existance;

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

256: new_references.activity_site_cd,
257: new_references.start_date
258: )
259: ) THEN
260: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: END IF;

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

306: IF (x_last_update_login IS NULL) THEN
307: x_last_update_login := -1;
308: END IF;
309: ELSE
310: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314:

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

367:
368: EXCEPTION
369: WHEN OTHERS THEN
370: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
371: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
372: fnd_message.set_token ('ERR_CD', SQLCODE);
373: igs_ge_msg_stack.add;
374: igs_sc_gen_001.unset_ctx('R');
375: app_exception.raise_exception;

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

368: EXCEPTION
369: WHEN OTHERS THEN
370: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
371: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
372: fnd_message.set_token ('ERR_CD', SQLCODE);
373: igs_ge_msg_stack.add;
374: igs_sc_gen_001.unset_ctx('R');
375: app_exception.raise_exception;
376: ELSE

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

413:
414: OPEN c1;
415: FETCH c1 INTO tlinfo;
416: IF (c1%notfound) THEN
417: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
418: igs_ge_msg_stack.add;
419: CLOSE c1;
420: app_exception.raise_exception;
421: RETURN;

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

428: AND ((tlinfo.remarks = x_remarks ) OR ((tlinfo.remarks IS NULL) AND (x_remarks IS NULL)))
429: ) THEN
430: NULL;
431: ELSE
432: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
433: igs_ge_msg_stack.add;
434: app_exception.raise_exception;
435: END IF;
436:

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

478: IF (x_last_update_login IS NULL) THEN
479: x_last_update_login := -1;
480: END IF;
481: ELSE
482: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486:

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

515: primary_flag = x_primary_flag
516: WHERE rowid = x_rowid;
517:
518: IF (SQL%NOTFOUND) THEN
519: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
520: igs_ge_msg_stack.add;
521: igs_sc_gen_001.unset_ctx('R');
522: app_exception.raise_exception;
523: END IF;

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

529:
530: EXCEPTION
531: WHEN OTHERS THEN
532: IF (SQLCODE = (-28115)) THEN
533: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
534: fnd_message.set_token ('ERR_CD', SQLCODE);
535: igs_ge_msg_stack.add;
536: igs_sc_gen_001.unset_ctx('R');
537: app_exception.raise_exception;

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

530: EXCEPTION
531: WHEN OTHERS THEN
532: IF (SQLCODE = (-28115)) THEN
533: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
534: fnd_message.set_token ('ERR_CD', SQLCODE);
535: igs_ge_msg_stack.add;
536: igs_sc_gen_001.unset_ctx('R');
537: app_exception.raise_exception;
538: ELSE

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

633: DELETE FROM igs_pe_act_site
634: WHERE rowid = x_rowid;
635:
636: IF (SQL%NOTFOUND) THEN
637: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
638: igs_ge_msg_stack.add;
639: igs_sc_gen_001.unset_ctx('R');
640: app_exception.raise_exception;
641: END IF;