APPS.INV_DIAG_PI_ONHAND dependencies on JTF_DIAGNOSTIC_COREAPI

Line 33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

29:
30: BEGIN
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
36: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
37: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);

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

74: ' INV_DIAG_GRP.CHECK_AVAIL(mpa.inventory_item_id,mpa.organization_id,mpa.revision, mpa.subinventory_name,mpa.locator_id) ' ||
75: ' order by mpa.inventory_item_id)' ||
76: ' where abs(adj_qty) > qty_avail ';
77:
78: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Details of Physical Inventory Tags without onhand');
79: reportStr := 'The test completed as expected';
80: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
81: statusStr := 'SUCCESS';
82: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

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

83: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
84:
85: EXCEPTION
86: when others then
87: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
88: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
89: statusStr := 'FAILURE';
90: errStr := sqlerrm ||' occurred in script Exception handled';
91: fixInfo := 'Unexpected Exception in INVDA01B.pls';

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

84:
85: EXCEPTION
86: when others then
87: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
88: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
89: statusStr := 'FAILURE';
90: errStr := sqlerrm ||' occurred in script Exception handled';
91: fixInfo := 'Unexpected Exception in INVDA01B.pls';
92: isFatal := 'FALSE';