APPS.JAI_PO_OSP_PKG dependencies on JAI_CMN_UTILS_PKG

Line 128: jai_cmn_utils_pkg.print_log('b13541366.log','1 Inside ja_in_57F4_process_header begin ');

124: ----------------------------------------------------------------------------------------*/
125: /* Added by Ramananda for removal of SQL LITERALs */
126: lv_called_release := 'RELEASE';
127: lv_called_po := 'PO';
128: jai_cmn_utils_pkg.print_log('b13541366.log','1 Inside ja_in_57F4_process_header begin ');
129:
130: For c_Line_rec in
131: (Select distinct po_line_id
132: from po_distributions_all

Line 141: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','2 Inside for loop po lineid '||c_Line_rec.po_line_id||' called from '||p_called_from||' ');

137: ( p_called_from = lv_called_po) --'PO'
138: )
139: )
140: Loop
141: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','2 Inside for loop po lineid '||c_Line_rec.po_line_id||' called from '||p_called_from||' ');
142: ja_in_57f4_lines_insert
143: (
144: p_po_header_id ,
145: c_Line_rec.po_line_id ,

Line 398: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','3 Inside insert lines procedure '||' ');

394:
395:
396: BEGIN
397: ln_check_57f4_exists := 0;
398: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','3 Inside insert lines procedure '||' ');
399:
400: /* Added by Ramananda for removal of SQL LITERALs */
401: lv_called_release := 'RELEASE';
402: lv_called_po := 'PO';

Line 408: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','4 Inside insert lines ln_check_57f4_exists value '||ln_check_57f4_exists||' ');

404: open c_check_57f4_exists;
405: fetch c_check_57f4_exists into ln_check_57f4_exists;
406: close c_check_57f4_exists;
407:
408: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','4 Inside insert lines ln_check_57f4_exists value '||ln_check_57f4_exists||' ');
409:
410: ln_vendor := p_vendor_id;
411: ln_vendor_site := p_vendor_site_id;
412:

Line 453: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5 Inside for loop line id'||rec_po_line_cur.po_line_id||' ');

449: wip_entity_id, wip_operation_seq_num,
450: wip_repetitive_schedule_id, wip_line_id
451: )
452: Loop
453: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5 Inside for loop line id'||rec_po_line_cur.po_line_id||' ');
454:
455: open c_location_id;
456: fetch c_location_id into ln_location_id;
457: close c_location_id;

Line 480: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','6 ln_header '||ln_header||' ');

476:
477: IF ln_ja_ctr IS NULL THEN
478: ln_ja_ctr := 0;
479: END IF;
480: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','6 ln_header '||ln_header||' ');
481:
482: IF ln_header = 0 THEN
483: OPEN c_form_id;
484: FETCH c_form_id INTO ln_form_id;

Line 486: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','7 form id '||ln_form_id||' ');

482: IF ln_header = 0 THEN
483: OPEN c_form_id;
484: FETCH c_form_id INTO ln_form_id;
485: CLOSE c_form_id;
486: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','7 form id '||ln_form_id||' ');
487: ln_header_ins_flag := 1;
488: ELSIF ln_header > 0 THEN
489: OPEN c_header_id(c_po_dist.orgn_id, nvl(c_po_dist.loc_id,ln_location_id));
490: FETCH c_header_id INTO ln_form_id;

Line 492: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','8 form id '||ln_form_id||' ');

488: ELSIF ln_header > 0 THEN
489: OPEN c_header_id(c_po_dist.orgn_id, nvl(c_po_dist.loc_id,ln_location_id));
490: FETCH c_header_id INTO ln_form_id;
491: CLOSE c_header_id;
492: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','8 form id '||ln_form_id||' ');
493: ln_header_ins_flag := 0;
494: END IF;
495:
496: --commented the change of 9626826 for bug #13541366

Line 592: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','9 after insert into hdrs ');

588: sysdate -- added for bug 8303018
589: );
590:
591: end if;
592: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','9 after insert into hdrs ');
593:
594: For c_component_rec in
595: ( SELECT required_quantity ,quantity_per_assembly,inventory_item_id ,
596: component_sequence_id , 'W' item_type, comments

Line 621: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','10 inside lines cursor ');

617:
618: The query after the second union takes care of the manual BOM setup by the user.
619: */
620: Loop
621: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','10 inside lines cursor ');
622:
623: ln_line_id := 0;
624: open c_excise_flag(c_po_dist.orgn_id , c_component_rec.inventory_item_id);
625: fetch c_excise_flag into lv_Excise_flag , lv_tariff_code;

Line 629: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','11 lv_Excise_flag '||lv_Excise_flag||' ');

625: fetch c_excise_flag into lv_Excise_flag , lv_tariff_code;
626: close c_excise_flag;
627:
628: if nvl(lv_Excise_flag,'N') <> 'Y' then
629: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','11 lv_Excise_flag '||lv_Excise_flag||' ');
630: goto continue_with_next_item;
631: end if;
632:
633:

Line 651: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','12 ln_parent_item_id '||ln_parent_item_id||' ');

647: close c_parent_item_cur;
648: elsif c_component_rec.item_type in ('P', 'M') then
649: ln_parent_item_id := rec_po_line_cur.item_id;
650: end if;
651: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','12 ln_parent_item_id '||ln_parent_item_id||' ');
652:
653: open c_assembly_id_cur(c_po_dist.wip_entity_id);
654: fetch c_assembly_id_cur into ln_assembly_id;
655: close c_assembly_id_cur;

Line 724: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','13 ln_despatch_quantity '||ln_despatch_quantity||' ');

720: ln_original_quantity := ln_po_qty * c_component_rec.quantity_per_assembly;
721: ln_despatch_quantity := ln_po_qty * c_component_rec.quantity_per_assembly;
722: /*end bug 8220196*/
723: END IF; /* lv_source_code ='W' */ --1
724: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','13 ln_despatch_quantity '||ln_despatch_quantity||' ');
725:
726: INSERT INTO JAI_PO_OSP_LINES (
727: FORM_ID ,
728: LINE_ID ,

Line 830: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1.1 Cancel OSP ');

826:
827:
828: FOR i_rec in c_57f4_lines LOOP
829:
830: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1.1 Cancel OSP ');
831:
832: IF (nvl(i_rec.primary_flag,'N') = 'N' AND nvl(i_rec.form_number,0) <> 0 ) --added form number for 13541366
833: THEN
834:

Line 835: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1.2 Before Update ');

831:
832: IF (nvl(i_rec.primary_flag,'N') = 'N' AND nvl(i_rec.form_number,0) <> 0 ) --added form number for 13541366
833: THEN
834:
835: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1.2 Before Update ');
836:
837: UPDATE JAI_PO_OSP_LINES set dispatched_qty = dispatched_qty - i_rec.despatch_qty
838: where form_id = i_rec.primary_form_id
839: and item_id = i_rec.item_id

Line 844: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1.3 After Update '||SQL%ROWCOUNT);

840: and po_line_id = i_rec.po_line_id;
841:
842: END IF;
843:
844: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1.3 After Update '||SQL%ROWCOUNT);
845: END LOOP;
846:
847:
848: end cancel_osp;

Line 1511: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','12.1 vQtyRemaining(ii.item_id) :'||vQtyRemaining(ii.item_id)||' ii.original_qty :'

1507: vProQty := (ii.original_qty/ pPoQty) * pQtyToApply;
1508: vQtyRemaining(ii.item_id) := vProQty;
1509:
1510:
1511: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','12.1 vQtyRemaining(ii.item_id) :'||vQtyRemaining(ii.item_id)||' ii.original_qty :'
1512: ||ii.original_qty||' pPoQty :'||pPoQty||' pQtyToApply :'||pQtyToApply||' vProQty :'||vProQty||' pItemId :'||pItemId);
1513: ELSE
1514: vQtyRemaining(ii.item_id) := pQtyToApply;
1515: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','12.2 vQtyRemaining(ii.item_id)'||vQtyRemaining(ii.item_id) );

Line 1515: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','12.2 vQtyRemaining(ii.item_id)'||vQtyRemaining(ii.item_id) );

1511: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','12.1 vQtyRemaining(ii.item_id) :'||vQtyRemaining(ii.item_id)||' ii.original_qty :'
1512: ||ii.original_qty||' pPoQty :'||pPoQty||' pQtyToApply :'||pQtyToApply||' vProQty :'||vProQty||' pItemId :'||pItemId);
1513: ELSE
1514: vQtyRemaining(ii.item_id) := pQtyToApply;
1515: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','12.2 vQtyRemaining(ii.item_id)'||vQtyRemaining(ii.item_id) );
1516:
1517: END IF ;
1518:
1519: END LOOP;

Line 1523: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','30 vQtyRemaining(pItemId) '||vQtyRemaining(pItemId));

1519: END LOOP;
1520:
1521: ELSIF pEvent = 1 THEN
1522: vQtyRemaining(pItemId) := vQtyRemaining(pItemId) - pQtyToApply;
1523: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','30 vQtyRemaining(pItemId) '||vQtyRemaining(pItemId));
1524:
1525: ELSIF pEvent = 2 THEN
1526: vItemId := vQtyRemaining.FIRST;
1527: WHILE vItemId IS NOT NULL LOOP

Line 1528: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.1 vItemId :'||vItemId||' vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' pQtyToApply :'||pQtyToApply);

1524:
1525: ELSIF pEvent = 2 THEN
1526: vItemId := vQtyRemaining.FIRST;
1527: WHILE vItemId IS NOT NULL LOOP
1528: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.1 vItemId :'||vItemId||' vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' pQtyToApply :'||pQtyToApply);
1529: vQtyRemaining(vItemId) := vQtyRemaining(vItemId) - pQtyToApply;
1530: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.2 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);
1531: vItemId := vQtyRemaining.NEXT(vItemId);
1532: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vItemId :'||vItemId);

Line 1530: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.2 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);

1526: vItemId := vQtyRemaining.FIRST;
1527: WHILE vItemId IS NOT NULL LOOP
1528: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.1 vItemId :'||vItemId||' vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' pQtyToApply :'||pQtyToApply);
1529: vQtyRemaining(vItemId) := vQtyRemaining(vItemId) - pQtyToApply;
1530: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.2 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);
1531: vItemId := vQtyRemaining.NEXT(vItemId);
1532: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vItemId :'||vItemId);
1533: END LOOP;
1534: --jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vQtyRemaining(vItemId) '||vQtyRemaining(vItemId));

Line 1532: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vItemId :'||vItemId);

1528: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.1 vItemId :'||vItemId||' vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' pQtyToApply :'||pQtyToApply);
1529: vQtyRemaining(vItemId) := vQtyRemaining(vItemId) - pQtyToApply;
1530: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.2 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);
1531: vItemId := vQtyRemaining.NEXT(vItemId);
1532: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vItemId :'||vItemId);
1533: END LOOP;
1534: --jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vQtyRemaining(vItemId) '||vQtyRemaining(vItemId));
1535:
1536: ELSIF pEvent = 3 THEN

Line 1534: --jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vQtyRemaining(vItemId) '||vQtyRemaining(vItemId));

1530: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.2 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);
1531: vItemId := vQtyRemaining.NEXT(vItemId);
1532: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vItemId :'||vItemId);
1533: END LOOP;
1534: --jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vQtyRemaining(vItemId) '||vQtyRemaining(vItemId));
1535:
1536: ELSIF pEvent = 3 THEN
1537: vReturnValue := vQtyRemaining(pItemId);
1538: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','13 vReturnValue'||vReturnValue );

Line 1538: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','13 vReturnValue'||vReturnValue );

1534: --jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','28.3 vQtyRemaining(vItemId) '||vQtyRemaining(vItemId));
1535:
1536: ELSIF pEvent = 3 THEN
1537: vReturnValue := vQtyRemaining(pItemId);
1538: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','13 vReturnValue'||vReturnValue );
1539:
1540:
1541: ELSIF pEvent = 4 THEN
1542: vItemId := vQtyRemaining.FIRST;

Line 1553: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','35.1 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);

1549: ELSIF pEvent = 5 THEN
1550: vItemId := vQtyRemaining.FIRST;
1551: WHILE vItemId IS NOT NULL LOOP
1552: IF vQtyRemaining(vItemId) <> 0 THEN
1553: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','35.1 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);
1554: vReturnValue := -1;
1555: exit;
1556: else
1557: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','35.2 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);

Line 1557: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','35.2 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);

1553: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','35.1 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);
1554: vReturnValue := -1;
1555: exit;
1556: else
1557: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','35.2 vQtyRemaining(vItemId) :'||vQtyRemaining(vItemId)||' vItemId :'||vItemId);
1558: vReturnValue := 0;
1559: END IF;
1560: vItemId := vQtyRemaining.NEXT(vItemId);
1561: END LOOP;

Line 1643: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1 update receiving quantity ');

1639: v_loc_id := p_ship_to_location_id;
1640: v_return_qty := 0;
1641: v_form_fully_available := false;
1642: v_tran_type := p_tran_type;
1643: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1 update receiving quantity ');
1644:
1645: IF v_debug THEN
1646: jai_cmn_utils_pkg.print_log(v_utl_file_name,'*******START Time Stamp*******' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS')
1647: ||' Transaction Type is ' || v_tran_type

Line 1646: jai_cmn_utils_pkg.print_log(v_utl_file_name,'*******START Time Stamp*******' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS')

1642: v_tran_type := p_tran_type;
1643: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','1 update receiving quantity ');
1644:
1645: IF v_debug THEN
1646: jai_cmn_utils_pkg.print_log(v_utl_file_name,'*******START Time Stamp*******' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS')
1647: ||' Transaction Type is ' || v_tran_type
1648: );
1649: END IF;
1650:

Line 1652: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','2 v_received_qty '|| v_received_qty);

1648: );
1649: END IF;
1650:
1651: v_received_qty := p_rcv_tran_qty;
1652: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','2 v_received_qty '|| v_received_qty);
1653:
1654: -- 2746952
1655: IF p_rcv_tran_qty >= 0 THEN
1656: v_match_type := 1;

Line 1666: jai_cmn_utils_pkg.print_log(v_utl_file_name,'1 line_location_id -> '|| p_po_line_location_id

1662: FETCH c_get_rcv_trans INTO v_wip_entity_id;
1663: CLOSE c_get_rcv_trans;
1664:
1665: IF v_debug THEN
1666: jai_cmn_utils_pkg.print_log(v_utl_file_name,'1 line_location_id -> '|| p_po_line_location_id
1667: ||', v_wip_entity_id -> '|| v_wip_entity_id
1668: );
1669: END IF;
1670:

Line 1674: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','3 v_count_57f4 '|| v_count_57f4);

1670:
1671: OPEN c_count_primary_57f4;
1672: FETCH c_count_primary_57f4 INTO v_count_57f4;
1673: CLOSE c_count_primary_57f4;
1674: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','3 v_count_57f4 '|| v_count_57f4);
1675:
1676: IF v_debug THEN
1677: jai_cmn_utils_pkg.print_log(v_utl_file_name,'2 po_header_id -> '|| p_po_header_id
1678: ||', po_release_id -> '|| p_po_release_id ||', to_organization_id -> '|| p_to_organization_id

Line 1677: jai_cmn_utils_pkg.print_log(v_utl_file_name,'2 po_header_id -> '|| p_po_header_id

1673: CLOSE c_count_primary_57f4;
1674: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','3 v_count_57f4 '|| v_count_57f4);
1675:
1676: IF v_debug THEN
1677: jai_cmn_utils_pkg.print_log(v_utl_file_name,'2 po_header_id -> '|| p_po_header_id
1678: ||', po_release_id -> '|| p_po_release_id ||', to_organization_id -> '|| p_to_organization_id
1679: ||', ship_to_location_id -> '|| p_ship_to_location_id ||', v_count_57f4 -> '|| v_count_57f4
1680: ||', shipment_header_id -> '|| p_shipment_header_id ||', shipment_line_id -> '|| p_shipment_line_id
1681: ||', v_tran_type -> '|| v_tran_type ||', v_received_qty -> '|| v_received_qty

Line 1704: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','4 v_po_qty '|| v_po_qty );

1700:
1701: open c_po_qty_cur(p_po_header_id , p_po_line_id);
1702: fetch c_po_qty_cur into v_po_qty;
1703: close c_po_qty_cur;
1704: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','4 v_po_qty '|| v_po_qty );
1705:
1706: IF v_debug THEN
1707: jai_cmn_utils_pkg.print_log(v_utl_file_name,'3 v_primary_form_id -> '|| v_primary_form_id
1708: ||', v_received_qty -> '|| v_received_qty

Line 1707: jai_cmn_utils_pkg.print_log(v_utl_file_name,'3 v_primary_form_id -> '|| v_primary_form_id

1703: close c_po_qty_cur;
1704: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','4 v_po_qty '|| v_po_qty );
1705:
1706: IF v_debug THEN
1707: jai_cmn_utils_pkg.print_log(v_utl_file_name,'3 v_primary_form_id -> '|| v_primary_form_id
1708: ||', v_received_qty -> '|| v_received_qty
1709: ||', v_po_qty -> '|| v_po_qty
1710: );
1711: END IF;

Line 1716: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5 v_po_uom '|| v_po_uom );

1712:
1713: open c_po_uom;
1714: fetch c_po_uom into v_po_uom;
1715: close c_po_uom;
1716: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5 v_po_uom '|| v_po_uom );
1717:
1718: IF v_debug THEN
1719: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.122 v_po_uom -> '|| v_po_uom);
1720: END IF;

Line 1719: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.122 v_po_uom -> '|| v_po_uom);

1715: close c_po_uom;
1716: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5 v_po_uom '|| v_po_uom );
1717:
1718: IF v_debug THEN
1719: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.122 v_po_uom -> '|| v_po_uom);
1720: END IF;
1721:
1722: -- added for bug#3446045 - sriram
1723: if v_po_uom is null then

Line 1732: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.123 v_po_uom -> '|| v_po_uom);

1728:
1729: -- ends here additions for bug# 3446045
1730:
1731: IF v_debug THEN
1732: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.123 v_po_uom -> '|| v_po_uom);
1733: END IF;
1734: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.1 v_po_uom '|| v_po_uom );
1735:
1736: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.2 p_unit_of_measure '|| p_unit_of_measure);

Line 1734: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.1 v_po_uom '|| v_po_uom );

1730:
1731: IF v_debug THEN
1732: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.123 v_po_uom -> '|| v_po_uom);
1733: END IF;
1734: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.1 v_po_uom '|| v_po_uom );
1735:
1736: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.2 p_unit_of_measure '|| p_unit_of_measure);
1737:
1738: -- Determines the conversion factor between PO and RECEIPT uom's if they are different

Line 1736: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.2 p_unit_of_measure '|| p_unit_of_measure);

1732: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.123 v_po_uom -> '|| v_po_uom);
1733: END IF;
1734: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.1 v_po_uom '|| v_po_uom );
1735:
1736: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','5.2 p_unit_of_measure '|| p_unit_of_measure);
1737:
1738: -- Determines the conversion factor between PO and RECEIPT uom's if they are different
1739: if v_po_uom <> p_unit_of_measure then
1740:

Line 1746: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.124 v_po_uom -> '|| v_po_uom

1742: (p_item_id, NULL, NULL, NULL, NULL,
1743: p_unit_of_measure, v_po_uom);
1744:
1745: IF v_debug THEN
1746: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.124 v_po_uom -> '|| v_po_uom
1747: ||', p_unit_of_measure -> '|| p_unit_of_measure
1748: ||', v_po_to_rec_conv -> '|| nvl(v_po_to_rec_conv, -1275)
1749: );
1750: END IF;

Line 1759: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','7 v_po_to_rec_conv '|| v_po_to_rec_conv );

1755:
1756: ELSE
1757: v_po_to_rec_conv := 1;
1758: end if;
1759: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','7 v_po_to_rec_conv '|| v_po_to_rec_conv );
1760:
1761: -- this takes care if there is UOM Change beteen PO and RECEIPT
1762: v_received_qty := v_received_qty * v_po_to_rec_conv;
1763:

Line 1767: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','8 v_received_qty '|| v_received_qty||' v_original_rcvd_qty :'||v_original_rcvd_qty );

1763:
1764: v_left_received_qty := v_received_qty;
1765: v_original_rcvd_qty := v_received_qty;
1766:
1767: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','8 v_received_qty '|| v_received_qty||' v_original_rcvd_qty :'||v_original_rcvd_qty );
1768:
1769: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','9 v_left_received_qty '|| v_left_received_qty );
1770:
1771: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','10 v_primary_form_id '|| v_primary_form_id );

Line 1769: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','9 v_left_received_qty '|| v_left_received_qty );

1765: v_original_rcvd_qty := v_received_qty;
1766:
1767: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','8 v_received_qty '|| v_received_qty||' v_original_rcvd_qty :'||v_original_rcvd_qty );
1768:
1769: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','9 v_left_received_qty '|| v_left_received_qty );
1770:
1771: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','10 v_primary_form_id '|| v_primary_form_id );
1772:
1773: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','11 outside_operation_uom_type '|| r_get_po_item_details.outside_operation_uom_type );

Line 1771: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','10 v_primary_form_id '|| v_primary_form_id );

1767: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','8 v_received_qty '|| v_received_qty||' v_original_rcvd_qty :'||v_original_rcvd_qty );
1768:
1769: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','9 v_left_received_qty '|| v_left_received_qty );
1770:
1771: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','10 v_primary_form_id '|| v_primary_form_id );
1772:
1773: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','11 outside_operation_uom_type '|| r_get_po_item_details.outside_operation_uom_type );
1774: -- v_fun_ret_value :=
1775: -- Initialize PLSQL table, Vijay Shankar for Bug# 3644845

Line 1773: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','11 outside_operation_uom_type '|| r_get_po_item_details.outside_operation_uom_type );

1769: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','9 v_left_received_qty '|| v_left_received_qty );
1770:
1771: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','10 v_primary_form_id '|| v_primary_form_id );
1772:
1773: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','11 outside_operation_uom_type '|| r_get_po_item_details.outside_operation_uom_type );
1774: -- v_fun_ret_value :=
1775: -- Initialize PLSQL table, Vijay Shankar for Bug# 3644845
1776: v_fun_ret_value := processCompBalances(0,
1777: v_primary_form_id, v_received_qty

Line 1781: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','14 v_fun_ret_value '|| v_fun_ret_value );

1777: v_primary_form_id, v_received_qty
1778: -- Bug 7028169. Added by Lakshmi Gopalsami
1779: ,v_po_qty
1780: ,r_get_po_item_details.outside_operation_uom_type);
1781: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','14 v_fun_ret_value '|| v_fun_ret_value );
1782:
1783:
1784: FOR each_form IN
1785: (

Line 1805: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','15 Inside each line loop '||each_form.form_id||' each_line.item_id :'||each_line.item_id);

1801:
1802: vFormId_ToBeUpdWithRegDate := null;
1803:
1804: FOR each_line in c_get_lines(each_form.form_id) LOOP
1805: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','15 Inside each line loop '||each_form.form_id||' each_line.item_id :'||each_line.item_id);
1806:
1807: v_ret_fact := 1;
1808: /* Added for bug 14034669 *//*Start*/
1809:

Line 1814: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.2 v_pr_form_uom ' ||v_pr_form_uom||' each_line.item_uom : '||each_line.item_uom);

1810: OPEN c_pr_form_lines(v_primary_form_id);
1811: FETCH c_pr_form_lines INTO v_pr_form_uom, v_source_code;
1812: CLOSE c_pr_form_lines;
1813:
1814: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.2 v_pr_form_uom ' ||v_pr_form_uom||' each_line.item_uom : '||each_line.item_uom);
1815:
1816: v_pr_to_57f4_line_conv := 1;
1817:
1818: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.3 v_pr_to_57f4_line_conv ' ||v_pr_to_57f4_line_conv);

Line 1818: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.3 v_pr_to_57f4_line_conv ' ||v_pr_to_57f4_line_conv);

1814: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.2 v_pr_form_uom ' ||v_pr_form_uom||' each_line.item_uom : '||each_line.item_uom);
1815:
1816: v_pr_to_57f4_line_conv := 1;
1817:
1818: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.3 v_pr_to_57f4_line_conv ' ||v_pr_to_57f4_line_conv);
1819:
1820: IF v_pr_form_uom <> each_line.item_uom AND r_get_po_item_details.outside_operation_uom_type = 'RESOURCE'
1821: AND v_source_code ='W'
1822: THEN

Line 1827: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.4 v_pr_to_57f4_line_conv : ' ||v_pr_to_57f4_line_conv);

1823: /* v_pr_to_57f4_line_conv := INV_CONVERT.INV_UM_CONVERT
1824: (each_line.item_id, NULL, NULL, v_pr_form_uom, each_line.item_uom, -- Modified for bug #13541366
1825: null, null);
1826:
1827: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.4 v_pr_to_57f4_line_conv : ' ||v_pr_to_57f4_line_conv);
1828:
1829: v_received_qty := v_received_qty * v_pr_to_57f4_line_conv; */
1830:
1831: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.5 each_line.form_id : ' || each_line.form_id||' v_original_rcvd_qty :'||v_original_rcvd_qty);

Line 1831: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.5 each_line.form_id : ' || each_line.form_id||' v_original_rcvd_qty :'||v_original_rcvd_qty);

1827: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.4 v_pr_to_57f4_line_conv : ' ||v_pr_to_57f4_line_conv);
1828:
1829: v_received_qty := v_received_qty * v_pr_to_57f4_line_conv; */
1830:
1831: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.5 each_line.form_id : ' || each_line.form_id||' v_original_rcvd_qty :'||v_original_rcvd_qty);
1832:
1833: v_fun_ret_value := processCompBalances(0,
1834: each_line.form_id,
1835: v_original_rcvd_qty

Line 1839: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.6 v_fun_ret_value '|| v_fun_ret_value );

1835: v_original_rcvd_qty
1836: ,v_po_qty
1837: ,r_get_po_item_details.outside_operation_uom_type);
1838:
1839: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.6 v_fun_ret_value '|| v_fun_ret_value );
1840:
1841: END IF;
1842:
1843: v_pr_to_57f4_line_conv := 1;

Line 1853: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16 For RTV v_received_qty ' ||v_received_qty);

1849: v_received_qty := processCompBalances(4, null, null
1850: -- Bug 7028169. Added by Lakshmi Gopalsami
1851: ,v_po_qty
1852: ,r_get_po_item_details.outside_operation_uom_type);
1853: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16 For RTV v_received_qty ' ||v_received_qty);
1854:
1855:
1856: ELSE
1857: v_received_qty := processCompBalances(3, each_line.item_id,null

Line 1861: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.1 v_received_qty ' ||v_received_qty);

1857: v_received_qty := processCompBalances(3, each_line.item_id,null
1858: -- Bug 7028169. Added by Lakshmi Gopalsami
1859: ,v_po_qty
1860: ,r_get_po_item_details.outside_operation_uom_type);
1861: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','16.1 v_received_qty ' ||v_received_qty);
1862:
1863: END IF;
1864: --End, Vijay Shankar for Bug# 3644845
1865:

Line 1883: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','17.2 v_chk_uom ' ||v_chk_uom||' v_challan_uom :'||v_challan_uom);

1879: THEN
1880:
1881: v_challan_uom := v_chk_uom;
1882:
1883: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','17.2 v_chk_uom ' ||v_chk_uom||' v_challan_uom :'||v_challan_uom);
1884:
1885: ELSIF each_line.item_uom = v_item_pr_uom_code AND each_line.item_uom <> v_chk_uom
1886: THEN
1887:

Line 1890: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','17.3 v_chk_uom ' ||v_chk_uom||' v_challan_uom :'||v_challan_uom);

1886: THEN
1887:
1888: v_challan_uom := v_chk_uom;
1889:
1890: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','17.3 v_chk_uom ' ||v_chk_uom||' v_challan_uom :'||v_challan_uom);
1891: ELSE
1892:
1893: v_challan_uom := v_item_pr_uom_code;
1894:

Line 1895: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','17.4 v_chk_uom ' ||v_chk_uom||' v_challan_uom :'||v_challan_uom);

1891: ELSE
1892:
1893: v_challan_uom := v_item_pr_uom_code;
1894:
1895: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','17.4 v_chk_uom ' ||v_chk_uom||' v_challan_uom :'||v_challan_uom);
1896:
1897: END IF;
1898:
1899: /* Added for bug #13541366 *//*End*/

Line 1900: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','18 v_item_pr_uom_code ' ||v_item_pr_uom_code||' v_item_pr_uom '||v_item_pr_uom||' each_line.item_uom'||each_line.item_uom||' v_chk_uom :'||v_chk_uom);

1896:
1897: END IF;
1898:
1899: /* Added for bug #13541366 *//*End*/
1900: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','18 v_item_pr_uom_code ' ||v_item_pr_uom_code||' v_item_pr_uom '||v_item_pr_uom||' each_line.item_uom'||each_line.item_uom||' v_chk_uom :'||v_chk_uom);
1901:
1902: -- Determines the conversion factor between Component Primary UOM and 57F4 Line uom's if they are different
1903: if v_challan_uom <> each_line.item_uom then -- Modified for bug #13541366
1904:

Line 1911: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1x2 v_po_uom -> '|| v_po_uom

1907: null, null);
1908: -- p_unit_of_measure, v_to_uom);
1909:
1910: IF v_debug THEN
1911: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1x2 v_po_uom -> '|| v_po_uom
1912: ||', v_to_uom -> '|| v_to_uom
1913: ||', v_pr_to_57f4_line_conv -> '|| nvl(v_pr_to_57f4_line_conv, -1275)
1914: );
1915: END IF;

Line 1924: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21 v_pr_to_57f4_line_conv ' ||v_pr_to_57f4_line_conv);

1920:
1921: ELSE
1922: v_pr_to_57f4_line_conv := 1;
1923: end if;
1924: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21 v_pr_to_57f4_line_conv ' ||v_pr_to_57f4_line_conv);
1925:
1926: v_comp_qty_pa := each_line.comp_qty_pa * v_pr_to_57f4_line_conv;
1927: v_despatch_parent_qty := each_line.despatch_qty / v_comp_qty_pa ;
1928: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.1 v_comp_qty_pa ' ||v_comp_qty_pa||' v_despatch_parent_qty '||v_despatch_parent_qty);

Line 1928: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.1 v_comp_qty_pa ' ||v_comp_qty_pa||' v_despatch_parent_qty '||v_despatch_parent_qty);

1924: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21 v_pr_to_57f4_line_conv ' ||v_pr_to_57f4_line_conv);
1925:
1926: v_comp_qty_pa := each_line.comp_qty_pa * v_pr_to_57f4_line_conv;
1927: v_despatch_parent_qty := each_line.despatch_qty / v_comp_qty_pa ;
1928: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.1 v_comp_qty_pa ' ||v_comp_qty_pa||' v_despatch_parent_qty '||v_despatch_parent_qty);
1929:
1930: --converting the dipatch qty to return qty uom
1931: IF v_match_type = 1 THEN
1932: v_comp_balance_qty := (each_line.despatch_qty - NVL(each_line.return_qty,0)) / v_comp_qty_pa ;

Line 1933: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.2 v_comp_balance_qty ' ||v_comp_balance_qty);

1929:
1930: --converting the dipatch qty to return qty uom
1931: IF v_match_type = 1 THEN
1932: v_comp_balance_qty := (each_line.despatch_qty - NVL(each_line.return_qty,0)) / v_comp_qty_pa ;
1933: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.2 v_comp_balance_qty ' ||v_comp_balance_qty);
1934: ELSE
1935: v_comp_balance_qty := NVL(each_line.return_qty, 0) / v_comp_qty_pa ;
1936: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.3 v_comp_balance_qty ' ||v_comp_balance_qty);
1937: END IF;

Line 1936: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.3 v_comp_balance_qty ' ||v_comp_balance_qty);

1932: v_comp_balance_qty := (each_line.despatch_qty - NVL(each_line.return_qty,0)) / v_comp_qty_pa ;
1933: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.2 v_comp_balance_qty ' ||v_comp_balance_qty);
1934: ELSE
1935: v_comp_balance_qty := NVL(each_line.return_qty, 0) / v_comp_qty_pa ;
1936: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.3 v_comp_balance_qty ' ||v_comp_balance_qty);
1937: END IF;
1938:
1939: IF v_debug THEN
1940: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4 form_id -> '|| each_line.form_id

Line 1940: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4 form_id -> '|| each_line.form_id

1936: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.3 v_comp_balance_qty ' ||v_comp_balance_qty);
1937: END IF;
1938:
1939: IF v_debug THEN
1940: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4 form_id -> '|| each_line.form_id
1941: ||', line_id -> '|| each_line.line_id ||', parent_item_id -> '|| each_line.parent_item_id
1942: ||', item_id -> '|| each_line.item_id ||', bal_parent_item_qty -> '|| each_line.bal_parent_item_qty
1943: ||', comp_qty_pa -> '|| each_line.comp_qty_pa ||', despatch_qty -> '|| each_line.despatch_qty
1944: ||', return_qty -> '|| each_line.return_qty ||', item_uom -> '|| each_line.item_uom

Line 1946: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1.1 unit_of_measure -> '|| p_unit_of_measure

1942: ||', item_id -> '|| each_line.item_id ||', bal_parent_item_qty -> '|| each_line.bal_parent_item_qty
1943: ||', comp_qty_pa -> '|| each_line.comp_qty_pa ||', despatch_qty -> '|| each_line.despatch_qty
1944: ||', return_qty -> '|| each_line.return_qty ||', item_uom -> '|| each_line.item_uom
1945: );
1946: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1.1 unit_of_measure -> '|| p_unit_of_measure
1947: ||', primary_unit_of_measure -> '|| p_new_primary_unit_of_measure ||', item_id -> '|| p_item_id
1948: ||', v_temp_rcvd_qty -> '|| v_temp_rcvd_qty ||', v_received_qty -> '|| v_received_qty
1949: ||', bal_qty -> '|| each_line.balance_qty ||', des_par_itm_qty -> '|| each_line.despatch_parent_item_qty
1950: ||', bal_par_itm_qty -> '|| each_line.bal_parent_item_qty ||', v_match_type -> '|| v_match_type

Line 1953: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.4 v_comp_qty_pa -> '|| v_comp_qty_pa

1949: ||', bal_qty -> '|| each_line.balance_qty ||', des_par_itm_qty -> '|| each_line.despatch_parent_item_qty
1950: ||', bal_par_itm_qty -> '|| each_line.bal_parent_item_qty ||', v_match_type -> '|| v_match_type
1951:
1952: );
1953: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.4 v_comp_qty_pa -> '|| v_comp_qty_pa
1954: ||', v_despatch_parent_qty -> '|| v_despatch_parent_qty
1955: ||', v_comp_balance_qty -> '|| v_comp_balance_qty
1956: ||', v_pr_to_57f4_line_conv -> '|| v_pr_to_57f4_line_conv
1957: );

Line 1970: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.4 v_received_qty ' ||v_received_qty||' v_bal_qty : '||v_bal_qty);

1966:
1967:
1968:
1969: v_bal_qty := v_comp_balance_qty;
1970: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','21.4 v_received_qty ' ||v_received_qty||' v_bal_qty : '||v_bal_qty);
1971:
1972: IF v_match_type = 1 THEN -- this handles +ve quantity RECEIVE / CORRECTed through RCV_TRANSACTIONS base form
1973:
1974: IF v_bal_qty >= v_received_qty THEN

Line 1978: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','22 v_received_qty ' ||v_received_qty||' v_comp_qty_pa '||v_comp_qty_pa||' v_temp_qty '|| v_temp_qty||' v_left_received_qty '||v_left_received_qty);

1974: IF v_bal_qty >= v_received_qty THEN
1975: --temp qty which is assigned to return qty value is assigned with the return qty value after converion to return qty uom
1976: v_temp_qty := v_received_qty * v_comp_qty_pa;
1977: v_left_received_qty := 0;
1978: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','22 v_received_qty ' ||v_received_qty||' v_comp_qty_pa '||v_comp_qty_pa||' v_temp_qty '|| v_temp_qty||' v_left_received_qty '||v_left_received_qty);
1979:
1980: v_quantity_applied := v_received_qty * v_comp_qty_pa; --Added * v_comp_qty_pa for bug #13541366 -- Vijay Shankar for Bug# 3644845, full received quantity applied
1981: v_bal_qty := v_bal_qty - v_received_qty;
1982:

Line 1986: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','23 v_bal_qty ' ||v_bal_qty||' v_comp_qty_pa '||v_comp_qty_pa||' v_temp_qty '|| v_temp_qty||' v_left_received_qty '||v_left_received_qty);

1982:
1983: ELSE
1984: v_temp_qty := v_bal_qty * v_comp_qty_pa;
1985: v_left_received_qty := v_received_qty - v_bal_qty;
1986: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','23 v_bal_qty ' ||v_bal_qty||' v_comp_qty_pa '||v_comp_qty_pa||' v_temp_qty '|| v_temp_qty||' v_left_received_qty '||v_left_received_qty);
1987:
1988: v_quantity_applied := v_bal_qty * v_comp_qty_pa; --Added * v_comp_qty_pa for bug #13541366 -- Vijay Shankar for Bug# 3644845, quantity on 57F4 line is Complete. Should update next 57F4 line with remaining qty
1989: v_bal_qty := 0;
1990:

Line 2003: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','24 v_received_qty ' ||v_received_qty||' v_comp_qty_pa '||v_comp_qty_pa||' v_temp_qty '|| v_temp_qty);

1999:
2000: IF v_bal_qty > abs(v_received_qty) THEN
2001: v_temp_qty := v_received_qty * v_comp_qty_pa;
2002: v_left_received_qty := 0;
2003: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','24 v_received_qty ' ||v_received_qty||' v_comp_qty_pa '||v_comp_qty_pa||' v_temp_qty '|| v_temp_qty);
2004:
2005: v_quantity_applied := v_received_qty * v_comp_qty_pa; --Added * v_comp_qty_pa for bug #13541366 -- Vijay Shankar for Bug# 3644845, full received quantity applied
2006: v_bal_qty := v_bal_qty + v_received_qty;
2007: ELSE

Line 2010: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','25 v_bal_qty ' ||v_bal_qty||' v_comp_qty_pa '||v_comp_qty_pa||' v_temp_qty '|| v_temp_qty);

2006: v_bal_qty := v_bal_qty + v_received_qty;
2007: ELSE
2008: v_temp_qty := (v_bal_qty * v_match_type) * v_comp_qty_pa;
2009: v_left_received_qty := v_received_qty + v_bal_qty;
2010: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','25 v_bal_qty ' ||v_bal_qty||' v_comp_qty_pa '||v_comp_qty_pa||' v_temp_qty '|| v_temp_qty);
2011:
2012: v_quantity_applied := -v_bal_qty * v_comp_qty_pa; --Added * v_comp_qty_pa for bug #13541366 -- Vijay Shankar for Bug# 3644845, quantity on 57F4 line is Complete. Should update next 57F4 line with remaining qty
2013: v_bal_qty := v_despatch_parent_qty;
2014: END IF;

Line 2024: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','26 v_return_qty ' ||v_return_qty);

2020: v_form_fully_available := true;
2021: END IF;
2022:
2023: v_return_qty := v_temp_qty;
2024: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','26 v_return_qty ' ||v_return_qty);
2025:
2026: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','27 v_bal_qty -> '|| v_bal_qty
2027: ||', v_return_qty -> '|| v_temp_qty||', v_left_received_qty -> '
2028: || v_left_received_qty||',each_line.line_id -> '||each_line.line_id

Line 2026: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','27 v_bal_qty -> '|| v_bal_qty

2022:
2023: v_return_qty := v_temp_qty;
2024: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','26 v_return_qty ' ||v_return_qty);
2025:
2026: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','27 v_bal_qty -> '|| v_bal_qty
2027: ||', v_return_qty -> '|| v_temp_qty||', v_left_received_qty -> '
2028: || v_left_received_qty||',each_line.line_id -> '||each_line.line_id
2029: );
2030: --------

Line 2033: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.1 v_bal_qty -> '|| v_bal_qty

2029: );
2030: --------
2031:
2032: IF v_debug THEN
2033: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.1 v_bal_qty -> '|| v_bal_qty
2034: ||', v_return_qty -> '|| v_temp_qty||', v_left_received_qty -> '|| v_left_received_qty
2035: );
2036: END IF;
2037:

Line 2052: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','29 v_fun_ret_value ' ||v_fun_ret_value||' v_quantity_applied '||v_quantity_applied);

2048: v_fun_ret_value := processCompBalances(2, null, nvl(v_quantity_applied,0)
2049: -- Bug 7028169. Added by Lakshmi Gopalsami
2050: ,v_po_qty
2051: ,r_get_po_item_details.outside_operation_uom_type);
2052: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','29 v_fun_ret_value ' ||v_fun_ret_value||' v_quantity_applied '||v_quantity_applied);
2053: ELSE
2054: v_fun_ret_value := processCompBalances(1, each_line.item_id, nvl(v_quantity_applied,0)
2055: -- Bug 7028169. Added by Lakshmi Gopalsami
2056: ,v_po_qty

Line 2058: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','31 v_fun_ret_value ' ||v_fun_ret_value||' v_quantity_applied '||v_quantity_applied);

2054: v_fun_ret_value := processCompBalances(1, each_line.item_id, nvl(v_quantity_applied,0)
2055: -- Bug 7028169. Added by Lakshmi Gopalsami
2056: ,v_po_qty
2057: ,r_get_po_item_details.outside_operation_uom_type);
2058: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','31 v_fun_ret_value ' ||v_fun_ret_value||' v_quantity_applied '||v_quantity_applied);
2059: END IF;
2060: --End, Vijay Shankar for Bug# 3644845
2061:
2062: IF v_debug THEN

Line 2063: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.3 updatedCount -> '|| SQL%ROWCOUNT

2059: END IF;
2060: --End, Vijay Shankar for Bug# 3644845
2061:
2062: IF v_debug THEN
2063: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.3 updatedCount -> '|| SQL%ROWCOUNT
2064: ||', v_left_received_qty -> '|| v_left_received_qty
2065: );
2066: END IF;
2067:

Line 2068: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','31 v_quantity_applied: '||v_quantity_applied);

2064: ||', v_left_received_qty -> '|| v_left_received_qty
2065: );
2066: END IF;
2067:
2068: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','31 v_quantity_applied: '||v_quantity_applied);
2069:
2070: v_return_qty := 0;
2071: v_comp_qty_pa := null;
2072: v_despatch_parent_qty := null;

Line 2075: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','32 v_left_received_qty: ' || v_left_received_qty||' v_quantity_applied: '||v_quantity_applied);

2071: v_comp_qty_pa := null;
2072: v_despatch_parent_qty := null;
2073: v_comp_balance_qty := null;
2074: v_quantity_applied := null;
2075: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','32 v_left_received_qty: ' || v_left_received_qty||' v_quantity_applied: '||v_quantity_applied);
2076:
2077: vFormId_ToBeUpdWithRegDate := each_form.form_id;
2078: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','33 End of line loop');
2079:

Line 2078: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','33 End of line loop');

2074: v_quantity_applied := null;
2075: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','32 v_left_received_qty: ' || v_left_received_qty||' v_quantity_applied: '||v_quantity_applied);
2076:
2077: vFormId_ToBeUpdWithRegDate := each_form.form_id;
2078: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','33 End of line loop');
2079:
2080: END LOOP;
2081:
2082: -- following if condition will get satisfied when balance is available on form which got

Line 2096: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','34 After updating osp hdrs with date ');

2092: SET CR_REG_ENTRY_DATE = v_creation_date
2093: WHERE form_id = vFormId_ToBeUpdWithRegDate;
2094:
2095: END IF;
2096: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','34 After updating osp hdrs with date ');
2097:
2098: -- If condition added by Vijay Shankar for Bug# 3644845
2099: IF processCompBalances(5, null, null
2100: -- Bug 7028169. Added by Lakshmi Gopalsami

Line 2104: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','36 Remaining qty is 0, comp balances 5 ');

2100: -- Bug 7028169. Added by Lakshmi Gopalsami
2101: ,v_po_qty
2102: ,r_get_po_item_details.outside_operation_uom_type) = 0 THEN
2103: -- control comes here if all the received quantity is applied onto 57F4 forms
2104: jai_cmn_utils_pkg.write_fnd_log_msg('b13541366.log','36 Remaining qty is 0, comp balances 5 ');
2105: EXIT;
2106: END IF;
2107:
2108: /* Vijay Shankar for Bug# 3644845