185: IF NOT (l_reference_found) THEN
186:
187: SELECT decode(p_reference_type,'P','Parent','N','Non Source','S','Source')
188: INTO l_reference_code
189: FROM sys.dual;
190:
191: fnd_message.set_name('CSI','CSI_TXN_SRC_REF_NOT_FOUND');
192: fnd_message.set_token('REF_TYPE',l_reference_code);
193: fnd_msg_pub.add;
3130: /* check if the returned item is a nonserial item which has children */
3131: BEGIN
3132: SELECT 'Y'
3133: INTO l_config_return
3134: FROM sys.dual
3135: WHERE exists (SELECT relationship_id
3136: FROM csi_ii_relationships
3137: WHERE object_id = l_u_instance_rec.instance_id
3138: AND relationship_type_code = 'COMPONENT-OF');