DBA Data[Home] [Help]

APPS.INV_DIAG_MO_CAN_SO 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 37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

33: BEGIN
34:
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
39:
40: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
41: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LineId',inputs);

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

34:
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
39:
40: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
41: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LineId',inputs);
42:

Line 45: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Organization Identifier');

41: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LineId',inputs);
42:
43: IF l_org_id IS NULL THEN
44: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization information');
45: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Organization Identifier');
46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct organization Identifier');
47: statusStr := 'FAILURE';
48: errStr := 'Invalid Organization Identifier';
49: fixInfo := 'Please enter or choose Organization identifier';

Line 46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct organization Identifier');

42:
43: IF l_org_id IS NULL THEN
44: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization information');
45: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Organization Identifier');
46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct organization Identifier');
47: statusStr := 'FAILURE';
48: errStr := 'Invalid Organization Identifier';
49: fixInfo := 'Please enter or choose Organization identifier';
50: isFatal := 'FALSE';

Line 84: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Move Order');

80: ' and mtr.organization_id = mp.organization_id(+)' ||
81: ' and mtr.inventory_item_id = mif.inventory_item_id(+)' ||
82: ' and mtr.organization_id = mif.organization_id(+) ';
83:
84: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Move Order');
85:
86:
87: reportStr := 'The test completed as expected';
88: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

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

91: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
92:
93: EXCEPTION
94: when others then
95: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
96: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
97: statusStr := 'FAILURE';
98: errStr := sqlerrm ||' occurred in script Exception handled';
99: fixInfo := 'Unexpected Exception in INVDM02B.pls';

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

92:
93: EXCEPTION
94: when others then
95: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
96: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
97: statusStr := 'FAILURE';
98: errStr := sqlerrm ||' occurred in script Exception handled';
99: fixInfo := 'Unexpected Exception in INVDM02B.pls';
100: isFatal := 'FALSE';