DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on SERIAL_CHECK

Line 11386: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_Unmark_Serial');

11382: -- End of changes for 3782838
11383:
11384: -- bug 2740681
11385: IF l_debug_on THEN
11386: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_Unmark_Serial');
11387: WSH_DEBUG_SV.log(l_module_name,'l_new_sn,l_new_to_sn,inventory_item_id', l_new_sn
11388: ||','||l_new_to_sn
11389: ||','||x_old_detail_rec.inventory_item_id);
11390: END IF;

Line 11391: Serial_Check.Inv_Unmark_Serial(

11387: WSH_DEBUG_SV.log(l_module_name,'l_new_sn,l_new_to_sn,inventory_item_id', l_new_sn
11388: ||','||l_new_to_sn
11389: ||','||x_old_detail_rec.inventory_item_id);
11390: END IF;
11391: Serial_Check.Inv_Unmark_Serial(
11392: l_new_sn,
11393: l_new_to_sn,
11394: NULL,
11395: NULL,

Line 11401: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');

11397: NULL,
11398: x_old_detail_rec.inventory_item_id);
11399:
11400: IF l_debug_on THEN
11401: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');
11402: END IF;
11403:
11404: IF l_debug_on THEN
11405: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');

Line 11405: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');

11401: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');
11402: END IF;
11403:
11404: IF l_debug_on THEN
11405: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');
11406: WSH_DEBUG_SV.log(l_module_name,'l_new_sn',l_new_sn);
11407: WSH_DEBUG_SV.log(l_module_name,'l_new_to_sn',l_new_to_sn);
11408: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id',x_old_detail_rec.inventory_item_id);
11409: WSH_DEBUG_SV.log(l_module_name,'organization_id',x_old_detail_rec.organization_id);

Line 11412: Serial_Check.Inv_Mark_Serial(

11408: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id',x_old_detail_rec.inventory_item_id);
11409: WSH_DEBUG_SV.log(l_module_name,'organization_id',x_old_detail_rec.organization_id);
11410: WSH_DEBUG_SV.log(l_module_name,'l_transaction_temp_id',l_transaction_temp_id);
11411: END IF;
11412: Serial_Check.Inv_Mark_Serial(
11413: l_new_sn,
11414: l_new_to_sn,
11415: x_old_detail_rec.inventory_item_id,
11416: x_old_detail_rec.organization_id,

Line 11422: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);

11418: l_transaction_temp_id,
11419: l_transaction_temp_id,
11420: l_success);
11421: IF l_debug_on THEN
11422: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11423: END IF;
11424:
11425: IF l_success < 0 THEN
11426: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');

Line 11465: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_Unmark_Serial');

11461: WHERE rowid = c.rowid;
11462:
11463: --Bug 2740681
11464: IF l_debug_on THEN
11465: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_Unmark_Serial');
11466: WSH_DEBUG_SV.log(l_module_name,'fm_serial_number,to_serial_number,inventory_item_id', c.fm_serial_number ||','||c.to_serial_number ||','||x_old_detail_rec.inventory_item_id);
11467: END IF;
11468: Serial_Check.Inv_Unmark_Serial(
11469: c.fm_serial_number,

Line 11468: Serial_Check.Inv_Unmark_Serial(

11464: IF l_debug_on THEN
11465: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_Unmark_Serial');
11466: WSH_DEBUG_SV.log(l_module_name,'fm_serial_number,to_serial_number,inventory_item_id', c.fm_serial_number ||','||c.to_serial_number ||','||x_old_detail_rec.inventory_item_id);
11467: END IF;
11468: Serial_Check.Inv_Unmark_Serial(
11469: c.fm_serial_number,
11470: c.to_serial_number,
11471: NULL,
11472: NULL,

Line 11477: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');

11473: NULL,
11474: NULL,
11475: x_old_detail_rec.inventory_item_id);
11476: IF l_debug_on THEN
11477: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');
11478: END IF;
11479:
11480: IF l_debug_on THEN
11481: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');

Line 11481: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');

11477: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');
11478: END IF;
11479:
11480: IF l_debug_on THEN
11481: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');
11482: WSH_DEBUG_SV.log(l_module_name,'fm_serial_number',c.fm_serial_number);
11483: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',c.to_serial_number);
11484: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id',x_old_detail_rec.inventory_item_id);
11485: WSH_DEBUG_SV.log(l_module_name,'organization_id',x_old_detail_rec.organization_id);

Line 11488: Serial_Check.Inv_Mark_Serial(

11484: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id',x_old_detail_rec.inventory_item_id);
11485: WSH_DEBUG_SV.log(l_module_name,'organization_id',x_old_detail_rec.organization_id);
11486: WSH_DEBUG_SV.log(l_module_name,'l_transaction_temp_id',l_transaction_temp_id);
11487: END IF;
11488: Serial_Check.Inv_Mark_Serial(
11489: c.fm_serial_number,
11490: c.to_serial_number,
11491: x_old_detail_rec.inventory_item_id,
11492: x_old_detail_rec.organization_id,

Line 11498: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);

11494: l_transaction_temp_id,
11495: l_transaction_temp_id,
11496: l_success);
11497: IF l_debug_on THEN
11498: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11499: END IF;
11500:
11501: IF l_success < 0 THEN
11502: FND_MESSAGE.SET_NAME('WSH','WSH_SER_RANGE_MK_ERROR');