APPS.PA_HR_ORG_UTILS dependencies on FND_API

Line 26: ( p_org_hierarchy_version_id <> FND_API.G_MISS_NUM)) THEN

22: ,x_error_msg_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
23: BEGIN
24: pa_debug.init_err_stack ('pa_hr_org_utils.Check_OrgHierName_Or_Id');
25: IF ((p_org_hierarchy_version_id IS NOT NULL) and
26: ( p_org_hierarchy_version_id <> FND_API.G_MISS_NUM)) THEN
27: IF (p_check_id_flag = 'Y') THEN
28: SELECT POSV1.org_structure_version_id
29: INTO x_org_hierarchy_version_id
30: FROM per_org_structure_versions POSV1

Line 45: x_return_status:= FND_API.G_RET_STS_SUCCESS;

41: WHERE POS.name = p_org_hierarchy_name
42: AND POS.organization_structure_id =
43: POSV1.organization_structure_id;
44: END IF;
45: x_return_status:= FND_API.G_RET_STS_SUCCESS;
46: pa_debug.reset_err_stack;
47: EXCEPTION
48: WHEN no_data_found THEN
49: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 49: x_return_status:= FND_API.G_RET_STS_ERROR;

45: x_return_status:= FND_API.G_RET_STS_SUCCESS;
46: pa_debug.reset_err_stack;
47: EXCEPTION
48: WHEN no_data_found THEN
49: x_return_status:= FND_API.G_RET_STS_ERROR;
50: x_error_msg_code:= 'PA_ORG_HIER_INVALID_AMBIGOUS';
51: WHEN too_many_rows THEN
52: x_return_status:= FND_API.G_RET_STS_ERROR;
53: x_error_msg_code:= 'PA_ORG_HIER_INVALID_AMBIGOUS';

Line 52: x_return_status:= FND_API.G_RET_STS_ERROR;

48: WHEN no_data_found THEN
49: x_return_status:= FND_API.G_RET_STS_ERROR;
50: x_error_msg_code:= 'PA_ORG_HIER_INVALID_AMBIGOUS';
51: WHEN too_many_rows THEN
52: x_return_status:= FND_API.G_RET_STS_ERROR;
53: x_error_msg_code:= 'PA_ORG_HIER_INVALID_AMBIGOUS';
54: WHEN OTHERS THEN
55: fnd_msg_pub.add_exc_msg
56: (p_pkg_name => 'PA_HR_ORG_UTILS',

Line 58: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

54: WHEN OTHERS THEN
55: fnd_msg_pub.add_exc_msg
56: (p_pkg_name => 'PA_HR_ORG_UTILS',
57: p_procedure_name => pa_debug.g_err_stack );
58: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
59: RAISE;
60: END Check_OrgHierName_Or_id;
61:
62: PROCEDURE Check_OrgName_Or_Id

Line 79: IF ((p_organization_id <> FND_API.G_MISS_NUM) AND (p_organization_id IS NOT NULL)) THEN

75: SELECT organization_id
76: FROM hr_organization_units
77: WHERE name = p_organization_name;
78: BEGIN
79: IF ((p_organization_id <> FND_API.G_MISS_NUM) AND (p_organization_id IS NOT NULL)) THEN
80: IF (p_check_id_flag = 'Y') THEN
81: SELECT organization_id
82: INTO x_organization_id
83: FROM hr_all_organization_units -- Bug 4358448 perf change

Line 136: x_return_status:= FND_API.G_RET_STS_SUCCESS;

132: ELSE
133: x_organization_id := NULL;
134: END IF;
135: END IF;
136: x_return_status:= FND_API.G_RET_STS_SUCCESS;
137: EXCEPTION
138: WHEN no_data_found THEN
139: x_organization_id := NULL;
140: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 140: x_return_status:= FND_API.G_RET_STS_ERROR;

136: x_return_status:= FND_API.G_RET_STS_SUCCESS;
137: EXCEPTION
138: WHEN no_data_found THEN
139: x_organization_id := NULL;
140: x_return_status:= FND_API.G_RET_STS_ERROR;
141: x_error_msg_code:= 'PA_INVALID_ORG';
142: WHEN too_many_rows THEN
143: x_organization_id := NULL;
144: x_return_status:= FND_API.G_RET_STS_ERROR;

Line 144: x_return_status:= FND_API.G_RET_STS_ERROR;

140: x_return_status:= FND_API.G_RET_STS_ERROR;
141: x_error_msg_code:= 'PA_INVALID_ORG';
142: WHEN too_many_rows THEN
143: x_organization_id := NULL;
144: x_return_status:= FND_API.G_RET_STS_ERROR;
145: x_error_msg_code:= 'PA_ORG_NOT_UNIQUE';
146: WHEN OTHERS THEN
147: x_organization_id := NULL;
148: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 148: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

144: x_return_status:= FND_API.G_RET_STS_ERROR;
145: x_error_msg_code:= 'PA_ORG_NOT_UNIQUE';
146: WHEN OTHERS THEN
147: x_organization_id := NULL;
148: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
149: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_projects_maint_utils', p_procedure_name => 'Check_org_name_Or_Id');
150: RAISE;
151: END Check_OrgName_Or_Id;
152: