DBA Data[Home] [Help]

APPS.FA_MASSADD_SPECIAL_PKG dependencies on FND_API

Line 189: x_return_status := FND_API.G_RET_STS_SUCCESS;

185: end if;
186:
187: end if;
188:
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190:
191: EXCEPTION
192: when error_found then
193: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);

Line 194: x_return_status := FND_API.G_RET_STS_ERROR;

190:
191: EXCEPTION
192: when error_found then
193: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
194: x_return_status := FND_API.G_RET_STS_ERROR;
195:
196: when others then
197: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
198: x_return_status := FND_API.G_RET_STS_ERROR;

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: x_return_status := FND_API.G_RET_STS_ERROR;
195:
196: when others then
197: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
198: x_return_status := FND_API.G_RET_STS_ERROR;
199:
200: END Do_Validation;
201:
202:

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

231: l_ret_val number;
232: l_cursor_id number;
233: l_sql_statement varchar2(2000);
234:
235: l_ret_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
236: l_calling_fn varchar2(40) := 'fa_massadd_special_pkg.update_all';
237:
238: error_found exception;
239: error_found2 exception; -- used in nested block

Line 320: if l_ret_status <> FND_API.G_RET_STS_SUCCESS then

316: l_massadd_rec,
317: l_ret_status);
318: end if;
319:
320: if l_ret_status <> FND_API.G_RET_STS_SUCCESS then
321: raise error_found2;
322: else
323: l_upd_rowid(l_upd_rowid.count + 1) := l_rowid_tbl(i);
324: if (p_posting_status = 'POST') then

Line 383: X_return_status := FND_API.G_RET_STS_SUCCESS;

379: commit;
380:
381: -- returning success here even though individual lines may have failed.
382: if (x_failure_count = 0) then
383: X_return_status := FND_API.G_RET_STS_SUCCESS;
384: else
385: X_return_status := FND_API.G_RET_STS_ERROR;
386: end if;
387:

Line 385: X_return_status := FND_API.G_RET_STS_ERROR;

381: -- returning success here even though individual lines may have failed.
382: if (x_failure_count = 0) then
383: X_return_status := FND_API.G_RET_STS_SUCCESS;
384: else
385: X_return_status := FND_API.G_RET_STS_ERROR;
386: end if;
387:
388: EXCEPTION
389: when error_found then

Line 391: X_return_status := FND_API.G_RET_STS_ERROR;

387:
388: EXCEPTION
389: when error_found then
390: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
391: X_return_status := FND_API.G_RET_STS_ERROR;
392:
393: when others then
394: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
395: X_return_status := FND_API.G_RET_STS_ERROR;

Line 395: X_return_status := FND_API.G_RET_STS_ERROR;

391: X_return_status := FND_API.G_RET_STS_ERROR;
392:
393: when others then
394: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
395: X_return_status := FND_API.G_RET_STS_ERROR;
396:
397:
398: END Update_All_Records;
399: