APPS.FND_OAM_DSCRAM_STATS_PKG dependencies on FND_API

Line 28: x_return_status := FND_API.G_RET_STS_ERROR;

24: l_ctxt VARCHAR2(60) := PKG_NAME||'INTERNAL_CREATE_ENTRY';
25:
26: l_stat_id NUMBER(15);
27: BEGIN
28: x_return_status := FND_API.G_RET_STS_ERROR;
29: x_return_msg := '';
30:
31: --do the insert
32: INSERT

Line 62: x_return_status := FND_API.G_RET_STS_SUCCESS;

58:
59: x_stat_id := l_stat_id;
60:
61: --success
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63: EXCEPTION
64: WHEN OTHERS THEN
65: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63: EXCEPTION
64: WHEN OTHERS THEN
65: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
66: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: --don't log it here, let the caller log it
68: END;
69:
70: --Private, does the grunt work for completing a stats entry

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

81:
82: l_stat_id NUMBER(15);
83: BEGIN
84: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: x_return_msg := '';
87:
88: --do the update
89: UPDATE fnd_oam_dscram_stats

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: RETURN;
106: END IF;
107:
108: --success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
111: EXCEPTION
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
111: EXCEPTION
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
115: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
116: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
117: END;

Line 132: x_return_status := FND_API.G_RET_STS_ERROR;

128: l_ctxt VARCHAR2(60) := PKG_NAME||'CREATE_ENTRY_FOR_RUN';
129:
130: l_run_stat_id NUMBER(15);
131: BEGIN
132: x_return_status := FND_API.G_RET_STS_ERROR;
133: x_return_msg := '';
134:
135: --select the stat_id first so we can use it as the run_stat_id also
136: SELECT FND_OAM_DSCRAM_STATS_S.NEXTVAL

Line 170: x_return_status := FND_API.G_RET_STS_SUCCESS;

166:
167: x_run_stat_id := l_run_stat_id;
168:
169: --success
170: x_return_status := FND_API.G_RET_STS_SUCCESS;
171: EXCEPTION
172: WHEN OTHERS THEN
173: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
174: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: EXCEPTION
172: WHEN OTHERS THEN
173: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
174: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: END;
177:
178: -- Public
179: PROCEDURE CREATE_ENTRY(p_run_stat_id IN NUMBER,

Line 201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

197: p_start_message => p_start_message,
198: x_stat_id => x_stat_id,
199: x_return_status => l_return_status,
200: x_return_msg => l_return_msg);
201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
202: --just log the message
203: fnd_oam_debug.log(6, l_ctxt, l_return_msg);
204: END IF;
205: EXCEPTION

Line 263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

259: p_start_message => p_start_message,
260: x_stat_id => x_stat_id,
261: x_return_status => l_return_status,
262: x_return_msg => l_return_msg);
263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
264: IF NOT FND_OAM_DSCRAM_UTILS_PKG.FLAG_TO_BOOLEAN(p_dismiss_failure) THEN
265: fnd_oam_debug.log(6, l_ctxt, l_return_msg);
266: END IF;
267: ROLLBACK;

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289: l_ctxt VARCHAR2(60) := PKG_NAME||'CREATE_ENTRY_FOR_RUN';
290:
291: l_run_stat_id NUMBER(15);
292: BEGIN
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: x_return_msg := '';
295:
296: SELECT last_run_stat_id
297: INTO l_run_stat_id

Line 313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

309:
310: --success
311: EXCEPTION
312: WHEN OTHERS THEN
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: x_return_msg := 'Unhandled Exception: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
315: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
316: END;
317: