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_LOT_API_PUB dependencies on INV_LOG_UTIL

Line 973: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');

969: EXCEPTION
970: when no_data_found THEN
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: IF (l_debug = 1) THEN
973: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
974: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
975: END IF;
976: raise FND_API.G_EXC_UNEXPECTED_ERROR;
977: when others then

Line 974: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');

970: when no_data_found THEN
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: IF (l_debug = 1) THEN
973: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
974: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
975: END IF;
976: raise FND_API.G_EXC_UNEXPECTED_ERROR;
977: when others then
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 980: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');

976: raise FND_API.G_EXC_UNEXPECTED_ERROR;
977: when others then
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: IF (l_debug = 1) THEN
980: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
981: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
982: END IF;
983: raise FND_API.G_EXC_UNEXPECTED_ERROR;
984:

Line 981: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');

977: when others then
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: IF (l_debug = 1) THEN
980: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
981: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
982: END IF;
983: raise FND_API.G_EXC_UNEXPECTED_ERROR;
984:
985: end;

Line 5712: inv_log_util.trace('l_expiration_date is:'||l_expiration_date, 'INV_LOT_API_PUB','9'); --For bug 4888300

5708: END IF;
5709: IF g_debug = 1 THEN
5710: print_debug('Updating MTL_LOT_NUMBERS table ....' , 9);
5711: END IF;
5712: inv_log_util.trace('l_expiration_date is:'||l_expiration_date, 'INV_LOT_API_PUB','9'); --For bug 4888300
5713:
5714: IF l_wms_installed = 'TRUE' THEN
5715: UPDATE mtl_lot_numbers
5716: SET expiration_date =

Line 10236: inv_log_util.trace('validate_quantities: Start ', g_pkg_name, 9);

10232: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10233: END IF;
10234:
10235: IF (l_debug = 1) THEN
10236: inv_log_util.trace('validate_quantities: Start ', g_pkg_name, 9);
10237: END IF;
10238:
10239: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
10240: FND_MSG_PUB.Initialize;

Line 10311: inv_log_util.trace('validate_quantities: Missing both quantities or one qty for no default item ..', g_pkg_name, 9);

10307: IF ((p_transaction_quantity IS NULL AND p_secondary_quantity IS NULL) OR
10308: (l_secondary_default_ind = 'N' AND (p_transaction_quantity IS NULL
10309: OR p_secondary_quantity IS NULL))) THEN
10310: IF (l_debug = 1) THEN
10311: inv_log_util.trace('validate_quantities: Missing both quantities or one qty for no default item ..', g_pkg_name, 9);
10312: END IF;
10313: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
10314: FND_MSG_PUB.ADD;
10315: RAISE FND_API.G_EXC_ERROR;

Line 10333: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);

10329: , to_name => NULL);
10330:
10331: IF (l_secondary_qty = -99999) THEN
10332: IF (l_debug = 1) THEN
10333: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);
10334: END IF;
10335: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10336: FND_MSG_PUB.ADD;
10337: RAISE FND_API.G_EXC_ERROR;

Line 10341: inv_log_util.trace('validate_quantities: new secondary qty is: '|| l_secondary_qty , g_pkg_name, 9);

10337: RAISE FND_API.G_EXC_ERROR;
10338: END IF;
10339: p_secondary_quantity := l_secondary_qty;
10340: IF (l_debug = 1) THEN
10341: inv_log_util.trace('validate_quantities: new secondary qty is: '|| l_secondary_qty , g_pkg_name, 9);
10342: END IF;
10343: ELSIF (p_transaction_quantity IS NULL) THEN
10344: -- Set the Qty1 from Qty2 if missing:
10345: l_transaction_quantity := INV_CONVERT.INV_UM_CONVERT

Line 10358: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT ERROR ', g_pkg_name, 9);

10354: , to_name => NULL);
10355:
10356: IF (l_transaction_quantity = -99999) THEN
10357: IF (l_debug = 1) THEN
10358: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT ERROR ', g_pkg_name, 9);
10359: END IF;
10360: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10361: FND_MSG_PUB.ADD;
10362: RAISE FND_API.G_EXC_ERROR;

Line 10366: inv_log_util.trace('validate_quantities: new transaction qty is: '|| l_transaction_quantity , g_pkg_name, 9);

10362: RAISE FND_API.G_EXC_ERROR;
10363: END IF;
10364: p_transaction_quantity := l_transaction_quantity;
10365: IF (l_debug = 1) THEN
10366: inv_log_util.trace('validate_quantities: new transaction qty is: '|| l_transaction_quantity , g_pkg_name, 9);
10367: END IF;
10368: ELSIF (p_transaction_quantity IS NOT NULL AND p_secondary_quantity IS NOT NULL) THEN
10369: IF (l_debug = 1) THEN
10370: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);

Line 10370: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);

10366: inv_log_util.trace('validate_quantities: new transaction qty is: '|| l_transaction_quantity , g_pkg_name, 9);
10367: END IF;
10368: ELSIF (p_transaction_quantity IS NOT NULL AND p_secondary_quantity IS NOT NULL) THEN
10369: IF (l_debug = 1) THEN
10370: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);
10371: END IF;
10372: -- Validate the quantitioes within deviation :
10373: l_are_qties_valid := INV_CONVERT.within_deviation(
10374: p_organization_id => p_organization_id

Line 10385: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);

10381: , p_uom_code2 => p_secondary_uom_code);
10382:
10383: IF (l_are_qties_valid = 0) THEN
10384: IF (l_debug = 1) THEN
10385: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);
10386: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10387: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10388: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10389: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);

Line 10386: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||

10382:
10383: IF (l_are_qties_valid = 0) THEN
10384: IF (l_debug = 1) THEN
10385: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);
10386: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10387: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10388: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10389: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);
10390: inv_log_util.trace(' p_lot_number: ' || p_lot_number || ' p_inventory_item_id: '||

Line 10388: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||

10384: IF (l_debug = 1) THEN
10385: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);
10386: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10387: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10388: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10389: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);
10390: inv_log_util.trace(' p_lot_number: ' || p_lot_number || ' p_inventory_item_id: '||
10391: p_inventory_item_id || ' p_organization_id: ' || p_organization_id, g_pkg_name, 9);
10392: END IF;

Line 10390: inv_log_util.trace(' p_lot_number: ' || p_lot_number || ' p_inventory_item_id: '||

10386: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10387: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10388: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10389: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);
10390: inv_log_util.trace(' p_lot_number: ' || p_lot_number || ' p_inventory_item_id: '||
10391: p_inventory_item_id || ' p_organization_id: ' || p_organization_id, g_pkg_name, 9);
10392: END IF;
10393: RAISE FND_API.G_EXC_ERROR;
10394: END IF;

Line 10396: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (PASS)' , g_pkg_name, 9);

10392: END IF;
10393: RAISE FND_API.G_EXC_ERROR;
10394: END IF;
10395: IF (l_debug = 1) THEN
10396: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (PASS)' , g_pkg_name, 9);
10397: END IF;
10398: END IF;--}
10399: END IF;--} -- l_tracking_quantity_ind != 'P'
10400: -- Set the prim Qty from transaction Qty if missing:

Line 10416: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);

10412: , to_name => NULL);
10413:
10414: IF (l_primary_quantity = -99999) THEN
10415: IF (l_debug = 1) THEN
10416: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);
10417: END IF;
10418: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10419: FND_MSG_PUB.ADD;
10420: RAISE FND_API.G_EXC_ERROR;

Line 10424: inv_log_util.trace('validate_quantities: new primary qty is: '|| l_primary_quantity , g_pkg_name, 9);

10420: RAISE FND_API.G_EXC_ERROR;
10421: END IF;
10422: p_primary_quantity := l_primary_quantity;
10423: IF (l_debug = 1) THEN
10424: inv_log_util.trace('validate_quantities: new primary qty is: '|| l_primary_quantity , g_pkg_name, 9);
10425: END IF;
10426: END IF;--} -- primary_quantity check
10427:
10428: -- Lot Indivisible Validation:

Line 10452: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (ERROR)', g_pkg_name, 9);

10448:
10449: IF (NOT l_lot_indiv_trx_valid) THEN
10450: -- the transaction is not valid regarding lot indivisible:
10451: IF (l_debug = 1) THEN
10452: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (ERROR)', g_pkg_name, 9);
10453: END IF;
10454: RAISE FND_API.G_EXC_ERROR;
10455: END IF;
10456: IF (l_debug = 1) THEN

Line 10457: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (PASS) ', g_pkg_name, 9);

10453: END IF;
10454: RAISE FND_API.G_EXC_ERROR;
10455: END IF;
10456: IF (l_debug = 1) THEN
10457: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (PASS) ', g_pkg_name, 9);
10458: END IF;
10459:
10460: END IF;--} -- l_lot_divisible_flag = 'N'
10461:

Line 10463: inv_log_util.trace('validate_quantities: End .... ', g_pkg_name, 9);

10459:
10460: END IF;--} -- l_lot_divisible_flag = 'N'
10461:
10462: IF (l_debug = 1) THEN
10463: inv_log_util.trace('validate_quantities: End .... ', g_pkg_name, 9);
10464: END IF;
10465:
10466: RETURN TRUE;
10467:

Line 10472: inv_log_util.trace('validate_quantities: FND_API.G_EXC_ERROR ', g_pkg_name, 9);

10468: EXCEPTION
10469: WHEN FND_API.G_EXC_ERROR THEN
10470: x_return_status := FND_API.G_RET_STS_ERROR;
10471: IF (l_debug = 1) THEN
10472: inv_log_util.trace('validate_quantities: FND_API.G_EXC_ERROR ', g_pkg_name, 9);
10473: END IF;
10474: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
10475: RETURN FALSE;
10476:

Line 10480: inv_log_util.trace('validate_quantities:when unexp sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name, 9);

10476:
10477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10479: IF (l_debug = 1) THEN
10480: inv_log_util.trace('validate_quantities:when unexp sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name, 9);
10481: END IF;
10482: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
10483: RETURN FALSE;
10484:

Line 10488: inv_log_util.trace('validate_quantities:when others sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name, 9);

10484:
10485: WHEN OTHERS THEN
10486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10487: IF (l_debug = 1) THEN
10488: inv_log_util.trace('validate_quantities:when others sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name, 9);
10489: END IF;
10490: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
10491: RETURN FALSE;
10492: