APPS.INV_DIAG_OH_QTY_ZERO 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 48: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

44: BEGIN
45:
46: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
47: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
48: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
49: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
50:
51: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
52: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);

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

45:
46: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
47: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
48: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
49: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
50:
51: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
52: l_item_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
53:

Line 80: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of onhand quantity with transaction quantity as zero');

76: END IF;
77:
78: sqltxt := sqltxt || ' ORDER BY moqd.create_transaction_id ' ;
79:
80: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of onhand quantity with transaction quantity as zero');
81:
82: FOR rec_tnx IN c_tnx (l_org_id,l_item_id) LOOP
83: sqltxt := ' SELECT mmt.transaction_id "Txn Id"' ||
84: ' , mp.organization_code|| '' (''||mmt.organization_id ||'')'' "Organization|Code (Id)"' ||

Line 115: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Create Transaction Details for transaction_id ' || rec_tnx.create_transaction_id );

111: ' AND mmt.transaction_action_id=ml.lookup_code' ||
112: ' AND ml.lookup_type = ''MTL_TRANSACTION_ACTION''' ||
113: ' ORDER BY costed_flag, transaction_id ';
114:
115: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Create Transaction Details for transaction_id ' || rec_tnx.create_transaction_id );
116: END LOOP;
117:
118: reportStr := 'The test completed as expected';
119: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

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

122: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
123:
124: EXCEPTION
125: when others then
126: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
127: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
128: statusStr := 'FAILURE';
129: errStr := sqlerrm ||' occurred in script Exception handled';
130: fixInfo := 'Unexpected Exception in INVDO08B.pls';

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

123:
124: EXCEPTION
125: when others then
126: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
127: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
128: statusStr := 'FAILURE';
129: errStr := sqlerrm ||' occurred in script Exception handled';
130: fixInfo := 'Unexpected Exception in INVDO08B.pls';
131: isFatal := 'FALSE';