125: RETURN l_dft_exists_tbl;
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: PO_MESSAGE_S.add_exc_msg
130: ( p_pkg_name => d_pkg_name,
131: p_procedure_name => d_api_name || '.' || d_position
132: );
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: RETURN l_exists_tbl(1);
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: PO_MESSAGE_S.add_exc_msg
192: ( p_pkg_name => d_pkg_name,
193: p_procedure_name => d_api_name || '.' || d_position
194: );
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: );
379:
380: EXCEPTION
381: WHEN OTHERS THEN
382: PO_MESSAGE_S.add_exc_msg
383: ( p_pkg_name => d_pkg_name,
384: p_procedure_name => d_api_name || '.' || d_position
385: );
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: END IF;
473:
474: EXCEPTION
475: WHEN OTHERS THEN
476: PO_MESSAGE_S.add_exc_msg
477: ( p_pkg_name => d_pkg_name,
478: p_procedure_name => d_api_name || '.' || d_position
479: );
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571:
572: d_position := 30;
573: EXCEPTION
574: WHEN OTHERS THEN
575: PO_MESSAGE_S.add_exc_msg
576: ( p_pkg_name => d_pkg_name,
577: p_procedure_name => d_api_name || '.' || d_position
578: );
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;