eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UTIL_UC_PKG dependencies on FND_LOG

Line 707: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

703:
704: BEGIN
705: x_item_assoc_id := NULL;
706:
707: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'p_ignore_quant_vald => '||p_ignore_quant_vald);
709: END IF;
710:
711: OPEN ahl_relationships_csr(p_mc_relationship_id, p_Inventory_id, p_Organization_id, p_revision);

Line 708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'p_ignore_quant_vald => '||p_ignore_quant_vald);

704: BEGIN
705: x_item_assoc_id := NULL;
706:
707: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
708: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'p_ignore_quant_vald => '||p_ignore_quant_vald);
709: END IF;
710:
711: OPEN ahl_relationships_csr(p_mc_relationship_id, p_Inventory_id, p_Organization_id, p_revision);
712: LOOP

Line 716: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

712: LOOP
713: FETCH ahl_relationships_csr into l_item_posn_rec;
714: EXIT WHEN (l_assoc_rec_found OR ahl_relationships_csr%NOTFOUND);
715:
716: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
717: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Org check is done, p_Organization_id => '||p_Organization_id);
718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item Quantity => '||l_Item_Posn_rec.Itm_qty||
719: ', Position Quantity => '||l_Item_Posn_rec.posn_qty);
720: END IF;

Line 717: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Org check is done, p_Organization_id => '||p_Organization_id);

713: FETCH ahl_relationships_csr into l_item_posn_rec;
714: EXIT WHEN (l_assoc_rec_found OR ahl_relationships_csr%NOTFOUND);
715:
716: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
717: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Org check is done, p_Organization_id => '||p_Organization_id);
718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item Quantity => '||l_Item_Posn_rec.Itm_qty||
719: ', Position Quantity => '||l_Item_Posn_rec.posn_qty);
720: END IF;
721:

Line 718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item Quantity => '||l_Item_Posn_rec.Itm_qty||

714: EXIT WHEN (l_assoc_rec_found OR ahl_relationships_csr%NOTFOUND);
715:
716: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
717: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Org check is done, p_Organization_id => '||p_Organization_id);
718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item Quantity => '||l_Item_Posn_rec.Itm_qty||
719: ', Position Quantity => '||l_Item_Posn_rec.posn_qty);
720: END IF;
721:
722: IF (l_Item_Posn_rec.Itm_qty IS NULL OR l_Item_Posn_rec.Itm_qty = 0) THEN

Line 741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

737: to_unit => l_Item_Posn_rec.posn_uom_code,
738: from_name => NULL,
739: to_name => NULL );
740:
741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
743: END IF;
744:
745: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec.posn_qty OR nvl(p_ignore_quant_vald,'N') = 'Y')) THEN

Line 742: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);

738: from_name => NULL,
739: to_name => NULL );
740:
741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
743: END IF;
744:
745: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec.posn_qty OR nvl(p_ignore_quant_vald,'N') = 'Y')) THEN
746: l_assoc_rec_found := TRUE;

Line 770: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

766: to_unit => l_Item_Posn_rec.Itm_uom_code,
767: from_name => NULL,
768: to_name => NULL );
769:
770: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
772: END IF;
773:
774: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec.Itm_qty OR nvl(p_ignore_quant_vald,'N') = 'Y' )) THEN

Line 771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);

767: from_name => NULL,
768: to_name => NULL );
769:
770: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
772: END IF;
773:
774: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec.Itm_qty OR nvl(p_ignore_quant_vald,'N') = 'Y' )) THEN
775: l_assoc_rec_found := TRUE;

Line 792: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

788: LOOP
789: FETCH ahl_relationships_csr1 into l_item_posn_rec1;
790: EXIT WHEN (l_assoc_rec_found OR ahl_relationships_csr1%NOTFOUND);
791:
792: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'No Org check done');
794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item Quantity => '||l_Item_Posn_rec1.Itm_qty||
795: ', Position Quantity => '||l_Item_Posn_rec1.posn_qty);
796: END IF;

Line 793: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'No Org check done');

789: FETCH ahl_relationships_csr1 into l_item_posn_rec1;
790: EXIT WHEN (l_assoc_rec_found OR ahl_relationships_csr1%NOTFOUND);
791:
792: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'No Org check done');
794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item Quantity => '||l_Item_Posn_rec1.Itm_qty||
795: ', Position Quantity => '||l_Item_Posn_rec1.posn_qty);
796: END IF;
797:

Line 794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item Quantity => '||l_Item_Posn_rec1.Itm_qty||

790: EXIT WHEN (l_assoc_rec_found OR ahl_relationships_csr1%NOTFOUND);
791:
792: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'No Org check done');
794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item Quantity => '||l_Item_Posn_rec1.Itm_qty||
795: ', Position Quantity => '||l_Item_Posn_rec1.posn_qty);
796: END IF;
797:
798: IF (l_Item_Posn_rec1.Itm_qty IS NULL OR l_Item_Posn_rec1.Itm_qty = 0) THEN

Line 817: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

813: to_unit => l_Item_Posn_rec1.posn_uom_code,
814: from_name => NULL,
815: to_name => NULL );
816:
817: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
818: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
819: END IF;
820:
821: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec1.posn_qty OR nvl(p_ignore_quant_vald,'N') = 'Y')) THEN

Line 818: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);

814: from_name => NULL,
815: to_name => NULL );
816:
817: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
818: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
819: END IF;
820:
821: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec1.posn_qty OR nvl(p_ignore_quant_vald,'N') = 'Y')) THEN
822: l_assoc_rec_found := TRUE;

Line 846: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

842: to_unit => l_Item_Posn_rec1.Itm_uom_code,
843: from_name => NULL,
844: to_name => NULL );
845:
846: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
847: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
848: END IF;
849:
850: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec1.Itm_qty OR nvl(p_ignore_quant_vald,'N') = 'Y')) THEN

Line 847: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);

843: from_name => NULL,
844: to_name => NULL );
845:
846: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
847: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'inv_convert.inv_um_convert returned l_quantity => '||l_quantity);
848: END IF;
849:
850: IF (l_quantity >=0 AND (l_quantity <= l_Item_Posn_rec1.Itm_qty OR nvl(p_ignore_quant_vald,'N') = 'Y')) THEN
851: l_assoc_rec_found := TRUE;

Line 879: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

875: FND_MESSAGE.Set_Name('AHL','AHL_UC_INVGRP_MISMATCH');
876: FND_MESSAGE.Set_Token('POSN_REF',l_pos_ref_meaning);
877: FND_MSG_PUB.ADD;
878:
879: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
880: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item invalid for l_pos_ref_meaning => '||l_pos_ref_meaning);
881: END IF;
882: END IF;
883:

Line 880: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item invalid for l_pos_ref_meaning => '||l_pos_ref_meaning);

876: FND_MESSAGE.Set_Token('POSN_REF',l_pos_ref_meaning);
877: FND_MSG_PUB.ADD;
878:
879: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
880: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item invalid for l_pos_ref_meaning => '||l_pos_ref_meaning);
881: END IF;
882: END IF;
883:
884: END Validate_for_Position;

Line 2555: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2551: END IF;
2552:
2553: -- if valid uc header id could not be derived return false.
2554: IF l_uc_header_id IS NULL THEN
2555: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_unit_header_id :'||p_unit_header_id);
2557: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. l_uc_header_id :'||l_uc_header_id );
2558: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_instance_id :'||p_instance_id);
2559: END IF;

Line 2556: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_unit_header_id :'||p_unit_header_id);

2552:
2553: -- if valid uc header id could not be derived return false.
2554: IF l_uc_header_id IS NULL THEN
2555: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_unit_header_id :'||p_unit_header_id);
2557: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. l_uc_header_id :'||l_uc_header_id );
2558: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_instance_id :'||p_instance_id);
2559: END IF;
2560: RETURN FND_API.G_FALSE;

Line 2557: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. l_uc_header_id :'||l_uc_header_id );

2553: -- if valid uc header id could not be derived return false.
2554: IF l_uc_header_id IS NULL THEN
2555: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_unit_header_id :'||p_unit_header_id);
2557: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. l_uc_header_id :'||l_uc_header_id );
2558: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_instance_id :'||p_instance_id);
2559: END IF;
2560: RETURN FND_API.G_FALSE;
2561: ELSE

Line 2558: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_instance_id :'||p_instance_id);

2554: IF l_uc_header_id IS NULL THEN
2555: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_unit_header_id :'||p_unit_header_id);
2557: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. l_uc_header_id :'||l_uc_header_id );
2558: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_instance_id :'||p_instance_id);
2559: END IF;
2560: RETURN FND_API.G_FALSE;
2561: ELSE
2562: -- else derive uc status code

Line 2712: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

2708: l_valid_UC_lst VARCHAR2(2000) := NULL;
2709:
2710: BEGIN
2711:
2712: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2713: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
2714: END IF;
2715:
2716: -- Standard call to check for call compatibility

Line 2713: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');

2709:
2710: BEGIN
2711:
2712: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2713: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
2714: END IF;
2715:
2716: -- Standard call to check for call compatibility
2717: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 2732: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2728: x_return_status := FND_API.G_RET_STS_SUCCESS;
2729:
2730: -- Validating the instance table
2731: IF (l_instance_tbl.COUNT >0) THEN
2732: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2733: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating for '||
2734: l_instance_tbl.COUNT||' items with flag: '||p_operator);
2735: END IF;
2736:

Line 2733: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating for '||

2729:
2730: -- Validating the instance table
2731: IF (l_instance_tbl.COUNT >0) THEN
2732: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2733: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating for '||
2734: l_instance_tbl.COUNT||' items with flag: '||p_operator);
2735: END IF;
2736:
2737: --For all the records in the instance table

Line 2739: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2735: END IF;
2736:
2737: --For all the records in the instance table
2738: FOR i in l_instance_tbl.FIRST..l_instance_tbl.LAST LOOP
2739: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2740: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Details of '||i||
2741: ' table item: IG id '||l_instance_tbl(i).item_group_id||
2742: ' INV id '||l_instance_tbl(i).inventory_item_id||
2743: ' ORG id '||l_instance_tbl(i).inventory_org_id);

Line 2740: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Details of '||i||

2736:
2737: --For all the records in the instance table
2738: FOR i in l_instance_tbl.FIRST..l_instance_tbl.LAST LOOP
2739: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2740: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Details of '||i||
2741: ' table item: IG id '||l_instance_tbl(i).item_group_id||
2742: ' INV id '||l_instance_tbl(i).inventory_item_id||
2743: ' ORG id '||l_instance_tbl(i).inventory_org_id);
2744: END IF;

Line 2755: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2751: FETCH c_check_item_group_csr INTO l_check_item_group_rec;
2752:
2753: --Proceed if item group is found
2754: IF (c_check_item_group_csr%FOUND) THEN
2755: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2756: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||' table item exists');
2757: END IF;
2758:
2759: --Get all the positions the item group is associated to

Line 2756: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||' table item exists');

2752:
2753: --Proceed if item group is found
2754: IF (c_check_item_group_csr%FOUND) THEN
2755: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2756: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||' table item exists');
2757: END IF;
2758:
2759: --Get all the positions the item group is associated to
2760: FOR position_rec IN c_get_associated_posns_csr(l_instance_tbl(i).item_group_id)

Line 2773: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2769: l_valid_UC_lst := l_valid_UC_lst || top_node_csr_rec.name || ' - '||
2770: AHL_MC_PATH_POSITION_PVT.get_posref_for_uc(
2771: top_node_csr_rec.unit_config_header_id,position_rec.relationship_id) || ', ';
2772:
2773: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2774: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||
2775: ' table item installed at root of '||
2776: top_node_csr_rec.name||' with rel id: '||
2777: position_rec.relationship_id);

Line 2774: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||

2770: AHL_MC_PATH_POSITION_PVT.get_posref_for_uc(
2771: top_node_csr_rec.unit_config_header_id,position_rec.relationship_id) || ', ';
2772:
2773: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2774: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||
2775: ' table item installed at root of '||
2776: top_node_csr_rec.name||' with rel id: '||
2777: position_rec.relationship_id);
2778: END IF;

Line 2796: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2792: l_valid_UC_lst := l_valid_UC_lst || l_unitname || ' - '||
2793: AHL_MC_PATH_POSITION_PVT.get_posref_for_uc(
2794: l_unitid,position_rec.relationship_id) || ', ';
2795:
2796: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2797: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||
2798: ' table item installed in '||l_unitname||
2799: ' with rel id: '||position_rec.relationship_id);
2800: END IF;

Line 2797: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||

2793: AHL_MC_PATH_POSITION_PVT.get_posref_for_uc(
2794: l_unitid,position_rec.relationship_id) || ', ';
2795:
2796: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2797: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||
2798: ' table item installed in '||l_unitname||
2799: ' with rel id: '||position_rec.relationship_id);
2800: END IF;
2801: END IF;

Line 2807: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2803: CLOSE c_get_uc_header_info_csr;
2804: END LOOP; --item_instance_rec
2805: END LOOP; --position_rec
2806:
2807: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2808: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Msg token formed: '||l_valid_UC_lst||
2809: ' for Item name: '||l_instance_tbl(i).concatenated_segments||
2810: ' revision: '||l_instance_tbl(i).revision);
2811: END IF;

Line 2808: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Msg token formed: '||l_valid_UC_lst||

2804: END LOOP; --item_instance_rec
2805: END LOOP; --position_rec
2806:
2807: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2808: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Msg token formed: '||l_valid_UC_lst||
2809: ' for Item name: '||l_instance_tbl(i).concatenated_segments||
2810: ' revision: '||l_instance_tbl(i).revision);
2811: END IF;
2812:

Line 2842: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

2838:
2839: END LOOP;
2840: END IF; -- IF count > 0
2841:
2842: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2843: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
2844: END IF;
2845:
2846: EXCEPTION

Line 2843: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');

2839: END LOOP;
2840: END IF; -- IF count > 0
2841:
2842: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2843: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
2844: END IF;
2845:
2846: EXCEPTION
2847: WHEN FND_API.G_EXC_ERROR THEN

Line 2927: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2923: l_pos_reference csi_ii_relationships.position_reference%TYPE;
2924: l_temp_num NUMBER;
2925:
2926: BEGIN
2927: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2928: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2929: L_DEBUG_KEY || '.begin',
2930: 'At the start of the procedure. p_inventory_item_id = ' || p_inventory_item_id ||
2931: ', p_item_revision = ' || p_item_revision ||

Line 2928: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2924: l_temp_num NUMBER;
2925:
2926: BEGIN
2927: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2928: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2929: L_DEBUG_KEY || '.begin',
2930: 'At the start of the procedure. p_inventory_item_id = ' || p_inventory_item_id ||
2931: ', p_item_revision = ' || p_item_revision ||
2932: ', p_instance_id = ' || p_instance_id);

Line 2941: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2937: OPEN get_uc_header_id_csr;
2938: FETCH get_uc_header_id_csr INTO l_uc_header_id, l_master_config_id;
2939: CLOSE get_uc_header_id_csr;
2940: IF (l_uc_header_id IS NOT NULL) THEN
2941: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2943: L_DEBUG_KEY,
2944: 'Instance is a unit. Unit Id: ' || l_uc_header_id);
2945: END IF;

Line 2942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2938: FETCH get_uc_header_id_csr INTO l_uc_header_id, l_master_config_id;
2939: CLOSE get_uc_header_id_csr;
2940: IF (l_uc_header_id IS NOT NULL) THEN
2941: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2942: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2943: L_DEBUG_KEY,
2944: 'Instance is a unit. Unit Id: ' || l_uc_header_id);
2945: END IF;
2946: -- Instance is a unit: Get the item group of the root node of the unit's MC

Line 2968: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2964: END IF;
2965: END IF;
2966: END IF;
2967:
2968: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2969: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2970: L_DEBUG_KEY,
2971: 'Item group id of instance: ' || l_node_ig_id);
2972: END IF;

Line 2969: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2965: END IF;
2966: END IF;
2967:
2968: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2969: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2970: L_DEBUG_KEY,
2971: 'Item group id of instance: ' || l_node_ig_id);
2972: END IF;
2973:

Line 2986: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2982: END IF;
2983: CLOSE item_group_has_item_csr;
2984: END IF;
2985:
2986: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2988: L_DEBUG_KEY || '.end',
2989: 'At the end of the procedure. x_matches_flag = ' || x_matches_flag);
2990: END IF;

Line 2987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2983: CLOSE item_group_has_item_csr;
2984: END IF;
2985:
2986: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2988: L_DEBUG_KEY || '.end',
2989: 'At the end of the procedure. x_matches_flag = ' || x_matches_flag);
2990: END IF;
2991: END Item_Matches_Instance_Pos;