APPS.SERIAL_CHECK dependencies on APP_EXCEPTIONS

Line 251: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION then

247: END;
248: END IF;
249: /*** End R12 }} ***/
250: EXCEPTION
251: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION then
252: IF success = 1 then
253: CLOSE serial_lock1;
254: else
255: CLOSE serial_lock2;

Line 260: inv_log_util.trace('app_exceptions.record_lock_exception', 'SERIAL_CHECK');

256: end if;
257: success := -2;
258: if( l_debug = 1 ) then
259: inv_log_util.trace('success is ' || success, 'SERIAL_CHECK');
260: inv_log_util.trace('app_exceptions.record_lock_exception', 'SERIAL_CHECK');
261: end if;
262: WHEN OTHERS then
263: IF success = 1 then
264: CLOSE serial_lock1;

Line 817: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

813: WHERE inventory_item_id = item_id
814: AND current_organization_id = org_id
815: AND serial_number = from_serial_number ;
816: EXCEPTION
817: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
818: success := FALSE;
819: IF (l_debug = 1) THEN
820: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
821: END IF;

Line 820: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');

816: EXCEPTION
817: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
818: success := FALSE;
819: IF (l_debug = 1) THEN
820: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
821: END IF;
822: END;
823:
824: success := TRUE;

Line 843: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

839: AND current_organization_id = org_id
840: AND serial_number between from_serial_number AND to_serial_number
841: AND LENGTH(serial_number) = LENGTH(from_serial_number) ;
842: EXCEPTION
843: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
844: success := FALSE;
845: IF (l_debug = 1) THEN
846: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
847: END IF;

Line 846: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');

842: EXCEPTION
843: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
844: success := FALSE;
845: IF (l_debug = 1) THEN
846: inv_log_util.trace('APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION','SERIAL_CHECK');
847: END IF;
848: END;
849:
850: success := TRUE;