APPS.INV_DIAG_WDD_STAGED 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: sqltxt := ' select' ||
49: ' mp.organization_code || '' ('' ||mr.organization_id|| '')'' "Organization Code (Id)"' ||
50: ' ,mif.item_number||'' (''||mif.inventory_item_id||'')'' "Item (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: sqltxt := ' select' ||
49: ' mp.organization_code || '' ('' ||mr.organization_id|| '')'' "Organization Code (Id)"' ||
50: ' ,mif.item_number||'' (''||mif.inventory_item_id||'')'' "Item (Id)"' ||
51: ' ,mr.reservation_id "Rsv ID"' ||

Line 89: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inv interfaced) serials not marked');

85: ' where wdd2.source_line_id=wdd1.source_line_id' ||
86: ' and wdd2.source_code=''OE''' ||
87: ' and wdd2.released_status in (''R'',''S''))) ';
88:
89: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inv interfaced) serials not marked');
90:
91: reportStr := 'The test completed as expected';
92: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
93: statusStr := 'SUCCESS';

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

95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
100: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
101: statusStr := 'FAILURE';
102: errStr := sqlerrm ||' occurred in script Exception handled';
103: fixInfo := 'Unexpected Exception in INVDP04B.pls';

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

96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
100: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
101: statusStr := 'FAILURE';
102: errStr := sqlerrm ||' occurred in script Exception handled';
103: fixInfo := 'Unexpected Exception in INVDP04B.pls';
104: isFatal := 'FALSE';