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

3475: -- bugfix 2765635: This is a round-about fix for this issue by calling a custom-hook.
3476: -- Refer bug for details.
3477: -- begin bugfix
3478:
3479: if CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'C' then
3480: -- Call Custom API with details..
3481:
3482: IF PG_DEBUG <> 0 THEN
3483: oe_debug_pub.add ('Prepare data for calling custom hook...');

Line 3492: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;

3488: select ELEMENT_NAME
3489: from mtl_descr_element_values
3490: where inventory_item_id = pConfigId;
3491:
3492: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
3493: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;
3494: i NUMBER;
3495: original_count NUMBER;
3496: l_return_status VARCHAR2(1);

Line 3493: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;

3489: from mtl_descr_element_values
3490: where inventory_item_id = pConfigId;
3491:
3492: l_catalog_dtls CTO_CUSTOM_CATALOG_DESC.CATALOG_DTLS_TBL_TYPE;
3493: l_params CTO_CUSTOM_CATALOG_DESC.INPARAMS;
3494: i NUMBER;
3495: original_count NUMBER;
3496: l_return_status VARCHAR2(1);
3497:

Line 3525: CTO_CUSTOM_CATALOG_DESC.user_catalog_desc (

3521: oe_debug_pub.add ('Parameter passed: l_params.p_item_id = '||l_params.p_item_id ||
3522: '; l_params.p_org_id = '||l_params.p_org_id );
3523: END IF;
3524:
3525: CTO_CUSTOM_CATALOG_DESC.user_catalog_desc (
3526: p_params => l_params,
3527: p_catalog_dtls => l_catalog_dtls,
3528: x_return_status => l_return_status);
3529:

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

3528: x_return_status => l_return_status);
3529:
3530: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
3531: IF PG_DEBUG <> 0 THEN
3532: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned exp error');
3533: END IF;
3534: RAISE FND_API.G_EXC_ERROR ;
3535:
3536: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

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

3534: RAISE FND_API.G_EXC_ERROR ;
3535:
3536: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
3537: IF PG_DEBUG <> 0 THEN
3538: oe_debug_pub.add ('CTO_CUSTOM_CATALOG_DESC.user_catalog_desc returned unexp error');
3539: END IF;
3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3541:
3542: end if ;

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

3576: end if; --bugfix 4081613
3577:
3578: END;
3579:
3580: elsif CTO_CUSTOM_CATALOG_DESC.catalog_desc_method = 'Y' then
3581: lStmtNum := 332;
3582: IF PG_DEBUG <> 0 THEN
3583: oe_debug_pub.add ('Std feature : Rollup lower level model catalog desc to top level');
3584: END IF;