DBA Data[Home] [Help]

APPS.JTF_AUTH_TRIGGERTEST dependencies on JTF_DIAGNOSTIC_COREAPI

Line 74: JTF_DIAGNOSTIC_COREAPI.line_out('The following triggers do not exist : ');

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;

Line 75: 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;

Line 77: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_principal_maps_t4');

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');

Line 78: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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;

Line 81: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_domain_tI');

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');

Line 82: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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;

Line 85: JTF_DIAGNOSTIC_COREAPI.line_out('jtf_auth_role_perm_tI');

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');

Line 86: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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;

Line 89: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PERMISSIONS_B_T1');

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');

Line 90: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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;

Line 93: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_DOMAINS_B_T1');

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');

Line 94: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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;

Line 97: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPALS_B_T1');

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');

Line 98: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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;

Line 101: JTF_DIAGNOSTIC_COREAPI.line_out('JTF_AUTH_PRINCIPAL_MAPS_T3');

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';

Line 102: JTF_DIAGNOSTIC_COREAPI.BRPrint;

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';

Line 118: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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: