DBA Data[Home] [Help]

APPS.IGS_AD_APPL_HIST_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 101: APP_EXCEPTION.RAISE_EXCEPTION;

97: )THEN
98: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
99: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
100: IGS_GE_MSG_STACK.ADD;
101: APP_EXCEPTION.RAISE_EXCEPTION;
102: END IF;
103: END IF;
104:
105: IF (((old_references.acad_cal_type = new_references.acad_cal_type) AND

Line 118: APP_EXCEPTION.RAISE_EXCEPTION;

114: )THEN
115: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ACAD_CAL'));
117: IGS_GE_MSG_STACK.ADD;
118: APP_EXCEPTION.RAISE_EXCEPTION;
119: END IF;
120: END IF;
121:
122: IF (((old_references.person_id = new_references.person_id)) OR

Line 132: APP_EXCEPTION.RAISE_EXCEPTION;

128: )THEN
129: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
130: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON'));
131: IGS_GE_MSG_STACK.ADD;
132: APP_EXCEPTION.RAISE_EXCEPTION;
133: END IF;
134: END IF;
135:
136: IF (((old_references.adm_appl_status = new_references.adm_appl_status)) OR

Line 146: APP_EXCEPTION.RAISE_EXCEPTION;

142: )THEN
143: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
144: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_APPL_STATUS'));
145: IGS_GE_MSG_STACK.ADD;
146: APP_EXCEPTION.RAISE_EXCEPTION;
147: END IF;
148: END IF;
149:
150: IF (((old_references.adm_fee_status = new_references.adm_fee_status)) OR

Line 160: APP_EXCEPTION.RAISE_EXCEPTION;

156: )THEN
157: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_FEE_STATUS'));
159: IGS_GE_MSG_STACK.ADD;
160: APP_EXCEPTION.RAISE_EXCEPTION;
161: END IF;
162: END IF;
163:
164: IF (((old_references.admission_cat = new_references.admission_cat) AND

Line 177: APP_EXCEPTION.RAISE_EXCEPTION;

173: )THEN
174: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_PRCS_CAT'));
176: IGS_GE_MSG_STACK.ADD;
177: APP_EXCEPTION.RAISE_EXCEPTION;
178: END IF;
179: END IF;
180:
181: END Check_Parent_Existance;

Line 231: APP_EXCEPTION.RAISE_EXCEPTION;

227: IF new_references.tac_appl_ind NOT IN ('Y','N') THEN
228: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
229: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_TAC_APPL_IND'));
230: IGS_GE_MSG_STACK.ADD;
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: END IF;
233: END IF;
234:
235: END CHECK_CONSTRAINTS;

Line 299: APP_EXCEPTION.RAISE_EXCEPTION;

295: new_references.hist_start_dt
296: )THEN
297: FND_MESSAGE.SET_NAME('IGS','IGS_GE_MULTI_ORG_DUP_REC');
298: IGS_GE_MSG_STACK.ADD;
299: APP_EXCEPTION.RAISE_EXCEPTION;
300: END IF;
301: Check_Constraints;
302: Check_Parent_Existance;
303:

Line 321: APP_EXCEPTION.RAISE_EXCEPTION;

317: new_references.hist_start_dt
318: )THEN
319: FND_MESSAGE.SET_NAME('IGS','IGS_GE_MULTI_ORG_DUP_REC');
320: IGS_GE_MSG_STACK.ADD;
321: APP_EXCEPTION.RAISE_EXCEPTION;
322: END IF;
323: Check_Constraints;
324: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
325: -- Call all the procedures related to Before Delete.

Line 385: app_exception.raise_exception;

381: end if;
382: else
383: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
384: IGS_GE_MSG_STACK.ADD;
385: app_exception.raise_exception;
386: end if;
387: Before_DML (
388: p_action => 'INSERT',
389: x_rowid => X_ROWID,

Line 483: app_exception.raise_exception;

479: -- that the ownerof policy function does not have privilege to access.
480: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
481: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
482: IGS_GE_MSG_STACK.ADD;
483: app_exception.raise_exception;
484: ELSE
485: RAISE;
486: END IF;
487: end INSERT_ROW;

Line 532: app_exception.raise_exception;

528: if (c1%notfound) then
529: close c1;
530: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
531: IGS_GE_MSG_STACK.ADD;
532: app_exception.raise_exception;
533: return;
534: end if;
535: close c1;
536:

Line 574: app_exception.raise_exception;

570: null;
571: else
572: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
573: IGS_GE_MSG_STACK.ADD;
574: app_exception.raise_exception;
575: end if;
576: return;
577: end LOCK_ROW;
578:

Line 618: app_exception.raise_exception;

614: end if;
615: else
616: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
617: IGS_GE_MSG_STACK.ADD;
618: app_exception.raise_exception;
619: end if;
620: Before_DML (
621: p_action => 'UPDATE',
622: x_rowid => X_ROWID,

Line 667: app_exception.raise_exception;

663: ;
664: if (sql%notfound) then
665: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
666: IGS_GE_MSG_STACK.ADD;
667: app_exception.raise_exception;
668: end if;
669: After_DML (
670: p_action => 'UPDATE',
671: x_rowid => X_ROWID

Line 685: app_exception.raise_exception;

681: -- that the ownerof policy function does not have privilege to access.
682: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
683: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
684: IGS_GE_MSG_STACK.ADD;
685: app_exception.raise_exception;
686: ELSE
687: RAISE;
688: END IF;
689: end UPDATE_ROW;

Line 777: app_exception.raise_exception;

773: where ROWID = X_ROWID;
774: if (sql%notfound) then
775: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
776: IGS_GE_MSG_STACK.ADD;
777: app_exception.raise_exception;
778: end if;
779: After_DML (
780: p_action => 'DELETE',
781: x_rowid => X_ROWID

Line 794: app_exception.raise_exception;

790: -- that the ownerof policy function does not have privilege to access.
791: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
792: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
793: IGS_GE_MSG_STACK.ADD;
794: app_exception.raise_exception;
795: ELSE
796: RAISE;
797: END IF;
798: end DELETE_ROW;