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_WORKPLAN_ATTR_PUB dependencies on PA_WORKPLAN_ATTR_PUB

Line 1: PACKAGE BODY PA_WORKPLAN_ATTR_PUB AS

1: PACKAGE BODY PA_WORKPLAN_ATTR_PUB AS
2: /* $Header: PAPRWPPB.pls 120.4 2007/02/06 09:41:45 dthakker noship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_WORKPLAN_ATTR_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_WORKPLAN_ATTR_PUB';

1: PACKAGE BODY PA_WORKPLAN_ATTR_PUB AS
2: /* $Header: PAPRWPPB.pls 120.4 2007/02/06 09:41:45 dthakker noship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_WORKPLAN_ATTR_PUB';
6:
7:
8: -- API name : Create_Proj_Workplan_Attrs
9: -- Type : Public

Line 93: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs');

89: l_approver_source_type NUMBER;
90: l_lifecycle_id NUMBER := NULL;
91: l_current_lifecycle_phase_id NUMBER;
92: BEGIN
93: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs');
94:
95: if (p_debug_mode = 'Y') then
96: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs BEGIN');
97: end if;

Line 96: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs BEGIN');

92: BEGIN
93: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs');
94:
95: if (p_debug_mode = 'Y') then
96: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs BEGIN');
97: end if;
98:
99: if p_commit = FND_API.G_TRUE then
100: savepoint create_proj_workplan_attrs;

Line 237: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs END');

233: commit work;
234: end if;
235:
236: if (p_debug_mode = 'Y') then
237: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs END');
238: end if;
239:
240: EXCEPTION
241: when FND_API.G_EXC_ERROR then

Line 251: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

247: if p_commit = FND_API.G_TRUE then
248: rollback to create_proj_workplan_attrs;
249: end if;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
252: p_procedure_name => 'Create_Proj_Workplan_Attrs',
253: p_error_text => SUBSTRB(SQLERRM,1,240));
254: when OTHERS then
255: if p_commit = FND_API.G_TRUE then

Line 259: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

255: if p_commit = FND_API.G_TRUE then
256: rollback to create_proj_workplan_attrs;
257: end if;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
260: p_procedure_name => 'Create_Proj_Workplan_Attrs',
261: p_error_text => SUBSTRB(SQLERRM,1,240));
262: raise;
263: END CREATE_PROJ_WORKPLAN_ATTRS;

Line 360: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs');

356: l_approver_source_type NUMBER;
357: l_lifecycle_id NUMBER := NULL;
358: l_current_lifecycle_phase_id NUMBER;
359: BEGIN
360: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs');
361:
362: if (p_debug_mode = 'Y') then
363: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs BEGIN');
364: end if;

Line 363: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs BEGIN');

359: BEGIN
360: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs');
361:
362: if (p_debug_mode = 'Y') then
363: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs BEGIN');
364: end if;
365:
366: if p_commit = FND_API.G_TRUE then
367: savepoint update_proj_workplan_attrs;

Line 532: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs END');

528: commit work;
529: end if;
530:
531: if (p_debug_mode = 'Y') then
532: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs END');
533: end if;
534:
535: EXCEPTION
536: when FND_API.G_EXC_ERROR then

Line 546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

542: if p_commit = FND_API.G_TRUE then
543: rollback to update_proj_workplan_attrs;
544: end if;
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
547: p_procedure_name => 'Update_Proj_Workplan_Attrs',
548: p_error_text => SUBSTRB(SQLERRM,1,240));
549: when OTHERS then
550: if p_commit = FND_API.G_TRUE then

Line 554: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

550: if p_commit = FND_API.G_TRUE then
551: rollback to update_proj_workplan_attrs;
552: end if;
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
555: p_procedure_name => 'Update_Proj_Workplan_Attrs',
556: p_error_text => SUBSTRB(SQLERRM,1,240));
557: raise;
558: END UPDATE_PROJ_WORKPLAN_ATTRS;

Line 606: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name');

602: l_msg_data VARCHAR2(2000); --precision changed from 250 to 2000 for bug 4093600
603: l_data VARCHAR2(2000); --precision changed from 250 to 2000 for bug 4093600
604: l_msg_index_out NUMBER;
605: BEGIN
606: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name');
607:
608: if (p_debug_mode = 'Y') then
609: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name BEGIN');
610: end if;

Line 609: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name BEGIN');

605: BEGIN
606: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name');
607:
608: if (p_debug_mode = 'Y') then
609: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name BEGIN');
610: end if;
611:
612: if p_commit = FND_API.G_TRUE then
613: savepoint update_structure_name;

Line 685: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name END');

681: commit work;
682: end if;
683:
684: if (p_debug_mode = 'Y') then
685: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name END');
686: end if;
687:
688: EXCEPTION
689: when FND_API.G_EXC_ERROR then

Line 699: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

695: if p_commit = FND_API.G_TRUE then
696: rollback to update_structure_name;
697: end if;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
700: p_procedure_name => 'Update_Structure_Name',
701: p_error_text => SUBSTRB(SQLERRM,1,240));
702: when OTHERS then
703: if p_commit = FND_API.G_TRUE then

Line 707: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

703: if p_commit = FND_API.G_TRUE then
704: rollback to update_structure_name;
705: end if;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
708: p_procedure_name => 'Update_Structure_Name',
709: p_error_text => SUBSTRB(SQLERRM,1,240));
710: raise;
711: END UPDATE_STRUCTURE_NAME;

Line 759: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs');

755: l_msg_data VARCHAR2(2000); --precision changed from 250 to 2000 for bug 4093600
756: l_data VARCHAR2(2000); --precision changed from 250 to 2000 for bug 4093600
757: l_msg_index_out NUMBER;
758: BEGIN
759: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs');
760:
761: if (p_debug_mode = 'Y') then
762: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs BEGIN');
763: end if;

Line 762: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs BEGIN');

758: BEGIN
759: pa_debug.init_err_stack('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs');
760:
761: if (p_debug_mode = 'Y') then
762: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs BEGIN');
763: end if;
764:
765: if p_commit = FND_API.G_TRUE then
766: savepoint delete_proj_workplan_attrs;

Line 813: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs END');

809: commit work;
810: end if;
811:
812: if (p_debug_mode = 'Y') then
813: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs END');
814: end if;
815:
816: EXCEPTION
817: when FND_API.G_EXC_ERROR then

Line 827: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

823: if p_commit = FND_API.G_TRUE then
824: rollback to delete_proj_workplan_attrs;
825: end if;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
828: p_procedure_name => 'Delete_Proj_Workplan_Attrs',
829: p_error_text => SUBSTRB(SQLERRM,1,240));
830: when OTHERS then
831: if p_commit = FND_API.G_TRUE then

Line 835: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

831: if p_commit = FND_API.G_TRUE then
832: rollback to delete_proj_workplan_attrs;
833: end if;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
836: p_procedure_name => 'Delete_Proj_Workplan_Attrs',
837: p_error_text => SUBSTRB(SQLERRM,1,240));
838: raise;
839: END DELETE_PROJ_WORKPLAN_ATTRS;

Line 842: END PA_WORKPLAN_ATTR_PUB;

838: raise;
839: END DELETE_PROJ_WORKPLAN_ATTRS;
840:
841:
842: END PA_WORKPLAN_ATTR_PUB;