DBA Data[Home] [Help]

APPS.PA_STATUS_LISTS_PVT dependencies on FND_API

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: x_msg_count := 0;
74: x_msg_data := NULL;
75:
76: -- Initialize the return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: PA_STATUS_LISTS_PKG.INSERT_ROW
80: (
81: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

97: EXCEPTION
98: WHEN OTHERS THEN
99: x_msg_count := 1;
100: x_msg_data := substr(SQLERRM,1,240);
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MSG_PUB.add_exc_msg
103: (p_pkg_name => 'PA_STTUS_LISTS_PVT'
104: , p_procedure_name => PA_DEBUG.G_Err_Stack
105: , p_error_text => substr(SQLERRM,1,240));

Line 155: x_return_status := FND_API.G_RET_STS_SUCCESS;

151: x_msg_count := 0;
152: x_msg_data := NULL;
153:
154: -- Initialize the return status to success
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
157: IF l_debug_mode = 'Y' THEN
158: pa_debug.g_err_stage:= 'Validating input parameters';
159: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 214: x_return_status := FND_API.G_RET_STS_ERROR;

210: PA_DEBUG.reset_err_stack;
211:
212: EXCEPTION
213: WHEN Invalid_Ret_Status THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: l_msg_count := FND_MSG_PUB.count_msg;
216:
217: IF l_msg_count = 1 and x_msg_data IS NULL THEN
218: PA_INTERFACE_UTILS_PUB.get_messages

Line 219: (p_encoded => FND_API.G_TRUE

215: l_msg_count := FND_MSG_PUB.count_msg;
216:
217: IF l_msg_count = 1 and x_msg_data IS NULL THEN
218: PA_INTERFACE_UTILS_PUB.get_messages
219: (p_encoded => FND_API.G_TRUE
220: ,p_msg_index => 1
221: ,p_msg_count => l_msg_count
222: ,p_msg_data => l_msg_data
223: ,p_data => l_data

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231: RETURN;
232: WHEN OTHERS THEN
233: x_msg_count := 1;
234: x_msg_data := substr(SQLERRM,1,240);
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: FND_MSG_PUB.add_exc_msg
237: (p_pkg_name => 'PA_STATUS_LISTS_PVT'
238: , p_procedure_name => PA_DEBUG.G_Err_Stack
239: , p_error_text => substr(SQLERRM,1,240));

Line 285: x_return_status := FND_API.G_RET_STS_SUCCESS;

281: x_msg_count := 0;
282: x_msg_data := NULL;
283:
284: -- Initialize the return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286:
287: PA_STATUS_LISTS_PKG.LOCK_ROW
288: (
289: X_STATUS_LIST_ID => P_STATUS_LIST_ID,

Line 309: x_return_status := FND_API.G_RET_STS_ERROR;

305: PA_DEBUG.reset_err_stack;
306:
307: EXCEPTION
308: WHEN Invalid_Ret_Status THEN
309: x_return_status := FND_API.G_RET_STS_ERROR;
310: l_msg_count := FND_MSG_PUB.count_msg;
311:
312: IF l_msg_count = 1 and x_msg_data IS NULL THEN
313: PA_INTERFACE_UTILS_PUB.get_messages

Line 314: (p_encoded => FND_API.G_TRUE

310: l_msg_count := FND_MSG_PUB.count_msg;
311:
312: IF l_msg_count = 1 and x_msg_data IS NULL THEN
313: PA_INTERFACE_UTILS_PUB.get_messages
314: (p_encoded => FND_API.G_TRUE
315: ,p_msg_index => 1
316: ,p_msg_count => l_msg_count
317: ,p_msg_data => l_msg_data
318: ,p_data => l_data

Line 330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

326: RETURN;
327: WHEN OTHERS THEN
328: x_msg_count := 1;
329: x_msg_data := substr(SQLERRM,1,240);
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331: FND_MSG_PUB.add_exc_msg
332: (p_pkg_name => 'PA_STATUS_LISTS_PVT'
333: , p_procedure_name => PA_DEBUG.G_Err_Stack
334: , p_error_text => substr(SQLERRM,1,240));