DBA Data[Home] [Help]

APPS.IGS_AD_PNL_HIS_DTLS_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 92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

88: NULL;
89: ELSIF NOT igs_ad_panel_dtls_pkg.get_pk_for_validation (
90: new_references.panel_dtls_id
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:

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

101: new_references.final_decision_code,
102: new_references.final_decision_type ,
103: 'N'
104: ) THEN
105: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
106: igs_ge_msg_stack.add;
107: app_exception.raise_exception;
108: END IF;
109:

Line 175: fnd_message.set_name ('IGS', 'IGS_AD_PNLHIS_PNDTLS_FK');

171: OPEN cur_rowid;
172: FETCH cur_rowid INTO lv_rowid;
173: IF (cur_rowid%FOUND) THEN
174: CLOSE cur_rowid;
175: fnd_message.set_name ('IGS', 'IGS_AD_PNLHIS_PNDTLS_FK');
176: igs_ge_msg_stack.add;
177: app_exception.raise_exception;
178: RETURN;
179: END IF;

Line 212: fnd_message.set_name ('IGS', 'IGS_AD_PNLHIS_CODE_CLS_FK');

208: OPEN cur_rowid;
209: FETCH cur_rowid INTO lv_rowid;
210: IF (cur_rowid%FOUND) THEN
211: CLOSE cur_rowid;
212: fnd_message.set_name ('IGS', 'IGS_AD_PNLHIS_CODE_CLS_FK');
213: igs_ge_msg_stack.add;
214: app_exception.raise_exception;
215: RETURN;
216: END IF;

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

264: new_references.panel_dtls_id,
265: new_references.history_date
266: )
267: ) THEN
268: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: END IF;
272: check_parent_existance;

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

279: new_references.panel_dtls_id,
280: new_references.history_date
281: )
282: ) THEN
283: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: END IF;
287: END IF;

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

326: IF (x_last_update_login IS NULL) THEN
327: x_last_update_login := -1;
328: END IF;
329: ELSE
330: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
331: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.insert_row');
332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;

Line 331: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.insert_row');

327: x_last_update_login := -1;
328: END IF;
329: ELSE
330: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
331: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.insert_row');
332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;
335:

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

376: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
377: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
378: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
379: -- that the ownerof policy function does not have privilege to access.
380: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
381: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
382: IGS_GE_MSG_STACK.ADD;
383: app_exception.raise_exception;
384: ELSE

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

377: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
378: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
379: -- that the ownerof policy function does not have privilege to access.
380: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
381: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
382: IGS_GE_MSG_STACK.ADD;
383: app_exception.raise_exception;
384: ELSE
385: RAISE;

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

417:
418: OPEN c1;
419: FETCH c1 INTO tlinfo;
420: IF (c1%notfound) THEN
421: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
422: igs_ge_msg_stack.add;
423: CLOSE c1;
424: app_exception.raise_exception;
425: RETURN;

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

431: AND ((tlinfo.final_decision_type = x_final_decision_type) OR ((tlinfo.final_decision_type IS NULL) AND (X_final_decision_type IS NULL)))
432: ) THEN
433: NULL;
434: ELSE
435: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438: END IF;
439:

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: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.update_row');
484: igs_ge_msg_stack.add;
485: app_exception.raise_exception;
486: END IF;

Line 483: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.update_row');

479: x_last_update_login := -1;
480: END IF;
481: ELSE
482: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
483: fnd_message.set_token ('ROUTINE', 'igs_ad_pnl_his_dtls_pkg.update_row');
484: igs_ge_msg_stack.add;
485: app_exception.raise_exception;
486: END IF;
487:

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

508: last_update_login = x_last_update_login
509: WHERE rowid = x_rowid;
510:
511: IF (SQL%NOTFOUND) THEN
512: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
513: IGS_GE_MSG_STACK.ADD;
514: app_exception.raise_exception;
515: END IF;
516:

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

521: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
522: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
523: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
524: -- that the ownerof policy function does not have privilege to access.
525: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
526: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
527: IGS_GE_MSG_STACK.ADD;
528: app_exception.raise_exception;
529: ELSE

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

522: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
523: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
524: -- that the ownerof policy function does not have privilege to access.
525: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
526: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
527: IGS_GE_MSG_STACK.ADD;
528: app_exception.raise_exception;
529: ELSE
530: RAISE;

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

608: DELETE FROM igs_ad_pnl_his_dtls
609: WHERE rowid = x_rowid;
610:
611: IF (SQL%NOTFOUND) THEN
612: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
613: IGS_GE_MSG_STACK.ADD;
614: app_exception.raise_exception;
615: END IF;
616:

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

621: -- 1) ORA-28115 (policy with check option violation) which is raised when Policy predicate was evaluated to FALSE with the updated values.
622: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
623: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
624: -- that the ownerof policy function does not have privilege to access.
625: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
626: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
627: IGS_GE_MSG_STACK.ADD;
628: app_exception.raise_exception;
629: ELSE

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

622: -- 2) ORA-28113 (policy predicate has error) which is raised when Policy function generates invalid predicate.
623: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
624: -- that the ownerof policy function does not have privilege to access.
625: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
626: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
627: IGS_GE_MSG_STACK.ADD;
628: app_exception.raise_exception;
629: ELSE
630: RAISE;