DBA Data[Home] [Help]

APPS.PA_FP_MULTI_CURRENCY_PKG dependencies on FND_API

Line 204: x_return_status := FND_API.G_RET_STS_SUCCESS;

200: **/
201:
202: BEGIN
203:
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205:
206: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
207: --l_debug_mode := NVL(l_debug_mode,'Y');
208: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 349: x_return_status := FND_API.G_RET_STS_ERROR;

345: p_value4 => p_start_date_tab(i));
346: fnd_msg_pub.count_and_get (p_count => x_msg_count,
347: p_data => x_msg_data);
348: x_msg_count := fnd_msg_pub.count_msg;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: */
351: x_projfunc_rejection_tab(i) := 'PA_FP_PF_COST_RATE_NOT_DEFINED';
352: END IF;
353: ELSE

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

373: p_value5 => p_txn_currency_code_tab(i));
374: fnd_msg_pub.count_and_get (p_count => x_msg_count,
375: p_data => x_msg_data);
376: x_msg_count := fnd_msg_pub.count_msg;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: */
379: x_projfunc_rejection_tab(i) := 'PA_FP_PFC_USR_RATE_NOT_ALLOWED';
380: END IF;
381: ELSE

Line 483: x_return_status := FND_API.G_RET_STS_ERROR;

479: p_value5 => p_txn_currency_code_tab(i));
480: fnd_msg_pub.count_and_get (p_count => x_msg_count,
481: p_data => x_msg_data);
482: x_msg_count := fnd_msg_pub.count_msg;
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: */
485: x_projfunc_rejection_tab(i) := 'PA_FP_NO_PF_EXCH_RATE_EXISTS';
486: END IF;
487: ELSIF l_converted_amount = -2 THEN

Line 511: x_return_status := FND_API.G_RET_STS_ERROR;

507: p_value5 => p_txn_currency_code_tab(i));
508: fnd_msg_pub.count_and_get (p_count => x_msg_count,
509: p_data => x_msg_data);
510: x_msg_count := fnd_msg_pub.count_msg;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: */
513: x_projfunc_rejection_tab(i) := 'PA_FP_CURR_NOT_VALID';
514: --Commented for Bug#5395732 ELSE
515: END IF; -- Added for Bug#5395732

Line 654: x_return_status := FND_API.G_RET_STS_ERROR;

650: p_value5 => p_txn_currency_code_tab(i));
651: fnd_msg_pub.count_and_get (p_count => x_msg_count,
652: p_data => x_msg_data);
653: x_msg_count := fnd_msg_pub.count_msg;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: */
656: x_projfunc_rejection_tab(i) := 'PA_FP_NO_PF_EXCH_RATE_EXISTS';
657: END IF;
658:

Line 683: x_return_status := FND_API.G_RET_STS_ERROR;

679: p_value5 => p_txn_currency_code_tab(i));
680: fnd_msg_pub.count_and_get (p_count => x_msg_count,
681: p_data => x_msg_data);
682: x_msg_count := fnd_msg_pub.count_msg;
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: */
685: x_projfunc_rejection_tab(i) := 'PA_FP_CURR_NOT_VALID';
686:
687: --Commented for Bug#5395732 ELSE

Line 797: x_return_status := FND_API.G_RET_STS_ERROR;

793: p_value4 => p_start_date_tab(i));
794: fnd_msg_pub.count_and_get (p_count => x_msg_count,
795: p_data => x_msg_data);
796: x_msg_count := fnd_msg_pub.count_msg;
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: */
799: x_projfunc_rejection_tab(i) := 'PA_FP_PF_REV_RATE_NOT_DEFINED';
800: END IF;
801: ELSE

Line 825: x_return_status := FND_API.G_RET_STS_ERROR;

821: p_value5 => p_txn_currency_code_tab(i));
822: fnd_msg_pub.count_and_get (p_count => x_msg_count,
823: p_data => x_msg_data);
824: x_msg_count := fnd_msg_pub.count_msg;
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: */
827: x_projfunc_rejection_tab(i) := 'PA_FP_PFR_USR_RATE_NOT_ALLOWED';
828: END IF;
829: ELSE

Line 903: x_return_status := FND_API.G_RET_STS_ERROR;

899: p_value5 => p_txn_currency_code_tab(i));
900: fnd_msg_pub.count_and_get (p_count => x_msg_count,
901: p_data => x_msg_data);
902: x_msg_count := fnd_msg_pub.count_msg;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: */
905: x_projfunc_rejection_tab(i) := 'PA_FP_NO_PF_EXCH_RATE_EXISTS';
906: END IF;
907: ELSIF l_converted_amount = -2 THEN

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: p_value5 => p_txn_currency_code_tab(i));
928: fnd_msg_pub.count_and_get (p_count => x_msg_count,
929: p_data => x_msg_data);
930: x_msg_count := fnd_msg_pub.count_msg;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: */
933: x_projfunc_rejection_tab(i) := 'PA_FP_CURR_NOT_VALID';
934:
935: -- Commented for Bug#5395732 ELSE

Line 1065: x_return_status := FND_API.G_RET_STS_ERROR;

1061: p_value4 => p_start_date_tab(i));
1062: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1063: p_data => x_msg_data);
1064: x_msg_count := fnd_msg_pub.count_msg;
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: */
1067: x_proj_rejection_tab(i) := 'PA_FP_PJ_COST_RATE_NOT_DEFINED';
1068: END IF;
1069: ELSE

Line 1093: x_return_status := FND_API.G_RET_STS_ERROR;

1089: p_value5 => p_txn_currency_code_tab(i));
1090: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1091: p_data => x_msg_data);
1092: x_msg_count := fnd_msg_pub.count_msg;
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: */
1095: x_proj_rejection_tab(i) := 'PA_FP_PJC_USR_RATE_NOT_ALLOWED';
1096: END IF;
1097: ELSE

Line 1195: x_return_status := FND_API.G_RET_STS_ERROR;

1191: p_value5 => p_txn_currency_code_tab(i));
1192: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1193: p_data => x_msg_data);
1194: x_msg_count := fnd_msg_pub.count_msg;
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: */
1197: x_proj_rejection_tab(i) := 'PA_FP_NO_PJ_EXCH_RATE_EXISTS';
1198: END IF;
1199: ELSIF l_converted_amount = -2 THEN

Line 1219: x_return_status := FND_API.G_RET_STS_ERROR;

1215: p_value5 => p_txn_currency_code_tab(i));
1216: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1217: p_data => x_msg_data);
1218: x_msg_count := fnd_msg_pub.count_msg;
1219: x_return_status := FND_API.G_RET_STS_ERROR;
1220: */
1221: x_proj_rejection_tab(i) := 'PA_FP_CURR_NOT_VALID';
1222: -- Commented for Bug#5395732 ELSE
1223: END IF; -- Added for Bug#5395732

Line 1345: x_return_status := FND_API.G_RET_STS_ERROR;

1341: p_value5 => p_txn_currency_code_tab(i));
1342: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1343: p_data => x_msg_data);
1344: x_msg_count := fnd_msg_pub.count_msg;
1345: x_return_status := FND_API.G_RET_STS_ERROR;
1346: */
1347: x_proj_rejection_tab(i) := 'PA_FP_NO_PJ_EXCH_RATE_EXISTS';
1348: END IF;
1349: ELSIF l_converted_amount = -2 THEN

Line 1373: x_return_status := FND_API.G_RET_STS_ERROR;

1369: p_value5 => p_txn_currency_code_tab(i));
1370: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1371: p_data => x_msg_data);
1372: x_msg_count := fnd_msg_pub.count_msg;
1373: x_return_status := FND_API.G_RET_STS_ERROR;
1374: */
1375: x_proj_rejection_tab(i) := 'PA_FP_CURR_NOT_VALID';
1376:
1377: -- Commented for Bug#5395732 ELSE

Line 1488: x_return_status := FND_API.G_RET_STS_ERROR;

1484: p_value4 => p_start_date_tab(i));
1485: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1486: p_data => x_msg_data);
1487: x_msg_count := fnd_msg_pub.count_msg;
1488: x_return_status := FND_API.G_RET_STS_ERROR;
1489: */
1490: x_proj_rejection_tab(i) := 'PA_FP_PJ_REV_RATE_NOT_DEFINED';
1491: END IF;
1492: ELSE

Line 1516: x_return_status := FND_API.G_RET_STS_ERROR;

1512: p_value5 => p_txn_currency_code_tab(i));
1513: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1514: p_data => x_msg_data);
1515: x_msg_count := fnd_msg_pub.count_msg;
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: */
1518: x_proj_rejection_tab(i) := 'PA_FP_PJC_USR_RATE_NOT_ALLOWED';
1519: END IF;
1520: ELSE

Line 1611: x_return_status := FND_API.G_RET_STS_ERROR;

1607: p_value5 => p_txn_currency_code_tab(i));
1608: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1609: p_data => x_msg_data);
1610: x_msg_count := fnd_msg_pub.count_msg;
1611: x_return_status := FND_API.G_RET_STS_ERROR;
1612: */
1613: x_proj_rejection_tab(i) := 'PA_FP_NO_PJ_EXCH_RATE_EXISTS';
1614: END IF;
1615: ELSIF l_converted_amount = -2 THEN

Line 1639: x_return_status := FND_API.G_RET_STS_ERROR;

1635: p_value5 => p_txn_currency_code_tab(i));
1636: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1637: p_data => x_msg_data);
1638: x_msg_count := fnd_msg_pub.count_msg;
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: */
1641: x_proj_rejection_tab(i) := 'PA_FP_CURR_NOT_VALID';
1642: -- Commented for Bug#5395732 ELSE
1643: END IF; -- Added for Bug#5395732

Line 1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1753: x_msg_data := FND_MESSAGE.GET;
1754: END IF;
1755: END IF;
1756:
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758: fnd_msg_pub.add_exc_msg
1759: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
1760: ,p_procedure_name => 'conv_mc_bulk' );
1761: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);

Line 1772: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1768: */
1769: IF P_PA_DEBUG_MODE = 'Y' THEN
1770: pa_debug.reset_err_stack;
1771: END IF;
1772: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1773: END conv_mc_bulk;
1774:
1775: PROCEDURE convert_txn_currency
1776: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

Line 2105: l_entire_return_status := FND_API.G_RET_STS_SUCCESS;

2101: * so commenting out
2102: *fnd_msg_pub.initialize;
2103: **/
2104:
2105: l_entire_return_status := FND_API.G_RET_STS_SUCCESS;
2106: x_return_status := FND_API.G_RET_STS_SUCCESS;
2107:
2108: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2109: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 2106: x_return_status := FND_API.G_RET_STS_SUCCESS;

2102: *fnd_msg_pub.initialize;
2103: **/
2104:
2105: l_entire_return_status := FND_API.G_RET_STS_SUCCESS;
2106: x_return_status := FND_API.G_RET_STS_SUCCESS;
2107:
2108: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2109: l_debug_mode := NVL(l_debug_mode, 'Y');
2110:

Line 2470: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2466:
2467: l_entire_msg_count := nvl(l_entire_msg_count,0) + nvl(l_msg_count,0);
2468: l_entire_msg_data := l_msg_data;
2469:
2470: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2471: l_stage := 1200;
2472: l_entire_return_status := l_return_status;
2473: END IF;
2474:

Line 2476: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2472: l_entire_return_status := l_return_status;
2473: END IF;
2474:
2475:
2476: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2477: l_stage := 1300;
2478: IF l_txn_row_id_tab.COUNT > 0 THEN --{
2479: /* Bug fix:4259098: re-calculate the plan cost by adding the actuals to the etc */
2480: FOR i IN l_txn_row_id_tab.FIRST .. l_txn_row_id_tab.LAST LOOP

Line 2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2603: END IF; -- returned success
2604: END IF; -- rowcount > 0
2605:
2606: EXCEPTION WHEN OTHERS THEN
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2608: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2609: p_data => x_msg_data);
2610: x_msg_count := FND_MSG_PUB.Count_Msg;
2611: IF x_msg_count = 1 THEN

Line 2632: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2628: */
2629: IF P_PA_DEBUG_MODE = 'Y' THEN
2630: pa_debug.reset_err_stack;
2631: END IF;
2632: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2633: END;
2634:
2635: END LOOP;
2636:

Line 2672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2668: x_msg_data := FND_MESSAGE.GET;
2669: END IF;
2670: END IF;
2671:
2672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2673: fnd_msg_pub.add_exc_msg
2674: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
2675: ,p_procedure_name => 'convert_txn_currency' );
2676: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);

Line 2687: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2683: */
2684: IF P_PA_DEBUG_MODE = 'Y' THEN
2685: pa_debug.reset_err_stack;
2686: END IF;
2687: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2688: END convert_txn_currency;
2689:
2690: /*=============================================================================
2691: This api is used to Round budget line amounts as per the currency precision/

Line 2811: x_return_status := FND_API.G_RET_STS_SUCCESS;

2807:
2808: BEGIN
2809:
2810: x_msg_count := 0;
2811: x_return_status := FND_API.G_RET_STS_SUCCESS;
2812:
2813: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2814: l_debug_mode := NVL(l_debug_mode, 'Y');
2815:

Line 3245: (p_encoded => FND_API.G_TRUE

3241: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3242: l_msg_count := FND_MSG_PUB.count_msg;
3243: IF l_msg_count = 1 THEN
3244: PA_INTERFACE_UTILS_PUB.get_messages
3245: (p_encoded => FND_API.G_TRUE
3246: ,p_msg_index => 1
3247: ,p_msg_count => l_msg_count
3248: ,p_msg_data => l_msg_data
3249: ,p_data => l_data

Line 3258: x_return_status := FND_API.G_RET_STS_ERROR;

3254: ELSE
3255: x_msg_count := l_msg_count;
3256: END IF;
3257:
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259:
3260: IF l_debug_mode = 'Y' THEN
3261: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
3262: pa_debug.write('Round_Budget_Line_Amounts: ' || g_module_name,pa_debug.g_err_stage,5);

Line 3274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3270: pa_debug.reset_curr_function();
3271: END IF;
3272: RETURN;
3273: WHEN Others THEN
3274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3275: x_msg_count := 1;
3276: x_msg_data := SQLERRM;
3277:
3278: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

Line 3340: x_return_status := FND_API.G_RET_STS_SUCCESS;

3336: --Code changes for bug 4200168 ends here.
3337:
3338: BEGIN
3339: x_msg_count := 0;
3340: x_return_status := FND_API.G_RET_STS_SUCCESS;
3341:
3342: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3343: l_debug_mode := NVL(l_debug_mode, 'Y');
3344:

Line 3589: (p_encoded => FND_API.G_TRUE

3585: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3586: l_msg_count := FND_MSG_PUB.count_msg;
3587: IF l_msg_count = 1 THEN
3588: PA_INTERFACE_UTILS_PUB.get_messages
3589: (p_encoded => FND_API.G_TRUE
3590: ,p_msg_index => 1
3591: ,p_msg_count => l_msg_count
3592: ,p_msg_data => l_msg_data
3593: ,p_data => l_data

Line 3601: x_return_status := FND_API.G_RET_STS_ERROR;

3597: x_msg_count := l_msg_count;
3598: ELSE
3599: x_msg_count := l_msg_count;
3600: END IF;
3601: x_return_status := FND_API.G_RET_STS_ERROR;
3602:
3603: IF l_debug_mode = 'Y' THEN
3604: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
3605: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 3618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3614: END IF;
3615: RETURN;
3616: WHEN OTHERS THEN
3617:
3618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3619: x_msg_count := 1;
3620: x_msg_data := SQLERRM;
3621:
3622: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'