DBA Data[Home] [Help]

APPS.INV_CONVERT dependencies on FND_PROFILE

Line 1060: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1056:
1057: l_loc_uom VARCHAR2(3):= null;
1058: l_uom_string VARCHAR2(20) := null;
1059: l_api_name CONSTANT VARCHAR2(30) := 'PICK_UOM_CONVERT';
1060: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1061:
1062: begin
1063:
1064: -- Initialize API return status to success

Line 1171: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1167: l_mmtt_sec_qty NUMBER;
1168: l_fulfillment_base VARCHAR2(1) := 'P';
1169: l_uom_string VARCHAR2(20) := null;
1170: l_api_name CONSTANT VARCHAR2(30) := 'pick_uom_convert_for_dual_uom';
1171: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1172:
1173: begin
1174:
1175: -- Initialize API return status to success

Line 1308: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1304: ,p_item_id IN NUMBER
1305: ,p_fulfillment_base IN VARCHAR2) RETURN VARCHAR2 IS
1306:
1307: l_uom_in_same_class VARCHAR2(1) :='Y';
1308: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1309:
1310: BEGIN
1311: IF Nvl(p_fulfillment_base,'P') = 'P'
1312: THEN

Line 1406: l_debug PLS_INTEGER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1402:
1403: l_uom_code1 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1404: l_uom_code2 MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1405: x_precision NUMBER;
1406: l_debug PLS_INTEGER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1407: l_procname VARCHAR2 (20) := 'within_deviation';
1408: BEGIN
1409:
1410: FND_MSG_PUB.INITIALIZE;

Line 1603: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1599: p_to_uom_code IN VARCHAR2) RETURN NUMBER
1600: IS
1601:
1602: l_conversion_rate NUMBER;
1603: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1604: l_api_name CONSTANT VARCHAR2(30) := 'inv_um_convert';
1605:
1606: BEGIN
1607: IF (p_from_uom_code = p_to_uom_code) THEN