DBA Data[Home] [Help]

APPS.PA_PROGRESS_CLIENT_EXTN dependencies on FND_API

Line 47: p_project_id IN NUMBER := FND_API.g_miss_num ,

43:
44:
45:
46: PROCEDURE GET_TASK_RES_OVERRIDE_INFO(
47: p_project_id IN NUMBER := FND_API.g_miss_num ,
48: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
49: p_structure_version_id IN NUMBER := FND_API.g_miss_num ,
50: p_object_type IN VARCHAR2 := FND_API.g_miss_char ,
51: p_object_id IN NUMBER := FND_API.g_miss_num ,

Line 49: p_structure_version_id IN NUMBER := FND_API.g_miss_num ,

45:
46: PROCEDURE GET_TASK_RES_OVERRIDE_INFO(
47: p_project_id IN NUMBER := FND_API.g_miss_num ,
48: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
49: p_structure_version_id IN NUMBER := FND_API.g_miss_num ,
50: p_object_type IN VARCHAR2 := FND_API.g_miss_char ,
51: p_object_id IN NUMBER := FND_API.g_miss_num ,
52: p_object_version_id IN NUMBER := FND_API.g_miss_num ,
53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,

Line 50: p_object_type IN VARCHAR2 := FND_API.g_miss_char ,

46: PROCEDURE GET_TASK_RES_OVERRIDE_INFO(
47: p_project_id IN NUMBER := FND_API.g_miss_num ,
48: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
49: p_structure_version_id IN NUMBER := FND_API.g_miss_num ,
50: p_object_type IN VARCHAR2 := FND_API.g_miss_char ,
51: p_object_id IN NUMBER := FND_API.g_miss_num ,
52: p_object_version_id IN NUMBER := FND_API.g_miss_num ,
53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,
54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,

Line 51: p_object_id IN NUMBER := FND_API.g_miss_num ,

47: p_project_id IN NUMBER := FND_API.g_miss_num ,
48: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
49: p_structure_version_id IN NUMBER := FND_API.g_miss_num ,
50: p_object_type IN VARCHAR2 := FND_API.g_miss_char ,
51: p_object_id IN NUMBER := FND_API.g_miss_num ,
52: p_object_version_id IN NUMBER := FND_API.g_miss_num ,
53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,
54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,
55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,

Line 52: p_object_version_id IN NUMBER := FND_API.g_miss_num ,

48: p_structure_type IN VARCHAR2 := 'WORKPLAN' ,
49: p_structure_version_id IN NUMBER := FND_API.g_miss_num ,
50: p_object_type IN VARCHAR2 := FND_API.g_miss_char ,
51: p_object_id IN NUMBER := FND_API.g_miss_num ,
52: p_object_version_id IN NUMBER := FND_API.g_miss_num ,
53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,
54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,
55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,
56: p_estimated_start_date IN DATE := FND_API.g_miss_date ,

Line 53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,

49: p_structure_version_id IN NUMBER := FND_API.g_miss_num ,
50: p_object_type IN VARCHAR2 := FND_API.g_miss_char ,
51: p_object_id IN NUMBER := FND_API.g_miss_num ,
52: p_object_version_id IN NUMBER := FND_API.g_miss_num ,
53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,
54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,
55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,
56: p_estimated_start_date IN DATE := FND_API.g_miss_date ,
57: p_estimated_finish_date IN DATE := FND_API.g_miss_date ,

Line 54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,

50: p_object_type IN VARCHAR2 := FND_API.g_miss_char ,
51: p_object_id IN NUMBER := FND_API.g_miss_num ,
52: p_object_version_id IN NUMBER := FND_API.g_miss_num ,
53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,
54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,
55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,
56: p_estimated_start_date IN DATE := FND_API.g_miss_date ,
57: p_estimated_finish_date IN DATE := FND_API.g_miss_date ,
58: p_actual_start_date IN DATE := FND_API.g_miss_date ,

Line 55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,

51: p_object_id IN NUMBER := FND_API.g_miss_num ,
52: p_object_version_id IN NUMBER := FND_API.g_miss_num ,
53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,
54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,
55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,
56: p_estimated_start_date IN DATE := FND_API.g_miss_date ,
57: p_estimated_finish_date IN DATE := FND_API.g_miss_date ,
58: p_actual_start_date IN DATE := FND_API.g_miss_date ,
59: p_actual_finish_date IN DATE := FND_API.g_miss_date ,

Line 56: p_estimated_start_date IN DATE := FND_API.g_miss_date ,

52: p_object_version_id IN NUMBER := FND_API.g_miss_num ,
53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,
54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,
55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,
56: p_estimated_start_date IN DATE := FND_API.g_miss_date ,
57: p_estimated_finish_date IN DATE := FND_API.g_miss_date ,
58: p_actual_start_date IN DATE := FND_API.g_miss_date ,
59: p_actual_finish_date IN DATE := FND_API.g_miss_date ,
60: x_estimated_start_date OUT NOCOPY DATE ,

Line 57: p_estimated_finish_date IN DATE := FND_API.g_miss_date ,

53: p_proj_element_id IN NUMBER := FND_API.g_miss_num ,
54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,
55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,
56: p_estimated_start_date IN DATE := FND_API.g_miss_date ,
57: p_estimated_finish_date IN DATE := FND_API.g_miss_date ,
58: p_actual_start_date IN DATE := FND_API.g_miss_date ,
59: p_actual_finish_date IN DATE := FND_API.g_miss_date ,
60: x_estimated_start_date OUT NOCOPY DATE ,
61: x_estimated_finish_date OUT NOCOPY DATE ,

Line 58: p_actual_start_date IN DATE := FND_API.g_miss_date ,

54: p_task_status IN VARCHAR2 := FND_API.g_miss_num ,
55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,
56: p_estimated_start_date IN DATE := FND_API.g_miss_date ,
57: p_estimated_finish_date IN DATE := FND_API.g_miss_date ,
58: p_actual_start_date IN DATE := FND_API.g_miss_date ,
59: p_actual_finish_date IN DATE := FND_API.g_miss_date ,
60: x_estimated_start_date OUT NOCOPY DATE ,
61: x_estimated_finish_date OUT NOCOPY DATE ,
62: x_actual_start_date OUT NOCOPY DATE ,

Line 59: p_actual_finish_date IN DATE := FND_API.g_miss_date ,

55: p_percent_complete IN NUMBER := FND_API.g_miss_num ,
56: p_estimated_start_date IN DATE := FND_API.g_miss_date ,
57: p_estimated_finish_date IN DATE := FND_API.g_miss_date ,
58: p_actual_start_date IN DATE := FND_API.g_miss_date ,
59: p_actual_finish_date IN DATE := FND_API.g_miss_date ,
60: x_estimated_start_date OUT NOCOPY DATE ,
61: x_estimated_finish_date OUT NOCOPY DATE ,
62: x_actual_start_date OUT NOCOPY DATE ,
63: x_actual_finish_date OUT NOCOPY DATE ,

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Initialize value 'S'

65: x_msg_count OUT NOCOPY NUMBER ,
66: x_msg_data OUT NOCOPY VARCHAR2
67: ) IS
68: BEGIN
69: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Initialize value 'S'
70: x_estimated_start_date := p_estimated_start_date;
71: x_estimated_finish_date := p_estimated_finish_date;
72: x_actual_start_date := p_actual_start_date;
73: x_actual_finish_date := p_actual_finish_date;

Line 81: -- raise FND_API.G_EXC_ERROR;

77: -- Sample for Error Message population into message stack
78: -- IF error condition THEN
79: -- fnd_message.set_name('PA','');
80: -- fnd_msg_pub.add;
81: -- raise FND_API.G_EXC_ERROR;
82: -- END IF;
83:
84: -- Your Override Implmentation code should End here
85: EXCEPTION

Line 86: WHEN FND_API.G_EXC_ERROR THEN

82: -- END IF;
83:
84: -- Your Override Implmentation code should End here
85: EXCEPTION
86: WHEN FND_API.G_EXC_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: x_msg_count := fnd_msg_pub.count_msg;
89: WHEN OTHERS THEN
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 87: x_return_status := FND_API.G_RET_STS_ERROR;

83:
84: -- Your Override Implmentation code should End here
85: EXCEPTION
86: WHEN FND_API.G_EXC_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: x_msg_count := fnd_msg_pub.count_msg;
89: WHEN OTHERS THEN
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_CLIENT_EXTN',

Line 90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

86: WHEN FND_API.G_EXC_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: x_msg_count := fnd_msg_pub.count_msg;
89: WHEN OTHERS THEN
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_CLIENT_EXTN',
92: p_procedure_name => 'GET_TASK_RES_OVERRIDE_INFO',
93: p_error_text => SUBSTRB(SQLERRM,1,120));
94: x_msg_count := fnd_msg_pub.count_msg;