eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XNP_TIMER_CORE dependencies on XNP_TIMER

Line 1: PACKAGE BODY xnp_timer_core AS

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

Line 30: FROM xnp_timer_registry

26: IS
27: CURSOR c_timer_data IS
28: SELECT timer_id, timer_message_code,
29: next_timer,start_time
30: FROM xnp_timer_registry
31: WHERE reference_id = p_reference_id
32: AND (timer_message_code = p_timer_message_code
33: OR next_timer = p_timer_message_code
34: )

Line 70: xnp_timer_core.remove_timer(

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: );

Line 129: xnp_timer_mgr.construct_dynamic_message(

125: l_interval := TO_NUMBER(l_interval_text);
126: l_new_interval := l_interval - l_elapsed_time;
127:
128: -- Reconstruct the message
129: xnp_timer_mgr.construct_dynamic_message(
130: p_msg_to_create => l_old_msg_header.message_code
131: ,p_old_msg_header => l_old_msg_header
132: ,p_delay => l_new_delay
133: ,p_interval => l_new_interval

Line 146: xnp_timer.start_timer(

142: raise l_EXCEPTION;
143: END IF;
144:
145:
146: xnp_timer.start_timer(
147: p_msg_header => l_msg_header
148: ,p_msg_text => l_msg_text
149: ,x_error_code => x_error_code
150: ,x_error_message => x_error_message

Line 162: xnp_timer_core.remove_timer(

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: );

Line 198: xnp_timer_mgr.construct_dynamic_message(

194: xnp_message.get_header(
195: p_msg_id => l_timer_id
196: ,x_msg_header => l_old_msg_header);
197:
198: xnp_timer_mgr.construct_dynamic_message(
199: p_msg_to_create => l_next_timer_code
200: ,p_old_msg_header => l_old_msg_header
201: ,p_delay => l_new_delay
202: ,x_new_msg_header => l_msg_header

Line 213: xnp_timer.start_timer(

209: raise l_EXCEPTION;
210: END IF;
211:
212:
213: xnp_timer.start_timer(
214: p_msg_header => l_msg_header
215: ,p_msg_text => l_msg_text
216: ,x_error_code => x_error_code
217: ,x_error_message => x_error_message

Line 252: FROM xnp_timer_registry

248: IS
249:
250: CURSOR c_recalculate_all_timers IS
251: SELECT timer_message_code
252: FROM xnp_timer_registry
253: WHERE reference_id = p_reference_id
254: AND status = 'ACTIVE' ;
255:
256:

Line 265: xnp_timer_core.recalculate(

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);

Line 290: FROM xnp_timer_registry

286:
287: IS
288: CURSOR c_timer_status IS
289: SELECT status
290: FROM xnp_timer_registry
291: WHERE timer_id = p_timer_id;
292:
293: BEGIN
294:

Line 340: SELECT timer_id, status FROM xnp_timer_registry

336: -- status asc (ACTIVE, EXPIRED, REMOVED)
337: -- Only the first record will be processed.
338:
339: CURSOR c_timer_status IS
340: SELECT timer_id, status FROM xnp_timer_registry
341: WHERE reference_id = p_reference_id
342: AND timer_message_code = p_timer_message_code
343: ORDER BY status ASC;
344:

Line 396: FROM xnp_timer_registry

392: -- Only the first record will be processed.
393:
394: CURSOR c_update_timer_status IS
395: SELECT *
396: FROM xnp_timer_registry
397: WHERE reference_id = p_reference_id
398: AND timer_message_code = p_timer_message_code
399: ORDER BY status ASC
400: FOR UPDATE OF status;

Line 402: v_Timer_Registry xnp_timer_registry%ROWTYPE;

398: AND timer_message_code = p_timer_message_code
399: ORDER BY status ASC
400: FOR UPDATE OF status;
401:
402: v_Timer_Registry xnp_timer_registry%ROWTYPE;
403: BEGIN
404: x_error_code := 0;
405: x_error_message := NULL ;
406:

Line 412: UPDATE xnp_timer_registry

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

Line 440: FROM xnp_timer_registry

436: )
437: IS
438: CURSOR c_update_timer_status IS
439: SELECT *
440: FROM xnp_timer_registry
441: WHERE timer_id = p_timer_id
442: FOR UPDATE OF status;
443:
444: v_Timer_Registry xnp_timer_registry%ROWTYPE;

Line 444: v_Timer_Registry xnp_timer_registry%ROWTYPE;

440: FROM xnp_timer_registry
441: WHERE timer_id = p_timer_id
442: FOR UPDATE OF status;
443:
444: v_Timer_Registry xnp_timer_registry%ROWTYPE;
445:
446: BEGIN
447: x_error_code := 0;
448: x_error_message := NULL ;

Line 459: UPDATE xnp_timer_registry

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;
462: END IF;
463: CLOSE c_update_timer_status;

Line 494: xnp_timer_core.update_timer_status(

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

Line 592: SELECT timer_id FROM xnp_timer_registry

588: -- In case timer is not active, it will remain in its original state and
589: -- will not be removed as it is the business logic that timer has expired
590:
591: CURSOR c_timer_status_id IS
592: SELECT timer_id FROM xnp_timer_registry
593: WHERE reference_id = p_reference_id
594: AND (timer_message_code = p_timer_message_code
595: OR next_timer = p_timer_message_code)
596: AND status = 'ACTIVE'

Line 617: xnp_timer_core.remove_timer(

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: );

Line 675: SELECT timer_id FROM xnp_timer_registry

671: ,x_error_message OUT NOCOPY VARCHAR2
672: )
673: IS
674: CURSOR c_deregister_timers IS
675: SELECT timer_id FROM xnp_timer_registry
676: WHERE order_id = p_order_id
677: AND status = 'ACTIVE';
678:
679: l_error_code NUMBER;

Line 687: xnp_timer_core.remove_timer (

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: );

Line 723: SELECT timer_id FROM xnp_timer_registry

719: ,x_error_message OUT NOCOPY VARCHAR2
720: )
721: IS
722: CURSOR c_deregister_timers IS
723: SELECT timer_id FROM xnp_timer_registry
724: WHERE wi_instance_id = p_workitem_instance_id
725: AND status = 'ACTIVE';
726:
727: l_error_code NUMBER;

Line 735: xnp_timer_core.remove_timer (

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: );

Line 771: FROM xnp_timer_registry

767: l_next_timer VARCHAR2(80) ;
768:
769: CURSOR c_next_timer IS
770: SELECT next_timer
771: FROM xnp_timer_registry
772: WHERE timer_id = p_timer_id ;
773:
774: BEGIN
775:

Line 800: FROM xnp_timer_registry

796: IS
797: CURSOR c_timer_data IS
798: SELECT timer_id, timer_message_code,
799: next_timer
800: FROM xnp_timer_registry
801: WHERE reference_id = p_reference_id
802: AND (timer_message_code = p_timer_message_code
803: OR next_timer = p_timer_message_code
804: )

Line 830: xnp_timer_core.remove_timer(

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: );

Line 846: xnp_timer_mgr.construct_dynamic_message(

842: ,x_msg_header => l_old_msg_header);
843:
844: -- Reconstruct the message
845:
846: xnp_timer_mgr.construct_dynamic_message(
847: p_msg_to_create => l_msg_to_create
848: ,p_old_msg_header => l_old_msg_header
849: ,x_new_msg_header => l_msg_header
850: ,x_new_msg_text => l_msg_text

Line 859: xnp_timer.start_timer(

855: IF x_error_code <> 0 THEN
856: raise l_EXCEPTION;
857: END IF;
858:
859: xnp_timer.start_timer(
860: p_msg_header => l_msg_header
861: ,p_msg_text => l_msg_text
862: ,x_error_code => x_error_code
863: ,x_error_message => x_error_message

Line 891: FROM xnp_timer_registry

887: )
888: IS
889: CURSOR c_restart_all_timers IS
890: SELECT timer_message_code
891: FROM xnp_timer_registry
892: WHERE reference_id = p_reference_id
893: AND status = 'ACTIVE' ;
894:
895: l_timer_message_code VARCHAR2(20);

Line 903: xnp_timer_core.restart(

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

Line 936: FROM xnp_timer_publishers

932: )
933: IS
934: CURSOR c_get_all_timers IS
935: SELECT timer_message_code
936: FROM xnp_timer_publishers
937: WHERE source_message_code = p_message_code ;
938:
939: l_old_msg_header xnp_message.msg_header_rec_type ;
940: l_new_msg_header xnp_message.msg_header_rec_type ;

Line 959: xnp_timer_mgr.construct_dynamic_message(

955: l_old_msg_header.fa_instance_id := p_fa_instance_id ;
956:
957: FOR rec IN c_get_all_timers LOOP
958:
959: xnp_timer_mgr.construct_dynamic_message(
960: p_msg_to_create => rec.timer_message_code,
961: p_old_msg_header => l_old_msg_header,
962: x_new_msg_header => l_new_msg_header,
963: x_new_msg_text => l_msg_text,

Line 969: xnp_timer.start_timer(l_new_msg_header,

965: x_error_message => x_error_message) ;
966:
967: IF (x_error_code = 0) THEN
968:
969: xnp_timer.start_timer(l_new_msg_header,
970: l_msg_text ,
971: x_error_code,
972: x_error_message);
973:

Line 1107: ,'XNP_TIMER_CORE.FIRE');

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:

Line 1115: END xnp_timer_core;

1111:
1112: END FIRE;
1113:
1114:
1115: END xnp_timer_core;