37:
38: l_start_index := p_mtl_ser_txn_if_rec.source_line_id.first;
39: l_end_index := p_mtl_ser_txn_if_rec.source_line_id.last;
40:
41: fnd_profile.get('USER_ID',g_userid);
42:
43: IF l_debug_on THEN
44: WSH_DEBUG_SV.log(l_module_name,'g_userid',g_userid);
45: WSH_DEBUG_SV.log(l_module_name,'l_start_index',l_start_index);
249: END IF;
250: RAISE WSH_FM_SERIALNO_NULL;
251: END IF;
252:
253: fnd_profile.get('USER_ID',g_userid);
254:
255: -- Set interface id if necessary
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.log(l_module_name,'USER_ID',g_userid);
441: END IF;
442:
443: END IF;
444:
445: fnd_profile.get('USER_ID',g_userid);
446:
447: UPDATE mtl_serial_numbers_interface SET
448: source_code = p_source_code,
449: source_line_id = p_source_line_id,