1: PACKAGE BODY xnp_timer_core AS
2: /* $Header: XNPTBLPB.pls 120.1 2005/06/17 03:55:24 appldev $ */
3:
4: -----------------------------------------------------------------------------
5: ---- Name : Remove_Timer_From_AQ
66: IF (l_timer_code <> 'T_DUMMY')
67: THEN
68: -- Call REMOVE_TIMER
69:
70: xnp_timer_core.remove_timer(
71: p_timer_id => l_timer_id
72: ,x_error_code => x_error_code
73: ,x_error_message => x_error_message
74: );
158:
159: ELSIF l_timer_code = 'T_DUMMY'
160:
161: THEN
162: xnp_timer_core.remove_timer(
163: p_timer_id => l_timer_id
164: ,x_error_code => x_error_code
165: ,x_error_message => x_error_message
166: );
261: BEGIN
262:
263: FOR rec IN c_recalculate_all_timers LOOP
264:
265: xnp_timer_core.recalculate(
266: p_reference_id => p_reference_id
267: ,p_timer_message_code => rec.timer_message_code
268: ,x_error_code => l_error_code
269: ,x_error_message => l_error_message);
490:
491: BEGIN
492:
493:
494: xnp_timer_core.update_timer_status(
495: p_timer_id => p_timer_id
496: ,p_status => 'REMOVED'
497: ,x_error_code => x_error_code
498: ,x_error_message => x_error_message
613: RAISE ex_timer_not_found;
614: END IF;
615: CLOSE c_timer_status_id;
616:
617: xnp_timer_core.remove_timer(
618: p_timer_id => l_timer_id
619: ,x_error_code => x_error_code
620: ,x_error_message => x_error_message
621: );
683: l_error_code := 0;
684: l_error_message := NULL;
685:
686: FOR rec IN c_deregister_timers LOOP
687: xnp_timer_core.remove_timer (
688: p_timer_id => rec.timer_id
689: ,x_error_code => l_error_code
690: ,x_error_message => l_error_message
691: );
731: l_error_code := 0;
732: l_error_message := NULL;
733:
734: FOR rec IN c_deregister_timers LOOP
735: xnp_timer_core.remove_timer (
736: p_timer_id => rec.timer_id
737: ,x_error_code => l_error_code
738: ,x_error_message => l_error_message
739: );
826: ELSE
827: l_msg_to_create := l_next_timer_code;
828: END IF;
829:
830: xnp_timer_core.remove_timer(
831: p_timer_id => l_timer_id
832: ,x_error_code => x_error_code
833: ,x_error_message => x_error_message
834: );
899: BEGIN
900:
901:
902: FOR rec IN c_restart_all_timers LOOP
903: xnp_timer_core.restart(
904: p_reference_id => p_reference_id
905: ,p_timer_message_code => rec.timer_message_code
906: ,x_error_code => l_error_code
907: ,x_error_message => l_error_message
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;
1111:
1111:
1112: END FIRE;
1113:
1114:
1115: END xnp_timer_core;