342: p_token3 => 'RESOURCE_NAME',
343: p_value3 => l_resource_name,
344: p_token4 => 'START_DATE',
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: */
344: p_token4 => 'START_DATE',
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;
370: p_token4 => 'START_DATE',
371: p_value4 => p_start_date_tab(i),
372: p_token5 => 'TXN_CURRENCY',
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: */
372: p_token5 => 'TXN_CURRENCY',
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;
476: p_token4 => 'RATE_DATE',
477: p_value4 => p_projfunc_cost_rate_date_tab(i),
478: p_token5 => 'TXN_CURRENCY',
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: */
478: p_token5 => 'TXN_CURRENCY',
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;
504: p_token4 => 'RATE_DATE',
505: p_value4 => p_projfunc_cost_rate_date_tab(i),
506: p_token5 => 'TXN_CURRENCY',
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: */
506: p_token5 => 'TXN_CURRENCY',
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
647: p_token4 => 'RATE_DATE',
648: p_value4 => p_projfunc_cost_rate_date_tab(i),
649: p_token5 => 'TXN_CURRENCY',
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: */
649: p_token5 => 'TXN_CURRENCY',
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;
676: p_token4 => 'RATE_DATE',
677: p_value4 => p_projfunc_cost_rate_date_tab(i),
678: p_token5 => 'TXN_CURRENCY',
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: */
678: p_token5 => 'TXN_CURRENCY',
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:
790: p_token3 => 'RESOURCE_NAME',
791: p_value3 => l_resource_name,
792: p_token4 => 'START_DATE',
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: */
792: p_token4 => 'START_DATE',
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;
818: p_token4 => 'START_DATE',
819: p_value4 => p_start_date_tab(i),
820: p_token5 => 'TXN_CURRENCY',
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: */
820: p_token5 => 'TXN_CURRENCY',
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;
896: p_token4 => 'RATE_DATE',
897: p_value4 => p_projfunc_rev_rate_date_tab(i),
898: p_token5 => 'TXN_CURRENCY',
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: */
898: p_token5 => 'TXN_CURRENCY',
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;
924: p_token4 => 'RATE_DATE',
925: p_value4 => p_projfunc_rev_rate_date_tab(i),
926: p_token5 => 'TXN_CURRENCY',
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: */
926: p_token5 => 'TXN_CURRENCY',
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:
1058: p_token3 => 'RESOURCE_NAME',
1059: p_value3 => l_resource_name,
1060: p_token4 => 'START_DATE',
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: */
1060: p_token4 => 'START_DATE',
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;
1086: p_token4 => 'START_DATE',
1087: p_value4 => p_start_date_tab(i),
1088: p_token5 => 'TXN_CURRENCY',
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: */
1088: p_token5 => 'TXN_CURRENCY',
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;
1188: p_token4 => 'RATE_DATE',
1189: p_value4 => p_proj_cost_rate_date_tab(i),
1190: p_token5 => 'TXN_CURRENCY',
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: */
1190: p_token5 => 'TXN_CURRENCY',
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;
1212: p_token4 => 'RATE_DATE',
1213: p_value4 => p_proj_cost_rate_date_tab(i),
1214: p_token5 => 'TXN_CURRENCY',
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: */
1214: p_token5 => 'TXN_CURRENCY',
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
1338: p_token4 => 'RATE_DATE',
1339: p_value4 => p_proj_cost_rate_date_tab(i),
1340: p_token5 => 'TXN_CURRENCY',
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: */
1340: p_token5 => 'TXN_CURRENCY',
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;
1366: p_token4 => 'RATE_DATE',
1367: p_value4 => p_proj_cost_rate_date_tab(i),
1368: p_token5 => 'TXN_CURRENCY',
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: */
1368: p_token5 => 'TXN_CURRENCY',
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:
1481: p_token3 => 'RESOURCE_NAME',
1482: p_value3 => l_resource_name,
1483: p_token4 => 'START_DATE',
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: */
1483: p_token4 => 'START_DATE',
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;
1509: p_token4 => 'START_DATE',
1510: p_value4 => p_start_date_tab(i),
1511: p_token5 => 'TXN_CURRENCY',
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: */
1511: p_token5 => 'TXN_CURRENCY',
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;
1604: p_token4 => 'RATE_DATE',
1605: p_value4 => p_proj_rev_rate_date_tab(i),
1606: p_token5 => 'TXN_CURRENCY',
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: */
1606: p_token5 => 'TXN_CURRENCY',
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;
1632: p_token4 => 'RATE_DATE',
1633: p_value4 => p_proj_rev_rate_date_tab(i),
1634: p_token5 => 'TXN_CURRENCY',
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: */
1634: p_token5 => 'TXN_CURRENCY',
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
1726: IF P_PA_DEBUG_MODE = 'Y' THEN
1727: pa_debug.write('conv_mc_bulk: ' || g_module_name,pa_debug.g_err_stage,3);
1728: END IF;
1729:
1730: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1731: p_data => x_msg_data);
1732: x_msg_count := FND_MSG_PUB.Count_Msg;
1733: IF x_msg_count = 1 THEN
1734: IF x_msg_data IS NOT NULL THEN
1728: END IF;
1729:
1730: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1731: p_data => x_msg_data);
1732: x_msg_count := FND_MSG_PUB.Count_Msg;
1733: IF x_msg_count = 1 THEN
1734: IF x_msg_data IS NOT NULL THEN
1735: FND_MESSAGE.SET_ENCODED (x_msg_data);
1736: x_msg_data := FND_MESSAGE.GET;
1743: pa_debug.reset_err_stack;
1744: END IF;
1745:
1746: EXCEPTION WHEN OTHERS THEN
1747: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1748: p_data => x_msg_data);
1749: x_msg_count := FND_MSG_PUB.Count_Msg;
1750: IF x_msg_count = 1 THEN
1751: IF x_msg_data IS NOT NULL THEN
1745:
1746: EXCEPTION WHEN OTHERS THEN
1747: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1748: p_data => x_msg_data);
1749: x_msg_count := FND_MSG_PUB.Count_Msg;
1750: IF x_msg_count = 1 THEN
1751: IF x_msg_data IS NOT NULL THEN
1752: FND_MESSAGE.SET_ENCODED (x_msg_data);
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);
1762: IF P_PA_DEBUG_MODE = 'Y' THEN
2098: BEGIN
2099:
2100: /** Bug fix: 3849908 initialization of msg stack here removes all the error msgs added during the calculate api and spread process
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;
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
2612: IF x_msg_data IS NOT NULL THEN
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
2612: IF x_msg_data IS NOT NULL THEN
2613: FND_MESSAGE.SET_ENCODED (x_msg_data);
2614: x_msg_data := FND_MESSAGE.GET;
2614: x_msg_data := FND_MESSAGE.GET;
2615: END IF;
2616: END IF;
2617:
2618: fnd_msg_pub.add_exc_msg
2619: ( p_pkg_name => 'PA_FP_MULTI_CURRENCY_PKG'
2620: ,p_procedure_name => 'convert_txn_currency' );
2621: pa_debug.g_err_stage := 'Stage : '||to_char(l_stage)||' '||substr(SQLERRM,1,240);
2622: IF P_PA_DEBUG_MODE = 'Y' THEN
2640: CLOSE rollup_lines;
2641: END IF;
2642:
2643: x_return_status := l_entire_return_status;
2644: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2645: p_data => x_msg_data);
2646: x_msg_count := FND_MSG_PUB.Count_Msg;
2647: IF x_msg_count = 1 THEN
2648: IF x_msg_data IS NOT NULL THEN
2642:
2643: x_return_status := l_entire_return_status;
2644: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2645: p_data => x_msg_data);
2646: x_msg_count := FND_MSG_PUB.Count_Msg;
2647: IF x_msg_count = 1 THEN
2648: IF x_msg_data IS NOT NULL THEN
2649: FND_MESSAGE.SET_ENCODED (x_msg_data);
2650: x_msg_data := FND_MESSAGE.GET;
2658: pa_debug.reset_err_stack;
2659: END IF;
2660:
2661: EXCEPTION WHEN OTHERS THEN
2662: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2663: p_data => x_msg_data);
2664: x_msg_count := FND_MSG_PUB.Count_Msg;
2665: IF x_msg_count = 1 THEN
2666: IF x_msg_data IS NOT NULL THEN
2660:
2661: EXCEPTION WHEN OTHERS THEN
2662: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2663: p_data => x_msg_data);
2664: x_msg_count := FND_MSG_PUB.Count_Msg;
2665: IF x_msg_count = 1 THEN
2666: IF x_msg_data IS NOT NULL THEN
2667: FND_MESSAGE.SET_ENCODED (x_msg_data);
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);
2677: IF P_PA_DEBUG_MODE = 'Y' THEN
3238:
3239: EXCEPTION
3240:
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
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'
3279: ,p_procedure_name => 'Round_Budget_Line_Amounts');
3280:
3281: IF l_debug_mode = 'Y' THEN
3282: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
3582: END IF;
3583: EXCEPTION
3584:
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
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'
3623: ,p_procedure_name => 'round_amounts');
3624:
3625: IF l_debug_mode = 'Y' THEN
3626: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;