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_APP_SERVER_PKG dependencies on FND_NODES

Line 135: -- Bug 3736714: Platform Code is required by FND_NODES to register a

131: l_node_name VARCHAR2(30) := UPPER(p_node_name);
132: l_platform_code VARCHAR2(30);
133:
134: BEGIN
135: -- Bug 3736714: Platform Code is required by FND_NODES to register a
136: -- node. AdminAppServer has been modified to support platform code.
137: l_platform_code := get_platform_code(p_platform_code);
138:
139: /* Bug 5279502: DESKTOP NODE SUPPORT IN FND_APP_SERVER_PKG */

Line 148: -- Check if node already exists in FND_NODES.

144: IF p_support_cp = 'N' and p_support_forms = 'N' and
145: p_support_web = 'N' and p_support_admin = 'N' and
146: p_support_db = 'N' and l_platform_code = '100000' then
147:
148: -- Check if node already exists in FND_NODES.
149: -- Desktop nodes use node_name as primary key.
150: select count(*) into kount
151: from fnd_nodes
152: where UPPER(node_name) = l_node_name;

Line 151: from fnd_nodes

147:
148: -- Check if node already exists in FND_NODES.
149: -- Desktop nodes use node_name as primary key.
150: select count(*) into kount
151: from fnd_nodes
152: where UPPER(node_name) = l_node_name;
153:
154: -- If node exists then update the desktop node.
155: IF kount > 0 THEN

Line 178: -- Check if node already exists in FND_NODES.

174: | Application Server Node |
175: ===========================*/
176: ELSE
177:
178: -- Check if node already exists in FND_NODES.
179: select count(*) into kount
180: from fnd_nodes
181: where server_address = p_address;
182:

Line 180: from fnd_nodes

176: ELSE
177:
178: -- Check if node already exists in FND_NODES.
179: select count(*) into kount
180: from fnd_nodes
181: where server_address = p_address;
182:
183: -- If node exists and
184: IF kount > 0 THEN

Line 196: from fnd_nodes

192: -- Then, get the node_id and node_name of the existing node
193: -- entry.
194: select node_id, node_name
195: into curr_node_id, curr_node_name
196: from fnd_nodes
197: where server_address = p_address;
198:
199: -- If the current node_name is not a fully qualified hostname
200: IF INSTR(curr_node_name, '.') = 0 THEN

Line 218: UPDATE FND_NODES

214:
215: -- Update the old node with the correct platform and null
216: -- out server_id and server_address so that the node does
217: -- not get referenced again.
218: UPDATE FND_NODES
219: SET PLATFORM_CODE = '87',
220: SERVER_ADDRESS = NULL,
221: SERVER_ID = NULL
222: WHERE NODE_ID = curr_node_id;

Line 226: from fnd_nodes

222: WHERE NODE_ID = curr_node_id;
223:
224: -- Added for Bug 3292353.
225: select count(*) into kount
226: from fnd_nodes
227: where UPPER(node_name) = l_node_name;
228:
229: -- Since fnd_concurrent.register_node() does not handle
230: -- the hostname at this time, it will be manually inserted

Line 252: -- FND_NODES.NODE_NAME should only have hostname if platform is not

248:
249: ELSE /* Node does not exist, the server will be inserted. */
250:
251: -- Check if p_node_name is a fully qualified hostname with domain.
252: -- FND_NODES.NODE_NAME should only have hostname if platform is not
253: -- UNIX Alpha.
254: if (l_platform_code <> '87' and INSTR(p_node_name, '.') <> 0) then
255: -- The hostname should be the beginning of the string up until
256: -- the first period. FND_NODES.NODE_NAME is stored in

Line 256: -- the first period. FND_NODES.NODE_NAME is stored in

252: -- FND_NODES.NODE_NAME should only have hostname if platform is not
253: -- UNIX Alpha.
254: if (l_platform_code <> '87' and INSTR(p_node_name, '.') <> 0) then
255: -- The hostname should be the beginning of the string up until
256: -- the first period. FND_NODES.NODE_NAME is stored in
257: -- UPPERCASE.
258: l_node_name := UPPER(SUBSTR(p_node_name, 0,
259: INSTR(p_node_name, '.') - 1));
260: end if;

Line 276: from fnd_nodes

272: db_tier => p_support_db);
273:
274: -- Added for Bug 3292353.
275: select count(*) into kount
276: from fnd_nodes
277: where UPPER(node_name) = l_node_name;
278:
279: -- Since fnd_concurrent.register_node() does not handle the hostname
280: -- at this time, it will be manually inserted using the

Line 310: ** Due to the migration of FND_APPLICATION_SERVERS to FND_NODES,

306:
307: /* delete_server
308: **
309: ** This procedure used to remove an Application Server row from the database.
310: ** Due to the migration of FND_APPLICATION_SERVERS to FND_NODES,
311: ** fnd_nodes.server_id is nulled out instead in order to preserve the
312: ** node_name and avoid dangling references to the node_name. This is called by
313: ** AdminAppServer.delSvrFromDB().
314: */

Line 311: ** fnd_nodes.server_id is nulled out instead in order to preserve the

307: /* delete_server
308: **
309: ** This procedure used to remove an Application Server row from the database.
310: ** Due to the migration of FND_APPLICATION_SERVERS to FND_NODES,
311: ** fnd_nodes.server_id is nulled out instead in order to preserve the
312: ** node_name and avoid dangling references to the node_name. This is called by
313: ** AdminAppServer.delSvrFromDB().
314: */
315: PROCEDURE delete_server (p_address IN VARCHAR2)

Line 319: UPDATE fnd_nodes

315: PROCEDURE delete_server (p_address IN VARCHAR2)
316: IS
317: BEGIN
318:
319: UPDATE fnd_nodes
320: SET server_id = NULL
321: WHERE server_address = p_address;
322:
323: EXCEPTION WHEN no_data_found THEN

Line 361: from fnd_nodes

357: select NODE_NAME, SUPPORT_CP, SUPPORT_FORMS, SUPPORT_WEB, SUPPORT_ADMIN,
358: SUPPORT_DB, PLATFORM_CODE
359: into l_node_name, l_support_cp, l_support_forms, l_support_web,
360: l_support_admin,l_support_db, l_platform
361: from fnd_nodes
362: where server_address = p_address;
363:
364: IF SQL%notfound THEN
365: RAISE no_data_found;

Line 376: UPDATE fnd_nodes

372: l_support_web <> 'N' or l_support_admin <> 'N' or
373: l_support_db <> 'N' or l_platform <> '100000' then
374:
375: IF(l_node_name <> UPPER(l_node_name)) THEN
376: UPDATE fnd_nodes
377: SET node_name = UPPER(l_node_name)
378: WHERE server_address = p_address;
379: END IF;
380:

Line 382: UPDATE fnd_nodes

378: WHERE server_address = p_address;
379: END IF;
380:
381: IF(p_server_id IS NOT NULL) THEN
382: UPDATE fnd_nodes
383: SET server_id = p_server_id
384: WHERE server_address = p_address;
385: END IF;
386:

Line 388: UPDATE fnd_nodes

384: WHERE server_address = p_address;
385: END IF;
386:
387: IF(p_description IS NOT NULL) THEN
388: UPDATE fnd_nodes
389: SET description = p_description
390: WHERE server_address = p_address;
391: END IF;
392:

Line 393: -- Added for Bug 3292353. ICX code will be calling FND_NODES.WEBHOST so

389: SET description = p_description
390: WHERE server_address = p_address;
391: END IF;
392:
393: -- Added for Bug 3292353. ICX code will be calling FND_NODES.WEBHOST so
394: -- there needs to be a way to populate/update the column. This may
395: -- later be changed to use CP APIs.
396: IF(p_webhost IS NOT NULL) THEN
397: UPDATE fnd_nodes

Line 397: UPDATE fnd_nodes

393: -- Added for Bug 3292353. ICX code will be calling FND_NODES.WEBHOST so
394: -- there needs to be a way to populate/update the column. This may
395: -- later be changed to use CP APIs.
396: IF(p_webhost IS NOT NULL) THEN
397: UPDATE fnd_nodes
398: SET webhost = p_webhost
399: WHERE server_address = p_address;
400: END IF;
401:

Line 409: UPDATE fnd_nodes

405: -- for the node needs to be updated.
406: IF (p_platform is NOT NULL) THEN
407: l_platform2 := get_platform_code(p_platform);
408:
409: UPDATE fnd_nodes
410: SET PLATFORM_CODE = l_platform2
411: WHERE server_address = p_address;
412: END IF;
413:

Line 415: Bug 3773424:AUTHENTICATION NODE HAS NO VALUES FOR FND_NODES.SUPPORT_*

411: WHERE server_address = p_address;
412: END IF;
413:
414: /*
415: Bug 3773424:AUTHENTICATION NODE HAS NO VALUES FOR FND_NODES.SUPPORT_*
416: COLUMNS. A system alert is being logged stating that it "Could not
417: contact Service Manager FNDSM_AUTHENTICATION_*". It seems that the
418: ICM attempts to tnsping all remote Service Managers using the query:
419:

Line 421: FROM FND_NODES

417: contact Service Manager FNDSM_AUTHENTICATION_*". It seems that the
418: ICM attempts to tnsping all remote Service Managers using the query:
419:
420: SELECT NODE_NAME, STATUS, NODE_MODE
421: FROM FND_NODES
422: WHERE NOT (SUPPORT_CP = 'N' AND
423: SUPPORT_WEB = 'N' AND SUPPORT_FORMS = 'N' AND
424: SUPPORT_ADMIN = 'N' AND SUPPORT_CP is NOT NULL AND
425: SUPPORT_WEB is NOT NULL AND

Line 438: UPDATE fnd_nodes

434:
435: IF (p_address = '*') THEN
436:
437: IF (l_support_cp is NULL) THEN
438: UPDATE fnd_nodes
439: SET SUPPORT_CP = 'N'
440: WHERE server_address = p_address;
441: END IF;
442:

Line 444: UPDATE fnd_nodes

440: WHERE server_address = p_address;
441: END IF;
442:
443: IF (l_support_forms is NULL) THEN
444: UPDATE fnd_nodes
445: SET SUPPORT_FORMS = 'N'
446: WHERE server_address = p_address;
447: END IF;
448:

Line 450: UPDATE fnd_nodes

446: WHERE server_address = p_address;
447: END IF;
448:
449: IF (l_support_web is NULL) THEN
450: UPDATE fnd_nodes
451: SET SUPPORT_WEB = 'N'
452: WHERE server_address = p_address;
453: END IF;
454:

Line 456: UPDATE fnd_nodes

452: WHERE server_address = p_address;
453: END IF;
454:
455: IF (l_support_admin is NULL) THEN
456: UPDATE fnd_nodes
457: SET SUPPORT_ADMIN = 'N'
458: WHERE server_address = p_address;
459: END IF;
460:

Line 462: UPDATE fnd_nodes

458: WHERE server_address = p_address;
459: END IF;
460:
461: IF (l_support_db is NULL) THEN
462: UPDATE fnd_nodes
463: SET SUPPORT_DB = 'N'
464: WHERE server_address = p_address;
465: END IF;
466:

Line 473: UPDATE fnd_nodes

469: */
470: IF (p_platform is NOT NULL) THEN
471: l_platform2 := get_platform_code(p_platform);
472: IF (l_platform <> l_platform2) THEN
473: UPDATE fnd_nodes
474: SET PLATFORM_CODE = l_platform2
475: WHERE server_address = p_address;
476: END IF;
477: END IF;

Line 521: Bug 3773424:AUTHENTICATION NODE HAS NO VALUES FOR FND_NODES.SUPPORT_*

517: EXCEPTION WHEN no_data_found THEN
518: /*
519: insert_server(p_value,'*','AUTHENTICATION','Authentication value');
520:
521: Bug 3773424:AUTHENTICATION NODE HAS NO VALUES FOR FND_NODES.SUPPORT_*
522: COLUMNS. A system alert is being logged stating that it "Could not
523: contact Service Manager FNDSM_AUTHENTICATION_*". It seems that the
524: ICM attempts to tnsping all remote Service Managers using the query:
525:

Line 527: FROM FND_NODES

523: contact Service Manager FNDSM_AUTHENTICATION_*". It seems that the
524: ICM attempts to tnsping all remote Service Managers using the query:
525:
526: SELECT NODE_NAME, STATUS, NODE_MODE
527: FROM FND_NODES
528: WHERE NOT (SUPPORT_CP = 'N' AND
529: SUPPORT_WEB = 'N' AND SUPPORT_FORMS = 'N' AND
530: SUPPORT_ADMIN = 'N' AND SUPPORT_CP is NOT NULL AND
531: SUPPORT_WEB is NOT NULL AND

Line 591: ** Update the FND_NODES row associated with p_node_name with the specified

587:
588: /* update_desktop_server
589: **
590: ** This API is used for Desktop Nodes only.
591: ** Update the FND_NODES row associated with p_node_name with the specified
592: ** values for server_id, address, and description. If NULLs are passed, do not
593: ** update. update_server cannot be used here because it uses p_address as the
594: ** where condition.
595: */

Line 608: from fnd_nodes

604:
605: -- Check if the desktop node exists.
606: select count(*)
607: into kount
608: from fnd_nodes
609: where node_name = p_node_name
610: and SUPPORT_CP = 'N'
611: and SUPPORT_FORMS = 'N'
612: and SUPPORT_WEB = 'N'

Line 629: UPDATE fnd_nodes

625: IF (p_address is null) OR (p_address <> '*') THEN
626: -- If server_id is provided, update using the node_name as condition.
627: IF(p_server_id IS NOT NULL) THEN
628:
629: UPDATE fnd_nodes
630: SET server_id = p_server_id
631: WHERE node_name = UPPER(p_node_name)
632: and support_cp = 'N'
633: and support_forms = 'N'

Line 644: UPDATE fnd_nodes

640: -- If a server_address is given, update using the node_name as condition.
641: -- server_address cannot be equal to '*' for a desktop node. The
642: -- (p_address <> '*') condition is intentionally left redundant.
643: IF (p_address IS NOT NULL) and (p_address <> '*') THEN
644: UPDATE fnd_nodes
645: SET server_address = p_address
646: WHERE node_name = UPPER(p_node_name)
647: and support_cp = 'N'
648: and support_forms = 'N'

Line 658: UPDATE fnd_nodes

654:
655: -- If a description is given, update using the node_name as condition.
656: -- Default value is 'Desktop Node', per insert_desktop_server().
657: IF(p_description IS NOT NULL) THEN
658: UPDATE fnd_nodes
659: SET description = p_description
660: WHERE node_name = UPPER(p_node_name)
661: and support_cp = 'N'
662: and support_forms = 'N'

Line 686: UPDATE fnd_nodes

682: PROCEDURE delete_desktop_server (p_node_name IN VARCHAR2)
683: IS
684: BEGIN
685:
686: UPDATE fnd_nodes
687: SET server_id = NULL
688: WHERE node_name = UPPER(p_node_name)
689: and support_cp = 'N'
690: and support_forms = 'N'