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;
270: );
271:
272: EXCEPTION
273: WHEN OTHERS THEN
274: PO_MESSAGE_S.add_exc_msg
275: ( p_pkg_name => d_pkg_name,
276: p_procedure_name => d_api_name || '.' || d_position
277: );
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: PO_MESSAGE_S.add_exc_msg
369: ( p_pkg_name => d_pkg_name,
370: p_procedure_name => d_api_name || '.' || d_position
371: );
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463:
464: d_position := 30;
465: EXCEPTION
466: WHEN OTHERS THEN
467: PO_MESSAGE_S.add_exc_msg
468: ( p_pkg_name => d_pkg_name,
469: p_procedure_name => d_api_name || '.' || d_position
470: );
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;