DBA Data[Home] [Help]

APPS.WMS_OPP_CYC_COUNT dependencies on FND_PROFILE

Line 42: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'),0);

38: RETURN NUMBER
39: IS
40: l_api_name CONSTANT VARCHAR2(30) := 'Get_total_item_qty';
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'),0);
43:
44: l_tot_qty NUMBER;
45: l_loaded_sys_qty NUMBER;
46: l_serial_number_control_code NUMBER;

Line 205: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'),0);

201: RETURN NUMBER
202: IS
203: l_api_name CONSTANT VARCHAR2(30) := 'Get_latest_cc_days';
204: l_api_version CONSTANT NUMBER := 1.0;
205: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'),0);
206:
207: l_no_of_days NUMBER;
208: l_opp_cyc_count_days NUMBER:=0;
209:

Line 273: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'),0);

269: RETURN NUMBER
270: IS
271: l_api_name CONSTANT VARCHAR2(30) := 'Is_cyc_count_enabled';
272: l_api_version CONSTANT NUMBER := 1.0;
273: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'),0);
274: l_progress VARCHAR2(500) := 'Entered API';
275:
276: l_tot_qty NUMBER;
277: l_sub_tol_qty NUMBER;

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

447: )
448: IS
449: l_api_name CONSTANT VARCHAR2(30) := 'delete_existing_cyc_count';
450: l_api_version CONSTANT NUMBER := 1.0;
451: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
452: BEGIN
453:
454: IF ( l_debug = 1 ) THEN
455: Mdebug ( l_api_name||' : Entered api ' || l_api_name , g_message);

Line 513: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'),0);

509: x_system_quantity OUT NOCOPY NUMBER)
510: IS
511: l_api_name CONSTANT VARCHAR2(30) := 'get_system_qty';
512: l_api_version CONSTANT NUMBER := 1.0;
513: l_debug NUMBER := Nvl(fnd_profile.Value('INV_DEBUG_TRACE'),0);
514:
515: l_tot_qty NUMBER;
516: l_cnt_qty NUMBER:=0;
517: l_loaded_sys_qty NUMBER;

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

805: l_serial_number_control_code NUMBER;
806: l_progress VARCHAR2 ( 10 );
807: l_loaded_sys_qty NUMBER;
808: l_cnt_qty NUMBER:=0;
809: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
810:
811: BEGIN
812:
813: IF ( l_debug = 1 ) THEN

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

1041: l_api_version CONSTANT NUMBER := 1.0;
1042: l_serial_number_control_code NUMBER;
1043: l_progress VARCHAR2 ( 10 );
1044: l_allocated_pri_qty NUMBER;
1045: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1046:
1047: BEGIN
1048:
1049: IF ( l_debug = 1 ) THEN

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

1256: l_api_version CONSTANT NUMBER := 1.0;
1257: l_serial_number_control_code NUMBER;
1258: l_progress VARCHAR2 ( 10 );
1259: l_allocated_pri_qty NUMBER;
1260: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1261: BEGIN
1262:
1263: IF ( l_debug = 1 ) THEN
1264: Mdebug ( l_api_name||' : Entered api ' || l_api_name , g_message);

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

1363: IS
1364: l_api_name CONSTANT VARCHAR2(30) := 'process_backorder';
1365: l_api_version CONSTANT NUMBER := 1.0;
1366: l_progress VARCHAR2 ( 10 );
1367: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1368:
1369: l_min_backorder_qty NUMBER;
1370: l_tot_backorder_qty NUMBER:=0;
1371: l_trx_tmp_id NUMBER;

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

1516:
1517: l_api_name CONSTANT VARCHAR2(30) := 'backorder_pending_tasks';
1518: l_api_version CONSTANT NUMBER := 1.0;
1519: l_progress VARCHAR2 ( 10 );
1520: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
1521:
1522: l_count_primary_qty NUMBER;
1523: l_count_qty NUMBER;
1524: l_alloc_qty NUMBER;

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

2244: l_return_status VARCHAR2(1):= fnd_api.G_RET_STS_SUCCESS;
2245: l_progress VARCHAR2(500) := 'Entered API';
2246: l_msg_count NUMBER;
2247: l_msg_data VARCHAR2(4000);
2248: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2249:
2250: BEGIN
2251:
2252: IF ( l_debug = 1 ) THEN

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

2410: l_return_status VARCHAR2(1):= fnd_api.G_RET_STS_SUCCESS;
2411: l_progress VARCHAR2(500) := 'Entered API';
2412: l_msg_count NUMBER;
2413: l_msg_data VARCHAR2(4000);
2414: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
2415: l_alloc_qty NUMBER;
2416: l_alloc_cur t_genref;
2417: l_det_alloc_qty NUMBER;
2418: l_det_alloc_cur t_genref;