DBA Data[Home] [Help]

APPS.PA_FP_ELEMENTS_PUB dependencies on FND_MSG_PUB

Line 47: FND_MSG_PUB.initialize;

43: l_debug_mode VARCHAR2(30);
44:
45: BEGIN
46:
47: FND_MSG_PUB.initialize;
48: IF P_PA_DEBUG_MODE = 'Y' THEN
49: pa_debug.init_err_stack('PA_FP_ELEMENTS_PUB.Refresh_FP_Elements');
50: END IF;
51: fnd_profile.get('pa_debug_MODE',l_debug_mode);

Line 157: l_msg_count := FND_MSG_PUB.count_msg;

153: pa_debug.reset_err_stack;
154:
155: EXCEPTION
156: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
157: l_msg_count := FND_MSG_PUB.count_msg;
158: IF l_msg_count = 1 THEN
159: PA_INTERFACE_UTILS_PUB.get_messages
160: (p_encoded => FND_API.G_TRUE,
161: p_msg_index => 1,

Line 177: FND_MSG_PUB.add_exc_msg

173: WHEN OTHERS THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: x_msg_count := 1;
176: x_msg_data := SQLERRM;
177: FND_MSG_PUB.add_exc_msg
178: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB.Refresh_FP_Elements'
179: ,p_procedure_name => pa_debug.G_Err_Stack );
180: IF P_PA_DEBUG_MODE = 'Y' THEN
181: pa_debug.write('Refresh_FP_Elements: ' || l_module_name,SQLERRM,4);

Line 262: FND_MSG_PUB.initialize;

258: /* end of variables defined for Bug 2920954*/
259:
260: BEGIN
261:
262: FND_MSG_PUB.initialize;
263: IF P_PA_DEBUG_MODE = 'Y' THEN
264: pa_debug.init_err_stack('PA_FP_ELEMENTS_PUB.Copy_Elements');
265: END IF;
266: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 309: IF FND_MSG_PUB.count_msg > 0 THEN

305: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
306:
307: END IF;
308:
309: IF FND_MSG_PUB.count_msg > 0 THEN
310: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
311: END IF;
312:
313: l_stage := 200;

Line 861: l_msg_count := FND_MSG_PUB.count_msg;

857: pa_debug.reset_err_stack;
858:
859: EXCEPTION
860: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
861: l_msg_count := FND_MSG_PUB.count_msg;
862: IF l_msg_count = 1 THEN
863: PA_INTERFACE_UTILS_PUB.get_messages
864: (p_encoded => FND_API.G_TRUE,
865: p_msg_index => 1,

Line 881: FND_MSG_PUB.add_exc_msg

877: WHEN OTHERS THEN
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: x_msg_count := 1;
880: x_msg_data := SQLERRM;
881: FND_MSG_PUB.add_exc_msg
882: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB.Copy_Elements'
883: ,p_procedure_name => pa_debug.G_Err_Stack );
884: IF P_PA_DEBUG_MODE = 'Y' THEN
885: pa_debug.write('Copy_Elements: ' || l_module_name,SQLERRM,4);

Line 1424: l_msg_count := FND_MSG_PUB.count_msg;

1420: pa_debug.reset_err_stack;
1421:
1422: EXCEPTION
1423: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1424: l_msg_count := FND_MSG_PUB.count_msg;
1425: IF l_msg_count = 1 THEN
1426: PA_INTERFACE_UTILS_PUB.get_messages
1427: (p_encoded => FND_API.G_TRUE,
1428: p_msg_index => 1,

Line 1444: FND_MSG_PUB.add_exc_msg

1440: WHEN OTHERS THEN
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: x_msg_count := 1;
1443: x_msg_data := SQLERRM;
1444: FND_MSG_PUB.add_exc_msg
1445: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB.Insert_Default'
1446: ,p_procedure_name => pa_debug.G_Err_Stack );
1447: IF P_PA_DEBUG_MODE = 'Y' THEN
1448: pa_debug.write('Insert_Default: ' || l_module_name,SQLERRM,4);

Line 1550: FND_MSG_PUB.add_exc_msg

1546: WHEN OTHERS THEN
1547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1548: x_msg_count := 1;
1549: x_msg_data := SQLERRM;
1550: FND_MSG_PUB.add_exc_msg
1551: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB.Delete_Elements'
1552: ,p_procedure_name => pa_debug.G_Err_Stack );
1553: IF P_PA_DEBUG_MODE = 'Y' THEN
1554: pa_debug.write('Delete_Elements: ' || l_module_name,SQLERRM,4);

Line 1810: FND_MSG_PUB.add_exc_msg

1806: WHEN OTHERS THEN
1807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1808: x_msg_count := 1;
1809: x_msg_data := SQLERRM;
1810: FND_MSG_PUB.add_exc_msg
1811: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB.Delete_Element'
1812: ,p_procedure_name => pa_debug.G_Err_Stack );
1813: IF P_PA_DEBUG_MODE = 'Y' THEN
1814: pa_debug.write('Delete_Element: ' || l_module_name,SQLERRM,4);

Line 1941: FND_MSG_PUB.add_exc_msg

1937: WHEN OTHERS THEN
1938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1939: x_msg_count := 1;
1940: x_msg_data := SQLERRM;
1941: FND_MSG_PUB.add_exc_msg
1942: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB.Insert_Bulk_Rows'
1943: ,p_procedure_name => pa_debug.G_Err_Stack );
1944: IF P_PA_DEBUG_MODE = 'Y' THEN
1945: pa_debug.write('Insert_Bulk_Rows: ' || l_module_name,SQLERRM,4);

Line 2048: FND_MSG_PUB.add_exc_msg

2044: WHEN OTHERS THEN
2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2046: x_msg_count := 1;
2047: x_msg_data := SQLERRM;
2048: FND_MSG_PUB.add_exc_msg
2049: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB.Insert_Bulk_Rows_Res'
2050: ,p_procedure_name => pa_debug.G_Err_Stack );
2051: IF P_PA_DEBUG_MODE = 'Y' THEN
2052: pa_debug.write('Insert_Bulk_Rows: ' || l_module_name,SQLERRM,4);

Line 2553: l_msg_count := FND_MSG_PUB.count_msg;

2549: EXCEPTION
2550:
2551: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2552:
2553: l_msg_count := FND_MSG_PUB.count_msg;
2554: IF l_msg_count = 1 THEN
2555: PA_INTERFACE_UTILS_PUB.get_messages
2556: (p_encoded => FND_API.G_TRUE
2557: ,p_msg_index => 1

Line 2582: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'

2578:
2579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2580: x_msg_count := 1;
2581: x_msg_data := SQLERRM;
2582: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
2583: ,p_procedure_name => 'CREATE_ENTERABLE_RESOURCES');
2584: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
2585: IF P_PA_DEBUG_MODE = 'Y' THEN
2586: pa_debug.write('create_enterable_resources: ' || l_module_name,pa_debug.g_err_stage,5);

Line 3276: l_msg_count := FND_MSG_PUB.count_msg;

3272: EXCEPTION
3273:
3274: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3275:
3276: l_msg_count := FND_MSG_PUB.count_msg;
3277: IF l_msg_count = 1 THEN
3278: PA_INTERFACE_UTILS_PUB.get_messages
3279: (p_encoded => FND_API.G_TRUE
3280: ,p_msg_index => 1

Line 3334: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_UPGRADE_PKG'

3330:
3331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3332: x_msg_count := 1;
3333: x_msg_data := SQLERRM;
3334: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_FP_UPGRADE_PKG'
3335: ,p_procedure_name => 'Create_elements_from_version');
3336: IF p_pa_debug_mode = 'Y' THEN
3337: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
3338: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

Line 3420: IF FND_MSG_PUB.count_msg > 0 THEN

3416:
3417: END IF;
3418:
3419:
3420: IF FND_MSG_PUB.count_msg > 0 THEN
3421: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3422: END IF;
3423:
3424:

Line 3717: l_msg_count := FND_MSG_PUB.count_msg;

3713: pa_debug.reset_err_stack;
3714:
3715: EXCEPTION
3716: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3717: l_msg_count := FND_MSG_PUB.count_msg;
3718: IF l_msg_count = 1 THEN
3719: PA_INTERFACE_UTILS_PUB.get_messages
3720: (p_encoded => FND_API.G_TRUE,
3721: p_msg_index => 1,

Line 3738: FND_MSG_PUB.add_exc_msg

3734: WHEN OTHERS THEN
3735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3736: x_msg_count := 1;
3737: x_msg_data := SQLERRM;
3738: FND_MSG_PUB.add_exc_msg
3739: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB.refresh_res_list_changes'
3740: ,p_procedure_name => pa_debug.G_Err_Stack );
3741: IF P_PA_DEBUG_MODE = 'Y' THEN
3742: pa_debug.write('refresh_res_list_changes: ' || l_module_name,SQLERRM,4);

Line 3993: l_msg_count := FND_MSG_PUB.count_msg;

3989:
3990: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3991:
3992: x_return_status := FND_API.G_RET_STS_ERROR;
3993: l_msg_count := FND_MSG_PUB.count_msg;
3994: IF l_msg_count = 1 THEN
3995: PA_INTERFACE_UTILS_PUB.get_messages
3996: (p_encoded => FND_API.G_TRUE
3997: ,p_msg_index => 1

Line 4020: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'

4016:
4017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4018: x_msg_count := 1;
4019: x_msg_data := SQLERRM;
4020: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
4021: ,p_procedure_name => 'CREATE_ASSGMT_FROM_ROLLUPTMP');
4022: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4023: IF P_PA_DEBUG_MODE = 'Y' THEN
4024: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 4477: l_msg_count := FND_MSG_PUB.count_msg;

4473:
4474: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4475:
4476: x_return_status := FND_API.G_RET_STS_ERROR;
4477: l_msg_count := FND_MSG_PUB.count_msg;
4478: IF l_msg_count = 1 THEN
4479: PA_INTERFACE_UTILS_PUB.get_messages
4480: (p_encoded => FND_API.G_TRUE
4481: ,p_msg_index => 1

Line 4504: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'

4500:
4501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4502: x_msg_count := 1;
4503: x_msg_data := SQLERRM;
4504: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
4505: ,p_procedure_name => 'Create_CI_Resource_Assignments');
4506: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4507: IF P_PA_DEBUG_MODE = 'Y' THEN
4508: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 4991: l_msg_count := FND_MSG_PUB.count_msg;

4987:
4988: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4989:
4990: x_return_status := FND_API.G_RET_STS_ERROR;
4991: l_msg_count := FND_MSG_PUB.count_msg;
4992: IF l_msg_count = 1 THEN
4993: PA_INTERFACE_UTILS_PUB.get_messages
4994: (p_encoded => FND_API.G_TRUE
4995: ,p_msg_index => 1

Line 5012: FND_MSG_PUB.add_exc_msg

5008:
5009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5010: x_msg_count := 1;
5011: x_msg_data := SQLERRM;
5012: FND_MSG_PUB.add_exc_msg
5013: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
5014: ,p_procedure_name => 'ADD_RESOURCES_AUTOMATICALLY'
5015: ,p_error_text => sqlerrm);
5016: pa_debug.reset_curr_function;

Line 5112: l_msg_count := FND_MSG_PUB.count_msg;

5108:
5109: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5110:
5111: x_return_status := FND_API.G_RET_STS_ERROR;
5112: l_msg_count := FND_MSG_PUB.count_msg;
5113:
5114: IF l_msg_count = 1 and x_msg_data IS NULL THEN
5115: PA_INTERFACE_UTILS_PUB.get_messages
5116: (p_encoded => FND_API.G_TRUE

Line 5136: FND_MSG_PUB.add_exc_msg

5132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5133: x_msg_count := 1;
5134: x_msg_data := SQLERRM;
5135:
5136: FND_MSG_PUB.add_exc_msg
5137: ( p_pkg_name => 'pa_Fp_elements_pub'
5138: ,p_procedure_name => 'delete_task_elements'
5139: ,p_error_text => x_msg_data);
5140:

Line 5491: l_msg_count := FND_MSG_PUB.count_msg;

5487:
5488: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5489:
5490: x_return_status := FND_API.G_RET_STS_ERROR;
5491: l_msg_count := FND_MSG_PUB.count_msg;
5492:
5493: IF l_msg_count = 1 and x_msg_data IS NULL THEN
5494: PA_INTERFACE_UTILS_PUB.get_messages
5495: (p_encoded => FND_API.G_TRUE

Line 5518: FND_MSG_PUB.add_exc_msg

5514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5515: x_msg_count := 1;
5516: x_msg_data := SQLERRM;
5517:
5518: FND_MSG_PUB.add_exc_msg
5519: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
5520: ,p_procedure_name => 'Get_Task_Element_Attributes'
5521: ,p_error_text => x_msg_data);
5522:

Line 5981: l_msg_count := FND_MSG_PUB.count_msg;

5977:
5978: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5979:
5980: x_return_status := FND_API.G_RET_STS_ERROR;
5981: l_msg_count := FND_MSG_PUB.count_msg;
5982:
5983: IF l_msg_count = 1 and x_msg_data IS NULL THEN
5984: PA_INTERFACE_UTILS_PUB.get_messages
5985: (p_encoded => FND_API.G_TRUE

Line 6007: FND_MSG_PUB.add_exc_msg

6003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6004: x_msg_count := 1;
6005: x_msg_data := SQLERRM;
6006:
6007: FND_MSG_PUB.add_exc_msg
6008: ( p_pkg_name => 'pa_fp_elements_pub'
6009: ,p_procedure_name => 'add_task_to_option'
6010: ,p_error_text => x_msg_data);
6011:

Line 6292: l_msg_count := FND_MSG_PUB.count_msg;

6288:
6289: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6290:
6291: x_return_status := FND_API.G_RET_STS_ERROR;
6292: l_msg_count := FND_MSG_PUB.count_msg;
6293:
6294: IF l_msg_count = 1 and x_msg_data IS NULL THEN
6295: PA_INTERFACE_UTILS_PUB.get_messages
6296: (p_encoded => FND_API.G_TRUE

Line 6318: FND_MSG_PUB.add_exc_msg

6314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6315: x_msg_count := 1;
6316: x_msg_data := SQLERRM;
6317:
6318: FND_MSG_PUB.add_exc_msg
6319: ( p_pkg_name => 'pa_fp_elements_pub'
6320: ,p_procedure_name => 'make_new_tasks_plannable'
6321: ,p_error_text => x_msg_data);
6322:

Line 7192: l_msg_count := FND_MSG_PUB.count_msg;

7188:
7189: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7190:
7191: x_return_status := FND_API.G_RET_STS_ERROR;
7192: l_msg_count := FND_MSG_PUB.count_msg;
7193:
7194: IF l_msg_count = 1 and x_msg_data IS NULL THEN
7195: PA_INTERFACE_UTILS_PUB.get_messages
7196: (p_encoded => FND_API.G_TRUE

Line 7223: FND_MSG_PUB.add_exc_msg

7219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7220: x_msg_count := 1;
7221: x_msg_data := SQLERRM;
7222:
7223: FND_MSG_PUB.add_exc_msg
7224: ( p_pkg_name => 'pa_fp_elements_pub'
7225: ,p_procedure_name => 'maintain_plannable_tasks'
7226: ,p_error_text => x_msg_data);
7227: