APPS.WMS_DEVHIST_HANDLER_PKG dependencies on FND_PROFILE

Line 56: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

52: AND business_event_id = x_business_event_id
53: AND task_summary = x_task_summary
54: AND Nvl(sequence_id,-999) = Nvl(x_sequence_id,-999);
55:
56: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
57: BEGIN
58: IF (l_debug = 1) THEN
59: inv_log_util.trace('inside inserting for HIST form','WMS_DEVHIST_HANDLER_PKG',9);
60: END IF;

Line 237: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

233: for update OF request_id,task_id,business_event_id,organization_id nowait;
234:
235: recinfo c%rowtype;
236:
237: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
238: BEGIN
239: open c;
240: fetch c into recinfo;
241: if (c%notfound) then

Line 374: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

370: X_REASON_ID IN NUMBER,
371: X_XFER_LPN_ID IN NUMBER
372: ) is
373:
374: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
375: BEGIN
376:
377: /*
378: IF (l_debug = 1) THEN

Line 439: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

435:
436: procedure DELETE_ROW (
437: X_ROWID in varchar2
438: ) is
439: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
440: begin
441:
442: /*
443: IF (l_debug = 1) THEN

Line 515: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

511: transaction_quantity,transfer_loc_id,transfer_sub_code,reason_id,device_status NOWAIT;
512:
513: recinfo_child_records C_child_records%ROWTYPE;
514:
515: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
516: BEGIN
517: /*
518: IF (l_debug = 1) THEN
519: inv_log_util.trace(' '||X_REQUEST_ID,'WMS_DEVHIST_HANDLER_PKG',9);

Line 602: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

598: X_SEQUENCE_ID IN NUMBER,
599: X_BUSINESS_EVENT_ID IN NUMBER
600: ) IS
601:
602: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
603: BEGIN
604: /*
605: IF (l_debug = 1) THEN
606: inv_log_util.trace('Inside delete_CHILD_RECORDS','WMS_DEVHIST_HANDLER_PKG',9);

Line 647: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

643: for update OF lot_number,lot_qty,serial_number nowait;
644:
645: recinfo c%rowtype;
646:
647: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
648: BEGIN
649: /*
650: IF (l_debug = 1) THEN
651: inv_log_util.trace('Inside lock_CHILD_RECORDS:::'||x_is_new_row,'WMS_DEVHIST_HANDLER_PKG',9);