APPS.PA_REPORT_TYPES_PKG dependencies on FND_API

Line 90: x_return_status := FND_API.G_RET_STS_SUCCESS;

86: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
87: ) is
88: BEGIN
89:
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: update PA_REPORT_TYPES set
92: NAME = decode(P_NAME,'^',name,p_name),
93: PAGE_ID = decode(p_page_id,'-99',page_id,p_page_id),
94: OVERRIDE_PAGE_LAYOUT = decode(p_OVERRIDE_PAGE_LAYOUT,'^',OVERRIDE_PAGE_LAYOUT,p_OVERRIDE_PAGE_LAYOUT),

Line 109: x_return_status := FND_API.G_RET_STS_ERROR;

105:
106:
107: if (sql%notfound) then
108: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: RETURN;
111: end if;
112:
113: EXCEPTION

Line 115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

111: end if;
112:
113: EXCEPTION
114: WHEN OTHERS THEN -- catch the exceptins here
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
116: RAISE;
117:
118: end UPDATE_ROW;
119:

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
125: ) is
126: BEGIN
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: delete from PA_REPORT_TYPES
131: where REPORT_TYPE_ID = p_report_type_id
132: AND nvl(p_record_version_number, record_version_number) = record_version_number;

Line 137: x_return_status := FND_API.G_RET_STS_ERROR;

133:
134:
135: IF (SQL%NOTFOUND) THEN
136: PA_UTILS.Add_Message ( p_app_short_name => 'PA', p_msg_name => 'PA_XC_RECORD_CHANGED');
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: RETURN;
139: END IF;
140:
141: EXCEPTION

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

140:
141: EXCEPTION
142: WHEN OTHERS THEN
143: -- Set the current program unit name in the error stack
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
145: RAISE;
146: end DELETE_ROW;
147:
148: