DBA Data[Home] [Help]

APPS.WIP_DIAG_DISCRETE_LOT dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 22: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

18: where_clause := ' and we.organization_id = ' || p_org_id || ' ';
19: where_clause1 := ' and wdj.organization_id = ' || p_org_id || ' ';
20: where_clause2 := ' and wrs.organization_id = ' || p_org_id || ' ';
21: reportStr := ' Organization Id = ' || p_org_id || '
';
22: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
23: end if ;
24:
25: sqltxt :=
26: 'select transaction_source_id wip_entity_id, ' ||

Line 151: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

147: /*
148: if apps_ver = '11.5.10' then
149:
150: reportStr := '
Action:' ;
151: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
152:
153: reportStr := '
For Release 11.5.10 :' ;
154: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
155:

Line 154: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

150: reportStr := '
Action:' ;
151: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
152:
153: reportStr := '
For Release 11.5.10 :' ;
154: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
155:
156: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('
Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
157:
158: --JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr) ;

Line 159: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

155:
156: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('
Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
157:
158: --JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr) ;
159: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
160:
161: elsif apps_ver = '11.5.9' then
162:
163: -- reportStr := '
For Release 11.5.9 :' ;

Line 164: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

160:
161: elsif apps_ver = '11.5.9' then
162:
163: -- reportStr := '
For Release 11.5.9 :' ;
164: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
165: reportStr := '
Root cause patch not available. If issue can be reproduced at will, please log a service request againt WIP with steps to reproduce' ;
166: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
167: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
168:

Line 166: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

162:
163: -- reportStr := '
For Release 11.5.9 :' ;
164: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
165: reportStr := '
Root cause patch not available. If issue can be reproduced at will, please log a service request againt WIP with steps to reproduce' ;
166: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
167: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
168:
169: reportStr := '
Execute procedure WIP_WDJ_DFIX_UNCOSTED_MAT.update_mmt_for_jobs(organization_id, wip_entity_id) ' ;
170: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

Line 171: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

167: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
168:
169: reportStr := '
Execute procedure WIP_WDJ_DFIX_UNCOSTED_MAT.update_mmt_for_jobs(organization_id, wip_entity_id) ' ;
170: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
171: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
172: end if ;
173: **/
174:
175: end if ;

Line 232: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

228: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to metalink note ', 402202.1, ' to get the root-cause patch and steps to correct the data.

') ;
229:
230: /*
231: reportStr := '
Action:' ;
232: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
233:
234: reportStr := reportStr || '
1.Execute procedure WIP_WDJ_DFIX_UNCOSTED_MAT.create_wpb(organization_id, wip_entity_id)';
235: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
236:

Line 235: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

231: reportStr := '
Action:' ;
232: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
233:
234: reportStr := reportStr || '
1.Execute procedure WIP_WDJ_DFIX_UNCOSTED_MAT.create_wpb(organization_id, wip_entity_id)';
235: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
236:
237: reportStr := reportStr || '
The values for the parameters can be obtained using the above output.' ;
238: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
239:

Line 238: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

234: reportStr := reportStr || '
1.Execute procedure WIP_WDJ_DFIX_UNCOSTED_MAT.create_wpb(organization_id, wip_entity_id)';
235: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
236:
237: reportStr := reportStr || '
The values for the parameters can be obtained using the above output.' ;
238: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
239:
240: reportStr := reportStr || '
2. Please log a service request with steps to reproduce if Client can reproduce issue at will.' ;
241: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
242: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

Line 241: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

237: reportStr := reportStr || '
The values for the parameters can be obtained using the above output.' ;
238: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
239:
240: reportStr := reportStr || '
2. Please log a service request with steps to reproduce if Client can reproduce issue at will.' ;
241: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
242: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
243: */
244:
245:

Line 311: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

307:
308: if p_org_id is not null then
309: where_clause := ' and organization_id = ' || p_org_id || ' ';
310: reportStr := ' Organization Id = ' || p_org_id || '
';
311: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
312: end if ;
313:
314: sqltxt :=
315: ' SELECT TRANSACTION_ID,' ||

Line 385: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

381:
382: if p_org_id is not null then
383: where_clause := ' and organization_id = ' || p_org_id || ' ';
384: reportStr := ' Organization Id = ' || p_org_id || '
';
385: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
386: end if ;
387:
388: sqltxt :=
389: 'SELECT organization_id, ' ||