DBA Data[Home] [Help]

APPS.JTF_FM_HISTORY_UTIL_PVT dependencies on FND_API

Line 100: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

96: delete_processed ( p_request_id => c_header_record.request_id
97: , x_return_status => l_return_status
98: );
99:
100: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
101: THEN
102: RAISE e_error_found;
103: END IF;
104:

Line 109: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

105: delete_request_contents ( p_request_id => c_header_record.request_id
106: , x_return_status => l_return_status
107: );
108:
109: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
110: THEN
111: RAISE e_error_found;
112: END IF;
113:

Line 119: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

115: delete_content_failures ( p_request_id => c_header_record.request_id
116: , x_return_status => l_return_status
117: );
118:
119: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
120: THEN
121: RAISE e_error_found;
122: END IF;
123:

Line 129: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

125: delete_email_stats ( p_request_id => c_header_record.request_id
126: , x_return_status => l_return_status
127: );
128:
129: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
130: THEN
131: RAISE e_error_found;
132: END IF;
133:

Line 138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

134: delete_request_history ( p_rowid => c_header_record.rowid
135: , x_return_status => l_return_status
136: );
137:
138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
139: THEN
140: RAISE e_error_found;
141: END IF;
142:

Line 198: x_return_status := FND_API.G_RET_STS_SUCCESS;

194:
195: l_message := RPAD('JTF_FM_REQUEST_CONTENTS table, records purged: ', 60, ' ') || l_count;
196: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
197:
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199: EXCEPTION
200: WHEN OTHERS
201: THEN
202: x_return_status := FND_API.G_RET_STS_ERROR;

Line 202: x_return_status := FND_API.G_RET_STS_ERROR;

198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199: EXCEPTION
200: WHEN OTHERS
201: THEN
202: x_return_status := FND_API.G_RET_STS_ERROR;
203: END delete_request_contents ;
204:
205: --------------------------------------------------------------------------------
206: -- PROCEDURE

Line 232: x_return_status := FND_API.G_RET_STS_SUCCESS;

228:
229: l_message := RPAD('JTF_FM_PROCESSED table, records purged: ', 60, ' ') || l_count;
230: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
231:
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233: EXCEPTION
234: WHEN OTHERS
235: THEN
236: x_return_status := FND_API.G_RET_STS_ERROR;

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233: EXCEPTION
234: WHEN OTHERS
235: THEN
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: END delete_processed ;
238:
239: --------------------------------------------------------------------------------
240: -- PROCEDURE

Line 266: x_return_status := FND_API.G_RET_STS_SUCCESS;

262:
263: l_message := RPAD('JTF_FM_CONTENT_FAILURES table, records purged: ', 60, ' ') || l_count;
264: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
265:
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267: EXCEPTION
268: WHEN OTHERS
269: THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267: EXCEPTION
268: WHEN OTHERS
269: THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: END delete_content_failures ;
272:
273: --------------------------------------------------------------------------------
274: -- PROCEDURE

Line 300: x_return_status := FND_API.G_RET_STS_SUCCESS;

296:
297: l_message := RPAD('JTF_FM_EMAIL_STAT table, records purged: ', 60, ' ') || l_count;
298: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
299:
300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301: EXCEPTION
302: WHEN OTHERS
303: THEN
304: x_return_status := FND_API.G_RET_STS_ERROR;

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301: EXCEPTION
302: WHEN OTHERS
303: THEN
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: END delete_email_stats ;
306:
307: --------------------------------------------------------------------------------
308: -- PROCEDURE

Line 334: x_return_status := FND_API.G_RET_STS_SUCCESS;

330:
331: l_message := RPAD('JTF_FM_REQUEST_HISTORY table, records purged: ', 60, ' ') || l_count;
332: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
333:
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335: EXCEPTION
336: WHEN OTHERS
337: THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;

Line 338: x_return_status := FND_API.G_RET_STS_ERROR;

334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335: EXCEPTION
336: WHEN OTHERS
337: THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: END delete_request_history;
340:
341: --------------------------------------------------------------------------------
342: -- PROCEDURE