DBA Data[Home] [Help]

APPS.AMW_PROC_APPROVAL_PKG dependencies on FND_API

Line 689: p_commit in varchar2 := FND_API.G_FALSE,

685:
686:
687: procedure autoapprove(
688: p_process_id in number,
689: p_commit in varchar2 := FND_API.G_FALSE,
690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
692: x_return_status out nocopy varchar2,
693: x_msg_count out nocopy number,

Line 690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

686:
687: procedure autoapprove(
688: p_process_id in number,
689: p_commit in varchar2 := FND_API.G_FALSE,
690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
692: x_return_status out nocopy varchar2,
693: x_msg_count out nocopy number,
694: x_msg_data out nocopy varchar2 )

Line 691: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

687: procedure autoapprove(
688: p_process_id in number,
689: p_commit in varchar2 := FND_API.G_FALSE,
690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
692: x_return_status out nocopy varchar2,
693: x_msg_count out nocopy number,
694: x_msg_data out nocopy varchar2 )
695:

Line 705: x_return_status := FND_API.G_RET_STS_SUCCESS;

701: l_msg_data varchar2(4000);
702:
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

Line 706: IF FND_API.to_Boolean( p_init_msg_list ) THEN

702:
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');

Line 711: RAISE FND_API.G_EXC_ERROR;

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;
712: END IF;
713:
714: sub_for_approval (p_process_id);
715: approve(p_process_id);

Line 719: WHEN FND_API.G_EXC_ERROR THEN

715: approve(p_process_id);
716:
717: exception
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);

Line 721: x_return_status := FND_API.G_RET_STS_ERROR;

717: exception
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

Line 722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count =>

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;

Line 725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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);

Line 727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

723: x_msg_count,p_data => x_msg_data);
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

Line 728: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count =>

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;

Line 733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

729: x_msg_count,p_data => x_msg_data);
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;

Line 738: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,

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:

Line 800: p_commit in varchar2 := FND_API.G_FALSE,

796: procedure check_approval_subm_eligib(
797: p_process_id in number,
798: p_result out nocopy varchar2,
799: p_out_mesg out nocopy varchar2,
800: p_commit in varchar2 := FND_API.G_FALSE,
801: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
802: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
803: x_return_status out nocopy varchar2,
804: x_msg_count out nocopy number,

Line 801: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

797: p_process_id in number,
798: p_result out nocopy varchar2,
799: p_out_mesg out nocopy varchar2,
800: p_commit in varchar2 := FND_API.G_FALSE,
801: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
802: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
803: x_return_status out nocopy varchar2,
804: x_msg_count out nocopy number,
805: x_msg_data out nocopy varchar2 )

Line 802: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

798: p_result out nocopy varchar2,
799: p_out_mesg out nocopy varchar2,
800: p_commit in varchar2 := FND_API.G_FALSE,
801: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
802: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
803: x_return_status out nocopy varchar2,
804: x_msg_count out nocopy number,
805: x_msg_data out nocopy varchar2 )
806:

Line 819: x_return_status := FND_API.G_RET_STS_SUCCESS;

815: st_var_pid number;
816:
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

Line 820: IF FND_API.to_Boolean( p_init_msg_list ) THEN

816:
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');

Line 825: RAISE FND_API.G_EXC_ERROR;

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;
826: END IF;
827:
828: p_result := 'Y';
829: p_out_mesg := null;

Line 857: WHEN FND_API.G_EXC_ERROR THEN

853: end if;
854:
855: exception
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:

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855: exception
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;

Line 860: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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;

Line 862: WHEN FND_API.G_EXC_UNEXPECTED_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;
865: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
866:

Line 864: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 865: 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;
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;

Line 869: 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;
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;

Line 874: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

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: