DBA Data[Home] [Help]

APPS.INV_DIAG_OH_SERIAL_STATUS dependencies on JTF_DIAGNOSTIC_COREAPI

Line 32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

28:
29: BEGIN
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
35:
36: sqltxt := ' SELECT mp.organization_code' ||

Line 78: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand with status populated for Onhand material status tracked organization for serial controlled Item');

74: ' mtsv.status_code ,' ||
75: ' moqd.status_id ';
76:
77:
78: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand with status populated for Onhand material status tracked organization for serial controlled Item');
79:
80: reportStr := 'The test completed as expected';
81: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
82: statusStr := 'SUCCESS';

Line 88: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

84: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
85:
86: EXCEPTION
87: when others then
88: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
89: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
90: statusStr := 'FAILURE';
91: errStr := sqlerrm ||' occurred in script Exception handled';
92: fixInfo := 'Unexpected Exception in INVDOH2B.pls';

Line 89: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');

85:
86: EXCEPTION
87: when others then
88: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
89: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
90: statusStr := 'FAILURE';
91: errStr := sqlerrm ||' occurred in script Exception handled';
92: fixInfo := 'Unexpected Exception in INVDOH2B.pls';
93: isFatal := 'FALSE';