eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on FND_API

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

69: FOR UPDATE NOWAIT;
70: BEGIN
71:
72: x_msg_count := 0;
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: IF P_PA_DEBUG_MODE = 'Y' THEN
76: pa_debug.set_err_stack('Acquire_Locks_For_Copy_Plan');
77: END IF;

Line 171: (p_encoded => FND_API.G_TRUE

167:
168: l_msg_count := FND_MSG_PUB.count_msg;
169: IF l_msg_count = 1 THEN
170: PA_INTERFACE_UTILS_PUB.get_messages
171: (p_encoded => FND_API.G_TRUE
172: ,p_msg_index => 1
173: ,p_msg_count => l_msg_count
174: ,p_msg_data => l_msg_data
175: ,p_data => l_data

Line 183: x_return_status:= FND_API.G_RET_STS_ERROR;

179: ELSE
180: x_msg_count := l_msg_count;
181: END IF;
182:
183: x_return_status:= FND_API.G_RET_STS_ERROR;
184: IF P_PA_DEBUG_MODE = 'Y' THEN
185: pa_debug.reset_err_stack;
186: END IF;
187: RAISE;

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

208: IF target_bdgt_vers_cur%ISOPEN THEN
209: CLOSE target_bdgt_vers_cur;
210: END IF;
211:
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: x_msg_count := 1;
214: x_msg_data := SQLERRM;
215: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
216: ,p_procedure_name => 'ACQUIRE_LOCKS_FOR_COPY_PLAN');

Line 361: x_return_status := FND_API.G_RET_STS_SUCCESS;

357: BEGIN
358:
359: FND_MSG_PUB.INITIALIZE;
360: x_msg_count := 0;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: IF P_PA_DEBUG_MODE = 'Y' THEN
364: pa_debug.init_err_stack('PA_FP_COPY_FROM_PKG.Copy_Plan');
365: END IF;

Line 585: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

581: ,x_msg_count => l_msg_count
582: ,x_msg_data => l_msg_data );
583:
584: /* Bug# 2647047 - Raise if return status is not success */
585: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
586: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
587: END IF;
588:
589: --Calling the api to copy source version to target version

Line 610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

606: ,x_msg_count => l_msg_count
607: ,x_msg_data => l_msg_data);
608:
609: /* Bug# 2647047 - Raise if return status is not success */
610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
611: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
612: END IF;
613:
614: -- Start of changes for bug 2729191

Line 728: (p_encoded => FND_API.G_TRUE

724:
725: l_msg_count := FND_MSG_PUB.count_msg;
726: IF l_msg_count = 1 THEN
727: PA_INTERFACE_UTILS_PUB.get_messages
728: (p_encoded => FND_API.G_TRUE
729: ,p_msg_index => 1
730: ,p_msg_count => l_msg_count
731: ,p_msg_data => l_msg_data
732: ,p_data => l_data

Line 741: x_return_status:= FND_API.G_RET_STS_ERROR;

737: x_msg_count := l_msg_count;
738: END IF;
739:
740: ROLLBACK;
741: x_return_status:= FND_API.G_RET_STS_ERROR;
742: IF P_PA_DEBUG_MODE = 'Y' THEN
743: pa_debug.reset_err_stack;
744: END IF;
745: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 749: (p_encoded => FND_API.G_TRUE

745: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
746: l_msg_count := FND_MSG_PUB.count_msg;
747: IF l_msg_count = 1 THEN
748: PA_INTERFACE_UTILS_PUB.get_messages
749: (p_encoded => FND_API.G_TRUE
750: ,p_msg_index => 1
751: ,p_msg_count => l_msg_count
752: ,p_msg_data => l_msg_data
753: ,p_data => l_data

Line 762: x_return_status:= FND_API.G_RET_STS_ERROR;

758: x_msg_count := l_msg_count;
759: END IF;
760:
761: ROLLBACK;
762: x_return_status:= FND_API.G_RET_STS_ERROR;
763: IF P_PA_DEBUG_MODE = 'Y' THEN
764: pa_debug.reset_err_stack;
765: END IF;
766: WHEN Others THEN

Line 767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

763: IF P_PA_DEBUG_MODE = 'Y' THEN
764: pa_debug.reset_err_stack;
765: END IF;
766: WHEN Others THEN
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: x_msg_count := 1;
769: x_msg_data := SQLERRM;
770: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
771: ,p_procedure_name => 'COPY_PLAN');

Line 834: x_return_status := FND_API.G_RET_STS_SUCCESS;

830: FOR UPDATE NOWAIT;
831: BEGIN
832:
833: x_msg_count := 0;
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835:
836: IF P_PA_DEBUG_MODE = 'Y' THEN
837: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Acquire_Lock_For_Copy_Actual');
838: END IF;

Line 912: x_return_status := FND_API.G_RET_STS_ERROR;

908: pa_debug.g_err_stage:='Unable to acquire lock';
909: pa_debug.write('Acquire_Locks_For_Copy_Actual: ' || g_module_name,pa_debug.g_err_stage,5);
910: END IF;
911:
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: l_msg_count := FND_MSG_PUB.count_msg;
914: IF l_msg_count = 1 THEN
915: PA_INTERFACE_UTILS_PUB.get_messages
916: (p_encoded => FND_API.G_TRUE

Line 916: (p_encoded => FND_API.G_TRUE

912: x_return_status := FND_API.G_RET_STS_ERROR;
913: l_msg_count := FND_MSG_PUB.count_msg;
914: IF l_msg_count = 1 THEN
915: PA_INTERFACE_UTILS_PUB.get_messages
916: (p_encoded => FND_API.G_TRUE
917: ,p_msg_index => 1
918: ,p_msg_count => l_msg_count
919: ,p_msg_data => l_msg_data
920: ,p_data => l_data

Line 933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

929: END IF;
930: RAISE;
931:
932: WHEN Others THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: x_msg_count := 1;
935: x_msg_data := SQLERRM;
936: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
937: ,p_procedure_name => 'ACQUIRE_LOCKS_FOR_COPY_ACTUAL');

Line 944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

940: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
941: pa_debug.write('Acquire_Locks_For_Copy_Actual: ' || g_module_name,pa_debug.g_err_stage,5);
942: pa_debug.reset_err_stack;
943: END IF;
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945:
946: END Acquire_Locks_For_Copy_Actual;
947:
948:

Line 1147: x_return_status := FND_API.G_RET_STS_SUCCESS;

1143:
1144: BEGIN
1145:
1146: x_msg_count := 0;
1147: x_return_status := FND_API.G_RET_STS_SUCCESS;
1148: IF p_pa_debug_mode = 'Y' THEN
1149: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Version');
1150: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1151: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 1838: (p_encoded => FND_API.G_TRUE

1834: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1835: l_msg_count := FND_MSG_PUB.count_msg;
1836: IF l_msg_count = 1 THEN
1837: PA_INTERFACE_UTILS_PUB.get_messages
1838: (p_encoded => FND_API.G_TRUE
1839: ,p_msg_index => 1
1840: ,p_msg_count => l_msg_count
1841: ,p_msg_data => l_msg_data
1842: ,p_data => l_data

Line 1849: x_return_status := FND_API.G_RET_STS_ERROR;

1845: x_msg_count := l_msg_count;
1846: ELSE
1847: x_msg_count := l_msg_count;
1848: END IF;
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850:
1851: IF P_PA_DEBUG_MODE = 'Y' THEN
1852: pa_debug.g_err_stage:='Invalid Arguments Passed';
1853: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

Line 1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1855: END IF;
1856: RAISE;
1857:
1858: WHEN Others THEN
1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1860: x_msg_count := 1;
1861: x_msg_data := SQLERRM;
1862: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'
1863: ,p_procedure_name => 'COPY_BUDGET_VERSION');

Line 1945: x_return_status := FND_API.G_RET_STS_SUCCESS;

1941:
1942: BEGIN
1943:
1944: x_msg_count := 0;
1945: x_return_status := FND_API.G_RET_STS_SUCCESS;
1946:
1947: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1948: l_debug_mode := NVL(l_debug_mode, 'Y');
1949:

Line 2165: (p_encoded => FND_API.G_TRUE

2161: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2162: l_msg_count := FND_MSG_PUB.count_msg;
2163: IF l_msg_count = 1 THEN
2164: PA_INTERFACE_UTILS_PUB.get_messages
2165: (p_encoded => FND_API.G_TRUE
2166: ,p_msg_index => 1
2167: ,p_msg_count => l_msg_count
2168: ,p_msg_data => l_msg_data
2169: ,p_data => l_data

Line 2178: x_return_status := FND_API.G_RET_STS_ERROR;

2174: ELSE
2175: x_msg_count := l_msg_count;
2176: END IF;
2177:
2178: x_return_status := FND_API.G_RET_STS_ERROR;
2179:
2180: IF l_debug_mode = 'Y' THEN
2181: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
2182: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 2189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2185: END IF;
2186: RETURN;
2187:
2188: WHEN OTHERS THEN
2189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2190: x_msg_count := 1;
2191: x_msg_data := SQLERRM;
2192:
2193: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

Line 2277: x_return_status := FND_API.G_RET_STS_SUCCESS;

2273:
2274:
2275: BEGIN
2276: x_msg_count := 0;
2277: x_return_status := FND_API.G_RET_STS_SUCCESS;
2278: IF P_PA_DEBUG_MODE = 'Y' THEN
2279: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Resource_Assignments');
2280: END IF;
2281: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 4052: (p_encoded => FND_API.G_TRUE

4048: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4049: l_msg_count := FND_MSG_PUB.count_msg;
4050: IF l_msg_count = 1 THEN
4051: PA_INTERFACE_UTILS_PUB.get_messages
4052: (p_encoded => FND_API.G_TRUE
4053: ,p_msg_index => 1
4054: ,p_msg_count => l_msg_count
4055: ,p_msg_data => l_msg_data
4056: ,p_data => l_data

Line 4063: x_return_status := FND_API.G_RET_STS_ERROR;

4059: x_msg_count := l_msg_count;
4060: ELSE
4061: x_msg_count := l_msg_count;
4062: END IF;
4063: x_return_status := FND_API.G_RET_STS_ERROR;
4064:
4065: IF P_PA_DEBUG_MODE = 'Y' THEN
4066: pa_debug.g_err_stage:='Invalid Arguments Passed';
4067: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,5);

Line 4073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4069: END IF;
4070: RAISE;
4071:
4072: WHEN Others THEN
4073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4074: x_msg_count := 1;
4075: x_msg_data := SQLERRM;
4076: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
4077: ,p_procedure_name => 'COPY_RESOURCE_ASSIGNMENTS');

Line 4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4080: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
4081: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,5);
4082: pa_debug.reset_err_stack;
4083: END IF;
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085:
4086: END Copy_Resource_Assignments;
4087:
4088: --Bug 4290043.This private API will be called from copy_budget_lines and Copy_Budget_Lines_Appr_Rev in this package

Line 4147: x_return_status := FND_API.G_RET_STS_SUCCESS;

4143:
4144: BEGIN
4145:
4146: x_msg_count := 0;
4147: x_return_status := FND_API.G_RET_STS_SUCCESS;
4148:
4149: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4150: l_debug_mode := NVL(l_debug_mode, 'Y');
4151: l_module_name := 'PAFPCPFB.mis_amts_chk_neg_qty';

Line 4279: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4275: ,x_return_status => l_return_status
4276: ,x_msg_count => l_msg_count
4277: ,x_msg_data => l_msg_data);
4278:
4279: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4280: IF l_debug_mode = 'Y' THEN
4281: pa_debug.g_err_stage:= 'Error in pa_fp_upgrade_pkg.Apply_Calculate_FPM_Rules';
4282: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
4283: END IF;

Line 4351: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4347: ,x_return_status => l_return_status
4348: ,x_msg_count => l_msg_count
4349: ,x_msg_data => l_msg_data);
4350:
4351: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4352: IF l_debug_mode = 'Y' THEN
4353: pa_debug.g_err_stage:= 'Error in PA_FP_CALC_PLAN_PKG.CheckZeroQTyNegETC';
4354: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
4355: END IF;

Line 4648: (p_encoded => FND_API.G_TRUE

4644: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4645: l_msg_count := FND_MSG_PUB.count_msg;
4646: IF l_msg_count = 1 THEN
4647: PA_INTERFACE_UTILS_PUB.get_messages
4648: (p_encoded => FND_API.G_TRUE
4649: ,p_msg_index => 1
4650: ,p_msg_count => l_msg_count
4651: ,p_msg_data => l_msg_data
4652: ,p_data => l_data

Line 4660: x_return_status := FND_API.G_RET_STS_ERROR;

4656: x_msg_count := l_msg_count;
4657: ELSE
4658: x_msg_count := l_msg_count;
4659: END IF;
4660: x_return_status := FND_API.G_RET_STS_ERROR;
4661:
4662: IF l_debug_mode = 'Y' THEN
4663: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
4664: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);

Line 4670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4666: pa_debug.reset_curr_function();
4667: END IF;
4668: RETURN;
4669: WHEN OTHERS THEN
4670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4671: x_msg_count := 1;
4672: x_msg_data := SQLERRM;
4673:
4674: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

Line 4764: x_return_status := FND_API.G_RET_STS_SUCCESS;

4760:
4761: BEGIN
4762:
4763: x_msg_count := 0;
4764: x_return_status := FND_API.G_RET_STS_SUCCESS;
4765: IF P_PA_DEBUG_MODE = 'Y' THEN
4766: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');
4767: END IF;
4768: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 5182: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5178: ,x_return_status => l_return_status
5179: ,x_msg_count => l_msg_count
5180: ,x_msg_data => l_msg_data);
5181:
5182: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5183: IF P_PA_debug_mode = 'Y' THEN
5184: pa_debug.g_err_stage:= 'Error in PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts';
5185: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
5186: END IF;

Line 5209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5205: x_return_status => l_return_status,
5206: x_msg_count => l_msg_count,
5207: x_msg_data => l_msg_data);
5208:
5209: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5210: IF P_PA_debug_mode = 'Y' THEN
5211: pa_debug.g_err_stage:= 'Error in derv_missing_amts_chk_neg_qty';
5212: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
5213: END IF;

Line 5231: (p_encoded => FND_API.G_TRUE

5227: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5228: l_msg_count := FND_MSG_PUB.count_msg;
5229: IF l_msg_count = 1 THEN
5230: PA_INTERFACE_UTILS_PUB.get_messages
5231: (p_encoded => FND_API.G_TRUE
5232: ,p_msg_index => 1
5233: ,p_msg_count => l_msg_count
5234: ,p_msg_data => l_msg_data
5235: ,p_data => l_data

Line 5242: x_return_status := FND_API.G_RET_STS_ERROR;

5238: x_msg_count := l_msg_count;
5239: ELSE
5240: x_msg_count := l_msg_count;
5241: END IF;
5242: x_return_status := FND_API.G_RET_STS_ERROR;
5243:
5244: IF P_PA_DEBUG_MODE = 'Y' THEN
5245: pa_debug.g_err_stage:='Invalid arguments passed';
5246: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);

Line 5252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5248: END IF;
5249: RAISE;
5250:
5251: WHEN Others THEN
5252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5253: x_msg_count := 1;
5254: x_msg_data := SQLERRM;
5255: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
5256: ,p_procedure_name => 'COPY_BUDGET_LINES');

Line 5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5259: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
5260: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,6);
5261: pa_debug.reset_err_stack;
5262: END IF;
5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5264: END Copy_Budget_Lines;
5265:
5266: /*===========================================================================
5267: This api copies proj period denorm res_assignment records from source

Line 5295: x_return_status := FND_API.G_RET_STS_SUCCESS;

5291:
5292: BEGIN
5293:
5294: x_msg_count := 0;
5295: x_return_status := FND_API.G_RET_STS_SUCCESS;
5296: IF P_PA_DEBUG_MODE = 'Y' THEN
5297: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Periods_Denorm');
5298: END IF;
5299: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 5549: (p_encoded => FND_API.G_TRUE

5545: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5546: l_msg_count := FND_MSG_PUB.count_msg;
5547: IF l_msg_count = 1 THEN
5548: PA_INTERFACE_UTILS_PUB.get_messages
5549: (p_encoded => FND_API.G_TRUE
5550: ,p_msg_index => 1
5551: ,p_msg_count => l_msg_count
5552: ,p_msg_data => l_msg_data
5553: ,p_data => l_data

Line 5560: x_return_status := FND_API.G_RET_STS_ERROR;

5556: x_msg_count := l_msg_count;
5557: ELSE
5558: x_msg_count := l_msg_count;
5559: END IF;
5560: x_return_status := FND_API.G_RET_STS_ERROR;
5561:
5562: IF P_PA_DEBUG_MODE = 'Y' THEN
5563: pa_debug.g_err_stage:='Invalid arguments passed';
5564: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);

Line 5570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5566: END IF;
5567: RAISE;
5568:
5569: WHEN Others THEN
5570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5571: x_msg_count := 1;
5572: x_msg_data := SQLERRM;
5573: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
5574: ,p_procedure_name => 'Copy_Periods_Denorm');

Line 5581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5577: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
5578: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,6);
5579: pa_debug.reset_err_stack;
5580: END IF;
5581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5582:
5583: END Copy_Periods_Denorm;
5584:
5585:

Line 6092: x_return_status := FND_API.G_RET_STS_SUCCESS;

6088: BEGIN
6089:
6090: FND_MSG_PUB.INITIALIZE;
6091: x_msg_count := 0;
6092: x_return_status := FND_API.G_RET_STS_SUCCESS;
6093:
6094: IF P_PA_DEBUG_MODE = 'Y' THEN
6095: pa_debug.init_err_stack('PA_FP_COPY_FROM_PKG.Copy_Finplans_From_Project');
6096: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

Line 6233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6229: ,x_msg_data => l_msg_data );
6230:
6231: /* Added the following check for the NOCOPY changes. */
6232:
6233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6234: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6235: END IF;
6236:
6237: --Bug :- 2570874

Line 6416: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6412: ,x_return_status => l_return_status
6413: ,x_msg_count => l_msg_count
6414: ,x_msg_data => l_msg_data);
6415:
6416: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6417: IF P_PA_DEBUG_MODE = 'Y' THEN
6418: pa_debug.write(g_module_name,' Return status from copy RA api is ' || l_Return_Status,3);
6419: END IF;
6420: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 6440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6436: ,x_return_status => l_return_status
6437: ,x_msg_count => l_msg_count
6438: ,x_msg_data => l_msg_data );
6439:
6440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6441: IF P_PA_DEBUG_MODE = 'Y' THEN
6442: pa_debug.write(g_module_name,' Return status from copy bl api is ' || l_Return_Status,3);
6443: END IF;
6444: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 6462: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN -- Bug# 2634726

6458: ,x_return_status => l_return_status
6459: ,x_msg_count => l_msg_count
6460: ,x_msg_data => l_msg_data);
6461:
6462: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN -- Bug# 2634726
6463: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6464: END IF;
6465:
6466: -- Bug Fix: 4569365. Removed MRC code.

Line 6497: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6493:
6494: PA_MRC_FINPLAN.g_calling_module := NULL;
6495: END IF;
6496:
6497: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6498: RAISE g_mrc_exception;
6499: END IF;
6500: */
6501:

Line 6542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6538: X_RETURN_STATUS => l_return_status,
6539: X_MSG_COUNT => l_msg_count,
6540: X_MSG_DATA => l_msg_data);
6541:
6542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6543: IF P_PA_debug_mode = 'Y' THEN
6544: pa_debug.g_err_stage:= 'Error in PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DETAILS';
6545: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level5);
6546: END IF;

Line 6557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6553: p_context => 'FINANCIAL',
6554: p_use_temp_table_flag => 'N',
6555: x_return_status => l_return_status);
6556:
6557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6558: IF P_PA_debug_mode = 'Y' THEN
6559: pa_debug.g_err_stage:= 'Error in PA_BUDGET_LINES_UTILS.populate_display_qty';
6560: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level5);
6561: END IF;

Line 6606: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6602: x_return_status => l_return_status,
6603: x_msg_data => l_msg_count,
6604: x_msg_count => l_msg_data);
6605:
6606: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6607: IF P_PA_debug_mode = 'Y' THEN
6608: pa_debug.g_err_stage:= 'Error in PA_RES_ASG_CURRENCY_PUB.MAINTAIN_DATA while doing the rollup';
6609: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level5);
6610: END IF;

Line 6665: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

6661: p_copy_mode => l_copy_mode,
6662: x_return_status => l_return_status,
6663: x_msg_code => l_err_stack);
6664:
6665: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
6666: PA_UTILS.ADD_MESSAGE(p_app_short_name => PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
6667: p_msg_name => l_err_stack);
6668:
6669: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 6736: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6732: ,x_msg_count => l_msg_count
6733: ,x_msg_data => l_msg_data );
6734:
6735: /* Bug# 2647047 - Raise if return status is not success */
6736: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6737: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6738: END IF;
6739:
6740: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 6757: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6753: ,x_msg_count => l_msg_count
6754: ,x_msg_data => l_msg_data );
6755:
6756: /* Bug# 2647047 - Raise if return status is not success */
6757: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6758: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6759: END IF;
6760:
6761: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 6784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6780: -- Bug Fix: 4569365. Removed MRC code.
6781: -- PA_MRC_FINPLAN.G_CALLING_MODULE := NULL; /* MRC */
6782:
6783: /* Bug# 2647047 - Raise if return status is not success */
6784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6785: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6786: END IF;
6787:
6788: END IF;

Line 6811: (p_encoded => FND_API.G_TRUE

6807:
6808: l_msg_count := FND_MSG_PUB.count_msg;
6809: IF l_msg_count = 1 THEN
6810: PA_INTERFACE_UTILS_PUB.get_messages
6811: (p_encoded => FND_API.G_TRUE
6812: ,p_msg_index => 1
6813: ,p_msg_count => l_msg_count
6814: ,p_msg_data => l_msg_data
6815: ,p_data => l_data

Line 6828: x_return_status:= FND_API.G_RET_STS_ERROR;

6824: pa_debug.g_err_stage:='Invalid Arguments Passed';
6825: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
6826: pa_debug.reset_err_stack;
6827: END IF;
6828: x_return_status:= FND_API.G_RET_STS_ERROR;
6829: -- bug#2753123
6830: IF l_err_stage is NOT NULL THEN
6831: x_msg_data := l_err_stage ;
6832: END IF ;

Line 6841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6837: RETURN ;
6838:
6839: WHEN Others THEN
6840:
6841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6842: x_msg_count := 1;
6843: x_msg_data := SQLERRM;
6844: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
6845: ,p_procedure_name => 'Copy_Finplans_From_Project');

Line 6856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6852: -- Bug Fix: 4569365. Removed MRC code.
6853:
6854: -- bug 3163280 ROLLBACK TO COPY_PROJECT;
6855: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
6856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6857:
6858: END Copy_Finplans_From_Project;
6859:
6860:

Line 6908: x_return_status := FND_API.G_RET_STS_SUCCESS;

6904:
6905: BEGIN
6906:
6907: x_msg_count := 0;
6908: x_return_status := FND_API.G_RET_STS_SUCCESS;
6909:
6910: IF p_pa_debug_mode = 'Y' THEN
6911: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Fp_Options_To_Be_Copied');
6912: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

Line 7193: (p_encoded => FND_API.G_TRUE

7189: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7190: l_msg_count := FND_MSG_PUB.count_msg;
7191: IF l_msg_count = 1 THEN
7192: PA_INTERFACE_UTILS_PUB.get_messages
7193: (p_encoded => FND_API.G_TRUE
7194: ,p_msg_index => 1
7195: ,p_msg_count => l_msg_count
7196: ,p_msg_data => l_msg_data
7197: ,p_data => l_data

Line 7210: x_return_status:= FND_API.G_RET_STS_ERROR;

7206: pa_debug.g_err_stage:='Invalid Arguments Passed';
7207: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
7208: pa_debug.reset_err_stack;
7209: END IF;
7210: x_return_status:= FND_API.G_RET_STS_ERROR;
7211:
7212: RAISE;
7213:
7214: WHEN Others THEN

Line 7216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7212: RAISE;
7213:
7214: WHEN Others THEN
7215:
7216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7217: x_msg_count := 1;
7218: x_msg_data := SQLERRM;
7219: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
7220: ,p_procedure_name => 'Get_Fp_Options_To_Be_Copied');

Line 7227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7223: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
7224: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
7225: pa_debug.reset_err_stack;
7226: END IF;
7227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7228:
7229: END Get_Fp_Options_To_Be_Copied;
7230:
7231:

Line 7360: x_return_status := FND_API.G_RET_STS_SUCCESS;

7356:
7357: BEGIN
7358:
7359: x_msg_count := 0;
7360: x_return_status := FND_API.G_RET_STS_SUCCESS;
7361: IF P_PA_DEBUG_MODE = 'Y' THEN
7362: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');
7363: END IF;
7364: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 8126: (p_encoded => FND_API.G_TRUE

8122: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8123: l_msg_count := FND_MSG_PUB.count_msg;
8124: IF l_msg_count = 1 THEN
8125: PA_INTERFACE_UTILS_PUB.get_messages
8126: (p_encoded => FND_API.G_TRUE
8127: ,p_msg_index => 1
8128: ,p_msg_count => l_msg_count
8129: ,p_msg_data => l_msg_data
8130: ,p_data => l_data

Line 8139: x_return_status := FND_API.G_RET_STS_ERROR;

8135: ELSE
8136: x_msg_count := l_msg_count;
8137: END IF;
8138:
8139: x_return_status := FND_API.G_RET_STS_ERROR;
8140: IF P_PA_DEBUG_MODE = 'Y' THEN
8141: pa_debug.g_err_stage:='Invalid arguments passed';
8142: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
8143: pa_debug.reset_err_stack;

Line 8149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8145: RAISE;
8146:
8147: WHEN Others THEN
8148:
8149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8150: x_msg_count := 1;
8151: x_msg_data := SQLERRM;
8152: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
8153: ,p_procedure_name => 'COPY_BUDGET_LINES');

Line 8198: x_return_status := FND_API.G_RET_STS_SUCCESS;

8194:
8195: BEGIN
8196:
8197: x_msg_count := 0;
8198: x_return_status := FND_API.G_RET_STS_SUCCESS;
8199:
8200: IF p_pa_debug_mode = 'Y' THEN
8201: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Current_Period_Profiles');
8202: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

Line 8245: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8241: ,x_return_status => l_return_status
8242: ,x_msg_count => l_msg_count
8243: ,x_msg_data => l_msg_data );
8244:
8245: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8246: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8247: END IF;
8248:
8249: END LOOP;

Line 8262: x_return_status := FND_API.G_RET_STS_ERROR;

8258: EXCEPTION
8259:
8260: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8261:
8262: x_return_status := FND_API.G_RET_STS_ERROR;
8263: l_msg_count := FND_MSG_PUB.count_msg;
8264: IF l_msg_count = 1 THEN
8265: PA_INTERFACE_UTILS_PUB.get_messages
8266: (p_encoded => FND_API.G_TRUE

Line 8266: (p_encoded => FND_API.G_TRUE

8262: x_return_status := FND_API.G_RET_STS_ERROR;
8263: l_msg_count := FND_MSG_PUB.count_msg;
8264: IF l_msg_count = 1 THEN
8265: PA_INTERFACE_UTILS_PUB.get_messages
8266: (p_encoded => FND_API.G_TRUE
8267: ,p_msg_index => 1
8268: ,p_msg_count => l_msg_count
8269: ,p_msg_data => l_msg_data
8270: ,p_data => l_data

Line 8284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8280: RAISE;
8281:
8282: WHEN others THEN
8283:
8284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8285: x_msg_count := 1;
8286: x_msg_data := SQLERRM;
8287: FND_MSG_PUB.add_exc_msg
8288: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

Line 8383: x_return_status := FND_API.G_RET_STS_SUCCESS;

8379:
8380: BEGIN
8381:
8382: x_msg_count := 0;
8383: x_return_status := FND_API.G_RET_STS_SUCCESS;
8384: IF P_PA_DEBUG_MODE = 'Y' THEN
8385: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Create_Shifted_PD_Profile');
8386: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
8387: END IF;

Line 8681: x_return_status := FND_API.G_RET_STS_ERROR;

8677: EXCEPTION
8678:
8679: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8680:
8681: x_return_status := FND_API.G_RET_STS_ERROR;
8682: l_msg_count := FND_MSG_PUB.count_msg;
8683: IF l_msg_count = 1 THEN
8684: PA_INTERFACE_UTILS_PUB.get_messages
8685: (p_encoded => FND_API.G_TRUE

Line 8685: (p_encoded => FND_API.G_TRUE

8681: x_return_status := FND_API.G_RET_STS_ERROR;
8682: l_msg_count := FND_MSG_PUB.count_msg;
8683: IF l_msg_count = 1 THEN
8684: PA_INTERFACE_UTILS_PUB.get_messages
8685: (p_encoded => FND_API.G_TRUE
8686: ,p_msg_index => 1
8687: ,p_msg_count => l_msg_count
8688: ,p_msg_data => l_msg_data
8689: ,p_data => l_data

Line 8703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8699: RAISE;
8700:
8701: WHEN others THEN
8702:
8703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8704: x_msg_count := 1;
8705: x_msg_data := SQLERRM;
8706: FND_MSG_PUB.add_exc_msg
8707: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

Line 8826: x_return_status := FND_API.G_RET_STS_SUCCESS;

8822: AND pra.task_id=spe.proj_element_id);
8823:
8824: BEGIN
8825: x_msg_count := 0;
8826: x_return_status := FND_API.G_RET_STS_SUCCESS;
8827: SAVEPOINT copy_wp_budget_versions;
8828:
8829: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
8830: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 8914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8910: ,x_return_status => x_return_status
8911: ,x_msg_count => x_msg_count
8912: ,x_msg_data => x_msg_data );
8913:
8914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8915:
8916: IF l_debug_mode = 'Y' THEN
8917: pa_debug.g_err_stage:='pa_fp_planning_transaction_pub.add_wp_plan_type returned error';
8918: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 8990: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8986: ,x_return_status => x_return_status
8987: ,x_msg_count => x_msg_count
8988: ,x_msg_data => x_msg_data);
8989:
8990: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8991:
8992: IF l_debug_mode = 'Y' THEN
8993: pa_debug.g_err_stage:='Copy Budget version returned error';
8994: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9038: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9034: ,x_return_status => x_return_status
9035: ,x_msg_count => x_msg_count
9036: ,x_msg_data => x_msg_data);
9037:
9038: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9039:
9040: IF l_debug_mode = 'Y' THEN
9041: pa_debug.g_err_stage:='Create_Fp_Option returned error';
9042: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9069: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9065: ,x_return_status => x_return_status
9066: ,x_msg_count => x_msg_count
9067: ,x_msg_data => x_msg_data);
9068:
9069: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9070:
9071: IF l_debug_mode = 'Y' THEN
9072: pa_debug.g_err_stage:='Copy_Fp_Txn_Currencies returned error';
9073: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

9111: x_return_status => l_return_status,
9112: x_msg_code => l_msg_data);
9113: END IF;
9114:
9115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
9116: PA_UTILS.ADD_MESSAGE(p_app_short_name => PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
9117: p_msg_name => l_msg_data);
9118: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
9119: END IF;

Line 9163: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9159: ,x_return_status => x_return_status
9160: ,x_msg_count => x_msg_count
9161: ,x_msg_data => x_msg_data);
9162:
9163: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9164:
9165: IF l_debug_mode = 'Y' THEN
9166: pa_debug.g_err_stage:='Copy_Fp_Txn_Currencies returned error';
9167: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9185: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9181: ,x_return_status => x_return_status
9182: ,x_msg_count => x_msg_count
9183: ,x_msg_data => x_msg_data);
9184:
9185: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9186:
9187: IF l_debug_mode = 'Y' THEN
9188: pa_debug.g_err_stage:='Update_Plan_Setup_For_WP_Copy returned error';
9189: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9218: RAISE FND_API.G_EXC_ERROR;

9214: IF l_debug_mode = 'Y' THEN
9215: pa_debug.g_err_stage:='PA_TASK_ASSIGNMENTS_PVT.Copy_Missing_Unplanned_Asgmts returned error';
9216: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
9217: END IF;
9218: RAISE FND_API.G_EXC_ERROR;
9219: END;
9220: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9221: RAISE FND_API.G_EXC_ERROR;
9222: END IF;

Line 9220: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9216: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
9217: END IF;
9218: RAISE FND_API.G_EXC_ERROR;
9219: END;
9220: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9221: RAISE FND_API.G_EXC_ERROR;
9222: END IF;
9223: -- End bug 3850488.
9224:

Line 9221: RAISE FND_API.G_EXC_ERROR;

9217: END IF;
9218: RAISE FND_API.G_EXC_ERROR;
9219: END;
9220: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9221: RAISE FND_API.G_EXC_ERROR;
9222: END IF;
9223: -- End bug 3850488.
9224:
9225: -- Call copy_actuals_for_workplan

Line 9234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9230: ,x_return_status => x_return_status
9231: ,x_msg_count => x_msg_count
9232: ,x_msg_data => x_msg_data);
9233:
9234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9235:
9236: IF l_debug_mode = 'Y' THEN
9237: pa_debug.g_err_stage:='Update_Plan_Setup_For_WP_Copy returned error';
9238: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9251: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9247: ,x_return_status => x_return_status
9248: ,x_msg_data => x_msg_data
9249: ,x_msg_count => x_msg_count);
9250:
9251: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9252:
9253: IF l_debug_mode = 'Y' THEN
9254: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';
9255: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);

Line 9275: (p_encoded => FND_API.G_TRUE

9271: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9272: l_msg_count := FND_MSG_PUB.count_msg;
9273: IF l_msg_count = 1 THEN
9274: PA_INTERFACE_UTILS_PUB.get_messages
9275: (p_encoded => FND_API.G_TRUE
9276: ,p_msg_index => 1
9277: ,p_msg_count => l_msg_count
9278: ,p_msg_data => l_msg_data
9279: ,p_data => l_data

Line 9288: x_return_status := FND_API.G_RET_STS_ERROR;

9284: ELSE
9285: x_msg_count := l_msg_count;
9286: END IF;
9287: ROLLBACK TO copy_wp_budget_versions;
9288: x_return_status := FND_API.G_RET_STS_ERROR;
9289:
9290: IF l_debug_mode = 'Y' THEN
9291: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
9292: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9295: END IF;
9296: RETURN;
9297: WHEN OTHERS THEN
9298: ROLLBACK TO copy_wp_budget_versions;
9299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9300: x_msg_count := 1;
9301: x_msg_data := SQLERRM;
9302:
9303: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

Line 9510: x_return_status := FND_API.G_RET_STS_SUCCESS;

9506:
9507: BEGIN
9508:
9509: x_msg_count := 0;
9510: x_return_status := FND_API.G_RET_STS_SUCCESS;
9511: IF P_PA_DEBUG_MODE = 'Y' THEN
9512: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines_Appr_Rev');
9513: END IF;
9514: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 9982: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9978: ,x_return_status => l_return_status
9979: ,x_msg_count => l_msg_count
9980: ,x_msg_data => l_msg_data);
9981:
9982: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9983: IF P_PA_debug_mode = 'Y' THEN
9984: pa_debug.g_err_stage:= 'Error in PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts';
9985: pa_debug.write('Copy_Budget_Lines_Appr_Rev: ' || g_module_name,pa_debug.g_err_stage,5);
9986: END IF;

Line 10009: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10005: x_return_status => l_return_status,
10006: x_msg_count => l_msg_count,
10007: x_msg_data => l_msg_data);
10008:
10009: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10010: IF P_PA_debug_mode = 'Y' THEN
10011: pa_debug.g_err_stage:= 'Error in derv_missing_amts_chk_neg_qty';
10012: pa_debug.write('Copy_Budget_Lines_Appr_Rev: ' || g_module_name,pa_debug.g_err_stage,5);
10013: END IF;

Line 10031: (p_encoded => FND_API.G_TRUE

10027: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10028: l_msg_count := FND_MSG_PUB.count_msg;
10029: IF l_msg_count = 1 THEN
10030: PA_INTERFACE_UTILS_PUB.get_messages
10031: (p_encoded => FND_API.G_TRUE
10032: ,p_msg_index => 1
10033: ,p_msg_count => l_msg_count
10034: ,p_msg_data => l_msg_data
10035: ,p_data => l_data

Line 10042: x_return_status := FND_API.G_RET_STS_ERROR;

10038: x_msg_count := l_msg_count;
10039: ELSE
10040: x_msg_count := l_msg_count;
10041: END IF;
10042: x_return_status := FND_API.G_RET_STS_ERROR;
10043:
10044: IF P_PA_DEBUG_MODE = 'Y' THEN
10045: pa_debug.g_err_stage:='Invalid arguments passed';
10046: pa_debug.write('Copy_Budget_Lines_Appr_Rev: ' || g_module_name,pa_debug.g_err_stage,5);

Line 10052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10048: END IF;
10049: RAISE;
10050:
10051: WHEN Others THEN
10052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10053: x_msg_count := 1;
10054: x_msg_data := SQLERRM;
10055: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
10056: ,p_procedure_name => 'COPY_BUDGET_LINES_APPR_REV');

Line 10063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10059: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
10060: pa_debug.write('Copy_Budget_Lines_Appr_Rev: ' || g_module_name,pa_debug.g_err_stage,6);
10061: pa_debug.reset_err_stack;
10062: END IF;
10063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10064: END Copy_Budget_Lines_Appr_Rev;
10065:
10066: /*=============================================================================
10067: Bug 3619687: PJ.M:B5:BF:DEV:TRACKING BUG FOR PLAN SETTINGS CHANGE REQUEST

Line 10179: x_return_status := FND_API.G_RET_STS_SUCCESS;

10175:
10176: BEGIN
10177:
10178: x_msg_count := 0;
10179: x_return_status := FND_API.G_RET_STS_SUCCESS;
10180:
10181: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
10182: l_debug_mode := NVL(l_debug_mode, 'Y');
10183:

Line 10304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10300: ,x_return_status => x_return_status
10301: ,x_msg_count => x_msg_count
10302: ,x_msg_data => x_msg_data );
10303:
10304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10305: IF l_debug_mode = 'Y' THEN
10306: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies
10307: api returned error';
10308: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);

Line 10327: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10323: ,x_return_status => x_return_status
10324: ,x_msg_count => x_msg_count
10325: ,x_msg_data => x_msg_data);
10326:
10327: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10328: IF l_debug_mode = 'Y' THEN
10329: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids
10330: api returned error';
10331: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);

Line 10375: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10371: ,x_msg_count => x_msg_count
10372: ,x_msg_data => x_msg_data);
10373:
10374: -- Bug 3579153 Check return status
10375: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10376: IF l_debug_mode = 'Y' THEN
10377: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api returned error';
10378: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);
10379: END IF;

Line 10437: (p_encoded => FND_API.G_TRUE

10433: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10434: l_msg_count := FND_MSG_PUB.count_msg;
10435: IF l_msg_count = 1 THEN
10436: PA_INTERFACE_UTILS_PUB.get_messages
10437: (p_encoded => FND_API.G_TRUE
10438: ,p_msg_index => 1
10439: ,p_msg_count => l_msg_count
10440: ,p_msg_data => l_msg_data
10441: ,p_data => l_data

Line 10450: x_return_status := FND_API.G_RET_STS_ERROR;

10446: ELSE
10447: x_msg_count := l_msg_count;
10448: END IF;
10449:
10450: x_return_status := FND_API.G_RET_STS_ERROR;
10451:
10452: IF l_debug_mode = 'Y' THEN
10453: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
10454: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);

Line 10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10456: pa_debug.reset_curr_function();
10457: END IF;
10458: RETURN;
10459: WHEN Others THEN
10460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10461: x_msg_count := 1;
10462: x_msg_data := SQLERRM;
10463:
10464: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'