DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on FND_API

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

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

Line 732: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 739: retcode := FND_API.G_RET_STS_ERROR;

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

Line 743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 1079: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1238: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1328: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1388: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1594: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1666: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1736: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1814: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 2203: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2759: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 2986: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3099: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3139: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3453: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 3933: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 4048: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4086: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4125: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4151: retcode := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4420: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4900: (p_encoded => FND_API.G_TRUE

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

Line 4911: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 4930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4972: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 5602: (p_encoded => FND_API.G_TRUE

5598: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5599: l_msg_count := FND_MSG_PUB.count_msg;
5600: IF l_msg_count = 1 THEN
5601: PA_INTERFACE_UTILS_PUB.get_messages
5602: (p_encoded => FND_API.G_TRUE
5603: ,p_msg_index => 1
5604: ,p_msg_count => l_msg_count
5605: ,p_msg_data => l_msg_data
5606: ,p_data => l_data

Line 5613: x_return_status := FND_API.G_RET_STS_ERROR;

5609: x_msg_count := l_msg_count;
5610: ELSE
5611: x_msg_count := l_msg_count;
5612: END IF;
5613: x_return_status := FND_API.G_RET_STS_ERROR;
5614:
5615: IF P_PA_DEBUG_MODE = 'Y' THEN
5616: pa_debug.g_err_stage:='Invalid Arguments Passed';
5617: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,5);

Line 5623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5619: pa_debug.reset_err_stack;
5620: RAISE;
5621:
5622: WHEN Others THEN
5623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5624: x_msg_count := 1;
5625: x_msg_data := SQLERRM;
5626: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'
5627: ,p_procedure_name => 'COPY_RESOURCE_ASSIGNMENTS');

Line 5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5630: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
5631: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,5);
5632: END IF;
5633: pa_debug.reset_err_stack;
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635:
5636: END Copy_Resource_Assignments;
5637:
5638: /*===================================================================

Line 5690: x_return_status := FND_API.G_RET_STS_SUCCESS;

5686:
5687: BEGIN
5688:
5689: x_msg_count := 0;
5690: x_return_status := FND_API.G_RET_STS_SUCCESS;
5691: pa_debug.set_err_stack('pa_fp_org_fcst_gen_pub.Copy_Budget_Lines');
5692: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5693: l_debug_mode := NVL(l_debug_mode, 'Y');
5694: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 6067: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6063: ,x_return_status => l_return_status
6064: ,x_msg_count => l_msg_count
6065: ,x_msg_data => l_msg_data);
6066:
6067: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6068: IF P_PA_debug_mode = 'Y' THEN
6069: pa_debug.g_err_stage:= 'Error in PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts';
6070: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
6071: END IF;

Line 6087: (p_encoded => FND_API.G_TRUE

6083: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6084: l_msg_count := FND_MSG_PUB.count_msg;
6085: IF l_msg_count = 1 THEN
6086: PA_INTERFACE_UTILS_PUB.get_messages
6087: (p_encoded => FND_API.G_TRUE
6088: ,p_msg_index => 1
6089: ,p_msg_count => l_msg_count
6090: ,p_msg_data => l_msg_data
6091: ,p_data => l_data

Line 6098: x_return_status := FND_API.G_RET_STS_ERROR;

6094: x_msg_count := l_msg_count;
6095: ELSE
6096: x_msg_count := l_msg_count;
6097: END IF;
6098: x_return_status := FND_API.G_RET_STS_ERROR;
6099:
6100: IF P_PA_DEBUG_MODE = 'Y' THEN
6101: pa_debug.g_err_stage:='Invalid arguments passed';
6102: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);

Line 6108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6104: pa_debug.reset_err_stack;
6105: RAISE;
6106:
6107: WHEN Others THEN
6108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6109: x_msg_count := 1;
6110: x_msg_data := SQLERRM;
6111: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'pa_fp_org_fcst_gen_pub'
6112: ,p_procedure_name => 'COPY_BUDGET_LINES');

Line 6119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6115: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
6116: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,6);
6117: END IF;
6118: pa_debug.reset_err_stack;
6119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6120: END Copy_Budget_Lines;
6121:
6122:
6123: END pa_fp_org_fcst_gen_pub;