DBA Data[Home] [Help]

APPS.PA_FP_EXCLUDED_ELEMENTS_PUB dependencies on FND_API

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

42: L_PROCEDURE_NAME CONSTANT VARCHAR2(100) :='Copy_Excluded_Elements: '||
43: G_PKG_NAME ;
44: BEGIN
45: x_msg_count := 0;
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
48:
49: IF l_debug_mode = 'Y' THEN
50: pa_debug.set_curr_function( p_function => 'Copy_Excluded_Elements',

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 218: (p_encoded => FND_API.G_TRUE

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

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: RETURN;
234:
235: WHEN OTHERS THEN
236:
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: x_msg_count := 1;
239: x_msg_data := SQLERRM;
240:
241: FND_MSG_PUB.add_exc_msg

Line 276: x_return_status := FND_API.G_RET_STS_SUCCESS;

272: l_procedure_name CONSTANT VARCHAR2(100) :='Synchronize_Excluded_Elements: '||G_PKG_NAME ;
273:
274: BEGIN
275: x_msg_count := 0;
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: PA_DEBUG.Set_Curr_Function( p_function => 'Synchronize_Excluded_Elements',
279: p_debug_mode => l_debug_mode );
280:

Line 331: x_return_status := FND_API.G_RET_STS_ERROR;

327: EXCEPTION
328:
329: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
330:
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: l_msg_count := FND_MSG_PUB.count_msg;
333: IF l_msg_count = 1 THEN
334: PA_INTERFACE_UTILS_PUB.get_messages
335: (p_encoded => FND_API.G_TRUE

Line 335: (p_encoded => FND_API.G_TRUE

331: x_return_status := FND_API.G_RET_STS_ERROR;
332: l_msg_count := FND_MSG_PUB.count_msg;
333: IF l_msg_count = 1 THEN
334: PA_INTERFACE_UTILS_PUB.get_messages
335: (p_encoded => FND_API.G_TRUE
336: ,p_msg_index => 1
337: ,p_msg_count => l_msg_count
338: ,p_msg_data => l_msg_data
339: ,p_data => l_data

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

346: pa_debug.reset_curr_function;
347: RETURN;
348: WHEN others THEN
349:
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: x_msg_count := 1;
352: x_msg_data := SQLERRM;
353: FND_MSG_PUB.add_exc_msg
354: ( p_pkg_name => G_PKG_NAME

Line 398: x_return_status := FND_API.G_RET_STS_SUCCESS;

394:
395: BEGIN
396:
397: x_msg_count := 0;
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
400:
401: IF l_debug_mode = 'Y' THEN
402: pa_debug.set_curr_function( p_function => 'Delete_Excluded_Elements',

Line 453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

449: PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW(
450: p_row_id => excl_elems_rec.rowid,
451: x_return_status => x_return_status);
452:
453: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
454: IF l_debug_mode = 'Y' THEN
455: pa_debug.g_err_stage:= 'Error returned by PA_FP_EXCLUDED_ELEMENTS_PKG.DELETE_ROW';
456: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,
457: L_DEBUG_LEVEL5);

Line 477: x_return_status := FND_API.G_RET_STS_ERROR;

473: EXCEPTION
474:
475: WHEN Pa_Fp_Constants_Pkg.Invalid_Arg_Exc THEN
476:
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: l_msg_count := FND_MSG_PUB.count_msg;
479:
480: IF cur_excl_elems%ISOPEN THEN
481: CLOSE cur_excl_elems;

Line 486: (p_encoded => FND_API.G_TRUE

482: END IF;
483:
484: IF l_msg_count = 1 and x_msg_data IS NULL THEN
485: PA_INTERFACE_UTILS_PUB.get_messages
486: (p_encoded => FND_API.G_TRUE
487: ,p_msg_index => 1
488: ,p_msg_count => l_msg_count
489: ,p_msg_data => l_msg_data
490: ,p_data => l_data

Line 505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

501: RETURN;
502:
503: WHEN others THEN
504:
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: x_msg_count := 1;
507: x_msg_data := SQLERRM;
508:
509: IF cur_excl_elems%ISOPEN THEN