APPS.INV_DIAG_RSV_HDR_ZERO dependencies on JTF_DIAGNOSTIC_COREAPI

Line 35: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

31: report OUT NOCOPY JTF_DIAG_REPORT,
32: reportClob OUT NOCOPY CLOB) IS
33: reportStr LONG;
34: counter NUMBER;
35: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
36: c_userid VARCHAR2(50);
37: statusStr VARCHAR2(50);
38: errStr VARCHAR2(4000);
39: fixInfo VARCHAR2(4000);

Line 46: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

42: sqltxt VARCHAR2 (2000);
43: BEGIN
44: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
45: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
46: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
47: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
48:
49: sqltxt := ' SELECT MR.RESERVATION_ID RSV_ID,' ||
50: ' MR.DEMAND_SOURCE_LINE_ID ORDER_LINE_ID,' ||

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

43: BEGIN
44: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
45: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
46: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
47: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
48:
49: sqltxt := ' SELECT MR.RESERVATION_ID RSV_ID,' ||
50: ' MR.DEMAND_SOURCE_LINE_ID ORDER_LINE_ID,' ||
51: ' MR.INVENTORY_ITEM_ID ITEM_ID,' ||

Line 59: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Reservation details with DEMAND_SOURCE_HEADER_ID as 0');

55: ' WHERE DEMAND_SOURCE_TYPE_ID IN (2,8)' ||
56: ' AND NVL(DEMAND_SOURCE_HEADER_ID, 0) = 0' ||
57: ' AND SUPPLY_SOURCE_TYPE_ID = 13 ';
58:
59: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Reservation details with DEMAND_SOURCE_HEADER_ID as 0');
60:
61: sqltxt := ' SELECT MD.DEMAND_ID DEMD_ID,' ||
62: ' MD.DEMAND_SOURCE_LINE ORDER_LINE_ID,' ||
63: ' MD.INVENTORY_ITEM_ID ITEM_ID,' ||

Line 71: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Demand details with DEMAND_SOURCE_HEADER_ID as 0');

67: ' WHERE DEMAND_SOURCE_TYPE IN (2,8)' ||
68: ' AND NVL(DEMAND_SOURCE_HEADER_ID, 0) = 0' ||
69: ' AND NVL(SUPPLY_SOURCE_TYPE, 13) = 13 ';
70:
71: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Demand details with DEMAND_SOURCE_HEADER_ID as 0');
72:
73: reportStr := 'The test completed as expected';
74: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
75: statusStr := 'SUCCESS';

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

77: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
78:
79: EXCEPTION
80: WHEN OTHERS THEN
81: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
82: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
83: statusStr := 'FAILURE';
84: errStr := sqlerrm ||' occurred in script Exception handled';
85: fixInfo := 'Unexpected Exception in INVDP02B.pls';

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

78:
79: EXCEPTION
80: WHEN OTHERS THEN
81: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
82: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
83: statusStr := 'FAILURE';
84: errStr := sqlerrm ||' occurred in script Exception handled';
85: fixInfo := 'Unexpected Exception in INVDP02B.pls';
86: isFatal := 'FALSE';