DBA Data[Home] [Help]

APPS.IGS_AD_APLINS_ADMREQ_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 100: app_exception.raise_exception;

96: )
97: ) THEN
98: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:
103: END check_uniqueness;
104:

Line 135: app_exception.raise_exception;

131: new_references.sequence_number
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137:
138: IF (((old_references.tracking_id = new_references.tracking_id)) OR
139: ((new_references.tracking_id IS NULL))) THEN

Line 146: app_exception.raise_exception;

142: new_references.tracking_id
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: END IF;
148:
149: END check_parent_existance;
150:

Line 266: app_exception.raise_exception;

262: CLOSE cur_rowid;
263: --changed the message name -rghosh (bug #2619603)
264: fnd_message.set_name ('IGS', 'IGS_AD_APLINS_ACAI_FK');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: RETURN;
268: END IF;
269: CLOSE cur_rowid;
270:

Line 301: app_exception.raise_exception;

297: IF (cur_rowid%FOUND) THEN
298: CLOSE cur_rowid;
299: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
300: igs_ge_msg_stack.add;
301: app_exception.raise_exception;
302: RETURN;
303: END IF;
304: CLOSE cur_rowid;
305:

Line 365: App_Exception.Raise_Exception;

361: Fnd_Message.Set_name('IGS','IGS_AD_NOT_INST_UPD_REQ_DOC');
362: IGS_GE_MSG_STACK.ADD;
363: CLOSE c_get_adm_doc_status;
364: CLOSE c_not_post_adm;
365: App_Exception.Raise_Exception;
366: END IF;
367: CLOSE c_get_adm_doc_status;
368: CLOSE c_not_post_adm;
369:

Line 466: app_exception.raise_exception;

462: )
463: ) THEN
464: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
468: check_uniqueness;
469: check_parent_existance;
470: check_appl_compl_stat (

Line 494: app_exception.raise_exception;

490: )
491: ) THEN
492: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
493: igs_ge_msg_stack.add;
494: app_exception.raise_exception;
495: END IF;
496: check_uniqueness;
497: check_appl_compl_stat (
498: new_references.tracking_id,

Line 579: app_exception.raise_exception;

575: END IF;
576: ELSE
577: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
578: igs_ge_msg_stack.add;
579: app_exception.raise_exception;
580: END IF;
581:
582: x_aplins_admreq_id := -1;
583: before_dml(

Line 662: app_exception.raise_exception;

658: -- that the ownerof policy function does not have privilege to access.
659: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
660: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
661: IGS_GE_MSG_STACK.ADD;
662: app_exception.raise_exception;
663: ELSE
664: RAISE;
665: END IF;
666: END insert_row;

Line 708: app_exception.raise_exception;

704: IF (c1%notfound) THEN
705: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
706: igs_ge_msg_stack.add;
707: CLOSE c1;
708: app_exception.raise_exception;
709: RETURN;
710: END IF;
711: CLOSE c1;
712:

Line 724: app_exception.raise_exception;

720: NULL;
721: ELSE
722: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
723: igs_ge_msg_stack.add;
724: app_exception.raise_exception;
725: END IF;
726:
727: RETURN;
728:

Line 778: app_exception.raise_exception;

774: END IF;
775: ELSE
776: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
777: igs_ge_msg_stack.add;
778: app_exception.raise_exception;
779: END IF;
780:
781: before_dml(
782: p_action => 'UPDATE',

Line 836: app_exception.raise_exception;

832: igs_ge_msg_stack.add;
833: IF (x_mode = 'S') THEN
834: igs_sc_gen_001.set_ctx('R');
835: END IF;
836: app_exception.raise_exception;
837: END IF;
838: IF (x_mode = 'S') THEN
839: igs_sc_gen_001.unset_ctx('R');
840: END IF;

Line 857: app_exception.raise_exception;

853: -- that the ownerof policy function does not have privilege to access.
854: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
855: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
856: IGS_GE_MSG_STACK.ADD;
857: app_exception.raise_exception;
858: ELSE
859: RAISE;
860: END IF;
861: END update_row;

Line 956: app_exception.raise_exception;

952: igs_ge_msg_stack.add;
953: IF (x_mode = 'S') THEN
954: igs_sc_gen_001.set_ctx('R');
955: END IF;
956: app_exception.raise_exception;
957: END IF;
958: IF (x_mode = 'S') THEN
959: igs_sc_gen_001.unset_ctx('R');
960: END IF;

Line 977: app_exception.raise_exception;

973: -- that the ownerof policy function does not have privilege to access.
974: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
975: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
976: IGS_GE_MSG_STACK.ADD;
977: app_exception.raise_exception;
978: ELSE
979: RAISE;
980: END IF;
981: END delete_row;