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 1184: PA_UTILS.add_message('PA', 'PA_PS_NO_DEP_ON_SUMM');

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

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

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

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

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

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

3358: close cur_proj_name;
3359:
3360: -- Bug # 4329284.
3361:
3362: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3363: RAISE FND_API.G_EXC_ERROR;
3364: END IF;
3365: IF (p_debug_mode = 'Y') THEN
3366: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

Line 3664: -- 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.

3660: END IF;
3661:
3662: --Bug 3912783:
3663: IF (PA_RELATIONSHIP_UTILS.Check_proj_currency_identical(p_src_proj_id,p_dest_proj_id) = 'N') THEN
3664: -- 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.
3665: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PRJ_CURR','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.
3666: RAISE FND_API.G_EXC_ERROR;
3667: END IF;
3668: --end bug 3912783

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

3661:
3662: --Bug 3912783:
3663: IF (PA_RELATIONSHIP_UTILS.Check_proj_currency_identical(p_src_proj_id,p_dest_proj_id) = 'N') THEN
3664: -- 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.
3665: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PRJ_CURR','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.
3666: RAISE FND_API.G_EXC_ERROR;
3667: END IF;
3668: --end bug 3912783
3669:

Line 3764: -- 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.

3760: l_time_phase1 := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(l_src_struc_elem_ver_id);
3761: IF l_dest_wp_str_ver_id IS NOT NULL THEN
3762: l_time_phase2 := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(l_dest_wp_str_ver_id);
3763: IF (l_time_phase1 <> l_time_phase2) THEN
3764: -- 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.
3765: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_TIME_PHASE','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.
3766: RAISE FND_API.G_EXC_ERROR;
3767: END IF;
3768: END IF;

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

3761: IF l_dest_wp_str_ver_id IS NOT NULL THEN
3762: l_time_phase2 := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase(l_dest_wp_str_ver_id);
3763: IF (l_time_phase1 <> l_time_phase2) THEN
3764: -- 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.
3765: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_TIME_PHASE','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4871876.
3766: RAISE FND_API.G_EXC_ERROR;
3767: END IF;
3768: END IF;
3769: END IF;

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

3784: THEN
3785: IF l_src_period_duration.pa_period_set_name <> l_dest_period_duration.pa_period_set_name OR
3786: l_src_period_duration.pa_period_type <> l_dest_period_duration.pa_period_type
3787: THEN
3788: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_PA_CAL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3789: RAISE FND_API.G_EXC_ERROR;
3790: END IF;
3791:
3792: ELSIF l_time_phase1 = 'G' AND l_time_phase2 = 'G'

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

3793: THEN
3794: IF l_src_period_duration.gl_period_set_name <> l_dest_period_duration.gl_period_set_name OR
3795: l_src_period_duration.accounted_period_type <> l_dest_period_duration.accounted_period_type
3796: THEN
3797: PA_UTILS.ADD_MESSAGE('PA','PA_PS_LINK_DIFF_GL_CAL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3798: RAISE FND_API.G_EXC_ERROR;
3799: END IF;
3800: END IF;
3801: END IF;

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

3831: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id) = 'N' THEN --SMukka
3832:
3833: if (FND_MSG_PUB.count_msg = 0) then -- Fix for Bug # 4256435.
3834:
3835: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3836:
3837: end if; -- Fix for Bug # 4256435.
3838:
3839: RAISE FND_API.G_EXC_ERROR;

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

3845: -- 4473103 : Begin
3846: IF l_src_str_wp_enable_fl = 'Y' AND l_dest_wp_str_ver_id IS NOT NULL THEN
3847: l_create_relationship_ok := PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id,'WORKPLAN');
3848: IF l_create_relationship_ok = 'N' THEN
3849: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3850: RAISE FND_API.G_EXC_ERROR;
3851: END IF;
3852: END IF;
3853:

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

3853:
3854: 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
3855: l_create_relationship_ok := PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id,'FINANCIAL');
3856: IF l_create_relationship_ok = 'N' THEN
3857: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3858: RAISE FND_API.G_EXC_ERROR;
3859: END IF;
3860: END IF;
3861: -- 4473103 : End

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

3872: END IF;
3873: /* --bug 3983361
3874: IF p_validation_level > 0 THEN
3875: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id) = 'N' THEN --SMukka
3876: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3877: RAISE FND_API.G_EXC_ERROR;
3878: END IF;
3879: END IF;
3880: */

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

3939: END IF;
3940: /* --bug 3983361
3941: IF p_validation_level > 0 THEN
3942: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id, 'FINANCIAL') = 'N' THEN --SMukka
3943: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3944: RAISE FND_API.G_EXC_ERROR;
3945: END IF;
3946: END IF;
3947: */

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

4006: END IF;
4007: /* --bug 3983361
4008: IF p_validation_level > 0 THEN
4009: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id) = 'N' THEN --SMukka
4010: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
4011: RAISE FND_API.G_EXC_ERROR;
4012: END IF;
4013: END IF;
4014: */

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

4075: END IF;
4076: /* --bug 3983361
4077: IF p_validation_level > 0 THEN
4078: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id, 'FINANCIAL') = 'N' THEN --SMukka
4079: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
4080: RAISE FND_API.G_EXC_ERROR;
4081: END IF;
4082: END IF;
4083: */

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

4563: OPEN get_lnk_obj_rel_attr(p_object_relationships_id);
4564: FETCH get_lnk_obj_rel_attr INTO get_lnk_obj_rel_attr_rec;
4565: IF get_lnk_obj_rel_attr%NOTFOUND THEN
4566: CLOSE get_lnk_obj_rel_attr;
4567: PA_UTILS.ADD_MESSAGE('PA','PA_NO_RECORD_VERSION_NUMBER');
4568: x_msg_data := 'PA_NO_RECORD_VERSION_NUMBER';
4569: RAISE FND_API.G_EXC_ERROR;
4570: END IF;
4571: --

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

4587: OPEN get_src_task_ver_id(get_lnk_obj_rel_attr_rec.object_id_from1);
4588: FETCH get_src_task_ver_id INTO get_src_task_ver_id_rec;
4589: IF get_src_task_ver_id%NOTFOUND THEN
4590: CLOSE get_src_task_ver_id;
4591: PA_UTILS.ADD_MESSAGE('PA','PA_NO_RECORD_VERSION_NUMBER');
4592: x_msg_data := 'PA_NO_RECORD_VERSION_NUMBER';
4593: RAISE FND_API.G_EXC_ERROR;
4594: END IF;
4595: --

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

4631: BEGIN
4632: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(get_lnk_info_rec.lnk_obj_rel_id,
4633: 'DROP');
4634: IF l_upd_prog_grp_status < 0 THEN
4635: PA_UTILS.ADD_MESSAGE('PA','PA_DEL_SUBPROJ_VAL_FAIL');
4636: RAISE FND_API.G_EXC_ERROR;
4637: END IF;
4638: IF (p_debug_mode = 'Y') THEN
4639: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

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

4699: OPEN get_rec_ver_num(get_lnk_info_rec.lnk_task_ver_id);
4700: FETCH get_rec_ver_num INTO get_rec_ver_num_rec;
4701: IF get_rec_ver_num%NOTFOUND THEN
4702: CLOSE get_rec_ver_num;
4703: PA_UTILS.ADD_MESSAGE('PA','PA_NO_RECORD_VERSION_NUMBER');
4704: x_msg_data := 'PA_NO_RECORD_VERSION_NUMBER';
4705: RAISE FND_API.G_EXC_ERROR;
4706: END IF;
4707: --

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

5043: BEGIN
5044: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(l_object_relationship_id,
5045: 'ADD');
5046: IF l_upd_prog_grp_status < 0 THEN
5047: PA_UTILS.ADD_MESSAGE('PA','PA_CP_SUBPROJ_VAL_FAIL');
5048: RAISE FND_API.G_EXC_ERROR;
5049: END IF;
5050: IF (p_debug_mode = 'Y') THEN
5051: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

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

5301: close cur_proj_name;
5302:
5303: -- Bug # 4329284.
5304:
5305: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
5306: RAISE FND_API.G_EXC_ERROR;
5307: END IF;
5308: IF (p_debug_mode = 'Y') THEN
5309: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

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

5329: l_upd_prog_grp_status:=0;
5330: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(get_coming_in_lnk_info_rec.object_relationship_id,
5331: 'DROP');
5332: IF l_upd_prog_grp_status < 0 THEN
5333: PA_UTILS.ADD_MESSAGE('PA','PA_MV_DEL_SUBPROJ_VAL_FAIL');
5334: RAISE FND_API.G_EXC_ERROR;
5335: END IF;
5336: IF (p_debug_mode = 'Y') THEN
5337: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);