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 234: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

230: result in out nocopy number) is
231: ecode number;
232: timeout number;
233: begin
234: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
235: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
236: 'fnd.plsql.FND_DCP.REQUEST_SESSION_LOCK',
237: 'request_session_lock called for apid='||to_char(apid)||
238: ', qid='||to_char(qid)||', pid='||to_char(pid));

Line 235: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

231: ecode number;
232: timeout number;
233: begin
234: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
235: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
236: 'fnd.plsql.FND_DCP.REQUEST_SESSION_LOCK',
237: 'request_session_lock called for apid='||to_char(apid)||
238: ', qid='||to_char(qid)||', pid='||to_char(pid));
239: end if;

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

250: else
251: lk := FNDCPLK || apid || '_' || qid || '_' || pid;
252: timeout := null; -- Others wait MAXWAIT for lock request.
253: end if;
254: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
255: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
256: 'fnd.plsql.FND_DCP.REQUEST_SESSION_LOCK',
257: 'lock name='||lk);
258: end if;

Line 255: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

251: lk := FNDCPLK || apid || '_' || qid || '_' || pid;
252: timeout := null; -- Others wait MAXWAIT for lock request.
253: end if;
254: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
255: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
256: 'fnd.plsql.FND_DCP.REQUEST_SESSION_LOCK',
257: 'lock name='||lk);
258: end if;
259:

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

272: lk := null;
273: hndl := null;
274: return;
275: else
276: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
277: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
278: 'fnd.plsql.FND_DCP.REQUEST_SESSION_LOCK',
279: 'for lock name='||lk||' hndl='||hndl);
280: end if;

Line 277: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

273: hndl := null;
274: return;
275: else
276: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
277: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
278: 'fnd.plsql.FND_DCP.REQUEST_SESSION_LOCK',
279: 'for lock name='||lk||' hndl='||hndl);
280: end if;
281: end if;

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

286: request_lock (hndl => hndl,
287: lmode => 6,
288: timeout => timeout,
289: result => result);
290: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
291: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
292: 'fnd.plsql.FND_DCP.REQUEST_SESSION_LOCK',
293: 'result of request_lock: '||to_char(result));
294: end if;

Line 291: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

287: lmode => 6,
288: timeout => timeout,
289: result => result);
290: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
291: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
292: 'fnd.plsql.FND_DCP.REQUEST_SESSION_LOCK',
293: 'result of request_lock: '||to_char(result));
294: end if;
295:

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

324:
325: dummy number;
326:
327: begin
328: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
329: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
330: 'fnd.plsql.FND_DCP.CHECK_PROCESS_STATUS_BY_HANDLE',
331: 'check_process_status_by_handle called for hndl='||hndl);
332: end if;

Line 329: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

325: dummy number;
326:
327: begin
328: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
329: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
330: 'fnd.plsql.FND_DCP.CHECK_PROCESS_STATUS_BY_HANDLE',
331: 'check_process_status_by_handle called for hndl='||hndl);
332: end if;
333:

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

337: request_lock (hndl => hndl,
338: lmode => 2,
339: timeout => 0,
340: result => result);
341: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
342: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
343: 'fnd.plsql.FND_DCP.CHECK_PROCESS_STATUS_BY_HANDLE',
344: 'result of request_lock: '||to_char(result));
345: end if;

Line 342: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

338: lmode => 2,
339: timeout => 0,
340: result => result);
341: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
342: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
343: 'fnd.plsql.FND_DCP.CHECK_PROCESS_STATUS_BY_HANDLE',
344: 'result of request_lock: '||to_char(result));
345: end if;
346:

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

533:
534: result number;
535:
536: begin
537: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
539: 'fnd.plsql.FND_DCP.RELEASE_LOCK',
540: 'release_lock called for hndl='||hndl);
541: end if;

Line 538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

534: result number;
535:
536: begin
537: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
538: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
539: 'fnd.plsql.FND_DCP.RELEASE_LOCK',
540: 'release_lock called for hndl='||hndl);
541: end if;
542: result := dbms_lock.release (hndl);

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

545: e_code := NTRUE;
546: else
547: e_code := NFALSE;
548: end if;
549: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
550: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
551: 'fnd.plsql.FND_DCP.RELEASE_LOCK',
552: 'release result='||to_char(result));
553: end if;

Line 550: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

546: else
547: e_code := NFALSE;
548: end if;
549: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
550: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
551: 'fnd.plsql.FND_DCP.RELEASE_LOCK',
552: 'release result='||to_char(result));
553: end if;
554: exception

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

602:
603: if (hndl is not null) then
604: result := dbms_lock.request (hndl, 6, 0); -- ULX lock
605:
606: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
607: fnd_log.string(FND_LOG.LEVEL_EVENT,
608: 'fnd.plsql.FND_DCP.MONITOR_ICM',
609: 'lock request result='||to_char(result)||' for hndl='||hndl);
610: end if;

Line 607: fnd_log.string(FND_LOG.LEVEL_EVENT,

603: if (hndl is not null) then
604: result := dbms_lock.request (hndl, 6, 0); -- ULX lock
605:
606: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
607: fnd_log.string(FND_LOG.LEVEL_EVENT,
608: 'fnd.plsql.FND_DCP.MONITOR_ICM',
609: 'lock request result='||to_char(result)||' for hndl='||hndl);
610: end if;
611:

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

619:
620: end if; -- PMON method TSTAMP/DBLOCK
621:
622: if (cpid is null) then
623: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
624: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
625: 'get_icm_info returned cpid NULL');
626: end if;
627:

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

620: end if; -- PMON method TSTAMP/DBLOCK
621:
622: if (cpid is null) then
623: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
624: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
625: 'get_icm_info returned cpid NULL');
626: end if;
627:
628: up := NTRUE;

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

630: rollback;
631: return;
632:
633: else
634: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
635: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
636: 'get_icm_info returned cpid='||to_char(cpid));
637: end if;
638:

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

631: return;
632:
633: else
634: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
635: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
636: 'get_icm_info returned cpid='||to_char(cpid));
637: end if;
638:
639: lk := FNDCPLK || '0_1_' || cpid;

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

639: lk := FNDCPLK || '0_1_' || cpid;
640: dbms_lock.allocate_unique (lk, hndl, EON);
641: result := dbms_lock.request (hndl, 6, 0); -- ULX lock
642:
643: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
644: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
645: 'new lock name = '||lk);
646: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
647: 'lock request result='||to_char(result)||' for hndl='||hndl);

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

640: dbms_lock.allocate_unique (lk, hndl, EON);
641: result := dbms_lock.request (hndl, 6, 0); -- ULX lock
642:
643: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
644: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
645: 'new lock name = '||lk);
646: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
647: 'lock request result='||to_char(result)||' for hndl='||hndl);
648: end if;

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

642:
643: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
644: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
645: 'new lock name = '||lk);
646: fnd_log.string(FND_LOG.LEVEL_EVENT, 'fnd.plsql.FND_DCP.MONITOR_ICM',
647: 'lock request result='||to_char(result)||' for hndl='||hndl);
648: end if;
649:
650: if (result = 0) then -- Success

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

910: retval number := NFALSE;
911:
912: begin
913:
914: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
915: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
916: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
917: 'Enter TARGET_NODE_MGR_CHK for manager ('||
918: to_char(my_q_appl_id)|| '/'||my_q_id||

Line 915: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

911:
912: begin
913:
914: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
915: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
916: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
917: 'Enter TARGET_NODE_MGR_CHK for manager ('||
918: to_char(my_q_appl_id)|| '/'||my_q_id||
919: ') and request_id '|| to_char(req_id));

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

924: into req_node
925: from fnd_concurrent_requests
926: where request_id = req_id;
927:
928: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
929: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
930: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
931: 'Target node for request '||to_char(req_id)||' is '||
932: NVL(req_node,'NULL'));

Line 929: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

925: from fnd_concurrent_requests
926: where request_id = req_id;
927:
928: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
929: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
930: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
931: 'Target node for request '||to_char(req_id)||' is '||
932: NVL(req_node,'NULL'));
933: end if;

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

946: where application_id = my_q_appl_id
947: and concurrent_queue_id = my_q_id;
948: end if;
949:
950: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
951: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
952: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
953: 'Manager node is '||NVL(my_node,'NULL'));
954: end if;

Line 951: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

947: and concurrent_queue_id = my_q_id;
948: end if;
949:
950: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
951: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
952: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
953: 'Manager node is '||NVL(my_node,'NULL'));
954: end if;
955:

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

967: where node_name = req_node
968: and (node_mode <> 'O'
969: or status <> 'Y');
970:
971: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
972: if dummy >= 1 then
973: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
974: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
975: 'Request target node '||req_node||' is DOWN');

Line 973: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

969: or status <> 'Y');
970:
971: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
972: if dummy >= 1 then
973: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
974: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
975: 'Request target node '||req_node||' is DOWN');
976: else
977: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 977: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

973: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
974: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
975: 'Request target node '||req_node||' is DOWN');
976: else
977: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
978: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
979: 'Request target node '||req_node||' is UP');
980: end if;
981: end if;

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

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

Line 990: fnd_log.message(FND_LOG.LEVEL_EVENT,

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

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

996:
997: /* Check if a manager is available to run this request on target node */
998: /* The first available manager we find, exit and return NFALSE */
999: if (retval = NFALSE) then
1000: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1001: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1002: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1003: 'Enter loop to determine if another manager can run');
1004: end if;

Line 1001: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

997: /* Check if a manager is available to run this request on target node */
998: /* The first available manager we find, exit and return NFALSE */
999: if (retval = NFALSE) then
1000: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1001: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1002: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1003: 'Enter loop to determine if another manager can run');
1004: end if;
1005: for mgr_rec in mgr_cursor(req_id, my_q_appl_id, my_q_id) loop

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

1007: and (mgr_rec.max_processes > 0)
1008: and (mgr_rec.running_processes > 0)
1009: and mgr_rec.target_node = req_node) then
1010: /* Here is an available manager, no need to continue. */
1011: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1012: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1013: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1014: 'Another manager ('||
1015: to_char(mgr_rec.queue_application_id )||'/'||

Line 1012: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1008: and (mgr_rec.running_processes > 0)
1009: and mgr_rec.target_node = req_node) then
1010: /* Here is an available manager, no need to continue. */
1011: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1012: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1013: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1014: 'Another manager ('||
1015: to_char(mgr_rec.queue_application_id )||'/'||
1016: to_char(mgr_rec.concurrent_queue_id)||

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

1022: retval := NTRUE;
1023: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
1024: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
1025: fnd_message.set_token ('NODE', req_node, FALSE);
1026: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1027: fnd_log.message(FND_LOG.LEVEL_EVENT,
1028: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1029: FALSE);
1030: end if;

Line 1027: fnd_log.message(FND_LOG.LEVEL_EVENT,

1023: fnd_message.set_name ('FND', 'CONC-REQ NODE NOT HONORED');
1024: fnd_message.set_token ('REQID', to_char(req_id), FALSE);
1025: fnd_message.set_token ('NODE', req_node, FALSE);
1026: if( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1027: fnd_log.message(FND_LOG.LEVEL_EVENT,
1028: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1029: FALSE);
1030: end if;
1031: end if;

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

1031: end if;
1032: end loop;
1033: end if;
1034:
1035: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1036: if retval = NTRUE then
1037: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1038: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1039: 'Returning retval= NTRUE');

Line 1037: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1033: end if;
1034:
1035: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1036: if retval = NTRUE then
1037: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1038: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1039: 'Returning retval= NTRUE');
1040: else
1041: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1041: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

1037: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1038: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1039: 'Returning retval= NTRUE');
1040: else
1041: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1042: 'fnd.plsql.FND_DCP.TARGET_NODE_MGR_CHK',
1043: 'Returning retval= NFALSE');
1044: end if;
1045: end if;