70: reportStr := 'The triggers exist. Test is successful';
71: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportStr);
72: statusStr := 'SUCCESS';
73: ELSE
74: JTF_DIAGNOSTIC_COREAPI.line_out('The following triggers do not exist : ');
75: JTF_DIAGNOSTIC_COREAPI.BRPrint;
76: IF (v_count1 <> 1) THEN
77: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_principal_maps_t4');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
71: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportStr);
72: statusStr := 'SUCCESS';
73: ELSE
74: JTF_DIAGNOSTIC_COREAPI.line_out('The following triggers do not exist : ');
75: JTF_DIAGNOSTIC_COREAPI.BRPrint;
76: IF (v_count1 <> 1) THEN
77: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_principal_maps_t4');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
79: END IF;
73: ELSE
74: JTF_DIAGNOSTIC_COREAPI.line_out('The following triggers do not exist : ');
75: JTF_DIAGNOSTIC_COREAPI.BRPrint;
76: IF (v_count1 <> 1) THEN
77: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_principal_maps_t4');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
79: END IF;
80: IF (v_count2 <> 1) THEN
81: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_domain_tI');
74: JTF_DIAGNOSTIC_COREAPI.line_out('The following triggers do not exist : ');
75: JTF_DIAGNOSTIC_COREAPI.BRPrint;
76: IF (v_count1 <> 1) THEN
77: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_principal_maps_t4');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
79: END IF;
80: IF (v_count2 <> 1) THEN
81: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_domain_tI');
82: JTF_DIAGNOSTIC_COREAPI.BRPrint;
77: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_principal_maps_t4');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
79: END IF;
80: IF (v_count2 <> 1) THEN
81: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_domain_tI');
82: JTF_DIAGNOSTIC_COREAPI.BRPrint;
83: END IF;
84: IF (v_count3 <> 1) THEN
85: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_role_perm_tI');
78: JTF_DIAGNOSTIC_COREAPI.BRPrint;
79: END IF;
80: IF (v_count2 <> 1) THEN
81: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_domain_tI');
82: JTF_DIAGNOSTIC_COREAPI.BRPrint;
83: END IF;
84: IF (v_count3 <> 1) THEN
85: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_role_perm_tI');
86: JTF_DIAGNOSTIC_COREAPI.BRPrint;
81: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_domain_tI');
82: JTF_DIAGNOSTIC_COREAPI.BRPrint;
83: END IF;
84: IF (v_count3 <> 1) THEN
85: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_role_perm_tI');
86: JTF_DIAGNOSTIC_COREAPI.BRPrint;
87: END IF;
88: IF (v_count4 <> 1) THEN
89: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PERMISSIONS_B_T1');
82: JTF_DIAGNOSTIC_COREAPI.BRPrint;
83: END IF;
84: IF (v_count3 <> 1) THEN
85: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_role_perm_tI');
86: JTF_DIAGNOSTIC_COREAPI.BRPrint;
87: END IF;
88: IF (v_count4 <> 1) THEN
89: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PERMISSIONS_B_T1');
90: JTF_DIAGNOSTIC_COREAPI.BRPrint;
85: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_role_perm_tI');
86: JTF_DIAGNOSTIC_COREAPI.BRPrint;
87: END IF;
88: IF (v_count4 <> 1) THEN
89: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PERMISSIONS_B_T1');
90: JTF_DIAGNOSTIC_COREAPI.BRPrint;
91: END IF;
92: IF (v_count5 <> 1) THEN
93: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_DOMAINS_B_T1');
86: JTF_DIAGNOSTIC_COREAPI.BRPrint;
87: END IF;
88: IF (v_count4 <> 1) THEN
89: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PERMISSIONS_B_T1');
90: JTF_DIAGNOSTIC_COREAPI.BRPrint;
91: END IF;
92: IF (v_count5 <> 1) THEN
93: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_DOMAINS_B_T1');
94: JTF_DIAGNOSTIC_COREAPI.BRPrint;
89: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PERMISSIONS_B_T1');
90: JTF_DIAGNOSTIC_COREAPI.BRPrint;
91: END IF;
92: IF (v_count5 <> 1) THEN
93: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_DOMAINS_B_T1');
94: JTF_DIAGNOSTIC_COREAPI.BRPrint;
95: END IF;
96: IF (v_count6 <> 1) THEN
97: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPALS_B_T1');
90: JTF_DIAGNOSTIC_COREAPI.BRPrint;
91: END IF;
92: IF (v_count5 <> 1) THEN
93: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_DOMAINS_B_T1');
94: JTF_DIAGNOSTIC_COREAPI.BRPrint;
95: END IF;
96: IF (v_count6 <> 1) THEN
97: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPALS_B_T1');
98: JTF_DIAGNOSTIC_COREAPI.BRPrint;
93: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_DOMAINS_B_T1');
94: JTF_DIAGNOSTIC_COREAPI.BRPrint;
95: END IF;
96: IF (v_count6 <> 1) THEN
97: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPALS_B_T1');
98: JTF_DIAGNOSTIC_COREAPI.BRPrint;
99: END IF;
100: IF (v_count7 <> 1) THEN
101: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPAL_MAPS_T3');
94: JTF_DIAGNOSTIC_COREAPI.BRPrint;
95: END IF;
96: IF (v_count6 <> 1) THEN
97: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPALS_B_T1');
98: JTF_DIAGNOSTIC_COREAPI.BRPrint;
99: END IF;
100: IF (v_count7 <> 1) THEN
101: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPAL_MAPS_T3');
102: JTF_DIAGNOSTIC_COREAPI.BRPrint;
97: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPALS_B_T1');
98: JTF_DIAGNOSTIC_COREAPI.BRPrint;
99: END IF;
100: IF (v_count7 <> 1) THEN
101: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPAL_MAPS_T3');
102: JTF_DIAGNOSTIC_COREAPI.BRPrint;
103: END IF;
104:
105: statusStr := 'FAILURE';
98: JTF_DIAGNOSTIC_COREAPI.BRPrint;
99: END IF;
100: IF (v_count7 <> 1) THEN
101: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPAL_MAPS_T3');
102: JTF_DIAGNOSTIC_COREAPI.BRPrint;
103: END IF;
104:
105: statusStr := 'FAILURE';
106: errStr := 'The triggers do not exist. Test is failure';
114: /* Retrieve and assign the OUT CLOB object with the current CLOB */
115: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
116:
117: EXCEPTION WHEN others THEN
118: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
119: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport('FAILURE','The test has failed','Try rerunning','FALSE');
120: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
121: END runTest;
122: