DBA Data[Home] [Help]

APPS.PA_PERF_RULES_PVT dependencies on FND_API

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61: -- Initialize the Error Stack
62: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.create_rule');
63: x_msg_count := 0;
64: x_msg_data := NULL;
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
67:
68: IF l_debug_mode = 'Y' THEN
69: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.create_rule',

Line 137: x_return_status := FND_API.G_RET_STS_ERROR;

133:
134:
135: EXCEPTION
136: WHEN duplicate_name THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138:
139: PA_UTILS.ADD_MESSAGE
140: ( p_app_short_name => 'PA',
141: p_msg_name => 'PA_NAME_UNIQUE');

Line 154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

150: rollback to sp;
151: RETURN;
152:
153: WHEN others THEN
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: x_msg_count := 1;
156: x_msg_data := SQLERRM;
157:
158: FND_MSG_PUB.add_exc_msg(

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: x_msg_count := 0;
228: x_msg_data := NULL;
229:
230: -- Initialize the return status to success
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
233: IF l_debug_mode = 'Y' THEN
234: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.update_rule',
235: p_debug_mode => l_debug_mode );

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324:
325: EXCEPTION
326:
327: WHEN duplicate_name THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329:
330: PA_UTILS.ADD_MESSAGE
331: ( p_app_short_name => 'PA',
332: p_msg_name => 'PA_NAME_UNIQUE');

Line 344: x_return_status := FND_API.G_RET_STS_ERROR;

340: rollback to sp;
341: RETURN;
342:
343: WHEN Invalid_Ret_Status THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: l_msg_count := FND_MSG_PUB.count_msg;
346:
347: IF l_msg_count = 1 and x_msg_data IS NULL THEN
348: PA_INTERFACE_UTILS_PUB.get_messages(

Line 349: p_encoded => FND_API.G_TRUE

345: l_msg_count := FND_MSG_PUB.count_msg;
346:
347: IF l_msg_count = 1 and x_msg_data IS NULL THEN
348: PA_INTERFACE_UTILS_PUB.get_messages(
349: p_encoded => FND_API.G_TRUE
350: ,p_msg_index => 1
351: ,p_msg_count => l_msg_count
352: ,p_msg_data => l_msg_data
353: ,p_data => l_data

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

368:
369: WHEN OTHERS THEN
370: x_msg_count := 1;
371: x_msg_data := substr(SQLERRM,1,240);
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: FND_MSG_PUB.add_exc_msg (
374: p_pkg_name => 'PA_PERF_RULES_PVT'
375: , p_procedure_name => PA_DEBUG.G_Err_Stack
376: , p_error_text => substr(SQLERRM,1,240));

Line 433: x_return_status := FND_API.G_RET_STS_SUCCESS;

429: x_msg_count := 0;
430: x_msg_data := NULL;
431:
432: -- Initialize the return status to success
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434:
435: IF l_debug_mode = 'Y' THEN
436: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.delete_rule',
437: p_debug_mode => l_debug_mode );

Line 473: l_return_status := FND_API.G_RET_STS_SUCCESS;

469:
470:
471: FOR cur_var IN cur_threshold( p_rule_id )
472: LOOP
473: l_return_status := FND_API.G_RET_STS_SUCCESS;
474: l_msg_count := 0;
475: l_msg_data := NULL;
476: PA_PERF_THRESHOLDS_PVT.delete_rule_det (
477: P_THRESHOLD_ID => cur_var.threshold_id,

Line 483: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

479: X_RETURN_STATUS => l_return_status,
480: X_MSG_COUNT => l_msg_count,
481: X_MSG_DATA => l_msg_data );
482:
483: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
484: IF l_debug_mode = 'Y' THEN
485: pa_debug.g_err_stage:= 'about to delete the Rule Threshold, Threshold_id : '|| cur_var.threshold_id;
486: pa_debug.write(g_module_name,pa_debug.g_err_stage,
487: l_debug_level3);

Line 496: l_return_status := FND_API.G_RET_STS_SUCCESS;

492: END LOOP;
493:
494: FOR cur_var IN cur_obj_rule( p_rule_id )
495: LOOP
496: l_return_status := FND_API.G_RET_STS_SUCCESS;
497: l_msg_count := 0;
498: l_msg_data := NULL;
499: PA_PERF_OBJECT_RULES_PVT.delete_rule_object (
500: P_OBJECT_RULE_ID => cur_var.object_rule_id,

Line 507: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

503: X_MSG_COUNT => l_msg_count,
504: X_MSG_DATA => l_msg_data,
505: X_RULE_NAME => l_rule_name );
506:
507: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
508: IF l_debug_mode = 'Y' THEN
509: pa_debug.g_err_stage:= 'about to delete the Rule Object Association, object_rule_id : '|| cur_var.object_rule_id;
510: pa_debug.write(g_module_name,pa_debug.g_err_stage,
511: l_debug_level3);

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530: PA_DEBUG.reset_err_stack;
531:
532: EXCEPTION
533: WHEN Invalid_Ret_Status THEN
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: l_msg_count := FND_MSG_PUB.count_msg;
536:
537: IF l_msg_count = 1 and x_msg_data IS NULL THEN
538: PA_INTERFACE_UTILS_PUB.get_messages

Line 539: ( p_encoded => FND_API.G_TRUE

535: l_msg_count := FND_MSG_PUB.count_msg;
536:
537: IF l_msg_count = 1 and x_msg_data IS NULL THEN
538: PA_INTERFACE_UTILS_PUB.get_messages
539: ( p_encoded => FND_API.G_TRUE
540: ,p_msg_index => 1
541: ,p_msg_count => l_msg_count
542: ,p_msg_data => l_msg_data
543: ,p_data => l_data

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558:
559: WHEN OTHERS THEN
560: x_msg_count := 1;
561: x_msg_data := substr(SQLERRM,1,240);
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MSG_PUB.add_exc_msg
564: ( p_pkg_name => 'PA_PERF_RULES_PVT'
565: , p_procedure_name => PA_DEBUG.G_Err_Stack
566: , p_error_text => substr(SQLERRM,1,240));

Line 613: x_return_status := FND_API.G_RET_STS_SUCCESS;

609: x_msg_count := 0;
610: x_msg_data := NULL;
611:
612: -- Initialize the return status to success
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
616:
617: IF l_debug_mode = 'Y' THEN

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: IF (trunc(P_START_DATE_ACTIVE) >= trunc(P_END_DATE_ACTIVE)) THEN
626: PA_UTILS.ADD_MESSAGE
627: ( p_app_short_name => 'PA',
628: p_msg_name => 'PA_SETUP_CHK_ST_EN_DATE');
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: x_msg_count := FND_MSG_PUB.count_msg;
631: END IF;
632: END IF;
633:

Line 688: x_return_status := FND_API.G_RET_STS_ERROR;

684: IF (l_check_precission = 'Y') THEN
685: PA_UTILS.ADD_MESSAGE
686: ( p_app_short_name => 'PA',
687: p_msg_name => 'PA_THRES_PRECISION_CHECK');
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: x_msg_count := FND_MSG_PUB.count_msg;
690: END IF ;
691:
692: IF (l_check_from_to_value = 'Y') THEN

Line 696: x_return_status := FND_API.G_RET_STS_ERROR;

692: IF (l_check_from_to_value = 'Y') THEN
693: PA_UTILS.ADD_MESSAGE
694: ( p_app_short_name => 'PA',
695: p_msg_name => 'PA_THRESH_FROM_TO_VALUE');
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: x_msg_count := FND_MSG_PUB.count_msg;
698: END IF ;
699:
700: IF (l_indicator_code = 'Y') THEN

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700: IF (l_indicator_code = 'Y') THEN
701: PA_UTILS.ADD_MESSAGE
702: ( p_app_short_name => 'PA',
703: p_msg_name => 'PA_INDICATOR_UNIQUE');
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: x_msg_count := FND_MSG_PUB.count_msg;
706: END IF ;
707:
708: IF (l_check_range = 'Y') THEN

Line 712: x_return_status := FND_API.G_RET_STS_ERROR;

708: IF (l_check_range = 'Y') THEN
709: PA_UTILS.ADD_MESSAGE
710: ( p_app_short_name => 'PA',
711: p_msg_name => 'PA_THRES_RANGE_CHECK');
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: x_msg_count := FND_MSG_PUB.count_msg;
714: END IF ;
715:
716:

Line 721: x_return_status := FND_API.G_RET_STS_ERROR;

717: IF (l_check_weighting = 'Y') THEN
718: PA_UTILS.ADD_MESSAGE
719: ( p_app_short_name => 'PA',
720: p_msg_name => 'PA_NEGATIVE_WEIGHTING');
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: x_msg_count := FND_MSG_PUB.count_msg;
723: END IF ;
724:
725:

Line 730: x_return_status := FND_API.G_RET_STS_ERROR;

726: IF (l_check_threshold = 'Y') THEN
727: PA_UTILS.ADD_MESSAGE
728: ( p_app_short_name => 'PA',
729: p_msg_name => 'PA_THRESHOLD_NEGATIVE');
730: x_return_status := FND_API.G_RET_STS_ERROR;
731: x_msg_count := FND_MSG_PUB.count_msg;
732: END IF ;
733:
734: END validate_rule;