44: fixInfo VARCHAR2(4000);
45: isFatal VARCHAR2(50); -- TRUE or FALSE
46: responsibilityExists VARCHAR2(1) ;
47: BEGIN
48: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars(reportClob);
49: begin
50: select 'Y'
51: into responsibilityExists
52: from fnd_responsibility
58: responsibilityExists := 'N' ;
59: end ;
60: IF (responsibilityExists = 'Y') THEN
61: reportStr := 'Oracle Mobile Field Service responsibility exists.' ;
62: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
63: statusStr := 'SUCCESS';
64: ELSE
65: statusStr := 'FAILURE';
66: errStr := 'Oracle Mobile Field Service responsibility does not exist. ';
66: errStr := 'Oracle Mobile Field Service responsibility does not exist. ';
67: fixInfo := 'Apply latest patch then contact support (if needed).' ;
68: isFatal := 'FALSE';
69: END IF;
70: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
71: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob ;
72: END runTest;
73:
74: ------------------------------------------------------------
67: fixInfo := 'Apply latest patch then contact support (if needed).' ;
68: isFatal := 'FALSE';
69: END IF;
70: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
71: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob ;
72: END runTest;
73:
74: ------------------------------------------------------------
75: -- procedure to report name back to framework