350: FETCH c_timer_status into x_timer_id, x_status;
351: IF c_timer_status%NOTFOUND
352: THEN
353: X_ERROR_CODE := xnp_errors.g_timer_not_found;
354: fnd_message.set_name('XNP', 'TIMER_NOT_FOUND');
355: fnd_message.set_token('REFERENCE_ID',p_reference_id);
356: fnd_message.set_token('MESSAGE_CODE',p_timer_message_code);
357: x_error_message := fnd_message.get;
358: END IF;
351: IF c_timer_status%NOTFOUND
352: THEN
353: X_ERROR_CODE := xnp_errors.g_timer_not_found;
354: fnd_message.set_name('XNP', 'TIMER_NOT_FOUND');
355: fnd_message.set_token('REFERENCE_ID',p_reference_id);
356: fnd_message.set_token('MESSAGE_CODE',p_timer_message_code);
357: x_error_message := fnd_message.get;
358: END IF;
359: CLOSE c_timer_status;
352: THEN
353: X_ERROR_CODE := xnp_errors.g_timer_not_found;
354: fnd_message.set_name('XNP', 'TIMER_NOT_FOUND');
355: fnd_message.set_token('REFERENCE_ID',p_reference_id);
356: fnd_message.set_token('MESSAGE_CODE',p_timer_message_code);
357: x_error_message := fnd_message.get;
358: END IF;
359: CLOSE c_timer_status;
360: EXCEPTION
353: X_ERROR_CODE := xnp_errors.g_timer_not_found;
354: fnd_message.set_name('XNP', 'TIMER_NOT_FOUND');
355: fnd_message.set_token('REFERENCE_ID',p_reference_id);
356: fnd_message.set_token('MESSAGE_CODE',p_timer_message_code);
357: x_error_message := fnd_message.get;
358: END IF;
359: CLOSE c_timer_status;
360: EXCEPTION
361: WHEN OTHERS THEN
451: FETCH c_update_timer_status INTO v_Timer_Registry;
452:
453: IF c_update_timer_status%NOTFOUND THEN
454: x_error_code := xnp_errors.g_timer_not_found;
455: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
456: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
457: x_error_message:= FND_MESSAGE.get ;
458: ELSE
459: UPDATE xnp_timer_registry
452:
453: IF c_update_timer_status%NOTFOUND THEN
454: x_error_code := xnp_errors.g_timer_not_found;
455: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
456: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
457: x_error_message:= FND_MESSAGE.get ;
458: ELSE
459: UPDATE xnp_timer_registry
460: SET status = p_status
453: IF c_update_timer_status%NOTFOUND THEN
454: x_error_code := xnp_errors.g_timer_not_found;
455: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
456: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
457: x_error_message:= FND_MESSAGE.get ;
458: ELSE
459: UPDATE xnp_timer_registry
460: SET status = p_status
461: WHERE CURRENT OF c_update_timer_status;
509:
510: EXCEPTION
511:
512: WHEN remove_timer_failed THEN
513: fnd_message.set_name ('XNP', 'REMOVE_TIMER_FAILED') ;
514: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
515: x_error_message := FND_MESSAGE.get ;
516:
517: END remove_timer;
510: EXCEPTION
511:
512: WHEN remove_timer_failed THEN
513: fnd_message.set_name ('XNP', 'REMOVE_TIMER_FAILED') ;
514: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
515: x_error_message := FND_MESSAGE.get ;
516:
517: END remove_timer;
518:
511:
512: WHEN remove_timer_failed THEN
513: fnd_message.set_name ('XNP', 'REMOVE_TIMER_FAILED') ;
514: fnd_message.set_token ('TIMER_ID',p_timer_id) ;
515: x_error_message := FND_MESSAGE.get ;
516:
517: END remove_timer;
518:
519: -----------------------------------------------------------------------------
620: ,x_error_message => x_error_message
621: );
622: IF (x_error_code <> 0) THEN
623: x_error_code := xnp_errors.g_timer_not_found;
624: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
625: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
626: x_error_message:= FND_MESSAGE.get ;
627: END IF;
628:
621: );
622: IF (x_error_code <> 0) THEN
623: x_error_code := xnp_errors.g_timer_not_found;
624: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
625: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
626: x_error_message:= FND_MESSAGE.get ;
627: END IF;
628:
629: EXCEPTION
622: IF (x_error_code <> 0) THEN
623: x_error_code := xnp_errors.g_timer_not_found;
624: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
625: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
626: x_error_message:= FND_MESSAGE.get ;
627: END IF;
628:
629: EXCEPTION
630: WHEN ex_timer_not_found THEN
638:
639:
640: WHEN NO_DATA_FOUND THEN
641: x_error_code := xnp_errors.g_timer_not_found;
642: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
643: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
644: x_error_message:= FND_MESSAGE.get ;
645:
646: IF c_timer_status_id%ISOPEN
639:
640: WHEN NO_DATA_FOUND THEN
641: x_error_code := xnp_errors.g_timer_not_found;
642: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
643: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
644: x_error_message:= FND_MESSAGE.get ;
645:
646: IF c_timer_status_id%ISOPEN
647: THEN
640: WHEN NO_DATA_FOUND THEN
641: x_error_code := xnp_errors.g_timer_not_found;
642: fnd_message.set_name ('XNP', 'TIMER_ID_NOT_FOUND') ;
643: fnd_message.set_token ('TIMER_ID',l_timer_id) ;
644: x_error_message:= FND_MESSAGE.get ;
645:
646: IF c_timer_status_id%ISOPEN
647: THEN
648: CLOSE c_timer_status_id;
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: -- Grab the error message and error no.
1104: x_error_code := SQLCODE;
1105: fnd_message.set_name('XNP','STD_ERROR');
1106: fnd_message.set_token('ERROR_LOCN'
1107: ,'XNP_TIMER_CORE.FIRE');
1108: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1109: x_error_message := fnd_message.get;
1102: WHEN OTHERS THEN
1103: -- Grab the error message and error no.
1104: x_error_code := SQLCODE;
1105: fnd_message.set_name('XNP','STD_ERROR');
1106: fnd_message.set_token('ERROR_LOCN'
1107: ,'XNP_TIMER_CORE.FIRE');
1108: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1109: x_error_message := fnd_message.get;
1110: END;
1104: x_error_code := SQLCODE;
1105: fnd_message.set_name('XNP','STD_ERROR');
1106: fnd_message.set_token('ERROR_LOCN'
1107: ,'XNP_TIMER_CORE.FIRE');
1108: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1109: x_error_message := fnd_message.get;
1110: END;
1111:
1112: END FIRE;
1105: fnd_message.set_name('XNP','STD_ERROR');
1106: fnd_message.set_token('ERROR_LOCN'
1107: ,'XNP_TIMER_CORE.FIRE');
1108: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1109: x_error_message := fnd_message.get;
1110: END;
1111:
1112: END FIRE;
1113: