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_PUB dependencies on PA_RELATIONSHIP_PUB

Line 1: package body PA_RELATIONSHIP_PUB as

1: package body PA_RELATIONSHIP_PUB as
2: /*$Header: PAXRELPB.pls 120.6.12010000.4 2008/11/07 05:25:53 rballamu ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_RELATIONSHIP_PUB';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_RELATIONSHIP_PUB';

1: package body PA_RELATIONSHIP_PUB as
2: /*$Header: PAXRELPB.pls 120.6.12010000.4 2008/11/07 05:25:53 rballamu ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_RELATIONSHIP_PUB';
5:
6: -- API name : Create_Relationship
7: -- Type : Public Procedure
8: -- Pre-reqs : None

Line 116: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP');

112: l_struc_ver_id_to NUMBER;
113: l_task_ver_id_to NUMBER;
114:
115: BEGIN
116: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP');
117:
118: IF (p_debug_mode = 'Y') THEN
119: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP begin');
120: END IF;

Line 119: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP begin');

115: BEGIN
116: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP');
117:
118: IF (p_debug_mode = 'Y') THEN
119: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP begin');
120: END IF;
121:
122: IF (p_commit = FND_API.G_TRUE) THEN
123: savepoint create_relationship;

Line 357: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP END');

353: COMMIT;
354: END IF;
355:
356: IF (p_debug_mode = 'Y') THEN
357: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP END');
358: END IF;
359:
360: EXCEPTION
361: when FND_API.G_EXC_ERROR then

Line 371: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

367: if p_commit = FND_API.G_TRUE then
368: rollback to create_relationship;
369: end if;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
372: p_procedure_name => 'CREATE_RELATIONSHIP',
373: p_error_text => SUBSTRB(SQLERRM,1,240));
374: when OTHERS then
375: if p_commit = FND_API.G_TRUE then

Line 441: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP');

437: l_msg_index_out NUMBER;
438: l_error_msg_code VARCHAR2(250);
439:
440: BEGIN
441: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP');
442:
443: IF (p_debug_mode = 'Y') THEN
444: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP begin');
445: END IF;

Line 444: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP begin');

440: BEGIN
441: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP');
442:
443: IF (p_debug_mode = 'Y') THEN
444: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP begin');
445: END IF;
446:
447: IF (p_commit = FND_API.G_TRUE) THEN
448: savepoint delete_relationship;

Line 503: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

499: if p_commit = FND_API.G_TRUE then
500: rollback to delete_relationship;
501: end if;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
504: p_procedure_name => 'DELETE_RELATIONSHIP',
505: p_error_text => SUBSTRB(SQLERRM,1,240));
506: when OTHERS then
507: if p_commit = FND_API.G_TRUE then

Line 605: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY');

601: AND element_version_id = p_src_task_ver_id
602: AND object_type = 'PA_TASKS';
603:
604: BEGIN
605: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY');
606:
607: IF (p_debug_mode = 'Y') THEN
608: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY begin');
609: END IF;

Line 608: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY begin');

604: BEGIN
605: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY');
606:
607: IF (p_debug_mode = 'Y') THEN
608: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY begin');
609: END IF;
610:
611: IF (p_commit = FND_API.G_TRUE) THEN
612: savepoint create_dependency;

Line 767: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY END');

763: COMMIT;
764: END IF;
765:
766: IF (p_debug_mode = 'Y') THEN
767: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_DEPENDENCY END');
768: END IF;
769:
770: EXCEPTION
771: when FND_API.G_EXC_ERROR then

Line 781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

777: if p_commit = FND_API.G_TRUE then
778: rollback to create_dependency;
779: end if;
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
782: p_procedure_name => 'CREATE_DEPENDENCY',
783: p_error_text => SUBSTRB(SQLERRM,1,240));
784: when OTHERS then
785: if p_commit = FND_API.G_TRUE then

Line 855: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY');

851: l_data VARCHAR2(250);
852: l_msg_index_out NUMBER;
853: l_error_msg_code VARCHAR2(250);
854: BEGIN
855: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY');
856:
857: IF (p_debug_mode = 'Y') THEN
858: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY begin');
859: END IF;

Line 858: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY begin');

854: BEGIN
855: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY');
856:
857: IF (p_debug_mode = 'Y') THEN
858: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY begin');
859: END IF;
860:
861: IF (p_commit = FND_API.G_TRUE) THEN
862: savepoint update_dependency;

Line 917: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY END');

913: COMMIT;
914: END IF;
915:
916: IF (p_debug_mode = 'Y') THEN
917: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_DEPENDENCY END');
918: END IF;
919:
920: EXCEPTION
921: when FND_API.G_EXC_ERROR then

Line 931: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

927: if p_commit = FND_API.G_TRUE then
928: rollback to update_dependency;
929: end if;
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
932: p_procedure_name => 'UPDATE_DEPENDENCY',
933: p_error_text => SUBSTRB(SQLERRM,1,240));
934: when OTHERS then
935: if p_commit = FND_API.G_TRUE then

Line 996: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY');

992: l_data VARCHAR2(250);
993: l_msg_index_out NUMBER;
994: l_error_msg_code VARCHAR2(250);
995: BEGIN
996: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY');
997:
998: IF (p_debug_mode = 'Y') THEN
999: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY begin');
1000: END IF;

Line 999: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY begin');

995: BEGIN
996: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY');
997:
998: IF (p_debug_mode = 'Y') THEN
999: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY begin');
1000: END IF;
1001:
1002: IF (p_commit = FND_API.G_TRUE) THEN
1003: savepoint delete_dependency;

Line 1054: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY END');

1050: COMMIT;
1051: END IF;
1052:
1053: IF (p_debug_mode = 'Y') THEN
1054: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_DEPENDENCY END');
1055: END IF;
1056: EXCEPTION
1057: when FND_API.G_EXC_ERROR then
1058: if p_commit = FND_API.G_TRUE then

Line 1067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

1063: if p_commit = FND_API.G_TRUE then
1064: rollback to delete_dependency;
1065: end if;
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1068: p_procedure_name => 'DELETE_DEPENDENCY',
1069: p_error_text => SUBSTRB(SQLERRM,1,240));
1070: when OTHERS then
1071: if p_commit = FND_API.G_TRUE then

Line 1150: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION');

1146: l_dest_proj_id NUMBER:=0;
1147: l_src_proj_id NUMBER:=0;
1148: BEGIN
1149: --
1150: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION');
1151: --
1152: IF (p_debug_mode = 'Y') THEN
1153: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION begin');
1154: END IF;

Line 1153: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION begin');

1149: --
1150: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION');
1151: --
1152: IF (p_debug_mode = 'Y') THEN
1153: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION begin');
1154: END IF;
1155: --
1156: IF (p_commit = FND_API.G_TRUE) THEN
1157: savepoint create_subproject_association;

Line 1231: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION END');

1227: COMMIT;
1228: END IF;
1229: --
1230: IF (p_debug_mode = 'Y') THEN
1231: pa_debug.debug('PA_RELATIONSHIP_PUB.CREATE_SUBPROJECT_ASSOCIATION END');
1232: END IF;
1233: --
1234: EXCEPTION
1235: when FND_API.G_EXC_ERROR then

Line 1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

1241: if p_commit = FND_API.G_TRUE then
1242: rollback to create_subproject_association;
1243: end if;
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1246: p_procedure_name => 'CREATE_SUBPROJECT_ASSOCIATION',
1247: p_error_text => SUBSTRB(SQLERRM,1,240));
1248: when OTHERS then
1249: if p_commit = FND_API.G_TRUE then

Line 1319: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_SUBPROJECT_ASSOCIATION');

1315: l_src_proj_id NUMBER:=0;
1316: --
1317: BEGIN
1318: --
1319: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_SUBPROJECT_ASSOCIATION');
1320: --
1321: IF (p_debug_mode = 'Y') THEN
1322: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION begin');
1323: END IF;

Line 1322: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION begin');

1318: --
1319: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_SUBPROJECT_ASSOCIATION');
1320: --
1321: IF (p_debug_mode = 'Y') THEN
1322: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION begin');
1323: END IF;
1324: --
1325: IF (p_commit = FND_API.G_TRUE) THEN
1326: savepoint Update_Subproject_Association;

Line 1375: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION END');

1371: COMMIT;
1372: END IF;
1373: --
1374: IF (p_debug_mode = 'Y') THEN
1375: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION END');
1376: END IF;
1377: --
1378: EXCEPTION
1379: when FND_API.G_EXC_ERROR then

Line 1389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

1385: if p_commit = FND_API.G_TRUE then
1386: rollback to Update_Subproject_Association;
1387: end if;
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1390: p_procedure_name => 'UPDATE_SUBPROJECT_ASSOCIATION',
1391: p_error_text => SUBSTRB(SQLERRM,1,240));
1392: when OTHERS then
1393: if p_commit = FND_API.G_TRUE then

Line 1459: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_SUBPROJECT_ASSOCIATION');

1455: l_src_proj_id NUMBER:=0;
1456: --
1457: BEGIN
1458: --
1459: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_SUBPROJECT_ASSOCIATION');
1460: --
1461: IF (p_debug_mode = 'Y') THEN
1462: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION begin');
1463: END IF;

Line 1462: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION begin');

1458: --
1459: pa_debug.init_err_stack ('PA_RELATIONSHIP_PUB.DELETE_SUBPROJECT_ASSOCIATION');
1460: --
1461: IF (p_debug_mode = 'Y') THEN
1462: pa_debug.debug('PA_RELATIONSHIP_PUB.UPDATE_SUBPROJECT_ASSOCIATION begin');
1463: END IF;
1464: --
1465: IF (p_commit = FND_API.G_TRUE) THEN
1466: savepoint Delete_SubProject_Association;

Line 1512: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_SUBPROJECT_ASSOCIATION END');

1508: COMMIT;
1509: END IF;
1510: --
1511: IF (p_debug_mode = 'Y') THEN
1512: pa_debug.debug('PA_RELATIONSHIP_PUB.DELETE_SUBPROJECT_ASSOCIATION END');
1513: END IF;
1514: --
1515: EXCEPTION
1516: when FND_API.G_EXC_ERROR then

Line 1526: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',

1522: if p_commit = FND_API.G_TRUE then
1523: rollback to Delete_SubProject_Association;
1524: end if;
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PUB',
1527: p_procedure_name => 'DELETE_SUBPROJECT_ASSOCIATION',
1528: p_error_text => SUBSTRB(SQLERRM,1,240));
1529: when OTHERS then
1530: if p_commit = FND_API.G_TRUE then

Line 2843: end PA_RELATIONSHIP_PUB;

2839: raise;
2840:
2841: end UPDATE_PROGRAM_GROUPS;
2842:
2843: end PA_RELATIONSHIP_PUB;