DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on FND_MSG_PUB

Line 168: l_msg_count := FND_MSG_PUB.count_msg;

164: IF target_bdgt_vers_cur%ISOPEN THEN
165: CLOSE target_bdgt_vers_cur;
166: END IF;
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

Line 215: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
217: IF P_PA_DEBUG_MODE = 'Y' THEN
218: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
219: pa_debug.write('Acquire_Locks_For_Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,5);

Line 359: FND_MSG_PUB.INITIALIZE;

355:
356: -- End of cursors defined for bug#2729191
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

Line 725: l_msg_count := FND_MSG_PUB.count_msg;

721: pa_debug.g_err_stage:='Can not acquire lock.. exiting copy plan';
722: pa_debug.write('Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,5);
723: END IF;
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

Line 746: l_msg_count := FND_MSG_PUB.count_msg;

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
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

Line 770: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
774: pa_debug.write('Copy_Plan: ' || g_module_name,pa_debug.g_err_stage,5);

Line 913: l_msg_count := FND_MSG_PUB.count_msg;

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
917: ,p_msg_index => 1

Line 936: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
938:
939: IF P_PA_DEBUG_MODE = 'Y' THEN
940: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 1835: l_msg_count := FND_MSG_PUB.count_msg;

1831:
1832: EXCEPTION
1833:
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

Line 1862: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

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');
1864:
1865: IF P_PA_DEBUG_MODE = 'Y' THEN
1866: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2162: l_msg_count := FND_MSG_PUB.count_msg;

2158: END IF;
2159: EXCEPTION
2160:
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

Line 2193: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

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'
2194: ,p_procedure_name => 'create_res_task_maps');
2195:
2196: IF l_debug_mode = 'Y' THEN
2197: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 4049: l_msg_count := FND_MSG_PUB.count_msg;

4045: END IF;
4046: EXCEPTION
4047:
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

Line 4076: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
4078:
4079: IF P_PA_DEBUG_MODE = 'Y' THEN
4080: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 4645: l_msg_count := FND_MSG_PUB.count_msg;

4641: END IF;
4642:
4643: EXCEPTION
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

Line 4674: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

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'
4675: ,p_procedure_name => 'derv_missing_amts_chk_neg_qty');
4676:
4677: IF l_debug_mode = 'Y' THEN
4678: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 5228: l_msg_count := FND_MSG_PUB.count_msg;

5224: END IF;
5225: EXCEPTION
5226:
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

Line 5255: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
5257:
5258: IF P_PA_DEBUG_MODE = 'Y' THEN
5259: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 5546: l_msg_count := FND_MSG_PUB.count_msg;

5542: END IF;
5543: EXCEPTION
5544:
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

Line 5573: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
5575:
5576: IF P_PA_DEBUG_MODE = 'Y' THEN
5577: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 6090: FND_MSG_PUB.INITIALIZE;

6086: l_debug_level5 NUMBER:=5;
6087:
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

Line 6808: l_msg_count := FND_MSG_PUB.count_msg;

6804: EXCEPTION
6805:
6806: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
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

Line 6844: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
6846:
6847: IF P_PA_DEBUG_MODE = 'Y' THEN
6848: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 7190: l_msg_count := FND_MSG_PUB.count_msg;

7186:
7187: EXCEPTION
7188:
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

Line 7219: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
7221:
7222: IF P_PA_DEBUG_MODE = 'Y' THEN
7223: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 8123: l_msg_count := FND_MSG_PUB.count_msg;

8119: END IF;
8120: EXCEPTION
8121:
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

Line 8152: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
8154: IF P_PA_DEBUG_MODE = 'Y' THEN
8155: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;
8156: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,6);

Line 8263: l_msg_count := FND_MSG_PUB.count_msg;

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
8267: ,p_msg_index => 1

Line 8287: FND_MSG_PUB.add_exc_msg

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'
8289: ,p_procedure_name => 'Copy_Current_Period_Profiles'
8290: ,p_error_text => sqlerrm);
8291: IF p_pa_debug_mode = 'Y' THEN

Line 8682: l_msg_count := FND_MSG_PUB.count_msg;

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
8686: ,p_msg_index => 1

Line 8706: FND_MSG_PUB.add_exc_msg

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'
8708: ,p_procedure_name => 'Get_Create_Shifted_PD_Profile'
8709: ,p_error_text => sqlerrm);
8710: IF p_pa_debug_mode = 'Y' THEN

Line 9272: l_msg_count := FND_MSG_PUB.count_msg;

9268: END IF;
9269: EXCEPTION
9270:
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

Line 9303: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

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'
9304: ,p_procedure_name => 'copy_wp_budget_versions');
9305:
9306: IF l_debug_mode = 'Y' THEN
9307: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10028: l_msg_count := FND_MSG_PUB.count_msg;

10024: END IF;
10025: EXCEPTION
10026:
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

Line 10055: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_COPY_FROM_PKG'

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');
10057:
10058: IF P_PA_DEBUG_MODE = 'Y' THEN
10059: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 10434: l_msg_count := FND_MSG_PUB.count_msg;

10430:
10431: EXCEPTION
10432:
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

Line 10464: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_COPY_FROM_PKG'

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'
10465: ,p_procedure_name => 'Update_Plan_Setup_For_WP_Copy');
10466:
10467: IF l_debug_mode = 'Y' THEN
10468: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;