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.OE_LOT_SERIAL_UTIL dependencies on OE_DEBUG_PUB

Line 523: OE_DEBUG_PUB.ADD('Inside complete record',1);

519: )
520: IS
521: BEGIN
522:
523: OE_DEBUG_PUB.ADD('Inside complete record',1);
524: OE_DEBUG_PUB.ADD('The quantity is '||to_char(p_x_Lot_Serial_rec.quantity),1);
525: IF p_x_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: p_x_Lot_Serial_rec.attribute1 := p_old_Lot_Serial_rec.attribute1;
527: END IF;

Line 524: OE_DEBUG_PUB.ADD('The quantity is '||to_char(p_x_Lot_Serial_rec.quantity),1);

520: IS
521: BEGIN
522:
523: OE_DEBUG_PUB.ADD('Inside complete record',1);
524: OE_DEBUG_PUB.ADD('The quantity is '||to_char(p_x_Lot_Serial_rec.quantity),1);
525: IF p_x_Lot_Serial_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: p_x_Lot_Serial_rec.attribute1 := p_old_Lot_Serial_rec.attribute1;
527: END IF;
528:

Line 648: OE_DEBUG_PUB.ADD('The quantity is '||to_char(p_x_Lot_Serial_rec.quantity),1);

644: IF p_x_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR THEN
645: p_x_Lot_Serial_rec.to_serial_number := p_old_Lot_Serial_rec.to_serial_number;
646: END IF;
647:
648: OE_DEBUG_PUB.ADD('The quantity is '||to_char(p_x_Lot_Serial_rec.quantity),1);
649: END Complete_Record;
650:
651: -- Procedure Convert_Miss_To_Null
652:

Line 850: oe_debug_pub.add('before update, lot_serial_id= '|| l_lot_serial_rec.lot_serial_id, 1);

846: --to update global picture
847:
848: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => p_lot_serial_rec.lot_serial_id,
849: x_lot_serial_rec =>l_lot_serial_rec);
850: oe_debug_pub.add('before update, lot_serial_id= '|| l_lot_serial_rec.lot_serial_id, 1);
851: /* jolin end*/
852:
853: UPDATE OE_LOT_SERIAL_NUMBERS
854: SET ATTRIBUTE1 = p_Lot_Serial_rec.attribute1

Line 894: oe_debug_pub.add('after update, old lot serial Id= ' || l_lot_serial_rec.lot_serial_id);

890: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
891:
892: -- calling notification framework to update global picture
893:
894: oe_debug_pub.add('after update, old lot serial Id= ' || l_lot_serial_rec.lot_serial_id);
895: oe_debug_pub.add('after update, new lot serial Id= ' || p_lot_serial_rec.lot_serial_id);
896:
897: OE_ORDER_UTIL.Update_Global_Picture(
898: p_Upd_New_Rec_If_Exists => True,

Line 895: oe_debug_pub.add('after update, new lot serial Id= ' || p_lot_serial_rec.lot_serial_id);

891:
892: -- calling notification framework to update global picture
893:
894: oe_debug_pub.add('after update, old lot serial Id= ' || l_lot_serial_rec.lot_serial_id);
895: oe_debug_pub.add('after update, new lot serial Id= ' || p_lot_serial_rec.lot_serial_id);
896:
897: OE_ORDER_UTIL.Update_Global_Picture(
898: p_Upd_New_Rec_If_Exists => True,
899: p_lot_serial_rec => p_lot_serial_rec,

Line 905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);

901: p_lot_serial_id => p_lot_serial_rec.lot_serial_id,
902: x_index => l_index,
903: x_return_status => l_return_status);
904:
905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);
906:
907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);

Line 908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

904:
905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);
906:
907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');

Line 909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);

905: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.update_row is: ' || l_return_status);
906:
907: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);

Line 912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');

908: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:

Line 913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);

909: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
912: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Update_row');
913: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.Update_ROW', 1);
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:
917: -- notification framework end

Line 1031: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.insert_row is: ' || l_return_status);

1027: p_lot_serial_id => p_lot_serial_rec.lot_serial_id,
1028: x_index => l_index,
1029: x_return_status => l_return_status);
1030:
1031: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.insert_row is: ' || l_return_status);
1032: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
1033:
1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1032: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);

1028: x_index => l_index,
1029: x_return_status => l_return_status);
1030:
1031: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.insert_row is: ' || l_return_status);
1032: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
1033:
1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

Line 1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

1032: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
1033:
1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');

Line 1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);

1033:
1034:
1035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);

Line 1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');

1036: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:

Line 1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);

1037: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1040: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Insert_row');
1041: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.INSERT_ROW', 1);
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1045: -- notification framework end

Line 1132: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1128:
1129:
1130: BEGIN
1131:
1132: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1133: IF (p_line_id <> FND_API.G_MISS_NUM)
1134: THEN
1135:
1136: OE_LINE_UTIL.Query_Row(p_line_id=>p_line_id,x_line_rec=>l_line_rec);

Line 1147: oe_debug_pub.add('JPN: Line ID' || p_line_id);

1143: /* jolin start*/
1144: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
1145: --added for notification framework to update global picture for lot serials for this line_id
1146:
1147: oe_debug_pub.add('JPN: Line ID' || p_line_id);
1148: FOR l_lots IN lot_serial
1149: LOOP
1150: --query lot serial record, then call notification framework to update global picture.
1151:

Line 1155: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_lots.lot_serial_id , 1);

1151:
1152: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_lots.lot_serial_id,
1153: x_lot_serial_rec =>l_old_lot_serial_rec);
1154:
1155: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_lots.lot_serial_id , 1);
1156:
1157: /* Set the operation on the record so that globals are updated as well */
1158: l_new_lot_serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1159: l_new_lot_serial_rec.lot_serial_id :=l_lots.lot_serial_id;

Line 1169: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||

1165: p_lot_serial_id => l_lots.lot_serial_id,
1166: x_index => l_index,
1167: x_return_status => l_return_status);
1168:
1169: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1170: ' for deleting line set lot_serial line is: ' || l_return_status);
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

Line 1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

1169: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1170: ' for deleting line set lot_serial line is: ' || l_return_status);
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');

Line 1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1170: ' for deleting line set lot_serial line is: ' || l_return_status);
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

Line 1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');

1173: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181:

Line 1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1174: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1178: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181:
1182: END LOOP;

Line 1204: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_set.lot_serial_id , 1);

1200:
1201: OE_LOT_SERIAL_UTIL.Query_Row(p_lot_serial_id => l_set.lot_serial_id,
1202: x_lot_serial_rec =>l_old_lot_serial_rec);
1203:
1204: oe_debug_pub.add('in delete row, lot_serial_id= '|| l_set.lot_serial_id , 1);
1205:
1206: /* Set the operation on the record so that globals are updated as well */
1207: l_new_lot_serial_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1208: l_new_lot_serial_rec.lot_serial_id :=l_set.lot_serial_id;

Line 1218: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||

1214: p_lot_serial_id => l_set.lot_serial_id,
1215: x_index => l_index,
1216: x_return_status => l_return_status);
1217:
1218: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1219: ' for deleting line set lot_serial line is: ' || l_return_status);
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

Line 1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

1218: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LOT_SERIAL_UTIL.delete_row' ||
1219: ' for deleting line set lot_serial line is: ' || l_return_status);
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');

Line 1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1219: ' for deleting line set lot_serial line is: ' || l_return_status);
1220:
1221: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

Line 1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');

1222: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:

Line 1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);

1223: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1226: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LOT_SERIAL_UTIL.Delete_row');
1227: OE_DEBUG_PUB.ADD('Exiting OE_LOT_SERIAL_UTIL.DELETE_ROW', 1);
1228: RAISE FND_API.G_EXC_ERROR;
1229: END IF;
1230:
1231: END LOOP;

Line 1563: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.LOCK_ROW', 1);

1559: l_lot_serial_id NUMBER;
1560: l_lock_control NUMBER;
1561: BEGIN
1562:
1563: oe_debug_pub.add('Entering OE_LOT_SERIAL_UTIL.LOCK_ROW', 1);
1564:
1565: SAVEPOINT Lock_Row;
1566:
1567: l_lock_control := NULL;

Line 1583: oe_debug_pub.add('selected for update', 1);

1579: FROM oe_lot_serial_numbers
1580: WHERE lot_serial_id = l_lot_serial_id
1581: FOR UPDATE NOWAIT;
1582:
1583: oe_debug_pub.add('selected for update', 1);
1584:
1585: OE_Lot_serial_Util.Query_Row
1586: (p_lot_serial_id => l_lot_serial_id
1587: ,x_lot_serial_rec => p_x_lot_serial_rec );

Line 1634: oe_debug_pub.add('Exiting OE_Lot_serial_UTIL.LOCK_ROW', 1);

1630: END IF;
1631:
1632: END IF;
1633:
1634: oe_debug_pub.add('Exiting OE_Lot_serial_UTIL.LOCK_ROW', 1);
1635:
1636: EXCEPTION
1637:
1638: WHEN NO_DATA_FOUND THEN

Line 1696: oe_debug_pub.add('entering oe_lot_serial_util.lock_rows', 1);

1692:
1693: l_lot_serial_id NUMBER;
1694: BEGIN
1695:
1696: oe_debug_pub.add('entering oe_lot_serial_util.lock_rows', 1);
1697:
1698: IF (p_lot_serial_id IS NOT NULL AND
1699: p_lot_serial_id <> FND_API.G_MISS_NUM) AND
1700: (p_line_id IS NOT NULL AND

Line 1766: oe_debug_pub.add('exiting oe_lot_serial_util.lock_rows', 1);

1762: );
1763:
1764: x_return_status := FND_API.G_RET_STS_SUCCESS;
1765:
1766: oe_debug_pub.add('exiting oe_lot_serial_util.lock_rows', 1);
1767:
1768: EXCEPTION
1769: WHEN NO_DATA_FOUND THEN
1770: