DBA Data[Home] [Help]

APPS.INV_DIAG_OH_CG_MCH 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 34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

30: BEGIN
31:
32: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
33: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
35: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
36:
37:
38:

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

31:
32: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
33: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
34: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
35: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
36:
37:
38:
39: sqltxt := ' select ' ||

Line 62: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of MOQD cost group mismatch.');

58: ' and mil.project_id=mproj.project_id' ||
59: ' and mil.organization_id=mproj.organization_id ' ||
60: ' and mproj.costing_group_id <> moqd.cost_group_id ';
61:
62: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of MOQD cost group mismatch.');
63:
64: reportStr := 'The test completed as expected';
65: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
66: statusStr := 'SUCCESS';

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

68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
69:
70: EXCEPTION
71: when others then
72: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
73: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
74: statusStr := 'FAILURE';
75: errStr := sqlerrm ||' occurred in script Exception handled';
76: fixInfo := 'Unexpected Exception in INVDO07B.pls';

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

69:
70: EXCEPTION
71: when others then
72: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
73: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
74: statusStr := 'FAILURE';
75: errStr := sqlerrm ||' occurred in script Exception handled';
76: fixInfo := 'Unexpected Exception in INVDO07B.pls';
77: isFatal := 'FALSE';