DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on SERIAL_CHECK

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

11813: -- End of changes for 3782838
11814:
11815: -- bug 2740681
11816: IF l_debug_on THEN
11817: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_Unmark_Serial');
11818: WSH_DEBUG_SV.log(l_module_name,'l_new_sn,l_new_to_sn,inventory_item_id', l_new_sn
11819: ||','||l_new_to_sn
11820: ||','||x_old_detail_rec.inventory_item_id);
11821: END IF;

Line 11822: Serial_Check.Inv_Unmark_Serial(

11818: WSH_DEBUG_SV.log(l_module_name,'l_new_sn,l_new_to_sn,inventory_item_id', l_new_sn
11819: ||','||l_new_to_sn
11820: ||','||x_old_detail_rec.inventory_item_id);
11821: END IF;
11822: Serial_Check.Inv_Unmark_Serial(
11823: l_new_sn,
11824: l_new_to_sn,
11825: NULL,
11826: NULL,

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

11828: NULL,
11829: x_old_detail_rec.inventory_item_id);
11830:
11831: IF l_debug_on THEN
11832: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');
11833: END IF;
11834: IF l_debug_on THEN
11835: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');
11836: WSH_DEBUG_SV.log(l_module_name,'l_new_sn',l_new_sn);

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

11831: IF l_debug_on THEN
11832: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');
11833: END IF;
11834: IF l_debug_on THEN
11835: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');
11836: WSH_DEBUG_SV.log(l_module_name,'l_new_sn',l_new_sn);
11837: WSH_DEBUG_SV.log(l_module_name,'l_new_to_sn',l_new_to_sn);
11838: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id',x_old_detail_rec.inventory_item_id);
11839: WSH_DEBUG_SV.log(l_module_name,'organization_id',x_old_detail_rec.organization_id);

Line 11846: Serial_Check.Inv_Mark_Serial(

11842: WSH_DEBUG_SV.log(l_module_name,'source_line_id',x_old_detail_rec.source_line_id);
11843: END IF;
11844: --RTV Changes
11845: IF x_old_detail_rec.source_code = 'RTV' THEN
11846: Serial_Check.Inv_Mark_Serial(
11847: l_new_sn,
11848: l_new_to_sn,
11849: x_old_detail_rec.inventory_item_id,
11850: x_old_detail_rec.organization_id,

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

11852: l_transaction_temp_id,
11853: x_old_detail_rec.source_line_id,
11854: l_success);
11855: IF l_debug_on THEN
11856: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11857: END IF;
11858: ELSE
11859: Serial_Check.Inv_Mark_Serial(
11860: l_new_sn,

Line 11859: Serial_Check.Inv_Mark_Serial(

11855: IF l_debug_on THEN
11856: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11857: END IF;
11858: ELSE
11859: Serial_Check.Inv_Mark_Serial(
11860: l_new_sn,
11861: l_new_to_sn,
11862: x_old_detail_rec.inventory_item_id,
11863: x_old_detail_rec.organization_id,

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

11865: l_transaction_temp_id,
11866: l_transaction_temp_id,
11867: l_success);
11868: IF l_debug_on THEN
11869: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11870: END IF;
11871: END IF;
11872: --RTV Changes
11873: IF l_success < 0 THEN

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

11909: WHERE rowid = c.rowid;
11910:
11911: --Bug 2740681
11912: IF l_debug_on THEN
11913: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_Unmark_Serial');
11914: 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);
11915: END IF;
11916: Serial_Check.Inv_Unmark_Serial(
11917: c.fm_serial_number,

Line 11916: Serial_Check.Inv_Unmark_Serial(

11912: IF l_debug_on THEN
11913: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_Unmark_Serial');
11914: 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);
11915: END IF;
11916: Serial_Check.Inv_Unmark_Serial(
11917: c.fm_serial_number,
11918: c.to_serial_number,
11919: NULL,
11920: NULL,

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

11921: NULL,
11922: NULL,
11923: x_old_detail_rec.inventory_item_id);
11924: IF l_debug_on THEN
11925: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');
11926: END IF;
11927: IF l_debug_on THEN
11928: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');
11929: WSH_DEBUG_SV.log(l_module_name,'fm_serial_number',c.fm_serial_number);

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

11924: IF l_debug_on THEN
11925: WSH_DEBUG_SV.logmsg(l_module_name,'After Calling Serial_Check.Inv_Unmark_Serial');
11926: END IF;
11927: IF l_debug_on THEN
11928: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Serial_Check.Inv_mark_Serial');
11929: WSH_DEBUG_SV.log(l_module_name,'fm_serial_number',c.fm_serial_number);
11930: WSH_DEBUG_SV.log(l_module_name,'to_serial_number',c.to_serial_number);
11931: WSH_DEBUG_SV.log(l_module_name,'inventory_item_id',x_old_detail_rec.inventory_item_id);
11932: WSH_DEBUG_SV.log(l_module_name,'organization_id',x_old_detail_rec.organization_id);

Line 11939: Serial_Check.Inv_Mark_Serial(

11935: WSH_DEBUG_SV.log(l_module_name,'source_line_id',x_old_detail_rec.source_line_id);
11936: END IF;
11937: --RTV Changes
11938: IF x_old_detail_rec.source_code = 'RTV' THEN
11939: Serial_Check.Inv_Mark_Serial(
11940: c.fm_serial_number,
11941: c.to_serial_number,
11942: x_old_detail_rec.inventory_item_id,
11943: x_old_detail_rec.organization_id,

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

11945: l_transaction_temp_id,
11946: x_old_detail_rec.source_line_id,
11947: l_success);
11948: IF l_debug_on THEN
11949: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11950: END IF;
11951: ELSE
11952: Serial_Check.Inv_Mark_Serial(
11953: c.fm_serial_number,

Line 11952: Serial_Check.Inv_Mark_Serial(

11948: IF l_debug_on THEN
11949: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11950: END IF;
11951: ELSE
11952: Serial_Check.Inv_Mark_Serial(
11953: c.fm_serial_number,
11954: c.to_serial_number,
11955: x_old_detail_rec.inventory_item_id,
11956: x_old_detail_rec.organization_id,

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

11958: l_transaction_temp_id,
11959: l_transaction_temp_id,
11960: l_success);
11961: IF l_debug_on THEN
11962: WSH_DEBUG_SV.log(l_module_name,'After Serial_Check.Inv_mark_Serial l_success',l_success);
11963: END IF;
11964: END IF;
11965: --RTV changes
11966: IF l_success < 0 THEN