4983: AND
4984: p_config_session_key.session_item_id is not null
4985: THEN
4986:
4987: l_configurator_enabled := fnd_profile.value('CSI_CONFIGURATOR_ENABLED');
4988:
4989: -- check for config txn details
4990: BEGIN
4991: SELECT 'Y' INTO l_td_found
5059: debug('check_standard_bom for Project Contracts');
5060:
5061: /* look at the explode_yes_no profile AND go FROM there */
5062:
5063: l_explode_flag := nvl(fnd_profile.value('CSI_EXPLODE_BOM'),'N');
5064: debug('Explode BOM Profile Option :'||l_explode_flag);
5065:
5066: IF l_explode_flag <> 'Y' THEN
5067: debug('Explode BOM Profile option is not set. ');
5581: BEGIN
5582: SELECT instance_status_id
5583: INTO l_instance_rec.instance_status_id
5584: FROM csi_instance_statuses
5585: WHERE name = fnd_profile.value('csi_default_instance_status');
5586: EXCEPTION
5587: WHEN no_data_found THEN
5588: l_instance_rec.instance_status_id := 510;
5589: END;