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.OPIMPXIN dependencies on EDW_LOG

Line 135: edw_log.put_line('CALCWIPCOMP p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

131:
132: OPEN wip_completion_no_lot_qty;
133:
134:
135: edw_log.put_line('CALCWIPCOMP p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
136: edw_log.put_line('CALCWIPCOMP p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
137:
138:
139: LOOP

Line 136: edw_log.put_line('CALCWIPCOMP p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

132: OPEN wip_completion_no_lot_qty;
133:
134:
135: edw_log.put_line('CALCWIPCOMP p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
136: edw_log.put_line('CALCWIPCOMP p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
137:
138:
139: LOOP
140:

Line 157: edw_log.put_line('NOT FOUND');

153:
154:
155: if(wip_completion_no_lot_qty%NOTFOUND) then
156:
157: edw_log.put_line('NOT FOUND');
158: CLOSE wip_completion_no_lot_qty;
159: exit;
160: end if;
161:

Line 175: /* edw_log.put_line('Insert_update_push_log'); */

171: p_total1 => total_qty,
172: selector => 1,
173: success => status);
174:
175: /* edw_log.put_line('Insert_update_push_log'); */
176: if (status > 0) then
177: edw_log.put_line('ERROR');
178:
179: Retcode := '2';

Line 177: edw_log.put_line('ERROR');

173: success => status);
174:
175: /* edw_log.put_line('Insert_update_push_log'); */
176: if (status > 0) then
177: edw_log.put_line('ERROR');
178:
179: Retcode := '2';
180: return;
181: end if;

Line 192: /* edw_log.put_line('2'); */

188: LOOP
189:
190: initialize(l_trx_date,l_organization_id,l_item_id,l_cost_group_id,l_revision,
191: l_lot_number,l_subinventory,l_locator,total_qty,total_value);
192: /* edw_log.put_line('2'); */
193: FETCH wip_completion_with_lot_qty
194: INTO l_trx_date,
195: l_organization_id,
196: l_item_id,

Line 207: edw_log.put_line('NOT FOUND');

203:
204:
205:
206: if(wip_completion_with_lot_qty%NOTFOUND) then
207: edw_log.put_line('NOT FOUND');
208: CLOSE wip_completion_with_lot_qty;
209: exit;
210: end if;
211:

Line 227: edw_log.put_line('error');

223: selector => 1,
224: success => status);
225:
226: if (status > 0) then
227: edw_log.put_line('error');
228: Retcode := '2';
229: return;
230: end if;
231:

Line 241: /* edw_log.put_line('3'); */

237: LOOP
238:
239: initialize(l_trx_date,l_organization_id,l_item_id,l_cost_group_id,l_revision,
240: l_lot_number,l_subinventory,l_locator,total_qty,total_value);
241: /* edw_log.put_line('3'); */
242: FETCH wip_completion_no_lot_val
243: INTO l_trx_date,
244: l_organization_id,
245: l_item_id,

Line 252: /* edw_log.put_line('3 after fetch'); */

248: l_subinventory,
249: l_locator,
250: total_value;
251:
252: /* edw_log.put_line('3 after fetch'); */
253: if(wip_completion_no_lot_val%NOTFOUND) then
254: edw_log.put_line('NOT FOUND');
255: CLOSE wip_completion_no_lot_val;
256: exit;

Line 254: edw_log.put_line('NOT FOUND');

250: total_value;
251:
252: /* edw_log.put_line('3 after fetch'); */
253: if(wip_completion_no_lot_val%NOTFOUND) then
254: edw_log.put_line('NOT FOUND');
255: CLOSE wip_completion_no_lot_val;
256: exit;
257: end if;
258:

Line 273: edw_log.put_line('error');

269: selector => 1,
270: success => status);
271:
272: if (status > 0) then
273: edw_log.put_line('error');
274: Retcode := '2';
275: return;
276: end if;
277:

Line 287: /* edw_log.put_line('4'); */

283: LOOP
284:
285: initialize(l_trx_date,l_organization_id,l_item_id,l_cost_group_id,l_revision,
286: l_lot_number,l_subinventory,l_locator,total_qty,total_value);
287: /* edw_log.put_line('4'); */
288: FETCH wip_completion_with_lot_val
289: INTO l_trx_date,
290: l_organization_id,
291: l_item_id,

Line 319: edw_log.put_line('error');

315: selector => 1,
316: success => status);
317:
318: if (status > 0) then
319: edw_log.put_line('error');
320: Retcode := '2';
321: return;
322: end if;
323:

Line 328: edw_log.put_line('EXCEPTIOn OTHERS');

324: END LOOP;
325:
326: EXCEPTION
327: WHEN OTHERS THEN
328: edw_log.put_line('EXCEPTIOn OTHERS');
329: edw_log.put_line('Error in calc_wip_completion');
330: Retcode := '2';
331:
332: end calc_wip_completion;

Line 329: edw_log.put_line('Error in calc_wip_completion');

325:
326: EXCEPTION
327: WHEN OTHERS THEN
328: edw_log.put_line('EXCEPTIOn OTHERS');
329: edw_log.put_line('Error in calc_wip_completion');
330: Retcode := '2';
331:
332: end calc_wip_completion;
333:

Line 462: edw_log.put_line('CALCWIPISS p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

458: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
459: BEGIN
460:
461:
462: edw_log.put_line('CALCWIPISS p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
463: edw_log.put_line('CALCWIPISS p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
464:
465:
466: OPEN wip_issue_no_lot_qty;

Line 463: edw_log.put_line('CALCWIPISS p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

459: BEGIN
460:
461:
462: edw_log.put_line('CALCWIPISS p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
463: edw_log.put_line('CALCWIPISS p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
464:
465:
466: OPEN wip_issue_no_lot_qty;
467:

Line 646: edw_log.put_line('Error in calc_wip_issue');

642: END LOOP;
643:
644: EXCEPTION
645: WHEN OTHERS THEN
646: edw_log.put_line('Error in calc_wip_issue');
647: Retcode := '2';
648:
649: end calc_wip_issue;
650:

Line 777: edw_log.put_line('CALCWIPRET p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

773: GROUP BY trunc(mmt.TRANSACTION_DATE),mmt.ORGANIZATION_ID,mmt.INVENTORY_ITEM_ID,mmt.COST_GROUP_ID,
774: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
775: BEGIN
776:
777: edw_log.put_line('CALCWIPRET p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
778: edw_log.put_line('CALCWIPRET p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
779: OPEN assembly_return_no_lot_qty;
780:
781: LOOP

Line 778: edw_log.put_line('CALCWIPRET p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

774: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
775: BEGIN
776:
777: edw_log.put_line('CALCWIPRET p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
778: edw_log.put_line('CALCWIPRET p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
779: OPEN assembly_return_no_lot_qty;
780:
781: LOOP
782:

Line 963: edw_log.put_line('Error in calc_assembly_return');

959: END LOOP;
960:
961: EXCEPTION
962: WHEN OTHERS THEN
963: edw_log.put_line('Error in calc_assembly_return');
964: Retcode := '2';
965:
966: end calc_assembly_return;
967:

Line 1111: edw_log.put_line('CALCPODEL p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

1107: GROUP BY trunc(mmt.TRANSACTION_DATE),mmt.ORGANIZATION_ID,mmt.INVENTORY_ITEM_ID,mmt.COST_GROUP_ID,
1108: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
1109: BEGIN
1110:
1111: edw_log.put_line('CALCPODEL p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
1112: edw_log.put_line('CALCPODEL p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
1113:
1114: OPEN po_deliveries_no_lot_qty;
1115:

Line 1112: edw_log.put_line('CALCPODEL p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

1108: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
1109: BEGIN
1110:
1111: edw_log.put_line('CALCPODEL p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
1112: edw_log.put_line('CALCPODEL p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
1113:
1114: OPEN po_deliveries_no_lot_qty;
1115:
1116: LOOP

Line 1297: edw_log.put_line('Error in calc_po_deliveries');

1293: END LOOP;
1294:
1295: EXCEPTION
1296: WHEN OTHERS THEN
1297: edw_log.put_line('Error in calc_po_deliveries');
1298: Retcode := '2';
1299:
1300: end calc_po_deliveries;
1301:

Line 1426: edw_log.put_line('CALCFROMORG p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

1422: GROUP BY trunc(mmt.TRANSACTION_DATE),mmt.ORGANIZATION_ID,mmt.INVENTORY_ITEM_ID,mmt.COST_GROUP_ID,
1423: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
1424: BEGIN
1425:
1426: edw_log.put_line('CALCFROMORG p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
1427: edw_log.put_line('CALCFROMORG p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
1428:
1429: OPEN value_from_orgs_no_lot_qty;
1430:

Line 1427: edw_log.put_line('CALCFROMORG p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

1423: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
1424: BEGIN
1425:
1426: edw_log.put_line('CALCFROMORG p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
1427: edw_log.put_line('CALCFROMORG p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
1428:
1429: OPEN value_from_orgs_no_lot_qty;
1430:
1431: LOOP

Line 1612: edw_log.put_line('Error in calc_value_from_orgs');

1608: END LOOP;
1609:
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: edw_log.put_line('Error in calc_value_from_orgs');
1613: Retcode := '2';
1614:
1615: end calc_value_from_orgs;
1616:

Line 1745: edw_log.put_line('CALCTOORG p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

1741: GROUP BY trunc(mmt.TRANSACTION_DATE),mmt.ORGANIZATION_ID,mmt.INVENTORY_ITEM_ID,mmt.COST_GROUP_ID,
1742: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
1743: BEGIN
1744:
1745: edw_log.put_line('CALCTOORG p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
1746: edw_log.put_line('CALCTOORG p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
1747:
1748: OPEN value_to_orgs_no_lot_qty;
1749:

Line 1746: edw_log.put_line('CALCTOORG p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

1742: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
1743: BEGIN
1744:
1745: edw_log.put_line('CALCTOORG p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
1746: edw_log.put_line('CALCTOORG p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
1747:
1748: OPEN value_to_orgs_no_lot_qty;
1749:
1750: LOOP

Line 1931: edw_log.put_line('Error in calc_value_to_orgs');

1927: END LOOP;
1928:
1929: EXCEPTION
1930: WHEN OTHERS THEN
1931: edw_log.put_line('Error in calc_value_to_orgs');
1932: Retcode := '2';
1933:
1934: end calc_value_to_orgs;
1935:

Line 2216: edw_log.put_line('CALCcstship p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

2212: -- End 11.5.10 changes*/
2213: ------------------------------------------------------------------------------
2214: BEGIN
2215:
2216: edw_log.put_line('CALCcstship p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
2217: edw_log.put_line('CALCcstship p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
2218:
2219: OPEN customer_shipment_no_lot_qty;
2220:

Line 2217: edw_log.put_line('CALCcstship p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

2213: ------------------------------------------------------------------------------
2214: BEGIN
2215:
2216: edw_log.put_line('CALCcstship p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
2217: edw_log.put_line('CALCcstship p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
2218:
2219: OPEN customer_shipment_no_lot_qty;
2220:
2221:

Line 2402: edw_log.put_line('Error in calc_customer_shipment');

2398: END LOOP;
2399:
2400: EXCEPTION
2401: WHEN OTHERS THEN
2402: edw_log.put_line('Error in calc_customer_shipment');
2403: Retcode := '2';
2404:
2405: end calc_customer_shipment;
2406:

Line 2528: edw_log.put_line('CALCadj p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

2524: GROUP BY trunc(mmt.TRANSACTION_DATE),mmt.ORGANIZATION_ID,mmt.INVENTORY_ITEM_ID,mmt.COST_GROUP_ID,
2525: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
2526: BEGIN
2527:
2528: edw_log.put_line('CALCadj p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
2529: edw_log.put_line('CALCadj p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
2530:
2531: OPEN inv_adj_no_lot_qty;
2532:

Line 2529: edw_log.put_line('CALCadj p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

2525: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
2526: BEGIN
2527:
2528: edw_log.put_line('CALCadj p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
2529: edw_log.put_line('CALCadj p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
2530:
2531: OPEN inv_adj_no_lot_qty;
2532:
2533: LOOP

Line 2711: edw_log.put_line('Error in calc_inv_adjustment');

2707: END LOOP;
2708:
2709: EXCEPTION
2710: WHEN OTHERS THEN
2711: edw_log.put_line('Error in calc_inv_adjustment');
2712: Retcode := '2';
2713:
2714: end calc_inv_adjustment;
2715:

Line 3029: edw_log.put_line('CALCTOTISS p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

3025: LOT_NUMBER, REVISION, SUBINVENTORY_CODE, LOCATOR_ID;
3026:
3027: BEGIN
3028:
3029: edw_log.put_line('CALCTOTISS p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
3030: edw_log.put_line('CALCTOTISS p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
3031:
3032: OPEN total_issue_no_lot_qty;
3033:

Line 3030: edw_log.put_line('CALCTOTISS p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

3026:
3027: BEGIN
3028:
3029: edw_log.put_line('CALCTOTISS p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
3030: edw_log.put_line('CALCTOTISS p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
3031:
3032: OPEN total_issue_no_lot_qty;
3033:
3034: LOOP

Line 3212: edw_log.put_line('Error in calc_total_issue');

3208: END LOOP;
3209:
3210: EXCEPTION
3211: WHEN OTHERS THEN
3212: edw_log.put_line('Error in calc_total_issue');
3213: Retcode := '2';
3214:
3215: end calc_total_issue;
3216:

Line 3381: edw_log.put_line('CALCTOTRCT p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));

3377: GROUP BY trunc(mmt.TRANSACTION_DATE),mmt.ORGANIZATION_ID,mmt.INVENTORY_ITEM_ID,mmt.COST_GROUP_ID,
3378: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
3379: BEGIN
3380:
3381: edw_log.put_line('CALCTOTRCT p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
3382: edw_log.put_line('CALCTOTRCT p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
3383: OPEN total_receipt_no_lot_qty;
3384:
3385: LOOP

Line 3382: edw_log.put_line('CALCTOTRCT p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));

3378: mmt.REVISION,mtln.lot_number,mmt.SUBINVENTORY_CODE,mmt.LOCATOR_ID;
3379: BEGIN
3380:
3381: edw_log.put_line('CALCTOTRCT p_from_Date '||to_char(p_from_date,'dd-mon-yyyy hh24:mi:ss'));
3382: edw_log.put_line('CALCTOTRCT p_to_Date '||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
3383: OPEN total_receipt_no_lot_qty;
3384:
3385: LOOP
3386: Initialize(l_trx_date,l_organization_id,l_item_id,l_cost_group_id,l_revision,

Line 3562: edw_log.put_line('Error in calc_total_receipt');

3558: END LOOP;
3559:
3560: EXCEPTION
3561: WHEN OTHERS THEN
3562: edw_log.put_line('Error in calc_total_receipt');
3563: Retcode := '2';
3564:
3565: end calc_total_receipt;
3566:

Line 3667: /* edw_log.put_line('IU_push_log: IDSKEY= '||l_pk); */

3663: ||p_revision||'-'||p_lot_number||'-'||p_subinventory||'-'||p_locator;
3664:
3665: --dbms_output.put_line('l_pk is ' || l_pk);
3666:
3667: /* edw_log.put_line('IU_push_log: IDSKEY= '||l_pk); */
3668:
3669:
3670: OPEN row_exists ;
3671:

Line 3735: edw_log.put_line('Error in Insert_update_push_log prodedure ');

3731: CLOSE row_exists ;
3732:
3733: EXCEPTION
3734: WHEN OTHERS THEN
3735: edw_log.put_line('Error in Insert_update_push_log prodedure ');
3736: edw_log.put_line('query errored '||l_query);
3737: success:=1;
3738: END Insert_update_push_log;
3739:

Line 3736: edw_log.put_line('query errored '||l_query);

3732:
3733: EXCEPTION
3734: WHEN OTHERS THEN
3735: edw_log.put_line('Error in Insert_update_push_log prodedure ');
3736: edw_log.put_line('query errored '||l_query);
3737: success:=1;
3738: END Insert_update_push_log;
3739:
3740: /*}----------------------------------------------

Line 3769: edw_log.put_line('Error in Initialize');

3765: total_value := 0;
3766:
3767: EXCEPTION
3768: WHEN OTHERS THEN
3769: edw_log.put_line('Error in Initialize');
3770:
3771: end Initialize;
3772:
3773: End OPIMPXIN;