DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on CTO_CUSTOM_CATALOG_DESC

Line 49: | if custom package CTO_CUSTOM_CATALOG_DESC.catalog_desc_method is

45: |
46: | Modified : 02-02-2005 Kiran Konada
47: | bug#4092184 FP:11.5.9 - 11.5.10 :I
48: | customer bug#4081613
49: | if custom package CTO_CUSTOM_CATALOG_DESC.catalog_desc_method is
50: | set to 'C' to use custom api AND if model item is not assigned
51: | to a catalog group. Create configuration process fails
52: |
53: | Fix has been made not to honor the custom package if a ato model

Line 5070: if CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'C' then

5066: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
5067: lStmtNum := 330;
5068:
5069:
5070: if CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'C' then
5071: -- Call Custom API with details..
5072:
5073: WriteToLog ('Prepare data for calling custom hook...', 5);
5074:

Line 5081: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;

5077: select ELEMENT_NAME
5078: from mtl_descr_element_values
5079: where inventory_item_id = pConfigId;
5080:
5081: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
5082: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;
5083: i NUMBER;
5084: original_count NUMBER;
5085: l_return_status VARCHAR2(1);

Line 5082: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;

5078: from mtl_descr_element_values
5079: where inventory_item_id = pConfigId;
5080:
5081: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
5082: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;
5083: i NUMBER;
5084: original_count NUMBER;
5085: l_return_status VARCHAR2(1);
5086:

Line 5110: CTO_CUSTOM_CATALOG_DESC.user_catalog_desc (

5106:
5107: WriteToLog ('Parameter passed: l_params.p_item_id = '||l_params.p_item_id ||
5108: '; l_params.p_org_id = '||l_params.p_org_id , 5);
5109:
5110: CTO_CUSTOM_CATALOG_DESC.user_catalog_desc (
5111: p_params => l_params,
5112: p_catalog_dtls => l_catalog_dtls,
5113: x_return_status => l_return_status);
5114:

Line 5116: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);

5112: p_catalog_dtls => l_catalog_dtls,
5113: x_return_status => l_return_status);
5114:
5115: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
5116: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
5117: RAISE FND_API.G_EXC_ERROR ;
5118:
5119: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
5120: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);

Line 5120: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);

5116: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
5117: RAISE FND_API.G_EXC_ERROR ;
5118:
5119: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
5120: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);
5121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5122: end if ;
5123:
5124: if l_catalog_dtls.count <> original_count then

Line 5152: elsif CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'Y' then

5148:
5149: end if; --bugfix 4081613
5150: END;
5151:
5152: elsif CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'Y' then
5153: lStmtNum := 332;
5154: WriteToLog ('Std feature : Rollup lower level model catalog desc to top level', 4);
5155: update MTL_DESCR_ELEMENT_VALUES i
5156: set i.element_value =