APPS.PA_CONTROL_ITEMS_PKG dependencies on FND_API

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74: where ci_id = px_ci_id;
75:
76: BEGIN
77:
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: --get the unique control item id from the Oracle Sequence
81: IF (px_ci_id is null) THEN
82: SELECT pa_control_items_s.nextval

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

223:
224:
225: EXCEPTION
226: WHEN OTHERS THEN
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
228: RAISE;
229:
230: end INSERT_ROW;
231:

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: ,p_last_update_login in NUMBER default fnd_global.user_id --Added the parameter for bug# 3877985
294:
295: ) is
296: begin
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: update PA_CONTROL_ITEMS set
300: ci_type_id = Nvl(p_ci_type_id,ci_type_id)
301: ,summary = Nvl(p_summary,summary)

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356: AND record_version_number = Nvl(p_record_version_number, record_version_number);
357:
358: if (sql%notfound) then
359: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: end if;
362:
363: EXCEPTION
364: WHEN OTHERS THEN

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

361: end if;
362:
363: EXCEPTION
364: WHEN OTHERS THEN
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
366: RAISE;
367: end UPDATE_ROW;
368:
369:

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

376: ,x_msg_data OUT NOCOPY VARCHAR2
377:
378: ) is
379: begin
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: DELETE FROM PA_CONTROL_ITEMS
383: where ci_id = p_ci_id
384: and record_version_number = p_record_version_number;

Line 389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

385:
386:
387: EXCEPTION
388: WHEN OTHERS THEN
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390: RAISE;
391: end DELETE_ROW;
392:
393: END PA_CONTROL_ITEMS_PKG;