APPS.PA_STATUSES_PUB dependencies on FND_API

Line 16: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE -- 1851096 changed for TRUE to FALSE

12: -- End of Comments
13:
14: PROCEDURE delete_status
15: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE -- 1851096 changed for TRUE to FALSE
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
19: ,p_max_msg_count IN NUMBER
20: ,p_pa_project_status_code IN VARCHAR2

Line 17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

13:
14: PROCEDURE delete_status
15: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE -- 1851096 changed for TRUE to FALSE
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
19: ,p_max_msg_count IN NUMBER
20: ,p_pa_project_status_code IN VARCHAR2
21: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 18: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE

14: PROCEDURE delete_status
15: ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE -- 1851096 changed for TRUE to FALSE
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
19: ,p_max_msg_count IN NUMBER
20: ,p_pa_project_status_code IN VARCHAR2
21: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 34: x_return_status := FND_API.G_RET_STS_SUCCESS ;

30: unknown_action_exc EXCEPTION;
31:
32: BEGIN
33:
34: x_return_status := FND_API.G_RET_STS_SUCCESS ;
35:
36: select status_type
37: into v_status_type
38: from pa_project_statuses

Line 70: x_return_status := FND_API.G_RET_STS_ERROR;

66: );
67: EXCEPTION
68: WHEN unknown_action_exc THEN
69: rollback;
70: x_return_status := FND_API.G_RET_STS_ERROR;
71: fnd_message.set_name('PA','PA_UNKNOWN_ACTION');
72: fnd_message.set_token('PKG_NAME','PA_STATUSES_PUB');
73: fnd_message.set_token('PROCEDURE_NAME','delete_status');
74: fnd_msg_pub.add();

Line 78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

74: fnd_msg_pub.add();
75: fnd_msg_pub.count_and_get(p_count => x_msg_count,
76: p_data => x_msg_data);
77: raise;
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: rollback;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
82: fnd_message.set_token('PKG_NAME','PA_STATUSES_PUB');

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

76: p_data => x_msg_data);
77: raise;
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: rollback;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
82: fnd_message.set_token('PKG_NAME','PA_STATUSES_PUB');
83: fnd_message.set_token('PROCEDURE_NAME','delete_status');
84: fnd_msg_pub.add();

Line 90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

86: p_data => x_msg_data);
87: raise;
88: WHEN OTHERS THEN
89: rollback;
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUSES_PUB',
92: p_procedure_name => 'delete_status',
93: p_error_text => SUBSTRB(SQLERRM,1,240));
94: fnd_msg_pub.count_and_get(p_count => x_msg_count,