DBA Data[Home] [Help]

APPS.IEC_REPORTS_PVT dependencies on FND_API

Line 71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: , 'GET_RECORDS_LOADED_COUNT'
68: , SQLCODE
69: , SQLERRM
70: );
71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END;
73:
74: -- RECORDS CALLED ONCE
75: BEGIN

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88: , 'GET_RECORDS_CALLED_ONCE_COUNT'
89: , SQLCODE
90: , SQLERRM
91: );
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END;
94:
95: END LOOP;
96:

Line 100: WHEN FND_API.G_EXC_ERROR THEN

96:
97: END IF;
98:
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: RAISE;
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: RAISE;
104: WHEN OTHERS THEN

Line 102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

98:
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: RAISE;
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: RAISE;
104: WHEN OTHERS THEN
105: Log( 'Reset of report counts for subsets belonging to list ' || p_list_id
106: , 'Calculate_SubsetCounts'

Line 111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

107: , 'MAIN'
108: , SQLCODE
109: , SQLERRM
110: );
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112:
113: END Calculate_SubsetCounts;
114:
115: PROCEDURE Update_SubsetCounts

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: , 'MAIN'
174: , SQLCODE
175: , SQLERRM
176: );
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178:
179: END Update_SubsetCounts;
180:
181: PROCEDURE Reset_ListRecordCounts

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: , 'GET_LIST_SUBSETS'
219: , SQLCODE
220: , SQLERRM
221: );
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END;
224:
225: Calculate_SubsetCounts( p_schedule_id
226: , p_list_id

Line 277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

273: , 'UPDATE_CALLABLE_ZONE_COUNTS'
274: , SQLCODE
275: , SQLERRM
276: );
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END;
279:
280: COMMIT;
281:

Line 283: WHEN FND_API.G_EXC_ERROR THEN

279:
280: COMMIT;
281:
282: EXCEPTION
283: WHEN FND_API.G_EXC_ERROR THEN
284: x_return_code := 'E';
285: ROLLBACK TO reset_counts_list;
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_code := 'U';

Line 286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

282: EXCEPTION
283: WHEN FND_API.G_EXC_ERROR THEN
284: x_return_code := 'E';
285: ROLLBACK TO reset_counts_list;
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_code := 'U';
288: ROLLBACK TO reset_counts_list;
289: WHEN OTHERS THEN
290: Log( 'Reset of record counts for list' || p_list_id

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: , 'GET_SCHEDULE_LISTS'
334: , SQLCODE
335: , SQLERRM
336: );
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END;
339:
340: IF l_list_id_col IS NOT NULL AND l_list_id_col.COUNT > 0 THEN
341:

Line 349: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN

345: , l_list_id_col(i)
346: , p_source_id
347: , l_return_code);
348:
349: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
350: RAISE fnd_api.g_exc_unexpected_error;
351: END IF;
352:
353: END LOOP;

Line 350: RAISE fnd_api.g_exc_unexpected_error;

346: , p_source_id
347: , l_return_code);
348:
349: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
350: RAISE fnd_api.g_exc_unexpected_error;
351: END IF;
352:
353: END LOOP;
354:

Line 360: WHEN FND_API.G_EXC_ERROR THEN

356:
357: COMMIT;
358:
359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: x_return_code := 'E';
362: ROLLBACK TO reset_counts_campaign;
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: x_return_code := 'U';

Line 363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: x_return_code := 'E';
362: ROLLBACK TO reset_counts_campaign;
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: x_return_code := 'U';
365: ROLLBACK TO reset_counts_campaign;
366: WHEN OTHERS THEN
367: Log( 'Reset of record counts for campaign schedule ' || p_schedule_id

Line 409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

405: , 'GET_EXECUTING_SCHEDULES'
406: , SQLCODE
407: , SQLERRM
408: );
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END;
411:
412: IF l_schedule_id_col IS NOT NULL AND l_schedule_id_col.COUNT > 0 THEN
413:

Line 420: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN

416: Reset_CampaignRecordCounts ( l_schedule_id_col(i)
417: , p_source_id
418: , l_return_code);
419:
420: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423:
424: END LOOP;

Line 421: RAISE fnd_api.g_exc_unexpected_error;

417: , p_source_id
418: , l_return_code);
419:
420: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423:
424: END LOOP;
425:

Line 431: WHEN FND_API.G_EXC_ERROR THEN

427:
428: COMMIT;
429:
430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: x_return_code := 'E';
433: ROLLBACK TO reset_counts_all;
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435: x_return_code := 'U';

Line 434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: x_return_code := 'E';
433: ROLLBACK TO reset_counts_all;
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435: x_return_code := 'U';
436: ROLLBACK TO reset_counts_all;
437: WHEN OTHERS THEN
438: Log( 'Reset of record counts for all campaign schedules'