DBA Data[Home] [Help]

APPS.WIP_CHANGE_STATUS dependencies on APP_EXCEPTION

Line 162: APP_EXCEPTION.RAISE_EXCEPTION;

158: IF SQL%NOTFOUND THEN
159: IF P_repetitive_schedule_id IS NOT NULL THEN
160: FND_MESSAGE.SET_NAME('WIP', 'WIP_NO_ACCT_PERIOD');
161: ROLLBACK;
162: APP_EXCEPTION.RAISE_EXCEPTION;
163:
164: ELSE
165: DECLARE
166: CURSOR C1 IS

Line 182: APP_EXCEPTION.RAISE_EXCEPTION;

178: IF C1%NOTFOUND THEN
179: CLOSE C1;
180: FND_MESSAGE.SET_NAME('WIP', 'WIP_NO_ACCT_PERIOD');
181: ROLLBACK;
182: APP_EXCEPTION.RAISE_EXCEPTION;
183:
184: END IF;
185: CLOSE C1;
186: END;

Line 255: APP_EXCEPTION.RAISE_EXCEPTION;

251: X_diff_routing := check_routing%NOTFOUND;
252: CLOSE check_routing;
253: IF X_diff_routing THEN
254: FND_MESSAGE.SET_NAME('WIP', 'WIP_SAME_ROUTING');
255: APP_EXCEPTION.RAISE_EXCEPTION;
256: END IF;
257: END CHECK_REPETITIVE_ROUTING;
258:
259:

Line 363: APP_EXCEPTION.RAISE_EXCEPTION;

359: CLOSE disc_info;
360:
361: IF NOT X_valid_job THEN
362: FND_MESSAGE.SET_NAME('WIP', 'WIP_QA_ACTION_NO_HOLD');
363: APP_EXCEPTION.RAISE_EXCEPTION;
364: END IF;
365: RELEASE (P_wip_entity_id, P_organization_id, '', '',
366: X_class_code, X_status_type, WIP_CONSTANTS.HOLD,
367: X_routing_exists, SYSDATE); /* fix for bug 2424987 */

Line 439: APP_EXCEPTION.RAISE_EXCEPTION;

435: CLOSE disc_info;
436:
437: IF NOT X_valid_job THEN
438: FND_MESSAGE.SET_NAME('WIP', 'WIP_QA_ACTION_NO_HOLD');
439: APP_EXCEPTION.RAISE_EXCEPTION;
440: END IF;
441:
442: RELEASE (P_wip_entity_id, P_organization_id, '', '',
443: X_class_code, X_status_type, WIP_CONSTANTS.RELEASED,