DBA Data[Home] [Help]

APPS.JAI_PO_OSP_PKG dependencies on JAI_CMN_UTILS_PKG

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

1476: v_form_fully_available := false;
1477: v_tran_type := p_tran_type;
1478:
1479: IF v_debug THEN
1480: jai_cmn_utils_pkg.print_log(v_utl_file_name,'*******START Time Stamp*******' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS')
1481: ||' Transaction Type is ' || v_tran_type
1482: );
1483: END IF;
1484:

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

1495: FETCH c_get_rcv_trans INTO v_wip_entity_id;
1496: CLOSE c_get_rcv_trans;
1497:
1498: IF v_debug THEN
1499: jai_cmn_utils_pkg.print_log(v_utl_file_name,'1 line_location_id -> '|| p_po_line_location_id
1500: ||', v_wip_entity_id -> '|| v_wip_entity_id
1501: );
1502: END IF;
1503:

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

1505: FETCH c_count_primary_57f4 INTO v_count_57f4;
1506: CLOSE c_count_primary_57f4;
1507:
1508: IF v_debug THEN
1509: jai_cmn_utils_pkg.print_log(v_utl_file_name,'2 po_header_id -> '|| p_po_header_id
1510: ||', po_release_id -> '|| p_po_release_id ||', to_organization_id -> '|| p_to_organization_id
1511: ||', ship_to_location_id -> '|| p_ship_to_location_id ||', v_count_57f4 -> '|| v_count_57f4
1512: ||', shipment_header_id -> '|| p_shipment_header_id ||', shipment_line_id -> '|| p_shipment_line_id
1513: ||', v_tran_type -> '|| v_tran_type ||', v_received_qty -> '|| v_received_qty

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

1534: fetch c_po_qty_cur into v_po_qty;
1535: close c_po_qty_cur;
1536:
1537: IF v_debug THEN
1538: jai_cmn_utils_pkg.print_log(v_utl_file_name,'3 v_primary_form_id -> '|| v_primary_form_id
1539: ||', v_received_qty -> '|| v_received_qty
1540: ||', v_po_qty -> '|| v_po_qty
1541: );
1542: END IF;

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

1545: fetch c_po_uom into v_po_uom;
1546: close c_po_uom;
1547:
1548: IF v_debug THEN
1549: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.122 v_po_uom -> '|| v_po_uom);
1550: END IF;
1551:
1552: -- added for bug#3446045 - sriram
1553: if v_po_uom is null then

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

1558:
1559: -- ends here additions for bug# 3446045
1560:
1561: IF v_debug THEN
1562: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.123 v_po_uom -> '|| v_po_uom);
1563: END IF;
1564:
1565: -- Determines the conversion factor between PO and RECEIPT uom's if they are different
1566: if v_po_uom <> p_unit_of_measure then

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

1569: (p_item_id, NULL, NULL, NULL, NULL,
1570: p_unit_of_measure, v_po_uom);
1571:
1572: IF v_debug THEN
1573: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.124 v_po_uom -> '|| v_po_uom
1574: ||', p_unit_of_measure -> '|| p_unit_of_measure
1575: ||', v_po_to_rec_conv -> '|| nvl(v_po_to_rec_conv, -1275)
1576: );
1577: END IF;

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

1648: null, null);
1649: -- p_unit_of_measure, v_to_uom);
1650:
1651: IF v_debug THEN
1652: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1x2 v_po_uom -> '|| v_po_uom
1653: ||', v_to_uom -> '|| v_to_uom
1654: ||', v_pr_to_57f4_line_conv -> '|| nvl(v_pr_to_57f4_line_conv, -1275)
1655: );
1656: END IF;

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

1671: v_comp_balance_qty := NVL(each_line.return_qty, 0) / v_comp_qty_pa ;
1672: END IF;
1673:
1674: IF v_debug THEN
1675: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4 form_id -> '|| each_line.form_id
1676: ||', line_id -> '|| each_line.line_id ||', parent_item_id -> '|| each_line.parent_item_id
1677: ||', item_id -> '|| each_line.item_id ||', bal_parent_item_qty -> '|| each_line.bal_parent_item_qty
1678: ||', comp_qty_pa -> '|| each_line.comp_qty_pa ||', despatch_qty -> '|| each_line.despatch_qty
1679: ||', return_qty -> '|| each_line.return_qty ||', item_uom -> '|| each_line.item_uom

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

1677: ||', item_id -> '|| each_line.item_id ||', bal_parent_item_qty -> '|| each_line.bal_parent_item_qty
1678: ||', comp_qty_pa -> '|| each_line.comp_qty_pa ||', despatch_qty -> '|| each_line.despatch_qty
1679: ||', return_qty -> '|| each_line.return_qty ||', item_uom -> '|| each_line.item_uom
1680: );
1681: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.1.1 unit_of_measure -> '|| p_unit_of_measure
1682: ||', primary_unit_of_measure -> '|| p_new_primary_unit_of_measure ||', item_id -> '|| p_item_id
1683: ||', v_temp_rcvd_qty -> '|| v_temp_rcvd_qty ||', v_received_qty -> '|| v_received_qty
1684: ||', bal_qty -> '|| each_line.balance_qty ||', des_par_itm_qty -> '|| each_line.despatch_parent_item_qty
1685: ||', bal_par_itm_qty -> '|| each_line.bal_parent_item_qty ||', v_match_type -> '|| v_match_type

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

1684: ||', bal_qty -> '|| each_line.balance_qty ||', des_par_itm_qty -> '|| each_line.despatch_parent_item_qty
1685: ||', bal_par_itm_qty -> '|| each_line.bal_parent_item_qty ||', v_match_type -> '|| v_match_type
1686:
1687: );
1688: jai_cmn_utils_pkg.print_log(v_utl_file_name,'4.4 v_comp_qty_pa -> '|| v_comp_qty_pa
1689: ||', v_despatch_parent_qty -> '|| v_despatch_parent_qty
1690: ||', v_comp_balance_qty -> '|| v_comp_balance_qty
1691: ||', v_pr_to_57f4_line_conv -> '|| v_pr_to_57f4_line_conv
1692: );

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

1744: v_return_qty := v_temp_qty;
1745: --------
1746:
1747: IF v_debug THEN
1748: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.1 v_bal_qty -> '|| v_bal_qty
1749: ||', v_return_qty -> '|| v_temp_qty||', v_left_received_qty -> '|| v_left_received_qty
1750: );
1751: END IF;
1752:

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

1772: END IF;
1773: --End, Vijay Shankar for Bug# 3644845
1774:
1775: IF v_debug THEN
1776: jai_cmn_utils_pkg.print_log(v_utl_file_name,'5.3 updatedCount -> '|| SQL%ROWCOUNT
1777: ||', v_left_received_qty -> '|| v_left_received_qty
1778: );
1779: END IF;
1780: