APPS.INV_DIAG_RSV_WDD_STG_MCH 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' ||
50: ' mp.organization_code || '' ('' ||mr.organization_id|| '')'' "Organization Code (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' ||
50: ' mp.organization_code || '' ('' ||mr.organization_id|| '')'' "Organization Code (Id)"' ||
51: ' ,mif.item_number||'' (''||mif.inventory_item_id||'')'' "Item (Id)"' ||

Line 95: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Unstaged Reservations');

91: ' where mmtt.trx_source_line_id=mr.demand_source_line_id' ||
92: ' and mr.demand_source_type_id=mmtt.transaction_source_type_id' ||
93: ' and mmtt.reservation_id is not null) ';
94:
95: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Unstaged Reservations');
96:
97: reportStr := 'The test completed as expected';
98: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
99: statusStr := 'SUCCESS';

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

101: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
106: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
107: statusStr := 'FAILURE';
108: errStr := sqlerrm ||' occurred in script Exception handled';
109: fixInfo := 'Unexpected Exception in INVDP03B.pls';

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

102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
106: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
107: statusStr := 'FAILURE';
108: errStr := sqlerrm ||' occurred in script Exception handled';
109: fixInfo := 'Unexpected Exception in INVDP03B.pls';
110: isFatal := 'FALSE';