DBA Data[Home] [Help]

APPS.XNP_TIMER_CORE dependencies on XNP_ERRORS

Line 225: x_error_code := XNP_ERRORS.G_TIMER_NOT_FOUND;

221: raise l_EXCEPTION;
222: END IF;
223:
224: ELSE
225: x_error_code := XNP_ERRORS.G_TIMER_NOT_FOUND;
226:
227: END IF;
228:
229: EXCEPTION

Line 299: x_error_code := XNP_ERRORS.G_TIMER_NOT_FOUND;

295: OPEN c_timer_status;
296: FETCH c_timer_status into x_status;
297: IF c_timer_status%NOTFOUND
298: THEN
299: x_error_code := XNP_ERRORS.G_TIMER_NOT_FOUND;
300: END IF;
301: CLOSE c_timer_status;
302:
303: EXCEPTION

Line 353: X_ERROR_CODE := xnp_errors.g_timer_not_found;

349: OPEN c_timer_status;
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;

Line 410: x_error_code := xnp_errors.g_timer_not_found;

406:
407: OPEN c_update_timer_status;
408: FETCH c_update_timer_status INTO v_Timer_Registry;
409: IF c_update_timer_status%NOTFOUND THEN
410: x_error_code := xnp_errors.g_timer_not_found;
411: ELSE
412: UPDATE xnp_timer_registry
413: SET status = p_status
414: WHERE CURRENT OF c_update_timer_status;

Line 419: x_error_code := XNP_ERRORS.G_TIMER_NOT_FOUND;

415: END IF;
416:
417: EXCEPTION
418: WHEN NO_DATA_FOUND THEN
419: x_error_code := XNP_ERRORS.G_TIMER_NOT_FOUND;
420: CLOSE c_update_timer_status;
421:
422: END update_timer_status;
423:

Line 454: x_error_code := xnp_errors.g_timer_not_found;

450: OPEN c_update_timer_status;
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

Line 623: x_error_code := xnp_errors.g_timer_not_found;

619: ,x_error_code => x_error_code
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;

Line 641: x_error_code := xnp_errors.g_timer_not_found;

637: END IF;
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:

Line 693: x_error_code := xnp_errors.g_timer_not_found;

689: ,x_error_code => l_error_code
690: ,x_error_message => l_error_message
691: );
692: IF (x_error_code <> 0) THEN
693: x_error_code := xnp_errors.g_timer_not_found;
694: x_error_message := 'Timer Id : ' || rec.timer_id || '-' || l_error_message;
695: END IF;
696:
697: END LOOP;

Line 702: x_error_code := xnp_errors.g_timer_not_found;

698:
699: EXCEPTION
700:
701: WHEN NO_DATA_FOUND THEN
702: x_error_code := xnp_errors.g_timer_not_found;
703:
704: WHEN OTHERS THEN
705: x_error_code := sqlcode;
706: x_error_message := sqlerrm;

Line 741: x_error_code := xnp_errors.g_timer_not_found;

737: ,x_error_code => l_error_code
738: ,x_error_message => l_error_message
739: );
740: IF (x_error_code <> 0) THEN
741: x_error_code := xnp_errors.g_timer_not_found;
742: x_error_message := 'Timer Id : ' || rec.timer_id || '-' || l_error_message;
743: END IF;
744:
745: END LOOP;

Line 750: x_error_code := xnp_errors.g_timer_not_found;

746:
747: EXCEPTION
748:
749: WHEN NO_DATA_FOUND THEN
750: x_error_code := xnp_errors.g_timer_not_found;
751:
752: WHEN OTHERS THEN
753: x_error_code := sqlcode;
754: x_error_message := sqlerrm;