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 INV_LOG_UTIL

Line 30: inv_log_util.trace(p_message, p_title, p_level);

26: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
27: END IF;
28:
29: IF (g_debug = 1) THEN
30: inv_log_util.trace(p_message, p_title, p_level);
31: END IF;
32: --dbms_output.put_line(p_message);
33: END debug_print;
34:

Line 85: inv_log_util.trace('In Query_VMI_Consigned','CONSIGNED_VALIDATIONS',9);

81:
82: BEGIN
83:
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:

Line 118: inv_log_util.trace('No record found in mtl_consigned_qty_temp, return 0','CONSIGNED_VALIDATIONS',9);

114: END;
115:
116: IF (l_table_count = 0) THEN
117: IF (l_debug = 1) THEN
118: inv_log_util.trace('No record found in mtl_consigned_qty_temp, return 0','CONSIGNED_VALIDATIONS',9);
119: END IF;
120: x_qoh := 0;
121:
122: -- invConv changes begin

Line 178: inv_log_util.trace('Final Level= '||L_LEVEL,'CONSIGNED_VALIDATIONS',9);

174: l_level:= 7;
175: END IF;
176:
177: IF (l_debug = 1) THEN
178: inv_log_util.trace('Final Level= '||L_LEVEL,'CONSIGNED_VALIDATIONS',9);
179: END IF;
180:
181:
182: IF (l_level =2) THEN

Line 309: inv_log_util.trace('When others in query CONSIGNED/VMI ','CONSIGNED_VALIDATIONS',9);

305:
306: EXCEPTION
307: when others THEN
308: IF (l_debug = 1) THEN
309: inv_log_util.trace('When others in query CONSIGNED/VMI ','CONSIGNED_VALIDATIONS',9);
310: END IF;
311: x_return_status := 'E';
312: x_qoh := 0;
313: -- invConv changes begin

Line 842: inv_log_util.trace('When Others Ex. in build sql','CONSIGNED_VALIDATIONS',9);

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;
845:
846:

Line 879: inv_log_util.trace('Inside Build Cursor','CONSIGNED_VALIDATIONS',9);

875: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
876: BEGIN
877: l_cursor := dbms_sql.open_cursor;
878: IF (l_debug = 1) THEN
879: inv_log_util.trace('Inside Build Cursor','CONSIGNED_VALIDATIONS',9);
880: END IF;
881:
882: build_sql
883: ( x_return_status => l_return_status

Line 1157: inv_log_util.trace('When others Ex. in Inserting in temp table','CONSIGNED_VALIDATIONS',9);

1153: dbms_sql.close_cursor(l_cursor);
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF (l_debug = 1) THEN
1157: inv_log_util.trace('When others Ex. in Inserting in temp table','CONSIGNED_VALIDATIONS',9);
1158: END IF;
1159: END populate_consigned_qty_temp;
1160:
1161: /* invconv changes begin : this procedure is now obsolete

Line 1195: inv_log_util.trace('check_is_reservable_sub','CONSIGNED_VALIDATIONS',9);

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:
1198: END check_is_reservable_sub;
1199: invConv changes end. */

Line 1260: inv_log_util.trace('in check_is_reservable. node_level='||p_node_level||', subinv='||p_subinventory_code||', loct='||p_locator_id||', lot='||p_lot_number, 'CONSIGNED_VALIDATIONS',9);

1256: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1257:
1258: BEGIN
1259: IF (l_debug = 1) THEN
1260: inv_log_util.trace('in check_is_reservable. node_level='||p_node_level||', subinv='||p_subinventory_code||', loct='||p_locator_id||', lot='||p_lot_number, 'CONSIGNED_VALIDATIONS',9);
1261: END IF;
1262:
1263: -- lot level = 4
1264: -- subinv level = 5

Line 1279: inv_log_util.trace('in RSV reservable='||l_reservable_type||', for lot='||p_lot_number, 'CONSIGNED_VALIDATIONS',9);

1275: END IF;
1276: CLOSE is_RSV_lot;
1277:
1278: IF (l_debug = 1) THEN
1279: inv_log_util.trace('in RSV reservable='||l_reservable_type||', for lot='||p_lot_number, 'CONSIGNED_VALIDATIONS',9);
1280: END IF;
1281:
1282: ELSIF (NVL(p_node_level, 0) = 6)
1283: OR (p_locator_id IS NOT NULL)

Line 1295: inv_log_util.trace('in RSV reservable='||l_reservable_type||', for locator='||p_locator_id, 'CONSIGNED_VALIDATIONS',9);

1291: END IF;
1292: CLOSE is_RSV_loct;
1293:
1294: IF (l_debug = 1) THEN
1295: inv_log_util.trace('in RSV reservable='||l_reservable_type||', for locator='||p_locator_id, 'CONSIGNED_VALIDATIONS',9);
1296: END IF;
1297:
1298: ELSIF (NVL(p_node_level, 0) = 5)
1299: OR (p_subinventory_code IS NOT NULL)

Line 1307: inv_log_util.trace('in RSV reservable='||l_reservable_type||', for subInv='||p_subinventory_code, 'CONSIGNED_VALIDATIONS',9);

1303: INTO l_reservable_type;
1304: CLOSE is_RSV_subInv;
1305:
1306: IF (l_debug = 1) THEN
1307: inv_log_util.trace('in RSV reservable='||l_reservable_type||', for subInv='||p_subinventory_code, 'CONSIGNED_VALIDATIONS',9);
1308: END IF;
1309:
1310: END IF;
1311:

Line 1315: inv_log_util.trace('in RSV reservable=TRUE', 'CONSIGNED_VALIDATIONS',9);

1311:
1312: IF (l_reservable_type = 1) THEN
1313: x_is_reservable := TRUE;
1314: IF (l_debug = 1) THEN
1315: inv_log_util.trace('in RSV reservable=TRUE', 'CONSIGNED_VALIDATIONS',9);
1316: END IF;
1317: ELSE
1318: x_is_reservable := FALSE;
1319: IF (l_debug = 1) THEN

Line 1320: inv_log_util.trace('in RSV reservable=FALSE', 'CONSIGNED_VALIDATIONS',9);

1316: END IF;
1317: ELSE
1318: x_is_reservable := FALSE;
1319: IF (l_debug = 1) THEN
1320: inv_log_util.trace('in RSV reservable=FALSE', 'CONSIGNED_VALIDATIONS',9);
1321: END IF;
1322: END IF;
1323:
1324: x_return_status := l_return_status;

Line 1330: inv_log_util.trace('in check_is_reservable, OTHERS Error='||SQLERRM, 'CONSIGNED_VALIDATIONS',9);

1326: EXCEPTION
1327:
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)

Line 1575: inv_log_util.trace('Done validation','CONSIGNED_VALIDATIONS',9);

1571: END IF ;
1572: END IF;
1573:
1574: IF (l_debug = 1) THEN
1575: inv_log_util.trace('Done validation','CONSIGNED_VALIDATIONS',9);
1576: END IF;
1577: IF (p_query_mode = G_REG_MODE) THEN
1578:
1579: IF (l_debug = 1) THEN

Line 1580: inv_log_util.trace('Transfer regular to consigned','CONSIGNED_VALIDATIONS',9);

1576: END IF;
1577: IF (p_query_mode = G_REG_MODE) THEN
1578:
1579: IF (l_debug = 1) THEN
1580: inv_log_util.trace('Transfer regular to consigned','CONSIGNED_VALIDATIONS',9);
1581: END IF;
1582: -- invConv changes begin : added secondary quantities :
1583: SELECT Nvl(sum(primary_transaction_quantity),0)
1584: , Nvl(sum(secondary_transaction_quantity),0)

Line 1601: inv_log_util.trace('Got qty, x_qoh=x_att='||x_att,'CONSIGNED_VALIDATIONS',9);

1597:
1598: x_qoh := x_att;
1599: x_sqoh := x_satt; -- invConv change
1600: IF (l_debug = 1) THEN
1601: inv_log_util.trace('Got qty, x_qoh=x_att='||x_att,'CONSIGNED_VALIDATIONS',9);
1602: END IF;
1603:
1604: RETURN;
1605: END IF;

Line 1627: inv_log_util.trace('Going to build SQL','CONSIGNED_VALIDATIONS',9);

1623: -- Clear the already existing cache only if for this item and org no table
1624: -- exists.
1625: IF (l_table_count = 0) THEN
1626: IF (l_debug = 1) THEN
1627: inv_log_util.trace('Going to build SQL','CONSIGNED_VALIDATIONS',9);
1628: END IF;
1629:
1630: populate_consigned_qty_temp(
1631: p_organization_id => p_organization_id

Line 1647: inv_log_util.trace('populate consigned temp Failed','CONSIGNED_VALIDATIONS',9);

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;
1650: END IF;
1651: END IF;

Line 1654: inv_log_util.trace('Query consigned temp table for l_vcoh','CONSIGNED_VALIDATIONS',9);

1650: END IF;
1651: END IF;
1652:
1653: IF (l_debug = 1) THEN
1654: inv_log_util.trace('Query consigned temp table for l_vcoh','CONSIGNED_VALIDATIONS',9);
1655: END IF;
1656: inv_consigned_validations.query_vmi_consigned(
1657: x_return_status => x_return_status
1658: , x_msg_count => l_msg_count

Line 1681: inv_log_util.trace('CONSIGNED_VMI table query Failed'||l_msg_data,'CONSIGNED_VALIDATIONS',9);

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;
1684: END IF;
1685:

Line 1687: inv_log_util.trace('Got l_vcoh='||l_vcoh,'CONSIGNED_VALIDATIONS',9);

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);
1688: END IF;
1689:
1690: IF (p_query_mode = G_TXN_MODE) THEN
1691:

Line 1696: inv_log_util.trace('Transaction Mode, calling quantity tree','CONSIGNED_VALIDATIONS',9);

1692: -- Call the quantity tree
1693: -- This API calls the public qty tree api to create and query the tree
1694: --togethor. The created tree is stored in the memory as a PL/SQL table.
1695: IF (l_debug = 1) THEN
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

Line 1738: inv_log_util.trace('Qty Tree Failed'||l_msg_data,'CONSIGNED_VALIDATIONS',9);

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;
1741: RAISE fnd_api.g_exc_unexpected_error;
1742: END IF;

Line 1776: inv_log_util.trace('When others Exception in get_consigned_quantity','CONSIGNED_VALIDATIONS',9);

1772:
1773: EXCEPTION
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;

Line 1884: inv_log_util.trace('in update_consigned_quantities is_rsv=TRUE', 'CONSIGNED_VALIDATIONS',9);

1880:
1881: IF b_reservable
1882: THEN
1883: IF (l_debug = 1) THEN
1884: inv_log_util.trace('in update_consigned_quantities is_rsv=TRUE', 'CONSIGNED_VALIDATIONS',9);
1885: END IF;
1886: ELSE
1887: IF (l_debug = 1) THEN
1888: inv_log_util.trace('in update_consigned_quantities is_rsv=FALSE', 'CONSIGNED_VALIDATIONS',9);

Line 1888: inv_log_util.trace('in update_consigned_quantities is_rsv=FALSE', 'CONSIGNED_VALIDATIONS',9);

1884: inv_log_util.trace('in update_consigned_quantities is_rsv=TRUE', 'CONSIGNED_VALIDATIONS',9);
1885: END IF;
1886: ELSE
1887: IF (l_debug = 1) THEN
1888: inv_log_util.trace('in update_consigned_quantities is_rsv=FALSE', 'CONSIGNED_VALIDATIONS',9);
1889: END IF;
1890: END IF;
1891: -- invConv changes end.
1892:

Line 1959: inv_log_util.trace('Ex in update_vmi_quantities','CONSIGNED_VALIDATIONS',9);

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:
1962:
1963: END update_consigned_quantities;

Line 2009: inv_log_util.trace('x_consume_consigned:'||x_consume_consigned||'x_consume_vmi :'||x_consume_vmi||'weight:'||l_weight,'CONSIGNED_VALIDATIONS',9);

2005: ORDER BY Nvl(weight,-1) DESC )
2006: where ROWNUM < 2;
2007:
2008: IF (l_debug = 1) THEN
2009: inv_log_util.trace('x_consume_consigned:'||x_consume_consigned||'x_consume_vmi :'||x_consume_vmi||'weight:'||l_weight,'CONSIGNED_VALIDATIONS',9);
2010: END IF;
2011: EXCEPTION
2012: WHEN no_data_found THEN
2013: x_consume_consigned := 0;

Line 2097: inv_log_util.trace('Other error in inv_consigned_validations.check_pending_transactions','CONSIGNED_VALIDATIONS',9);

2093: END IF;
2094: EXCEPTION
2095: WHEN others THEN
2096: IF (l_debug = 1) THEN
2097: inv_log_util.trace('Other error in inv_consigned_validations.check_pending_transactions','CONSIGNED_VALIDATIONS',9);
2098: END IF;
2099: RETURN 'N';
2100: END check_pending_transactions ;
2101:

Line 2135: inv_log_util.trace('p_include_nonnet: ' || to_char(p_include_nonnet) ||

2131: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2132:
2133: BEGIN
2134: IF (l_debug=1) THEN
2135: inv_log_util.trace('p_include_nonnet: ' || to_char(p_include_nonnet) ||
2136: ', p_level: ' || to_char(p_level) ||
2137: ', p_org_id: ' || to_char(p_org_id) ||
2138: ', p_subinv: ' || p_subinv ||
2139: ', p_item_id: ' || to_char(p_item_id)

Line 2159: inv_log_util.trace('Total quantity on-hand: ' || to_char(l_qoh), 'GET_PLANNING_ONHAND_QTY', 9);

2155: -- invConv changes end.
2156:
2157:
2158: IF(l_debug=1) THEN
2159: inv_log_util.trace('Total quantity on-hand: ' || to_char(l_qoh), 'GET_PLANNING_ONHAND_QTY', 9);
2160: END IF;
2161: RETURN(l_qoh);
2162:
2163:

Line 2167: inv_log_util.trace(sqlcode || ', ' || sqlerrm, 'GET_PLANNING_ONHAND_QTY', 1);

2163:
2164: EXCEPTION
2165: WHEN OTHERS THEN
2166: IF(l_debug=1) THEN
2167: inv_log_util.trace(sqlcode || ', ' || sqlerrm, 'GET_PLANNING_ONHAND_QTY', 1);
2168: END IF;
2169: RETURN(0);
2170:
2171: END GET_PLANNING_QUANTITY;

Line 2737: inv_log_util.trace('Total MTRL undelivered LPN quantity for WIP completions: ' || to_char(l_lpn_qty), 'GET_PLANNING_ONHAND_QTY', 9);

2733: AND mtrl.line_status = 7 -- Pre Approved
2734: AND mtrl.lpn_id is not null;
2735:
2736: IF(l_debug=1) THEN
2737: inv_log_util.trace('Total MTRL undelivered LPN quantity for WIP completions: ' || to_char(l_lpn_qty), 'GET_PLANNING_ONHAND_QTY', 9);
2738: END IF;
2739:
2740:
2741: ELSIF (p_level = 2) THEN

Line 2930: inv_log_util.trace

2926: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2927:
2928: BEGIN
2929: IF (l_debug=1) THEN
2930: inv_log_util.trace
2931: ('p_onhand_source: ' || to_char(p_onhand_source) ||
2932: ', p_org_id: ' || to_char(p_org_id) ||
2933: ', p_item_id: ' || to_char(p_item_id)
2934: , 'GET_PLANNING_SD_QTY'

Line 2995: inv_log_util.trace('Total MOQ quantity Org level: ' || to_char(l_moq_qty), 'GET_PLANNING_SD_QTY', 9);

2991: AND nvl(moq.planning_tp_type,2) = 2;
2992: END IF;
2993:
2994: IF(l_debug=1) THEN
2995: inv_log_util.trace('Total MOQ quantity Org level: ' || to_char(l_moq_qty), 'GET_PLANNING_SD_QTY', 9);
2996: END IF;
2997:
2998: IF (l_lot_control = 2) THEN
2999:

Line 3054: inv_log_util.trace('Total MMTT Trx quantity Source Org level (lot Controlled): ' || to_char(l_mmtt_qty_src), 'GET_PLANNING_SD_QTY', 9);

3050:
3051: END IF;
3052:
3053: IF(l_debug=1) THEN
3054: inv_log_util.trace('Total MMTT Trx quantity Source Org level (lot Controlled): ' || to_char(l_mmtt_qty_src), 'GET_PLANNING_SD_QTY', 9);
3055: END IF;
3056:
3057: IF (p_onhand_source = g_atpable_only) THEN
3058:

Line 3117: inv_log_util.trace('Total MMTT Trx quantity Dest Org level (lot controlled): ' || to_char(l_mmtt_qty_dest), 'GET_PLANNING_SD_QTY', 9);

3113:
3114: END IF;
3115:
3116: IF(l_debug=1) THEN
3117: inv_log_util.trace('Total MMTT Trx quantity Dest Org level (lot controlled): ' || to_char(l_mmtt_qty_dest), 'GET_PLANNING_SD_QTY', 9);
3118: END IF;
3119: ELSE
3120:
3121: IF (p_onhand_source = g_atpable_only) THEN

Line 3162: inv_log_util.trace('Total MMTT Trx quantity Source Org level: ' || to_char(l_mmtt_qty_src), 'GET_PLANNING_SD_QTY', 9);

3158:
3159: END IF;
3160:
3161: IF(l_debug=1) THEN
3162: inv_log_util.trace('Total MMTT Trx quantity Source Org level: ' || to_char(l_mmtt_qty_src), 'GET_PLANNING_SD_QTY', 9);
3163: END IF;
3164:
3165: IF (p_onhand_source = g_atpable_only) THEN
3166:

Line 3210: inv_log_util.trace('Total MMTT Trx quantity Dest Org level: ' || to_char(l_mmtt_qty_dest), 'GET_PLANNING_SD_QTY', 9);

3206:
3207: END IF;
3208:
3209: IF(l_debug=1) THEN
3210: inv_log_util.trace('Total MMTT Trx quantity Dest Org level: ' || to_char(l_mmtt_qty_dest), 'GET_PLANNING_SD_QTY', 9);
3211: END IF;
3212: END IF;
3213:
3214: ELSE /* onhand material status check */

Line 3275: inv_log_util.trace('Total MOQ quantity Org level: ' || to_char(l_moq_qty), 'GET_PLANNING_SD_QTY', 9);

3271:
3272: END IF;
3273:
3274: IF(l_debug=1) THEN
3275: inv_log_util.trace('Total MOQ quantity Org level: ' || to_char(l_moq_qty), 'GET_PLANNING_SD_QTY', 9);
3276: END IF;
3277:
3278: IF (l_lot_control = 2) THEN
3279:

Line 3350: inv_log_util.trace('Total MMTT Trx quantity Source Org level (lot Controlled): ' || to_char(l_mmtt_qty_src), 'GET_PLANNING_SD_QTY', 9);

3346:
3347: END IF;
3348:
3349: IF(l_debug=1) THEN
3350: inv_log_util.trace('Total MMTT Trx quantity Source Org level (lot Controlled): ' || to_char(l_mmtt_qty_src), 'GET_PLANNING_SD_QTY', 9);
3351: END IF;
3352:
3353: IF (p_onhand_source = g_atpable_only) THEN
3354:

Line 3441: inv_log_util.trace('Total MMTT Trx quantity Dest Org level (lot controlled): ' || to_char(l_mmtt_qty_dest), 'GET_PLANNING_SD_QTY', 9);

3437:
3438: END IF;
3439:
3440: IF(l_debug=1) THEN
3441: inv_log_util.trace('Total MMTT Trx quantity Dest Org level (lot controlled): ' || to_char(l_mmtt_qty_dest), 'GET_PLANNING_SD_QTY', 9);
3442: END IF;
3443: ELSE
3444:
3445: IF (p_onhand_source = g_atpable_only) THEN

Line 3500: inv_log_util.trace('Total MMTT Trx quantity Source Org level: ' || to_char(l_mmtt_qty_src), 'GET_PLANNING_SD_QTY', 9);

3496:
3497: END IF;
3498:
3499: IF(l_debug=1) THEN
3500: inv_log_util.trace('Total MMTT Trx quantity Source Org level: ' || to_char(l_mmtt_qty_src), 'GET_PLANNING_SD_QTY', 9);
3501: END IF;
3502:
3503: IF (p_onhand_source = g_atpable_only) THEN
3504:

Line 3574: inv_log_util.trace('Total MMTT Trx quantity Dest Org level: ' || to_char(l_mmtt_qty_dest), 'GET_PLANNING_SD_QTY', 9);

3570:
3571: END IF;
3572:
3573: IF(l_debug=1) THEN
3574: inv_log_util.trace('Total MMTT Trx quantity Dest Org level: ' || to_char(l_mmtt_qty_dest), 'GET_PLANNING_SD_QTY', 9);
3575: END IF;
3576:
3577: END IF;
3578:

Line 3601: inv_log_util.trace('Total MTRL undelivered LPN quantity for WIP completions: ' || to_char(l_lpn_qty), 'GET_PLANNING_SD_QTY', 9);

3597: AND mtrl.line_status = 7 -- Pre Approved
3598: AND mtrl.lpn_id is not null;
3599:
3600: IF(l_debug=1) THEN
3601: inv_log_util.trace('Total MTRL undelivered LPN quantity for WIP completions: ' || to_char(l_lpn_qty), 'GET_PLANNING_SD_QTY', 9);
3602: END IF;
3603:
3604: -- Bug 4189319, adding undelivered LPN l_lpn_qty for WIP assembly completions in total onhand.
3605: l_qoh := nvl(l_moq_qty,0) + nvl(l_mmtt_qty_src,0) + nvl(l_mmtt_qty_dest,0) + nvl(l_lpn_qty,0);

Line 3608: inv_log_util.trace('Total quantity on-hand: ' || to_char(l_qoh), 'GET_PLANNING_SD_QTY', 9);

3604: -- Bug 4189319, adding undelivered LPN l_lpn_qty for WIP assembly completions in total onhand.
3605: l_qoh := nvl(l_moq_qty,0) + nvl(l_mmtt_qty_src,0) + nvl(l_mmtt_qty_dest,0) + nvl(l_lpn_qty,0);
3606:
3607: IF(l_debug=1) THEN
3608: inv_log_util.trace('Total quantity on-hand: ' || to_char(l_qoh), 'GET_PLANNING_SD_QTY', 9);
3609: END IF;
3610: RETURN(l_qoh);
3611:
3612:

Line 3616: inv_log_util.trace(sqlcode || ', ' || sqlerrm, 'GET_PLANNING_SD_QTY', 1);

3612:
3613: EXCEPTION
3614: WHEN OTHERS THEN
3615: IF(l_debug=1) THEN
3616: inv_log_util.trace(sqlcode || ', ' || sqlerrm, 'GET_PLANNING_SD_QTY', 1);
3617: END IF;
3618: RETURN(0);
3619:
3620: END GET_PLANNING_SD_QUANTITY;

Line 3811: inv_log_util.trace('When Others Ex. in build_lpn_sql','CONSIGNED_VALIDATIONS',9);

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;
3814:
3815:

Line 3844: inv_log_util.trace('Inside build_lpn_cursor','CONSIGNED_VALIDATIONS',9);

3840: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3841: BEGIN
3842: l_cursor := dbms_sql.open_cursor;
3843: IF (l_debug = 1) THEN
3844: inv_log_util.trace('Inside build_lpn_cursor','CONSIGNED_VALIDATIONS',9);
3845: END IF;
3846:
3847: build_lpn_sql
3848: (l_return_status,

Line 3872: inv_log_util.trace('p_lpn_id:'||p_lpn_id||',org :'||p_organization_id ||',item:'|| p_inventory_item_id,'CONSIGNED_VALIDATIONS',9);

3868: RAISE;
3869: END;
3870:
3871: IF (l_debug = 1) THEN
3872: inv_log_util.trace('p_lpn_id:'||p_lpn_id||',org :'||p_organization_id ||',item:'|| p_inventory_item_id,'CONSIGNED_VALIDATIONS',9);
3873: END IF;
3874: dbms_sql.bind_variable(l_cursor, ':organization_id', p_organization_id);
3875: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
3876: dbms_sql.bind_variable(l_cursor, ':lpn_id', p_lpn_id );

Line 3889: inv_log_util.trace('When Others Ex. in build_lpn_cursor','CONSIGNED_VALIDATIONS',9);

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:
3892: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3893: THEN

Line 4067: inv_log_util.trace('#of records inserted into mtl_consigned_qty_temp :'||l_count,'CONSIGNED_VALIDATIONS',9);

4063: ll_owning_organization_id);
4064: END LOOP;
4065:
4066: IF (l_debug = 1) THEN
4067: inv_log_util.trace('#of records inserted into mtl_consigned_qty_temp :'||l_count,'CONSIGNED_VALIDATIONS',9);
4068: END IF;
4069: dbms_sql.close_cursor(l_cursor);
4070: EXCEPTION
4071: WHEN OTHERS THEN

Line 4073: inv_log_util.trace('When others Ex. in populate_lpn_temp','CONSIGNED_VALIDATIONS',9);

4069: dbms_sql.close_cursor(l_cursor);
4070: EXCEPTION
4071: WHEN OTHERS THEN
4072: IF (l_debug = 1) THEN
4073: inv_log_util.trace('When others Ex. in populate_lpn_temp','CONSIGNED_VALIDATIONS',9);
4074: END IF;
4075: END populate_lpn_temp;
4076:
4077:

Line 4125: inv_log_util.trace(' GET_CONSIGNED_LPN_QUANTITIES *','CONSIGNED_VALIDATIONS',9);

4121: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4122: BEGIN
4123:
4124: IF (l_debug = 1) THEN
4125: inv_log_util.trace('****** GET_CONSIGNED_LPN_QUANTITIES *******','CONSIGNED_VALIDATIONS',9);
4126: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','
4127: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS',9);
4128: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
4129: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS',9);

Line 4126: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','

4122: BEGIN
4123:
4124: IF (l_debug = 1) THEN
4125: inv_log_util.trace('****** GET_CONSIGNED_LPN_QUANTITIES *******','CONSIGNED_VALIDATIONS',9);
4126: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','
4127: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS',9);
4128: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
4129: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS',9);
4130: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS',9);

Line 4128: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||

4124: IF (l_debug = 1) THEN
4125: inv_log_util.trace('****** GET_CONSIGNED_LPN_QUANTITIES *******','CONSIGNED_VALIDATIONS',9);
4126: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','
4127: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS',9);
4128: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
4129: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS',9);
4130: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS',9);
4131: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS',9);
4132: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||

Line 4130: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS',9);

4126: inv_log_util.trace(' Org, Owning_org, planning_org='|| p_organization_id ||','
4127: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS',9);
4128: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
4129: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS',9);
4130: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS',9);
4131: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS',9);
4132: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||
4133: p_source_type_id ||',' ||p_demand_source_line_id || ','||
4134: p_demand_source_header_id || ',' || p_demand_source_name,'CONSIGNED_VALIDATIONS',9);

Line 4131: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS',9);

4127: || p_owning_org_id ||','||p_planning_org_id,'CONSIGNED_VALIDATIONS',9);
4128: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
4129: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS',9);
4130: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS',9);
4131: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS',9);
4132: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||
4133: p_source_type_id ||',' ||p_demand_source_line_id || ','||
4134: p_demand_source_header_id || ',' || p_demand_source_name,'CONSIGNED_VALIDATIONS',9);
4135: inv_log_util.trace(' OnhandSource, CstGroupID, QueryMode: '|| p_onhand_source || ','||

Line 4132: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||

4128: inv_log_util.trace(' Item, Is Rev, Lot, Serial controlled: '||p_inventory_item_id|| ','||
4129: p_is_revision_control ||','|| p_is_lot_control ||','|| p_is_serial_control,'CONSIGNED_VALIDATIONS',9);
4130: inv_log_util.trace(' Rev, Lot, LotExpDate: '|| p_revision ||','||p_lot_number ||','|| p_lot_expiration_date,'CONSIGNED_VALIDATIONS',9);
4131: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS',9);
4132: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||
4133: p_source_type_id ||',' ||p_demand_source_line_id || ','||
4134: p_demand_source_header_id || ',' || p_demand_source_name,'CONSIGNED_VALIDATIONS',9);
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);

Line 4135: inv_log_util.trace(' OnhandSource, CstGroupID, QueryMode: '|| p_onhand_source || ','||

4131: inv_log_util.trace(' Sub, Loc: '||p_subinventory_code||','||p_locator_id,'CONSIGNED_VALIDATIONS',9);
4132: inv_log_util.trace(' SourceTypeID, DemdSrcLineID, DemdSrcHdrID, DemdSrcName: ' ||
4133: p_source_type_id ||',' ||p_demand_source_line_id || ','||
4134: p_demand_source_header_id || ',' || p_demand_source_name,'CONSIGNED_VALIDATIONS',9);
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;

Line 4207: inv_log_util.trace('Done with validations','CONSIGNED_VALIDATIONS',9);

4203: END IF ;
4204: END IF;
4205:
4206: IF (l_debug = 1) THEN
4207: inv_log_util.trace('Done with validations','CONSIGNED_VALIDATIONS',9);
4208: END IF;
4209: IF (p_query_mode = G_REG_MODE) THEN
4210:
4211: IF (l_debug = 1) THEN

Line 4212: inv_log_util.trace('Transfer regular to consigned','CONSIGNED_VALIDATIONS',9);

4208: END IF;
4209: IF (p_query_mode = G_REG_MODE) THEN
4210:
4211: IF (l_debug = 1) THEN
4212: inv_log_util.trace('Transfer regular to consigned','CONSIGNED_VALIDATIONS',9);
4213: END IF;
4214: SELECT Nvl(sum(primary_transaction_quantity),0) INTO x_att
4215: FROM mtl_onhand_quantities_detail
4216: WHERE owning_organization_id = organization_id

Line 4229: inv_log_util.trace('Got qty, x_qoh=x_att='||x_att,'CONSIGNED_VALIDATIONS',9);

4225: AND nvl(cost_group_id, -999) = nvl(p_cost_group_id, nvl(cost_group_id, -999));
4226:
4227: x_qoh := x_att;
4228: IF (l_debug = 1) THEN
4229: inv_log_util.trace('Got qty, x_qoh=x_att='||x_att,'CONSIGNED_VALIDATIONS',9);
4230: END IF;
4231:
4232: RETURN;
4233: END IF;

Line 4251: inv_log_util.trace('calling populate_lpn_temp','CONSIGNED_VALIDATIONS',9);

4247: -- Clear the already existing cache only if for this item and org no table
4248: -- exists.
4249: IF (l_table_count = 0) THEN
4250: IF (l_debug = 1) THEN
4251: inv_log_util.trace('calling populate_lpn_temp','CONSIGNED_VALIDATIONS',9);
4252: END IF;
4253:
4254: populate_lpn_temp(
4255: p_organization_id => p_organization_id

Line 4270: inv_log_util.trace('populate_lpn_temp Failed','CONSIGNED_VALIDATIONS',9);

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;
4273: END IF;
4274: IF (l_debug = 1) THEN

Line 4275: inv_log_util.trace('after populate_lpn_temp x_att'||x_att,'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;
4277:
4278: END IF;
4279:

Line 4281: inv_log_util.trace('Query consigned temp table for l_vcoh','CONSIGNED_VALIDATIONS',9);

4277:
4278: END IF;
4279:
4280: IF (l_debug = 1) THEN
4281: inv_log_util.trace('Query consigned temp table for l_vcoh','CONSIGNED_VALIDATIONS',9);
4282: END IF;
4283:
4284: SELECT Nvl(sum(primary_quantity),0) INTO l_vcoh
4285: FROM mtl_consigned_qty_temp

Line 4297: inv_log_util.trace('Got l_vcoh='||l_vcoh,'CONSIGNED_VALIDATIONS',9);

4293: AND subinventory_code = p_subinventory_code
4294: AND locator_id = p_locator_id ;
4295:
4296: IF (l_debug = 1) THEN
4297: inv_log_util.trace('Got l_vcoh='||l_vcoh,'CONSIGNED_VALIDATIONS',9);
4298: END IF;
4299:
4300: IF (p_query_mode = G_TXN_MODE) THEN
4301:

Line 4306: inv_log_util.trace('Transaction Mode, calling quantity tree','CONSIGNED_VALIDATIONS',9);

4302: -- Call the quantity tree
4303: -- This API calls the public qty tree api to create and query the tree
4304: --togethor. The created tree is stored in the memory as a PL/SQL table.
4305: IF (l_debug = 1) THEN
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

Line 4342: inv_log_util.trace('Qty Tree Failed'||l_msg_data,'CONSIGNED_VALIDATIONS',9);

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;
4345: RAISE fnd_api.g_exc_unexpected_error;
4346: END IF;

Line 4349: inv_log_util.trace('Called qty tree, l_qoh='||l_qoh||',l_att='||l_att,'CONSIGNED_VALIDATIONS',9);

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);
4350: inv_log_util.trace('Comparing with l_vcoh='||l_vcoh,'CONSIGNED_VALIDATIONS',9);
4351: END IF;
4352: --consign/VMI att is min of qty tree att and vmi/consigned onhand.
4353: IF (l_vcoh <= l_att) THEN

Line 4350: inv_log_util.trace('Comparing with l_vcoh='||l_vcoh,'CONSIGNED_VALIDATIONS',9);

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);
4350: inv_log_util.trace('Comparing with l_vcoh='||l_vcoh,'CONSIGNED_VALIDATIONS',9);
4351: END IF;
4352: --consign/VMI att is min of qty tree att and vmi/consigned onhand.
4353: IF (l_vcoh <= l_att) THEN
4354: x_att:= l_vcoh;

Line 4364: inv_log_util.trace('Transfer mode, x_qoh=x_att=l_vcoh='||x_att,'CONSIGNED_VALIDATIONS',9);

4360: ELSIF (p_query_mode = G_XFR_MODE) THEN
4361: x_att := l_vcoh;
4362: x_qoh := x_att;
4363: IF (l_debug = 1) THEN
4364: inv_log_util.trace('Transfer mode, x_qoh=x_att=l_vcoh='||x_att,'CONSIGNED_VALIDATIONS',9);
4365: END IF;
4366:
4367: END IF;
4368:

Line 4374: inv_log_util.trace('When others Exception in GET_CONSIGNED_LPN_QUANTITY','CONSIGNED_VALIDATIONS',9);

4370:
4371: EXCEPTION
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;