2253: VALUES (l_lane_ids(j),
2254: l_list_header_id,
2255: l_start_date,
2256: l_end_date,
2257: FND_GLOBAL.USER_ID,
2258: G_CURDATE,
2259: FND_GLOBAL.USER_ID,
2260: G_CURDATE,
2261: FND_GLOBAL.USER_ID);
2255: l_start_date,
2256: l_end_date,
2257: FND_GLOBAL.USER_ID,
2258: G_CURDATE,
2259: FND_GLOBAL.USER_ID,
2260: G_CURDATE,
2261: FND_GLOBAL.USER_ID);
2262: EXCEPTION
2263: WHEN OTHERS THEN
2257: FND_GLOBAL.USER_ID,
2258: G_CURDATE,
2259: FND_GLOBAL.USER_ID,
2260: G_CURDATE,
2261: FND_GLOBAL.USER_ID);
2262: EXCEPTION
2263: WHEN OTHERS THEN
2264: x_status := 2;
2265: FTE_UTIL_PKG.Write_LogFile(l_module_name, sqlerrm);
2274: UPDATE fte_lanes
2275: SET service_detail_flag ='Y',
2276: service_type_code = l_service_level,
2277: lane_type = NULL,
2278: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2279: LAST_UPDATE_DATE = SYSDATE,
2280: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
2281: WHERE lane_id = l_lane_ids(j);
2282:
2276: service_type_code = l_service_level,
2277: lane_type = NULL,
2278: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2279: LAST_UPDATE_DATE = SYSDATE,
2280: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
2281: WHERE lane_id = l_lane_ids(j);
2282:
2283: EXCEPTION
2284: WHEN OTHERS THEN
2375: l_prc_param_values(m),
2376: l_rate_basis_uom,
2377: l_currency,
2378: sysdate,
2379: FND_GLOBAL.User_Id,
2380: sysdate,
2381: FND_GLOBAL.User_Id,
2382: l_modifier_id);
2383: EXCEPTION
2377: l_currency,
2378: sysdate,
2379: FND_GLOBAL.User_Id,
2380: sysdate,
2381: FND_GLOBAL.User_Id,
2382: l_modifier_id);
2383: EXCEPTION
2384: WHEN OTHERS THEN
2385: x_status := 2;