DBA Data[Home] [Help]

APPS.FA_MASSADD_SPECIAL_PKG dependencies on FND_API

Line 155: x_return_status := FND_API.G_RET_STS_SUCCESS;

151: end if;
152:
153: end if;
154:
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156:
157: EXCEPTION
158: when error_found then
159: fa_srvr_msg.add_message(calling_fn => l_calling_fn

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: EXCEPTION
158: when error_found then
159: fa_srvr_msg.add_message(calling_fn => l_calling_fn
160: ,p_log_level_rec => p_log_level_rec);
161: x_return_status := FND_API.G_RET_STS_ERROR;
162:
163: when others then
164: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
165: ,p_log_level_rec => p_log_level_rec);

Line 166: x_return_status := FND_API.G_RET_STS_ERROR;

162:
163: when others then
164: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
165: ,p_log_level_rec => p_log_level_rec);
166: x_return_status := FND_API.G_RET_STS_ERROR;
167:
168: END Do_Validation;
169:
170:

Line 204: l_ret_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

200: l_ret_val number;
201: l_cursor_id number;
202: l_sql_statement varchar2(2000);
203:
204: l_ret_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
205: l_calling_fn varchar2(40) := 'fa_massadd_special_pkg.update_all';
206:
207: error_found exception;
208: error_found2 exception; -- used in nested block

Line 279: if l_ret_status <> FND_API.G_RET_STS_SUCCESS then

275: l_ret_status
276: ,p_log_level_rec => p_log_level_rec);
277: end if;
278:
279: if l_ret_status <> FND_API.G_RET_STS_SUCCESS then
280: raise error_found2;
281: else
282: l_upd_rowid(l_upd_rowid.count + 1) := l_rowid_tbl(i);
283: if (p_posting_status = 'POST') then

Line 334: X_return_status := FND_API.G_RET_STS_SUCCESS;

330: commit;
331:
332: -- returning success here even though individual lines may have failed.
333: if (x_failure_count = 0) then
334: X_return_status := FND_API.G_RET_STS_SUCCESS;
335: else
336: X_return_status := FND_API.G_RET_STS_ERROR;
337: end if;
338:

Line 336: X_return_status := FND_API.G_RET_STS_ERROR;

332: -- returning success here even though individual lines may have failed.
333: if (x_failure_count = 0) then
334: X_return_status := FND_API.G_RET_STS_SUCCESS;
335: else
336: X_return_status := FND_API.G_RET_STS_ERROR;
337: end if;
338:
339: EXCEPTION
340: when error_found then

Line 343: X_return_status := FND_API.G_RET_STS_ERROR;

339: EXCEPTION
340: when error_found then
341: fa_srvr_msg.add_message(calling_fn => l_calling_fn
342: ,p_log_level_rec => p_log_level_rec);
343: X_return_status := FND_API.G_RET_STS_ERROR;
344:
345: when others then
346: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
347: ,p_log_level_rec => p_log_level_rec);

Line 348: X_return_status := FND_API.G_RET_STS_ERROR;

344:
345: when others then
346: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
347: ,p_log_level_rec => p_log_level_rec);
348: X_return_status := FND_API.G_RET_STS_ERROR;
349:
350:
351: END Update_All_Records;
352: