272: OPEN csr_ftype_id;
273: FETCH csr_ftype_id into l_formula_type_id;
274: If csr_ftype_id%notfound Then
275: CLOSE csr_ftype_id;
276: fnd_message.set_name('FF', 'FF_34862_INV_FORMULA_TYPE');
277: fnd_message.set_token('FORMULA_TYPE',p_formula_type_name);
278: fnd_message.raise_error;
279: return 0;
280: End if;
273: FETCH csr_ftype_id into l_formula_type_id;
274: If csr_ftype_id%notfound Then
275: CLOSE csr_ftype_id;
276: fnd_message.set_name('FF', 'FF_34862_INV_FORMULA_TYPE');
277: fnd_message.set_token('FORMULA_TYPE',p_formula_type_name);
278: fnd_message.raise_error;
279: return 0;
280: End if;
281: CLOSE csr_ftype_id;
274: If csr_ftype_id%notfound Then
275: CLOSE csr_ftype_id;
276: fnd_message.set_name('FF', 'FF_34862_INV_FORMULA_TYPE');
277: fnd_message.set_token('FORMULA_TYPE',p_formula_type_name);
278: fnd_message.raise_error;
279: return 0;
280: End if;
281: CLOSE csr_ftype_id;
282:
307: OPEN csr_fcon_id;
308: FETCH csr_fcon_id into l_context_id;
309: If csr_fcon_id%notfound Then
310: CLOSE csr_fcon_id;
311: fnd_message.set_name('FF', 'FF_34861_INV_CONTEXT_TYPE');
312: fnd_message.set_token('CONTEXT',p_context_name);
313: fnd_message.raise_error;
314: return 0;
315: End if;
308: FETCH csr_fcon_id into l_context_id;
309: If csr_fcon_id%notfound Then
310: CLOSE csr_fcon_id;
311: fnd_message.set_name('FF', 'FF_34861_INV_CONTEXT_TYPE');
312: fnd_message.set_token('CONTEXT',p_context_name);
313: fnd_message.raise_error;
314: return 0;
315: End if;
316: CLOSE csr_fcon_id;
309: If csr_fcon_id%notfound Then
310: CLOSE csr_fcon_id;
311: fnd_message.set_name('FF', 'FF_34861_INV_CONTEXT_TYPE');
312: fnd_message.set_token('CONTEXT',p_context_name);
313: fnd_message.raise_error;
314: return 0;
315: End if;
316: CLOSE csr_fcon_id;
317: