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 4871: if CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'C' then

4867: xTableName := 'MTL_DESCR_ELEMENT_VALUES';
4868: lStmtNum := 330;
4869:
4870:
4871: if CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'C' then
4872: -- Call Custom API with details..
4873:
4874: WriteToLog ('Prepare data for calling custom hook...', 5);
4875:

Line 4882: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;

4878: select ELEMENT_NAME
4879: from mtl_descr_element_values
4880: where inventory_item_id = pConfigId;
4881:
4882: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
4883: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;
4884: i NUMBER;
4885: original_count NUMBER;
4886: l_return_status VARCHAR2(1);

Line 4883: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;

4879: from mtl_descr_element_values
4880: where inventory_item_id = pConfigId;
4881:
4882: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
4883: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;
4884: i NUMBER;
4885: original_count NUMBER;
4886: l_return_status VARCHAR2(1);
4887:

Line 4911: CTO_CUSTOM_CATALOG_DESC.user_catalog_desc (

4907:
4908: WriteToLog ('Parameter passed: l_params.p_item_id = '||l_params.p_item_id ||
4909: '; l_params.p_org_id = '||l_params.p_org_id , 5);
4910:
4911: CTO_CUSTOM_CATALOG_DESC.user_catalog_desc (
4912: p_params => l_params,
4913: p_catalog_dtls => l_catalog_dtls,
4914: x_return_status => l_return_status);
4915:

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

4913: p_catalog_dtls => l_catalog_dtls,
4914: x_return_status => l_return_status);
4915:
4916: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
4917: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
4918: RAISE FND_API.G_EXC_ERROR ;
4919:
4920: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
4921: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);

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

4917: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error', 1);
4918: RAISE FND_API.G_EXC_ERROR ;
4919:
4920: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
4921: WriteToLog ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error', 1);
4922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4923: end if ;
4924:
4925: if l_catalog_dtls.count <> original_count then

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

4949:
4950: end if; --bugfix 4081613
4951: END;
4952:
4953: elsif CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'Y' then
4954: lStmtNum := 332;
4955: WriteToLog ('Std feature : Rollup lower level model catalog desc to top level', 4);
4956: update MTL_DESCR_ELEMENT_VALUES i
4957: set i.element_value =