DBA Data[Home] [Help]

APPS.INV_MOVE_ORDER_PUB dependencies on FND_PROFILE

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

73: l_return_status VARCHAR2(1);
74: l_trohdr_rec Trohdr_Rec_Type;
75: l_trolin_tbl Trolin_Tbl_Type := G_MISS_TROLIN_TBL;
76: l_trolin_val_tbl Trolin_Val_Tbl_Type := G_MISS_TROLIN_VAL_TBL;
77: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
78: BEGIN
79: if l_debug = 1 THEN
80: print_debug('enter Create Move Order Header', l_api_name);
81: end if;

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

326: WHERE organization_id = v_org_id
327: AND inventory_item_id = v_item_id;
328:
329: l_item_loc_ctrl NUMBER;
330: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
331:
332: --Bug 7148749, added for ship model complete handling
333: l_current_ship_model_id NUMBER;
334: l_shipmodel_start_index NUMBER;

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

1312: l_control_rec INV_GLOBALS.Control_Rec_Type;
1313: l_return_status VARCHAR2(1);
1314: l_trohdr_rec Trohdr_Rec_Type;
1315: l_trolin_tbl Trolin_Tbl_Type;
1316: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1317: BEGIN
1318:
1319: -- Standard call to check for call compatibility
1320:

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

1458: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Move_Order';
1459: l_return_status VARCHAR2(1);
1460: l_trohdr_rec Trohdr_Rec_Type;
1461: l_trolin_tbl Trolin_Tbl_Type;
1462: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1463: BEGIN
1464:
1465: -- Standard call to check for call compatibility
1466:

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

1607: l_api_name CONSTANT VARCHAR2(30):= 'Get_Move_Order';
1608: l_header_id NUMBER := p_header_id;
1609: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
1610: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
1611: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1612: BEGIN
1613:
1614: -- Standard call to check for call compatibility
1615:

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

1763: , x_trohdr_val_rec OUT NOCOPY Trohdr_Val_Rec_Type
1764: , x_trolin_val_tbl OUT NOCOPY Trolin_Val_Tbl_Type
1765: )
1766: IS
1767: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1768: BEGIN
1769:
1770: -- Convert trohdr
1771:

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

1808: IS
1809: l_trohdr_rec Trohdr_Rec_Type;
1810: l_trolin_rec Trolin_Rec_Type;
1811: l_index BINARY_INTEGER;
1812: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1813: BEGIN
1814:
1815: -- Init x_return_status.
1816:

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

1888: l_trohdr_rec Trohdr_Rec_Type := G_MISS_TROHDR_REC;
1889: l_trohdr_val_rec Trohdr_Val_Rec_Type := G_MISS_TROHDR_VAL_REC;
1890: l_trolin_tbl Trolin_Tbl_Type := p_trolin_tbl;
1891: l_trolin_val_tbl Trolin_Val_Tbl_Type := G_MISS_TROLIN_VAL_TBL;
1892: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1893: BEGIN
1894:
1895: -- Standard call to check for call compatibility
1896: IF NOT FND_API.Compatible_API_Call