DBA Data[Home] [Help]

APPS.WMS_DEVHIST_HANDLER_PKG dependencies on APP_EXCEPTION

Line 247: app_exception.raise_exception;

243: IF (l_debug = 1) THEN
244: inv_log_util.trace('inside LOCK ROW c%notfound','WMS_DEVHIST_HANDLER_PKG',9);
245: END IF;
246: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
247: app_exception.raise_exception;
248: end if;
249: close c;
250: IF (l_debug = 1) THEN
251: inv_log_util.trace('inside LOCK ROW','WMS_DEVHIST_HANDLER_PKG',9);

Line 324: app_exception.raise_exception;

320: IF (l_debug = 1) THEN
321: inv_log_util.trace('inside LOCK ROW WILL SHOW CHNAGED MESG','WMS_DEVHIST_HANDLER_PKG',9);
322: END IF;
323: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
324: app_exception.raise_exception;
325: end if;
326: end LOCK_ROW;
327:
328: procedure UPDATE_ROW (

Line 588: app_exception.raise_exception;

584: inv_log_util.trace('inside exception'||SQLCODE,'WMS_DEVHIST_HANDLER_PKG',9);
585: END IF;
586: IF SQLCODE = -54 THEN --record locked by other session
587: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
588: app_exception.raise_exception;
589: END IF;
590:
591:
592: end UPDATE_CHILD_RECORDS;

Line 660: app_exception.raise_exception;

656: fetch c into recinfo;
657: if (c%notfound) then
658: close c;
659: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
660: app_exception.raise_exception;
661: end if;
662: close c;
663:
664: if ( (recinfo.request_id = x_request_id)

Line 681: app_exception.raise_exception;

677: ) then
678: return;
679: ELSE
680: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
681: app_exception.raise_exception;
682: end if;
683: --END IF;
684:
685: END lock_child_row;