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_RELATIONSHIP_PUB

Line 3346: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(x_object_relationship_id,

3342:
3343: --Bug No 3450684
3344: BEGIN
3345: IF p_validation_level > 0 THEN
3346: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(x_object_relationship_id,
3347: 'ADD');
3348: IF l_upd_prog_grp_status < 0 THEN
3349:
3350: -- Bug # 4329284.

Line 3366: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

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);
3367: END IF;
3368: END IF;
3369: EXCEPTION
3370:

Line 3382: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));

3378:
3379: WHEN OTHERS THEN
3380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
3381: p_procedure_name => 'Insert_Subproject_Association',
3382: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
3383: RAISE FND_API.G_EXC_ERROR;
3384: END;
3385: --
3386: IF (p_debug_mode = 'Y') THEN

Line 4632: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(get_lnk_info_rec.lnk_obj_rel_id,

4628: END IF;
4629: --Loop thru the above cursor to get the second part of the link
4630: --Bug No 3450684
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;

Line 4639: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

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);
4640: END IF;
4641: EXCEPTION
4642:
4643: -- Begin fix for Bug # 4485908.

Line 4654: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));

4650:
4651: WHEN OTHERS THEN
4652: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
4653: p_procedure_name => 'Delete_SubProject_Association',
4654: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
4655: RAISE FND_API.G_EXC_ERROR;
4656: END;
4657: --
4658:

Line 4659: --PA_RELATIONSHIP_PUB.Delete_Relationship(porb.object_relationship_id);--table handler

4655: RAISE FND_API.G_EXC_ERROR;
4656: END;
4657: --
4658:
4659: --PA_RELATIONSHIP_PUB.Delete_Relationship(porb.object_relationship_id);--table handler
4660: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
4661: p_object_relationship_id => get_lnk_info_rec.lnk_obj_rel_id
4662: ,p_object_type_from => NULL
4663: ,p_object_id_from1 => NULL

Line 5044: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(l_object_relationship_id,

5040: END IF;
5041: --
5042: --Bug No 3450684
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;

Line 5051: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

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);
5052: END IF;
5053: EXCEPTION
5054:
5055: -- Begin fix for Bug # 4485908.

Line 5066: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));

5062:
5063: WHEN OTHERS THEN
5064: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5065: p_procedure_name => 'Copy_OG_Lnk_For_Subproj_Ass',
5066: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5067: RAISE FND_API.G_EXC_ERROR;
5068: END;
5069: END IF;
5070: --

Line 5289: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(x_object_relationship_id,

5285: --
5286: --Bug No 3450684
5287: BEGIN
5288: l_upd_prog_grp_status:=0;
5289: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(x_object_relationship_id,
5290: 'ADD');
5291: IF l_upd_prog_grp_status < 0 THEN
5292:
5293: -- Bug # 4329284.

Line 5309: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

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);
5310: END IF;
5311: EXCEPTION
5312:
5313: -- Begin fix for Bug # 4485908.

Line 5324: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));

5320:
5321: WHEN OTHERS THEN
5322: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5323: p_procedure_name => 'Insert_Subproject_Association',
5324: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5325: RAISE FND_API.G_EXC_ERROR;
5326: END;
5327:
5328: BEGIN

Line 5330: l_upd_prog_grp_status:=PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS(get_coming_in_lnk_info_rec.object_relationship_id,

5326: END;
5327:
5328: BEGIN
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;

Line 5337: pa_debug.debug('Return Status PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS=> '||l_upd_prog_grp_status);

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);
5338: END IF;
5339: EXCEPTION
5340:
5341: -- Begin fix for Bug # 4485908.

Line 5352: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));

5348:
5349: WHEN OTHERS THEN
5350: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5351: p_procedure_name => 'Move_CI_Lnk_For_subproj_step2',
5352: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5353: RAISE FND_API.G_EXC_ERROR;
5354: END;
5355: --
5356: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(