APPS.PA_CONTROL_ITEMS_PKG dependencies on FND_API

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: where ci_type_id = p_ci_type_id;
99:
100: BEGIN
101:
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104: --get the unique control item id from the Oracle Sequence
105: IF (px_ci_id is null) THEN
106: SELECT pa_control_items_s.nextval

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

293:
294:
295: EXCEPTION
296: WHEN OTHERS THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
298: RAISE;
299:
300: end INSERT_ROW;
301:

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: ,p_last_update_login in NUMBER default fnd_global.user_id --Added the parameter for bug# 3877985
378:
379: ) is
380: begin
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: update PA_CONTROL_ITEMS set
384: ci_type_id = Nvl(p_ci_type_id,ci_type_id)
385: ,summary = Nvl(p_summary,summary)

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

452: AND record_version_number = Nvl(p_record_version_number, record_version_number);
453:
454: if (sql%notfound) then
455: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: end if;
458:
459: EXCEPTION
460: WHEN OTHERS THEN

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

457: end if;
458:
459: EXCEPTION
460: WHEN OTHERS THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
462: RAISE;
463: end UPDATE_ROW;
464:
465:

Line 476: x_return_status := FND_API.G_RET_STS_SUCCESS;

472: ,x_msg_data OUT NOCOPY VARCHAR2
473:
474: ) is
475: begin
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477:
478: DELETE FROM PA_CONTROL_ITEMS
479: where ci_id = p_ci_id
480: and record_version_number = p_record_version_number;

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

481:
482:
483: EXCEPTION
484: WHEN OTHERS THEN
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: RAISE;
487: end DELETE_ROW;
488:
489: END PA_CONTROL_ITEMS_PKG;