APPS.PA_STATUSES_PVT dependencies on FND_API

Line 26: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE -- (Bug 1851096)

22: -- ============================================================================
23:
24: PROCEDURE delete_status_pvt
25: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --- (Bug 1851096)
26: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE -- (Bug 1851096)
27: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
28: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
29: ,p_max_msg_count IN NUMBER
30: ,p_pa_project_status_code IN VARCHAR2

Line 27: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

23:
24: PROCEDURE delete_status_pvt
25: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --- (Bug 1851096)
26: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE -- (Bug 1851096)
27: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
28: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
29: ,p_max_msg_count IN NUMBER
30: ,p_pa_project_status_code IN VARCHAR2
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 28: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

24: PROCEDURE delete_status_pvt
25: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --- (Bug 1851096)
26: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE -- (Bug 1851096)
27: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
28: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
29: ,p_max_msg_count IN NUMBER
30: ,p_pa_project_status_code IN VARCHAR2
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 64: IF NOT FND_API.Compatible_API_Call (

60: SAVEPOINT delete_status_pub;
61:
62: -- Standard call to check for call compatibility.
63:
64: IF NOT FND_API.Compatible_API_Call (
65: g_api_version_number ,
66: p_api_version_number ,
67: l_api_name ,
68: G_PKG_NAME ) THEN

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: g_api_version_number ,
66: p_api_version_number ,
67: l_api_name ,
68: G_PKG_NAME ) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72:
73: -- Initialize the message table if requested.

Line 75: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

71:
72:
73: -- Initialize the message table if requested.
74:
75: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79:

Line 82: x_return_status := FND_API.G_RET_STS_SUCCESS;

78:
79:
80: -- Set API return status to success
81:
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83: l_resp_id := FND_GLOBAL.Resp_id;
84: l_user_id := FND_GLOBAL.User_id;
85:
86:

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85:
86:
87: -- Check the status code passed
88: IF p_pa_project_status_code is NULL THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: -- get the status_type for the current status_code
93: select status_type

Line 123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

119: x_errorcode => l_errorcode ,
120: x_msg_count => l_msg_count ,
121: x_msg_data => l_msg_data);
122:
123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
124: l_msg_count := FND_MSG_PUB.count_msg;
125: If l_msg_count > 0 THEN
126: x_msg_count := l_msg_count;
127: If l_msg_count = 1 THEN

Line 129: (p_encoded => FND_API.G_TRUE ,

125: If l_msg_count > 0 THEN
126: x_msg_count := l_msg_count;
127: If l_msg_count = 1 THEN
128: pa_interface_utils_pub.get_messages
129: (p_encoded => FND_API.G_TRUE ,
130: p_msg_index => 1 ,
131: p_msg_count => l_msg_count ,
132: p_msg_data => l_msg_data ,
133: p_data => l_data ,

Line 139: RAISE FND_API.G_EXC_ERROR;

135: );
136: x_msg_data := l_data;
137: End if;
138: End if;
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141: End IF;
142: /* End of Changes for Bug 2778408 */
143: PA_PROJECT_STATUSES_PKG.delete_row(p_pa_project_status_code);

Line 149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

145: PA_NEXT_ALLOW_STATUSES_PKG.delete_row(p_pa_project_status_code);
146: ELSE
147: x_msg_data := x_err_stage;
148: ROLLBACK TO delete_status_pub;
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
152: COMMIT;
153:

Line 156: WHEN FND_API.G_EXC_ERROR THEN

152: COMMIT;
153:
154: EXCEPTION
155:
156: WHEN FND_API.G_EXC_ERROR THEN
157: ROLLBACK TO delete_status_pub;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count ,

Line 158: x_return_status := FND_API.G_RET_STS_ERROR;

154: EXCEPTION
155:
156: WHEN FND_API.G_EXC_ERROR THEN
157: ROLLBACK TO delete_status_pub;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count ,
161: p_data => x_msg_data );
162:

Line 163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count ,
161: p_data => x_msg_data );
162:
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: ROLLBACK TO delete_status_pub;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: FND_MSG_PUB.Count_And_Get
167: ( p_count => x_msg_count ,

Line 165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

161: p_data => x_msg_data );
162:
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: ROLLBACK TO delete_status_pub;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: FND_MSG_PUB.Count_And_Get
167: ( p_count => x_msg_count ,
168: p_data => x_msg_data );
169:

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: p_data => x_msg_data );
169:
170: WHEN ROW_ALREADY_LOCKED THEN
171: ROLLBACK TO delete_status_pub;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173:
174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
175: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
176: FND_MESSAGE.SET_TOKEN('ENTITY', p_pa_project_status_code);

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

181: p_data => x_msg_data );
182:
183: WHEN OTHERS THEN
184: ROLLBACK TO delete_status_pub;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
187: FND_MSG_PUB.add_exc_msg
188: ( p_pkg_name => G_PKG_NAME
189: , p_procedure_name => l_api_name