289: when unappr_xst_excpt then
290: rollback;
291: fnd_message.set_name('AMW','AMW_UNAPPROV_PROC_DOWN');
292: err_msg := fnd_message.get;
293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_proc_approval_pkg',
294: p_procedure_name => 'check_hier_approved',
295: p_error_text => err_msg);
296: raise;
297:
670: when unappr_obj_exception then
671: fnd_message.set_name('AMW','AMW_UNAPPRV_ASSOC');
672: err_msg := fnd_message.get;
673: if raise_ex = 'Y' then
674: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_PROC_APPROVAL_PKG',
675: p_procedure_name => 'prod_err_unapr_obj_ass_ex',
676: p_error_text => err_msg);
677: raise;
678: else
703: begin
704:
705: x_return_status := FND_API.G_RET_STS_SUCCESS;
706: IF FND_API.to_Boolean( p_init_msg_list ) THEN
707: FND_MSG_PUB.initialize;
708: END IF;
709: IF FND_GLOBAL.User_Id IS NULL THEN
710: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
711: RAISE FND_API.G_EXC_ERROR;
718:
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count =>
723: x_msg_count,p_data => x_msg_data);
724:
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK;
724:
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count =>
729: x_msg_count,p_data => x_msg_data);
730:
731: WHEN OTHERS THEN
732: ROLLBACK;
730:
731: WHEN OTHERS THEN
732: ROLLBACK;
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
735: THEN
736: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
737: END IF;
738: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
732: ROLLBACK;
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
735: THEN
736: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
737: END IF;
738: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
739: p_data => x_msg_data);
740:
734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
735: THEN
736: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
737: END IF;
738: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,
739: p_data => x_msg_data);
740:
741: end autoapprove;
742:
817: begin
818:
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820: IF FND_API.to_Boolean( p_init_msg_list ) THEN
821: FND_MSG_PUB.initialize;
822: END IF;
823: IF FND_GLOBAL.User_Id IS NULL THEN
824: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
825: RAISE FND_API.G_EXC_ERROR;
856:
857: WHEN FND_API.G_EXC_ERROR THEN
858: ROLLBACK;
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
861:
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: ROLLBACK;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861:
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: ROLLBACK;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
866:
867: WHEN OTHERS THEN
868: ROLLBACK;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866:
867: WHEN OTHERS THEN
868: ROLLBACK;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
871: THEN
872: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
873: END IF;
874: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
868: ROLLBACK;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
871: THEN
872: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
873: END IF;
874: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
875:
876: end check_approval_subm_eligib;
870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
871: THEN
872: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
873: END IF;
874: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
875:
876: end check_approval_subm_eligib;
877:
878: