DBA Data[Home] [Help]

APPS.PA_OPPORTUNITY_MGT_PVT dependencies on FND_API

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61: l_can_not_convert_currency EXCEPTION;
62: l_prob_exp_date_valid_error EXCEPTION;
63:
64: BEGIN
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
68: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
69: --Bug:4469336

Line 139: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

135: x_msg_count => x_msg_count,
136: x_msg_data => x_msg_data);
137: ELSE
138:
139: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
140: PA_OPPORTUNITY_MGT_PVT.validate_value_fields(p_opportunity_value => p_opportunity_value,
141: p_opp_value_currency_code => p_opp_value_currency_code,
142: p_projfunc_currency_code => v_c1.projfunc_currency_code,
143: p_project_currency_code => v_c1.project_currency_code,

Line 155: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

151: END IF;
152:
153: END IF;
154:
155: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
156: PA_PROJECTS_MAINT_UTILS.check_currency_name_or_code (
157: p_agreement_currency => p_opp_value_currency_code,
158: p_agreement_currency_name => NULL,
159: p_check_id_flag => 'Y',

Line 165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

161: x_return_status => x_return_status,
162: x_error_msg_code => x_msg_data);
163:
164: -- This if condition is Added for Bug 5214782
165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
166: PA_UTILS.ADD_MESSAGE('PA', x_msg_data);
167: END IF ;
168: -- End of 5214782
169: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file

Line 177: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

173: END IF;
174:
175: END IF;
176:
177: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
178: IF l_opp_value_currency_code = v_c1.projfunc_currency_code AND l_opp_value_currency_code = v_c1.project_currency_code THEN
179:
180: --Bug:4469336. Added the if condition for avoiding blind calls to pa_debug.write and pa_debug.write_file
181: IF l_debug_mode = 'Y' THEN

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339: END IF;
340:
341: EXCEPTION
342: WHEN l_can_not_convert_currency THEN
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: x_msg_data := 'PA_CAN_NOT_CONVERT_CURRENCY';
345: x_msg_count := FND_MSG_PUB.Count_Msg;
346: IF x_msg_count = 1 THEN
347: pa_interface_utils_pub.get_messages

Line 348: (p_encoded => FND_API.G_TRUE,

344: x_msg_data := 'PA_CAN_NOT_CONVERT_CURRENCY';
345: x_msg_count := FND_MSG_PUB.Count_Msg;
346: IF x_msg_count = 1 THEN
347: pa_interface_utils_pub.get_messages
348: (p_encoded => FND_API.G_TRUE,
349: p_msg_index => 1,
350: p_msg_count => x_msg_count,
351: p_msg_data => x_msg_data,
352: --p_data => x_msg_data, Bug: 4537865

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: --Bug: 4537865
358: End IF;
359: WHEN l_prob_exp_date_valid_error THEN
360: PA_UTILS.add_message('PA', 'PA_PROB_EXP_DATE_VALID_ERROR');
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: x_msg_data := 'PA_OPP_MULTI_CURRENCY_ERROR';
363: x_msg_count := FND_MSG_PUB.Count_Msg;
364: IF x_msg_count = 1 THEN
365: pa_interface_utils_pub.get_messages

Line 366: (p_encoded => FND_API.G_TRUE,

362: x_msg_data := 'PA_OPP_MULTI_CURRENCY_ERROR';
363: x_msg_count := FND_MSG_PUB.Count_Msg;
364: IF x_msg_count = 1 THEN
365: pa_interface_utils_pub.get_messages
366: (p_encoded => FND_API.G_TRUE,
367: p_msg_index => 1,
368: p_msg_count => x_msg_count,
369: p_msg_data => x_msg_data,
370: --p_data => x_msg_data, * Bug: 4537865

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

374: x_msg_data := l_new_msg_data;
375: --Bug: 4537865
376: End IF;
377: WHEN OTHERS THEN
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_OPPORTUNITY_MGT_PVT',
380: p_procedure_name => 'modify_project_attributes');
381: raise;
382:

Line 407: x_return_status := FND_API.G_RET_STS_SUCCESS;

403: v_c1 c1%ROWTYPE;
404:
405:
406: BEGIN
407: x_return_status := FND_API.G_RET_STS_SUCCESS;
408:
409:
410: OPEN c1;
411: FETCH c1 INTO v_c1;

Line 429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

425: x_msg_data => x_msg_data);
426:
427: EXCEPTION
428: WHEN OTHERS THEN
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
430: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_OPPORTUNITY_MGT_PVT',
431: p_procedure_name => 'copy_project_attributes');
432: raise;
433:

Line 475: x_return_status := FND_API.G_RET_STS_SUCCESS;

471: l_debug_mode VARCHAR2(10);
472: --Bug:4469336
473:
474: BEGIN
475: x_return_status := FND_API.G_RET_STS_SUCCESS;
476:
477: --Bug:4469336 Added for avoiding blind calls to pa_debug.write and pa_debug.write_file
478: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
479: --Bug:4469336

Line 586: x_return_status := FND_API.G_RET_STS_ERROR;

582: END IF;
583:
584: EXCEPTION
585: WHEN l_can_not_convert_currency THEN
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: x_msg_data := 'PA_CAN_NOT_CONVERT_CURRENCY';
588: x_msg_count := FND_MSG_PUB.Count_Msg;
589: IF x_msg_count = 1 THEN
590: pa_interface_utils_pub.get_messages

Line 591: (p_encoded => FND_API.G_TRUE,

587: x_msg_data := 'PA_CAN_NOT_CONVERT_CURRENCY';
588: x_msg_count := FND_MSG_PUB.Count_Msg;
589: IF x_msg_count = 1 THEN
590: pa_interface_utils_pub.get_messages
591: (p_encoded => FND_API.G_TRUE,
592: p_msg_index => 1,
593: p_msg_count => x_msg_count,
594: p_msg_data => x_msg_data,
595: --p_data => x_msg_data, * Bug: 4537865

Line 603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

599: x_msg_data := l_new_msg_data;
600: --Bug: 4537865
601: End IF;
602: WHEN OTHERS THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_OPPORTUNITY_MGT_PVT',
605: p_procedure_name => 'create_project_attributes');
606: raise;
607:

Line 648: x_return_status := FND_API.G_RET_STS_SUCCESS;

644: AND relationship_type = 'A'
645: AND relationship_subtype = 'PROJECT_REQUEST';
646:
647: BEGIN
648: x_return_status := FND_API.G_RET_STS_SUCCESS;
649:
650: -- Delete attributes from pa_proj_opportunity_attributes.
651: PA_PROJ_OPP_ATTRS_PKG.delete_row(p_project_id => p_project_id,
652: x_return_status => x_return_status,

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

688: END LOOP;
689:
690: EXCEPTION
691: WHEN OTHERS THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_OPPORTUNITY_MGT_PVT',
694: p_procedure_name => 'delete_project_attributes');
695: raise;
696:

Line 722: x_return_status := FND_API.G_RET_STS_SUCCESS;

718: l_new_msg_data VARCHAR2(2000);
719: --Bug: 4537865
720:
721: BEGIN
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723:
724: IF p_opportunity_value IS NULL THEN
725: RETURN;
726: ELSIF p_opp_value_currency_code IS NULL THEN

Line 737: x_return_status := FND_API.G_RET_STS_ERROR;

733:
734: EXCEPTION
735: WHEN l_opp_value_currency_missing THEN
736: PA_UTILS.add_message('PA', 'PA_OPP_VALUE_CURRENCY_MISSING');
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: x_msg_data := 'PA_OPP_VALUE_CURRENCY_MISSING';
739: x_msg_count := FND_MSG_PUB.Count_Msg;
740: IF x_msg_count = 1 THEN
741: pa_interface_utils_pub.get_messages

Line 742: (p_encoded => FND_API.G_TRUE,

738: x_msg_data := 'PA_OPP_VALUE_CURRENCY_MISSING';
739: x_msg_count := FND_MSG_PUB.Count_Msg;
740: IF x_msg_count = 1 THEN
741: pa_interface_utils_pub.get_messages
742: (p_encoded => FND_API.G_TRUE,
743: p_msg_index => 1,
744: p_msg_count => x_msg_count,
745: p_msg_data => x_msg_data,
746: --p_data => x_msg_data, * Bug: 4537865

Line 755: x_return_status := FND_API.G_RET_STS_ERROR;

751: --Bug: 4537865
752: End IF;
753: WHEN l_opp_multi_currency_error THEN
754: PA_UTILS.add_message('PA', 'PA_OPP_MULTI_CURRENCY_ERROR');
755: x_return_status := FND_API.G_RET_STS_ERROR;
756: x_msg_data := 'PA_OPP_MULTI_CURRENCY_ERROR';
757: x_msg_count := FND_MSG_PUB.Count_Msg;
758: IF x_msg_count = 1 THEN
759: pa_interface_utils_pub.get_messages

Line 760: (p_encoded => FND_API.G_TRUE,

756: x_msg_data := 'PA_OPP_MULTI_CURRENCY_ERROR';
757: x_msg_count := FND_MSG_PUB.Count_Msg;
758: IF x_msg_count = 1 THEN
759: pa_interface_utils_pub.get_messages
760: (p_encoded => FND_API.G_TRUE,
761: p_msg_index => 1,
762: p_msg_count => x_msg_count,
763: p_msg_data => x_msg_data,
764: --p_data => x_msg_data, * Bug: 4537865

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: x_msg_data := l_new_msg_data;
769: --Bug: 4537865
770: End IF;
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_OPPORTUNITY_MGT_PVT',
774: p_procedure_name => 'validate_value_fields');
775: raise;
776:

Line 799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

795: FROM pa_implementations;
796:
797: EXCEPTION
798: WHEN OTHERS THEN
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_OPPORTUNITY_MGT_PVT',
801: p_procedure_name => 'get_opp_multi_currency_setup');
802: raise;
803: END get_opp_multi_currency_setup;

Line 827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

823: WHERE org_id = p_org_id; --MOAC Changes: Bug 4363092: removed nvl usage with org_id
824:
825: EXCEPTION
826: WHEN OTHERS THEN
827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_OPPORTUNITY_MGT_PVT',
829: p_procedure_name => 'delete_project_attributes');
830: raise;
831: END get_opp_multi_currency_setup;