APPS.INV_DIAG_PHY_INV_DUMP dependencies on JTF_DIAGNOSTIC_COREAPI

Line 22: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

18: reportClob OUT NOCOPY CLOB) IS
19:
20: reportStr LONG;
21: counter NUMBER;
22: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
23: c_userid VARCHAR2(50);
24: statusStr VARCHAR2(50);
25: errStr VARCHAR2(4000);
26: fixInfo VARCHAR2(4000);

Line 40: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

36: BEGIN
37:
38: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
39: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
40: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
41: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
42:
43: row_limit := INV_DIAG_GRP.g_max_row;
44:

Line 41: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');

37:
38: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
39: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
40: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
41: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
42:
43: row_limit := INV_DIAG_GRP.g_max_row;
44:
45: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

Line 104: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Dump of Physical Inventory Adjustments');

100: sqltxt := sqltxt || ' AND ROWNUM < ' || row_limit ;
101: END IF;
102:
103: END IF;
104: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Dump of Physical Inventory Adjustments');
105:
106: ELSIF l_script = 'MPIT_DUMP' THEN
107: sqltxt := ' SELECT' ||
108: ' MPIT.TAG_ID,' ||

Line 176: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Physical Inventory tags');

172: END IF;
173:
174: END IF;
175:
176: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Physical Inventory tags');
177:
178: ELSIF l_script = 'MPI_DUMP' THEN
179: sqltxt := ' SELECT ' ||
180: ' MPI.PHYSICAL_INVENTORY_ID,' ||

Line 233: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Physical Inventory tags without onhand');

229: ELSE
230: sqltxt := sqltxt || ' AND ROWNUM < ' || row_limit ;
231: END IF;
232:
233: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Physical Inventory tags without onhand');
234:
235: ELSE
236: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with Script Name');
237: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');

Line 237: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');

233: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Physical Inventory tags without onhand');
234:
235: ELSE
236: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with Script Name');
237: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');
238: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose correct Script Name');
239: statusStr := 'FAILURE';
240: errStr := 'Invalid Script Name';
241: fixInfo := 'Please choose correct Script Name';

Line 238: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose correct Script Name');

234:
235: ELSE
236: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with Script Name');
237: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');
238: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose correct Script Name');
239: statusStr := 'FAILURE';
240: errStr := 'Invalid Script Name';
241: fixInfo := 'Please choose correct Script Name';
242: isFatal := 'FALSE';

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

252: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
253:
254: EXCEPTION
255: when others then
256: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
257: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
258: statusStr := 'FAILURE';
259: errStr := sqlerrm ||' occurred in script Exception handled';
260: fixInfo := 'Unexpected Exception in INVDA07B.pls';

Line 257: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');

253:
254: EXCEPTION
255: when others then
256: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
257: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
258: statusStr := 'FAILURE';
259: errStr := sqlerrm ||' occurred in script Exception handled';
260: fixInfo := 'Unexpected Exception in INVDA07B.pls';
261: isFatal := 'FALSE';