13: l_msg VARCHAR2(5100);
14: l_ts VARCHAR2(30);
15: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16: BEGIN
17: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
18: -- l_msg:=l_ts||' '||msg;
19:
20: l_msg := msg;
21:
48: END IF;
49:
50: SELECT WMS_DEVICE_ASSIGNMENT_TEMP_S.nextval
51: INTO l_assign_temp_id
52: FROM DUAL;
53:
54: INSERT INTO WMS_DEVICE_ASSIGNMENT_TEMP
55: ( ASSIGNMENT_TEMP_ID,
56: EMPLOYEE_ID,