DBA Data[Home] [Help]

APPS.FND_OID_DIAG dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 94: report := jtf_diagnostic_adaptutil.constructReport(statusStr,

90: statusStr := 'FAILURE';
91: errStr := constructErr('Oracle Application Common Name not found in Workflow Preferences');
92: fixInfo := constructHelp('Oracle Application Common Name must be registered in Workflow Preferences');
93: isFatal := 'FALSE';
94: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
95: errStr, fixInfo, isFatal);
96: reportClob := jtf_diagnostic_adaptutil.getReportClob;
97: when others then
98: statusStr := 'FAILURE';

Line 96: reportClob := jtf_diagnostic_adaptutil.getReportClob;

92: fixInfo := constructHelp('Oracle Application Common Name must be registered in Workflow Preferences');
93: isFatal := 'FALSE';
94: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
95: errStr, fixInfo, isFatal);
96: reportClob := jtf_diagnostic_adaptutil.getReportClob;
97: when others then
98: statusStr := 'FAILURE';
99: errStr := constructErr(sqlerrm || ' occured in ' || currentMethod);
100: fixInfo := constructHelp('Contact System Adminstrator');

Line 102: report := jtf_diagnostic_adaptutil.constructReport(statusStr,

98: statusStr := 'FAILURE';
99: errStr := constructErr(sqlerrm || ' occured in ' || currentMethod);
100: fixInfo := constructHelp('Contact System Adminstrator');
101: isFatal := 'FALSE';
102: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
103: errStr, fixInfo, isFatal);
104: reportClob := jtf_diagnostic_adaptutil.getReportClob;
105: end init;
106: --

Line 104: reportClob := jtf_diagnostic_adaptutil.getReportClob;

100: fixInfo := constructHelp('Contact System Adminstrator');
101: isFatal := 'FALSE';
102: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
103: errStr, fixInfo, isFatal);
104: reportClob := jtf_diagnostic_adaptutil.getReportClob;
105: end init;
106: --
107: -------------------------------------------------------------------------------
108: procedure getDefaultTestParams(defaultInputValues out nocopy jtf_diag_inputtbl) is

Line 130: report := jtf_diagnostic_adaptutil.constructReport(statusStr,

126: statusStr := 'FAILURE';
127: errStr := constructErr(sqlerrm || ' occured in ' || currentMethod);
128: fixInfo := constructHelp('Contact System Adminstrator');
129: isFatal := 'FALSE';
130: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
131: errStr, fixInfo, isFatal);
132: reportClob := jtf_diagnostic_adaptutil.getReportClob;
133:
134: end cleanup;

Line 132: reportClob := jtf_diagnostic_adaptutil.getReportClob;

128: fixInfo := constructHelp('Contact System Adminstrator');
129: isFatal := 'FALSE';
130: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
131: errStr, fixInfo, isFatal);
132: reportClob := jtf_diagnostic_adaptutil.getReportClob;
133:
134: end cleanup;
135: --
136: -------------------------------------------------------------------------------

Line 161: return jtf_diagnostic_adaptutil.BOTH_MODE;

157: -------------------------------------------------------------------------------
158: function getTestMode return integer is
159: begin
160: currentMethod := 'getTestMode';
161: return jtf_diagnostic_adaptutil.BOTH_MODE;
162: end getTestMode;
163: --
164: -------------------------------------------------------------------------------
165: procedure dbms_ldap_test is

Line 353: jtf_diagnostic_adaptutil.setUpVars;

349: reportClob out nocopy clob) is
350:
351: begin
352: currentMethod := 'runtest';
353: jtf_diagnostic_adaptutil.setUpVars;
354: jtf_diagnostic_adaptutil.addStringToReport('@html');
355: jtf_diagnostic_coreapi.insert_style_sheet;
356: --oidAdmin := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);
357: --oidPwd := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);

Line 354: jtf_diagnostic_adaptutil.addStringToReport('@html');

350:
351: begin
352: currentMethod := 'runtest';
353: jtf_diagnostic_adaptutil.setUpVars;
354: jtf_diagnostic_adaptutil.addStringToReport('@html');
355: jtf_diagnostic_coreapi.insert_style_sheet;
356: --oidAdmin := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);
357: --oidPwd := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);
358:

Line 356: --oidAdmin := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);

352: currentMethod := 'runtest';
353: jtf_diagnostic_adaptutil.setUpVars;
354: jtf_diagnostic_adaptutil.addStringToReport('@html');
355: jtf_diagnostic_coreapi.insert_style_sheet;
356: --oidAdmin := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);
357: --oidPwd := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);
358:
359: profile_test;
360: if (not is_oid_enabled) then

Line 357: --oidPwd := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);

353: jtf_diagnostic_adaptutil.setUpVars;
354: jtf_diagnostic_adaptutil.addStringToReport('@html');
355: jtf_diagnostic_coreapi.insert_style_sheet;
356: --oidAdmin := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);
357: --oidPwd := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);
358:
359: profile_test;
360: if (not is_oid_enabled) then
361: jtf_diagnostic_adaptutil.addStringToReport('No additional test executed');

Line 361: jtf_diagnostic_adaptutil.addStringToReport('No additional test executed');

357: --oidPwd := jtf_diagnostic_adaptutil.getInputValue('OIDPWD', inputs);
358:
359: profile_test;
360: if (not is_oid_enabled) then
361: jtf_diagnostic_adaptutil.addStringToReport('No additional test executed');
362:
363: else
364: dbms_ldap_test;
365: if (is_dbms_ldap_available) then

Line 413: jtf_diagnostic_adaptutil.addStringToReport('Cannot connect to OiD, test terminated');

409: linkTest;
410:
411: usersTest;
412: else
413: jtf_diagnostic_adaptutil.addStringToReport('Cannot connect to OiD, test terminated');
414: end if;
415: else
416: jtf_diagnostic_adaptutil.addStringToReport('Cannot continue testing, DBMS_LDAP is not available');
417: end if;

Line 416: jtf_diagnostic_adaptutil.addStringToReport('Cannot continue testing, DBMS_LDAP is not available');

412: else
413: jtf_diagnostic_adaptutil.addStringToReport('Cannot connect to OiD, test terminated');
414: end if;
415: else
416: jtf_diagnostic_adaptutil.addStringToReport('Cannot continue testing, DBMS_LDAP is not available');
417: end if;
418: end if;
419:
420: if (tableOpen) then

Line 424: jtf_diagnostic_adaptutil.addStringToReport('Test completed successfully
');

420: if (tableOpen) then
421: endTable;
422: end if;
423: if (statusStr = 'SUCCESS') then
424: jtf_diagnostic_adaptutil.addStringToReport('Test completed successfully
');
425: elsif (statusStr = 'WARNING') then
426: jtf_diagnostic_adaptutil.addStringToReport('Test succeeded with warnings
');
427: else
428: jtf_diagnostic_adaptutil.addStringToReport('Test failed
');

Line 426: jtf_diagnostic_adaptutil.addStringToReport('Test succeeded with warnings
');

422: end if;
423: if (statusStr = 'SUCCESS') then
424: jtf_diagnostic_adaptutil.addStringToReport('Test completed successfully
');
425: elsif (statusStr = 'WARNING') then
426: jtf_diagnostic_adaptutil.addStringToReport('Test succeeded with warnings
');
427: else
428: jtf_diagnostic_adaptutil.addStringToReport('Test failed
');
429: end if;
430:

Line 428: jtf_diagnostic_adaptutil.addStringToReport('Test failed
');

424: jtf_diagnostic_adaptutil.addStringToReport('Test completed successfully
');
425: elsif (statusStr = 'WARNING') then
426: jtf_diagnostic_adaptutil.addStringToReport('Test succeeded with warnings
');
427: else
428: jtf_diagnostic_adaptutil.addStringToReport('Test failed
');
429: end if;
430:
431: errStr := errStr || '';
432: fixInfo := fixInfo || '';

Line 433: report := jtf_diagnostic_adaptutil.constructReport(statusStr,

429: end if;
430:
431: errStr := errStr || '';
432: fixInfo := fixInfo || '';
433: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
434: errStr, fixInfo, isFatal);
435: reportClob := jtf_diagnostic_adaptutil.getReportClob;
436:
437: exception

Line 435: reportClob := jtf_diagnostic_adaptutil.getReportClob;

431: errStr := errStr || '';
432: fixInfo := fixInfo || '';
433: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
434: errStr, fixInfo, isFatal);
435: reportClob := jtf_diagnostic_adaptutil.getReportClob;
436:
437: exception
438: when others then
439: --jtf_diagnostic_coreapi.errorprint('Error: '||sqlerrm);

Line 444: jtf_diagnostic_adaptutil.addStringToReport('Test failed
');

440: --jtf_diagnostic_coreapi.ActionErrorPrint('Contact System Adminstrator');
441: if (tableOpen) then
442: endTable;
443: end if;
444: jtf_diagnostic_adaptutil.addStringToReport('Test failed
');
445: statusStr := 'FAILURE';
446: errStr := constructErr(sqlerrm || ' occured in ' || currentMethod);
447: fixInfo := constructHelp('Contact System Adminstrator');
448: errStr := errStr || '';

Line 451: report := jtf_diagnostic_adaptutil.constructReport(statusStr,

447: fixInfo := constructHelp('Contact System Adminstrator');
448: errStr := errStr || '';
449: fixInfo := fixInfo || '';
450: isFatal := 'FALSE';
451: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
452: errStr, fixInfo, isFatal);
453: reportClob := jtf_diagnostic_adaptutil.getReportClob;
454: end runtest;
455: --

Line 453: reportClob := jtf_diagnostic_adaptutil.getReportClob;

449: fixInfo := fixInfo || '';
450: isFatal := 'FALSE';
451: report := jtf_diagnostic_adaptutil.constructReport(statusStr,
452: errStr, fixInfo, isFatal);
453: reportClob := jtf_diagnostic_adaptutil.getReportClob;
454: end runtest;
455: --
456: -------------------------------------------------------------------------------
457: procedure eventsTest is

Line 532: jtf_diagnostic_adaptutil.addStringToReport(' Subscription Event Status');

528: currentMethod := 'subscriptionsTest';
529:
530: beginTable('Business Event Subscriptions', 3);
531: -- see fndoidsyncs.wfx
532: jtf_diagnostic_adaptutil.addStringToReport(' Subscription Event Status');
533: subs := SubList('fnd_oid_subscriptions.assign_def_resp',
534: 'fnd_oid_subscriptions.event_error',
535: 'fnd_oid_subscriptions.event_resend',
536: 'fnd_oid_subscriptions.hz_identity_add',

Line 552: jtf_diagnostic_adaptutil.addStringToReport(''|| subs(i)||'');

548:
549: i:= 1;
550: while (i 551: l_subscription := subs(i);
552: jtf_diagnostic_adaptutil.addStringToReport(''|| subs(i)||'');
553:
554: open c1(l_subscription);
555: loop
556:

Line 559: jtf_diagnostic_adaptutil.addStringToReport(' MISSING INCORRECT');

555: loop
556:
557: fetch c1 into l_status, l_event;
558: if (c1%ROWCOUNT = 0 ) then
559: jtf_diagnostic_adaptutil.addStringToReport(' MISSING INCORRECT');
560: statusStr := 'FAILURE';
561: errStr := constructErr(l_subscription || ' is not created');
562: fixInfo := constructHelp(l_subscription || ' should be created');
563: isFatal := 'FALSE';

Line 567: jtf_diagnostic_adaptutil.addStringToReport(''||l_event||''||l_status);

563: isFatal := 'FALSE';
564: end if;
565: exit when c1%NOTFOUND;
566:
567: jtf_diagnostic_adaptutil.addStringToReport(''||l_event||''||l_status);
568: end loop;
569: close c1;
570: i:=i+2;
571:

Line 1241: --jtf_diagnostic_adaptutil.addStringToReport(title || ': ' || '
');

1237:
1238: exception
1239: when no_data_found then
1240: insertRow(attrName);
1241: --jtf_diagnostic_adaptutil.addStringToReport(title || ': ' || '
');
1242:
1243: end printAttr;
1244: --
1245: -------------------------------------------------------------------------------

Line 1277: jtf_diagnostic_adaptutil.addStringToReport(html);

1273: if (tableOpen) then
1274: endTable;
1275: end if;
1276: html := '';
1277: jtf_diagnostic_adaptutil.addStringToReport(html);
1278: tableOpen := true;
1279: end beginTable;
1280: --
1281: -------------------------------------------------------------------------------

Line 1288: jtf_diagnostic_adaptutil.addStringToReport(html);

1284: html varchar2(4000);
1285:
1286: begin
1287: html := '

' || title || '


';
1288: jtf_diagnostic_adaptutil.addStringToReport(html);
1289: tableOpen := false;
1290: end endTable;
1291: --
1292: -------------------------------------------------------------------------------

Line 1299: jtf_diagnostic_adaptutil.addStringToReport(html);

1295: html varchar2(4000);
1296:
1297: begin
1298: html := '' || text || '
';
1299: jtf_diagnostic_adaptutil.addStringToReport(html);
1300: end insertRow;
1301: --
1302: -------------------------------------------------------------------------------
1303: procedure insertColumn(text in varchar2) is

Line 1309: jtf_diagnostic_adaptutil.addStringToReport(html);

1305: html varchar2(4000);
1306:
1307: begin
1308: html := '' || text || '
';
1309: jtf_diagnostic_adaptutil.addStringToReport(html);
1310: end insertColumn;
1311: --
1312: -------------------------------------------------------------------------------
1313: procedure beginRow is

Line 1319: jtf_diagnostic_adaptutil.addStringToReport(html);

1315: html varchar2(4000);
1316:
1317: begin
1318: html := '';
1319: jtf_diagnostic_adaptutil.addStringToReport(html);
1320: end beginRow;
1321: --
1322: -------------------------------------------------------------------------------
1323: procedure endRow is

Line 1329: jtf_diagnostic_adaptutil.addStringToReport(html);

1325: html varchar2(4000);
1326:
1327: begin
1328: html := '';
1329: jtf_diagnostic_adaptutil.addStringToReport(html);
1330: end endRow;
1331: --
1332: -------------------------------------------------------------------------------
1333: procedure getOrclApp(p_app in out nocopy varchar2) is