DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_TSDATA dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 51: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

47: WHERE inventory_item_id = cp_n_item_id
48: AND organization_id = nvl(cp_n_org_id,organization_id);
49:
50: BEGIN
51: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
52: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
53: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
54:
55: /*Initializing local vars */

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

48: AND organization_id = nvl(cp_n_org_id,organization_id);
49:
50: BEGIN
51: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
52: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
53: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
54:
55: /*Initializing local vars */
56: row_limit :=1000; /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/

Line 60: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

56: row_limit :=1000; /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/
57: ln_rows_proc :=0;
58:
59: -- accept input
60: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
61: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
62:
63: If l_item_id is NULL then
64: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');

Line 61: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);

57: ln_rows_proc :=0;
58:
59: -- accept input
60: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
61: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
62:
63: If l_item_id is NULL then
64: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');
65: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Item Id.');

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

67: isFatal := 'TRUE';
68: fixInfo := ' Please review the error message below and take corrective action. ';
69: errStr := ' Invalid value for input field ItemId. It is a mandatory input.';
70:
71: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
72: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
73: Return;
74: End If;
75:

Line 72: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

68: fixInfo := ' Please review the error message below and take corrective action. ';
69: errStr := ' Invalid value for input field ItemId. It is a mandatory input.';
70:
71: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
72: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
73: Return;
74: End If;
75:
76: If l_org_id is NULL then

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

80: isFatal := 'TRUE';
81: fixInfo := ' Please review the error message below and take corrective action. ';
82: errStr := ' Invalid value for input field Organization Id. It is a mandatory input.';
83:
84: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
85: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
86: Return;
87: End If;
88:

Line 85: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

81: fixInfo := ' Please review the error message below and take corrective action. ';
82: errStr := ' Invalid value for input field Organization Id. It is a mandatory input.';
83:
84: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
85: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
86: Return;
87: End If;
88:
89: If (l_item_id is NOT NULL) AND (l_org_id is NOT NULL) Then

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

97: statusStr := 'FAILURE';
98: errStr := 'Invalid Item and Organization Combination';
99: fixInfo := ' Please review the error message below and take corrective action. ';
100: isFatal := 'TRUE';
101: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
102: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
103: RETURN;
104: END IF;
105: End If;

Line 102: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

98: errStr := 'Invalid Item and Organization Combination';
99: fixInfo := ' Please review the error message below and take corrective action. ';
100: isFatal := 'TRUE';
101: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
102: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
103: RETURN;
104: END IF;
105: End If;
106:

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

1298: /* End of Scripts to check for trailing spaces in Rtg Tables */
1299:
1300: <>
1301: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');
1302: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1303: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1304:
1305: EXCEPTION
1306: when others then

Line 1303: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

1299:
1300: <>
1301: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');
1302: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1303: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1304:
1305: EXCEPTION
1306: when others then
1307: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

1309: statusStr := 'FAILURE';
1310: errStr := sqlerrm ||' occurred in script. ';
1311: fixInfo := 'Unexpected Exception in BOMDGTSB.pls';
1312: isFatal := 'FALSE';
1313: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1314: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1315:
1316: END runTest;
1317:

Line 1314: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

1310: errStr := sqlerrm ||' occurred in script. ';
1311: fixInfo := 'Unexpected Exception in BOMDGTSB.pls';
1312: isFatal := 'FALSE';
1313: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1314: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1315:
1316: END runTest;
1317:
1318: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 1342: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

1338: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
1339: tempDependencies JTF_DIAG_DEPENDTBL;
1340:
1341: BEGIN
1342: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
1343: END getDependencies;
1344:
1345: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
1346: BEGIN

Line 1354: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

1350:
1351: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
1352: tempOutput JTF_DIAG_OUTPUTTBL;
1353: BEGIN
1354: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
1355: outputValues := tempOutput;
1356: EXCEPTION
1357: when others then
1358: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 1358: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

1354: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
1355: outputValues := tempOutput;
1356: EXCEPTION
1357: when others then
1358: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
1359: END getOutputValues;
1360:
1361:
1362: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 1365: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

1361:
1362: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
1363: tempInput JTF_DIAG_INPUTTBL;
1364: BEGIN
1365: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
1366: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
1367: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.bom.diag.lov.ItemLov');-- Lov name modified to ItemId for bug 6412260
1368: defaultInputValues := tempInput;
1369: EXCEPTION

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

1362: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
1363: tempInput JTF_DIAG_INPUTTBL;
1364: BEGIN
1365: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
1366: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
1367: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.bom.diag.lov.ItemLov');-- Lov name modified to ItemId for bug 6412260
1368: defaultInputValues := tempInput;
1369: EXCEPTION
1370: when others then

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

1363: tempInput JTF_DIAG_INPUTTBL;
1364: BEGIN
1365: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
1366: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
1367: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.bom.diag.lov.ItemLov');-- Lov name modified to ItemId for bug 6412260
1368: defaultInputValues := tempInput;
1369: EXCEPTION
1370: when others then
1371: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 1371: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

1367: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.bom.diag.lov.ItemLov');-- Lov name modified to ItemId for bug 6412260
1368: defaultInputValues := tempInput;
1369: EXCEPTION
1370: when others then
1371: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
1372: END getDefaultTestParams;
1373:
1374: Function getTestMode return INTEGER IS
1375: BEGIN

Line 1376: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

1372: END getDefaultTestParams;
1373:
1374: Function getTestMode return INTEGER IS
1375: BEGIN
1376: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
1377:
1378: END getTestMode;
1379:
1380: END BOM_DIAGUNITTEST_TSDATA;