APPS.IGS_EN_SPLACEMENTS_API dependencies on APP_EXCEPTION

Line 109: APP_EXCEPTION.RAISE_EXCEPTION;

105: IF l_dup_found = 'Y' THEN
106: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PLCMNT_SUP_DUP');
107: FND_MESSAGE.SET_TOKEN('PERSON_NAME',P_LAST_NAME || ', ' || P_FIRST_NAME);
108: IGS_GE_MSG_STACK.ADD;
109: APP_EXCEPTION.RAISE_EXCEPTION;
110: END IF;
111: END IF;
112:
113: IGS_PE_PERSON_PKG.INSERT_ROW(

Line 176: APP_EXCEPTION.RAISE_EXCEPTION;

172: X_ATTRIBUTE24 => NULL);
173:
174: IF l_return_status IN ('E','U') THEN
175: FND_MESSAGE.SET_ENCODED(l_msg_data);
176: APP_EXCEPTION.RAISE_EXCEPTION;
177: END IF;
178:
179: END IF;
180:

Line 234: APP_EXCEPTION.RAISE_EXCEPTION;

230: -- the record was updated by some other user hence the object version number is not matching.
231: CLOSE cur_c2;
232: FND_MESSAGE.SET_NAME ('FND',' FORM_RECORD_DELETED');
233: IGS_GE_MSG_STACK.ADD;
234: APP_EXCEPTION.RAISE_EXCEPTION;
235: END IF;
236: END IF;
237:
238:

Line 283: APP_EXCEPTION.RAISE_EXCEPTION;

279: CLOSE cur_c2;
280:
281: IF l_return_status IN ('E', 'U') THEN
282: FND_MESSAGE.SET_ENCODED (l_msg_data);
283: APP_EXCEPTION.RAISE_EXCEPTION;
284: END IF;
285: END IF;
286:
287: -- if email address is not null but email id is null, new record - insert

Line 338: APP_EXCEPTION.RAISE_EXCEPTION;

334: -- the record was updated by some other user hence the object version number is not matching.
335: CLOSE cur_c3;
336: FND_MESSAGE.SET_NAME('FND',' FORM_RECORD_DELETED');
337: IGS_GE_MSG_STACK.ADD;
338: APP_EXCEPTION.RAISE_EXCEPTION;
339: END IF;
340: END IF;
341:
342: IF p_email_address IS NULL THEN

Line 390: APP_EXCEPTION.RAISE_EXCEPTION;

386:
387: -- CHECK FOR THE V_RETURN_STATUS
388: IF l_RETURN_STATUS IN ( 'E' , 'U' ) THEN
389: FND_MESSAGE.SET_ENCODED(L_MSG_DATA);
390: APP_EXCEPTION.RAISE_EXCEPTION;
391: END IF;
392:
393: END IF;
394:

Line 465: APP_EXCEPTION.RAISE_EXCEPTION;

461:
462: CLOSE cur_c1;
463: IF L_RETURN_STATUS IN ('E','U') THEN
464: FND_MESSAGE.SET_ENCODED(L_MSG_DATA);
465: APP_EXCEPTION.RAISE_EXCEPTION;
466: END IF;
467:
468: END IF;
469: END IF;