275:
276: EXCEPTION
277: WHEN EventNotFound THEN
278:
279: FND_MESSAGE.SET_NAME( 'AR', 'HZ_EVENTNOTFOUND');
280: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );
281: FND_MSG_PUB.ADD;
282:
283: -- Debug info.
276: EXCEPTION
277: WHEN EventNotFound THEN
278:
279: FND_MESSAGE.SET_NAME( 'AR', 'HZ_EVENTNOTFOUND');
280: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );
281: FND_MSG_PUB.ADD;
282:
283: -- Debug info.
284: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
290: -- Check if API is called in debug mode. If yes, disable debug.
291: --disable_debug;
292:
293: WHEN EventNotHZ THEN
294: FND_MESSAGE.SET_NAME( 'AR', 'HZ_EVENTNOTTCA');
295: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );
296: FND_MSG_PUB.ADD;
297:
298: -- Debug info.
291: --disable_debug;
292:
293: WHEN EventNotHZ THEN
294: FND_MESSAGE.SET_NAME( 'AR', 'HZ_EVENTNOTTCA');
295: FND_MESSAGE.SET_TOKEN( 'EVENT' ,p_event_name );
296: FND_MSG_PUB.ADD;
297:
298: -- Debug info.
299: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
307:
308: WHEN NO_DATA_FOUND THEN
309: ROLLBACK TO hz_raise_event;
310:
311: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
312: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
313: FND_MSG_PUB.ADD;
314:
315: -- Debug info.
308: WHEN NO_DATA_FOUND THEN
309: ROLLBACK TO hz_raise_event;
310:
311: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
312: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
313: FND_MSG_PUB.ADD;
314:
315: -- Debug info.
316: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
326:
327: WHEN OTHERS THEN
328: ROLLBACK TO hz_raise_event;
329:
330: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
331: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
332: FND_MSG_PUB.ADD;
333:
334: -- Debug info.
327: WHEN OTHERS THEN
328: ROLLBACK TO hz_raise_event;
329:
330: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
331: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
332: FND_MSG_PUB.ADD;
333:
334: -- Debug info.
335: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN