APPS.IGS_AD_PNMEMBR_NOTS_PKG dependencies on IGS_GE_MSG_STACK

Line 47: igs_ge_msg_stack.add;

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;
51: CLOSE cur_old_ref_values;

Line 96: igs_ge_msg_stack.add;

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:
100: END check_parent_existance;

Line 170: igs_ge_msg_stack.add;

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;
174: CLOSE cur_rowid;

Line 227: igs_ge_msg_stack.add;

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;
231: ELSIF (p_action = 'UPDATE') THEN

Line 243: igs_ge_msg_stack.add;

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

Line 291: igs_ge_msg_stack.add;

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:
295: before_dml(

Line 341: IGS_GE_MSG_STACK.ADD;

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

Line 380: igs_ge_msg_stack.add;

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

Line 393: igs_ge_msg_stack.add;

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:
397: RETURN;

Line 441: igs_ge_msg_stack.add;

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:
445: before_dml(

Line 469: IGS_GE_MSG_STACK.ADD;

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

Line 483: IGS_GE_MSG_STACK.ADD;

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

Line 570: IGS_GE_MSG_STACK.ADD;

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

Line 584: IGS_GE_MSG_STACK.ADD;

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