APPS.INV_DIAG_RSV_MS_DUMP dependencies on JTF_DIAGNOSTIC_COREAPI

Line 22: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

18: reportClob OUT NOCOPY CLOB) IS
19:
20: reportStr LONG;
21: counter NUMBER;
22: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
23: c_userid VARCHAR2(50);
24: statusStr VARCHAR2(50);
25: errStr VARCHAR2(4000);
26: fixInfo VARCHAR2(4000);

Line 40: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

36: BEGIN
37:
38: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
39: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
40: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
41: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
42:
43: row_limit := INV_DIAG_GRP.g_max_row;
44:

Line 41: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');

37:
38: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
39: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
40: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
41: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
42:
43: row_limit := INV_DIAG_GRP.g_max_row;
44:
45: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

Line 140: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Dump of Reservations');

136: END IF;
137:
138: END IF;
139:
140: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Dump of Reservations');
141:
142: ELSIF l_script = 'MS_DUMP' THEN
143: sqltxt := 'SELECT ' ||
144: ' MS.SUPPLY_TYPE_CODE,' ||

Line 215: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Dump of MTL_SUPPLY');

211:
212: END IF;
213:
214:
215: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Dump of MTL_SUPPLY');
216:
217: ELSE
218: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with Script Name');
219: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');

Line 219: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');

215: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Dump of MTL_SUPPLY');
216:
217: ELSE
218: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with Script Name');
219: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');
220: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose correct Script Name');
221: statusStr := 'FAILURE';
222: errStr := 'Invalid Script Name';
223: fixInfo := 'Please choose correct Script Name';

Line 220: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose correct Script Name');

216:
217: ELSE
218: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with Script Name');
219: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Script Name');
220: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose correct Script Name');
221: statusStr := 'FAILURE';
222: errStr := 'Invalid Script Name';
223: fixInfo := 'Please choose correct Script Name';
224: isFatal := 'FALSE';

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

234: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
235:
236: EXCEPTION
237: when others then
238: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
239: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
240: statusStr := 'FAILURE';
241: errStr := sqlerrm ||' occurred in script Exception handled';
242: fixInfo := 'Unexpected Exception in INVDP08B.pls';

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

235:
236: EXCEPTION
237: when others then
238: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
239: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
240: statusStr := 'FAILURE';
241: errStr := sqlerrm ||' occurred in script Exception handled';
242: fixInfo := 'Unexpected Exception in INVDP08B.pls';
243: isFatal := 'FALSE';