APPS.WMS_TRIPSTOPS_STAGELANES_PUB dependencies on FND_PROFILE

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

1: PACKAGE BODY WMS_TRIPSTOPS_STAGELANES_PUB AS
2: /* $Header: WMSDKTSB.pls 120.6 2008/03/20 06:36:40 shikapoo ship $ */
3:
4: PROCEDURE trace(p_message IN VARCHAR2) iS
5: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6: BEGIN
7: inv_pick_wave_pick_confirm_pub.tracelog(err_msg => p_message,
8: module => 'WMSDKTSB: ');
9: END trace;

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

21: l_dock_id NUMBER := 0;
22: l_staging_lane_id NUMBER := 0;
23: l_stg_ln_id NUMBER := 0;
24:
25: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
26: BEGIN
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: IF (l_debug = 1) THEN

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

172: get_stglanes_for_dkdr_rec get_stglanes_for_dkdr_cur%rowtype;
173:
174: l_cur_staging_lane_id NUMBER;
175:
176: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
177: BEGIN
178: OPEN get_stglanes_for_dkdr_cur;
179: IF (l_debug = 1) THEN
180: trace('FUNCTION get_available_staginglane trip stop id = ' || p_trip_stop);

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

328: RETURN NUMBER
329: IS
330: l_dummy NUMBER := 0;
331:
332: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
333: BEGIN
334: IF (l_debug = 1) THEN
335: trace('Before select in FUNCTION check_if_stagelane_assigned');
336: END IF;

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

393: RETURN NUMBER
394: IS
395: x_stage_id NUMBER := 0;
396: l_date_end_time VARCHAR2(30);
397: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
398: BEGIN
399: IF (l_debug = 1) THEN
400: trace('FUNCTION get_earliest_available_stglane - dock door id passed = ' || p_dock_id);
401: END IF;

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

467: , x_staging_lane_id OUT NOCOPY NUMBER
468: , x_dkdr_trpstp_exists OUT NOCOPY BOOLEAN)
469: IS
470: -- l_dkdr_trpstp_exists BOOLEAN := TRUE;
471: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
472: BEGIN
473: IF (l_debug = 1) THEN
474: trace('Before select in FUNCTION check_dockdoor_tripstop_exists trip stop = ' || p_trip_stop);
475: END IF;

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

563: , p_stage_lane_id IN NUMBER
564: , p_trip_stop IN NUMBER
565: , p_dock_id IN NUMBER)
566: IS
567: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
568: BEGIN
569: SAVEPOINT update_dock_sp;
570: --x_return_status := FND_API.G_RET_STS_SUCCESS;
571: IF (l_debug = 1) THEN

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

615: , p_staging_lane_id IN NUMBER)
616: RETURN VARCHAR2
617: IS
618: l_sub_code VARCHAR2(30);
619: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
620: BEGIN
621: IF (l_debug = 1) THEN
622: trace('Before select in FUNCTION get_subinventory_code Staging lane = '||p_staging_lane_id);
623: END IF;