DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on FND_API

Line 729: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

725: IF P_PA_DEBUG_MODE = 'Y' THEN
726: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
727: END IF;
728:
729: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
730: THEN
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
733: ': Error occured while Getting forecast Options Det [' ||

Line 731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

727: END IF;
728:
729: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
730: THEN
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
733: ': Error occured while Getting forecast Options Det [' ||
734: l_err_code|| ']';
735: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 738: retcode := FND_API.G_RET_STS_ERROR;

734: l_err_code|| ']';
735: IF P_PA_DEBUG_MODE = 'Y' THEN
736: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
737: END IF;
738: retcode := FND_API.G_RET_STS_ERROR;
739: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
740: p_msg_name => 'PA_FP_FCST_OPTION_ERR');
741: END IF;
742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

738: retcode := FND_API.G_RET_STS_ERROR;
739: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
740: p_msg_name => 'PA_FP_FCST_OPTION_ERR');
741: END IF;
742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
743: END IF;
744:
745:
746: /* Get resource list information */

Line 769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

765: pa_debug.g_err_stage := TO_CHAR(l_stage)||'-'||SQLERRM;
766: IF P_PA_DEBUG_MODE = 'Y' THEN
767: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
768: END IF;
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END;
771:
772: BEGIN
773: l_stage := 300;

Line 829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

825: pa_debug.g_err_stage := TO_CHAR(l_stage)||'-'||SQLERRM;
826: IF P_PA_DEBUG_MODE = 'Y' THEN
827: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
828: END IF;
829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
830: END;
831:
832: BEGIN
833: IF p_budget_version_id IS NULL THEN

Line 866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

862: pa_debug.g_err_stage := TO_CHAR(l_stage)||'-'||SQLERRM;
863: IF P_PA_DEBUG_MODE = 'Y' THEN
864: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
865: END IF;
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END;
868:
869: l_budget_ctr := 0; /* This is required to let the loop run
870: only once if budget version id is passed*/

Line 1040: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1036: ,x_org_project_id => l_project_id
1037: ,x_return_status => l_return_status
1038: ,x_err_code => l_err_code);
1039:
1040: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1041: THEN
1042: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1043: ': Error occured while Getting Project Info [' ||
1044: l_err_code|| ']';

Line 1078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1074: ,x_org_task_id => l_own_task_id
1075: ,x_return_status => l_return_status
1076: ,x_err_code => l_err_code);
1077:
1078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1079: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1080: ': Error getting Own Task';
1081: IF P_PA_DEBUG_MODE = 'Y' THEN
1082: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1237: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1233: ,x_err_code => l_err_code);
1234:
1235: -- hr_utility.trace('Own Task Id = '||to_char(l_own_task_id));
1236:
1237: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1238: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1239: ': Error getting Own Task';
1240: IF P_PA_DEBUG_MODE = 'Y' THEN
1241: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1327: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1323: ,p_fin_plan_version_id => NULL
1324: ,x_row_id => l_row_id
1325: ,x_return_status => l_return_status);
1326:
1327: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1328: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1329: ': Error creating Proj FP Options';
1330: IF P_PA_DEBUG_MODE = 'Y' THEN
1331: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1387: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1383: ,p_fin_plan_version_id => NULL
1384: ,x_row_id => l_row_id
1385: ,x_return_status => l_return_status);
1386:
1387: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1388: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1389: ': Error creating Plan FP Options';
1390: IF P_PA_DEBUG_MODE = 'Y' THEN
1391: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1469: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1465: ,x_period_profile_id => l_period_profile_id
1466: ,x_return_status => l_return_status
1467: ,x_err_code => l_err_code);
1468:
1469: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1470: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1471: ': Error in get_period_profile ';
1472: IF P_PA_DEBUG_MODE = 'Y' THEN
1473: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1512: ,x_return_status => l_return_status
1513: ,x_msg_count => l_msg_count
1514: ,x_msg_data => errbuff );
1515:
1516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1517: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1518: ': Error creating period profile';
1519: IF P_PA_DEBUG_MODE = 'Y' THEN
1520: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1593: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1589: IF P_PA_DEBUG_MODE = 'Y' THEN
1590: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);
1591: END IF;
1592:
1593: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1594: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1595: ': Error creating Budget version';
1596: IF P_PA_DEBUG_MODE = 'Y' THEN
1597: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1665: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1661: ,p_fin_plan_version_id => l_budget_version_id
1662: ,x_row_id => l_row_id
1663: ,x_return_status => l_return_status);
1664:
1665: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1666: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1667: ': Error creating Budget Version FP Options';
1668: IF P_PA_DEBUG_MODE = 'Y' THEN
1669: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1731: ,x_err_code => l_err_code);
1732:
1733: -- hr_utility.trace('Own Task Id = '||to_char(l_own_task_id));
1734:
1735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1736: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1737: ': Error getting Own Task';
1738: IF P_PA_DEBUG_MODE = 'Y' THEN
1739: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1813: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1809: ,x_return_status => l_return_status
1810: --,x_msg_count => x_msg_count
1811: ,x_msg_data => errbuff );
1812:
1813: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1814: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
1815: ': Error getting period profile info';
1816: IF P_PA_DEBUG_MODE = 'Y' THEN
1817: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 1843: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1839: x_return_status => l_return_status,
1840: x_msg_count => l_msg_count,
1841: x_msg_data => l_msg_data);
1842:
1843: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1844: RAISE pa_fp_org_fcst_gen_pub.error_reloop;
1845: END IF;
1846: l_stage := 4900;
1847: -- hr_utility.trace(to_char(l_stage));

Line 2202: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2198: l_stage := 5600;
2199: -- hr_utility.trace(to_char(l_stage));
2200: -- hr_utility.trace('Probability => '||to_char(l_prob_percent));
2201:
2202: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2203: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
2204: ': Error getting probability percent';
2205: IF P_PA_DEBUG_MODE = 'Y' THEN
2206: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 2758: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2754: ,x_return_status => l_return_status
2755: ,x_msg_count => l_msg_count
2756: ,x_msg_data => errbuff );
2757:
2758: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2759: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
2760: ': Error creating Period Denorm';
2761: IF P_PA_DEBUG_MODE = 'Y' THEN
2762: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 2985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2981: ,p_resource_assignment_type => 'OWN'
2982: ,x_row_id => l_row_id
2983: ,x_return_status => l_return_status );
2984:
2985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2986: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
2987: ': Error creating Resource Assignment';
2988: IF P_PA_DEBUG_MODE = 'Y' THEN
2989: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 3098: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3094: ,x_err_code => l_err_code);
3095:
3096: -- hr_utility.trace(l_err_code);
3097:
3098: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3099: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
3100: ':Error getting utilization details'||'-'||l_err_code;
3101: IF P_PA_DEBUG_MODE = 'Y' THEN
3102: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 3138: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3134: ,x_headcount => l_bl_head_count_tab(i)
3135: ,x_return_status => l_return_status
3136: ,x_err_code => l_err_code);
3137:
3138: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3139: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
3140: ':Error getting Head Count';
3141: IF P_PA_DEBUG_MODE = 'Y' THEN
3142: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 3452: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3448: ,x_return_status => l_return_status
3449: ,x_msg_count => l_msg_count
3450: ,x_msg_data => errbuff );
3451:
3452: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3453: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
3454: ':Error creating Period Denorm';
3455: IF P_PA_DEBUG_MODE = 'Y' THEN
3456: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 3524: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3520: ,p_resource_assignment_type => 'PROJECT'
3521: ,x_row_id => l_row_id
3522: ,x_return_status => l_return_status );
3523:
3524: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3525: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
3526: ': Error creating Proj Resource Assignment';
3527: IF P_PA_DEBUG_MODE = 'Y' THEN
3528: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 3932: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3928: ,x_msg_data => errbuff
3929: ,p_budget_version_id => l_budget_version_id
3930: ,p_project_id => l_project_id);
3931:
3932: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3933: pa_debug.g_err_stage := TO_CHAR(l_stage) ||
3934: ':Error creating Period Denorm';
3935: IF P_PA_DEBUG_MODE = 'Y' THEN
3936: pa_debug.write_file('gen_org_fcst: ' || pa_debug.g_err_stage);

Line 4047: l_return_status := FND_API.G_RET_STS_ERROR;

4043: argument7 => l_organization_id, -- P_ORGANIZATION_ID
4044: argument8 => NULL, -- P_START_ORGANIZATION_FLAG
4045: argument9 => NULL); -- P_START_ORGANIZATION_ID
4046: IF l_request_id = 0 then
4047: l_return_status := FND_API.G_RET_STS_ERROR;
4048: IF P_PA_DEBUG_MODE = 'Y' THEN
4049: pa_debug.write_file('gen_org_fcst: ' || 'Report not successful [PAFPEXRP] l_request_id=0; ERROR');
4050: END IF;
4051: ELSE

Line 4085: l_return_status := FND_API.G_RET_STS_ERROR;

4081: argument7 => NULL, -- P_ORGANIZATION_ID
4082: argument8 => 1, -- P_START_ORGANIZATION_FLAG
4083: argument9 => p_starting_organization_id); -- P_START_ORGANIZATION_ID
4084: IF l_request_id = 0 then
4085: l_return_status := FND_API.G_RET_STS_ERROR;
4086: IF P_PA_DEBUG_MODE = 'Y' THEN
4087: pa_debug.write_file('gen_org_fcst: ' || 'Report not successful [PAFPEXRP] l_request_id=0; ERROR');
4088: END IF;
4089: ELSE

Line 4124: l_return_status := FND_API.G_RET_STS_ERROR;

4120: argument8 => NULL, -- P_START_ORGANIZATION_FLAG
4121: argument9 => NULL); -- P_START_ORGANIZATION_ID
4122:
4123: IF l_request_id = 0 then
4124: l_return_status := FND_API.G_RET_STS_ERROR;
4125: IF P_PA_DEBUG_MODE = 'Y' THEN
4126: pa_debug.write_file('gen_org_fcst: ' || 'Report not successful [PAFPEXRP] l_request_id=0; ERROR');
4127: END IF;
4128: ELSE

Line 4150: retcode := FND_API.G_RET_STS_UNEXP_ERROR;

4146: FND_MSG_PUB.add_exc_msg
4147: ( p_pkg_name => 'PA_FP_ORG_FCST_GEN_PKG.gen_org_fcst'
4148: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
4149:
4150: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
4151: errbuff := TO_CHAR(l_stage)||'['||SQLERRM||']';
4152:
4153: -- hr_utility.trace(to_char(l_stage)||'-'||SQLERRM);
4154: pa_debug.g_err_stage := TO_CHAR(l_stage)||'['||SQLERRM||']';

Line 4419: x_return_status := FND_API.G_RET_STS_SUCCESS;

4415: 'PROJECT', l_target_project_id) ;
4416: BEGIN
4417:
4418: x_msg_count := 0;
4419: x_return_status := FND_API.G_RET_STS_SUCCESS;
4420: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Create_Res_Task_Maps');
4421: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4422: l_debug_mode := NVL(l_debug_mode, 'Y');
4423: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 4899: (p_encoded => FND_API.G_TRUE

4895: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4896: l_msg_count := FND_MSG_PUB.count_msg;
4897: IF l_msg_count = 1 THEN
4898: PA_INTERFACE_UTILS_PUB.get_messages
4899: (p_encoded => FND_API.G_TRUE
4900: ,p_msg_index => 1
4901: ,p_msg_count => l_msg_count
4902: ,p_msg_data => l_msg_data
4903: ,p_data => l_data

Line 4910: x_return_status := FND_API.G_RET_STS_ERROR;

4906: x_msg_count := l_msg_count;
4907: ELSE
4908: x_msg_count := l_msg_count;
4909: END IF;
4910: x_return_status := FND_API.G_RET_STS_ERROR;
4911: IF P_PA_DEBUG_MODE = 'Y' THEN
4912: pa_debug.g_err_stage:='Invalid Arguments Passed';
4913: pa_debug.write('create_res_task_maps: ' || g_module_name,pa_debug.g_err_stage,5);
4914: END IF;

Line 4919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4915: pa_debug.reset_err_stack;
4916: RAISE;
4917:
4918: WHEN Others THEN
4919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4920: x_msg_count := 1;
4921: x_msg_data := SQLERRM;
4922: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_org_fcst_gen_pub'
4923: ,p_procedure_name => 'CREATE_RES_TASK_MAPS');

Line 4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4925: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
4926: pa_debug.write('create_res_task_maps: ' || g_module_name,pa_debug.g_err_stage,5);
4927: END IF;
4928: pa_debug.reset_err_stack;
4929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4930:
4931: END CREATE_RES_TASK_MAPS;
4932:
4933:

Line 4971: x_return_status := FND_API.G_RET_STS_SUCCESS;

4967:
4968: BEGIN
4969:
4970: x_msg_count := 0;
4971: x_return_status := FND_API.G_RET_STS_SUCCESS;
4972: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Resource_Assignments');
4973: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4974: l_debug_mode := NVL(l_debug_mode, 'Y');
4975: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 5597: (p_encoded => FND_API.G_TRUE

5593: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5594: l_msg_count := FND_MSG_PUB.count_msg;
5595: IF l_msg_count = 1 THEN
5596: PA_INTERFACE_UTILS_PUB.get_messages
5597: (p_encoded => FND_API.G_TRUE
5598: ,p_msg_index => 1
5599: ,p_msg_count => l_msg_count
5600: ,p_msg_data => l_msg_data
5601: ,p_data => l_data

Line 5608: x_return_status := FND_API.G_RET_STS_ERROR;

5604: x_msg_count := l_msg_count;
5605: ELSE
5606: x_msg_count := l_msg_count;
5607: END IF;
5608: x_return_status := FND_API.G_RET_STS_ERROR;
5609:
5610: IF P_PA_DEBUG_MODE = 'Y' THEN
5611: pa_debug.g_err_stage:='Invalid Arguments Passed';
5612: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,5);

Line 5618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5614: pa_debug.reset_err_stack;
5615: RAISE;
5616:
5617: WHEN Others THEN
5618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5619: x_msg_count := 1;
5620: x_msg_data := SQLERRM;
5621: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'
5622: ,p_procedure_name => 'COPY_RESOURCE_ASSIGNMENTS');

Line 5629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5625: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
5626: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,5);
5627: END IF;
5628: pa_debug.reset_err_stack;
5629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5630:
5631: END Copy_Resource_Assignments;
5632:
5633: /*===================================================================

Line 5685: x_return_status := FND_API.G_RET_STS_SUCCESS;

5681:
5682: BEGIN
5683:
5684: x_msg_count := 0;
5685: x_return_status := FND_API.G_RET_STS_SUCCESS;
5686: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Budget_Lines');
5687: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5688: l_debug_mode := NVL(l_debug_mode, 'Y');
5689: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 6062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6058: ,x_return_status => l_return_status
6059: ,x_msg_count => l_msg_count
6060: ,x_msg_data => l_msg_data);
6061:
6062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6063: IF P_PA_debug_mode = 'Y' THEN
6064: pa_debug.g_err_stage:= 'Error in PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts';
6065: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
6066: END IF;

Line 6082: (p_encoded => FND_API.G_TRUE

6078: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6079: l_msg_count := FND_MSG_PUB.count_msg;
6080: IF l_msg_count = 1 THEN
6081: PA_INTERFACE_UTILS_PUB.get_messages
6082: (p_encoded => FND_API.G_TRUE
6083: ,p_msg_index => 1
6084: ,p_msg_count => l_msg_count
6085: ,p_msg_data => l_msg_data
6086: ,p_data => l_data

Line 6093: x_return_status := FND_API.G_RET_STS_ERROR;

6089: x_msg_count := l_msg_count;
6090: ELSE
6091: x_msg_count := l_msg_count;
6092: END IF;
6093: x_return_status := FND_API.G_RET_STS_ERROR;
6094:
6095: IF P_PA_DEBUG_MODE = 'Y' THEN
6096: pa_debug.g_err_stage:='Invalid arguments passed';
6097: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);

Line 6103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6099: pa_debug.reset_err_stack;
6100: RAISE;
6101:
6102: WHEN Others THEN
6103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6104: x_msg_count := 1;
6105: x_msg_data := SQLERRM;
6106: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'
6107: ,p_procedure_name => 'COPY_BUDGET_LINES');

Line 6114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6110: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
6111: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,6);
6112: END IF;
6113: pa_debug.reset_err_stack;
6114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6115: END Copy_Budget_Lines;
6116:
6117:
6118: END pa_fp_org_fcst_gen_pub;