404: exception
405:
406: when unappr_xst_excpt then
407: rollback;
408: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');
409: err_msg := fnd_message.get;
410: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_proc_org_approval_pkg',
411: p_procedure_name => 'check_hier_approved',
412: p_error_text => err_msg);
405:
406: when unappr_xst_excpt then
407: rollback;
408: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');
409: err_msg := fnd_message.get;
410: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_proc_org_approval_pkg',
411: p_procedure_name => 'check_hier_approved',
412: p_error_text => err_msg);
413: raise;
466:
467: exception
468:
469: when unappr_xst_excpt then
470: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');
471: err_msg := fnd_message.get;
472: p_result := 'N';
473: p_out_mesg := err_msg;
474:
467: exception
468:
469: when unappr_xst_excpt then
470: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');
471: err_msg := fnd_message.get;
472: p_result := 'N';
473: p_out_mesg := err_msg;
474:
475: end check_hier_approved;
874:
875: exception
876:
877: when unappr_obj_exception then
878: fnd_message.set_name('AMW','AMW_UNAPPRV_ASSOC');
879: err_msg := fnd_message.get;
880: if raise_ex = 'Y' then
881: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_PROC_ORG_APPROVAL_PKG',
882: p_procedure_name => 'prod_err_unapr_obj_ass_ex',
875: exception
876:
877: when unappr_obj_exception then
878: fnd_message.set_name('AMW','AMW_UNAPPRV_ASSOC');
879: err_msg := fnd_message.get;
880: if raise_ex = 'Y' then
881: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_PROC_ORG_APPROVAL_PKG',
882: p_procedure_name => 'prod_err_unapr_obj_ass_ex',
883: p_error_text => err_msg);