5: PROCEDURE mydebug(msg in varchar2)
6: IS
7: l_msg VARCHAR2(5100);
8: l_ts VARCHAR2(30);
9: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10: BEGIN
11: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
12: l_msg:=l_ts||' '||msg;
13:
52: l_serial_allocated_flag VARCHAR2(1);
53: l_serial_transaction_temp_id NUMBER;
54: --BUG 12769978 end
55:
56: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
57: BEGIN
58: l_progress := '10';
59: SAVEPOINT sp_skip_task_adjustments;
60: l_emp_id := p_sign_on_emp_id ;