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.

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 4040: (p_encoded => FND_API.G_TRUE

4036: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4037: l_msg_count := FND_MSG_PUB.count_msg;
4038: IF l_msg_count = 1 THEN
4039: PA_INTERFACE_UTILS_PUB.get_messages
4040: (p_encoded => FND_API.G_TRUE
4041: ,p_msg_index => 1
4042: ,p_msg_count => l_msg_count
4043: ,p_msg_data => l_msg_data
4044: ,p_data => l_data

Line 4051: x_return_status := FND_API.G_RET_STS_ERROR;

4047: x_msg_count := l_msg_count;
4048: ELSE
4049: x_msg_count := l_msg_count;
4050: END IF;
4051: x_return_status := FND_API.G_RET_STS_ERROR;
4052:
4053: IF P_PA_DEBUG_MODE = 'Y' THEN
4054: pa_debug.g_err_stage:='Invalid Arguments Passed';
4055: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,5);

Line 4061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4057: END IF;
4058: RAISE;
4059:
4060: WHEN Others THEN
4061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4062: x_msg_count := 1;
4063: x_msg_data := SQLERRM;
4064: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
4065: ,p_procedure_name => 'COPY_RESOURCE_ASSIGNMENTS');

Line 4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4068: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
4069: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,5);
4070: pa_debug.reset_err_stack;
4071: END IF;
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073:
4074: END Copy_Resource_Assignments;
4075:
4076: --Bug 4290043.This private API will be called from copy_budget_lines and Copy_Budget_Lines_Appr_Rev in this package

Line 4135: x_return_status := FND_API.G_RET_STS_SUCCESS;

4131:
4132: BEGIN
4133:
4134: x_msg_count := 0;
4135: x_return_status := FND_API.G_RET_STS_SUCCESS;
4136:
4137: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4138: l_debug_mode := NVL(l_debug_mode, 'Y');
4139: l_module_name := 'PAFPCPFB.mis_amts_chk_neg_qty';

Line 4267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4263: ,x_return_status => l_return_status
4264: ,x_msg_count => l_msg_count
4265: ,x_msg_data => l_msg_data);
4266:
4267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4268: IF l_debug_mode = 'Y' THEN
4269: pa_debug.g_err_stage:= 'Error in pa_fp_upgrade_pkg.Apply_Calculate_FPM_Rules';
4270: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
4271: END IF;

Line 4339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4335: ,x_return_status => l_return_status
4336: ,x_msg_count => l_msg_count
4337: ,x_msg_data => l_msg_data);
4338:
4339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4340: IF l_debug_mode = 'Y' THEN
4341: pa_debug.g_err_stage:= 'Error in PA_FP_CALC_PLAN_PKG.CheckZeroQTyNegETC';
4342: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
4343: END IF;

Line 4636: (p_encoded => FND_API.G_TRUE

4632: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4633: l_msg_count := FND_MSG_PUB.count_msg;
4634: IF l_msg_count = 1 THEN
4635: PA_INTERFACE_UTILS_PUB.get_messages
4636: (p_encoded => FND_API.G_TRUE
4637: ,p_msg_index => 1
4638: ,p_msg_count => l_msg_count
4639: ,p_msg_data => l_msg_data
4640: ,p_data => l_data

Line 4648: x_return_status := FND_API.G_RET_STS_ERROR;

4644: x_msg_count := l_msg_count;
4645: ELSE
4646: x_msg_count := l_msg_count;
4647: END IF;
4648: x_return_status := FND_API.G_RET_STS_ERROR;
4649:
4650: IF l_debug_mode = 'Y' THEN
4651: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
4652: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);

Line 4658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4654: pa_debug.reset_curr_function();
4655: END IF;
4656: RETURN;
4657: WHEN OTHERS THEN
4658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4659: x_msg_count := 1;
4660: x_msg_data := SQLERRM;
4661:
4662: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

Line 4752: x_return_status := FND_API.G_RET_STS_SUCCESS;

4748:
4749: BEGIN
4750:
4751: x_msg_count := 0;
4752: x_return_status := FND_API.G_RET_STS_SUCCESS;
4753: IF P_PA_DEBUG_MODE = 'Y' THEN
4754: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');
4755: END IF;
4756: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 5170: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5166: ,x_return_status => l_return_status
5167: ,x_msg_count => l_msg_count
5168: ,x_msg_data => l_msg_data);
5169:
5170: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5171: IF P_PA_debug_mode = 'Y' THEN
5172: pa_debug.g_err_stage:= 'Error in PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts';
5173: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
5174: END IF;

Line 5197: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5193: x_return_status => l_return_status,
5194: x_msg_count => l_msg_count,
5195: x_msg_data => l_msg_data);
5196:
5197: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5198: IF P_PA_debug_mode = 'Y' THEN
5199: pa_debug.g_err_stage:= 'Error in derv_missing_amts_chk_neg_qty';
5200: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
5201: END IF;

Line 5219: (p_encoded => FND_API.G_TRUE

5215: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5216: l_msg_count := FND_MSG_PUB.count_msg;
5217: IF l_msg_count = 1 THEN
5218: PA_INTERFACE_UTILS_PUB.get_messages
5219: (p_encoded => FND_API.G_TRUE
5220: ,p_msg_index => 1
5221: ,p_msg_count => l_msg_count
5222: ,p_msg_data => l_msg_data
5223: ,p_data => l_data

Line 5230: x_return_status := FND_API.G_RET_STS_ERROR;

5226: x_msg_count := l_msg_count;
5227: ELSE
5228: x_msg_count := l_msg_count;
5229: END IF;
5230: x_return_status := FND_API.G_RET_STS_ERROR;
5231:
5232: IF P_PA_DEBUG_MODE = 'Y' THEN
5233: pa_debug.g_err_stage:='Invalid arguments passed';
5234: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);

Line 5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5236: END IF;
5237: RAISE;
5238:
5239: WHEN Others THEN
5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5241: x_msg_count := 1;
5242: x_msg_data := SQLERRM;
5243: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
5244: ,p_procedure_name => 'COPY_BUDGET_LINES');

Line 5251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5247: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
5248: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,6);
5249: pa_debug.reset_err_stack;
5250: END IF;
5251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5252: END Copy_Budget_Lines;
5253:
5254: /*===========================================================================
5255: This api copies proj period denorm res_assignment records from source

Line 5283: x_return_status := FND_API.G_RET_STS_SUCCESS;

5279:
5280: BEGIN
5281:
5282: x_msg_count := 0;
5283: x_return_status := FND_API.G_RET_STS_SUCCESS;
5284: IF P_PA_DEBUG_MODE = 'Y' THEN
5285: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Periods_Denorm');
5286: END IF;
5287: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 5537: (p_encoded => FND_API.G_TRUE

5533: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5534: l_msg_count := FND_MSG_PUB.count_msg;
5535: IF l_msg_count = 1 THEN
5536: PA_INTERFACE_UTILS_PUB.get_messages
5537: (p_encoded => FND_API.G_TRUE
5538: ,p_msg_index => 1
5539: ,p_msg_count => l_msg_count
5540: ,p_msg_data => l_msg_data
5541: ,p_data => l_data

Line 5548: x_return_status := FND_API.G_RET_STS_ERROR;

5544: x_msg_count := l_msg_count;
5545: ELSE
5546: x_msg_count := l_msg_count;
5547: END IF;
5548: x_return_status := FND_API.G_RET_STS_ERROR;
5549:
5550: IF P_PA_DEBUG_MODE = 'Y' THEN
5551: pa_debug.g_err_stage:='Invalid arguments passed';
5552: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);

Line 5558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5554: END IF;
5555: RAISE;
5556:
5557: WHEN Others THEN
5558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5559: x_msg_count := 1;
5560: x_msg_data := SQLERRM;
5561: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
5562: ,p_procedure_name => 'Copy_Periods_Denorm');

Line 5569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5565: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
5566: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,6);
5567: pa_debug.reset_err_stack;
5568: END IF;
5569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5570:
5571: END Copy_Periods_Denorm;
5572:
5573:

Line 6079: x_return_status := FND_API.G_RET_STS_SUCCESS;

6075: BEGIN
6076:
6077: FND_MSG_PUB.INITIALIZE;
6078: x_msg_count := 0;
6079: x_return_status := FND_API.G_RET_STS_SUCCESS;
6080:
6081: IF P_PA_DEBUG_MODE = 'Y' THEN
6082: pa_debug.init_err_stack('PA_FP_COPY_FROM_PKG.Copy_Finplans_From_Project');
6083: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

Line 6220: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6216: ,x_msg_data => l_msg_data );
6217:
6218: /* Added the following check for the NOCOPY changes. */
6219:
6220: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6221: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6222: END IF;
6223:
6224: --Bug :- 2570874

Line 6399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6395: ,x_return_status => l_return_status
6396: ,x_msg_count => l_msg_count
6397: ,x_msg_data => l_msg_data);
6398:
6399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6400: IF P_PA_DEBUG_MODE = 'Y' THEN
6401: pa_debug.write(g_module_name,' Return status from copy RA api is ' || l_Return_Status,3);
6402: END IF;
6403: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 6423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6419: ,x_return_status => l_return_status
6420: ,x_msg_count => l_msg_count
6421: ,x_msg_data => l_msg_data );
6422:
6423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6424: IF P_PA_DEBUG_MODE = 'Y' THEN
6425: pa_debug.write(g_module_name,' Return status from copy bl api is ' || l_Return_Status,3);
6426: END IF;
6427: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

6441: ,x_return_status => l_return_status
6442: ,x_msg_count => l_msg_count
6443: ,x_msg_data => l_msg_data);
6444:
6445: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN -- Bug# 2634726
6446: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6447: END IF;
6448:
6449: -- Bug Fix: 4569365. Removed MRC code.

Line 6480: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6476:
6477: PA_MRC_FINPLAN.g_calling_module := NULL;
6478: END IF;
6479:
6480: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6481: RAISE g_mrc_exception;
6482: END IF;
6483: */
6484:

Line 6525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6521: X_RETURN_STATUS => l_return_status,
6522: X_MSG_COUNT => l_msg_count,
6523: X_MSG_DATA => l_msg_data);
6524:
6525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6526: IF P_PA_debug_mode = 'Y' THEN
6527: pa_debug.g_err_stage:= 'Error in PA_FP_GEN_AMOUNT_UTILS.GET_PLAN_VERSION_DETAILS';
6528: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level5);
6529: END IF;

Line 6540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6536: p_context => 'FINANCIAL',
6537: p_use_temp_table_flag => 'N',
6538: x_return_status => l_return_status);
6539:
6540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6541: IF P_PA_debug_mode = 'Y' THEN
6542: pa_debug.g_err_stage:= 'Error in PA_BUDGET_LINES_UTILS.populate_display_qty';
6543: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level5);
6544: END IF;

Line 6589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6585: x_return_status => l_return_status,
6586: x_msg_data => l_msg_count,
6587: x_msg_count => l_msg_data);
6588:
6589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6590: IF P_PA_debug_mode = 'Y' THEN
6591: pa_debug.g_err_stage:= 'Error in PA_RES_ASG_CURRENCY_PUB.MAINTAIN_DATA while doing the rollup';
6592: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level5);
6593: END IF;

Line 6648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

6644: p_copy_mode => l_copy_mode,
6645: x_return_status => l_return_status,
6646: x_msg_code => l_err_stack);
6647:
6648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
6649: PA_UTILS.ADD_MESSAGE(p_app_short_name => PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
6650: p_msg_name => l_err_stack);
6651:
6652: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 6719: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6715: ,x_msg_count => l_msg_count
6716: ,x_msg_data => l_msg_data );
6717:
6718: /* Bug# 2647047 - Raise if return status is not success */
6719: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6720: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6721: END IF;
6722:
6723: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 6740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 6767: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6763: -- Bug Fix: 4569365. Removed MRC code.
6764: -- PA_MRC_FINPLAN.G_CALLING_MODULE := NULL; /* MRC */
6765:
6766: /* Bug# 2647047 - Raise if return status is not success */
6767: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6768: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6769: END IF;
6770:
6771: END IF;

Line 6794: (p_encoded => FND_API.G_TRUE

6790:
6791: l_msg_count := FND_MSG_PUB.count_msg;
6792: IF l_msg_count = 1 THEN
6793: PA_INTERFACE_UTILS_PUB.get_messages
6794: (p_encoded => FND_API.G_TRUE
6795: ,p_msg_index => 1
6796: ,p_msg_count => l_msg_count
6797: ,p_msg_data => l_msg_data
6798: ,p_data => l_data

Line 6811: x_return_status:= FND_API.G_RET_STS_ERROR;

6807: pa_debug.g_err_stage:='Invalid Arguments Passed';
6808: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
6809: pa_debug.reset_err_stack;
6810: END IF;
6811: x_return_status:= FND_API.G_RET_STS_ERROR;
6812: -- bug#2753123
6813: IF l_err_stage is NOT NULL THEN
6814: x_msg_data := l_err_stage ;
6815: END IF ;

Line 6824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6820: RETURN ;
6821:
6822: WHEN Others THEN
6823:
6824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6825: x_msg_count := 1;
6826: x_msg_data := SQLERRM;
6827: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
6828: ,p_procedure_name => 'Copy_Finplans_From_Project');

Line 6839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6835: -- Bug Fix: 4569365. Removed MRC code.
6836:
6837: -- bug 3163280 ROLLBACK TO COPY_PROJECT;
6838: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
6839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6840:
6841: END Copy_Finplans_From_Project;
6842:
6843:

Line 6891: x_return_status := FND_API.G_RET_STS_SUCCESS;

6887:
6888: BEGIN
6889:
6890: x_msg_count := 0;
6891: x_return_status := FND_API.G_RET_STS_SUCCESS;
6892:
6893: IF p_pa_debug_mode = 'Y' THEN
6894: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Fp_Options_To_Be_Copied');
6895: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

Line 7176: (p_encoded => FND_API.G_TRUE

7172: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7173: l_msg_count := FND_MSG_PUB.count_msg;
7174: IF l_msg_count = 1 THEN
7175: PA_INTERFACE_UTILS_PUB.get_messages
7176: (p_encoded => FND_API.G_TRUE
7177: ,p_msg_index => 1
7178: ,p_msg_count => l_msg_count
7179: ,p_msg_data => l_msg_data
7180: ,p_data => l_data

Line 7193: x_return_status:= FND_API.G_RET_STS_ERROR;

7189: pa_debug.g_err_stage:='Invalid Arguments Passed';
7190: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
7191: pa_debug.reset_err_stack;
7192: END IF;
7193: x_return_status:= FND_API.G_RET_STS_ERROR;
7194:
7195: RAISE;
7196:
7197: WHEN Others THEN

Line 7199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7195: RAISE;
7196:
7197: WHEN Others THEN
7198:
7199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7200: x_msg_count := 1;
7201: x_msg_data := SQLERRM;
7202: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
7203: ,p_procedure_name => 'Get_Fp_Options_To_Be_Copied');

Line 7210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7206: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
7207: pa_debug.write( g_module_name,pa_debug.g_err_stage,5);
7208: pa_debug.reset_err_stack;
7209: END IF;
7210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7211:
7212: END Get_Fp_Options_To_Be_Copied;
7213:
7214:

Line 7341: x_return_status := FND_API.G_RET_STS_SUCCESS;

7337:
7338: BEGIN
7339:
7340: x_msg_count := 0;
7341: x_return_status := FND_API.G_RET_STS_SUCCESS;
7342: IF P_PA_DEBUG_MODE = 'Y' THEN
7343: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines');
7344: END IF;
7345: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 8099: (p_encoded => FND_API.G_TRUE

8095: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8096: l_msg_count := FND_MSG_PUB.count_msg;
8097: IF l_msg_count = 1 THEN
8098: PA_INTERFACE_UTILS_PUB.get_messages
8099: (p_encoded => FND_API.G_TRUE
8100: ,p_msg_index => 1
8101: ,p_msg_count => l_msg_count
8102: ,p_msg_data => l_msg_data
8103: ,p_data => l_data

Line 8112: x_return_status := FND_API.G_RET_STS_ERROR;

8108: ELSE
8109: x_msg_count := l_msg_count;
8110: END IF;
8111:
8112: x_return_status := FND_API.G_RET_STS_ERROR;
8113: IF P_PA_DEBUG_MODE = 'Y' THEN
8114: pa_debug.g_err_stage:='Invalid arguments passed';
8115: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
8116: pa_debug.reset_err_stack;

Line 8122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8118: RAISE;
8119:
8120: WHEN Others THEN
8121:
8122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8123: x_msg_count := 1;
8124: x_msg_data := SQLERRM;
8125: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
8126: ,p_procedure_name => 'COPY_BUDGET_LINES');

Line 8171: x_return_status := FND_API.G_RET_STS_SUCCESS;

8167:
8168: BEGIN
8169:
8170: x_msg_count := 0;
8171: x_return_status := FND_API.G_RET_STS_SUCCESS;
8172:
8173: IF p_pa_debug_mode = 'Y' THEN
8174: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Current_Period_Profiles');
8175: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

Line 8218: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8214: ,x_return_status => l_return_status
8215: ,x_msg_count => l_msg_count
8216: ,x_msg_data => l_msg_data );
8217:
8218: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8219: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8220: END IF;
8221:
8222: END LOOP;

Line 8235: x_return_status := FND_API.G_RET_STS_ERROR;

8231: EXCEPTION
8232:
8233: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8234:
8235: x_return_status := FND_API.G_RET_STS_ERROR;
8236: l_msg_count := FND_MSG_PUB.count_msg;
8237: IF l_msg_count = 1 THEN
8238: PA_INTERFACE_UTILS_PUB.get_messages
8239: (p_encoded => FND_API.G_TRUE

Line 8239: (p_encoded => FND_API.G_TRUE

8235: x_return_status := FND_API.G_RET_STS_ERROR;
8236: l_msg_count := FND_MSG_PUB.count_msg;
8237: IF l_msg_count = 1 THEN
8238: PA_INTERFACE_UTILS_PUB.get_messages
8239: (p_encoded => FND_API.G_TRUE
8240: ,p_msg_index => 1
8241: ,p_msg_count => l_msg_count
8242: ,p_msg_data => l_msg_data
8243: ,p_data => l_data

Line 8257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8253: RAISE;
8254:
8255: WHEN others THEN
8256:
8257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8258: x_msg_count := 1;
8259: x_msg_data := SQLERRM;
8260: FND_MSG_PUB.add_exc_msg
8261: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

Line 8356: x_return_status := FND_API.G_RET_STS_SUCCESS;

8352:
8353: BEGIN
8354:
8355: x_msg_count := 0;
8356: x_return_status := FND_API.G_RET_STS_SUCCESS;
8357: IF P_PA_DEBUG_MODE = 'Y' THEN
8358: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Get_Create_Shifted_PD_Profile');
8359: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);
8360: END IF;

Line 8654: x_return_status := FND_API.G_RET_STS_ERROR;

8650: EXCEPTION
8651:
8652: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8653:
8654: x_return_status := FND_API.G_RET_STS_ERROR;
8655: l_msg_count := FND_MSG_PUB.count_msg;
8656: IF l_msg_count = 1 THEN
8657: PA_INTERFACE_UTILS_PUB.get_messages
8658: (p_encoded => FND_API.G_TRUE

Line 8658: (p_encoded => FND_API.G_TRUE

8654: x_return_status := FND_API.G_RET_STS_ERROR;
8655: l_msg_count := FND_MSG_PUB.count_msg;
8656: IF l_msg_count = 1 THEN
8657: PA_INTERFACE_UTILS_PUB.get_messages
8658: (p_encoded => FND_API.G_TRUE
8659: ,p_msg_index => 1
8660: ,p_msg_count => l_msg_count
8661: ,p_msg_data => l_msg_data
8662: ,p_data => l_data

Line 8676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8672: RAISE;
8673:
8674: WHEN others THEN
8675:
8676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8677: x_msg_count := 1;
8678: x_msg_data := SQLERRM;
8679: FND_MSG_PUB.add_exc_msg
8680: ( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

Line 8799: x_return_status := FND_API.G_RET_STS_SUCCESS;

8795: AND pra.task_id=spe.proj_element_id);
8796:
8797: BEGIN
8798: x_msg_count := 0;
8799: x_return_status := FND_API.G_RET_STS_SUCCESS;
8800: SAVEPOINT copy_wp_budget_versions;
8801:
8802: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
8803: l_debug_mode := NVL(l_debug_mode, 'Y');

Line 8887: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8883: ,x_return_status => x_return_status
8884: ,x_msg_count => x_msg_count
8885: ,x_msg_data => x_msg_data );
8886:
8887: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8888:
8889: IF l_debug_mode = 'Y' THEN
8890: pa_debug.g_err_stage:='pa_fp_planning_transaction_pub.add_wp_plan_type returned error';
8891: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 8963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8959: ,x_return_status => x_return_status
8960: ,x_msg_count => x_msg_count
8961: ,x_msg_data => x_msg_data);
8962:
8963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8964:
8965: IF l_debug_mode = 'Y' THEN
8966: pa_debug.g_err_stage:='Copy Budget version returned error';
8967: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9011: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9007: ,x_return_status => x_return_status
9008: ,x_msg_count => x_msg_count
9009: ,x_msg_data => x_msg_data);
9010:
9011: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9012:
9013: IF l_debug_mode = 'Y' THEN
9014: pa_debug.g_err_stage:='Create_Fp_Option returned error';
9015: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9042: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9038: ,x_return_status => x_return_status
9039: ,x_msg_count => x_msg_count
9040: ,x_msg_data => x_msg_data);
9041:
9042: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9043:
9044: IF l_debug_mode = 'Y' THEN
9045: pa_debug.g_err_stage:='Copy_Fp_Txn_Currencies returned error';
9046: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9088: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

9084: x_return_status => l_return_status,
9085: x_msg_code => l_msg_data);
9086: END IF;
9087:
9088: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
9089: PA_UTILS.ADD_MESSAGE(p_app_short_name => PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
9090: p_msg_name => l_msg_data);
9091: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
9092: END IF;

Line 9136: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9132: ,x_return_status => x_return_status
9133: ,x_msg_count => x_msg_count
9134: ,x_msg_data => x_msg_data);
9135:
9136: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9137:
9138: IF l_debug_mode = 'Y' THEN
9139: pa_debug.g_err_stage:='Copy_Fp_Txn_Currencies returned error';
9140: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9158: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9154: ,x_return_status => x_return_status
9155: ,x_msg_count => x_msg_count
9156: ,x_msg_data => x_msg_data);
9157:
9158: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9159:
9160: IF l_debug_mode = 'Y' THEN
9161: pa_debug.g_err_stage:='Update_Plan_Setup_For_WP_Copy returned error';
9162: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9191: RAISE FND_API.G_EXC_ERROR;

9187: IF l_debug_mode = 'Y' THEN
9188: pa_debug.g_err_stage:='PA_TASK_ASSIGNMENTS_PVT.Copy_Missing_Unplanned_Asgmts returned error';
9189: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
9190: END IF;
9191: RAISE FND_API.G_EXC_ERROR;
9192: END;
9193: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9194: RAISE FND_API.G_EXC_ERROR;
9195: END IF;

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

9189: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
9190: END IF;
9191: RAISE FND_API.G_EXC_ERROR;
9192: END;
9193: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9194: RAISE FND_API.G_EXC_ERROR;
9195: END IF;
9196: -- End bug 3850488.
9197:

Line 9194: RAISE FND_API.G_EXC_ERROR;

9190: END IF;
9191: RAISE FND_API.G_EXC_ERROR;
9192: END;
9193: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9194: RAISE FND_API.G_EXC_ERROR;
9195: END IF;
9196: -- End bug 3850488.
9197:
9198: -- Call copy_actuals_for_workplan

Line 9207: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9203: ,x_return_status => x_return_status
9204: ,x_msg_count => x_msg_count
9205: ,x_msg_data => x_msg_data);
9206:
9207: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9208:
9209: IF l_debug_mode = 'Y' THEN
9210: pa_debug.g_err_stage:='Update_Plan_Setup_For_WP_Copy returned error';
9211: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9224: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9220: ,x_return_status => x_return_status
9221: ,x_msg_data => x_msg_data
9222: ,x_msg_count => x_msg_count);
9223:
9224: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9225:
9226: IF l_debug_mode = 'Y' THEN
9227: pa_debug.g_err_stage:='PA_PLANNING_TRANSACTION_UTILS.call_update_rep_lines_api returned error';
9228: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);

Line 9248: (p_encoded => FND_API.G_TRUE

9244: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9245: l_msg_count := FND_MSG_PUB.count_msg;
9246: IF l_msg_count = 1 THEN
9247: PA_INTERFACE_UTILS_PUB.get_messages
9248: (p_encoded => FND_API.G_TRUE
9249: ,p_msg_index => 1
9250: ,p_msg_count => l_msg_count
9251: ,p_msg_data => l_msg_data
9252: ,p_data => l_data

Line 9261: x_return_status := FND_API.G_RET_STS_ERROR;

9257: ELSE
9258: x_msg_count := l_msg_count;
9259: END IF;
9260: ROLLBACK TO copy_wp_budget_versions;
9261: x_return_status := FND_API.G_RET_STS_ERROR;
9262:
9263: IF l_debug_mode = 'Y' THEN
9264: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
9265: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 9272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9268: END IF;
9269: RETURN;
9270: WHEN OTHERS THEN
9271: ROLLBACK TO copy_wp_budget_versions;
9272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9273: x_msg_count := 1;
9274: x_msg_data := SQLERRM;
9275:
9276: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

Line 9483: x_return_status := FND_API.G_RET_STS_SUCCESS;

9479:
9480: BEGIN
9481:
9482: x_msg_count := 0;
9483: x_return_status := FND_API.G_RET_STS_SUCCESS;
9484: IF P_PA_DEBUG_MODE = 'Y' THEN
9485: pa_debug.set_err_stack('PA_FP_COPY_FROM_PKG.Copy_Budget_Lines_Appr_Rev');
9486: END IF;
9487: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 9955: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

9951: ,x_return_status => l_return_status
9952: ,x_msg_count => l_msg_count
9953: ,x_msg_data => l_msg_data);
9954:
9955: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9956: IF P_PA_debug_mode = 'Y' THEN
9957: pa_debug.g_err_stage:= 'Error in PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts';
9958: pa_debug.write('Copy_Budget_Lines_Appr_Rev: ' || g_module_name,pa_debug.g_err_stage,5);
9959: END IF;

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 derv_missing_amts_chk_neg_qty';
9985: pa_debug.write('Copy_Budget_Lines_Appr_Rev: ' || g_module_name,pa_debug.g_err_stage,5);
9986: END IF;

Line 10004: (p_encoded => FND_API.G_TRUE

10000: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10001: l_msg_count := FND_MSG_PUB.count_msg;
10002: IF l_msg_count = 1 THEN
10003: PA_INTERFACE_UTILS_PUB.get_messages
10004: (p_encoded => FND_API.G_TRUE
10005: ,p_msg_index => 1
10006: ,p_msg_count => l_msg_count
10007: ,p_msg_data => l_msg_data
10008: ,p_data => l_data

Line 10015: x_return_status := FND_API.G_RET_STS_ERROR;

10011: x_msg_count := l_msg_count;
10012: ELSE
10013: x_msg_count := l_msg_count;
10014: END IF;
10015: x_return_status := FND_API.G_RET_STS_ERROR;
10016:
10017: IF P_PA_DEBUG_MODE = 'Y' THEN
10018: pa_debug.g_err_stage:='Invalid arguments passed';
10019: pa_debug.write('Copy_Budget_Lines_Appr_Rev: ' || g_module_name,pa_debug.g_err_stage,5);

Line 10025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10021: END IF;
10022: RAISE;
10023:
10024: WHEN Others THEN
10025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10026: x_msg_count := 1;
10027: x_msg_data := SQLERRM;
10028: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'
10029: ,p_procedure_name => 'COPY_BUDGET_LINES_APPR_REV');

Line 10036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10032: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
10033: pa_debug.write('Copy_Budget_Lines_Appr_Rev: ' || g_module_name,pa_debug.g_err_stage,6);
10034: pa_debug.reset_err_stack;
10035: END IF;
10036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10037: END Copy_Budget_Lines_Appr_Rev;
10038:
10039: /*=============================================================================
10040: Bug 3619687: PJ.M:B5:BF:DEV:TRACKING BUG FOR PLAN SETTINGS CHANGE REQUEST

Line 10152: x_return_status := FND_API.G_RET_STS_SUCCESS;

10148:
10149: BEGIN
10150:
10151: x_msg_count := 0;
10152: x_return_status := FND_API.G_RET_STS_SUCCESS;
10153:
10154: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
10155: l_debug_mode := NVL(l_debug_mode, 'Y');
10156:

Line 10277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10273: ,x_return_status => x_return_status
10274: ,x_msg_count => x_msg_count
10275: ,x_msg_data => x_msg_data );
10276:
10277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10278: IF l_debug_mode = 'Y' THEN
10279: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.copy_fp_txn_currencies
10280: api returned error';
10281: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);

Line 10300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10296: ,x_return_status => x_return_status
10297: ,x_msg_count => x_msg_count
10298: ,x_msg_data => x_msg_data);
10299:
10300: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10301: IF l_debug_mode = 'Y' THEN
10302: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids
10303: api returned error';
10304: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);

Line 10348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

10344: ,x_msg_count => x_msg_count
10345: ,x_msg_data => x_msg_data);
10346:
10347: -- Bug 3579153 Check return status
10348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10349: IF l_debug_mode = 'Y' THEN
10350: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Map_Rlmi_Rbs api returned error';
10351: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);
10352: END IF;

Line 10410: (p_encoded => FND_API.G_TRUE

10406: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10407: l_msg_count := FND_MSG_PUB.count_msg;
10408: IF l_msg_count = 1 THEN
10409: PA_INTERFACE_UTILS_PUB.get_messages
10410: (p_encoded => FND_API.G_TRUE
10411: ,p_msg_index => 1
10412: ,p_msg_count => l_msg_count
10413: ,p_msg_data => l_msg_data
10414: ,p_data => l_data

Line 10423: x_return_status := FND_API.G_RET_STS_ERROR;

10419: ELSE
10420: x_msg_count := l_msg_count;
10421: END IF;
10422:
10423: x_return_status := FND_API.G_RET_STS_ERROR;
10424:
10425: IF l_debug_mode = 'Y' THEN
10426: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
10427: pa_debug.write('Update_Plan_Setup_For_WP_Copy: ' || g_module_name,pa_debug.g_err_stage,5);

Line 10433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10429: pa_debug.reset_curr_function();
10430: END IF;
10431: RETURN;
10432: WHEN Others THEN
10433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10434: x_msg_count := 1;
10435: x_msg_data := SQLERRM;
10436:
10437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'