403: l_quantity(i),
404: l_fm_serial_number(i),
405: l_to_serial_number(i),
406: sysdate,
407: FND_GLOBAL.USER_ID,
408: sysdate,
409: FND_GLOBAL.USER_ID,
410: l_attribute_category(i), -- Bug 3628620
411: l_attribute1(i), l_attribute2(i), l_attribute3(i),
405: l_to_serial_number(i),
406: sysdate,
407: FND_GLOBAL.USER_ID,
408: sysdate,
409: FND_GLOBAL.USER_ID,
410: l_attribute_category(i), -- Bug 3628620
411: l_attribute1(i), l_attribute2(i), l_attribute3(i),
412: l_attribute4(i), l_attribute5(i), l_attribute6(i),
413: l_attribute7(i), l_attribute8(i), l_attribute9(i),
1565:
1566: -- mark stop as being processed; refresh its LAST_UPDATED info.
1567: UPDATE wsh_trip_stops
1568: SET pending_interface_flag = 'P',
1569: request_id = fnd_global.conc_request_id,
1570: last_updated_by = fnd_global.user_id,
1571: last_update_date = sysdate,
1572: batch_id = l_stop_batch_id
1573: WHERE stop_id = l_stop_id;
1566: -- mark stop as being processed; refresh its LAST_UPDATED info.
1567: UPDATE wsh_trip_stops
1568: SET pending_interface_flag = 'P',
1569: request_id = fnd_global.conc_request_id,
1570: last_updated_by = fnd_global.user_id,
1571: last_update_date = sysdate,
1572: batch_id = l_stop_batch_id
1573: WHERE stop_id = l_stop_id;
1574:
1965: IF l_found THEN
1966: l_action := 'updating';
1967: UPDATE wsh_trip_stops
1968: SET pending_interface_flag = l_new_flag,
1969: last_updated_by = fnd_global.user_id,
1970: last_update_date = sysdate
1971: WHERE batch_id = l_stop_batch_id;
1972: END IF;
1973:
2152: END IF;
2153:
2154: UPDATE wsh_trip_stops wts
2155: SET wts.pending_interface_flag = 'Y',
2156: wts.last_updated_by = fnd_global.user_id,
2157: wts.last_update_date = sysdate
2158: WHERE wts.pending_interface_flag = 'P'
2159: AND EXISTS (SELECT 'request completed'
2160: FROM fnd_concurrent_requests fcr
8447: if l_process_online_msg_count > 0 then
8448: FOR i in 1 .. l_process_online_msg_count
8449: LOOP
8450: l_process_online_message := fnd_msg_pub.get(i,'T');
8451: l_process_online_message := replace(l_process_online_message,fnd_global.local_chr(0), ' ');
8452: WSH_UTIL_CORE.PrintMsg(l_process_online_message);
8453: IF l_debug_on THEN
8454: WSH_DEBUG_SV.log(l_module_name,'Error txt:',
8455: SUBSTR(l_process_online_message,1,200));