APPS.PA_PROJECT_CTX_SEARCH_PVT dependencies on FND_API

Line 17: x_return_status := FND_API.G_RET_STS_SUCCESS;

13: l_project_description PA_PROJECTS_ALL.description%TYPE;
14: l_exists VARCHAR2(1);
15: l_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
16: BEGIN
17: x_return_status := FND_API.G_RET_STS_SUCCESS;
18:
19: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.
20: IF p_template_flag = 'Y'
21: THEN

Line 41: IF p_project_long_name = FND_API.G_MISS_CHAR THEN

37: END;
38:
39: IF l_exists = 'N' THEN
40:
41: IF p_project_long_name = FND_API.G_MISS_CHAR THEN
42: l_project_long_name := null;
43: ELSE
44: l_project_long_name := p_project_long_name;
45: END IF;

Line 47: IF p_project_description = FND_API.G_MISS_CHAR THEN

43: ELSE
44: l_project_long_name := p_project_long_name;
45: END IF;
46:
47: IF p_project_description = FND_API.G_MISS_CHAR THEN
48: l_project_description := null;
49: ELSE
50: l_project_description := p_project_description;
51: END IF;

Line 71: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

67: END IF;
68: -- 4537865 : Included Exception Block
69: EXCEPTION
70: WHEN OTHERS THEN
71: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
72: Fnd_Msg_Pub.add_exc_msg
73: ( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PVT'
74: , p_procedure_name => 'INSERT_ROW'
75: , p_error_text => SUBSTRB(SQLERRM,1,240));

Line 94: x_return_status := FND_API.G_RET_STS_SUCCESS;

90: l_exists VARCHAR2(1);
91: l_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
92: l_old_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
93: BEGIN
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.
97: IF p_template_flag = 'Y'
98: THEN

Line 124: IF p_project_long_name = FND_API.G_MISS_CHAR THEN

120: p_project_long_name => p_project_long_name,
121: p_project_description => p_project_description,
122: x_return_status => x_return_status);
123: ELSE
124: IF p_project_long_name = FND_API.G_MISS_CHAR THEN
125: l_project_long_name := null;
126: ELSE
127: l_project_long_name := p_project_long_name;
128: END IF;

Line 130: IF p_project_description = FND_API.G_MISS_CHAR THEN

126: ELSE
127: l_project_long_name := p_project_long_name;
128: END IF;
129:
130: IF p_project_description = FND_API.G_MISS_CHAR THEN
131: l_project_description := null;
132: ELSE
133: l_project_description := p_project_description;
134: END IF;

Line 160: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

156:
157: -- 4537865 : Included Exception Block
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
161: Fnd_Msg_Pub.add_exc_msg
162: ( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PVT'
163: , p_procedure_name => 'UPDATE_ROW'
164: , p_error_text => SUBSTRB(SQLERRM,1,240));

Line 174: x_return_status := FND_API.G_RET_STS_SUCCESS;

170: p_template_flag IN VARCHAR2,
171: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
172: IS
173: BEGIN
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.
177: IF p_template_flag = 'Y'
178: THEN

Line 188: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

184: x_return_status => x_return_status);
185: -- 4537865 : Included Exception Block
186: EXCEPTION
187: WHEN OTHERS THEN
188: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
189: Fnd_Msg_Pub.add_exc_msg
190: ( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PVT'
191: , p_procedure_name => 'DELETE_ROW'
192: , p_error_text => SUBSTRB(SQLERRM,1,240));