DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_TSDATA dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 52: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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

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

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

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

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

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

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

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

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

Line 73: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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

Line 86: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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

Line 103: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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

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

Line 1304: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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

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

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

Line 1315: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

Line 1343: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

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

Line 1355: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

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

Line 1359: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

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

Line 1366: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

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

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

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

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

Line 1372: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

Line 1377: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

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