DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_INTFDATA dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 36: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

32: l_oracle_schema VARCHAR2 (30);
33: l_table_exists NUMBER;
34:
35: BEGIN
36: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
37: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
38: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
39:
40: /* set limit of records to be fetched*/

Line 37: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

33: l_table_exists NUMBER;
34:
35: BEGIN
36: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
37: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
38: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
39:
40: /* set limit of records to be fetched*/
41: row_limit :=1000;

Line 44: l_type := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Type',inputs);

40: /* set limit of records to be fetched*/
41: row_limit :=1000;
42:
43: -- accept input
44: l_type := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Type',inputs);
45: /* Allowed values for input parameter type
46: 1 - Inv
47: 2 - Bom
48: 3 - Rtg

Line 61: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

57: isFatal := 'TRUE';
58: fixInfo := ' Please review the error message below and take corrective action. ';
59: errStr := ' Invalid value for input field Type. ';
60:
61: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
62: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
63:
64: Else /* valid value for input type */
65: If upper(l_type)='INV' Then

Line 62: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

58: fixInfo := ' Please review the error message below and take corrective action. ';
59: errStr := ' Invalid value for input field Type. ';
60:
61: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
62: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
63:
64: Else /* valid value for input type */
65: If upper(l_type)='INV' Then
66: /* Items Interface Details */

Line 2016: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

2012: /* End of mtl_interface_errors table.*/
2013:
2014: <>
2015: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');
2016: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
2017: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
2018: End If; /* l_type is valid */
2019:
2020: EXCEPTION

Line 2017: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

2013:
2014: <>
2015: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');
2016: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
2017: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
2018: End If; /* l_type is valid */
2019:
2020: EXCEPTION
2021: when others then

Line 2028: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

2024: statusStr := 'FAILURE';
2025: errStr := sqlerrm ||' occurred in script. ';
2026: fixInfo := 'Unexpected Exception in BOMDGINB.pls';
2027: isFatal := 'FALSE';
2028: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
2029: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
2030: END runTest;
2031:
2032: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 2029: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

2025: errStr := sqlerrm ||' occurred in script. ';
2026: fixInfo := 'Unexpected Exception in BOMDGINB.pls';
2027: isFatal := 'FALSE';
2028: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
2029: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
2030: END runTest;
2031:
2032: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
2033: BEGIN

Line 2063: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

2059: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
2060: tempDependencies JTF_DIAG_DEPENDTBL;
2061:
2062: BEGIN
2063: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
2064: END getDependencies;
2065:
2066: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
2067: BEGIN

Line 2075: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

2071:
2072: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
2073: tempOutput JTF_DIAG_OUTPUTTBL;
2074: BEGIN
2075: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
2076: outputValues := tempOutput;
2077: EXCEPTION
2078: when others then
2079: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 2079: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

2075: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
2076: outputValues := tempOutput;
2077: EXCEPTION
2078: when others then
2079: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
2080: END getOutputValues;
2081:
2082:
2083: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 2086: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

2082:
2083: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
2084: tempInput JTF_DIAG_INPUTTBL;
2085: BEGIN
2086: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
2087: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Type','LOV-oracle.apps.bom.diag.lov.InterfaceRecLov');-- Lov name modified to Type for bug 6412260
2088: defaultInputValues := tempInput;
2089: EXCEPTION
2090: when others then

Line 2087: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Type','LOV-oracle.apps.bom.diag.lov.InterfaceRecLov');-- Lov name modified to Type for bug 6412260

2083: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
2084: tempInput JTF_DIAG_INPUTTBL;
2085: BEGIN
2086: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
2087: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Type','LOV-oracle.apps.bom.diag.lov.InterfaceRecLov');-- Lov name modified to Type for bug 6412260
2088: defaultInputValues := tempInput;
2089: EXCEPTION
2090: when others then
2091: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 2091: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

2087: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Type','LOV-oracle.apps.bom.diag.lov.InterfaceRecLov');-- Lov name modified to Type for bug 6412260
2088: defaultInputValues := tempInput;
2089: EXCEPTION
2090: when others then
2091: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
2092: END getDefaultTestParams;
2093:
2094: Function getTestMode return INTEGER IS
2095: BEGIN

Line 2096: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

2092: END getDefaultTestParams;
2093:
2094: Function getTestMode return INTEGER IS
2095: BEGIN
2096: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
2097:
2098: END getTestMode;
2099:
2100: END BOM_DIAGUNITTEST_INTFDATA;