DBA Data[Home] [Help]

APPS.IGS_AD_PNMEMBR_NOTS_PKG dependencies on FND_MESSAGE

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

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

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

91: ELSIF NOT igs_ad_pnmembr_dtls_pkg.get_pk_for_validation (
92: new_references.panel_dtls_id,
93: new_references.member_person_id
94: ) THEN
95: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
96: igs_ge_msg_stack.add;
97: app_exception.raise_exception;
98: END IF;
99:

Line 169: fnd_message.set_name ('IGS', 'IGS_AD_PNMEMBR_NOTS_FK');

165: OPEN cur_rowid;
166: FETCH cur_rowid INTO lv_rowid;
167: IF (cur_rowid%FOUND) THEN
168: CLOSE cur_rowid;
169: fnd_message.set_name ('IGS', 'IGS_AD_PNMEMBR_NOTS_FK');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: RETURN;
173: END IF;

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

222: new_references.member_person_id,
223: new_references.notes_version_num
224: )
225: ) THEN
226: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: END IF;
230: check_parent_existance;

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

238: new_references.member_person_id,
239: new_references.notes_version_num
240: )
241: ) THEN
242: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: igs_ge_msg_stack.add;
244: app_exception.raise_exception;
245: END IF;
246: END IF;

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

285: IF (x_last_update_login IS NULL) THEN
286: x_last_update_login := -1;
287: END IF;
288: ELSE
289: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
290: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_NOTS_PKG.INSERT_ROW');
291: igs_ge_msg_stack.add;
292: app_exception.raise_exception;
293: END IF;

Line 290: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_NOTS_PKG.INSERT_ROW');

286: x_last_update_login := -1;
287: END IF;
288: ELSE
289: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
290: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_NOTS_PKG.INSERT_ROW');
291: igs_ge_msg_stack.add;
292: app_exception.raise_exception;
293: END IF;
294:

Line 339: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');

335: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
336: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
337: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
338: -- that the ownerof policy function does not have privilege to access.
339: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
340: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
341: IGS_GE_MSG_STACK.ADD;
342: app_exception.raise_exception;
343: ELSE

Line 340: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

336: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
337: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
338: -- that the ownerof policy function does not have privilege to access.
339: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
340: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
341: IGS_GE_MSG_STACK.ADD;
342: app_exception.raise_exception;
343: ELSE
344: RAISE;

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

375:
376: OPEN c1;
377: FETCH c1 INTO tlinfo;
378: IF (c1%notfound) THEN
379: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
380: igs_ge_msg_stack.add;
381: CLOSE c1;
382: app_exception.raise_exception;
383: RETURN;

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

388: (tlinfo.member_notes = x_member_notes)
389: ) THEN
390: NULL;
391: ELSE
392: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395: END IF;
396:

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

435: IF (x_last_update_login IS NULL) THEN
436: x_last_update_login := -1;
437: END IF;
438: ELSE
439: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
440: fnd_message.set_token ('ROUTINE', 'IGS_AD_pnmembr_nots_PKG.UPDATE_ROW');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;

Line 440: fnd_message.set_token ('ROUTINE', 'IGS_AD_pnmembr_nots_PKG.UPDATE_ROW');

436: x_last_update_login := -1;
437: END IF;
438: ELSE
439: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
440: fnd_message.set_token ('ROUTINE', 'IGS_AD_pnmembr_nots_PKG.UPDATE_ROW');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;
444:

Line 468: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

464: last_update_login = x_last_update_login
465: WHERE rowid = x_rowid;
466:
467: IF (SQL%NOTFOUND) THEN
468: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
469: IGS_GE_MSG_STACK.ADD;
470: app_exception.raise_exception;
471: END IF;
472:

Line 481: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');

477: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
478: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
479: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
480: -- that the ownerof policy function does not have privilege to access.
481: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
482: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
483: IGS_GE_MSG_STACK.ADD;
484: app_exception.raise_exception;
485: ELSE

Line 482: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

478: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
479: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
480: -- that the ownerof policy function does not have privilege to access.
481: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
482: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
483: IGS_GE_MSG_STACK.ADD;
484: app_exception.raise_exception;
485: ELSE
486: RAISE;

Line 569: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

565: DELETE FROM igs_ad_pnmembr_nots
566: WHERE rowid = x_rowid;
567:
568: IF (SQL%NOTFOUND) THEN
569: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
570: IGS_GE_MSG_STACK.ADD;
571: app_exception.raise_exception;
572: END IF;
573:

Line 582: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');

578: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
579: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
580: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
581: -- that the ownerof policy function does not have privilege to access.
582: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
583: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
584: IGS_GE_MSG_STACK.ADD;
585: app_exception.raise_exception;
586: ELSE

Line 583: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);

579: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
580: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
581: -- that the ownerof policy function does not have privilege to access.
582: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
583: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
584: IGS_GE_MSG_STACK.ADD;
585: app_exception.raise_exception;
586: ELSE
587: RAISE;