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.INV_CONSIGNED_VALIDATIONS dependencies on FND_API

Line 88: x_return_status:= fnd_api.g_ret_sts_success;

84: IF (l_debug = 1) THEN
85: inv_log_util.trace('In Query_VMI_Consigned','CONSIGNED_VALIDATIONS',9);
86: END IF;
87:
88: x_return_status:= fnd_api.g_ret_sts_success;
89:
90: -- invConv changes begin
91: -- Validations : DUOM item
92: OPEN get_item_info( p_organization_id, p_inventory_item_id);

Line 131: x_return_status:= fnd_api.g_ret_sts_success;

127: x_sqoh := NULL;
128: END IF;
129: -- invConv changes end
130:
131: x_return_status:= fnd_api.g_ret_sts_success;
132: RETURN;
133: END IF;
134:
135: -- compute level

Line 321: RAISE fnd_api.g_exc_unexpected_error;

317: ELSE
318: x_sqoh := NULL;
319: END IF;
320: -- invConv changes end
321: RAISE fnd_api.g_exc_unexpected_error;
322: END query_vmi_consigned;
323:
324:
325: -------------------------------------------------------------------------------

Line 353: -- 1. fnd_api.g_ret_sts_success for success --

349: -- --
350: -- Output Parameters --
351: -- x_return_status --
352: -- standard output parameter. Possible values are --
353: -- 1. fnd_api.g_ret_sts_success for success --
354: -- 2. fnd_api.g_ret_sts_exc_error for expected error --
355: -- 3. fnd_api.g_ret_sts_unexp_error for unexpected error --
356: -------------------------------------------------------------------------------
357:

Line 354: -- 2. fnd_api.g_ret_sts_exc_error for expected error --

350: -- Output Parameters --
351: -- x_return_status --
352: -- standard output parameter. Possible values are --
353: -- 1. fnd_api.g_ret_sts_success for success --
354: -- 2. fnd_api.g_ret_sts_exc_error for expected error --
355: -- 3. fnd_api.g_ret_sts_unexp_error for unexpected error --
356: -------------------------------------------------------------------------------
357:
358:

Line 355: -- 3. fnd_api.g_ret_sts_unexp_error for unexpected error --

351: -- x_return_status --
352: -- standard output parameter. Possible values are --
353: -- 1. fnd_api.g_ret_sts_success for success --
354: -- 2. fnd_api.g_ret_sts_exc_error for expected error --
355: -- 3. fnd_api.g_ret_sts_unexp_error for unexpected error --
356: -------------------------------------------------------------------------------
357:
358:
359: PROCEDURE build_sql

Line 373: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

369: , p_is_revision_control IN BOOLEAN
370: ) IS
371:
372:
373: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
374: --
375: l_stmt long;
376: l_asset_sub_where long;
377: l_revision_select long;

Line 840: x_return_status := fnd_api.g_ret_sts_unexp_error;

836:
837:
838: EXCEPTION
839: WHEN OTHERS THEN
840: x_return_status := fnd_api.g_ret_sts_unexp_error;
841: IF (l_debug = 1) THEN
842: inv_log_util.trace('When Others Ex. in build sql','CONSIGNED_VALIDATIONS',9);
843: END IF;
844: END build_sql;

Line 868: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

864: , p_pick_release IN NUMBER
865: , x_cursor OUT NOCOPY NUMBER
866: , p_is_revision_control IN BOOLEAN
867: ) IS
868: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
869: l_cursor NUMBER;
870: l_sql LONG;
871: l_last_error_pos NUMBER;
872: l_temp_str VARCHAR2(30);

Line 894: IF l_return_status <> fnd_api.g_ret_sts_success THEN

890: , p_pick_release => p_pick_release
891: , x_sql_statement => l_sql
892: , p_is_revision_control => p_is_revision_control);
893:
894: IF l_return_status <> fnd_api.g_ret_sts_success THEN
895: RAISE fnd_api.g_exc_unexpected_error;
896: END IF;
897:
898:

Line 895: RAISE fnd_api.g_exc_unexpected_error;

891: , x_sql_statement => l_sql
892: , p_is_revision_control => p_is_revision_control);
893:
894: IF l_return_status <> fnd_api.g_ret_sts_success THEN
895: RAISE fnd_api.g_exc_unexpected_error;
896: END IF;
897:
898:
899: BEGIN

Line 934: x_return_status := fnd_api.g_ret_sts_unexp_error ;

930: x_return_status := l_return_status;
931:
932: EXCEPTION
933: WHEN OTHERS THEN
934: x_return_status := fnd_api.g_ret_sts_unexp_error ;
935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
936: THEN
937: fnd_msg_pub.add_exc_msg
938: ( g_pkg_name

Line 1053: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1049: , p_pick_release => 0
1050: , x_cursor => l_cursor
1051: );
1052:
1053: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1054: l_return_status:= fnd_api.g_ret_sts_error;
1055: RAISE fnd_api.g_exc_unexpected_error;
1056: END IF;
1057:

Line 1054: l_return_status:= fnd_api.g_ret_sts_error;

1050: , x_cursor => l_cursor
1051: );
1052:
1053: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1054: l_return_status:= fnd_api.g_ret_sts_error;
1055: RAISE fnd_api.g_exc_unexpected_error;
1056: END IF;
1057:
1058:

Line 1055: RAISE fnd_api.g_exc_unexpected_error;

1051: );
1052:
1053: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1054: l_return_status:= fnd_api.g_ret_sts_error;
1055: RAISE fnd_api.g_exc_unexpected_error;
1056: END IF;
1057:
1058:
1059:

Line 1174: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1170: , p_organization_id IN VARCHAR2
1171: , p_subinventory_code IN VARCHAR2
1172: , x_is_reservable_sub OUT NOCOPY BOOLEAN
1173: ) IS
1174: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1175: l_reservable_type NUMBER;
1176: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1177: BEGIN
1178: SELECT reservable_type INTO l_reservable_type

Line 1193: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1189:
1190: EXCEPTION
1191:
1192: WHEN OTHERS THEN
1193: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1194: IF (l_debug = 1) THEN
1195: inv_log_util.trace('check_is_reservable_sub','CONSIGNED_VALIDATIONS',9);
1196: END IF;
1197:

Line 1218: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1214: , p_lot_number IN VARCHAR2
1215: , x_is_reservable OUT NOCOPY BOOLEAN
1216: ) IS
1217:
1218: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1219: l_reservable_type NUMBER;
1220:
1221: CURSOR is_RSV_subInv( org_id IN NUMBER
1222: , subinv IN VARCHAR2) IS

Line 1332: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1328: WHEN OTHERS THEN
1329: IF (l_debug = 1) THEN
1330: inv_log_util.trace('in check_is_reservable, OTHERS Error='||SQLERRM, 'CONSIGNED_VALIDATIONS',9);
1331: END IF;
1332: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1333:
1334: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1335: THEN
1336: fnd_msg_pub.add_exc_msg

Line 1504: x_return_status:= fnd_api.g_ret_sts_success;

1500: debug_print(' OnhandSource, CstGroupID, QueryMode: '|| p_onhand_source || ','||
1501: p_cost_group_id ||',' ||p_query_mode,'CONSIGNED_VALIDATIONS',9);
1502: END IF;
1503:
1504: x_return_status:= fnd_api.g_ret_sts_success;
1505:
1506: IF p_tree_mode IS NULL THEN
1507: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
1508: ELSE l_tree_mode := p_tree_mode;

Line 1517: RAISE fnd_api.g_exc_error;

1513: IF p_source_type_id IS NULL THEN
1514: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');
1515: fnd_msg_pub.ADD;
1516: x_return_msg := fnd_message.get;
1517: RAISE fnd_api.g_exc_error;
1518: END IF;
1519:
1520: IF p_demand_source_header_id IS NULL THEN
1521: IF p_demand_source_name IS NULL THEN

Line 1525: RAISE fnd_api.g_exc_error;

1521: IF p_demand_source_name IS NULL THEN
1522: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
1523: fnd_msg_pub.ADD;
1524: x_return_msg := fnd_message.get;
1525: RAISE fnd_api.g_exc_error;
1526: END IF;
1527: END IF;
1528:
1529: IF p_demand_source_header_id IS NULL

Line 1534: RAISE fnd_api.g_exc_error;

1530: AND p_demand_source_line_id IS NOT NULL THEN
1531: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
1532: fnd_msg_pub.ADD;
1533: x_return_msg := fnd_message.get;
1534: RAISE fnd_api.g_exc_error;
1535: END IF;
1536: END IF;
1537:
1538: IF (Upper(p_is_revision_control) = 'TRUE') OR (Upper(p_is_revision_control)=fnd_api.g_true) THEN

Line 1538: IF (Upper(p_is_revision_control) = 'TRUE') OR (Upper(p_is_revision_control)=fnd_api.g_true) THEN

1534: RAISE fnd_api.g_exc_error;
1535: END IF;
1536: END IF;
1537:
1538: IF (Upper(p_is_revision_control) = 'TRUE') OR (Upper(p_is_revision_control)=fnd_api.g_true) THEN
1539: l_is_revision_control := TRUE;
1540: END IF;
1541:
1542: IF (Upper(p_is_lot_control) = 'TRUE') OR (Upper(p_is_lot_control)=fnd_api.g_true) THEN

Line 1542: IF (Upper(p_is_lot_control) = 'TRUE') OR (Upper(p_is_lot_control)=fnd_api.g_true) THEN

1538: IF (Upper(p_is_revision_control) = 'TRUE') OR (Upper(p_is_revision_control)=fnd_api.g_true) THEN
1539: l_is_revision_control := TRUE;
1540: END IF;
1541:
1542: IF (Upper(p_is_lot_control) = 'TRUE') OR (Upper(p_is_lot_control)=fnd_api.g_true) THEN
1543: l_is_lot_control := TRUE;
1544: END IF;
1545:
1546: IF (Upper(p_is_serial_control) = 'TRUE') OR (Upper(p_is_serial_control) = fnd_api.g_true) THEN

Line 1546: IF (Upper(p_is_serial_control) = 'TRUE') OR (Upper(p_is_serial_control) = fnd_api.g_true) THEN

1542: IF (Upper(p_is_lot_control) = 'TRUE') OR (Upper(p_is_lot_control)=fnd_api.g_true) THEN
1543: l_is_lot_control := TRUE;
1544: END IF;
1545:
1546: IF (Upper(p_is_serial_control) = 'TRUE') OR (Upper(p_is_serial_control) = fnd_api.g_true) THEN
1547: l_is_serial_control := TRUE;
1548: END IF;
1549:
1550: /* Validate input parameters */

Line 1555: RAISE fnd_api.g_exc_unexpected_error;

1551: IF (p_inventory_item_id IS NULL) THEN
1552: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
1553: fnd_msg_pub.ADD;
1554: x_return_msg := fnd_message.get;
1555: RAISE fnd_api.g_exc_unexpected_error;
1556: END IF ;
1557:
1558: IF (p_query_mode = G_TXN_MODE) THEN
1559: IF (p_owning_org_id IS NULL AND p_planning_org_id IS NULL) THEN

Line 1563: RAISE fnd_api.g_exc_unexpected_error;

1559: IF (p_owning_org_id IS NULL AND p_planning_org_id IS NULL) THEN
1560: fnd_message.set_name('INV', 'INV_OWN_PLAN_ORG_REQUIRED');
1561: fnd_msg_pub.ADD;
1562: x_return_msg := fnd_message.get;
1563: RAISE fnd_api.g_exc_unexpected_error;
1564: END IF ;
1565: ELSIF (p_query_mode = G_REG_MODE) THEN
1566: IF (p_owning_org_id IS NULL) THEN
1567: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');

Line 1570: RAISE fnd_api.g_exc_unexpected_error;

1566: IF (p_owning_org_id IS NULL) THEN
1567: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');
1568: fnd_msg_pub.ADD;
1569: x_return_msg := fnd_message.get;
1570: RAISE fnd_api.g_exc_unexpected_error;
1571: END IF ;
1572: END IF;
1573:
1574: IF (l_debug = 1) THEN

Line 1645: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1641: , p_qty_tree_att => x_att
1642: , p_qty_tree_satt => x_satt -- invConv change
1643: , x_return_status => x_return_status) ;
1644:
1645: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1646: IF (l_debug = 1) THEN
1647: inv_log_util.trace('populate consigned temp Failed','CONSIGNED_VALIDATIONS',9);
1648: END IF;
1649: RAISE fnd_api.g_exc_unexpected_error;

Line 1649: RAISE fnd_api.g_exc_unexpected_error;

1645: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1646: IF (l_debug = 1) THEN
1647: inv_log_util.trace('populate consigned temp Failed','CONSIGNED_VALIDATIONS',9);
1648: END IF;
1649: RAISE fnd_api.g_exc_unexpected_error;
1650: END IF;
1651: END IF;
1652:
1653: IF (l_debug = 1) THEN

Line 1679: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1675: , x_qoh => l_vcoh
1676: , x_sqoh => l_svcoh -- invConv change
1677: );
1678:
1679: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1680: IF (l_debug = 1) THEN
1681: inv_log_util.trace('CONSIGNED_VMI table query Failed'||l_msg_data,'CONSIGNED_VALIDATIONS',9);
1682: END IF;
1683: RAISE fnd_api.g_exc_unexpected_error;

Line 1683: RAISE fnd_api.g_exc_unexpected_error;

1679: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1680: IF (l_debug = 1) THEN
1681: inv_log_util.trace('CONSIGNED_VMI table query Failed'||l_msg_data,'CONSIGNED_VALIDATIONS',9);
1682: END IF;
1683: RAISE fnd_api.g_exc_unexpected_error;
1684: END IF;
1685:
1686: IF (l_debug = 1) THEN
1687: inv_log_util.trace('Got l_vcoh='||l_vcoh,'CONSIGNED_VALIDATIONS',9);

Line 1700: , p_init_msg_lst => fnd_api.g_false

1696: inv_log_util.trace('Transaction Mode, calling quantity tree','CONSIGNED_VALIDATIONS',9);
1697: END IF;
1698: inv_quantity_tree_pub.query_quantities(
1699: p_api_version_number => 1.0
1700: , p_init_msg_lst => fnd_api.g_false
1701: , x_return_status => x_return_status
1702: , x_msg_count => l_msg_count
1703: , x_msg_data => l_msg_data
1704: , p_organization_id => p_organization_id

Line 1736: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1732: , x_satr => l_satr -- invConv change
1733: );
1734:
1735: -- If the qty tree returns and error raise an exception.
1736: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1737: IF (l_debug = 1) THEN
1738: inv_log_util.trace('Qty Tree Failed'||l_msg_data,'CONSIGNED_VALIDATIONS',9);
1739: END IF;
1740: x_return_msg:= l_msg_data;

Line 1741: RAISE fnd_api.g_exc_unexpected_error;

1737: IF (l_debug = 1) THEN
1738: inv_log_util.trace('Qty Tree Failed'||l_msg_data,'CONSIGNED_VALIDATIONS',9);
1739: END IF;
1740: x_return_msg:= l_msg_data;
1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;
1743:
1744: IF (l_debug = 1) THEN
1745: debug_print('Called qty tree, l_qoh='||l_qoh||', sqoh='||l_sqoh||',l_att='||l_att||', satt='||l_satt,'CONSIGNED_VALIDATIONS',9);

Line 1770: x_return_status:= fnd_api.g_ret_sts_success;

1766: END IF;
1767:
1768: END IF;
1769:
1770: x_return_status:= fnd_api.g_ret_sts_success;
1771: debug_print('Normal end of get_consigned_quantity2.');
1772:
1773: EXCEPTION
1774: when others THEN

Line 1778: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

1774: when others THEN
1775: IF (l_debug = 1) THEN
1776: inv_log_util.trace('When others Exception in get_consigned_quantity','CONSIGNED_VALIDATIONS',9);
1777: END IF;
1778: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1779: RETURN;
1780: END get_consigned_quantity;
1781:
1782:

Line 1824: x_return_status := fnd_api.g_ret_sts_success;

1820: -- l_new_att_vmi NUMBER; -- not used
1821: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1822: BEGIN
1823:
1824: x_return_status := fnd_api.g_ret_sts_success;
1825:
1826:
1827: IF (p_inventory_item_id IS NULL) THEN
1828: fnd_message.set_name('INV', 'INV_INT_ITMCODE');

Line 1832: RAISE fnd_api.g_exc_unexpected_error;

1828: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
1829: fnd_msg_pub.ADD;
1830: x_msg_data := fnd_message.get;
1831: x_return_status :='E';
1832: RAISE fnd_api.g_exc_unexpected_error;
1833: END IF ;
1834: IF (p_organization_id IS NULL) THEN
1835: fnd_message.set_name('INV', 'INV-NO ORG INFORMATION');
1836: fnd_msg_pub.ADD;

Line 1839: RAISE fnd_api.g_exc_unexpected_error;

1835: fnd_message.set_name('INV', 'INV-NO ORG INFORMATION');
1836: fnd_msg_pub.ADD;
1837: x_msg_data := fnd_message.get;
1838: x_return_status :='E';
1839: RAISE fnd_api.g_exc_unexpected_error;
1840: END IF ;
1841:
1842: -- We assume that this API is only invoked for VMI related transactions.
1843:

Line 1852: RAISE fnd_api.g_exc_unexpected_error;

1848: fnd_message.set_name('INV', 'INV-WRONG_LEVEL');
1849: fnd_msg_pub.ADD;
1850: x_msg_data := fnd_message.get;
1851: x_return_status :='E';
1852: RAISE fnd_api.g_exc_unexpected_error;
1853: END IF ;
1854:
1855:
1856: -- need to find out whether the sub is reservable or not

Line 1893: IF x_return_status = fnd_api.g_ret_sts_error THEN

1889: END IF;
1890: END IF;
1891: -- invConv changes end.
1892:
1893: IF x_return_status = fnd_api.g_ret_sts_error THEN
1894: RAISE fnd_api.g_exc_error;
1895: End IF ;
1896: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1897: RAISE fnd_api.g_exc_unexpected_error;

Line 1894: RAISE fnd_api.g_exc_error;

1890: END IF;
1891: -- invConv changes end.
1892:
1893: IF x_return_status = fnd_api.g_ret_sts_error THEN
1894: RAISE fnd_api.g_exc_error;
1895: End IF ;
1896: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1897: RAISE fnd_api.g_exc_unexpected_error;
1898: End IF;

Line 1896: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1892:
1893: IF x_return_status = fnd_api.g_ret_sts_error THEN
1894: RAISE fnd_api.g_exc_error;
1895: End IF ;
1896: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1897: RAISE fnd_api.g_exc_unexpected_error;
1898: End IF;
1899:
1900: -- invConv change : replaced l_is_reservable_sub by b_reservable

Line 1897: RAISE fnd_api.g_exc_unexpected_error;

1893: IF x_return_status = fnd_api.g_ret_sts_error THEN
1894: RAISE fnd_api.g_exc_error;
1895: End IF ;
1896: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1897: RAISE fnd_api.g_exc_unexpected_error;
1898: End IF;
1899:
1900: -- invConv change : replaced l_is_reservable_sub by b_reservable
1901: -- IF (l_is_reservable_sub) THEN

Line 1952: x_return_status := fnd_api.g_ret_sts_success;

1948: p_containerized,
1949: p_planning_organization_id,
1950: p_owning_organization_id);
1951:
1952: x_return_status := fnd_api.g_ret_sts_success;
1953:
1954: EXCEPTION
1955:
1956: WHEN OTHERS THEN

Line 1957: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1953:
1954: EXCEPTION
1955:
1956: WHEN OTHERS THEN
1957: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1958: IF (l_debug = 1) THEN
1959: inv_log_util.trace('Ex in update_vmi_quantities','CONSIGNED_VALIDATIONS',9);
1960: END IF;
1961:

Line 1988: x_return_status := fnd_api.g_ret_sts_success;

1984: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1985: l_weight NUMBER;
1986: BEGIN
1987:
1988: x_return_status := fnd_api.g_ret_sts_success;
1989:
1990: SELECT decode(consume_consigned_flag,'Y',1,0), decode(consume_vmi_flag,'Y',1,0),weight
1991: INTO x_consume_consigned, x_consume_vmi,l_weight from
1992: (SELECT nvl(consume_consigned_flag,'N') consume_consigned_flag, nvl(consume_vmi_flag,'N') consume_vmi_flag,weight

Line 2015: x_return_status := fnd_api.g_ret_sts_success;

2011: EXCEPTION
2012: WHEN no_data_found THEN
2013: x_consume_consigned := 0;
2014: x_consume_vmi := 0;
2015: x_return_status := fnd_api.g_ret_sts_success;
2016: WHEN others THEN
2017: x_return_status := fnd_api.G_RET_STS_ERROR;
2018: END check_consume;
2019:

Line 2017: x_return_status := fnd_api.G_RET_STS_ERROR;

2013: x_consume_consigned := 0;
2014: x_consume_vmi := 0;
2015: x_return_status := fnd_api.g_ret_sts_success;
2016: WHEN others THEN
2017: x_return_status := fnd_api.G_RET_STS_ERROR;
2018: END check_consume;
2019:
2020:
2021: --VALUE RETURNED:

Line 3638: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

3634: , p_is_revision_control IN BOOLEAN
3635: ) IS
3636:
3637:
3638: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3639: --
3640: l_stmt long;
3641: l_asset_sub_where long;
3642: l_revision_select long;

Line 3809: x_return_status := fnd_api.g_ret_sts_unexp_error;

3805:
3806:
3807: EXCEPTION
3808: WHEN OTHERS THEN
3809: x_return_status := fnd_api.g_ret_sts_unexp_error;
3810: IF (l_debug = 1) THEN
3811: inv_log_util.trace('When Others Ex. in build_lpn_sql','CONSIGNED_VALIDATIONS',9);
3812: END IF;
3813: END build_lpn_sql;

Line 3833: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

3829: , p_lpn_id IN NUMBER
3830: , x_cursor OUT NOCOPY NUMBER
3831: , p_is_revision_control IN BOOLEAN
3832: ) IS
3833: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3834: l_cursor NUMBER;
3835: l_sql LONG;
3836: l_last_error_pos NUMBER;
3837: l_temp_str VARCHAR2(30);

Line 3858: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3854: p_pick_release,
3855: l_sql,
3856: p_is_revision_control);
3857:
3858: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3859: RAISE fnd_api.g_exc_unexpected_error;
3860: END IF;
3861:
3862: BEGIN

Line 3859: RAISE fnd_api.g_exc_unexpected_error;

3855: l_sql,
3856: p_is_revision_control);
3857:
3858: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3859: RAISE fnd_api.g_exc_unexpected_error;
3860: END IF;
3861:
3862: BEGIN
3863: dbms_sql.parse(l_cursor,l_sql,dbms_sql.v7);

Line 3887: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3883: x_return_status := l_return_status;
3884:
3885: EXCEPTION
3886: WHEN OTHERS THEN
3887: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3888: IF (l_debug = 1) THEN
3889: inv_log_util.trace('When Others Ex. in build_lpn_cursor','CONSIGNED_VALIDATIONS',9);
3890: END IF;
3891:

Line 3976: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3972: , p_lpn_id => p_lpn_id
3973: , x_cursor => l_cursor
3974: );
3975:
3976: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3977: l_return_status:= fnd_api.g_ret_sts_error;
3978: RAISE fnd_api.g_exc_unexpected_error;
3979: END IF;
3980:

Line 3977: l_return_status:= fnd_api.g_ret_sts_error;

3973: , x_cursor => l_cursor
3974: );
3975:
3976: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3977: l_return_status:= fnd_api.g_ret_sts_error;
3978: RAISE fnd_api.g_exc_unexpected_error;
3979: END IF;
3980:
3981: dbms_sql.define_column(l_cursor,1,l_organization_id);

Line 3978: RAISE fnd_api.g_exc_unexpected_error;

3974: );
3975:
3976: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3977: l_return_status:= fnd_api.g_ret_sts_error;
3978: RAISE fnd_api.g_exc_unexpected_error;
3979: END IF;
3980:
3981: dbms_sql.define_column(l_cursor,1,l_organization_id);
3982: dbms_sql.define_column(l_cursor,2,l_inventory_item_id);

Line 4139: x_return_status:= fnd_api.g_ret_sts_success;

4135: inv_log_util.trace(' OnhandSource, CstGroupID, QueryMode: '|| p_onhand_source || ','||
4136: p_cost_group_id ||',' ||p_query_mode||',p_lpn_id :'||p_lpn_id,'CONSIGNED_VALIDATIONS',9);
4137: END IF;
4138:
4139: x_return_status:= fnd_api.g_ret_sts_success;
4140:
4141: l_tree_mode := p_tree_mode;
4142:
4143: -- validate demand source info

Line 4149: RAISE fnd_api.g_exc_error;

4145: IF p_source_type_id IS NULL THEN
4146: fnd_message.set_name('INV', 'INV-MISSING DEMAND SOURCE TYPE');
4147: fnd_msg_pub.ADD;
4148: x_return_msg := fnd_message.get;
4149: RAISE fnd_api.g_exc_error;
4150: END IF;
4151:
4152: IF p_demand_source_header_id IS NULL THEN
4153: IF p_demand_source_name IS NULL THEN

Line 4157: RAISE fnd_api.g_exc_error;

4153: IF p_demand_source_name IS NULL THEN
4154: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
4155: fnd_msg_pub.ADD;
4156: x_return_msg := fnd_message.get;
4157: RAISE fnd_api.g_exc_error;
4158: END IF;
4159: END IF;
4160:
4161: IF p_demand_source_header_id IS NULL

Line 4166: RAISE fnd_api.g_exc_error;

4162: AND p_demand_source_line_id IS NOT NULL THEN
4163: fnd_message.set_name('INV', 'INV-MISSING DEMAND SRC HEADER');
4164: fnd_msg_pub.ADD;
4165: x_return_msg := fnd_message.get;
4166: RAISE fnd_api.g_exc_error;
4167: END IF;
4168: END IF;
4169:
4170: IF (Upper(p_is_revision_control) = 'TRUE') OR (Upper(p_is_revision_control)=fnd_api.g_true) THEN

Line 4170: IF (Upper(p_is_revision_control) = 'TRUE') OR (Upper(p_is_revision_control)=fnd_api.g_true) THEN

4166: RAISE fnd_api.g_exc_error;
4167: END IF;
4168: END IF;
4169:
4170: IF (Upper(p_is_revision_control) = 'TRUE') OR (Upper(p_is_revision_control)=fnd_api.g_true) THEN
4171: l_is_revision_control := TRUE;
4172: END IF;
4173:
4174: IF (Upper(p_is_lot_control) = 'TRUE') OR (Upper(p_is_lot_control)=fnd_api.g_true) THEN

Line 4174: IF (Upper(p_is_lot_control) = 'TRUE') OR (Upper(p_is_lot_control)=fnd_api.g_true) THEN

4170: IF (Upper(p_is_revision_control) = 'TRUE') OR (Upper(p_is_revision_control)=fnd_api.g_true) THEN
4171: l_is_revision_control := TRUE;
4172: END IF;
4173:
4174: IF (Upper(p_is_lot_control) = 'TRUE') OR (Upper(p_is_lot_control)=fnd_api.g_true) THEN
4175: l_is_lot_control := TRUE;
4176: END IF;
4177:
4178: IF (Upper(p_is_serial_control) = 'TRUE') OR (Upper(p_is_serial_control) = fnd_api.g_true) THEN

Line 4178: IF (Upper(p_is_serial_control) = 'TRUE') OR (Upper(p_is_serial_control) = fnd_api.g_true) THEN

4174: IF (Upper(p_is_lot_control) = 'TRUE') OR (Upper(p_is_lot_control)=fnd_api.g_true) THEN
4175: l_is_lot_control := TRUE;
4176: END IF;
4177:
4178: IF (Upper(p_is_serial_control) = 'TRUE') OR (Upper(p_is_serial_control) = fnd_api.g_true) THEN
4179: l_is_serial_control := TRUE;
4180: END IF;
4181:
4182: /* Validate input parameters */

Line 4187: RAISE fnd_api.g_exc_unexpected_error;

4183: IF (p_inventory_item_id IS NULL) THEN
4184: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
4185: fnd_msg_pub.ADD;
4186: x_return_msg := fnd_message.get;
4187: RAISE fnd_api.g_exc_unexpected_error;
4188: END IF ;
4189:
4190: IF (p_query_mode = G_TXN_MODE) THEN
4191: IF (p_owning_org_id IS NULL AND p_planning_org_id IS NULL) THEN

Line 4195: RAISE fnd_api.g_exc_unexpected_error;

4191: IF (p_owning_org_id IS NULL AND p_planning_org_id IS NULL) THEN
4192: fnd_message.set_name('INV', 'INV_OWN_PLAN_ORG_REQUIRED');
4193: fnd_msg_pub.ADD;
4194: x_return_msg := fnd_message.get;
4195: RAISE fnd_api.g_exc_unexpected_error;
4196: END IF ;
4197: ELSIF (p_query_mode = G_REG_MODE) THEN
4198: IF (p_owning_org_id IS NULL) THEN
4199: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');

Line 4202: RAISE fnd_api.g_exc_unexpected_error;

4198: IF (p_owning_org_id IS NULL) THEN
4199: fnd_message.set_name('INV', 'INV_OWN_ORG_REQUIRED');
4200: fnd_msg_pub.ADD;
4201: x_return_msg := fnd_message.get;
4202: RAISE fnd_api.g_exc_unexpected_error;
4203: END IF ;
4204: END IF;
4205:
4206: IF (l_debug = 1) THEN

Line 4268: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4264: , p_lpn_id => p_lpn_id
4265: , p_qty_tree_att => x_att
4266: , x_return_status => x_return_status) ;
4267:
4268: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4269: IF (l_debug = 1) THEN
4270: inv_log_util.trace('populate_lpn_temp Failed','CONSIGNED_VALIDATIONS',9);
4271: END IF;
4272: RAISE fnd_api.g_exc_unexpected_error;

Line 4272: RAISE fnd_api.g_exc_unexpected_error;

4268: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4269: IF (l_debug = 1) THEN
4270: inv_log_util.trace('populate_lpn_temp Failed','CONSIGNED_VALIDATIONS',9);
4271: END IF;
4272: RAISE fnd_api.g_exc_unexpected_error;
4273: END IF;
4274: IF (l_debug = 1) THEN
4275: inv_log_util.trace('after populate_lpn_temp x_att'||x_att,'CONSIGNED_VALIDATIONS',9);
4276: END IF;

Line 4310: , p_init_msg_lst => fnd_api.g_false

4306: inv_log_util.trace('Transaction Mode, calling quantity tree','CONSIGNED_VALIDATIONS',9);
4307: END IF;
4308: inv_quantity_tree_pub.query_quantities(
4309: p_api_version_number => 1.0
4310: , p_init_msg_lst => fnd_api.g_false
4311: , x_return_status => x_return_status
4312: , x_msg_count => l_msg_count
4313: , x_msg_data => l_msg_data
4314: , p_organization_id => p_organization_id

Line 4340: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4336: , x_atr => l_atr
4337: );
4338:
4339: -- If the qty tree returns and error raise an exception.
4340: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4341: IF (l_debug = 1) THEN
4342: inv_log_util.trace('Qty Tree Failed'||l_msg_data,'CONSIGNED_VALIDATIONS',9);
4343: END IF;
4344: x_return_msg:= l_msg_data;

Line 4345: RAISE fnd_api.g_exc_unexpected_error;

4341: IF (l_debug = 1) THEN
4342: inv_log_util.trace('Qty Tree Failed'||l_msg_data,'CONSIGNED_VALIDATIONS',9);
4343: END IF;
4344: x_return_msg:= l_msg_data;
4345: RAISE fnd_api.g_exc_unexpected_error;
4346: END IF;
4347:
4348: IF (l_debug = 1) THEN
4349: inv_log_util.trace('Called qty tree, l_qoh='||l_qoh||',l_att='||l_att,'CONSIGNED_VALIDATIONS',9);

Line 4369: x_return_status:= fnd_api.g_ret_sts_success;

4365: END IF;
4366:
4367: END IF;
4368:
4369: x_return_status:= fnd_api.g_ret_sts_success;
4370:
4371: EXCEPTION
4372: when others THEN
4373: IF (l_debug = 1) THEN

Line 4376: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

4372: when others THEN
4373: IF (l_debug = 1) THEN
4374: inv_log_util.trace('When others Exception in GET_CONSIGNED_LPN_QUANTITY','CONSIGNED_VALIDATIONS',9);
4375: END IF;
4376: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
4377: RETURN;
4378: END GET_CONSIGNED_LPN_QUANTITY;
4379:
4380: