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.PO_DOCUMENT_UPDATE_PVT dependencies on DUAL

Line 1721: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */

1717:
1718: l_shipment_count NUMBER;
1719: l_return_status VARCHAR2(1);
1720: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/
1721: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */
1722: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */
1723: BEGIN
1724: IF (g_fnd_debug = 'Y') THEN
1725: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1868: INTO l_dual_uom_ind,l_secondary_default_ind

1864: p_chg.shipment_changes.get_count = 0) THEN
1865:
1866: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1867: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1868: INTO l_dual_uom_ind,l_secondary_default_ind
1869: FROM mtl_system_items_b msi,
1870: financials_system_parameters fsp
1871: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1872: AND msi.organization_id = fsp.inventory_organization_id;

Line 1874: l_dual_uom_ind := 'P';

1870: financials_system_parameters fsp
1871: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1872: AND msi.organization_id = fsp.inventory_organization_id;
1873: ELSE
1874: l_dual_uom_ind := 'P';
1875: END IF;
1876:
1877: IF (l_dual_uom_ind = 'P') THEN
1878: add_error ( p_api_errors => g_api_errors,

Line 1877: IF (l_dual_uom_ind = 'P') THEN

1873: ELSE
1874: l_dual_uom_ind := 'P';
1875: END IF;
1876:
1877: IF (l_dual_uom_ind = 'P') THEN
1878: add_error ( p_api_errors => g_api_errors,
1879: x_return_status => x_return_status,
1880: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',
1881: p_table_name => 'PO_LINES_ALL',

Line 1880: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',

1876:
1877: IF (l_dual_uom_ind = 'P') THEN
1878: add_error ( p_api_errors => g_api_errors,
1879: x_return_status => x_return_status,
1880: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',
1881: p_table_name => 'PO_LINES_ALL',
1882: p_column_name => 'SECONDARY_QUANTITY',
1883: p_entity_type => G_ENTITY_TYPE_LINES,
1884: p_entity_id => i );

Line 1891: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',

1887: ELSIF (l_secondary_default_ind = 'F') THEN
1888: PO_DOCUMENT_UPDATE_PVT.add_error (
1889: p_api_errors => g_api_errors,
1890: x_return_status => l_return_status,
1891: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',
1892: p_token_name1 => 'PQTY',
1893: p_token_value1 => p_chg.shipment_changes.c_quantity(i),
1894: p_token_name2 => 'SQTY',
1895: p_token_value2 => p_chg.line_changes.secondary_quantity(i));

Line 1908: INTO l_dual_uom_ind,l_secondary_default_ind

1904: p_chg.shipment_changes.get_count = 0) THEN
1905:
1906: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1907: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1908: INTO l_dual_uom_ind,l_secondary_default_ind
1909: FROM mtl_system_items_b msi,
1910: financials_system_parameters fsp
1911: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1912: AND msi.organization_id = fsp.inventory_organization_id;

Line 1914: l_dual_uom_ind := 'P';

1910: financials_system_parameters fsp
1911: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1912: AND msi.organization_id = fsp.inventory_organization_id;
1913: ELSE
1914: l_dual_uom_ind := 'P';
1915: END IF;
1916:
1917: IF (l_dual_uom_ind = 'P') THEN
1918: add_error ( p_api_errors => g_api_errors,

Line 1917: IF (l_dual_uom_ind = 'P') THEN

1913: ELSE
1914: l_dual_uom_ind := 'P';
1915: END IF;
1916:
1917: IF (l_dual_uom_ind = 'P') THEN
1918: add_error ( p_api_errors => g_api_errors,
1919: x_return_status => x_return_status,
1920: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',
1921: p_table_name => 'PO_LINES_ALL',

Line 1920: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',

1916:
1917: IF (l_dual_uom_ind = 'P') THEN
1918: add_error ( p_api_errors => g_api_errors,
1919: x_return_status => x_return_status,
1920: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',
1921: p_table_name => 'PO_LINES_ALL',
1922: p_column_name => 'SECONDARY_QUANTITY',
1923: p_entity_type => G_ENTITY_TYPE_LINES,
1924: p_entity_id => i );

Line 3056: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;

3052:
3053:
3054: l_return_status VARCHAR2(1);
3055: /* INVCONV sschinch 09/07/04 */
3056: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
3057: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE ; --INVCONV sschinch
3058: l_secondary_qty PO_LINE_LOCATIONS.quantity%TYPE;
3059: l_fsp_org_id NUMBER;
3060: x_count NUMBER;

Line 3495: INTO l_dual_um_ind,l_secondary_default_ind,l_new_sec_uom

3491: l_new_qty IS NULL ) THEN
3492:
3493: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3494: SELECT msi.tracking_quantity_ind,secondary_default_ind,secondary_uom_code
3495: INTO l_dual_um_ind,l_secondary_default_ind,l_new_sec_uom
3496: FROM mtl_system_items_b msi
3497: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3498: AND msi.organization_id = l_fsp_org_id;
3499: ELSE

Line 3500: l_dual_um_ind := 'P';

3496: FROM mtl_system_items_b msi
3497: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3498: AND msi.organization_id = l_fsp_org_id;
3499: ELSE
3500: l_dual_um_ind := 'P';
3501: END IF;
3502:
3503: IF (l_dual_um_ind = 'PS' AND l_secondary_default_ind <> 'F') THEN
3504: SELECT muom.unit_of_measure

Line 3503: IF (l_dual_um_ind = 'PS' AND l_secondary_default_ind <> 'F') THEN

3499: ELSE
3500: l_dual_um_ind := 'P';
3501: END IF;
3502:
3503: IF (l_dual_um_ind = 'PS' AND l_secondary_default_ind <> 'F') THEN
3504: SELECT muom.unit_of_measure
3505: INTO l_new_sec_uom
3506: FROM mtl_units_of_measure muom
3507: WHERE uom_code = l_new_sec_uom;

Line 3577: INTO l_dual_um_ind,l_secondary_default_ind

3573: ELSIF (l_new_qty IS NOT NULL) AND (l_cur_uom2 IS NOT NULL) THEN
3574:
3575: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3576: SELECT msi.tracking_quantity_ind,secondary_default_ind
3577: INTO l_dual_um_ind,l_secondary_default_ind
3578: FROM mtl_system_items_b msi
3579: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3580: AND msi.organization_id = l_fsp_org_id;
3581: ELSE

Line 3582: l_dual_um_ind := 'P';

3578: FROM mtl_system_items_b msi
3579: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3580: AND msi.organization_id = l_fsp_org_id;
3581: ELSE
3582: l_dual_um_ind := 'P';
3583: END IF;
3584:
3585: -- Check if item and FSP org combination is dual uom control.
3586: IF (l_dual_um_ind = 'P') THEN

Line 3585: -- Check if item and FSP org combination is dual uom control.

3581: ELSE
3582: l_dual_um_ind := 'P';
3583: END IF;
3584:
3585: -- Check if item and FSP org combination is dual uom control.
3586: IF (l_dual_um_ind = 'P') THEN
3587: p_chg.line_changes.secondary_quantity(i) := NULL;
3588: ELSIF (l_dual_um_ind = 'PS') THEN
3589: IF (p_chg.line_changes.secondary_quantity(i) IS NOT NULL) THEN

Line 3586: IF (l_dual_um_ind = 'P') THEN

3582: l_dual_um_ind := 'P';
3583: END IF;
3584:
3585: -- Check if item and FSP org combination is dual uom control.
3586: IF (l_dual_um_ind = 'P') THEN
3587: p_chg.line_changes.secondary_quantity(i) := NULL;
3588: ELSIF (l_dual_um_ind = 'PS') THEN
3589: IF (p_chg.line_changes.secondary_quantity(i) IS NOT NULL) THEN
3590: l_return_status := inv_convert.within_deviation(

Line 3588: ELSIF (l_dual_um_ind = 'PS') THEN

3584:
3585: -- Check if item and FSP org combination is dual uom control.
3586: IF (l_dual_um_ind = 'P') THEN
3587: p_chg.line_changes.secondary_quantity(i) := NULL;
3588: ELSIF (l_dual_um_ind = 'PS') THEN
3589: IF (p_chg.line_changes.secondary_quantity(i) IS NOT NULL) THEN
3590: l_return_status := inv_convert.within_deviation(
3591: p_organization_id => l_fsp_org_id,
3592: p_inventory_item_id => p_chg.line_changes.c_item_id(i),

Line 3678: INTO l_dual_um_ind,l_secondary_default_ind

3674: l_fsp_org_id := p_chg.shipment_changes.c_ship_to_organization_id(i);
3675:
3676: IF p_chg.shipment_changes.c_item_id(i) IS NOT NULL THEN
3677: SELECT msi.tracking_quantity_ind,secondary_default_ind
3678: INTO l_dual_um_ind,l_secondary_default_ind
3679: FROM mtl_system_items_b msi
3680: WHERE msi.inventory_item_id = p_chg.shipment_changes.c_item_id(i)
3681: AND msi.organization_id = l_fsp_org_id;
3682: ELSE

Line 3723: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',

3719: l_secondary_default_ind = 'F') THEN
3720: PO_DOCUMENT_UPDATE_PVT.add_error (
3721: p_api_errors => g_api_errors,
3722: x_return_status => l_return_status,
3723: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',
3724: p_token_name1 => 'PQTY',
3725: p_token_value1 => p_chg.shipment_changes.c_quantity(i),
3726: p_token_name2 => 'SQTY',
3727: p_token_value2 => l_new_secondary_qty);

Line 3731: /** If item is dual uom control and quantity is specified and secondary qty is not specified

3727: p_token_value2 => l_new_secondary_qty);
3728: x_return_status := FND_API.G_RET_STS_ERROR;
3729: RETURN;
3730: END IF;
3731: /** If item is dual uom control and quantity is specified and secondary qty is not specified
3732: then derive the secondary quantity **/
3733:
3734: /*
3735: PO_UOM_S.uom_convert(l_new_qty, l_document_uom,

Line 7235: FROM dual;

7231: IF (l_parent_line_loc_id IS NOT NULL) THEN -- This is a split shipment.
7232: -- Generate a new LINE_LOCATION_ID from the sequence.
7233: SELECT PO_LINE_LOCATIONS_S.nextval
7234: INTO l_line_location_id
7235: FROM dual;
7236:
7237: -- Update the split shipment change with the new LINE_LOCATION_ID.
7238: p_chg.shipment_changes.po_line_location_id(l_ship_chg_i)
7239: := l_line_location_id;

Line 7644: FROM dual;

7640:
7641: -- Generate a new PO_DISTRIBUTION_ID from the sequence.
7642: SELECT PO_DISTRIBUTIONS_S.nextval
7643: INTO l_po_distribution_id
7644: FROM dual;
7645:
7646: -- Update the split distribution change with the new PO_DISTRIBUTION_ID.
7647: p_chg.distribution_changes.po_distribution_id(l_dist_chg_i)
7648: := l_po_distribution_id;