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
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:
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
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'
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
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
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
273: , 'UPDATE_CALLABLE_ZONE_COUNTS'
274: , SQLCODE
275: , SQLERRM
276: );
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END;
279:
280: COMMIT;
281:
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';
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
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:
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;
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:
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';
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
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:
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;
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:
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';
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'