DBA Data[Home] [Help]

APPS.PA_PERF_THRESHOLDS_PUB dependencies on FND_API

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

48: -- Initialize the Error Stack
49: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.create_rule_det');
50: x_msg_count := 0;
51: x_msg_data := NULL;
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
54:
55: IF l_debug_mode = 'Y' THEN
56: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.create_rule_det',

Line 106: x_return_status := FND_API.G_RET_STS_ERROR;

102:
103:
104: EXCEPTION
105: WHEN Invalid_Ret_Status THEN
106: x_return_status := FND_API.G_RET_STS_ERROR;
107: l_msg_count := FND_MSG_PUB.count_msg;
108:
109: IF l_msg_count = 1 and x_msg_data IS NULL THEN
110: PA_INTERFACE_UTILS_PUB.get_messages(

Line 111: p_encoded => FND_API.G_TRUE

107: l_msg_count := FND_MSG_PUB.count_msg;
108:
109: IF l_msg_count = 1 and x_msg_data IS NULL THEN
110: PA_INTERFACE_UTILS_PUB.get_messages(
111: p_encoded => FND_API.G_TRUE
112: ,p_msg_index => 1
113: ,p_msg_count => l_msg_count
114: ,p_msg_data => l_msg_data
115: ,p_data => l_data

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

128: rollback to sp;
129: RETURN;
130:
131: WHEN others THEN
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: x_msg_count := 1;
134: x_msg_data := SQLERRM;
135:
136: FND_MSG_PUB.add_exc_msg(

Line 197: x_return_status := FND_API.G_RET_STS_SUCCESS;

193: x_msg_count := 0;
194: x_msg_data := NULL;
195:
196: -- Initialize the return status to success
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
199: IF l_debug_mode = 'Y' THEN
200: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.update_rule_det',
201: p_debug_mode => l_debug_mode );

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: PA_DEBUG.reset_err_stack;
256:
257: EXCEPTION
258: WHEN Invalid_Ret_Status THEN
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: l_msg_count := FND_MSG_PUB.count_msg;
261:
262: IF l_msg_count = 1 and x_msg_data IS NULL THEN
263: PA_INTERFACE_UTILS_PUB.get_messages(

Line 264: p_encoded => FND_API.G_TRUE

260: l_msg_count := FND_MSG_PUB.count_msg;
261:
262: IF l_msg_count = 1 and x_msg_data IS NULL THEN
263: PA_INTERFACE_UTILS_PUB.get_messages(
264: p_encoded => FND_API.G_TRUE
265: ,p_msg_index => 1
266: ,p_msg_count => l_msg_count
267: ,p_msg_data => l_msg_data
268: ,p_data => l_data

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283:
284: WHEN OTHERS THEN
285: x_msg_count := 1;
286: x_msg_data := substr(SQLERRM,1,240);
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.add_exc_msg (
289: p_pkg_name => 'PA_PERF_THRESHOLDS_PUB'
290: , p_procedure_name => PA_DEBUG.G_Err_Stack
291: , p_error_text => substr(SQLERRM,1,240));

Line 335: x_return_status := FND_API.G_RET_STS_SUCCESS;

331: x_msg_count := 0;
332: x_msg_data := NULL;
333:
334: -- Initialize the return status to success
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336:
337: IF l_debug_mode = 'Y' THEN
338: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.delete_rule_det',
339: p_debug_mode => l_debug_mode );

Line 382: x_return_status := FND_API.G_RET_STS_ERROR;

378: PA_DEBUG.reset_err_stack;
379:
380: EXCEPTION
381: WHEN Invalid_Ret_Status THEN
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: l_msg_count := FND_MSG_PUB.count_msg;
384:
385: IF l_msg_count = 1 and x_msg_data IS NULL THEN
386: PA_INTERFACE_UTILS_PUB.get_messages

Line 387: ( p_encoded => FND_API.G_TRUE

383: l_msg_count := FND_MSG_PUB.count_msg;
384:
385: IF l_msg_count = 1 and x_msg_data IS NULL THEN
386: PA_INTERFACE_UTILS_PUB.get_messages
387: ( p_encoded => FND_API.G_TRUE
388: ,p_msg_index => 1
389: ,p_msg_count => l_msg_count
390: ,p_msg_data => l_msg_data
391: ,p_data => l_data

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

406:
407: WHEN OTHERS THEN
408: x_msg_count := 1;
409: x_msg_data := substr(SQLERRM,1,240);
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MSG_PUB.add_exc_msg
412: ( p_pkg_name => 'PA_PERF_THRESHOLDS_PUB'
413: , p_procedure_name => PA_DEBUG.G_Err_Stack
414: , p_error_text => substr(SQLERRM,1,240));