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.FND_DCP dependencies on FND_LOG

Line 68: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

64: where queue_application_id = 0
65: and concurrent_queue_id = 1
66: and process_status_code in ('A', 'M', 'K'));
67:
68: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
69: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.GET_ICM_INFO',
70: 'ICM info: cpid=' ||cpid||', node='||node||', inst=' ||inst);
71: end if;
72:

Line 69: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.GET_ICM_INFO',

65: and concurrent_queue_id = 1
66: and process_status_code in ('A', 'M', 'K'));
67:
68: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
69: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.GET_ICM_INFO',
70: 'ICM info: cpid=' ||cpid||', node='||node||', inst=' ||inst);
71: end if;
72:
73: return (cpid);

Line 565: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

561:
562: if (hndl is not null) then
563: result := dbms_lock.request (hndl, 6, 0); -- ULX lock
564:
565: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
566: fnd_log.string(FND_LOG.LEVEL_EVENT,
567: 'fnd.plsql.FND_DCP.MONITOR_ICM',
568: 'lock request result='||to_char(result)||' for hndl='||hndl);
569: end if;

Line 566: fnd_log.string(FND_LOG.LEVEL_EVENT,

562: if (hndl is not null) then
563: result := dbms_lock.request (hndl, 6, 0); -- ULX lock
564:
565: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
566: fnd_log.string(FND_LOG.LEVEL_EVENT,
567: 'fnd.plsql.FND_DCP.MONITOR_ICM',
568: 'lock request result='||to_char(result)||' for hndl='||hndl);
569: end if;
570:

Line 582: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

578:
579: end if; -- PMON method TSTAMP/DBLOCK
580:
581: if (cpid is null) then
582: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
583: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
584: 'get_icm_info returned cpid NULL');
585: end if;
586:

Line 583: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',

579: end if; -- PMON method TSTAMP/DBLOCK
580:
581: if (cpid is null) then
582: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
583: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
584: 'get_icm_info returned cpid NULL');
585: end if;
586:
587: up := NTRUE;

Line 593: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

589: rollback;
590: return;
591:
592: else
593: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
594: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
595: 'get_icm_info returned cpid='||to_char(cpid));
596: end if;
597:

Line 594: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',

590: return;
591:
592: else
593: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
594: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
595: 'get_icm_info returned cpid='||to_char(cpid));
596: end if;
597:
598: lk := FNDCPLK || '0_1_' || cpid;

Line 602: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

598: lk := FNDCPLK || '0_1_' || cpid;
599: dbms_lock.allocate_unique (lk, hndl, EON);
600: result := dbms_lock.request (hndl, 6, 0); -- ULX lock
601:
602: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
603: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
604: 'new lock name = '||lk);
605: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
606: 'lock request result='||to_char(result)||' for hndl='||hndl);

Line 603: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',

599: dbms_lock.allocate_unique (lk, hndl, EON);
600: result := dbms_lock.request (hndl, 6, 0); -- ULX lock
601:
602: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
603: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
604: 'new lock name = '||lk);
605: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
606: 'lock request result='||to_char(result)||' for hndl='||hndl);
607: end if;

Line 605: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',

601:
602: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
603: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
604: 'new lock name = '||lk);
605: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
606: 'lock request result='||to_char(result)||' for hndl='||hndl);
607: end if;
608:
609: if (result = 0) then -- Success

Line 873: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

869: retval number := NFALSE;
870:
871: begin
872:
873: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
874: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
875: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
876: 'Enter TARGET_NODE_MGR_CHK for manager ('||
877: to_char(my_q_appl_id)|| '/'||my_q_id||

Line 874: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

870:
871: begin
872:
873: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
874: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
875: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
876: 'Enter TARGET_NODE_MGR_CHK for manager ('||
877: to_char(my_q_appl_id)|| '/'||my_q_id||
878: ') and request_id '|| to_char(req_id));

Line 887: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

883: into req_node
884: from fnd_concurrent_requests
885: where request_id = req_id;
886:
887: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
888: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
889: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
890: 'Target node for request '||to_char(req_id)||' is '||
891: NVL(req_node,'NULL'));

Line 888: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

884: from fnd_concurrent_requests
885: where request_id = req_id;
886:
887: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
888: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
889: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
890: 'Target node for request '||to_char(req_id)||' is '||
891: NVL(req_node,'NULL'));
892: end if;

Line 909: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

905: where application_id = my_q_appl_id
906: and concurrent_queue_id = my_q_id;
907: end if;
908:
909: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
910: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
911: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
912: 'Manager node is '||NVL(my_node,'NULL'));
913: end if;

Line 910: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

906: and concurrent_queue_id = my_q_id;
907: end if;
908:
909: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
910: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
911: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
912: 'Manager node is '||NVL(my_node,'NULL'));
913: end if;
914:

Line 930: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

926: where node_name = req_node
927: and (node_mode <> 'O'
928: or status <> 'Y');
929:
930: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
931: if dummy >= 1 then
932: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
933: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
934: 'Request target node '||req_node||' is DOWN');

Line 932: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

928: or status <> 'Y');
929:
930: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
931: if dummy >= 1 then
932: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
933: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
934: 'Request target node '||req_node||' is DOWN');
935: else
936: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 936: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

932: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
933: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
934: 'Request target node '||req_node||' is DOWN');
935: else
936: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
937: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
938: 'Request target node '||req_node||' is UP');
939: end if;
940: end if;

Line 948: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

944: retval := NTRUE;
945: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
946: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
947: fnd_message.set_token ('NODE', req_node, FALSE);
948: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
949: fnd_log.message(FND_LOG.LEVEL_EVENT,
950: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
951: FALSE);
952: end if;

Line 949: fnd_log.message(FND_LOG.LEVEL_EVENT,

945: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
946: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
947: fnd_message.set_token ('NODE', req_node, FALSE);
948: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
949: fnd_log.message(FND_LOG.LEVEL_EVENT,
950: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
951: FALSE);
952: end if;
953: end if;

Line 959: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

955:
956: /* Check if a manager is available to run this request on target node */
957: /* The first available manager we find, exit and return NFALSE */
958: if (retval = NFALSE) then
959: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
960: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
961: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
962: 'Enter loop to determine if another manager can run');
963: end if;

Line 960: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

956: /* Check if a manager is available to run this request on target node */
957: /* The first available manager we find, exit and return NFALSE */
958: if (retval = NFALSE) then
959: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
960: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
961: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
962: 'Enter loop to determine if another manager can run');
963: end if;
964: for mgr_rec in mgr_cursor(req_id, my_q_appl_id, my_q_id) loop

Line 970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

966: and (mgr_rec.max_processes > 0)
967: and (mgr_rec.running_processes > 0)
968: and mgr_rec.target_node = req_node) then
969: /* Here is an available manager, no need to continue. */
970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
971: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
972: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
973: 'Another manager ('||
974: to_char(mgr_rec.queue_application_id )||'/'||

Line 971: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

967: and (mgr_rec.running_processes > 0)
968: and mgr_rec.target_node = req_node) then
969: /* Here is an available manager, no need to continue. */
970: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
971: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
972: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
973: 'Another manager ('||
974: to_char(mgr_rec.queue_application_id )||'/'||
975: to_char(mgr_rec.concurrent_queue_id)||

Line 985: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

981: retval := NTRUE;
982: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
983: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
984: fnd_message.set_token ('NODE', req_node, FALSE);
985: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
986: fnd_log.message(FND_LOG.LEVEL_EVENT,
987: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
988: FALSE);
989: end if;

Line 986: fnd_log.message(FND_LOG.LEVEL_EVENT,

982: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
983: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
984: fnd_message.set_token ('NODE', req_node, FALSE);
985: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
986: fnd_log.message(FND_LOG.LEVEL_EVENT,
987: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
988: FALSE);
989: end if;
990: end if;

Line 994: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

990: end if;
991: end loop;
992: end if;
993:
994: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
995: if retval = NTRUE then
996: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
997: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
998: 'Returning retval= NTRUE');

Line 996: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

992: end if;
993:
994: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
995: if retval = NTRUE then
996: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
997: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
998: 'Returning retval= NTRUE');
999: else
1000: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1000: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

996: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
997: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
998: 'Returning retval= NTRUE');
999: else
1000: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1001: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1002: 'Returning retval= NFALSE');
1003: end if;
1004: end if;