eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_DIAG_TDUMP dependencies on JTF_DIAGNOSTIC_COREAPI

Line 37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

33: l_proc_flag varchar2(1);
34: BEGIN
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: -- accept input
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40: l_txn_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('TransactionId',inputs);
41: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);

Line 50: JTF_DIAGNOSTIC_COREAPI.BRPrint;

46:
47: row_limit :=INV_DIAG_GRP.g_max_row;
48:
49: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Table name '||l_script);
50: JTF_DIAGNOSTIC_COREAPI.BRPrint;
51: if l_script = 'mmt' then
52: if l_txn_id is not null then
53: sqltxt := 'select * from MTL_MATERIAL_TRANSACTIONS where transaction_id ='||l_txn_id;
54: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MMT for transaction '||l_txn_id);

Line 54: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MMT for transaction '||l_txn_id);

50: JTF_DIAGNOSTIC_COREAPI.BRPrint;
51: if l_script = 'mmt' then
52: if l_txn_id is not null then
53: sqltxt := 'select * from MTL_MATERIAL_TRANSACTIONS where transaction_id ='||l_txn_id;
54: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MMT for transaction '||l_txn_id);
55: statusStr := 'SUCCESS';
56: elsif l_item_id is not null then
57: sqltxt := 'select * from MTL_MATERIAL_TRANSACTIONS where inventory_item_id ='||l_item_id||
58: ' order by transaction_id';

Line 61: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_MATERIAL_TRANSACTIONS for item id '||l_item_id);

57: sqltxt := 'select * from MTL_MATERIAL_TRANSACTIONS where inventory_item_id ='||l_item_id||
58: ' order by transaction_id';
59: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
60:
61: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_MATERIAL_TRANSACTIONS for item id '||l_item_id);
62: statusStr := 'SUCCESS';
63: else
64: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Parameter input is requred to get dump of MTL_MATERIAL_TRANSACTIONS!');
65: statusStr := 'FAILURE';

Line 64: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Parameter input is requred to get dump of MTL_MATERIAL_TRANSACTIONS!');

60:
61: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_MATERIAL_TRANSACTIONS for item id '||l_item_id);
62: statusStr := 'SUCCESS';
63: else
64: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Parameter input is requred to get dump of MTL_MATERIAL_TRANSACTIONS!');
65: statusStr := 'FAILURE';
66: errStr := 'This test failed as: no input';
67: fixInfo := 'Please enter at least one of the following parameters: TransactionId or ItemId';
68: isFatal := 'SUCCESS';

Line 93: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_MATERIAL_TRANSACTIONS_TEMP'||reportStr||' Transactions');

89: end if;
90:
91: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
92:
93: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_MATERIAL_TRANSACTIONS_TEMP'||reportStr||' Transactions');
94: else
95:
96: sqltxt := 'select * from mtl_material_transactions_temp where rownum <= '||row_limit;
97: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_MATERIAL_TRANSACTIONS_TEMP for All Pending Transactions ');

Line 97: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_MATERIAL_TRANSACTIONS_TEMP for All Pending Transactions ');

93: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_MATERIAL_TRANSACTIONS_TEMP'||reportStr||' Transactions');
94: else
95:
96: sqltxt := 'select * from mtl_material_transactions_temp where rownum <= '||row_limit;
97: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_MATERIAL_TRANSACTIONS_TEMP for All Pending Transactions ');
98: statusStr := 'SUCCESS';
99: end if;
100: elsif l_script = 'mti' then
101: if l_txn_id is not null or l_item_id is not null or l_proc_flag = 'E' or l_org_id is not null then

Line 122: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTIONS_INTERFACE'||reportStr||' Transactions');

118: reportStr := reportStr||' - Organization id'||l_org_id;
119: end if;
120:
121: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
122: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTIONS_INTERFACE'||reportStr||' Transactions');
123: else
124: sqltxt := 'select * from mtl_transactions_interface where rownum <= '||row_limit;
125: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTIONS_INTERFACE for All Pending Transactions ');
126: statusStr := 'SUCCESS';

Line 125: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTIONS_INTERFACE for All Pending Transactions ');

121: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
122: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTIONS_INTERFACE'||reportStr||' Transactions');
123: else
124: sqltxt := 'select * from mtl_transactions_interface where rownum <= '||row_limit;
125: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTIONS_INTERFACE for All Pending Transactions ');
126: statusStr := 'SUCCESS';
127: end if;
128: elsif l_script = 'mut' then
129: if l_txn_id is not null or l_item_id is not null or l_proc_flag = 'E' or l_org_id is not null

Line 151: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_UNIT_TRANSACTIONS'||reportStr||' Transactions');

147: reportStr := reportStr||' - Serial Number '||l_sn;
148: end if;
149:
150: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
151: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_UNIT_TRANSACTIONS'||reportStr||' Transactions');
152: else
153: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Parameter input is requred to get dump of MTL_UNIT_TRANSACTIONS!');
154: statusStr := 'FAILURE';
155: errStr := 'This test failed as: no input';

Line 153: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Parameter input is requred to get dump of MTL_UNIT_TRANSACTIONS!');

149:
150: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
151: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_UNIT_TRANSACTIONS'||reportStr||' Transactions');
152: else
153: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Parameter input is requred to get dump of MTL_UNIT_TRANSACTIONS!');
154: statusStr := 'FAILURE';
155: errStr := 'This test failed as: no input';
156: fixInfo := 'Please enter at least one of the following parameters Org, Item, TransactionId, Serial Number';
157: isFatal := 'SUCCESS';

Line 182: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTION_LOT_NUMBERS'||reportStr||' Transactions');

178: reportStr := reportStr||' - Lot '||l_lot;
179: end if;
180:
181: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
182: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTION_LOT_NUMBERS'||reportStr||' Transactions');
183: else
184: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Parameter input is requred to get dump of MTL_TRANSACTION_LOT_NUMBERS!');
185: statusStr := 'FAILURE';
186: errStr := 'This test failed as: no input';

Line 184: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Parameter input is requred to get dump of MTL_TRANSACTION_LOT_NUMBERS!');

180:
181: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
182: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTION_LOT_NUMBERS'||reportStr||' Transactions');
183: else
184: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Parameter input is requred to get dump of MTL_TRANSACTION_LOT_NUMBERS!');
185: statusStr := 'FAILURE';
186: errStr := 'This test failed as: no input';
187: fixInfo := 'Please enter at least one of the following parameters Org, Item, TransactionId, Lot Number';
188: isFatal := 'SUCCESS';

Line 205: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_SERIAL_NUMBERS_TEMP'||reportStr||' Transactions');

201: ' or to_serial_number = '''||l_sn||''')';
202: reportStr := reportStr||' - Serial Number '||l_sn;
203: end if;
204: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
205: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_SERIAL_NUMBERS_TEMP'||reportStr||' Transactions');
206:
207: else
208: sqltxt := 'select * from MTL_SERIAL_NUMBERS_TEMP where rownum <= '||row_limit;
209: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_SERIAL_NUMBERS_TEMP for All Pending Transactions ');

Line 209: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_SERIAL_NUMBERS_TEMP for All Pending Transactions ');

205: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_SERIAL_NUMBERS_TEMP'||reportStr||' Transactions');
206:
207: else
208: sqltxt := 'select * from MTL_SERIAL_NUMBERS_TEMP where rownum <= '||row_limit;
209: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_SERIAL_NUMBERS_TEMP for All Pending Transactions ');
210: statusStr := 'SUCCESS';
211: end if;
212: elsif l_script ='mtlt' then
213: if l_txn_id is not null or l_item_id is not null or l_proc_flag = 'E' or l_org_id is not null

Line 226: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTION_LOTS_TEMP'||reportStr||' Transactions');

222: sqltxt := sqltxt||' and lot_number = '''||l_lot||'''';
223: reportStr := reportStr||' - Lot '||l_lot;
224: end if;
225: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
226: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTION_LOTS_TEMP'||reportStr||' Transactions');
227:
228: else
229: sqltxt := 'select * from MTL_SERIAL_NUMBERS_TEMP where rownum <= '||row_limit;
230: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTION_LOTS_TEMP for All Pending Transactions ');

Line 230: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTION_LOTS_TEMP for All Pending Transactions ');

226: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTION_LOTS_TEMP'||reportStr||' Transactions');
227:
228: else
229: sqltxt := 'select * from MTL_SERIAL_NUMBERS_TEMP where rownum <= '||row_limit;
230: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Dump of MTL_TRANSACTION_LOTS_TEMP for All Pending Transactions ');
231: statusStr := 'SUCCESS';
232: end if;
233: end if;
234: