DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on CTO_CUSTOM_CATALOG_DESC

Line 166: | if custom package CTO_CUSTOM_CATALOG_DESC.catalog_desc_method is

162: |
163: | Modified : 02-02-2005 Kiran Konada
164: | bug#4092184 FP:11.5.9 - 11.5.10 :I
165: | customer bug#4081613
166: | if custom package CTO_CUSTOM_CATALOG_DESC.catalog_desc_method is
167: | set to 'C' to use custom api AND if model item is not assigned
168: | to a catalog group. Create configuration process fails
169: |
170: | Fix has been made not to honor the custom package if a ato model

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

3567: -- bugfix 2765635: This is a round-about fix for this issue by calling a custom-hook.
3568: -- Refer bug for details.
3569: -- begin bugfix
3570:
3571: if CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'C' then
3572: -- Call Custom API with details..
3573:
3574: IF PG_DEBUG <> 0 THEN
3575: oe_debug_pub.add ('Prepare data for calling custom hook...');

Line 3584: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;

3580: select ELEMENT_NAME
3581: from mtl_descr_element_values
3582: where inventory_item_id = pConfigId;
3583:
3584: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
3585: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;
3586: i NUMBER;
3587: original_count NUMBER;
3588: l_return_status VARCHAR2(1);

Line 3585: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;

3581: from mtl_descr_element_values
3582: where inventory_item_id = pConfigId;
3583:
3584: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
3585: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;
3586: i NUMBER;
3587: original_count NUMBER;
3588: l_return_status VARCHAR2(1);
3589:

Line 3617: CTO_CUSTOM_CATALOG_DESC.user_catalog_desc (

3613: oe_debug_pub.add ('Parameter passed: l_params.p_item_id = '||l_params.p_item_id ||
3614: '; l_params.p_org_id = '||l_params.p_org_id );
3615: END IF;
3616:
3617: CTO_CUSTOM_CATALOG_DESC.user_catalog_desc (
3618: p_params => l_params,
3619: p_catalog_dtls => l_catalog_dtls,
3620: x_return_status => l_return_status);
3621:

Line 3624: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error');

3620: x_return_status => l_return_status);
3621:
3622: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
3623: IF PG_DEBUG <> 0 THEN
3624: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error');
3625: END IF;
3626: RAISE FND_API.G_EXC_ERROR ;
3627:
3628: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

Line 3630: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error');

3626: RAISE FND_API.G_EXC_ERROR ;
3627:
3628: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
3629: IF PG_DEBUG <> 0 THEN
3630: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error');
3631: END IF;
3632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3633:
3634: end if ;

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

3668: end if; --bugfix 4081613
3669:
3670: END;
3671:
3672: elsif CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'Y' then
3673: lStmtNum := 332;
3674: IF PG_DEBUG <> 0 THEN
3675: oe_debug_pub.add ('Std feature : Rollup lower level model catalog desc to top level');
3676: END IF;