APPS.PA_PROJECT_DATES_PVT dependencies on PA_PROJECT_DATES_PVT

Line 1: PACKAGE BODY PA_PROJECT_DATES_PVT AS

1: PACKAGE BODY PA_PROJECT_DATES_PVT AS
2: /* $Header: PARMPDVB.pls 120.4 2008/06/26 09:55:37 jravisha ship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_DATES_PVT';

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

1: PACKAGE BODY PA_PROJECT_DATES_PVT AS
2: /* $Header: PARMPDVB.pls 120.4 2008/06/26 09:55:37 jravisha ship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_DATES_PVT';
6:
7:
8: -- API name : Update_Project_Dates
9: -- Type : Public

Line 73: pa_debug.debug('PA_PROJECT_DATES_PVT.Update_Project_Dates BEGIN');

69: where project_id = p_project_id;
70:
71: BEGIN
72: if (p_debug_mode = 'Y') then
73: pa_debug.debug('PA_PROJECT_DATES_PVT.Update_Project_Dates BEGIN');
74: end if;
75:
76: if p_commit = FND_API.G_TRUE then
77: savepoint update_project_dates_pvt;

Line 305: pa_debug.debug('PA_PROJECT_DATES_PVT.Update_Project_Dates END');

301: commit work;
302: end if;
303:
304: if (p_debug_mode = 'Y') then
305: pa_debug.debug('PA_PROJECT_DATES_PVT.Update_Project_Dates END');
306: end if;
307:
308: EXCEPTION
309: when FND_API.G_EXC_ERROR then

Line 319: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PVT',

315: if p_commit = FND_API.G_TRUE then
316: rollback to update_project_dates_pvt;
317: end if;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PVT',
320: p_procedure_name => 'Update_Project_Dates',
321: p_error_text => SUBSTRB(SQLERRM,1,240));
322: when OTHERS then
323: if p_commit = FND_API.G_TRUE then

Line 327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PVT',

323: if p_commit = FND_API.G_TRUE then
324: rollback to update_project_dates_pvt;
325: end if;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PVT',
328: p_procedure_name => 'Update_Project_Dates',
329: p_error_text => SUBSTRB(SQLERRM,1,240));
330: raise;
331: END UPDATE_PROJECT_DATES;

Line 334: END PA_PROJECT_DATES_PVT;

330: raise;
331: END UPDATE_PROJECT_DATES;
332:
333:
334: END PA_PROJECT_DATES_PVT;