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 1178: x_return_status := FND_API.G_RET_STS_ERROR;

1174: p_value5 => p_txn_currency_code_tab(i));
1175: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1176: p_data => x_msg_data);
1177: x_msg_count := fnd_msg_pub.count_msg;
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: */
1180: x_proj_rejection_tab(i) := 'PA_FP_NO_PJ_EXCH_RATE_EXISTS';
1181: END IF;
1182: ELSIF l_converted_amount = -2 THEN

Line 1202: x_return_status := FND_API.G_RET_STS_ERROR;

1198: p_value5 => p_txn_currency_code_tab(i));
1199: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1200: p_data => x_msg_data);
1201: x_msg_count := fnd_msg_pub.count_msg;
1202: x_return_status := FND_API.G_RET_STS_ERROR;
1203: */
1204: x_proj_rejection_tab(i) := 'PA_FP_CURR_NOT_VALID';
1205: -- Commented for Bug#5395732 ELSE
1206: END IF; -- Added for Bug#5395732

Line 1328: x_return_status := FND_API.G_RET_STS_ERROR;

1324: p_value5 => p_txn_currency_code_tab(i));
1325: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1326: p_data => x_msg_data);
1327: x_msg_count := fnd_msg_pub.count_msg;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: */
1330: x_proj_rejection_tab(i) := 'PA_FP_NO_PJ_EXCH_RATE_EXISTS';
1331: END IF;
1332: ELSIF l_converted_amount = -2 THEN

Line 1356: x_return_status := FND_API.G_RET_STS_ERROR;

1352: p_value5 => p_txn_currency_code_tab(i));
1353: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1354: p_data => x_msg_data);
1355: x_msg_count := fnd_msg_pub.count_msg;
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357: */
1358: x_proj_rejection_tab(i) := 'PA_FP_CURR_NOT_VALID';
1359:
1360: -- Commented for Bug#5395732 ELSE

Line 1471: x_return_status := FND_API.G_RET_STS_ERROR;

1467: p_value4 => p_start_date_tab(i));
1468: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1469: p_data => x_msg_data);
1470: x_msg_count := fnd_msg_pub.count_msg;
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: */
1473: x_proj_rejection_tab(i) := 'PA_FP_PJ_REV_RATE_NOT_DEFINED';
1474: END IF;
1475: ELSE

Line 1499: x_return_status := FND_API.G_RET_STS_ERROR;

1495: p_value5 => p_txn_currency_code_tab(i));
1496: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1497: p_data => x_msg_data);
1498: x_msg_count := fnd_msg_pub.count_msg;
1499: x_return_status := FND_API.G_RET_STS_ERROR;
1500: */
1501: x_proj_rejection_tab(i) := 'PA_FP_PJC_USR_RATE_NOT_ALLOWED';
1502: END IF;
1503: ELSE

Line 1578: x_return_status := FND_API.G_RET_STS_ERROR;

1574: p_value5 => p_txn_currency_code_tab(i));
1575: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1576: p_data => x_msg_data);
1577: x_msg_count := fnd_msg_pub.count_msg;
1578: x_return_status := FND_API.G_RET_STS_ERROR;
1579: */
1580: x_proj_rejection_tab(i) := 'PA_FP_NO_PJ_EXCH_RATE_EXISTS';
1581: END IF;
1582: ELSIF l_converted_amount = -2 THEN

Line 1606: x_return_status := FND_API.G_RET_STS_ERROR;

1602: p_value5 => p_txn_currency_code_tab(i));
1603: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1604: p_data => x_msg_data);
1605: x_msg_count := fnd_msg_pub.count_msg;
1606: x_return_status := FND_API.G_RET_STS_ERROR;
1607: */
1608: x_proj_rejection_tab(i) := 'PA_FP_CURR_NOT_VALID';
1609: -- Commented for Bug#5395732 ELSE
1610: END IF; -- Added for Bug#5395732

Line 1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1720: x_msg_data := FND_MESSAGE.GET;
1721: END IF;
1722: END IF;
1723:
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: fnd_msg_pub.add_exc_msg
1726: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
1727: ,p_procedure_name => 'conv_mc_bulk' );
1728: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);

Line 1739: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1735: */
1736: IF P_PA_DEBUG_MODE = 'Y' THEN
1737: pa_debug.reset_err_stack;
1738: END IF;
1739: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1740: END conv_mc_bulk;
1741:
1742: PROCEDURE convert_txn_currency
1743: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

Line 2072: l_entire_return_status := FND_API.G_RET_STS_SUCCESS;

2068: * so commenting out
2069: *fnd_msg_pub.initialize;
2070: **/
2071:
2072: l_entire_return_status := FND_API.G_RET_STS_SUCCESS;
2073: x_return_status := FND_API.G_RET_STS_SUCCESS;
2074:
2075: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2076: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 2073: x_return_status := FND_API.G_RET_STS_SUCCESS;

2069: *fnd_msg_pub.initialize;
2070: **/
2071:
2072: l_entire_return_status := FND_API.G_RET_STS_SUCCESS;
2073: x_return_status := FND_API.G_RET_STS_SUCCESS;
2074:
2075: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2076: l_debug_mode := NVL(l_debug_mode, 'Y');
2077:

Line 2437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2433:
2434: l_entire_msg_count := nvl(l_entire_msg_count,0) + nvl(l_msg_count,0);
2435: l_entire_msg_data := l_msg_data;
2436:
2437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2438: l_stage := 1200;
2439: l_entire_return_status := l_return_status;
2440: END IF;
2441:

Line 2443: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2439: l_entire_return_status := l_return_status;
2440: END IF;
2441:
2442:
2443: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2444: l_stage := 1300;
2445: IF l_txn_row_id_tab.COUNT > 0 THEN --{
2446: /* Bug fix:4259098: re-calculate the plan cost by adding the actuals to the etc */
2447: FOR i IN l_txn_row_id_tab.FIRST .. l_txn_row_id_tab.LAST LOOP

Line 2574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2570: END IF; -- returned success
2571: END IF; -- rowcount > 0
2572:
2573: EXCEPTION WHEN OTHERS THEN
2574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2575: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2576: p_data => x_msg_data);
2577: x_msg_count := FND_MSG_PUB.Count_Msg;
2578: IF x_msg_count = 1 THEN

Line 2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2595: */
2596: IF P_PA_DEBUG_MODE = 'Y' THEN
2597: pa_debug.reset_err_stack;
2598: END IF;
2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2600: END;
2601:
2602: END LOOP;
2603:

Line 2639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2635: x_msg_data := FND_MESSAGE.GET;
2636: END IF;
2637: END IF;
2638:
2639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2640: fnd_msg_pub.add_exc_msg
2641: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
2642: ,p_procedure_name => 'convert_txn_currency' );
2643: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);

Line 2654: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2650: */
2651: IF P_PA_DEBUG_MODE = 'Y' THEN
2652: pa_debug.reset_err_stack;
2653: END IF;
2654: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2655: END convert_txn_currency;
2656:
2657: /*=============================================================================
2658: This api is used to Round budget line amounts as per the currency precision/

Line 2778: x_return_status := FND_API.G_RET_STS_SUCCESS;

2774:
2775: BEGIN
2776:
2777: x_msg_count := 0;
2778: x_return_status := FND_API.G_RET_STS_SUCCESS;
2779:
2780: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2781: l_debug_mode := NVL(l_debug_mode, 'Y');
2782:

Line 3212: (p_encoded => FND_API.G_TRUE

3208: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3209: l_msg_count := FND_MSG_PUB.count_msg;
3210: IF l_msg_count = 1 THEN
3211: PA_INTERFACE_UTILS_PUB.get_messages
3212: (p_encoded => FND_API.G_TRUE
3213: ,p_msg_index => 1
3214: ,p_msg_count => l_msg_count
3215: ,p_msg_data => l_msg_data
3216: ,p_data => l_data

Line 3225: x_return_status := FND_API.G_RET_STS_ERROR;

3221: ELSE
3222: x_msg_count := l_msg_count;
3223: END IF;
3224:
3225: x_return_status := FND_API.G_RET_STS_ERROR;
3226:
3227: IF l_debug_mode = 'Y' THEN
3228: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
3229: pa_debug.write('Round_Budget_Line_Amounts: ' || g_module_name,pa_debug.g_err_stage,5);

Line 3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3237: pa_debug.reset_curr_function();
3238: END IF;
3239: RETURN;
3240: WHEN Others THEN
3241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3242: x_msg_count := 1;
3243: x_msg_data := SQLERRM;
3244:
3245: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'

Line 3307: x_return_status := FND_API.G_RET_STS_SUCCESS;

3303: --Code changes for bug 4200168 ends here.
3304:
3305: BEGIN
3306: x_msg_count := 0;
3307: x_return_status := FND_API.G_RET_STS_SUCCESS;
3308:
3309: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3310: l_debug_mode := NVL(l_debug_mode, 'Y');
3311:

Line 3556: (p_encoded => FND_API.G_TRUE

3552: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3553: l_msg_count := FND_MSG_PUB.count_msg;
3554: IF l_msg_count = 1 THEN
3555: PA_INTERFACE_UTILS_PUB.get_messages
3556: (p_encoded => FND_API.G_TRUE
3557: ,p_msg_index => 1
3558: ,p_msg_count => l_msg_count
3559: ,p_msg_data => l_msg_data
3560: ,p_data => l_data

Line 3568: x_return_status := FND_API.G_RET_STS_ERROR;

3564: x_msg_count := l_msg_count;
3565: ELSE
3566: x_msg_count := l_msg_count;
3567: END IF;
3568: x_return_status := FND_API.G_RET_STS_ERROR;
3569:
3570: IF l_debug_mode = 'Y' THEN
3571: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
3572: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 3585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3581: END IF;
3582: RETURN;
3583: WHEN OTHERS THEN
3584:
3585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3586: x_msg_count := 1;
3587: x_msg_data := SQLERRM;
3588:
3589: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'