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.XDP_AQ_UTILITIES dependencies on DBMS_LOCK

Line 441: dbms_lock.sleep(3);

437: END IF;
438: END IF;
439:
440: ELSIF lv_queue_state = 'SUSPENDED' THEN -- notify dequeuer to sleep
441: dbms_lock.sleep(3);
442: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
443: return;
444: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
445: dbms_lock.sleep(3);

Line 445: dbms_lock.sleep(3);

441: dbms_lock.sleep(3);
442: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
443: return;
444: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
445: dbms_lock.sleep(3);
446: ELSIF lv_queue_state = 'DATA_NOT_FOUND' THEN -- notify dequeuer to exit
447: return;
448: ELSE -- notify dequeuer to exit
449: return;

Line 795: dbms_lock.sleep(3);

791:
792: end if;
793:
794: ELSIF lv_queue_state = 'SUSPENDED' THEN --otify dequeuer to sleep
795: dbms_lock.sleep(3);
796: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
797: return;
798: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
799: dbms_lock.sleep(3);

Line 799: dbms_lock.sleep(3);

795: dbms_lock.sleep(3);
796: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
797: return;
798: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
799: dbms_lock.sleep(3);
800: ELSIF lv_queue_state = 'DATA_NOT_FOUND' THEN -- notify dequeuer to exit
801: return;
802: ELSE -- notify dequeuer to exit
803: return;

Line 1087: dbms_lock.sleep(3);

1083: rollback to workitem_q_tag;
1084: end if;
1085:
1086: ELSIF lv_queue_state = 'SUSPENDED' THEN -- Notify dequeuer to sleep
1087: dbms_lock.sleep(3);
1088: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
1089: return;
1090: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
1091: dbms_lock.sleep(3);

Line 1091: dbms_lock.sleep(3);

1087: dbms_lock.sleep(3);
1088: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
1089: return;
1090: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
1091: dbms_lock.sleep(3);
1092: ELSIF lv_queue_state = 'DATA_NOT_FOUND' THEN -- notify dequeuer to exit
1093: return;
1094: ELSE -- notify dequeuer to exit
1095: return;

Line 1380: dbms_lock.sleep(3);

1376: rollback to fa_q_tag;
1377: end if;
1378:
1379: ELSIF lv_queue_state = 'SUSPENDED' THEN -- notify dequeuer to sleep
1380: dbms_lock.sleep(3);
1381: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
1382: return;
1383: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
1384: dbms_lock.sleep(3);

Line 1384: dbms_lock.sleep(3);

1380: dbms_lock.sleep(3);
1381: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
1382: return;
1383: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
1384: dbms_lock.sleep(3);
1385: ELSIF lv_queue_state = 'DATA_NOT_FOUND' THEN -- notify dequeuer to exit
1386: return;
1387: ELSE -- notify dequeuer to exit
1388: return;

Line 1660: dbms_lock.sleep(3);

1656: END IF;
1657: commit;
1658:
1659: ELSIF lv_queue_state = 'SUSPENDED' THEN -- notify dequeuer to sleep
1660: dbms_lock.sleep(3);
1661: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
1662: return;
1663: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
1664: dbms_lock.sleep(3);

Line 1664: dbms_lock.sleep(3);

1660: dbms_lock.sleep(3);
1661: ELSIF lv_queue_state = 'SHUTDOWN' THEN -- notify dequeuer to exit
1662: return;
1663: ELSIF lv_queue_state = 'DISABLED' THEN -- notify dequeuer to exit
1664: dbms_lock.sleep(3);
1665: ELSIF lv_queue_state = 'DATA_NOT_FOUND' THEN -- notify dequeuer to exit
1666: return;
1667: ELSE -- notify dequeuer to exit
1668: return;

Line 1994: dbms_lock.sleep(3);

1990: raise_application_error(-20530,SQLERRM);
1991: END;
1992:
1993: ELSIF lv_queue_state = 'SUSPENDED' THEN /* notify dequeuer to sleep */
1994: dbms_lock.sleep(3);
1995: ELSIF lv_queue_state = 'SHUTDOWN' THEN /* notify dequeuer to exit */
1996: return;
1997: ELSIF lv_queue_state = 'DISABLED' THEN /* notify dequeuer to exit */
1998: dbms_lock.sleep(3);

Line 1998: dbms_lock.sleep(3);

1994: dbms_lock.sleep(3);
1995: ELSIF lv_queue_state = 'SHUTDOWN' THEN /* notify dequeuer to exit */
1996: return;
1997: ELSIF lv_queue_state = 'DISABLED' THEN /* notify dequeuer to exit */
1998: dbms_lock.sleep(3);
1999: ELSIF lv_queue_state = 'DATA_NOT_FOUND' THEN /* notify dequeuer to exit */
2000: return;
2001: ELSE /* notify dequeuer to exit */
2002: return;

Line 2563: DBMS_LOCK.SLEEP(g_sleep_time);

2559: EXIT ;
2560: END IF ;
2561:
2562: l_dq_count := l_dq_count + 1 ;
2563: DBMS_LOCK.SLEEP(g_sleep_time);
2564:
2565: END LOOP ;
2566:
2567: fnd_file.put_line(fnd_file.output,'Total Number of Events Dequeued : '||l_dq_count );

Line 2607: DBMS_LOCK.SLEEP(g_sleep_time);

2603: EXIT ;
2604: END IF ;
2605:
2606: l_dq_count := l_dq_count + 1 ;
2607: DBMS_LOCK.SLEEP(g_sleep_time);
2608:
2609: END LOOP ;
2610:
2611: fnd_file.put_line(fnd_file.output,'Total Number of Messages Dequeued : '||l_dq_count );

Line 2651: DBMS_LOCK.SLEEP(g_sleep_time);

2647: EXIT ;
2648: END IF ;
2649:
2650: l_dq_count := l_dq_count + 1 ;
2651: DBMS_LOCK.SLEEP(g_sleep_time);
2652:
2653: END LOOP ;
2654: fnd_file.put_line(fnd_file.output,'Total Number of Timers Dequeued: '||l_dq_count );
2655:

Line 2693: DBMS_LOCK.SLEEP(g_sleep_time);

2689: EXIT ;
2690: END IF ;
2691:
2692: l_dq_count := l_dq_count + 1 ;
2693: DBMS_LOCK.SLEEP(g_sleep_time);
2694:
2695: END LOOP ;
2696: fnd_file.put_line(fnd_file.output,'Total Number of Orders Dequeued : '||l_dq_count );
2697:

Line 2735: DBMS_LOCK.SLEEP(g_sleep_time);

2731: EXIT ;
2732: END IF ;
2733:
2734: l_dq_count := l_dq_count + 1 ;
2735: DBMS_LOCK.SLEEP(g_sleep_time);
2736:
2737: END LOOP ;
2738: fnd_file.put_line(fnd_file.output,'Total Number of Fulfillment Actions Dequeued : '||l_dq_count );
2739:

Line 2779: DBMS_LOCK.SLEEP(g_sleep_time);

2775: EXIT ;
2776: END IF ;
2777:
2778: l_dq_count := l_dq_count + 1 ;
2779: DBMS_LOCK.SLEEP(g_sleep_time);
2780:
2781: END LOOP ;
2782: fnd_file.put_line(fnd_file.output,'Total Number FulFillment Element Ready Queue Dequeued : '||l_dq_count );
2783:

Line 2821: DBMS_LOCK.SLEEP(g_sleep_time);

2817: EXIT ;
2818: END IF ;
2819:
2820: l_dq_count := l_dq_count + 1 ;
2821: DBMS_LOCK.SLEEP(g_sleep_time);
2822:
2823: END LOOP ;
2824: fnd_file.put_line(fnd_file.output,'Total Number of Workitems Dequeued : '||l_dq_count );
2825:

Line 3024: DBMS_LOCK.SLEEP(g_sleep_time);

3020: p_wf_item_key => lv_wf_object.WF_ITEM_KEY );
3021: END IF ;
3022:
3023: l_dq_count := l_dq_count + 1 ;
3024: DBMS_LOCK.SLEEP(g_sleep_time);
3025:
3026: END LOOP ;
3027: fnd_file.put_line(fnd_file.output,'Total Number of Orders Dequeued from Order Exception Queue : '||l_dq_count );
3028:

Line 3100: DBMS_LOCK.SLEEP(g_sleep_time);

3096: END IF;
3097:
3098: END IF ;
3099: l_dq_count := l_dq_count + 1 ;
3100: DBMS_LOCK.SLEEP(g_sleep_time);
3101:
3102: END LOOP ;
3103: fnd_file.put_line(fnd_file.output,'Total Number of Fulfillment Actions Dequeued from Fulfillment Actions Exception Queue : '||l_dq_count );
3104:

Line 3176: DBMS_LOCK.SLEEP(g_sleep_time);

3172: END IF;
3173:
3174: END IF ;
3175: l_dq_count := l_dq_count + 1 ;
3176: DBMS_LOCK.SLEEP(g_sleep_time);
3177:
3178: END LOOP ;
3179: fnd_file.put_line(fnd_file.output,'Total Number of WorkItems dequeued from WorkItem Exception Queue : '||l_dq_count );
3180:

Line 3271: DBMS_LOCK.SLEEP(g_sleep_time);

3267: END IF;
3268:
3269: END IF ;
3270: l_dq_count := l_dq_count + 1 ;
3271: DBMS_LOCK.SLEEP(g_sleep_time);
3272:
3273: END LOOP ;
3274: fnd_file.put_line(fnd_file.output,'Total Number dequeued from FE Ready Exception Queue : '||l_dq_count );
3275:

Line 3333: DBMS_LOCK.SLEEP(g_sleep_time);

3329:
3330: END IF ;
3331:
3332: l_dq_count := l_dq_count + 1 ;
3333: DBMS_LOCK.SLEEP(g_sleep_time);
3334:
3335: END LOOP ;
3336:
3337: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Inbound Messages Exception Queue : '||l_dq_count );

Line 3396: DBMS_LOCK.SLEEP(g_sleep_time);

3392: p_commit_mode => xnp_message.c_on_commit );
3393:
3394: END IF ;
3395: l_dq_count := l_dq_count + 1 ;
3396: DBMS_LOCK.SLEEP(g_sleep_time);
3397:
3398: END LOOP ;
3399: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Events Exception Queue : '||l_dq_count );
3400:

Line 3458: DBMS_LOCK.SLEEP(g_sleep_time);

3454: p_commit_mode => xnp_message.c_on_commit);
3455:
3456: END IF ;
3457: l_dq_count := l_dq_count + 1 ;
3458: DBMS_LOCK.SLEEP(g_sleep_time);
3459:
3460: END LOOP ;
3461: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Timer Exception Queue : '||l_dq_count );
3462:

Line 3561: DBMS_LOCK.SLEEP(g_sleep_time);

3557: payload => l_message,
3558: msgid => message_handle );
3559:
3560: l_dq_count := l_dq_count + 1 ;
3561: DBMS_LOCK.SLEEP(g_sleep_time);
3562:
3563: END LOOP ;
3564:
3565: fnd_file.put_line(fnd_file.output,'Total Number dequeued from Outbound Msg Exception Queue : '||l_dq_count );