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 4037: l_msg_count := FND_MSG_PUB.count_msg;

4033: END IF;
4034: EXCEPTION
4035:
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

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

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');
4066:
4067: IF P_PA_DEBUG_MODE = 'Y' THEN
4068: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 4633: l_msg_count := FND_MSG_PUB.count_msg;

4629: END IF;
4630:
4631: EXCEPTION
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

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

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'
4663: ,p_procedure_name => 'derv_missing_amts_chk_neg_qty');
4664:
4665: IF l_debug_mode = 'Y' THEN
4666: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 5216: l_msg_count := FND_MSG_PUB.count_msg;

5212: END IF;
5213: EXCEPTION
5214:
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

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

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');
5245:
5246: IF P_PA_DEBUG_MODE = 'Y' THEN
5247: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 5534: l_msg_count := FND_MSG_PUB.count_msg;

5530: END IF;
5531: EXCEPTION
5532:
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

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

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');
5563:
5564: IF P_PA_DEBUG_MODE = 'Y' THEN
5565: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 6077: FND_MSG_PUB.INITIALIZE;

6073: l_debug_level5 NUMBER:=5;
6074:
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

Line 6791: l_msg_count := FND_MSG_PUB.count_msg;

6787: EXCEPTION
6788:
6789: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
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

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

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');
6829:
6830: IF P_PA_DEBUG_MODE = 'Y' THEN
6831: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 7173: l_msg_count := FND_MSG_PUB.count_msg;

7169:
7170: EXCEPTION
7171:
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

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

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');
7204:
7205: IF P_PA_DEBUG_MODE = 'Y' THEN
7206: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 8096: l_msg_count := FND_MSG_PUB.count_msg;

8092: END IF;
8093: EXCEPTION
8094:
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

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

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

Line 8236: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 8260: FND_MSG_PUB.add_exc_msg

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'
8262: ,p_procedure_name => 'Copy_Current_Period_Profiles'
8263: ,p_error_text => sqlerrm);
8264: IF p_pa_debug_mode = 'Y' THEN

Line 8655: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 8679: FND_MSG_PUB.add_exc_msg

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'
8681: ,p_procedure_name => 'Get_Create_Shifted_PD_Profile'
8682: ,p_error_text => sqlerrm);
8683: IF p_pa_debug_mode = 'Y' THEN

Line 9245: l_msg_count := FND_MSG_PUB.count_msg;

9241: END IF;
9242: EXCEPTION
9243:
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

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

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'
9277: ,p_procedure_name => 'copy_wp_budget_versions');
9278:
9279: IF l_debug_mode = 'Y' THEN
9280: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10001: l_msg_count := FND_MSG_PUB.count_msg;

9997: END IF;
9998: EXCEPTION
9999:
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

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

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');
10030:
10031: IF P_PA_DEBUG_MODE = 'Y' THEN
10032: pa_debug.g_err_stage:='Unexpected error'||SQLERRM;

Line 10407: l_msg_count := FND_MSG_PUB.count_msg;

10403:
10404: EXCEPTION
10405:
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

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

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'
10438: ,p_procedure_name => 'Update_Plan_Setup_For_WP_Copy');
10439:
10440: IF l_debug_mode = 'Y' THEN
10441: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;