APPS.FND_OAM_DSCRAM_RUNS_PKG dependencies on FND_API

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: FROM fnd_oam_dscram_runs_b
137: WHERE run_id = p_run_id;
138: BEGIN
139: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: x_return_msg := '';
142:
143: -- check that data scrambling is enabled first
144: FND_PROFILE.GET(B_DSCRAM_ENABLED_PROFILE_NAME,

Line 192: x_return_status := FND_API.G_RET_STS_SUCCESS;

188: END IF;
189:
190: --success
191: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193: RETURN TRUE;
194: EXCEPTION
195: WHEN PROGRAM_ERROR THEN
196: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: RETURN FALSE;
199: WHEN OTHERS THEN
200: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
201: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
204: RETURN FALSE;
205: END;
206:

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223: SELECT run_status
224: FROM fnd_oam_dscram_runs_b
225: WHERE run_id = b_run_info.run_id;
226: BEGIN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: x_return_msg := '';
229:
230: -- make sure the state's initialized
231: IF NOT b_run_info.initialized THEN

Line 239: RETURN (x_return_status = FND_API.G_RET_STS_SUCCESS);

235: -- check if we should do work or if we can return the cached status
236: IF NOT (p_force_query OR
237: FND_OAM_DSCRAM_UTILS_PKG.VALIDATION_DUE(b_run_info.last_validated)) THEN
238: x_return_status := b_run_info.last_validation_ret_sts;
239: RETURN (x_return_status = FND_API.G_RET_STS_SUCCESS);
240: END IF;
241:
242: fnd_oam_debug.log(1, l_ctxt, '>RE-QUERYING<');
243:

Line 273: x_return_status := FND_API.G_RET_STS_SUCCESS;

269:
270: --ignore p_recurse because we're the topmost entity
271:
272: --success
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274: b_run_info.last_validation_ret_sts := x_return_status;
275: b_run_info.last_validated := SYSDATE;
276: RETURN TRUE;
277: EXCEPTION

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

277: EXCEPTION
278: WHEN OTHERS THEN
279: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
280: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: b_run_info.last_validation_ret_sts := x_return_status;
283: b_run_info.last_validated := SYSDATE;
284: RETURN FALSE;
285: END;

Line 317: x_return_status := FND_API.G_RET_STS_ERROR;

313: FROM fnd_oam_dscram_stats
314: WHERE stat_id = c_stat_id);
315: BEGIN
316: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: x_return_msg := '';
319:
320: --fetch necessary run attributes
321: OPEN C1;

Line 357: x_return_status := FND_API.G_RET_STS_SUCCESS;

353: b_run_info.run_mode := l_run_mode;
354: b_run_info.last_validated := NULL;
355: b_run_info.initialized := TRUE;
356:
357: x_return_status := FND_API.G_RET_STS_SUCCESS;
358: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
359: EXCEPTION
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357: x_return_status := FND_API.G_RET_STS_SUCCESS;
358: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
359: EXCEPTION
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_return_msg := 'Unhandled Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
363: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
364: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
365: END;