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 217: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

213: l_api_name := l_itemkey || ' update_wc_line';
214:
215:
216: IF (g_asn_debug = 'Y') THEN
217: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
218: 'Enter update_wc_line');
219: END IF;
220:
221: IF (g_asn_debug = 'Y') THEN

Line 222: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

218: 'Enter update_wc_line');
219: END IF;
220:
221: IF (g_asn_debug = 'Y') THEN
222: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
223: 'Before call to update_quantity_amount');
224: END IF;
225:
226: update_quantity_amount(p_shipment_line_id,p_quantity_shipped,p_amount_shipped);

Line 228: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

224: END IF;
225:
226: update_quantity_amount(p_shipment_line_id,p_quantity_shipped,p_amount_shipped);
227: IF (g_asn_debug = 'Y') THEN
228: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
229: 'After call to update_quantity_amount');
230: END IF;
231:
232: /* Bug 8899316 */

Line 260: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

256: Raise NO_DATA_FOUND;
257: end if; */
258:
259: IF (g_asn_debug = 'Y') THEN
260: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
261: 'Leave update_wc_line');
262: END IF;
263:
264: return;

Line 341: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

337: l_api_name := l_itemkey || ' update_quantity_amount';
338:
339:
340: IF (g_asn_debug = 'Y') THEN
341: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
342: 'Enter update_quantity_amount');
343: END IF;
344:
345: /* Get the original quantity or amount. We need this

Line 358: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

354: from rcv_shipment_lines
355: where shipment_line_id = p_shipment_line_id;
356:
357: IF (g_asn_debug = 'Y') THEN
358: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
359: 'l_orig_qty_shipped ' ||l_orig_qty_shipped);
360: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
361: 'l_orig_amt_shipped ' ||l_orig_amt_shipped);
362: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 360: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

356:
357: IF (g_asn_debug = 'Y') THEN
358: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
359: 'l_orig_qty_shipped ' ||l_orig_qty_shipped);
360: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
361: 'l_orig_amt_shipped ' ||l_orig_amt_shipped);
362: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
363: 'l_line_location_id ' ||l_line_location_id);
364: END IF;

Line 362: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

358: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
359: 'l_orig_qty_shipped ' ||l_orig_qty_shipped);
360: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
361: 'l_orig_amt_shipped ' ||l_orig_amt_shipped);
362: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
363: 'l_line_location_id ' ||l_line_location_id);
364: END IF;
365:
366:

Line 372: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

368: l_qty_shipped := p_quantity_shipped - l_orig_qty_shipped;
369: l_amt_shipped := p_amount_shipped - l_orig_amt_shipped;
370:
371: IF (g_asn_debug = 'Y') THEN
372: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
373: 'l_qty_shipped ' ||l_qty_shipped);
374: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
375: 'l_amt_shipped ' ||l_amt_shipped);
376: end if;

Line 374: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

370:
371: IF (g_asn_debug = 'Y') THEN
372: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
373: 'l_qty_shipped ' ||l_qty_shipped);
374: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
375: 'l_amt_shipped ' ||l_amt_shipped);
376: end if;
377:
378: UPDATE po_line_locations_all poll

Line 390: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

386: where poll.line_location_id = l_line_location_id;
387:
388:
389: IF (g_asn_debug = 'Y') THEN
390: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
391: 'After update to poll ' );
392: end if;
393:
394: If (p_amount_shipped is not null) then

Line 400: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

396: end if;
397:
398: /* To update PO supply we need to know the distribution id */
399: IF (g_asn_debug = 'Y') THEN
400: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
401: 'p_shipment_line_id '||p_shipment_line_id );
402: end if;
403:
404: /* Bug 8899316: Commenting this code as mtl_supply logic is incorrect */

Line 415: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

411: and po_line_location_id = l_line_location_id
412: and shipment_line_id = p_shipment_line_id;
413:
414: IF (g_asn_debug = 'Y') THEN
415: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
416: 'l_distribution_id '||l_distribution_id );
417: end if;
418:
419: update mtl_supply

Line 427: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

423: and po_line_location_id = l_line_location_id
424: and shipment_line_id = p_shipment_line_id;
425:
426: IF (g_asn_debug = 'Y') THEN
427: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
428: 'After update to shipment supply' );
429: end if;
430:
431: update mtl_supply

Line 439: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

435: and po_distribution_id = l_distribution_id;
436:
437:
438: IF (g_asn_debug = 'Y') THEN
439: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
440: 'After update to PO supply' );
441: end if;
442:
443: */

Line 466: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

462: and po_distribution_id = l_distribution_id
463: and shipment_line_id = p_shipment_line_id;
464:
465: IF (g_asn_debug = 'Y') THEN
466: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
467: 'l_distribution_id '||l_distribution_id );
468: end if;
469:
470: l_wc_qty := p_quantity_shipped;

Line 581: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

577: l_supply_rowid;
578: exit when supply_info%notfound;
579:
580: IF (g_asn_debug = 'Y') THEN
581: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
582: 'l_supply_uom '||l_supply_uom );
583: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
584: 'l_supply_item_id '||l_supply_item_id );
585: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 583: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

579:
580: IF (g_asn_debug = 'Y') THEN
581: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
582: 'l_supply_uom '||l_supply_uom );
583: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
584: 'l_supply_item_id '||l_supply_item_id );
585: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
586: 'l_supply_from_org '||l_supply_from_org );
587: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 585: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

581: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
582: 'l_supply_uom '||l_supply_uom );
583: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
584: 'l_supply_item_id '||l_supply_item_id );
585: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
586: 'l_supply_from_org '||l_supply_from_org );
587: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
588: 'l_supply_to_org '||l_supply_to_org );
589: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 587: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

583: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
584: 'l_supply_item_id '||l_supply_item_id );
585: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
586: 'l_supply_from_org '||l_supply_from_org );
587: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
588: 'l_supply_to_org '||l_supply_to_org );
589: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
590: 'l_supply_receipt_date '||l_supply_receipt_date );
591: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 589: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

585: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
586: 'l_supply_from_org '||l_supply_from_org );
587: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
588: 'l_supply_to_org '||l_supply_to_org );
589: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
590: 'l_supply_receipt_date '||l_supply_receipt_date );
591: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
592: 'l_supply_rowid '||l_supply_rowid );
593: end if;

Line 591: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

587: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
588: 'l_supply_to_org '||l_supply_to_org );
589: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
590: 'l_supply_receipt_date '||l_supply_receipt_date );
591: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
592: 'l_supply_rowid '||l_supply_rowid );
593: end if;
594:
595: if (l_supply_qty = 0) then --{

Line 597: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

593: end if;
594:
595: if (l_supply_qty = 0) then --{
596: IF (g_asn_debug = 'Y') THEN
597: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
598: 'Before Delete' );
599: end if;
600:
601: delete from mtl_supply

Line 604: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

600:
601: delete from mtl_supply
602: where rowid = l_supply_rowid;
603: IF (g_asn_debug = 'Y') THEN
604: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
605: 'After Delete' );
606: end if;
607: return;
608: else --}{

Line 610: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

606: end if;
607: return;
608: else --}{
609: IF (g_asn_debug = 'Y') THEN
610: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
611: 'Supply qty not 0' );
612: end if;
613: if l_supply_item_id = -1 then --{
614: SELECT muom.unit_of_measure, NULL

Line 644: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

640: l_primary_qty
641: );
642:
643: IF (g_asn_debug = 'Y') THEN
644: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
645: 'Before update to mtl_supply.quantity' );
646: end if;
647: UPDATE MTL_SUPPLY
648: SET TO_ORG_PRIMARY_QUANTITY = l_primary_qty,

Line 660: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

656: + nvl(l_lead_time, 0 ))
657: WHERE ROWID = l_supply_rowid;
658:
659: IF (g_asn_debug = 'Y') THEN
660: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
661: 'After update to mtl_supply.quantity' );
662: end if;
663:
664:

Line 669: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

665: end loop;
666:
667: close supply_info;
668: IF (g_asn_debug = 'Y') THEN
669: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
670: 'Leave update_quantity_amount' );
671: end if;
672:
673: EXCEPTION

Line 701: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

697: l_api_name := l_itemkey || ' delete_line_s';
698:
699:
700: IF (g_asn_debug = 'Y') THEN
701: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
702: 'Enter delete_line_s');
703: END IF;
704:
705: IF (g_asn_debug = 'Y') THEN

Line 706: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

702: 'Enter delete_line_s');
703: END IF;
704:
705: IF (g_asn_debug = 'Y') THEN
706: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
707: 'p_shipment_line_id '||p_shipment_line_id);
708: END IF;
709:
710: update_quantity_amount(p_shipment_line_id,

Line 715: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

711: 0,--quantity_shipped
712: 0); --amount_shipped
713:
714: IF (g_asn_debug = 'Y') THEN
715: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
716: 'Before Delete '||p_shipment_line_id);
717: END IF;
718:
719: delete from rcv_shipment_lines

Line 750: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

746: l_api_name := l_itemkey || ' update_approval_status';
747:
748:
749: IF (g_asn_debug = 'Y') THEN
750: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
751: 'Enter HEADER update_approval_status');
752: END IF;
753:
754: update rcv_shipment_headers

Line 776: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

772: l_api_name := l_itemkey || ' update_approval_status';
773:
774:
775: IF (g_asn_debug = 'Y') THEN
776: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
777: 'Enter LINE update_approval_status');
778: END IF;
779:
780: update rcv_shipment_lines

Line 790: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

786: where shipment_line_id = p_document_id;
787:
788: end if;
789: IF (g_asn_debug = 'Y') THEN
790: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
791: 'Leave update_approval_status');
792: END IF;
793:
794: EXCEPTION

Line 831: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

827: AND shipment_line_id = p_shipment_line_id;
828:
829:
830: IF (g_asn_debug = 'Y') THEN
831: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
832: 'Enter correct_wc_line');
833: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
834: 'interface_transaction_id : ' || p_interface_transaction_id);
835: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 833: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

829:
830: IF (g_asn_debug = 'Y') THEN
831: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
832: 'Enter correct_wc_line');
833: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
834: 'interface_transaction_id : ' || p_interface_transaction_id);
835: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
836: 'shipment_line_id : ' || p_shipment_line_id);
837: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 835: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

831: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
832: 'Enter correct_wc_line');
833: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
834: 'interface_transaction_id : ' || p_interface_transaction_id);
835: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
836: 'shipment_line_id : ' || p_shipment_line_id);
837: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
838: 'quantity : ' || l_trx_quantity);
839: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 837: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

833: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
834: 'interface_transaction_id : ' || p_interface_transaction_id);
835: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
836: 'shipment_line_id : ' || p_shipment_line_id);
837: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
838: 'quantity : ' || l_trx_quantity);
839: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
840: 'amount : ' || l_trx_amount);
841: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 839: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

835: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
836: 'shipment_line_id : ' || p_shipment_line_id);
837: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
838: 'quantity : ' || l_trx_quantity);
839: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
840: 'amount : ' || l_trx_amount);
841: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
842: 'requested_amount : ' || l_requested_amount);
843: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

Line 841: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

837: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
838: 'quantity : ' || l_trx_quantity);
839: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
840: 'amount : ' || l_trx_amount);
841: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
842: 'requested_amount : ' || l_requested_amount);
843: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
844: 'material_stored_amount : ' || l_material_stored_amount);
845: END IF;

Line 843: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

839: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
840: 'amount : ' || l_trx_amount);
841: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
842: 'requested_amount : ' || l_requested_amount);
843: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
844: 'material_stored_amount : ' || l_material_stored_amount);
845: END IF;
846:
847: update rcv_shipment_lines

Line 855: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

851: material_stored_amount = material_stored_amount + l_material_stored_amount
852: WHERE shipment_line_id = p_shipment_line_id;
853:
854: IF (g_asn_debug = 'Y') THEN
855: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
856: 'Leave correct_wc_line');
857: END IF;
858:
859: return;

Line 897: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

893: x_progress := 10;
894: l_api_name := 'rcv_shipment_lines_pkg.get_wc_available_quantity';
895: x_progress := 20;
896: IF (g_asn_debug = 'Y') THEN
897: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
898: 'Enter get_wc_available_quantity');
899: END IF;
900: x_progress := 30;
901:

Line 918: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

914: p_unit_of_measure => x_primary_uom
915: );
916:
917: IF (g_asn_debug = 'Y') THEN
918: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
919: 'transactions_id : ' || c_lines.transaction_id
920: || ' ,available_quantity : ' || x_available_quantity );
921: END IF;
922:

Line 928: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

924:
925: END LOOP;
926:
927: IF (g_asn_debug = 'Y') THEN
928: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
929: 'p_available_quantity : ' || p_available_quantity);
930: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
931: 'Leave get_wc_available_quantity');
932: END IF;

Line 930: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

926:
927: IF (g_asn_debug = 'Y') THEN
928: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
929: 'p_available_quantity : ' || p_available_quantity);
930: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
931: 'Leave get_wc_available_quantity');
932: END IF;
933: EXCEPTION
934: WHEN OTHERS THEN

Line 970: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

966: x_progress := 10;
967: l_api_name := 'rcv_shipment_lines_pkg.get_wc_available_amount';
968: x_progress := 20;
969: IF (g_asn_debug = 'Y') THEN
970: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
971: 'Enter get_wc_available_amount');
972: END IF;
973: x_progress := 30;
974: p_available_amount := 0;

Line 987: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

983: p_available_amount => x_available_amount,
984: p_tolerable_amount => x_tolerable_amount);
985:
986: IF (g_asn_debug = 'Y') THEN
987: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
988: 'transactions_id : ' || c_lines.transaction_id
989: || ' ,available_amount : ' || x_available_amount );
990: END IF;
991:

Line 998: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

994:
995: END LOOP;
996:
997: IF (g_asn_debug = 'Y') THEN
998: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
999: 'p_available_amount : ' || p_available_amount);
1000: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1001: 'Leave get_wc_available_amount');
1002: END IF;

Line 1000: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,

996:
997: IF (g_asn_debug = 'Y') THEN
998: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
999: 'p_available_amount : ' || p_available_amount);
1000: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
1001: 'Leave get_wc_available_amount');
1002: END IF;
1003: EXCEPTION
1004: WHEN OTHERS THEN