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_RELATIONSHIP_PVT dependencies on PA_UTILS

Line 226: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_PUB_VER_EXIST');

222: --dbms_output.put_line('struc ver id='||l_lastest_pub_ver_id||', struc id = '||l_structure_id);
223: IF Get_latest_Pub_Ver%NOTFOUND THEN
224: CLOSE Get_latest_Pub_Ver;
225: --dbms_output.put_line('no latest pub version, error');
226: PA_UTILS.ADD_MESSAGE('PA','PA_PS_NO_PUB_VER_EXIST');
227: x_msg_data := 'PA_PS_NO_PUB_VER_EXIST';
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230: l_id_to := l_lastest_pub_ver_id;

Line 237: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_NAME_REQ');

233:
234: ELSE
235: --Check if user entered Structure Name and Structure Version Name
236: If (p_structure_id_to = NULL) THEN
237: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_NAME_REQ');
238: x_msg_data := 'PA_PS_STRUC_NAME_REQ';
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241:

Line 247: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_TYPE_ID_ERR');

243: OPEN Is_Struc_Type_Valid(p_structure_type, p_structure_id_to);
244: FETCH Is_Struc_Type_Valid into l_dummy;
245: IF Is_Struc_Type_Valid%NOTFOUND THEN
246: CLOSE Is_Struc_Type_Valid;
247: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_TYPE_ID_ERR');
248: x_msg_data := 'PA_PS_STRUC_TYPE_ID_ERR';
249: RAISE FND_API.G_EXC_ERROR;
250: END IF;
251: CLOSE Is_Struc_Type_Valid;

Line 254: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAME_REQ');

250: END IF;
251: CLOSE Is_Struc_Type_Valid;
252:
253: IF (p_structure_version_id_to = NULL) THEN
254: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_VER_NAME_REQ');
255: x_msg_data := 'PA_PS_STRUC_VER_NAME_REQ';
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258:

Line 292: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_TYPE_ID_ERR');

288: OPEN Is_Struc_Type_Valid(p_structure_type, p_structure_id_from);
289: FETCH Is_Struc_Type_Valid into l_dummy;
290: IF Is_Struc_Type_Valid%NOTFOUND THEN
291: CLOSE Is_Struc_Type_Valid;
292: PA_UTILS.ADD_MESSAGE('PA','PA_PS_STRUC_TYPE_ID_ERR');
293: x_msg_data := 'PA_PS_STRUC_TYPE_ID_ERR';
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296: CLOSE Is_Struc_Type_Valid;

Line 515: PA_UTILS.ADD_MESSAGE('PA',l_error_message_code);

511: END IF;
512: -- End : 4537865
513:
514: ELSE
515: PA_UTILS.ADD_MESSAGE('PA',l_error_message_code);
516: x_msg_data := l_error_message_code;
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519:

Line 1183: PA_UTILS.add_message('PA', 'PA_PS_NO_DEP_ON_SUMM');

1179: IF NVL(l_cnt,0) <> 0 THEN
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: x_msg_count := 1;
1182: x_msg_data := 'PA_PS_NO_DEP_ON_SUMM';
1183: PA_UTILS.add_message('PA', 'PA_PS_NO_DEP_ON_SUMM');
1184: raise FND_API.G_EXC_ERROR;
1185: END IF;
1186: END;
1187: END IF;

Line 1202: PA_UTILS.add_message('PA', 'PA_PS_NO_DEP_ON_SUMM');

1198: IF NVL(l_cnt,0) <> 0 THEN
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200: x_msg_count := 1;
1201: x_msg_data := 'PA_PS_NO_DEP_ON_SUMM';
1202: PA_UTILS.add_message('PA', 'PA_PS_NO_DEP_ON_SUMM');
1203: raise FND_API.G_EXC_ERROR;
1204: END IF;
1205: END;
1206: END IF;

Line 1714: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_DEP_FOR_PUB_STR');

1710: -- Bug No 3494587, added this to code check if the the structure ver is published
1711: -- if the sturcture ver is published then the process should not allow to delete dependency
1712: IF PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_project_id) = 'Y' THEN
1713: IF PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(l_project_id,l_struc_ver_id) = 'Y' THEN
1714: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_DEP_FOR_PUB_STR');
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717: END IF;
1718: --

Line 3349: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

3345: close cur_proj_name;
3346:
3347: -- Bug # 4329284.
3348:
3349: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3350: RAISE FND_API.G_EXC_ERROR;
3351: END IF;
3352: IF (p_debug_mode = 'Y') THEN
3353: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

Line 3651: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PRJ_CURR','PROJ',l_proj_name,'TASK',l_task_name,'PROG',l_prog_name); -- Bug # 4329284.

3647: END IF;
3648:
3649: --Bug 3912783:
3650: IF (PA_RELATIONSHIP_UTILS.Check_proj_currency_identical(p_src_proj_id,p_dest_proj_id) = 'N') THEN
3651: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PRJ_CURR','PROJ',l_proj_name,'TASK',l_task_name,'PROG',l_prog_name); -- Bug # 4329284.
3652: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PRJ_CURR','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.
3653: RAISE FND_API.G_EXC_ERROR;
3654: END IF;
3655: --end bug 3912783

Line 3652: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PRJ_CURR','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.

3648:
3649: --Bug 3912783:
3650: IF (PA_RELATIONSHIP_UTILS.Check_proj_currency_identical(p_src_proj_id,p_dest_proj_id) = 'N') THEN
3651: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PRJ_CURR','PROJ',l_proj_name,'TASK',l_task_name,'PROG',l_prog_name); -- Bug # 4329284.
3652: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PRJ_CURR','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.
3653: RAISE FND_API.G_EXC_ERROR;
3654: END IF;
3655: --end bug 3912783
3656:

Line 3751: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_TIME_PHASE','PROJ',l_proj_name,'TASK',l_task_name,'PROG',l_prog_name); -- Bug # 4329284.

3747: l_time_phase1 := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(l_src_struc_elem_ver_id);
3748: IF l_dest_wp_str_ver_id IS NOT NULL THEN
3749: l_time_phase2 := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(l_dest_wp_str_ver_id);
3750: IF (l_time_phase1 <> l_time_phase2) THEN
3751: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_TIME_PHASE','PROJ',l_proj_name,'TASK',l_task_name,'PROG',l_prog_name); -- Bug # 4329284.
3752: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_TIME_PHASE','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.
3753: RAISE FND_API.G_EXC_ERROR;
3754: END IF;
3755: END IF;

Line 3752: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_TIME_PHASE','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.

3748: IF l_dest_wp_str_ver_id IS NOT NULL THEN
3749: l_time_phase2 := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(l_dest_wp_str_ver_id);
3750: IF (l_time_phase1 <> l_time_phase2) THEN
3751: -- PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_TIME_PHASE','PROJ',l_proj_name,'TASK',l_task_name,'PROG',l_prog_name); -- Bug # 4329284.
3752: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_TIME_PHASE','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.
3753: RAISE FND_API.G_EXC_ERROR;
3754: END IF;
3755: END IF;
3756: END IF;

Line 3775: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PA_CAL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

3771: THEN
3772: IF l_src_period_duration.pa_period_set_name <> l_dest_period_duration.pa_period_set_name OR
3773: l_src_period_duration.pa_period_type <> l_dest_period_duration.pa_period_type
3774: THEN
3775: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PA_CAL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3776: RAISE FND_API.G_EXC_ERROR;
3777: END IF;
3778:
3779: ELSIF l_time_phase1 = 'G' AND l_time_phase2 = 'G'

Line 3784: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_GL_CAL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

3780: THEN
3781: IF l_src_period_duration.gl_period_set_name <> l_dest_period_duration.gl_period_set_name OR
3782: l_src_period_duration.accounted_period_type <> l_dest_period_duration.accounted_period_type
3783: THEN
3784: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_GL_CAL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3785: RAISE FND_API.G_EXC_ERROR;
3786: END IF;
3787: END IF;
3788: END IF;

Line 3822: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

3818: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id) = 'N' THEN --SMukka
3819:
3820: if (FND_MSG_PUB.count_msg = 0) then -- Fix for Bug # 4256435.
3821:
3822: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3823:
3824: end if; -- Fix for Bug # 4256435.
3825:
3826: RAISE FND_API.G_EXC_ERROR;

Line 3836: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

3832: -- 4473103 : Begin
3833: IF l_src_str_wp_enable_fl = 'Y' AND l_dest_wp_str_ver_id IS NOT NULL THEN
3834: l_create_relationship_ok := PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id,'WORKPLAN');
3835: IF l_create_relationship_ok = 'N' THEN
3836: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3837: RAISE FND_API.G_EXC_ERROR;
3838: END IF;
3839: END IF;
3840:

Line 3844: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

3840:
3841: IF l_src_str_fin_enable_fl = 'Y' AND l_dest_fin_str_ver_id IS NOT NULL AND l_src_task_financial_flag='Y' THEN
3842: l_create_relationship_ok := PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id,'FINANCIAL');
3843: IF l_create_relationship_ok = 'N' THEN
3844: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3845: RAISE FND_API.G_EXC_ERROR;
3846: END IF;
3847: END IF;
3848: -- 4473103 : End

Line 3863: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

3859: END IF;
3860: /* --bug 3983361
3861: IF p_validation_level > 0 THEN
3862: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id) = 'N' THEN --SMukka
3863: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3864: RAISE FND_API.G_EXC_ERROR;
3865: END IF;
3866: END IF;
3867: */

Line 3930: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

3926: END IF;
3927: /* --bug 3983361
3928: IF p_validation_level > 0 THEN
3929: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id, 'FINANCIAL') = 'N' THEN --SMukka
3930: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3931: RAISE FND_API.G_EXC_ERROR;
3932: END IF;
3933: END IF;
3934: */

Line 3997: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

3993: END IF;
3994: /* --bug 3983361
3995: IF p_validation_level > 0 THEN
3996: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id) = 'N' THEN --SMukka
3997: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3998: RAISE FND_API.G_EXC_ERROR;
3999: END IF;
4000: END IF;
4001: */

Line 4066: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

4062: END IF;
4063: /* --bug 3983361
4064: IF p_validation_level > 0 THEN
4065: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id, 'FINANCIAL') = 'N' THEN --SMukka
4066: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
4067: RAISE FND_API.G_EXC_ERROR;
4068: END IF;
4069: END IF;
4070: */

Line 4549: PA_UTILS.ADD_MESSAGE('PA','PA_NO_RECORD_VERSION_NUMBER');

4545: OPEN get_lnk_obj_rel_attr(p_object_relationships_id);
4546: FETCH get_lnk_obj_rel_attr INTO get_lnk_obj_rel_attr_rec;
4547: IF get_lnk_obj_rel_attr%NOTFOUND THEN
4548: CLOSE get_lnk_obj_rel_attr;
4549: PA_UTILS.ADD_MESSAGE('PA','PA_NO_RECORD_VERSION_NUMBER');
4550: x_msg_data := 'PA_NO_RECORD_VERSION_NUMBER';
4551: RAISE FND_API.G_EXC_ERROR;
4552: END IF;
4553: --

Line 4573: PA_UTILS.ADD_MESSAGE('PA','PA_NO_RECORD_VERSION_NUMBER');

4569: OPEN get_src_task_ver_id(get_lnk_obj_rel_attr_rec.object_id_from1);
4570: FETCH get_src_task_ver_id INTO get_src_task_ver_id_rec;
4571: IF get_src_task_ver_id%NOTFOUND THEN
4572: CLOSE get_src_task_ver_id;
4573: PA_UTILS.ADD_MESSAGE('PA','PA_NO_RECORD_VERSION_NUMBER');
4574: x_msg_data := 'PA_NO_RECORD_VERSION_NUMBER';
4575: RAISE FND_API.G_EXC_ERROR;
4576: END IF;
4577: --

Line 4617: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_SUBPROJ_VAL_FAIL');

4613: BEGIN
4614: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(get_lnk_info_rec.lnk_obj_rel_id,
4615: 'DROP');
4616: IF l_upd_prog_grp_status < 0 THEN
4617: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_SUBPROJ_VAL_FAIL');
4618: RAISE FND_API.G_EXC_ERROR;
4619: END IF;
4620: IF (p_debug_mode = 'Y') THEN
4621: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

Line 4685: PA_UTILS.ADD_MESSAGE('PA','PA_NO_RECORD_VERSION_NUMBER');

4681: OPEN get_rec_ver_num(get_lnk_info_rec.lnk_task_ver_id);
4682: FETCH get_rec_ver_num INTO get_rec_ver_num_rec;
4683: IF get_rec_ver_num%NOTFOUND THEN
4684: CLOSE get_rec_ver_num;
4685: PA_UTILS.ADD_MESSAGE('PA','PA_NO_RECORD_VERSION_NUMBER');
4686: x_msg_data := 'PA_NO_RECORD_VERSION_NUMBER';
4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;
4689: --

Line 5025: PA_UTILS.ADD_MESSAGE('PA','PA_CP_SUBPROJ_VAL_FAIL');

5021: BEGIN
5022: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(l_object_relationship_id,
5023: 'ADD');
5024: IF l_upd_prog_grp_status < 0 THEN
5025: PA_UTILS.ADD_MESSAGE('PA','PA_CP_SUBPROJ_VAL_FAIL');
5026: RAISE FND_API.G_EXC_ERROR;
5027: END IF;
5028: IF (p_debug_mode = 'Y') THEN
5029: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

Line 5283: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.

5279: close cur_proj_name;
5280:
5281: -- Bug # 4329284.
5282:
5283: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
5284: RAISE FND_API.G_EXC_ERROR;
5285: END IF;
5286: IF (p_debug_mode = 'Y') THEN
5287: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

Line 5311: PA_UTILS.ADD_MESSAGE('PA','PA_MV_DEL_SUBPROJ_VAL_FAIL');

5307: l_upd_prog_grp_status:=0;
5308: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(get_coming_in_lnk_info_rec.object_relationship_id,
5309: 'DROP');
5310: IF l_upd_prog_grp_status < 0 THEN
5311: PA_UTILS.ADD_MESSAGE('PA','PA_MV_DEL_SUBPROJ_VAL_FAIL');
5312: RAISE FND_API.G_EXC_ERROR;
5313: END IF;
5314: IF (p_debug_mode = 'Y') THEN
5315: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);