eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_DIAG_WOL_FLOW dependencies on JTF_DIAGNOSTIC_COREAPI

Line 21: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

17: where_clause VARCHAR2(4000) := NULL; -- where clause
18: BEGIN
19: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
20: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
21: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
22: row_limit := 1000;
23: -- accept input
24: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
25:

Line 86: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

82: ' and wfs.organization_id = mmt1.organization_id) '||
83: ' order by transaction_source_id, transaction_action_id';
84:
85:
86: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
87: 'Component transaction(s) in MMT erred during costing with Parent transaction either' ||
88: ' not costed or erred in MMT (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
89:
90: IF (dummy_num = row_limit) THEN

Line 91: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

87: 'Component transaction(s) in MMT erred during costing with Parent transaction either' ||
88: ' not costed or erred in MMT (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
89:
90: IF (dummy_num = row_limit) THEN
91: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
92: END IF;
93:
94: If ( dummy_num > 0) then
95:

Line 99: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

95:
96: reportStr := 'The rows returned above signify data inconsistency in component transaction(s).' ||
97: ' These are component transactions in MMT for Work Order-less / Flow for which the parent assembly' ||
98: ' transaction is either not costed or erred.';
99: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
100: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
101:
102: end if;
103:

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

');

96: reportStr := 'The rows returned above signify data inconsistency in component transaction(s).' ||
97: ' These are component transactions in MMT for Work Order-less / Flow for which the parent assembly' ||
98: ' transaction is either not costed or erred.';
99: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
100: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
101:
102: end if;
103:
104: statusStr := 'SUCCESS';

Line 160: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

156: ' ) '||
157: ' order by transaction_source_id, transaction_action_id';
158:
159:
160: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
161: 'Component transaction(s) in MMT erred during costing with missing Parent transaction in MMT (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
162:
163: IF (dummy_num = row_limit) THEN
164: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 164: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

160: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
161: 'Component transaction(s) in MMT erred during costing with missing Parent transaction in MMT (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
162:
163: IF (dummy_num = row_limit) THEN
164: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
165: END IF;
166:
167: If ( dummy_num > 0) then
168:

Line 170: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

166:
167: If ( dummy_num > 0) then
168:
169: reportStr := 'The rows returned above signify data inconsistency among component transaction(s). These are component transactions' || ' in MMT for Work Order-less / Flow transactions for which the parent assembly transaction is missing in MMT.';
170: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
171: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
172:
173: end if;
174:

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

');

167: If ( dummy_num > 0) then
168:
169: reportStr := 'The rows returned above signify data inconsistency among component transaction(s). These are component transactions' || ' in MMT for Work Order-less / Flow transactions for which the parent assembly transaction is missing in MMT.';
170: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
171: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
172:
173: end if;
174:
175: statusStr := 'SUCCESS';

Line 229: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

225: ' ) '||
226: 'order by transaction_source_id, transaction_action_id';
227:
228:
229: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
230: 'Component transaction(s) in MMT Uncosted/erred during costing with costed Parent transaction in MMT (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
231:
232: IF (dummy_num = row_limit) THEN
233: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 233: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

229: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
230: 'Component transaction(s) in MMT Uncosted/erred during costing with costed Parent transaction in MMT (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
231:
232: IF (dummy_num = row_limit) THEN
233: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
234: END IF;
235:
236: If ( dummy_num > 0) then
237:

Line 239: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

235:
236: If ( dummy_num > 0) then
237:
238: reportStr := 'The rows returned above signify data inconsistency among component transaction(s). These are component transactions' || ' in MMT for Work Order-less / Flow transactions for which the parent assembly transaction is costed.';
239: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
240: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
241:
242: end if;
243:

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

');

236: If ( dummy_num > 0) then
237:
238: reportStr := 'The rows returned above signify data inconsistency among component transaction(s). These are component transactions' || ' in MMT for Work Order-less / Flow transactions for which the parent assembly transaction is costed.';
239: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
240: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
241:
242: end if;
243:
244: statusStr := 'SUCCESS';

Line 295: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

291: ' ) '||
292: ' order by transaction_source_id, transaction_action_id';
293:
294:
295: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
296: 'Transaction(s) in MMT Uncosted/erred during costing with missing flow schedule (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
297:
298: IF (dummy_num = row_limit) THEN
299: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 299: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

295: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
296: 'Transaction(s) in MMT Uncosted/erred during costing with missing flow schedule (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
297:
298: IF (dummy_num = row_limit) THEN
299: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
300: END IF;
301:
302: If ( dummy_num > 0) then
303:

Line 306: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

302: If ( dummy_num > 0) then
303:
304: reportStr := 'The rows returned above signify data inconsistency among MMT transaction(s) for Work Order-less / Flow' ||
305: ' transactions. These are transactions in MMT for Work Order-less / Flow transactions for which the flow schedule is missing.';
306: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
307: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
308:
309: end if;
310:

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

');

303:
304: reportStr := 'The rows returned above signify data inconsistency among MMT transaction(s) for Work Order-less / Flow' ||
305: ' transactions. These are transactions in MMT for Work Order-less / Flow transactions for which the flow schedule is missing.';
306: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
307: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
308:
309: end if;
310:
311: statusStr := 'SUCCESS';

Line 365: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

361: ' and mmt1.transaction_source_id <> mmt.transaction_source_id '||
362: ' ) '||
363: ' order by transaction_source_id, transaction_action_id ';
364:
365: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
366: 'Component transaction(s) in MMT erred during costing due to backflush against an incorrect flow schedule with Parent transaction either not costed or erred in MMT (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
367:
368: IF (dummy_num = row_limit) THEN
369: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 369: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

365: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
366: 'Component transaction(s) in MMT erred during costing due to backflush against an incorrect flow schedule with Parent transaction either not costed or erred in MMT (error: CST_INVALID_WIP).',true,null,'Y',row_limit);
367:
368: IF (dummy_num = row_limit) THEN
369: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
370: END IF;
371:
372: If ( dummy_num > 0) then
373:

Line 377: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

373:
374: reportStr := 'The rows returned above signify data inconsistency among MMT component transaction(s) for'||
375: ' Work Order-less / Flow transactions. These are component transactions in MMT' ||
376: ' for Work Order-less / Flow transactions with incorrect transaction_source_id.';
377: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
378: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
379:
380: end if;
381:

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

');

374: reportStr := 'The rows returned above signify data inconsistency among MMT component transaction(s) for'||
375: ' Work Order-less / Flow transactions. These are component transactions in MMT' ||
376: ' for Work Order-less / Flow transactions with incorrect transaction_source_id.';
377: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
378: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
379:
380: end if;
381:
382: statusStr := 'SUCCESS';

Line 409: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

405: where_clause VARCHAR2(4000) := NULL; -- where clause
406: BEGIN
407: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
408: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
409: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
410: -- accept input
411: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
412:
413: If l_org_id is not null then

Line 440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

436: where_clause ||
437: 'order by wip_entity_id, transaction_id';
438:
439:
440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
441: 'Pending Resource transaction(s) due to UnCosted/erred MMT transaction.',true,null,'Y',row_limit);
442:
443: IF (dummy_num = row_limit) THEN
444: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 444: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

440: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
441: 'Pending Resource transaction(s) due to UnCosted/erred MMT transaction.',true,null,'Y',row_limit);
442:
443: IF (dummy_num = row_limit) THEN
444: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
445: END IF;
446:
447: If ( dummy_num > 0) then
448:

Line 450: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

446:
447: If ( dummy_num > 0) then
448:
449: reportStr := 'The rows returned above signify data inconsistency in resource transaction(s) for Work Order-less / Flow transactions. These are pending transactions in WCTI for uncosted / erred Work Order-less / Flow transactions in MMT.';
450: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
451: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');
452:
453: end if;
454:

Line 451: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');

447: If ( dummy_num > 0) then
448:
449: reportStr := 'The rows returned above signify data inconsistency in resource transaction(s) for Work Order-less / Flow transactions. These are pending transactions in WCTI for uncosted / erred Work Order-less / Flow transactions in MMT.';
450: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
451: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please open a service request against Oracle Work in Process for the data-fix and root-cause, and upload the output of this diagnostic test.

');
452:
453: end if;
454:
455: statusStr := 'SUCCESS';

Line 484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

480: ' and mmt.completion_transaction_id = wcti.completion_transaction_id '||
481: where_clause || ' )';
482:
483:
484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
485: 'Work Order-less / Flow Pending Resource transaction(s) with Costed parent MMT transaction.',true,null,'Y',row_limit);
486:
487: IF (dummy_num = row_limit) THEN
488: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 488: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

484: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
485: 'Work Order-less / Flow Pending Resource transaction(s) with Costed parent MMT transaction.',true,null,'Y',row_limit);
486:
487: IF (dummy_num = row_limit) THEN
488: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
489: END IF;
490:
491: If ( dummy_num > 0) then
492:

Line 494: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

490:
491: If ( dummy_num > 0) then
492:
493: reportStr := 'The rows returned above signify data inconsistency in resource transaction(s) for Work Order-less / Flow transactions. These are transactions in WCTI for which parent Work Order-less / Flow transactions is costed.';
494: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
495: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Records listed above are not eligible for Costing as Parent transaction is already costed.
' ||
496: ' In this event, variances must have been posted. You should thus post a manual journal entry to transfer the value back from variance account' ||
497: ' into WIP valuation acounts. Finally, delete the corresponding pending resource transaction(s) record.

');
498:

Line 495: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Records listed above are not eligible for Costing as Parent transaction is already costed.
' ||

491: If ( dummy_num > 0) then
492:
493: reportStr := 'The rows returned above signify data inconsistency in resource transaction(s) for Work Order-less / Flow transactions. These are transactions in WCTI for which parent Work Order-less / Flow transactions is costed.';
494: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
495: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Records listed above are not eligible for Costing as Parent transaction is already costed.
' ||
496: ' In this event, variances must have been posted. You should thus post a manual journal entry to transfer the value back from variance account' ||
497: ' into WIP valuation acounts. Finally, delete the corresponding pending resource transaction(s) record.

');
498:
499: end if;

Line 530: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

526: where_clause VARCHAR2(4000) := NULL; -- where clause
527: BEGIN
528: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
529: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
530: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
531: -- accept input
532: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
533:
534: If l_org_id is not null then

Line 541: if JTF_DIAGNOSTIC_COREAPI.Column_Exists('MTL_TRANSACTIONS_INTERFACE','COMPLETION_TRANSACTION_ID', 'INV') = 'Y' then

537: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
538: end if;
539:
540: /* Bug 5731956: Added if condition to check existence of column COMPLETION_TRANSACTION_ID*/
541: if JTF_DIAGNOSTIC_COREAPI.Column_Exists('MTL_TRANSACTIONS_INTERFACE','COMPLETION_TRANSACTION_ID', 'INV') = 'Y' then
542: sqltxt :=
543: 'SELECT transaction_source_id, '||
544: ' organization_id, '||
545: ' transaction_interface_id, '||

Line 569: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

565: ' AND mmt.completion_transaction_id = mti.completion_transaction_id '||
566: ' AND mmt.costed_flag IN (''N'',''E'') '||
567: ' AND mmt.transaction_action_id NOT IN (1, 27, 33, 34)) ';
568:
569: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
570: 'Component transaction(s) in transactions open interface whose associated assembly transaction '||
571: 'is costed or missing in material transactions table(MMT).',true,null,'Y',row_limit);
572:
573: IF (dummy_num = row_limit) THEN

Line 574: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

570: 'Component transaction(s) in transactions open interface whose associated assembly transaction '||
571: 'is costed or missing in material transactions table(MMT).',true,null,'Y',row_limit);
572:
573: IF (dummy_num = row_limit) THEN
574: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
575: END IF;
576:
577: If ( dummy_num > 0) then
578:

Line 581: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

577: If ( dummy_num > 0) then
578:
579: reportStr := 'The rows returned above signify data inconsistency in component transaction(s) for Work Order-less / Flow transactions.' ||
580: ' These are component transactions in MTI for which parent Work Order-less / Flow transactions is costed or missing.';
581: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
582: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
583:
584: end if;
585:

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

');

578:
579: reportStr := 'The rows returned above signify data inconsistency in component transaction(s) for Work Order-less / Flow transactions.' ||
580: ' These are component transactions in MTI for which parent Work Order-less / Flow transactions is costed or missing.';
581: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
582: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
583:
584: end if;
585:
586: statusStr := 'SUCCESS';

Line 620: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Component transaction(s) in transactions open interface whose associated assembly transaction is not costed.',true,null,'Y',row_limit);

616: ' AND mmt.costed_flag IN (''N'',''E'') '||
617: ' AND mmt.transaction_action_id NOT IN (1, 27, 33, 34)) ';
618:
619:
620: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Component transaction(s) in transactions open interface whose associated assembly transaction is not costed.',true,null,'Y',row_limit);
621:
622: IF (dummy_num = row_limit) THEN
623: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
624: END IF;

Line 623: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

619:
620: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Component transaction(s) in transactions open interface whose associated assembly transaction is not costed.',true,null,'Y',row_limit);
621:
622: IF (dummy_num = row_limit) THEN
623: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
624: END IF;
625:
626: If ( dummy_num > 0) then
627:

Line 630: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

626: If ( dummy_num > 0) then
627:
628: reportStr := 'The rows returned above signify data inconsistency in component transaction(s) for Work Order-less / Flow transactions.' ||
629: ' These are component transactions in MTI for which parent Work Order-less / Flow transactions is not costed.';
630: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
631: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
632:
633: end if;
634: else

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

');

627:
628: reportStr := 'The rows returned above signify data inconsistency in component transaction(s) for Work Order-less / Flow transactions.' ||
629: ' These are component transactions in MTI for which parent Work Order-less / Flow transactions is not costed.';
630: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
631: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
632:
633: end if;
634: else
635: reportStr := 'This instance is not able to run this test as it is not on the required patchset level.';

Line 636: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr);

632:
633: end if;
634: else
635: reportStr := 'This instance is not able to run this test as it is not on the required patchset level.';
636: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr);
637: JTF_DIAGNOSTIC_COREAPI.ActionWarningPrint('No action required.');
638: end if;
639:
640: statusStr := 'SUCCESS';

Line 637: JTF_DIAGNOSTIC_COREAPI.ActionWarningPrint('No action required.');

633: end if;
634: else
635: reportStr := 'This instance is not able to run this test as it is not on the required patchset level.';
636: JTF_DIAGNOSTIC_COREAPI.WarningPrint(reportStr);
637: JTF_DIAGNOSTIC_COREAPI.ActionWarningPrint('No action required.');
638: end if;
639:
640: statusStr := 'SUCCESS';
641: isFatal := 'FALSE';

Line 669: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

665: where_clause VARCHAR2(4000) := NULL; -- where clause
666: BEGIN
667: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
668: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
669: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
670: row_limit := 1000;
671: -- accept input
672: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
673:

Line 706: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,

702: ' locator_id, '||
703: ' completion_transaction_id';
704:
705:
706: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
707: 'Duplicate material transactions.',true,null,'Y',row_limit);
708:
709: IF (dummy_num = row_limit) THEN
710: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

Line 710: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');

706: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,
707: 'Duplicate material transactions.',true,null,'Y',row_limit);
708:
709: IF (dummy_num = row_limit) THEN
710: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output limited to the first '|| row_limit || ' rows to prevent an excessively large output file.
');
711: END IF;
712:
713: If ( dummy_num > 0) then
714:

Line 716: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);

712:
713: If ( dummy_num > 0) then
714:
715: reportStr := 'The rows returned above signify data inconsistency in Work Order-less / Flow transactions. These are duplicate material transactions.';
716: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
717: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
718:
719: end if;
720: statusStr := 'SUCCESS';

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

');

713: If ( dummy_num > 0) then
714:
715: reportStr := 'The rows returned above signify data inconsistency in Work Order-less / Flow transactions. These are duplicate material transactions.';
716: JTF_DIAGNOSTIC_COREAPI.ErrorPrint(reportStr);
717: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('Please refer to Metalink note ', 402202.1, 'to get the root-cause patch and steps to correct the data.

');
718:
719: end if;
720: statusStr := 'SUCCESS';
721: isFatal := 'FALSE';