DBA Data[Home] [Help]

APPS.PA_WORKPLAN_ATTR_PVT dependencies on PA_WORKPLAN_ATTR_PVT

Line 1: PACKAGE BODY PA_WORKPLAN_ATTR_PVT AS

1: PACKAGE BODY PA_WORKPLAN_ATTR_PVT AS
2: /* $Header: PAPRWPVB.pls 120.1 2005/08/19 16:46:07 mwasowic noship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_WORKPLAN_ATTR_PVT';

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

1: PACKAGE BODY PA_WORKPLAN_ATTR_PVT AS
2: /* $Header: PAPRWPVB.pls 120.1 2005/08/19 16:46:07 mwasowic noship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_WORKPLAN_ATTR_PVT';
6:
7:
8: -- API name : Create_Proj_Workplan_Attrs
9: -- Type : Private

Line 90: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Create_Proj_Workplan_Attrs BEGIN');

86:
87: BEGIN
88:
89: if (p_debug_mode = 'Y') then
90: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Create_Proj_Workplan_Attrs BEGIN');
91: end if;
92:
93: if p_commit = FND_API.G_TRUE then
94: savepoint create_proj_workplan_attrs_pvt;

Line 214: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Create_Proj_Workplan_Attrs END');

210: commit work;
211: end if;
212:
213: if (p_debug_mode = 'Y') then
214: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Create_Proj_Workplan_Attrs END');
215: end if;
216:
217: EXCEPTION
218: when FND_API.G_EXC_ERROR then

Line 228: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

224: if p_commit = FND_API.G_TRUE then
225: rollback to create_proj_workplan_attrs_pvt;
226: end if;
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
229: p_procedure_name => 'Create_Proj_Workplan_Attrs',
230: p_error_text => SUBSTRB(SQLERRM,1,240));
231: when OTHERS then
232: if p_commit = FND_API.G_TRUE then

Line 236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

232: if p_commit = FND_API.G_TRUE then
233: rollback to create_proj_workplan_attrs_pvt;
234: end if;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
237: p_procedure_name => 'Create_Proj_Workplan_Attrs',
238: p_error_text => SUBSTRB(SQLERRM,1,240));
239: raise;
240: END CREATE_PROJ_WORKPLAN_ATTRS;

Line 369: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Proj_Workplan_Attrs BEGIN');

365: BEGIN
366:
367:
368: if (p_debug_mode = 'Y') then
369: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Proj_Workplan_Attrs BEGIN');
370: end if;
371:
372: if (p_commit = FND_API.G_TRUE) then
373: savepoint update_proj_workplan_attrs_pvt;

Line 777: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Proj_Workplan_Attrs END');

773: commit work;
774: end if;
775:
776: if (p_debug_mode = 'Y') then
777: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Proj_Workplan_Attrs END');
778: end if;
779:
780: EXCEPTION
781: when FND_API.G_EXC_ERROR then

Line 791: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

787: if p_commit = FND_API.G_TRUE then
788: rollback to update_proj_workplan_attrs_pvt;
789: end if;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
792: p_procedure_name => 'Update_Proj_Workplan_Attrs',
793: p_error_text => SUBSTRB(SQLERRM,1,240));
794: when OTHERS then
795: if p_commit = FND_API.G_TRUE then

Line 799: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

795: if p_commit = FND_API.G_TRUE then
796: rollback to update_proj_workplan_attrs_pvt;
797: end if;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
800: p_procedure_name => 'Update_Proj_Workplan_Attrs',
801: p_error_text => SUBSTRB(SQLERRM,1,240));
802: raise;
803: END UPDATE_PROJ_WORKPLAN_ATTRS;

Line 848: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Structure_Name BEGIN');

844: l_dummy VARCHAR2(1);
845: BEGIN
846:
847: if (p_debug_mode = 'Y') then
848: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Structure_Name BEGIN');
849: end if;
850:
851: if p_commit = FND_API.G_TRUE then
852: savepoint update_structure_name_pvt;

Line 932: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Structure_Name END');

928: commit work;
929: end if;
930:
931: if (p_debug_mode = 'Y') then
932: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Update_Structure_Name END');
933: end if;
934:
935: EXCEPTION
936: when FND_API.G_EXC_ERROR then

Line 946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

942: if p_commit = FND_API.G_TRUE then
943: rollback to update_structure_name_pvt;
944: end if;
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
947: p_procedure_name => 'Update_Structure_Name',
948: p_error_text => SUBSTRB(SQLERRM,1,240));
949: when OTHERS then
950: if p_commit = FND_API.G_TRUE then

Line 954: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

950: if p_commit = FND_API.G_TRUE then
951: rollback to update_structure_name_pvt;
952: end if;
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
955: p_procedure_name => 'Update_Structure_Name',
956: p_error_text => SUBSTRB(SQLERRM,1,240));
957: raise;
958: END UPDATE_STRUCTURE_NAME;

Line 1001: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Delete_Proj_Workplan_Attrs BEGIN');

997: l_dummy VARCHAR2(1);
998:
999: BEGIN
1000: if (p_debug_mode = 'Y') then
1001: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Delete_Proj_Workplan_Attrs BEGIN');
1002: end if;
1003:
1004: if p_commit = FND_API.G_TRUE then
1005: savepoint delete_proj_workplan_attrs_pvt;

Line 1088: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Delete_Proj_Workplan_Attrs END');

1084: commit work;
1085: end if;
1086:
1087: if (p_debug_mode = 'Y') then
1088: pa_debug.debug('PA_WORKPLAN_ATTR_PVT.Delete_Proj_Workplan_Attrs END');
1089: end if;
1090:
1091: EXCEPTION
1092: when FND_API.G_EXC_ERROR then

Line 1102: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',

1098: if p_commit = FND_API.G_TRUE then
1099: rollback to delete_proj_workplan_attrs_pvt;
1100: end if;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PVT',
1103: p_procedure_name => 'Delete_Proj_Workplan_Attrs',
1104: p_error_text => SUBSTRB(SQLERRM,1,240));
1105: raise;
1106: END DELETE_PROJ_WORKPLAN_ATTRS;

Line 1108: END PA_WORKPLAN_ATTR_PVT;

1104: p_error_text => SUBSTRB(SQLERRM,1,240));
1105: raise;
1106: END DELETE_PROJ_WORKPLAN_ATTRS;
1107:
1108: END PA_WORKPLAN_ATTR_PVT;