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

3998:
3999: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4000:
4001: x_return_status := FND_API.G_RET_STS_ERROR;
4002: l_msg_count := FND_MSG_PUB.count_msg;
4003: IF l_msg_count = 1 THEN
4004: PA_INTERFACE_UTILS_PUB.get_messages
4005: (p_encoded => FND_API.G_TRUE
4006: ,p_msg_index => 1

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

4025:
4026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4027: x_msg_count := 1;
4028: x_msg_data := SQLERRM;
4029: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
4030: ,p_procedure_name => 'CREATE_ASSGMT_FROM_ROLLUPTMP');
4031: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4032: IF P_PA_DEBUG_MODE = 'Y' THEN
4033: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 4486: l_msg_count := FND_MSG_PUB.count_msg;

4482:
4483: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4484:
4485: x_return_status := FND_API.G_RET_STS_ERROR;
4486: l_msg_count := FND_MSG_PUB.count_msg;
4487: IF l_msg_count = 1 THEN
4488: PA_INTERFACE_UTILS_PUB.get_messages
4489: (p_encoded => FND_API.G_TRUE
4490: ,p_msg_index => 1

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

4509:
4510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4511: x_msg_count := 1;
4512: x_msg_data := SQLERRM;
4513: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
4514: ,p_procedure_name => 'Create_CI_Resource_Assignments');
4515: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4516: IF P_PA_DEBUG_MODE = 'Y' THEN
4517: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 5000: l_msg_count := FND_MSG_PUB.count_msg;

4996:
4997: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4998:
4999: x_return_status := FND_API.G_RET_STS_ERROR;
5000: l_msg_count := FND_MSG_PUB.count_msg;
5001: IF l_msg_count = 1 THEN
5002: PA_INTERFACE_UTILS_PUB.get_messages
5003: (p_encoded => FND_API.G_TRUE
5004: ,p_msg_index => 1

Line 5021: FND_MSG_PUB.add_exc_msg

5017:
5018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5019: x_msg_count := 1;
5020: x_msg_data := SQLERRM;
5021: FND_MSG_PUB.add_exc_msg
5022: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
5023: ,p_procedure_name => 'ADD_RESOURCES_AUTOMATICALLY'
5024: ,p_error_text => sqlerrm);
5025: pa_debug.reset_curr_function;

Line 5121: l_msg_count := FND_MSG_PUB.count_msg;

5117:
5118: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5119:
5120: x_return_status := FND_API.G_RET_STS_ERROR;
5121: l_msg_count := FND_MSG_PUB.count_msg;
5122:
5123: IF l_msg_count = 1 and x_msg_data IS NULL THEN
5124: PA_INTERFACE_UTILS_PUB.get_messages
5125: (p_encoded => FND_API.G_TRUE

Line 5145: FND_MSG_PUB.add_exc_msg

5141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5142: x_msg_count := 1;
5143: x_msg_data := SQLERRM;
5144:
5145: FND_MSG_PUB.add_exc_msg
5146: ( p_pkg_name => 'pa_Fp_elements_pub'
5147: ,p_procedure_name => 'delete_task_elements'
5148: ,p_error_text => x_msg_data);
5149:

Line 5500: l_msg_count := FND_MSG_PUB.count_msg;

5496:
5497: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5498:
5499: x_return_status := FND_API.G_RET_STS_ERROR;
5500: l_msg_count := FND_MSG_PUB.count_msg;
5501:
5502: IF l_msg_count = 1 and x_msg_data IS NULL THEN
5503: PA_INTERFACE_UTILS_PUB.get_messages
5504: (p_encoded => FND_API.G_TRUE

Line 5527: FND_MSG_PUB.add_exc_msg

5523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5524: x_msg_count := 1;
5525: x_msg_data := SQLERRM;
5526:
5527: FND_MSG_PUB.add_exc_msg
5528: ( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
5529: ,p_procedure_name => 'Get_Task_Element_Attributes'
5530: ,p_error_text => x_msg_data);
5531:

Line 5990: l_msg_count := FND_MSG_PUB.count_msg;

5986:
5987: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5988:
5989: x_return_status := FND_API.G_RET_STS_ERROR;
5990: l_msg_count := FND_MSG_PUB.count_msg;
5991:
5992: IF l_msg_count = 1 and x_msg_data IS NULL THEN
5993: PA_INTERFACE_UTILS_PUB.get_messages
5994: (p_encoded => FND_API.G_TRUE

Line 6016: FND_MSG_PUB.add_exc_msg

6012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6013: x_msg_count := 1;
6014: x_msg_data := SQLERRM;
6015:
6016: FND_MSG_PUB.add_exc_msg
6017: ( p_pkg_name => 'pa_fp_elements_pub'
6018: ,p_procedure_name => 'add_task_to_option'
6019: ,p_error_text => x_msg_data);
6020:

Line 6301: l_msg_count := FND_MSG_PUB.count_msg;

6297:
6298: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6299:
6300: x_return_status := FND_API.G_RET_STS_ERROR;
6301: l_msg_count := FND_MSG_PUB.count_msg;
6302:
6303: IF l_msg_count = 1 and x_msg_data IS NULL THEN
6304: PA_INTERFACE_UTILS_PUB.get_messages
6305: (p_encoded => FND_API.G_TRUE

Line 6327: FND_MSG_PUB.add_exc_msg

6323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6324: x_msg_count := 1;
6325: x_msg_data := SQLERRM;
6326:
6327: FND_MSG_PUB.add_exc_msg
6328: ( p_pkg_name => 'pa_fp_elements_pub'
6329: ,p_procedure_name => 'make_new_tasks_plannable'
6330: ,p_error_text => x_msg_data);
6331:

Line 7201: l_msg_count := FND_MSG_PUB.count_msg;

7197:
7198: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7199:
7200: x_return_status := FND_API.G_RET_STS_ERROR;
7201: l_msg_count := FND_MSG_PUB.count_msg;
7202:
7203: IF l_msg_count = 1 and x_msg_data IS NULL THEN
7204: PA_INTERFACE_UTILS_PUB.get_messages
7205: (p_encoded => FND_API.G_TRUE

Line 7232: FND_MSG_PUB.add_exc_msg

7228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7229: x_msg_count := 1;
7230: x_msg_data := SQLERRM;
7231:
7232: FND_MSG_PUB.add_exc_msg
7233: ( p_pkg_name => 'pa_fp_elements_pub'
7234: ,p_procedure_name => 'maintain_plannable_tasks'
7235: ,p_error_text => x_msg_data);
7236: