APPS.INV_DIAG_PI_SUBLOC dependencies on JTF_DIAGNOSTIC_COREAPI

Line 68: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

64:
65: BEGIN
66: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
67: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
68: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
69:
70: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
71:
72: sqltxt := ' select mif.item_number||''(''||mif.inventory_item_id||'')'' "Item (Id)"' ||

Line 104: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Onhand with invalid locators');

100: ' AND (decode(P.STOCK_LOCATOR_CONTROL_CODE,4,decode(S.LOCATOR_TYPE,5,I.LOCATION_CONTROL_CODE, S.LOCATOR_TYPE), ' ||
101: ' P.STOCK_LOCATOR_CONTROL_CODE) IN (2,3) )) ' ||
102: ' ORDER BY moqd.organization_id, moqd.inventory_item_id, moqd.create_transaction_id, moqd.update_transaction_id, moqd.locator_id ';
103:
104: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Onhand with invalid locators');
105:
106: FOR rec_inv_loc IN c_inv_loc (l_org_id ) LOOP
107:
108: sqltxt := ' SELECT mmt.transaction_id "Txn Id" ' ||

Line 139: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transaction with invalid locator');

135: ' AND mmt.transaction_action_id=ml.lookup_code ' ||
136: ' AND ml.lookup_type = ''MTL_TRANSACTION_ACTION'' ' ||
137: ' ORDER BY mmt.costed_flag, mmt.transaction_id ';
138:
139: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Transaction with invalid locator');
140:
141: FOR rec_phy_adj IN c_phy_adj (rec_inv_loc.create_transaction_id, rec_inv_loc.update_transaction_id) LOOP
142:
143: sqltxt := ' SELECT mpi.physical_inventory_name||''(''||mpi.physical_inventory_id||'')'' "Phy inv name(Id)",' ||

Line 159: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Details of Physical Inventory');

155: ' and mil.subinventory_code = mpit.subinventory' ||
156: ' and mil.inventory_location_id = mpit.locator_id) ' ||
157: ' ORDER BY mpi.physical_inventory_id ';
158:
159: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Details of Physical Inventory');
160:
161: sqltxt := ' SELECT ' ||
162: ' MPA.ADJUSTMENT_ID,' ||
163: ' MPA.ORGANIZATION_ID,' ||

Line 203: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Details of Physical Inventory Adjustments');

199: ' and mil.subinventory_code = mpa.subinventory_name' ||
200: ' and mil.inventory_location_id = mpa.locator_id)' ||
201: ' ORDER BY mpa.physical_inventory_id ' ;
202:
203: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Details of Physical Inventory Adjustments');
204:
205: END LOOP;
206:
207: END LOOP;

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

214: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
215:
216: EXCEPTION
217: when others then
218: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
219: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
220: statusStr := 'FAILURE';
221: errStr := sqlerrm ||' occurred in script Exception handled';
222: fixInfo := 'Unexpected Exception in INVDA02B.pls';

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

215:
216: EXCEPTION
217: when others then
218: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
219: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
220: statusStr := 'FAILURE';
221: errStr := sqlerrm ||' occurred in script Exception handled';
222: fixInfo := 'Unexpected Exception in INVDA02B.pls';
223: isFatal := 'FALSE';