DBA Data[Home] [Help]

APPS.PA_PERF_EXCP_UTILS dependencies on FND_API

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: ;
54:
55: BEGIN
56:
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: x_indicators := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
60: x_ind_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE(); --Added for bug 4064923
61: x_indicators.extend(p_kpa_codes.count);

Line 73: IF l_return_code <> fnd_api.g_true THEN

69: p_object_key => p_object_id);
70:
71:
72:
73: IF l_return_code <> fnd_api.g_true THEN
74: RETURN;
75:
76:
77: ELSE

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

138: -- Set the excetption Message and the stack
139: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PERF_EXCP_UTILS.get_kpa_name_list'
140: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
141: --
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
143:
144:
145: END;
146:

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

171:
172:
173: BEGIN
174:
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: x_kpa_names := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
178:
179: x_kpa_names.extend(p_kpa_codes.count);

Line 200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

196: -- Set the excetption Message and the stack
197: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PERF_EXCP_UTILS.get_kpa_name_list'
198: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
199: --
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201:
202: END;
203:
204:

Line 242: IF l_ret <> fnd_api.g_true THEN

238: p_object_name => p_object_type,
239: p_object_key => p_object_id);
240:
241:
242: IF l_ret <> fnd_api.g_true THEN
243:
244: RETURN NULL;
245:
246: END IF;

Line 318: IF l_ret <> fnd_api.g_true THEN

314: p_privilege => 'PA_PERF_EXCEPTIONS',
315: p_object_name => p_object_type,
316: p_object_key => p_object_id);
317:
318: IF l_ret <> fnd_api.g_true THEN
319:
320: RETURN NULL;
321:
322: END IF;

Line 426: IF l_ret <> fnd_api.g_true THEN

422: p_privilege => 'PA_PERF_EXCEPTIONS',
423: p_object_name => p_object_type,
424: p_object_key => p_object_id);
425:
426: IF l_ret <> fnd_api.g_true THEN
427:
428: RETURN NULL;
429:
430: END IF;

Line 599: x_return_status:=fnd_api.g_ret_sts_success;

595: l_rowid ROWID;
596: BEGIN
597:
598: PA_DEBUG.init_err_stack('PA_PERF_EXCP_UTILS.copy_object_rule_assoc');
599: x_return_status:=fnd_api.g_ret_sts_success;
600:
601: savepoint copy_object_rule_assoc;
602:
603: IF (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 603: IF (x_return_status = fnd_api.g_ret_sts_success) THEN

599: x_return_status:=fnd_api.g_ret_sts_success;
600:
601: savepoint copy_object_rule_assoc;
602:
603: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
604: -- Insert the perf/score rules for the new object
605:
606: FOR c_rec in perf_score_rules LOOP
607:

Line 635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

631: ROLLBACK TO copy_object_rule_assoc;
632: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PERF_EXCP_UTILS.copy_object_rule_assoc',
633: p_procedure_name => PA_DEBUG.G_Err_Stack );
634:
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
636:
637: END copy_object_rule_assoc;
638:
639:

Line 650: x_return_status:=fnd_api.g_ret_sts_success;

646:
647: BEGIN
648:
649: PA_DEBUG.init_err_stack('PA_PERF_EXCP_UTILS.delete_object_exceptions');
650: x_return_status:=fnd_api.g_ret_sts_success;
651:
652: savepoint delete_object_exceptions;
653:
654: delete pa_perf_object_rules

Line 689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

685: ROLLBACK TO delete_object_exceptions;
686: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PERF_EXCP_UTILS.copy_object_rule_assoc',
687: p_procedure_name => PA_DEBUG.G_Err_Stack );
688:
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
690:
691: END delete_object_exceptions;
692:
693:

Line 713: x_return_Status := FND_API.g_ret_sts_success;

709: v_err_msg VARCHAR2(1000);
710:
711: BEGIN
712:
713: x_return_Status := FND_API.g_ret_sts_success;
714:
715:
716: x_request_id := FND_REQUEST.submit_request
717: (application => 'PA',

Line 745: x_return_status := FND_API.G_RET_STS_ERROR;

741: fnd_message.retrieve(v_err_msg);
742:
743: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
744: p_msg_name => 'PA_PERF_EXCP_UTILS');
745: x_return_status := FND_API.G_RET_STS_ERROR;
746:
747: PA_UTILS.ADD_MESSAGE
748: (p_app_short_name => 'PA',
749: p_msg_name => 'PA_EXCP_REQUEST_FAILURE',