DBA Data[Home] [Help]

APPS.WIP_WDJ_DIAG_CORRUPT_OSP dependencies on JTF_DIAGNOSTIC_COREAPI

Line 33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

29: BEGIN
30:
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35:
36: -- accept input
37: if (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null ) then

Line 46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
Parameter input is required.');

42: statusStr := 'SUCCESS';
43: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
44: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
45: else
46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
Parameter input is required.');
47: if l_org_id is null then
48: fixInfo := 'Please enter the Org id for which output is desired.';
49: end if ;
50: isFatal := 'FALSE';

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

59:
60:
61: EXCEPTION
62: when others then
63: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
64: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
65: statusStr := 'FAILURE';
66: errStr := sqlerrm ||' occurred in script Exception handled';
67: fixInfo := 'Unexpected Exception in WIPDJOBB.pls';

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

60:
61: EXCEPTION
62: when others then
63: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
64: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
65: statusStr := 'FAILURE';
66: errStr := sqlerrm ||' occurred in script Exception handled';
67: fixInfo := 'Unexpected Exception in WIPDJOBB.pls';
68: isFatal := 'FALSE';