DBA Data[Home] [Help]

APPS.IGS_AD_APPL_ARP_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

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

Line 102: app_exception.raise_exception;

98: ) THEN
99: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104:
105: IF (((old_references.appl_revprof_revgr_id = new_references.appl_revprof_revgr_id)) OR
106: ((new_references.appl_revprof_revgr_id IS NULL))) THEN

Line 114: app_exception.raise_exception;

110: ) THEN
111: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PRF_GRP'));
113: igs_ge_msg_stack.add;
114: app_exception.raise_exception;
115: END IF;
116:
117: IF (((old_references.appl_rev_profile_id = new_references.appl_rev_profile_id)) OR
118: ((new_references.appl_rev_profile_id IS NULL))) THEN

Line 127: app_exception.raise_exception;

123: ) THEN
124: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REV_PROFILE'));
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;
129:
130: IF (((old_references.person_id = new_references.person_id) AND
131: (old_references.admission_appl_number = new_references.admission_appl_number) AND

Line 148: app_exception.raise_exception;

144: ) THEN
145: fnd_message.set_name ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PROGRAM_APPL'));
147: igs_ge_msg_stack.add;
148: app_exception.raise_exception;
149: END IF;
150:
151: END check_parent_existance;
152:

Line 217: app_exception.raise_exception;

213: IF (cur_rowid%FOUND) THEN
214: CLOSE cur_rowid;
215: fnd_message.set_name ('IGS', 'IGS_AD_APLARP_APRRGR_FK');
216: igs_ge_msg_stack.add;
217: app_exception.raise_exception;
218: RETURN;
219: END IF;
220: CLOSE cur_rowid;
221:

Line 252: app_exception.raise_exception;

248: IF (cur_rowid%FOUND) THEN
249: CLOSE cur_rowid;
250: fnd_message.set_name ('IGS', 'IGS_AD_APLARP_ADAPR_FK');
251: igs_ge_msg_stack.add;
252: app_exception.raise_exception;
253: RETURN;
254: END IF;
255: CLOSE cur_rowid;
256:

Line 295: app_exception.raise_exception;

291: IF (cur_rowid%FOUND) THEN
292: CLOSE cur_rowid;
293: fnd_message.set_name ('IGS', 'IGS_AD_APLARP_ACAI_FK');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: RETURN;
297: END IF;
298: CLOSE cur_rowid;
299:

Line 349: App_Exception.Raise_Exception;

345: IF c_get_system_status % NOTFOUND THEN
346: Fnd_Message.Set_name('IGS','IGS_AD_NOT_INST_UPD_RVP_OUT');
347: IGS_GE_MSG_STACK.ADD;
348: CLOSE c_get_system_status;
349: App_Exception.Raise_Exception;
350: END IF;
351: CLOSE c_get_system_status;
352:
353: END check_system_status;

Line 416: app_exception.raise_exception;

412: )
413: ) THEN
414: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418: check_parent_existance;
419: check_system_status (
420: new_references.person_id,

Line 440: app_exception.raise_exception;

436: )
437: ) THEN
438: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442: check_system_status (
443: new_references.person_id,
444: new_references.admission_appl_number,

Line 522: app_exception.raise_exception;

518: END IF;
519: ELSE
520: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
521: igs_ge_msg_stack.add;
522: app_exception.raise_exception;
523: END IF;
524:
525: x_appl_arp_id := -1;
526: before_dml(

Line 604: app_exception.raise_exception;

600: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
601: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
602: fnd_message.set_token ('ERR_CD', SQLCODE);
603: igs_ge_msg_stack.add;
604: app_exception.raise_exception;
605: ELSE
606: igs_sc_gen_001.unset_ctx('R');
607: RAISE;
608: END IF;

Line 653: app_exception.raise_exception;

649: IF (c1%notfound) THEN
650: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
651: igs_ge_msg_stack.add;
652: CLOSE c1;
653: app_exception.raise_exception;
654: RETURN;
655: END IF;
656: CLOSE c1;
657:

Line 670: app_exception.raise_exception;

666: NULL;
667: ELSE
668: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
669: igs_ge_msg_stack.add;
670: app_exception.raise_exception;
671: END IF;
672:
673: RETURN;
674:

Line 725: app_exception.raise_exception;

721: END IF;
722: ELSE
723: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
724: igs_ge_msg_stack.add;
725: app_exception.raise_exception;
726: END IF;
727:
728: before_dml(
729: p_action => 'UPDATE',

Line 785: app_exception.raise_exception;

781: igs_ge_msg_stack.add;
782: IF (x_mode = 'S') THEN
783: igs_sc_gen_001.unset_ctx('R');
784: END IF;
785: app_exception.raise_exception;
786: END IF;
787: IF (x_mode = 'S') THEN
788: igs_sc_gen_001.unset_ctx('R');
789: END IF;

Line 805: app_exception.raise_exception;

801: -- that the ownerof policy function does not have privilege to access.
802: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
803: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
804: IGS_GE_MSG_STACK.ADD;
805: app_exception.raise_exception;
806: ELSE
807: RAISE;
808: END IF;
809: END update_row;

Line 907: app_exception.raise_exception;

903: igs_ge_msg_stack.add;
904: IF (x_mode = 'S') THEN
905: igs_sc_gen_001.unset_ctx('R');
906: END IF;
907: app_exception.raise_exception;
908: END IF;
909: IF (x_mode = 'S') THEN
910: igs_sc_gen_001.unset_ctx('R');
911: END IF;