DBA Data[Home] [Help]

APPS.GMI_OM_ALLOC_API_PUB dependencies on FND_PROFILE

Line 268: l_default_lot := FND_PROFILE.VALUE('IC$DEFAULT_LOT');

264:
265: /*Init variables
266: =========================================*/
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268: l_default_lot := FND_PROFILE.VALUE('IC$DEFAULT_LOT');
269: l_default_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
270: l_allow_negative_inv := FND_PROFILE.VALUE('IC$ALLOWNEGINV');
271: l_overpick_enabled := FND_PROFILE.VALUE('WSH_OVERPICK_ENABLED');
272:

Line 269: l_default_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

265: /*Init variables
266: =========================================*/
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268: l_default_lot := FND_PROFILE.VALUE('IC$DEFAULT_LOT');
269: l_default_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
270: l_allow_negative_inv := FND_PROFILE.VALUE('IC$ALLOWNEGINV');
271: l_overpick_enabled := FND_PROFILE.VALUE('WSH_OVERPICK_ENABLED');
272:
273: --

Line 270: l_allow_negative_inv := FND_PROFILE.VALUE('IC$ALLOWNEGINV');

266: =========================================*/
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268: l_default_lot := FND_PROFILE.VALUE('IC$DEFAULT_LOT');
269: l_default_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
270: l_allow_negative_inv := FND_PROFILE.VALUE('IC$ALLOWNEGINV');
271: l_overpick_enabled := FND_PROFILE.VALUE('WSH_OVERPICK_ENABLED');
272:
273: --
274: -- BUG 3581429 Added the following anonymous block

Line 271: l_overpick_enabled := FND_PROFILE.VALUE('WSH_OVERPICK_ENABLED');

267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268: l_default_lot := FND_PROFILE.VALUE('IC$DEFAULT_LOT');
269: l_default_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
270: l_allow_negative_inv := FND_PROFILE.VALUE('IC$ALLOWNEGINV');
271: l_overpick_enabled := FND_PROFILE.VALUE('WSH_OVERPICK_ENABLED');
272:
273: --
274: -- BUG 3581429 Added the following anonymous block
275: --

Line 277: l_epsilon := to_number(NVL(FND_PROFILE.VALUE('IC$EPSILON'),0)) ;

273: --
274: -- BUG 3581429 Added the following anonymous block
275: --
276: BEGIN
277: l_epsilon := to_number(NVL(FND_PROFILE.VALUE('IC$EPSILON'),0)) ;
278: n := (-1) * round(log(10,l_epsilon));
279: EXCEPTION
280: WHEN OTHERS THEN
281: n := 9;

Line 1997: l_debug_level VARCHAR2(240) := TO_NUMBER(NVL(fnd_profile.value ('ONT_DEBUG_LEVEL'),0));

1993: l_log UTL_FILE.file_type;
1994: l_time VARCHAR2(10);
1995: l_file_name VARCHAR2(80);
1996: l_sessionid NUMBER := 0;
1997: l_debug_level VARCHAR2(240) := TO_NUMBER(NVL(fnd_profile.value ('ONT_DEBUG_LEVEL'),0));
1998:
1999: BEGIN
2000:
2001: IF (l_debug_level >= 5)