APPS.INV_REPLENISH_COUNT_PVT dependencies on FND_PROFILE

Line 77: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

73: , p_count_secondary_uom_code IN VARCHAR2 -- INVCONV, NSRIVAST
74: , p_count_secondary_quantity IN NUMBER -- INVCONV, NSRIVAST
75: ) IS
76: l_proc CONSTANT VARCHAR2(30) := 'INSERT_ROW';
77: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
78: BEGIN
79: x_return_status := fnd_api.g_ret_sts_success;
80:
81: IF l_trace_on = 1 THEN

Line 212: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

208: , p_count_uom_code IN VARCHAR2
209: , p_count_secondary_quantity IN NUMBER -- INVCONV, NSRIVAST
210: ) IS
211: l_proc CONSTANT VARCHAR2(30) := 'UPDATE_ROW';
212: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
213: BEGIN
214: x_return_status := fnd_api.g_ret_sts_success;
215:
216: IF l_trace_on = 1 THEN

Line 286: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

282: , p_quantity_tracked IN NUMBER
283: ) IS
284: l_proc CONSTANT VARCHAR2(30) := 'FETCH_COUNT_LINES';
285: l_count NUMBER := 0;
286: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
287: BEGIN
288: x_return_status := fnd_api.g_ret_sts_success;
289:
290: IF l_trace_on = 1 THEN

Line 417: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

413: , p_subinventory_code IN VARCHAR2
414: , p_planning_level IN NUMBER
415: ) IS
416: l_func_name CONSTANT VARCHAR2(30) := 'GET_REPLENISH_COUNT_NAME';
417: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
418: BEGIN
419: x_return_status := fnd_api.g_ret_sts_success;
420:
421: IF l_trace_on = 1 THEN

Line 499: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

495: RETURN NUMBER IS
496: l_func_name CONSTANT VARCHAR2(30) := 'invalid_uncounted_lines_exist';
497: l_record_exists NUMBER := 0;
498: l_error_record_exists NUMBER := 0;
499: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
500: BEGIN
501: x_return_status := fnd_api.g_ret_sts_success;
502:
503: IF l_trace_on = 1 THEN

Line 669: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

665: )
666: RETURN NUMBER IS
667: l_func_name CONSTANT VARCHAR2(30) := 'IS_COUNT_VALID';
668: l_count_valid NUMBER := 1;
669: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
670: BEGIN
671: x_return_status := fnd_api.g_ret_sts_success;
672:
673: IF l_trace_on = 1 THEN

Line 726: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

722: , p_replenish_header_id IN NUMBER
723: , p_organization_id IN NUMBER
724: ) IS
725: l_proc CONSTANT VARCHAR2(30) := 'PROCESS_REPORT_COUNT';
726: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
727: BEGIN
728: x_return_status := fnd_api.g_ret_sts_success;
729:
730: IF l_trace_on = 1 THEN