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 712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

708:
709: BEGIN
710: x_item_assoc_id := NULL;
711:
712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'p_ignore_quant_vald => '||p_ignore_quant_vald);
714: END IF;
715:
716: OPEN ahl_relationships_csr(p_mc_relationship_id, p_Inventory_id, p_Organization_id, p_revision);

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

709: BEGIN
710: x_item_assoc_id := NULL;
711:
712: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
713: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'p_ignore_quant_vald => '||p_ignore_quant_vald);
714: END IF;
715:
716: OPEN ahl_relationships_csr(p_mc_relationship_id, p_Inventory_id, p_Organization_id, p_revision);
717: LOOP

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

880: FND_MESSAGE.Set_Name('AHL','AHL_UC_INVGRP_MISMATCH');
881: FND_MESSAGE.Set_Token('POSN_REF',l_pos_ref_meaning);
882: FND_MSG_PUB.ADD;
883:
884: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
885: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item invalid for l_pos_ref_meaning => '||l_pos_ref_meaning);
886: END IF;
887: END IF;
888:

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

881: FND_MESSAGE.Set_Token('POSN_REF',l_pos_ref_meaning);
882: FND_MSG_PUB.ADD;
883:
884: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
885: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Item invalid for l_pos_ref_meaning => '||l_pos_ref_meaning);
886: END IF;
887: END IF;
888:
889: END Validate_for_Position;

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

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

Line 2561: 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:
2558: -- if valid uc header id could not be derived return false.
2559: IF l_uc_header_id IS NULL THEN
2560: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2561: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_unit_header_id :'||p_unit_header_id);
2562: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. l_uc_header_id :'||l_uc_header_id );
2563: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_instance_id :'||p_instance_id);
2564: END IF;
2565: RETURN FND_API.G_FALSE;

Line 2562: 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: -- if valid uc header id could not be derived return false.
2559: IF l_uc_header_id IS NULL THEN
2560: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2561: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_unit_header_id :'||p_unit_header_id);
2562: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. l_uc_header_id :'||l_uc_header_id );
2563: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, l_debug_key, 'UC Header Id Derived as NULL. p_instance_id :'||p_instance_id);
2564: END IF;
2565: RETURN FND_API.G_FALSE;
2566: ELSE

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

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

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

2713: l_valid_UC_lst VARCHAR2(2000) := NULL;
2714:
2715: BEGIN
2716:
2717: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2718: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
2719: END IF;
2720:
2721: -- Standard call to check for call compatibility

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

2714:
2715: BEGIN
2716:
2717: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2718: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
2719: END IF;
2720:
2721: -- Standard call to check for call compatibility
2722: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

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

2733: x_return_status := FND_API.G_RET_STS_SUCCESS;
2734:
2735: -- Validating the instance table
2736: IF (l_instance_tbl.COUNT >0) THEN
2737: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2738: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating for '||
2739: l_instance_tbl.COUNT||' items with flag: '||p_operator);
2740: END IF;
2741:

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

2734:
2735: -- Validating the instance table
2736: IF (l_instance_tbl.COUNT >0) THEN
2737: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2738: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Validating for '||
2739: l_instance_tbl.COUNT||' items with flag: '||p_operator);
2740: END IF;
2741:
2742: --For all the records in the instance table

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

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

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

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

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

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

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

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

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

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

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

2775: AHL_MC_PATH_POSITION_PVT.get_posref_for_uc(
2776: top_node_csr_rec.unit_config_header_id,position_rec.relationship_id) || ', ';
2777:
2778: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2779: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||
2780: ' table item installed at root of '||
2781: top_node_csr_rec.name||' with rel id: '||
2782: position_rec.relationship_id);
2783: END IF;

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

2797: l_valid_UC_lst := l_valid_UC_lst || l_unitname || ' - '||
2798: AHL_MC_PATH_POSITION_PVT.get_posref_for_uc(
2799: l_unitid,position_rec.relationship_id) || ', ';
2800:
2801: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2802: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||
2803: ' table item installed in '||l_unitname||
2804: ' with rel id: '||position_rec.relationship_id);
2805: END IF;

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

2798: AHL_MC_PATH_POSITION_PVT.get_posref_for_uc(
2799: l_unitid,position_rec.relationship_id) || ', ';
2800:
2801: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2802: FND_LOG.string(FND_LOG.level_statement,l_full_name,i||
2803: ' table item installed in '||l_unitname||
2804: ' with rel id: '||position_rec.relationship_id);
2805: END IF;
2806: END IF;

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

2808: CLOSE c_get_uc_header_info_csr;
2809: END LOOP; --item_instance_rec
2810: END LOOP; --position_rec
2811:
2812: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2813: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Msg token formed: '||l_valid_UC_lst||
2814: ' for Item name: '||l_instance_tbl(i).concatenated_segments||
2815: ' revision: '||l_instance_tbl(i).revision);
2816: END IF;

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

2809: END LOOP; --item_instance_rec
2810: END LOOP; --position_rec
2811:
2812: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2813: FND_LOG.string(FND_LOG.level_statement,l_full_name,'Msg token formed: '||l_valid_UC_lst||
2814: ' for Item name: '||l_instance_tbl(i).concatenated_segments||
2815: ' revision: '||l_instance_tbl(i).revision);
2816: END IF;
2817:

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

2843:
2844: END LOOP;
2845: END IF; -- IF count > 0
2846:
2847: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2848: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
2849: END IF;
2850:
2851: EXCEPTION

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

2844: END LOOP;
2845: END IF; -- IF count > 0
2846:
2847: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2848: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'End of the API');
2849: END IF;
2850:
2851: EXCEPTION
2852: WHEN FND_API.G_EXC_ERROR THEN

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

2928: l_pos_reference csi_ii_relationships.position_reference%TYPE;
2929: l_temp_num NUMBER;
2930:
2931: BEGIN
2932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2934: L_DEBUG_KEY || '.begin',
2935: 'At the start of the procedure. p_inventory_item_id = ' || p_inventory_item_id ||
2936: ', p_item_revision = ' || p_item_revision ||

Line 2933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2929: l_temp_num NUMBER;
2930:
2931: BEGIN
2932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2934: L_DEBUG_KEY || '.begin',
2935: 'At the start of the procedure. p_inventory_item_id = ' || p_inventory_item_id ||
2936: ', p_item_revision = ' || p_item_revision ||
2937: ', p_instance_id = ' || p_instance_id);

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

2942: OPEN get_uc_header_id_csr;
2943: FETCH get_uc_header_id_csr INTO l_uc_header_id, l_master_config_id;
2944: CLOSE get_uc_header_id_csr;
2945: IF (l_uc_header_id IS NOT NULL) THEN
2946: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2947: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2948: L_DEBUG_KEY,
2949: 'Instance is a unit. Unit Id: ' || l_uc_header_id);
2950: END IF;

Line 2947: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

2969: END IF;
2970: END IF;
2971: END IF;
2972:
2973: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2975: L_DEBUG_KEY,
2976: 'Item group id of instance: ' || l_node_ig_id);
2977: END IF;

Line 2974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2970: END IF;
2971: END IF;
2972:
2973: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2975: L_DEBUG_KEY,
2976: 'Item group id of instance: ' || l_node_ig_id);
2977: END IF;
2978:

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

2987: END IF;
2988: CLOSE item_group_has_item_csr;
2989: END IF;
2990:
2991: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2992: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2993: L_DEBUG_KEY || '.end',
2994: 'At the end of the procedure. x_matches_flag = ' || x_matches_flag);
2995: END IF;

Line 2992: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2988: CLOSE item_group_has_item_csr;
2989: END IF;
2990:
2991: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2992: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2993: L_DEBUG_KEY || '.end',
2994: 'At the end of the procedure. x_matches_flag = ' || x_matches_flag);
2995: END IF;
2996: END Item_Matches_Instance_Pos;