DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_IBRDATA dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 42: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

38: AND organization_id = nvl(cp_n_org_id,organization_id);
39:
40:
41: BEGIN
42: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
43: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
44: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
45:
46: /*Initializing local vars */

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

39:
40:
41: BEGIN
42: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
43: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
44: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
45:
46: /*Initializing local vars */
47: row_limit :=1000; /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/

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

47: row_limit :=1000; /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/
48: l_count := 0;
49:
50: -- accept input
51: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
52: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
53:
54: If l_item_id is NULL then
55: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');

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

48: l_count := 0;
49:
50: -- accept input
51: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
52: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
53:
54: If l_item_id is NULL then
55: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');
56: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Item Id.');

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

58: isFatal := 'TRUE';
59: fixInfo := ' Please review the error message below and take corrective action. ';
60: errStr := ' Invalid value for input field Item Id. It is a mandatory input.';
61:
62: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
63: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
64: Return;
65: Else /* l_item_id is not null */
66: OPEN c_item_valid (l_item_id, l_org_id);

Line 63: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

59: fixInfo := ' Please review the error message below and take corrective action. ';
60: errStr := ' Invalid value for input field Item Id. It is a mandatory input.';
61:
62: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
63: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
64: Return;
65: Else /* l_item_id is not null */
66: OPEN c_item_valid (l_item_id, l_org_id);
67: FETCH c_item_valid INTO l_count;

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

73: statusStr := 'FAILURE';
74: errStr := 'Invalid Item and Organization Combination';
75: fixInfo := ' Please review the error message below and take corrective action. ';
76: isFatal := 'TRUE';
77: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
78: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
79: RETURN;
80: END IF;
81: End If; /* l_item_id is null */

Line 78: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

74: errStr := 'Invalid Item and Organization Combination';
75: fixInfo := ' Please review the error message below and take corrective action. ';
76: isFatal := 'TRUE';
77: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
78: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
79: RETURN;
80: END IF;
81: End If; /* l_item_id is null */
82:

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

2528:
2529:
2530: <>
2531: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');
2532: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
2533: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
2534:
2535: EXCEPTION
2536: when others then

Line 2533: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

2529:
2530: <>
2531: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');
2532: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
2533: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
2534:
2535: EXCEPTION
2536: when others then
2537: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

2539: statusStr := 'FAILURE';
2540: errStr := sqlerrm ||' occurred in script. ';
2541: fixInfo := 'Unexpected Exception in BOMDGIBB.pls';
2542: isFatal := 'FALSE';
2543: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
2544: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
2545:
2546: END runTest;
2547:

Line 2544: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

2540: errStr := sqlerrm ||' occurred in script. ';
2541: fixInfo := 'Unexpected Exception in BOMDGIBB.pls';
2542: isFatal := 'FALSE';
2543: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
2544: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
2545:
2546: END runTest;
2547:
2548: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 2568: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

2564: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
2565: tempDependencies JTF_DIAG_DEPENDTBL;
2566:
2567: BEGIN
2568: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
2569: END getDependencies;
2570:
2571: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
2572: BEGIN

Line 2580: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

2576:
2577: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
2578: tempOutput JTF_DIAG_OUTPUTTBL;
2579: BEGIN
2580: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
2581: outputValues := tempOutput;
2582: EXCEPTION
2583: when others then
2584: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 2584: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

2580: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
2581: outputValues := tempOutput;
2582: EXCEPTION
2583: when others then
2584: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
2585: END getOutputValues;
2586:
2587:
2588: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 2591: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

2587:
2588: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
2589: tempInput JTF_DIAG_INPUTTBL;
2590: BEGIN
2591: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
2592: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
2593: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.bom.diag.lov.ItemLov');-- Lov name modified to ItemId for bug 6412260
2594: defaultInputValues := tempInput;
2595: EXCEPTION

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

2588: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
2589: tempInput JTF_DIAG_INPUTTBL;
2590: BEGIN
2591: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
2592: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
2593: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.bom.diag.lov.ItemLov');-- Lov name modified to ItemId for bug 6412260
2594: defaultInputValues := tempInput;
2595: EXCEPTION
2596: when others then

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

2589: tempInput JTF_DIAG_INPUTTBL;
2590: BEGIN
2591: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
2592: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
2593: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.bom.diag.lov.ItemLov');-- Lov name modified to ItemId for bug 6412260
2594: defaultInputValues := tempInput;
2595: EXCEPTION
2596: when others then
2597: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 2597: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

2593: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'ItemId','LOV-oracle.apps.bom.diag.lov.ItemLov');-- Lov name modified to ItemId for bug 6412260
2594: defaultInputValues := tempInput;
2595: EXCEPTION
2596: when others then
2597: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
2598: END getDefaultTestParams;
2599:
2600: Function getTestMode return INTEGER IS
2601: BEGIN

Line 2602: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

2598: END getDefaultTestParams;
2599:
2600: Function getTestMode return INTEGER IS
2601: BEGIN
2602: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
2603:
2604: END getTestMode;
2605:
2606: END BOM_DIAGUNITTEST_IBRDATA;