DBA Data[Home] [Help]

APPS.INV_DIAG_OH_COMINGLING dependencies on JTF_DIAGNOSTIC_COREAPI

Line 32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

28:
29: BEGIN
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
35:
36: sqltxt := ' SELECT mp.organization_code' ||

Line 105: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand Records for which commingling of the status exists');

101: sqltxt := sqltxt ||
102: ' ORDER BY x.organization_id, x.inventory_item_id,'||
103: ' x.subinventory_code, x.locator_id, x.lot_number';
104:
105: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand Records for which commingling of the status exists');
106:
107: reportStr := 'The test completed as expected';
108: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
109: statusStr := 'SUCCESS';

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

111: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
112:
113: EXCEPTION
114: when others then
115: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
116: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
117: statusStr := 'FAILURE';
118: errStr := sqlerrm ||' occurred in script Exception handled';
119: fixInfo := 'Unexpected Exception in INVDOH4B.pls';

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

112:
113: EXCEPTION
114: when others then
115: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
116: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
117: statusStr := 'FAILURE';
118: errStr := sqlerrm ||' occurred in script Exception handled';
119: fixInfo := 'Unexpected Exception in INVDOH4B.pls';
120: isFatal := 'FALSE';