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.RCV_SHIPMENT_LINES_PKG dependencies on FND_LOG

Line 19: /* Taken from Package FND_LOG

15: p_msg in varchar2)
16: IS
17: l_module varchar2(2000);
18: BEGIN
19: /* Taken from Package FND_LOG
20: LEVEL_UNEXPECTED CONSTANT NUMBER := 6;
21: LEVEL_ERROR CONSTANT NUMBER := 5;
22: LEVEL_EXCEPTION CONSTANT NUMBER := 4;
23: LEVEL_EVENT CONSTANT NUMBER := 3;

Line 30: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

26: */
27:
28: l_module := 'pos.plsql.rcv_shipment_lines_pkg.'||p_api_name;
29: IF(g_asn_debug = 'Y')THEN
30: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
31: FND_LOG.string(LOG_LEVEL => p_level,
32: MODULE => l_module,
33: MESSAGE => p_msg);
34: END IF;

Line 31: FND_LOG.string(LOG_LEVEL => p_level,

27:
28: l_module := 'pos.plsql.rcv_shipment_lines_pkg.'||p_api_name;
29: IF(g_asn_debug = 'Y')THEN
30: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
31: FND_LOG.string(LOG_LEVEL => p_level,
32: MODULE => l_module,
33: MESSAGE => p_msg);
34: END IF;
35:

Line 201: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

197: l_api_name := l_itemkey || ' update_wc_line';
198:
199:
200: IF (g_asn_debug = 'Y') THEN
201: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
202: 'Enter update_wc_line');
203: END IF;
204:
205: IF (g_asn_debug = 'Y') THEN

Line 206: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

202: 'Enter update_wc_line');
203: END IF;
204:
205: IF (g_asn_debug = 'Y') THEN
206: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
207: 'Before call to update_quantity_amount');
208: END IF;
209:
210: update_quantity_amount(p_shipment_line_id,p_quantity_shipped,p_amount_shipped);

Line 212: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

208: END IF;
209:
210: update_quantity_amount(p_shipment_line_id,p_quantity_shipped,p_amount_shipped);
211: IF (g_asn_debug = 'Y') THEN
212: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
213: 'After call to update_quantity_amount');
214: END IF;
215:
216: update rcv_shipment_lines

Line 232: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

228: Raise NO_DATA_FOUND;
229: end if;
230:
231: IF (g_asn_debug = 'Y') THEN
232: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
233: 'Leave update_wc_line');
234: END IF;
235:
236: return;

Line 298: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

294: l_api_name := l_itemkey || ' update_quantity_amount';
295:
296:
297: IF (g_asn_debug = 'Y') THEN
298: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
299: 'Enter update_quantity_amount');
300: END IF;
301:
302: /* Get the original quantity or amount. We need this

Line 315: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

311: from rcv_shipment_lines
312: where shipment_line_id = p_shipment_line_id;
313:
314: IF (g_asn_debug = 'Y') THEN
315: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
316: 'l_orig_qty_shipped ' ||l_orig_qty_shipped);
317: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
318: 'l_orig_amt_shipped ' ||l_orig_amt_shipped);
319: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 317: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

313:
314: IF (g_asn_debug = 'Y') THEN
315: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
316: 'l_orig_qty_shipped ' ||l_orig_qty_shipped);
317: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
318: 'l_orig_amt_shipped ' ||l_orig_amt_shipped);
319: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
320: 'l_line_location_id ' ||l_line_location_id);
321: END IF;

Line 319: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

315: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
316: 'l_orig_qty_shipped ' ||l_orig_qty_shipped);
317: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
318: 'l_orig_amt_shipped ' ||l_orig_amt_shipped);
319: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
320: 'l_line_location_id ' ||l_line_location_id);
321: END IF;
322:
323:

Line 329: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

325: l_qty_shipped := p_quantity_shipped - l_orig_qty_shipped;
326: l_amt_shipped := p_amount_shipped - l_orig_amt_shipped;
327:
328: IF (g_asn_debug = 'Y') THEN
329: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
330: 'l_qty_shipped ' ||l_qty_shipped);
331: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
332: 'l_amt_shipped ' ||l_amt_shipped);
333: end if;

Line 331: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

327:
328: IF (g_asn_debug = 'Y') THEN
329: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
330: 'l_qty_shipped ' ||l_qty_shipped);
331: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
332: 'l_amt_shipped ' ||l_amt_shipped);
333: end if;
334:
335: UPDATE po_line_locations_all poll

Line 347: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

343: where poll.line_location_id = l_line_location_id;
344:
345:
346: IF (g_asn_debug = 'Y') THEN
347: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
348: 'After update to poll ' );
349: end if;
350:
351: If (p_amount_shipped is not null) then

Line 357: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

353: end if;
354:
355: /* To update PO supply we need to know the distribution id */
356: IF (g_asn_debug = 'Y') THEN
357: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
358: 'p_shipment_line_id '||p_shipment_line_id );
359: end if;
360:
361: select po_distribution_id

Line 369: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

365: and po_line_location_id = l_line_location_id
366: and shipment_line_id = p_shipment_line_id;
367:
368: IF (g_asn_debug = 'Y') THEN
369: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
370: 'l_distribution_id '||l_distribution_id );
371: end if;
372:
373: /* Update the shipment qty with the new quantity. */

Line 382: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

378: and po_line_location_id = l_line_location_id
379: and shipment_line_id = p_shipment_line_id;
380:
381: IF (g_asn_debug = 'Y') THEN
382: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
383: 'After update to shipment supply' );
384: end if;
385:
386: /* Update PO supply in mtl_supply */

Line 395: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

391: and po_distribution_id = l_distribution_id;
392:
393:
394: IF (g_asn_debug = 'Y') THEN
395: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
396: 'After update to PO supply' );
397: end if;
398:
399: open supply_info;

Line 411: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

407: l_supply_rowid;
408: exit when supply_info%notfound;
409:
410: IF (g_asn_debug = 'Y') THEN
411: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
412: 'l_supply_uom '||l_supply_uom );
413: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
414: 'l_supply_item_id '||l_supply_item_id );
415: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 413: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

409:
410: IF (g_asn_debug = 'Y') THEN
411: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
412: 'l_supply_uom '||l_supply_uom );
413: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
414: 'l_supply_item_id '||l_supply_item_id );
415: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
416: 'l_supply_from_org '||l_supply_from_org );
417: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 415: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

411: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
412: 'l_supply_uom '||l_supply_uom );
413: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
414: 'l_supply_item_id '||l_supply_item_id );
415: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
416: 'l_supply_from_org '||l_supply_from_org );
417: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
418: 'l_supply_to_org '||l_supply_to_org );
419: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 417: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

413: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
414: 'l_supply_item_id '||l_supply_item_id );
415: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
416: 'l_supply_from_org '||l_supply_from_org );
417: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
418: 'l_supply_to_org '||l_supply_to_org );
419: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
420: 'l_supply_receipt_date '||l_supply_receipt_date );
421: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 419: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

415: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
416: 'l_supply_from_org '||l_supply_from_org );
417: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
418: 'l_supply_to_org '||l_supply_to_org );
419: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
420: 'l_supply_receipt_date '||l_supply_receipt_date );
421: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
422: 'l_supply_rowid '||l_supply_rowid );
423: end if;

Line 421: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

417: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
418: 'l_supply_to_org '||l_supply_to_org );
419: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
420: 'l_supply_receipt_date '||l_supply_receipt_date );
421: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
422: 'l_supply_rowid '||l_supply_rowid );
423: end if;
424:
425: if (l_supply_qty = 0) then --{

Line 427: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

423: end if;
424:
425: if (l_supply_qty = 0) then --{
426: IF (g_asn_debug = 'Y') THEN
427: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
428: 'Before Delete' );
429: end if;
430:
431: delete from mtl_supply

Line 434: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

430:
431: delete from mtl_supply
432: where rowid = l_supply_rowid;
433: IF (g_asn_debug = 'Y') THEN
434: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
435: 'After Delete' );
436: end if;
437: return;
438: else --}{

Line 440: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

436: end if;
437: return;
438: else --}{
439: IF (g_asn_debug = 'Y') THEN
440: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
441: 'Supply qty not 0' );
442: end if;
443: if l_supply_item_id = -1 then --{
444: SELECT muom.unit_of_measure, NULL

Line 474: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

470: l_primary_qty
471: );
472:
473: IF (g_asn_debug = 'Y') THEN
474: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
475: 'Before update to mtl_supply.quantity' );
476: end if;
477: UPDATE MTL_SUPPLY
478: SET TO_ORG_PRIMARY_QUANTITY = l_primary_qty,

Line 490: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

486: + nvl(l_lead_time, 0 ))
487: WHERE ROWID = l_supply_rowid;
488:
489: IF (g_asn_debug = 'Y') THEN
490: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
491: 'After update to mtl_supply.quantity' );
492: end if;
493:
494:

Line 499: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

495: end loop;
496:
497: close supply_info;
498: IF (g_asn_debug = 'Y') THEN
499: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
500: 'Leave update_quantity_amount' );
501: end if;
502:
503: EXCEPTION

Line 531: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

527: l_api_name := l_itemkey || ' delete_line_s';
528:
529:
530: IF (g_asn_debug = 'Y') THEN
531: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
532: 'Enter delete_line_s');
533: END IF;
534:
535: IF (g_asn_debug = 'Y') THEN

Line 536: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

532: 'Enter delete_line_s');
533: END IF;
534:
535: IF (g_asn_debug = 'Y') THEN
536: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
537: 'p_shipment_line_id '||p_shipment_line_id);
538: END IF;
539:
540: update_quantity_amount(p_shipment_line_id,

Line 545: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

541: 0,--quantity_shipped
542: 0); --amount_shipped
543:
544: IF (g_asn_debug = 'Y') THEN
545: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
546: 'Before Delete '||p_shipment_line_id);
547: END IF;
548:
549: delete from rcv_shipment_lines

Line 580: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

576: l_api_name := l_itemkey || ' update_approval_status';
577:
578:
579: IF (g_asn_debug = 'Y') THEN
580: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
581: 'Enter HEADER update_approval_status');
582: END IF;
583:
584: update rcv_shipment_headers

Line 606: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

602: l_api_name := l_itemkey || ' update_approval_status';
603:
604:
605: IF (g_asn_debug = 'Y') THEN
606: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
607: 'Enter LINE update_approval_status');
608: END IF;
609:
610: update rcv_shipment_lines

Line 620: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

616: where shipment_line_id = p_document_id;
617:
618: end if;
619: IF (g_asn_debug = 'Y') THEN
620: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
621: 'Leave update_approval_status');
622: END IF;
623:
624: EXCEPTION