DBA Data[Home] [Help]

APPS.JTF_FM_HISTORY_UTIL_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

Line 206: x_return_status := FND_API.G_RET_STS_SUCCESS;

202:
203: l_message := RPAD('JTF_FM_REQUEST_CONTENTS table, records purged: ', 60, ' ') || l_count;
204: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
205:
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207: EXCEPTION
208: WHEN OTHERS
209: THEN
210: x_return_status := FND_API.G_RET_STS_ERROR;

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207: EXCEPTION
208: WHEN OTHERS
209: THEN
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: END delete_request_contents ;
212:
213: --------------------------------------------------------------------------------
214: -- PROCEDURE

Line 240: x_return_status := FND_API.G_RET_STS_SUCCESS;

236:
237: l_message := RPAD('JTF_FM_PROCESSED table, records purged: ', 60, ' ') || l_count;
238: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
239:
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: EXCEPTION
242: WHEN OTHERS
243: THEN
244: x_return_status := FND_API.G_RET_STS_ERROR;

Line 244: x_return_status := FND_API.G_RET_STS_ERROR;

240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: EXCEPTION
242: WHEN OTHERS
243: THEN
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: END delete_processed ;
246:
247: --------------------------------------------------------------------------------
248: -- PROCEDURE

Line 274: x_return_status := FND_API.G_RET_STS_SUCCESS;

270:
271: l_message := RPAD('JTF_FM_CONTENT_FAILURES table, records purged: ', 60, ' ') || l_count;
272: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
273:
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: EXCEPTION
276: WHEN OTHERS
277: THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: EXCEPTION
276: WHEN OTHERS
277: THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: END delete_content_failures ;
280:
281: --------------------------------------------------------------------------------
282: -- PROCEDURE

Line 308: x_return_status := FND_API.G_RET_STS_SUCCESS;

304:
305: l_message := RPAD('JTF_FM_EMAIL_STAT table, records purged: ', 60, ' ') || l_count;
306: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: EXCEPTION
310: WHEN OTHERS
311: THEN
312: x_return_status := FND_API.G_RET_STS_ERROR;

Line 312: x_return_status := FND_API.G_RET_STS_ERROR;

308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: EXCEPTION
310: WHEN OTHERS
311: THEN
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: END delete_email_stats ;
314:
315: --------------------------------------------------------------------------------
316: -- PROCEDURE

Line 342: x_return_status := FND_API.G_RET_STS_SUCCESS;

338:
339: l_message := RPAD('JTF_FM_REQUEST_HISTORY table, records purged: ', 60, ' ') || l_count;
340: FND_FILE.PUT_LINE(FND_FILE.LOG, l_message);
341:
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343: EXCEPTION
344: WHEN OTHERS
345: THEN
346: x_return_status := FND_API.G_RET_STS_ERROR;

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343: EXCEPTION
344: WHEN OTHERS
345: THEN
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: END delete_request_history;
348:
349: --------------------------------------------------------------------------------
350: -- PROCEDURE