APPS.ASO_PROJ_COMM_INT dependencies on FND_API

Line 13: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_PROJ_COMM_INT';
11:
12: PROCEDURE Calculate_Proj_Commission (
13: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
14: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
15: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
16: P_Resource_Id IN NUMBER := FND_API.G_MISS_NUM,
17: X_Last_Update_Date OUT NOCOPY /* file.sql.39 change */ DATE,

Line 14: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_PROJ_COMM_INT';
11:
12: PROCEDURE Calculate_Proj_Commission (
13: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
14: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
15: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
16: P_Resource_Id IN NUMBER := FND_API.G_MISS_NUM,
17: X_Last_Update_Date OUT NOCOPY /* file.sql.39 change */ DATE,
18: X_Object_Version_Number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 16: P_Resource_Id IN NUMBER := FND_API.G_MISS_NUM,

12: PROCEDURE Calculate_Proj_Commission (
13: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
14: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
15: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
16: P_Resource_Id IN NUMBER := FND_API.G_MISS_NUM,
17: X_Last_Update_Date OUT NOCOPY /* file.sql.39 change */ DATE,
18: X_Object_Version_Number OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
19: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 36: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

32: -- Standard Start of API savepoint
33: SAVEPOINT CALCULATE_PROJ_COMMISSION_INT;
34:
35: -- Standard call to check for call compatibility.
36: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
37: 1.0,
38: l_api_name,
39: G_PKG_NAME)
40: THEN

Line 41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

37: 1.0,
38: l_api_name,
39: G_PKG_NAME)
40: THEN
41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

38: l_api_name,
39: G_PKG_NAME)
40: THEN
41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF FND_API.to_Boolean( p_init_msg_list )

Line 46: IF FND_API.to_Boolean( p_init_msg_list )

42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF FND_API.to_Boolean( p_init_msg_list )
47: THEN
48: FND_MSG_PUB.initialize;
49: END IF;
50:

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

48: FND_MSG_PUB.initialize;
49: END IF;
50:
51: -- Initialize API return status to SUCCESS
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: --
55: -- API body
56: --

Line 59: P_Init_Msg_List => FND_API.G_FALSE,

55: -- API body
56: --
57:
58: ASO_PROJ_COMM_PVT.Calculate_Proj_Commission (
59: P_Init_Msg_List => FND_API.G_FALSE,
60: P_Commit => FND_API.G_FALSE,
61: P_Qte_Header_Rec => p_qte_header_rec,
62: P_Resource_Id => p_resource_id,
63: X_Object_Version_Number => x_object_version_number,

Line 60: P_Commit => FND_API.G_FALSE,

56: --
57:
58: ASO_PROJ_COMM_PVT.Calculate_Proj_Commission (
59: P_Init_Msg_List => FND_API.G_FALSE,
60: P_Commit => FND_API.G_FALSE,
61: P_Qte_Header_Rec => p_qte_header_rec,
62: P_Resource_Id => p_resource_id,
63: X_Object_Version_Number => x_object_version_number,
64: X_Last_Update_Date => x_last_update_date,

Line 74: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

70: IF aso_debug_pub.g_debug_flag = 'Y' THEN
71: aso_debug_pub.add('After ASO_PROJ_COMM_PVT.Calculate_Proj_Commission: '||x_return_status,1,'Y');
72: END IF;
73:
74: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 75: RAISE FND_API.G_EXC_ERROR;

71: aso_debug_pub.add('After ASO_PROJ_COMM_PVT.Calculate_Proj_Commission: '||x_return_status,1,'Y');
72: END IF;
73:
74: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;

Line 77: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

73:
74: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80:
81: -- Standard call to get message count and if count is 1, get message info.

Line 78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

74: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
75: RAISE FND_API.G_EXC_ERROR;
76: END IF;
77: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80:
81: -- Standard call to get message count and if count is 1, get message info.
82: FND_MSG_PUB.Count_And_Get

Line 89: WHEN FND_API.G_EXC_ERROR THEN

85: );
86:
87: EXCEPTION
88:
89: WHEN FND_API.G_EXC_ERROR THEN
90: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
91: P_API_NAME => L_API_NAME,
92: P_PKG_NAME => G_PKG_NAME,
93: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

98: X_MSG_DATA => X_MSG_DATA,
99: X_RETURN_STATUS => X_RETURN_STATUS
100: );
101:
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
104: P_API_NAME => L_API_NAME,
105: P_PKG_NAME => G_PKG_NAME,
106: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,