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 1088: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');

1084: EXCEPTION
1085: when no_data_found THEN
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF (l_debug = 1) THEN
1088: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
1089: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
1090: END IF;
1091: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1092: when others then

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

1085: when no_data_found THEN
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF (l_debug = 1) THEN
1088: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
1089: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
1090: END IF;
1091: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1092: when others then
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1091: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1092: when others then
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: IF (l_debug = 1) THEN
1095: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
1096: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
1097: END IF;
1098: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1099:

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

1092: when others then
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: IF (l_debug = 1) THEN
1095: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
1096: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
1097: END IF;
1098: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1099:
1100: end;

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

5870: END IF;
5871: IF g_debug = 1 THEN
5872: print_debug('Updating MTL_LOT_NUMBERS table ....' , 9);
5873: END IF;
5874: inv_log_util.trace('l_expiration_date is:'||l_expiration_date, 'INV_LOT_API_PUB','9'); --For bug 4888300
5875:
5876: --Fixed for bug#7529468
5877: --added two column in update statement
5878: --LAST_UPDATE_DATE and LAST_UPDATED_BY

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

10709: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10710: END IF;
10711:
10712: IF (l_debug = 1) THEN
10713: inv_log_util.trace('validate_quantities: Start ', g_pkg_name, 9);
10714: END IF;
10715:
10716: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
10717: FND_MSG_PUB.Initialize;

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

10784: IF ((p_transaction_quantity IS NULL AND p_secondary_quantity IS NULL) OR
10785: (l_secondary_default_ind = 'N' AND (p_transaction_quantity IS NULL
10786: OR p_secondary_quantity IS NULL))) THEN
10787: IF (l_debug = 1) THEN
10788: inv_log_util.trace('validate_quantities: Missing both quantities or one qty for no default item ..', g_pkg_name, 9);
10789: END IF;
10790: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
10791: FND_MSG_PUB.ADD;
10792: RAISE FND_API.G_EXC_ERROR;

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

10806: , to_name => NULL);
10807:
10808: IF (l_secondary_qty = -99999) THEN
10809: IF (l_debug = 1) THEN
10810: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);
10811: END IF;
10812: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10813: FND_MSG_PUB.ADD;
10814: RAISE FND_API.G_EXC_ERROR;

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

10814: RAISE FND_API.G_EXC_ERROR;
10815: END IF;
10816: p_secondary_quantity := l_secondary_qty;
10817: IF (l_debug = 1) THEN
10818: inv_log_util.trace('validate_quantities: new secondary qty is: '|| l_secondary_qty , g_pkg_name, 9);
10819: END IF;
10820: ELSIF (p_transaction_quantity IS NULL) THEN
10821: -- Set the Qty1 from Qty2 if missing:
10822: l_transaction_quantity := INV_CONVERT.INV_UM_CONVERT

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

10831: , to_name => NULL);
10832:
10833: IF (l_transaction_quantity = -99999) THEN
10834: IF (l_debug = 1) THEN
10835: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT ERROR ', g_pkg_name, 9);
10836: END IF;
10837: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10838: FND_MSG_PUB.ADD;
10839: RAISE FND_API.G_EXC_ERROR;

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

10839: RAISE FND_API.G_EXC_ERROR;
10840: END IF;
10841: p_transaction_quantity := l_transaction_quantity;
10842: IF (l_debug = 1) THEN
10843: inv_log_util.trace('validate_quantities: new transaction qty is: '|| l_transaction_quantity , g_pkg_name, 9);
10844: END IF;
10845: ELSIF (p_transaction_quantity IS NOT NULL AND p_secondary_quantity IS NOT NULL) THEN
10846: IF (l_debug = 1) THEN
10847: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);

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

10843: inv_log_util.trace('validate_quantities: new transaction qty is: '|| l_transaction_quantity , g_pkg_name, 9);
10844: END IF;
10845: ELSIF (p_transaction_quantity IS NOT NULL AND p_secondary_quantity IS NOT NULL) THEN
10846: IF (l_debug = 1) THEN
10847: inv_log_util.trace('validate_quantities: calling INV_CONVERT.WITHIN_DEVIATION', g_pkg_name, 9);
10848: END IF;
10849: -- Validate the quantitioes within deviation :
10850: l_are_qties_valid := INV_CONVERT.within_deviation(
10851: p_organization_id => p_organization_id

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

10858: , p_uom_code2 => p_secondary_uom_code);
10859:
10860: IF (l_are_qties_valid = 0) THEN
10861: IF (l_debug = 1) THEN
10862: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);
10863: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10864: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10865: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10866: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);

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

10859:
10860: IF (l_are_qties_valid = 0) THEN
10861: IF (l_debug = 1) THEN
10862: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);
10863: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10864: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10865: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10866: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);
10867: inv_log_util.trace(' p_lot_number: ' || p_lot_number || ' p_inventory_item_id: '||

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

10861: IF (l_debug = 1) THEN
10862: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (ERROR)' , g_pkg_name, 9);
10863: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10864: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10865: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10866: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);
10867: inv_log_util.trace(' p_lot_number: ' || p_lot_number || ' p_inventory_item_id: '||
10868: p_inventory_item_id || ' p_organization_id: ' || p_organization_id, g_pkg_name, 9);
10869: END IF;

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

10863: inv_log_util.trace('p_transaction_quantity: ' || p_transaction_quantity ||
10864: ' p_transaction_uom_code: ' || p_transaction_uom_code, g_pkg_name, 9);
10865: inv_log_util.trace(' p_secondary_quantity: ' || p_secondary_quantity ||
10866: ' p_secondary_uom_code: ' || p_secondary_uom_code, g_pkg_name, 9);
10867: inv_log_util.trace(' p_lot_number: ' || p_lot_number || ' p_inventory_item_id: '||
10868: p_inventory_item_id || ' p_organization_id: ' || p_organization_id, g_pkg_name, 9);
10869: END IF;
10870: RAISE FND_API.G_EXC_ERROR;
10871: END IF;

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

10869: END IF;
10870: RAISE FND_API.G_EXC_ERROR;
10871: END IF;
10872: IF (l_debug = 1) THEN
10873: inv_log_util.trace('validate_quantities: INV_CONVERT.within_deviation (PASS)' , g_pkg_name, 9);
10874: END IF;
10875: END IF;--}
10876: END IF;--} -- l_tracking_quantity_ind != 'P'
10877: -- Set the prim Qty from transaction Qty if missing:

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

10889: , to_name => NULL);
10890:
10891: IF (l_primary_quantity = -99999) THEN
10892: IF (l_debug = 1) THEN
10893: inv_log_util.trace('validate_quantities: INV_CONVERT.INV_UM_CONVERT error ', g_pkg_name, 9);
10894: END IF;
10895: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
10896: FND_MSG_PUB.ADD;
10897: RAISE FND_API.G_EXC_ERROR;

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

10897: RAISE FND_API.G_EXC_ERROR;
10898: END IF;
10899: p_primary_quantity := l_primary_quantity;
10900: IF (l_debug = 1) THEN
10901: inv_log_util.trace('validate_quantities: new primary qty is: '|| l_primary_quantity , g_pkg_name, 9);
10902: END IF;
10903: END IF;--} -- primary_quantity check
10904:
10905: -- Lot Indivisible Validation:

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

10925:
10926: IF (NOT l_lot_indiv_trx_valid) THEN
10927: -- the transaction is not valid regarding lot indivisible:
10928: IF (l_debug = 1) THEN
10929: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (ERROR)', g_pkg_name, 9);
10930: END IF;
10931: RAISE FND_API.G_EXC_ERROR;
10932: END IF;
10933: IF (l_debug = 1) THEN

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

10930: END IF;
10931: RAISE FND_API.G_EXC_ERROR;
10932: END IF;
10933: IF (l_debug = 1) THEN
10934: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (PASS) ', g_pkg_name, 9);
10935: END IF;
10936:
10937: END IF;--} -- l_lot_divisible_flag = 'N'
10938:

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

10936:
10937: END IF;--} -- l_lot_divisible_flag = 'N'
10938:
10939: IF (l_debug = 1) THEN
10940: inv_log_util.trace('validate_quantities: End .... ', g_pkg_name, 9);
10941: END IF;
10942:
10943: RETURN TRUE;
10944:

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

10945: EXCEPTION
10946: WHEN FND_API.G_EXC_ERROR THEN
10947: x_return_status := FND_API.G_RET_STS_ERROR;
10948: IF (l_debug = 1) THEN
10949: inv_log_util.trace('validate_quantities: FND_API.G_EXC_ERROR ', g_pkg_name, 9);
10950: END IF;
10951: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
10952: RETURN FALSE;
10953:

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

10953:
10954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10956: IF (l_debug = 1) THEN
10957: inv_log_util.trace('validate_quantities:when unexp sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name, 9);
10958: END IF;
10959: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
10960: RETURN FALSE;
10961:

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

10961:
10962: WHEN OTHERS THEN
10963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10964: IF (l_debug = 1) THEN
10965: inv_log_util.trace('validate_quantities:when others sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name, 9);
10966: END IF;
10967: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
10968: RETURN FALSE;
10969:

Line 11017: inv_log_util.trace('lot_UOM_conv_OrgTxf: inside proc ', g_pkg_name,9);

11013: l_lot_rec check_lot_exists%rowtype;
11014:
11015: BEGIN
11016: IF (l_debug = 1) THEN
11017: inv_log_util.trace('lot_UOM_conv_OrgTxf: inside proc ', g_pkg_name,9);
11018: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_organization_id '||p_organization_id, g_pkg_name,9);
11019: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_inventory_item_id '||p_inventory_item_id, g_pkg_name,9) ;
11020: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_xfr_organization_id '||p_xfr_organization_id, g_pkg_name,9) ;
11021: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_lot_number '||p_lot_number, g_pkg_name,9) ;

Line 11018: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_organization_id '||p_organization_id, g_pkg_name,9);

11014:
11015: BEGIN
11016: IF (l_debug = 1) THEN
11017: inv_log_util.trace('lot_UOM_conv_OrgTxf: inside proc ', g_pkg_name,9);
11018: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_organization_id '||p_organization_id, g_pkg_name,9);
11019: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_inventory_item_id '||p_inventory_item_id, g_pkg_name,9) ;
11020: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_xfr_organization_id '||p_xfr_organization_id, g_pkg_name,9) ;
11021: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_lot_number '||p_lot_number, g_pkg_name,9) ;
11022: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_transaction_temp_id '||p_transaction_temp_id, g_pkg_name,9) ;

Line 11019: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_inventory_item_id '||p_inventory_item_id, g_pkg_name,9) ;

11015: BEGIN
11016: IF (l_debug = 1) THEN
11017: inv_log_util.trace('lot_UOM_conv_OrgTxf: inside proc ', g_pkg_name,9);
11018: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_organization_id '||p_organization_id, g_pkg_name,9);
11019: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_inventory_item_id '||p_inventory_item_id, g_pkg_name,9) ;
11020: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_xfr_organization_id '||p_xfr_organization_id, g_pkg_name,9) ;
11021: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_lot_number '||p_lot_number, g_pkg_name,9) ;
11022: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_transaction_temp_id '||p_transaction_temp_id, g_pkg_name,9) ;
11023: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_to_UOM_code '||p_to_UOM_code, g_pkg_name,9) ;

Line 11020: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_xfr_organization_id '||p_xfr_organization_id, g_pkg_name,9) ;

11016: IF (l_debug = 1) THEN
11017: inv_log_util.trace('lot_UOM_conv_OrgTxf: inside proc ', g_pkg_name,9);
11018: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_organization_id '||p_organization_id, g_pkg_name,9);
11019: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_inventory_item_id '||p_inventory_item_id, g_pkg_name,9) ;
11020: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_xfr_organization_id '||p_xfr_organization_id, g_pkg_name,9) ;
11021: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_lot_number '||p_lot_number, g_pkg_name,9) ;
11022: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_transaction_temp_id '||p_transaction_temp_id, g_pkg_name,9) ;
11023: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_to_UOM_code '||p_to_UOM_code, g_pkg_name,9) ;
11024: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_from_UOM_code '||p_from_UOM_code, g_pkg_name,9) ;

Line 11021: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_lot_number '||p_lot_number, g_pkg_name,9) ;

11017: inv_log_util.trace('lot_UOM_conv_OrgTxf: inside proc ', g_pkg_name,9);
11018: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_organization_id '||p_organization_id, g_pkg_name,9);
11019: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_inventory_item_id '||p_inventory_item_id, g_pkg_name,9) ;
11020: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_xfr_organization_id '||p_xfr_organization_id, g_pkg_name,9) ;
11021: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_lot_number '||p_lot_number, g_pkg_name,9) ;
11022: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_transaction_temp_id '||p_transaction_temp_id, g_pkg_name,9) ;
11023: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_to_UOM_code '||p_to_UOM_code, g_pkg_name,9) ;
11024: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_from_UOM_code '||p_from_UOM_code, g_pkg_name,9) ;
11025: END IF ;

Line 11022: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_transaction_temp_id '||p_transaction_temp_id, g_pkg_name,9) ;

11018: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_organization_id '||p_organization_id, g_pkg_name,9);
11019: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_inventory_item_id '||p_inventory_item_id, g_pkg_name,9) ;
11020: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_xfr_organization_id '||p_xfr_organization_id, g_pkg_name,9) ;
11021: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_lot_number '||p_lot_number, g_pkg_name,9) ;
11022: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_transaction_temp_id '||p_transaction_temp_id, g_pkg_name,9) ;
11023: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_to_UOM_code '||p_to_UOM_code, g_pkg_name,9) ;
11024: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_from_UOM_code '||p_from_UOM_code, g_pkg_name,9) ;
11025: END IF ;
11026:

Line 11023: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_to_UOM_code '||p_to_UOM_code, g_pkg_name,9) ;

11019: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_inventory_item_id '||p_inventory_item_id, g_pkg_name,9) ;
11020: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_xfr_organization_id '||p_xfr_organization_id, g_pkg_name,9) ;
11021: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_lot_number '||p_lot_number, g_pkg_name,9) ;
11022: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_transaction_temp_id '||p_transaction_temp_id, g_pkg_name,9) ;
11023: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_to_UOM_code '||p_to_UOM_code, g_pkg_name,9) ;
11024: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_from_UOM_code '||p_from_UOM_code, g_pkg_name,9) ;
11025: END IF ;
11026:
11027:

Line 11024: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_from_UOM_code '||p_from_UOM_code, g_pkg_name,9) ;

11020: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_xfr_organization_id '||p_xfr_organization_id, g_pkg_name,9) ;
11021: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_lot_number '||p_lot_number, g_pkg_name,9) ;
11022: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_transaction_temp_id '||p_transaction_temp_id, g_pkg_name,9) ;
11023: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_to_UOM_code '||p_to_UOM_code, g_pkg_name,9) ;
11024: inv_log_util.trace('lot_UOM_conv_OrgTxf: p_from_UOM_code '||p_from_UOM_code, g_pkg_name,9) ;
11025: END IF ;
11026:
11027:
11028: begin

Line 11046: inv_log_util.trace('lot_UOM_conv_OrgTxf: create_lot_uom_conversion '||l_create_lot_uom_conversion, g_pkg_name,9);

11042: WHEN No_Data_Found THEN
11043: l_create_lot_uom_conversion:=NULL;
11044: END;
11045: IF (l_debug = 1) THEN
11046: inv_log_util.trace('lot_UOM_conv_OrgTxf: create_lot_uom_conversion '||l_create_lot_uom_conversion, g_pkg_name,9);
11047: END IF ;
11048:
11049: BEGIN
11050: SELECT uom_code INTO l_to_UOM_code

Line 11073: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_to_UOM_code '||l_to_UOM_code, g_pkg_name,9);

11069: WHEN No_Data_Found THEN
11070: l_to_UOM_code:=p_from_UOM_code;
11071: END;
11072: IF (l_debug = 1) THEN
11073: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_to_UOM_code '||l_to_UOM_code, g_pkg_name,9);
11074: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_from_UOM_code '||l_from_UOM_code, g_pkg_name,9);
11075:
11076: END IF ;
11077:

Line 11074: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_from_UOM_code '||l_from_UOM_code, g_pkg_name,9);

11070: l_to_UOM_code:=p_from_UOM_code;
11071: END;
11072: IF (l_debug = 1) THEN
11073: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_to_UOM_code '||l_to_UOM_code, g_pkg_name,9);
11074: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_from_UOM_code '||l_from_UOM_code, g_pkg_name,9);
11075:
11076: END IF ;
11077:
11078:

Line 11081: inv_log_util.trace('lot_UOM_conv_OrgTxf: first IF', g_pkg_name,9);

11077:
11078:
11079: IF (l_create_lot_uom_conversion =1 OR l_create_lot_uom_conversion=3) THEN
11080: IF (l_debug = 1) THEN
11081: inv_log_util.trace('lot_UOM_conv_OrgTxf: first IF', g_pkg_name,9);
11082: END IF ;
11083: OPEN c_check_exists(p_xfr_organization_id,l_to_UOM_code,l_from_UOM_code);
11084: FETCH c_check_exists into l_value;
11085: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_value'||l_value, g_pkg_name,9);

Line 11085: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_value'||l_value, g_pkg_name,9);

11081: inv_log_util.trace('lot_UOM_conv_OrgTxf: first IF', g_pkg_name,9);
11082: END IF ;
11083: OPEN c_check_exists(p_xfr_organization_id,l_to_UOM_code,l_from_UOM_code);
11084: FETCH c_check_exists into l_value;
11085: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_value'||l_value, g_pkg_name,9);
11086: IF c_check_exists%FOUND THEN
11087:
11088: IF (l_debug = 1) THEN
11089: inv_log_util.trace('lot_UOM_conv_OrgTxf: cursor c_check_exists found', g_pkg_name,9);

Line 11089: inv_log_util.trace('lot_UOM_conv_OrgTxf: cursor c_check_exists found', g_pkg_name,9);

11085: inv_log_util.trace('lot_UOM_conv_OrgTxf: l_value'||l_value, g_pkg_name,9);
11086: IF c_check_exists%FOUND THEN
11087:
11088: IF (l_debug = 1) THEN
11089: inv_log_util.trace('lot_UOM_conv_OrgTxf: cursor c_check_exists found', g_pkg_name,9);
11090: END IF ;
11091:
11092: OPEN check_lot_exists(p_organization_id);
11093: FETCH check_lot_exists INTO l_lot_rec;

Line 11096: inv_log_util.trace('lot_UOM_conv_OrgTxf: checking check_lot_exists ', g_pkg_name,9);

11092: OPEN check_lot_exists(p_organization_id);
11093: FETCH check_lot_exists INTO l_lot_rec;
11094:
11095: IF (l_debug = 1) THEN
11096: inv_log_util.trace('lot_UOM_conv_OrgTxf: checking check_lot_exists ', g_pkg_name,9);
11097: END IF ;
11098:
11099: IF check_lot_exists%FOUND THEN
11100: CLOSE c_check_exists;

Line 11103: inv_log_util.trace('lot_UOM_conv_OrgTxf: cursor check_lot_exists found', g_pkg_name,9);

11099: IF check_lot_exists%FOUND THEN
11100: CLOSE c_check_exists;
11101:
11102: IF (l_debug = 1) THEN
11103: inv_log_util.trace('lot_UOM_conv_OrgTxf: cursor check_lot_exists found', g_pkg_name,9);
11104: END IF;
11105:
11106: OPEN c_check_exists(p_organization_id,l_to_UOM_code,l_from_UOM_code);
11107: FETCH c_check_exists into l_value;

Line 11111: inv_log_util.trace('lot_UOM_conv_OrgTxf: 1', g_pkg_name,9);

11107: FETCH c_check_exists into l_value;
11108: IF c_check_exists%NOTFOUND THEN
11109:
11110: IF (l_debug = 1) THEN
11111: inv_log_util.trace('lot_UOM_conv_OrgTxf: 1', g_pkg_name,9);
11112: END IF;
11113:
11114: create_lot_UOM_conv_orgtxf(
11115: p_organization_id => p_organization_id

Line 11130: inv_log_util.trace('lot_UOM_conv_OrgTxf: in else', g_pkg_name,9);

11126: CLOSE check_lot_exists;
11127: ELSIF check_lot_exists%NOTFOUND THEN
11128:
11129: IF (l_debug = 1) THEN
11130: inv_log_util.trace('lot_UOM_conv_OrgTxf: in else', g_pkg_name,9);
11131: END IF;
11132:
11133: begin
11134: SELECT EXPIRATION_DATE INTO l_expiration_date FROM MTL_LOT_NUMBERS

Line 11143: inv_log_util.trace('lot_UOM_conv_OrgTxf: 2' ||l_expiration_date, g_pkg_name,9);

11139: WHEN No_Data_Found THEN
11140: l_expiration_date:=NULL;
11141: END;
11142: IF (l_debug = 1) THEN
11143: inv_log_util.trace('lot_UOM_conv_OrgTxf: 2' ||l_expiration_date, g_pkg_name,9);
11144: END IF;
11145: inv_lot_api_pub.insertlot(
11146: p_api_version => 1.0
11147: , p_init_msg_list => fnd_api.g_false

Line 11164: inv_log_util.trace('Lot insertion failed. ',g_pkg_name,9);

11160: , x_msg_data => x_msg_data
11161: );
11162: IF x_return_status <> FND_API.g_ret_sts_success THEN
11163: IF (l_debug = 1) THEN
11164: inv_log_util.trace('Lot insertion failed. ',g_pkg_name,9);
11165: END IF;
11166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11167: END IF;
11168: IF (l_debug = 1) THEN

Line 11169: inv_log_util.trace('lot_UOM_conv_OrgTxf: 3', g_pkg_name,9);

11165: END IF;
11166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11167: END IF;
11168: IF (l_debug = 1) THEN
11169: inv_log_util.trace('lot_UOM_conv_OrgTxf: 3', g_pkg_name,9);
11170: END IF;
11171: create_lot_UOM_conv_orgtxf(
11172: p_organization_id => p_organization_id
11173: , p_inventory_item_id => p_inventory_item_id

Line 11186: inv_log_util.trace('lot_UOM_conv_OrgTxf: end', g_pkg_name,9);

11182: END IF;
11183: END IF;
11184: END IF;
11185: IF (l_debug = 1) THEN
11186: inv_log_util.trace('lot_UOM_conv_OrgTxf: end', g_pkg_name,9);
11187: END IF;
11188:
11189: x_return_status := FND_API.G_RET_STS_SUCCESS;
11190:

Line 11195: inv_log_util.trace('lot_UOM_conv_OrgTxf: FND_API.G_EXC_ERROR ', g_pkg_name,9);

11191: EXCEPTION
11192: WHEN FND_API.G_EXC_ERROR THEN
11193: x_return_status := FND_API.G_RET_STS_ERROR;
11194: IF (l_debug = 1) THEN
11195: inv_log_util.trace('lot_UOM_conv_OrgTxf: FND_API.G_EXC_ERROR ', g_pkg_name,9);
11196: END IF;
11197: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
11198:
11199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

11198:
11199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11201: IF (l_debug = 1) THEN
11202: inv_log_util.trace('lot_UOM_conv_OrgTxf:when unexp sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name,9);
11203: END IF;
11204: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
11205:
11206: WHEN OTHERS THEN

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

11205:
11206: WHEN OTHERS THEN
11207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11208: IF (l_debug = 1) THEN
11209: inv_log_util.trace('lot_UOM_conv_OrgTxf:when others sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name,9);
11210: END IF;
11211: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
11212: END lot_UOM_conv_OrgTxf;
11213:

Line 11238: inv_log_util.trace('create_lot_UOM_conv_orgtxf: start ', g_pkg_name, 9);

11234: FROM FND_DUAL;
11235:
11236: BEGIN
11237: --IF (l_debug = 1) THEN
11238: inv_log_util.trace('create_lot_UOM_conv_orgtxf: start ', g_pkg_name, 9);
11239: --END IF;
11240: OPEN GET_CONV_SEQ;
11241: FETCH GET_CONV_SEQ INTO l_conv_seq;
11242: CLOSE GET_CONV_SEQ;

Line 11300: inv_log_util.trace('create_lot_UOM_conv_orgtxf: end ', g_pkg_name, 9);

11296: AND FROM_UOM_CODE=p_from_UOM_code ;
11297:
11298: x_return_status := FND_API.G_RET_STS_SUCCESS;
11299: --IF (l_debug = 1) THEN
11300: inv_log_util.trace('create_lot_UOM_conv_orgtxf: end ', g_pkg_name, 9);
11301: --END IF;
11302: EXCEPTION
11303: WHEN FND_API.G_EXC_ERROR THEN
11304: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11306: inv_log_util.trace('create_lot_UOM_conv_orgtxf: FND_API.G_EXC_ERROR ', g_pkg_name,9);

11302: EXCEPTION
11303: WHEN FND_API.G_EXC_ERROR THEN
11304: x_return_status := FND_API.G_RET_STS_ERROR;
11305: IF (l_debug = 1) THEN
11306: inv_log_util.trace('create_lot_UOM_conv_orgtxf: FND_API.G_EXC_ERROR ', g_pkg_name,9);
11307: END IF;
11308: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
11309:
11310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

11309:
11310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11312: IF (l_debug = 1) THEN
11313: inv_log_util.trace('create_lot_UOM_conv_orgtxf:when unexp sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name,9);
11314: END IF;
11315: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
11316:
11317: WHEN OTHERS THEN

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

11316:
11317: WHEN OTHERS THEN
11318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11319: IF (l_debug = 1) THEN
11320: inv_log_util.trace('create_lot_UOM_conv_orgtxf:when others sqlcode= '||sqlcode||' sqlerrm= '||substr(sqlerrm,1,240), g_pkg_name,9);
11321: END IF;
11322: FND_MSG_PUB.Count_AND_GET (p_count => x_msg_count, p_data => x_msg_data);
11323:
11324: