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 */
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*/
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.');
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.');
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:
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
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:
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
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;
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:
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
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);
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:
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
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
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;
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
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
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
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;
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
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;