DBA Data[Home] [Help]

APPS.INV_DIAG_OH_STATUS_CONTROL 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 mtsv.status_code' ||

Line 51: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Statuses with Onhand control as No when any of the organization is onhand status enabled');

47: ' AND rownum < 2' ||
48: ' ) ';
49:
50:
51: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Statuses with Onhand control as No when any of the organization is onhand status enabled');
52:
53: reportStr := 'The test completed as expected';
54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
55: statusStr := 'SUCCESS';

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

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

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

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