eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_DIAG_SER_NOT_MRK 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 50: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

46:
47: BEGIN
48: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
50: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
51: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
52:
53: /*
54: -- check whether user has 'Inventory' responsibilty to execute diagnostics script.

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

47: BEGIN
48: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
50: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
51: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
52:
53: /*
54: -- check whether user has 'Inventory' responsibilty to execute diagnostics script.
55: IF NOT INV_DIAG_GRP.check_responsibility(p_responsibility_name => l_resp) THEN -- l_resp = 'Inventory'

Line 56: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' You do not have the privilege to run this Diagnostics.');

52:
53: /*
54: -- check whether user has 'Inventory' responsibilty to execute diagnostics script.
55: IF NOT INV_DIAG_GRP.check_responsibility(p_responsibility_name => l_resp) THEN -- l_resp = 'Inventory'
56: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' You do not have the privilege to run this Diagnostics.');
57: statusStr := 'FAILURE';
58: errStr := 'This test requires Inventory Responsibility Role';
59: fixInfo := 'Please contact your sysadmin to get Inventory Responsibility';
60: isFatal := 'FALSE';

Line 98: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of staged serial and not marked, serial in delivery details');

94: IF l_item_id iS NOT NULL THEN
95: sqltxt := sqltxt || ' and msi.inventory_item_id = ' || l_item_id ;
96: END IF;
97:
98: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of staged serial and not marked, serial in delivery details');
99:
100: sqltxt := ' SELECT count(*) ' ||
101: ' FROM' ||
102: ' mtl_serial_numbers msn,' ||

Line 127: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of staged serial and not marked, serial in pending serials');

123: IF l_item_id iS NOT NULL THEN
124: sqltxt := sqltxt || ' and msi.inventory_item_id = ' || l_item_id ;
125: END IF;
126:
127: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of staged serial and not marked, serial in pending serials');
128:
129: sqltxt := ' SELECT count(*) ' ||
130: ' FROM' ||
131: ' mtl_serial_numbers msn ,' ||

Line 157: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of staged serial and not marked, serial in deliveried serials');

153: IF l_item_id iS NOT NULL THEN
154: sqltxt := sqltxt || ' and msi.inventory_item_id = ' || l_item_id ;
155: END IF;
156:
157: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of staged serial and not marked, serial in deliveried serials');
158:
159: sqltxt := 'select mp.organization_code || '' ('' || msn.current_organization_id ||'')'' "Organization|Code (Id)" ,' ||
160: ' msi.item_number || '' ('' || msn.inventory_item_id || '')'' "Item (Id)" ,' ||
161: ' msn.serial_number "Serial Number",' ||

Line 192: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inventory interfaced) serials, serials in deliver details');

188: IF l_item_id iS NOT NULL THEN
189: sqltxt := sqltxt || ' and msi.inventory_item_id = ' || l_item_id ;
190: END IF;
191:
192: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inventory interfaced) serials, serials in deliver details');
193:
194: sqltxt := ' select mp.organization_code || ''('' || msn.current_organization_id || '')'' "Organization|Code (Id)" ,' ||
195: ' msi.item_number || ''('' || msn.inventory_item_id || '')'' "Item (Id)" ,' ||
196: ' msn.serial_number "Serial Number",' ||

Line 228: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inventory interfaced) serials, serial in pending serials');

224: IF l_item_id iS NOT NULL THEN
225: sqltxt := sqltxt || ' and msi.inventory_item_id = ' || l_item_id ;
226: END IF;
227:
228: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inventory interfaced) serials, serial in pending serials');
229:
230: sqltxt := 'select mp.organization_code || '' ('' || msn.current_organization_id ||'')'' "Organization|Code (Id)" ,' ||
231: ' msi.item_number || '' ('' || msn.inventory_item_id || '')'' "Item (Id)" ,' ||
232: ' msn.serial_number "Serial Number",' ||

Line 264: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inventory interfaced) serials, serials in delivered serials');

260: IF l_item_id iS NOT NULL THEN
261: sqltxt := sqltxt || ' and msi.inventory_item_id = ' || l_item_id ;
262: END IF;
263:
264: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of staged / shipped (and not inventory interfaced) serials, serials in delivered serials');
265:
266: reportStr := 'The test completed as expected';
267: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
268: statusStr := 'SUCCESS';

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

270: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
271:
272: EXCEPTION
273: WHEN OTHERS THEN
274: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
275: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
276: statusStr := 'FAILURE';
277: errStr := sqlerrm ||' occurred in script Exception handled';
278: fixInfo := 'Unexpected Exception in INVDP05B.pls';

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

271:
272: EXCEPTION
273: WHEN OTHERS THEN
274: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
275: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
276: statusStr := 'FAILURE';
277: errStr := sqlerrm ||' occurred in script Exception handled';
278: fixInfo := 'Unexpected Exception in INVDP05B.pls';
279: isFatal := 'FALSE';