APPS.PA_ROLE_CONTROLS_PVT dependencies on FND_API

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32: x_msg_count := 0;
33: x_msg_data := NULL;
34:
35: -- Initialize the return status to success
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: PA_ROLE_CONTROLS_PKG.Insert_Row
39: (X_ROWID => P_ROWID,
40: X_ROLE_CONTROL_CODE => P_ROLE_CONTROL_CODE,

Line 56: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

52: EXCEPTION
53: WHEN OTHERS THEN
54: x_msg_count := 1;
55: x_msg_data := substr(SQLERRM,1,240);
56: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
57: FND_MSG_PUB.add_exc_msg
58: (p_pkg_name => 'PA_ROLE_CONTROLS_PVT'
59: , p_procedure_name => PA_DEBUG.G_Err_Stack
60: , p_error_text => substr(SQLERRM,1,240));

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

91: x_msg_count := 0;
92: x_msg_data := NULL;
93:
94: -- Initialize the return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96:
97: PA_ROLE_CONTROLS_PKG.LOCK_ROW
98: (X_ROWID => P_ROWID,
99: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER

Line 109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

105: EXCEPTION
106: WHEN OTHERS THEN
107: x_msg_count := 1;
108: x_msg_data := substr(SQLERRM,1,240);
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
110: FND_MSG_PUB.add_exc_msg
111: (p_pkg_name => 'PA_ROLE_CONTROLS_PVT'
112: , p_procedure_name => PA_DEBUG.G_Err_Stack
113: , p_error_text => substr(SQLERRM,1,240));

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

145: x_msg_count := 0;
146: x_msg_data := NULL;
147:
148: -- Initialize the return status to success
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151: PA_ROLE_CONTROLS_PKG.UPDATE_ROW
152: (X_ROWID => P_ROWID,
153: X_ROLE_CONTROL_CODE => P_ROLE_CONTROL_CODE,

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

165: EXCEPTION
166: WHEN OTHERS THEN
167: x_msg_count := 1;
168: x_msg_data := substr(SQLERRM,1,240);
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: FND_MSG_PUB.add_exc_msg
171: (p_pkg_name => 'PA_ROLE_CONTROLS_PVT'
172: , p_procedure_name => PA_DEBUG.G_Err_Stack
173: , p_error_text => substr(SQLERRM,1,240));

Line 219: x_return_status := FND_API.G_RET_STS_SUCCESS;

215: x_msg_count := 0;
216: x_msg_data := NULL;
217:
218: -- Initialize the return status to success
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220:
221: -- Check if OK to Delete the Project Role Id for the P_Rowid IN Parameter
222:
223: SELECT project_role_id, role_control_code

Line 235: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

231: x_return_status => l_return_status,
232: x_error_message_code => l_error_message_code
233: );
234:
235: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
236: THEN
237: x_msg_count := 1;
238: x_msg_data := l_error_message_code;
239: x_return_status := l_return_status;

Line 260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

256: EXCEPTION
257: WHEN OTHERS THEN
258: x_msg_count := 1;
259: x_msg_data := substr(SQLERRM,1,240);
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: FND_MSG_PUB.add_exc_msg
262: (p_pkg_name => 'PA_ROLE_CONTROLS_PVT'
263: , p_procedure_name => PA_DEBUG.G_Err_Stack
264: , p_error_text => substr(SQLERRM,1,240));