DBA Data[Home] [Help]

APPS.PA_PROJECT_DATES_PUB dependencies on PA_PROJECT_DATES_PUB

Line 1: PACKAGE BODY PA_PROJECT_DATES_PUB AS

1: PACKAGE BODY PA_PROJECT_DATES_PUB AS
2: /* $Header: PARMPDPB.pls 120.5 2007/02/06 09:51:55 dthakker ship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_DATES_PUB';

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

1: PACKAGE BODY PA_PROJECT_DATES_PUB AS
2: /* $Header: PARMPDPB.pls 120.5 2007/02/06 09:51:55 dthakker ship $ */
3:
4: -- Global constant
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_DATES_PUB';
6:
7:
8: -- API name : Copy_Project_Dates
9: -- Type : Public

Line 282: pa_debug.init_err_stack('PA_PROJECT_DATES_PUB.Copy_Project_Dates');

278: l_task_dates TASK_DATES_TBL_TYPE;
279: -- End of addition for bug 5665772
280:
281: BEGIN
282: pa_debug.init_err_stack('PA_PROJECT_DATES_PUB.Copy_Project_Dates');
283:
284: if (p_debug_mode = 'Y') then
285: pa_debug.debug('PA_PROJECT_DATES_PUB.Copy_Project_Dates BEGIN');
286: end if;

Line 285: pa_debug.debug('PA_PROJECT_DATES_PUB.Copy_Project_Dates BEGIN');

281: BEGIN
282: pa_debug.init_err_stack('PA_PROJECT_DATES_PUB.Copy_Project_Dates');
283:
284: if (p_debug_mode = 'Y') then
285: pa_debug.debug('PA_PROJECT_DATES_PUB.Copy_Project_Dates BEGIN');
286: end if;
287:
288: if p_commit = FND_API.G_TRUE then
289: savepoint copy_project_dates;

Line 492: PA_PROJECT_DATES_PUB.Update_Project_Dates (

488: OPEN get_proj_record_ver_number;
489: FETCH get_proj_record_ver_number INTO l_proj_record_version_number;
490: CLOSE get_proj_record_ver_number;
491:
492: PA_PROJECT_DATES_PUB.Update_Project_Dates (
493: p_init_msg_list => p_init_msg_list
494: ,p_commit => FND_API.G_FALSE
495: ,p_validate_only => FND_API.G_FALSE -- Bug 2786525
496: ,p_calling_module => p_calling_module

Line 834: -- PA_PROJECT_DATES_PUB.Update_Project_Dates (

830: -- l_proj_start_date := l_proj_start_date + p_buffer;
831: -- l_proj_finish_date := l_proj_finish_date + p_buffer;
832: -- end if;
833:
834: -- PA_PROJECT_DATES_PUB.Update_Project_Dates (
835: -- p_init_msg_list => p_init_msg_list
836: -- ,p_commit => FND_API.G_FALSE
837: -- ,p_validate_only => p_validate_only
838: -- ,p_calling_module => p_calling_module

Line 871: pa_debug.debug('PA_PROJECT_DATES_PUB.Copy_Project_Dates END');

867: commit work;
868: end if;
869:
870: if (p_debug_mode = 'Y') then
871: pa_debug.debug('PA_PROJECT_DATES_PUB.Copy_Project_Dates END');
872: end if;
873:
874: EXCEPTION
875: when FND_API.G_EXC_ERROR then

Line 885: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',

881: if p_commit = FND_API.G_TRUE then
882: rollback to copy_project_dates;
883: end if;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
886: p_procedure_name => 'Copy_Project_Dates',
887: p_error_text => SUBSTRB(SQLERRM,1,240));
888: when OTHERS then
889: if p_commit = FND_API.G_TRUE then

Line 893: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',

889: if p_commit = FND_API.G_TRUE then
890: rollback to copy_project_dates;
891: end if;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
894: p_procedure_name => 'Copy_Project_Dates',
895: p_error_text => SUBSTRB(SQLERRM,1,240));
896: raise;
897: END COPY_PROJECT_DATES;

Line 951: pa_debug.init_err_stack('PA_PROJECT_DATES_PUB.Update_Project_Dates');

947: l_data VARCHAR2(250);
948: l_msg_index_out NUMBER;
949:
950: BEGIN
951: pa_debug.init_err_stack('PA_PROJECT_DATES_PUB.Update_Project_Dates');
952:
953: if (p_debug_mode = 'Y') then
954: pa_debug.debug('PA_PROJECT_DATES_PUB.Update_Project_Dates BEGIN');
955: end if;

Line 954: pa_debug.debug('PA_PROJECT_DATES_PUB.Update_Project_Dates BEGIN');

950: BEGIN
951: pa_debug.init_err_stack('PA_PROJECT_DATES_PUB.Update_Project_Dates');
952:
953: if (p_debug_mode = 'Y') then
954: pa_debug.debug('PA_PROJECT_DATES_PUB.Update_Project_Dates BEGIN');
955: end if;
956:
957: if p_commit = FND_API.G_TRUE then
958: savepoint update_project_dates;

Line 1029: pa_debug.debug('PA_PROJECT_DATES_PUB.Update_Project_Dates END');

1025: commit work;
1026: end if;
1027:
1028: if (p_debug_mode = 'Y') then
1029: pa_debug.debug('PA_PROJECT_DATES_PUB.Update_Project_Dates END');
1030: end if;
1031:
1032: EXCEPTION
1033: when FND_API.G_EXC_ERROR then

Line 1043: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',

1039: if p_commit = FND_API.G_TRUE then
1040: rollback to update_project_dates;
1041: end if;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
1044: p_procedure_name => 'Update_Project_Dates',
1045: p_error_text => SUBSTRB(SQLERRM,1,240));
1046: when OTHERS then
1047: if p_commit = FND_API.G_TRUE then

Line 1051: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',

1047: if p_commit = FND_API.G_TRUE then
1048: rollback to update_project_dates;
1049: end if;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
1052: p_procedure_name => 'Update_Project_Dates',
1053: p_error_text => SUBSTRB(SQLERRM,1,240));
1054: raise;
1055: END UPDATE_PROJECT_DATES;

Line 1058: END PA_PROJECT_DATES_PUB;

1054: raise;
1055: END UPDATE_PROJECT_DATES;
1056:
1057:
1058: END PA_PROJECT_DATES_PUB;