APPS.INV_DIAG_OH_REV_ITMNOREV 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 35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

31: BEGIN
32:
33: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
37:
38: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
39:

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

32:
33: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
37:
38: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
39:
40:

Line 62: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand with Revision for item not revision controlled');

58: ' mp.organization_code || '' ('' || moqd.organization_id || '')'',' ||
59: ' mif.item_number|| '' (''||moqd.inventory_item_id||'')'',' ||
60: ' moqd.inventory_item_id, moqd.subinventory_code, moqd.locator_id, moqd.lot_number, moqd.revision' ;
61:
62: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand with Revision for item not revision controlled');
63:
64: ELSE
65:
66: sqltxt := ' select ' ||

Line 85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,' Onhand with Revision for item not revision controlled.');

81: ' mp.organization_code || '' ('' || t.organization_id || '')'',' ||
82: ' mif.item_number|| '' (''||t.inventory_item_id||'')'',' ||
83: ' t.inventory_item_id, t.subinventory_code, t.locator_id, t.lot_number, t.revision' ;
84:
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,' Onhand with Revision for item not revision controlled.');
86: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Please execute with organization identifier to identify the revision mismatch for an organization.');
87: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,' Alternatively user can execute the mismatch script mentioned in Note 279205.1 and then this script without organization identifier to identify revision mismatches across organization.');
88:
89: END IF;

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 INVDO03B.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 INVDO03B.pls';
104: isFatal := 'FALSE';