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_SO_MSO_MCH 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 38: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

34: BEGIN
35:
36: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
37: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
38: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
39: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
40:
41: /*
42: -- check whether user has 'Inventory' responsibilty to execute diagnostics script.

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

35:
36: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
37: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
38: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
39: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
40:
41: /*
42: -- check whether user has 'Inventory' responsibilty to execute diagnostics script.
43: IF NOT INV_DIAG_GRP.check_responsibility(p_responsibility_name => l_resp) THEN -- l_resp = 'Inventory'

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

40:
41: /*
42: -- check whether user has 'Inventory' responsibilty to execute diagnostics script.
43: IF NOT INV_DIAG_GRP.check_responsibility(p_responsibility_name => l_resp) THEN -- l_resp = 'Inventory'
44: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' You do not have the privilege to run this Diagnostics.');
45: statusStr := 'FAILURE';
46: errStr := 'This test requires Inventory Responsibility Role';
47: fixInfo := 'Please contact your sysadmin to get Inventory Responsibility';
48: isFatal := 'FALSE';

Line 60: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Organization or Sales Order ');

56: l_order_number := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrderNo',inputs);
57:
58: IF l_org_id IS NULL OR l_order_number IS NULL THEN
59: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization and Sales order information');
60: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Organization or Sales Order ');
61: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct organization and Sales Order Number');
62: statusStr := 'FAILURE';
63: errStr := 'Invalid Organization Sales Order Combination';
64: fixInfo := 'Please enter Organization and Sales Order information';

Line 61: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct organization and Sales Order Number');

57:
58: IF l_org_id IS NULL OR l_order_number IS NULL THEN
59: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization and Sales order information');
60: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Organization or Sales Order ');
61: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct organization and Sales Order Number');
62: statusStr := 'FAILURE';
63: errStr := 'Invalid Organization Sales Order Combination';
64: fixInfo := 'Please enter Organization and Sales Order information';
65: isFatal := 'FALSE';

Line 75: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Profile (OE_SROUCE_CODE) value');

71: FND_CLIENT_INFO.SET_ORG_CONTEXT('' || l_org_id || '');
72:
73: sqltxt := ' select FND_PROFILE.value(''OE_SOURCE_CODE'') "OE_SOURCE_CODE" from dual ';
74:
75: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Profile (OE_SROUCE_CODE) value');
76:
77: sqltxt := ' select segment1 "Segment 1",segment2 "Segment 2",segment3 "Segment 3",sales_order_id "Sales Order Id"' ||
78: ' from mtl_sales_orders ' ||
79: ' where segment1=' || '''' || l_order_number || '''';

Line 81: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Segments value for the sales order ');

77: sqltxt := ' select segment1 "Segment 1",segment2 "Segment 2",segment3 "Segment 3",sales_order_id "Sales Order Id"' ||
78: ' from mtl_sales_orders ' ||
79: ' where segment1=' || '''' || l_order_number || '''';
80:
81: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Segments value for the sales order ');
82:
83: sqltxt := ' SELECT order_number,' ||
84: ' NAME || ''('' || order_type_id || '')'' "Order Type (ID)", ' ||
85: ' FND_PROFILE.VALUE(''ONT_SOURCE_CODE'') "Order Source"' ||

Line 93: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Sales Order');

89: ' AND language = (select language_code from' ||
90: ' fnd_languages' ||
91: ' where installed_flag = ''B'') ';
92:
93: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Sales Order');
94:
95: reportStr := 'The test completed as expected';
96: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
97: statusStr := 'SUCCESS';

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

99: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
100:
101: EXCEPTION
102: when others then
103: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
104: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
105: statusStr := 'FAILURE';
106: errStr := sqlerrm ||' occurred in script INVDP01B.pls Exception handled';
107: fixInfo := 'Unexpected Exception in INVDP01B.pls';

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

100:
101: EXCEPTION
102: when others then
103: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
104: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
105: statusStr := 'FAILURE';
106: errStr := sqlerrm ||' occurred in script INVDP01B.pls Exception handled';
107: fixInfo := 'Unexpected Exception in INVDP01B.pls';
108: isFatal := 'FALSE';