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 1698: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */

1694:
1695: l_shipment_count NUMBER;
1696: l_return_status VARCHAR2(1);
1697: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/
1698: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */
1699: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */
1700: BEGIN
1701: IF (g_fnd_debug = 'Y') THEN
1702: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1845: INTO l_dual_uom_ind,l_secondary_default_ind

1841: p_chg.shipment_changes.get_count = 0) THEN
1842:
1843: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1844: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1845: INTO l_dual_uom_ind,l_secondary_default_ind
1846: FROM mtl_system_items_b msi,
1847: financials_system_parameters fsp
1848: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1849: AND msi.organization_id = fsp.inventory_organization_id;

Line 1851: l_dual_uom_ind := 'P';

1847: financials_system_parameters fsp
1848: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1849: AND msi.organization_id = fsp.inventory_organization_id;
1850: ELSE
1851: l_dual_uom_ind := 'P';
1852: END IF;
1853:
1854: IF (l_dual_uom_ind = 'P') THEN
1855: add_error ( p_api_errors => g_api_errors,

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

1850: ELSE
1851: l_dual_uom_ind := 'P';
1852: END IF;
1853:
1854: IF (l_dual_uom_ind = 'P') THEN
1855: add_error ( p_api_errors => g_api_errors,
1856: x_return_status => x_return_status,
1857: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',
1858: p_table_name => 'PO_LINES_ALL',

Line 1857: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',

1853:
1854: IF (l_dual_uom_ind = 'P') THEN
1855: add_error ( p_api_errors => g_api_errors,
1856: x_return_status => x_return_status,
1857: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',
1858: p_table_name => 'PO_LINES_ALL',
1859: p_column_name => 'SECONDARY_QUANTITY',
1860: p_entity_type => G_ENTITY_TYPE_LINES,
1861: p_entity_id => i );

Line 1868: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',

1864: ELSIF (l_secondary_default_ind = 'F') THEN
1865: PO_DOCUMENT_UPDATE_PVT.add_error (
1866: p_api_errors => g_api_errors,
1867: x_return_status => l_return_status,
1868: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',
1869: p_token_name1 => 'PQTY',
1870: p_token_value1 => p_chg.shipment_changes.c_quantity(i),
1871: p_token_name2 => 'SQTY',
1872: p_token_value2 => p_chg.line_changes.secondary_quantity(i));

Line 1885: INTO l_dual_uom_ind,l_secondary_default_ind

1881: p_chg.shipment_changes.get_count = 0) THEN
1882:
1883: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1884: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1885: INTO l_dual_uom_ind,l_secondary_default_ind
1886: FROM mtl_system_items_b msi,
1887: financials_system_parameters fsp
1888: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1889: AND msi.organization_id = fsp.inventory_organization_id;

Line 1891: l_dual_uom_ind := 'P';

1887: financials_system_parameters fsp
1888: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1889: AND msi.organization_id = fsp.inventory_organization_id;
1890: ELSE
1891: l_dual_uom_ind := 'P';
1892: END IF;
1893:
1894: IF (l_dual_uom_ind = 'P') THEN
1895: add_error ( p_api_errors => g_api_errors,

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

1890: ELSE
1891: l_dual_uom_ind := 'P';
1892: END IF;
1893:
1894: IF (l_dual_uom_ind = 'P') THEN
1895: add_error ( p_api_errors => g_api_errors,
1896: x_return_status => x_return_status,
1897: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',
1898: p_table_name => 'PO_LINES_ALL',

Line 1897: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',

1893:
1894: IF (l_dual_uom_ind = 'P') THEN
1895: add_error ( p_api_errors => g_api_errors,
1896: x_return_status => x_return_status,
1897: p_message_name => 'PO_CHNG_NON_DUAL_ITEM',
1898: p_table_name => 'PO_LINES_ALL',
1899: p_column_name => 'SECONDARY_QUANTITY',
1900: p_entity_type => G_ENTITY_TYPE_LINES,
1901: p_entity_id => i );

Line 3033: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;

3029:
3030:
3031: l_return_status VARCHAR2(1);
3032: /* INVCONV sschinch 09/07/04 */
3033: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
3034: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE ; --INVCONV sschinch
3035: l_secondary_qty PO_LINE_LOCATIONS.quantity%TYPE;
3036: l_fsp_org_id NUMBER;
3037: x_count NUMBER;

Line 3472: INTO l_dual_um_ind,l_secondary_default_ind,l_new_sec_uom

3468: l_new_qty IS NULL ) THEN
3469:
3470: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3471: SELECT msi.tracking_quantity_ind,secondary_default_ind,secondary_uom_code
3472: INTO l_dual_um_ind,l_secondary_default_ind,l_new_sec_uom
3473: FROM mtl_system_items_b msi
3474: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3475: AND msi.organization_id = l_fsp_org_id;
3476: ELSE

Line 3477: l_dual_um_ind := 'P';

3473: FROM mtl_system_items_b msi
3474: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3475: AND msi.organization_id = l_fsp_org_id;
3476: ELSE
3477: l_dual_um_ind := 'P';
3478: END IF;
3479:
3480: IF (l_dual_um_ind = 'PS' AND l_secondary_default_ind <> 'F') THEN
3481: SELECT muom.unit_of_measure

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

3476: ELSE
3477: l_dual_um_ind := 'P';
3478: END IF;
3479:
3480: IF (l_dual_um_ind = 'PS' AND l_secondary_default_ind <> 'F') THEN
3481: SELECT muom.unit_of_measure
3482: INTO l_new_sec_uom
3483: FROM mtl_units_of_measure muom
3484: WHERE uom_code = l_new_sec_uom;

Line 3555: INTO l_dual_um_ind,l_secondary_default_ind

3551: ELSIF (l_new_qty IS NOT NULL) AND (l_cur_uom2 IS NOT NULL) THEN
3552:
3553: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3554: SELECT msi.tracking_quantity_ind,secondary_default_ind
3555: INTO l_dual_um_ind,l_secondary_default_ind
3556: FROM mtl_system_items_b msi
3557: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3558: AND msi.organization_id = l_fsp_org_id;
3559: ELSE

Line 3560: l_dual_um_ind := 'P';

3556: FROM mtl_system_items_b msi
3557: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3558: AND msi.organization_id = l_fsp_org_id;
3559: ELSE
3560: l_dual_um_ind := 'P';
3561: END IF;
3562:
3563: -- Check if item and FSP org combination is dual uom control.
3564: IF (l_dual_um_ind = 'P') THEN

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

3559: ELSE
3560: l_dual_um_ind := 'P';
3561: END IF;
3562:
3563: -- Check if item and FSP org combination is dual uom control.
3564: IF (l_dual_um_ind = 'P') THEN
3565: p_chg.line_changes.secondary_quantity(i) := NULL;
3566: ELSIF (l_dual_um_ind = 'PS') THEN
3567: IF (p_chg.line_changes.secondary_quantity(i) IS NOT NULL) THEN

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

3560: l_dual_um_ind := 'P';
3561: END IF;
3562:
3563: -- Check if item and FSP org combination is dual uom control.
3564: IF (l_dual_um_ind = 'P') THEN
3565: p_chg.line_changes.secondary_quantity(i) := NULL;
3566: ELSIF (l_dual_um_ind = 'PS') THEN
3567: IF (p_chg.line_changes.secondary_quantity(i) IS NOT NULL) THEN
3568: l_return_status := inv_convert.within_deviation(

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

3562:
3563: -- Check if item and FSP org combination is dual uom control.
3564: IF (l_dual_um_ind = 'P') THEN
3565: p_chg.line_changes.secondary_quantity(i) := NULL;
3566: ELSIF (l_dual_um_ind = 'PS') THEN
3567: IF (p_chg.line_changes.secondary_quantity(i) IS NOT NULL) THEN
3568: l_return_status := inv_convert.within_deviation(
3569: p_organization_id => l_fsp_org_id,
3570: p_inventory_item_id => p_chg.line_changes.c_item_id(i),

Line 3641: INTO l_dual_um_ind,l_secondary_default_ind

3637: l_fsp_org_id := p_chg.shipment_changes.c_ship_to_organization_id(i);
3638:
3639: IF p_chg.shipment_changes.c_item_id(i) IS NOT NULL THEN
3640: SELECT msi.tracking_quantity_ind,secondary_default_ind
3641: INTO l_dual_um_ind,l_secondary_default_ind
3642: FROM mtl_system_items_b msi
3643: WHERE msi.inventory_item_id = p_chg.shipment_changes.c_item_id(i)
3644: AND msi.organization_id = l_fsp_org_id;
3645: ELSE

Line 3686: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',

3682: l_secondary_default_ind = 'F') THEN
3683: PO_DOCUMENT_UPDATE_PVT.add_error (
3684: p_api_errors => g_api_errors,
3685: x_return_status => l_return_status,
3686: p_message_name => 'PO_DUALFIXED_NO_CONVERSION',
3687: p_token_name1 => 'PQTY',
3688: p_token_value1 => p_chg.shipment_changes.c_quantity(i),
3689: p_token_name2 => 'SQTY',
3690: p_token_value2 => l_new_secondary_qty);

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

3690: p_token_value2 => l_new_secondary_qty);
3691: x_return_status := FND_API.G_RET_STS_ERROR;
3692: RETURN;
3693: END IF;
3694: /** If item is dual uom control and quantity is specified and secondary qty is not specified
3695: then derive the secondary quantity **/
3696:
3697: /*
3698: PO_UOM_S.uom_convert(l_new_qty, l_document_uom,

Line 7123: FROM dual;

7119: IF (l_parent_line_loc_id IS NOT NULL) THEN -- This is a split shipment.
7120: -- Generate a new LINE_LOCATION_ID from the sequence.
7121: SELECT PO_LINE_LOCATIONS_S.nextval
7122: INTO l_line_location_id
7123: FROM dual;
7124:
7125: -- Update the split shipment change with the new LINE_LOCATION_ID.
7126: p_chg.shipment_changes.po_line_location_id(l_ship_chg_i)
7127: := l_line_location_id;

Line 7532: FROM dual;

7528:
7529: -- Generate a new PO_DISTRIBUTION_ID from the sequence.
7530: SELECT PO_DISTRIBUTIONS_S.nextval
7531: INTO l_po_distribution_id
7532: FROM dual;
7533:
7534: -- Update the split distribution change with the new PO_DISTRIBUTION_ID.
7535: p_chg.distribution_changes.po_distribution_id(l_dist_chg_i)
7536: := l_po_distribution_id;