eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on FND_API

Line 1017: raise FND_API.G_EXC_ERROR ;

1013: wsh_debug_sv.log (l_module_name, 'Return Status from WSH_SHIPPING_PARAMS_PVT.GET', l_return_status);
1014: END IF;
1015:
1016: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1017: raise FND_API.G_EXC_ERROR ;
1018: END IF;
1019:
1020: --If any of the delivery grouping attribute is enabled copy the grouping attributes from delivery to delivery line
1021: IF (l_shipping_param_info.GROUP_BY_SHIP_METHOD_FLAG = 'Y' or

Line 1041: raise FND_API.G_EXC_ERROR ;

1037: wsh_debug_sv.log (l_module_name, 'Return Status from WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD', l_return_status);
1038: END IF;
1039:
1040: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1041: raise FND_API.G_EXC_ERROR ;
1042: END IF;
1043:
1044: IF l_shipping_param_info.GROUP_BY_SHIP_METHOD_FLAG = 'Y' THEN
1045: --{

Line 1135: p_init_msg_list => FND_API.G_FALSE,

1131: l_detail_in_rec.action_code := 'CREATE';
1132:
1133: WSH_INTERFACE_GRP.Create_Update_Delivery_Detail(
1134: p_api_version_number => l_api_version,
1135: p_init_msg_list => FND_API.G_FALSE,
1136: p_commit => FND_API.G_FALSE,
1137: x_return_status => l_return_status,
1138: x_msg_count => l_msg_count,
1139: x_msg_data => l_msg_data,

Line 1136: p_commit => FND_API.G_FALSE,

1132:
1133: WSH_INTERFACE_GRP.Create_Update_Delivery_Detail(
1134: p_api_version_number => l_api_version,
1135: p_init_msg_list => FND_API.G_FALSE,
1136: p_commit => FND_API.G_FALSE,
1137: x_return_status => l_return_status,
1138: x_msg_count => l_msg_count,
1139: x_msg_data => l_msg_data,
1140: p_detail_info_tab => l_detail_info_tab,

Line 1354: raise fnd_api.g_exc_error;

1350: -- Not Supported
1351: IF l_debug_on THEN
1352: wsh_debug_sv.logmsg(l_module_name,'Serial types not supported for remnant models');
1353: END IF;
1354: raise fnd_api.g_exc_error;
1355: -- Serial Number is NOT NULL
1356: ELSIF del_det_int_rec.serial_number IS NOT NULL THEN
1357: IF l_debug_on THEN
1358: wsh_debug_sv.log(l_module_name,'PNS: del_det_int_rec.inventory_item_id', del_det_int_rec.inventory_item_id);

Line 1551: WHEN FND_API.G_EXC_ERROR THEN

1547: IF l_debug_on THEN
1548: wsh_debug_sv.pop(l_module_name);
1549: END IF;
1550: EXCEPTION
1551: WHEN FND_API.G_EXC_ERROR THEN
1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FND_API.G_EXC_ERROR');

Line 1554: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1550: EXCEPTION
1551: WHEN FND_API.G_EXC_ERROR THEN
1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FND_API.G_EXC_ERROR');
1556: END IF;
1557: WHEN create_cont_instance_failed THEN
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FND_API.G_EXC_ERROR');

1551: WHEN FND_API.G_EXC_ERROR THEN
1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: FND_API.G_EXC_ERROR');
1556: END IF;
1557: WHEN create_cont_instance_failed THEN
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1559: IF l_debug_on THEN

Line 1811: RAISE fnd_api.g_exc_error;

1807: p_delivery_id => l_delivery_id,
1808: x_return_status => l_return_status);
1809:
1810: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1811: RAISE fnd_api.g_exc_error;
1812: END IF;
1813:
1814:
1815: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2') THEN

Line 1918: RAISE fnd_api.g_exc_error;

1914: p_delivery_id => l_delivery_id,
1915: x_return_status => l_return_status);
1916:
1917: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
1918: RAISE fnd_api.g_exc_error;
1919: END IF;
1920:
1921:
1922: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2') THEN

Line 2015: RAISE fnd_api.g_exc_error;

2011: p_delivery_id => l_delivery_id,
2012: x_return_status => l_return_status);
2013:
2014: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
2015: RAISE fnd_api.g_exc_error;
2016: END IF;
2017:
2018:
2019: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2') THEN

Line 2190: raise fnd_api.g_exc_error;

2186: -- Not Supported
2187: IF l_debug_on THEN
2188: wsh_debug_sv.logmsg(l_module_name,'Serial types not supported for remnant models');
2189: END IF;
2190: raise fnd_api.g_exc_error;
2191: END IF; --}
2192: END IF;
2193:
2194: <>

Line 2286: RAISE fnd_api.g_exc_error;

2282: p_delivery_id => l_delivery_id,
2283: x_return_status => l_return_status);
2284:
2285: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
2286: RAISE fnd_api.g_exc_error;
2287: END IF;
2288:
2289:
2290: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2') THEN

Line 2383: RAISE fnd_api.g_exc_error;

2379: p_delivery_id => l_delivery_id,
2380: x_return_status => l_return_status);
2381:
2382: IF (l_return_status <> wsh_util_core.g_ret_sts_success) THEN
2383: RAISE fnd_api.g_exc_error;
2384: END IF;
2385:
2386:
2387: IF (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, '!') = 'TW2') THEN

Line 2487: WHEN fnd_api.g_exc_error THEN

2483: wsh_debug_sv.pop(l_module_name);
2484: END IF;
2485:
2486: EXCEPTION
2487: WHEN fnd_api.g_exc_error THEN
2488: x_return_status := fnd_api.g_ret_sts_error;
2489: --
2490: IF l_debug_on THEN
2491: wsh_debug_sv.logmsg(l_module_name,

Line 2488: x_return_status := fnd_api.g_ret_sts_error;

2484: END IF;
2485:
2486: EXCEPTION
2487: WHEN fnd_api.g_exc_error THEN
2488: x_return_status := fnd_api.g_ret_sts_error;
2489: --
2490: IF l_debug_on THEN
2491: wsh_debug_sv.logmsg(l_module_name,
2492: 'FND_API.G_EXC_ERROR exception has occured.',

Line 2492: 'FND_API.G_EXC_ERROR exception has occured.',

2488: x_return_status := fnd_api.g_ret_sts_error;
2489: --
2490: IF l_debug_on THEN
2491: wsh_debug_sv.logmsg(l_module_name,
2492: 'FND_API.G_EXC_ERROR exception has occured.',
2493: wsh_debug_sv.c_excep_level);
2494: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
2495: END IF;
2496: --

Line 2494: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

2490: IF l_debug_on THEN
2491: wsh_debug_sv.logmsg(l_module_name,
2492: 'FND_API.G_EXC_ERROR exception has occured.',
2493: wsh_debug_sv.c_excep_level);
2494: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
2495: END IF;
2496: --
2497: --
2498: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2498: WHEN fnd_api.g_exc_unexpected_error THEN

2494: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
2495: END IF;
2496: --
2497: --
2498: WHEN fnd_api.g_exc_unexpected_error THEN
2499: x_return_status := fnd_api.g_ret_sts_unexp_error;
2500: --
2501: IF l_debug_on THEN
2502: wsh_debug_sv.logmsg(l_module_name,

Line 2499: x_return_status := fnd_api.g_ret_sts_unexp_error;

2495: END IF;
2496: --
2497: --
2498: WHEN fnd_api.g_exc_unexpected_error THEN
2499: x_return_status := fnd_api.g_ret_sts_unexp_error;
2500: --
2501: IF l_debug_on THEN
2502: wsh_debug_sv.logmsg(l_module_name,
2503: 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

Line 2503: 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

2499: x_return_status := fnd_api.g_ret_sts_unexp_error;
2500: --
2501: IF l_debug_on THEN
2502: wsh_debug_sv.logmsg(l_module_name,
2503: 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
2504: wsh_debug_sv.c_excep_level);
2505: wsh_debug_sv.pop(l_module_name,
2506: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2507: END IF;

Line 2506: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2502: wsh_debug_sv.logmsg(l_module_name,
2503: 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
2504: wsh_debug_sv.c_excep_level);
2505: wsh_debug_sv.pop(l_module_name,
2506: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2507: END IF;
2508: --
2509: WHEN wsh_util_core.g_exc_warning THEN
2510: x_return_status := wsh_util_core.g_ret_sts_warning;

Line 2916: raise fnd_api.g_exc_error;

2912: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2913:
2914: IF(p_delivery_interface_id IS NULL)
2915: THEN
2916: raise fnd_api.g_exc_error;
2917: END IF;
2918:
2919: IF p_action_code NOT IN ('CREATE', 'UPDATE')
2920: THEN

Line 2923: RAISE fnd_api.g_exc_error;

2919: IF p_action_code NOT IN ('CREATE', 'UPDATE')
2920: THEN
2921: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_ACTION_CODE');
2922: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_code );
2923: RAISE fnd_api.g_exc_error;
2924: END IF;
2925:
2926: l_index := 1;
2927:

Line 2960: if ( nvl(l_del_int_rec.carrier_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char )

2956: END IF;
2957: END IF; -- if p_action_code=update
2958:
2959: -- This is to pass the carrier information to the Third Party Instance.
2960: if ( nvl(l_del_int_rec.carrier_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char )
2961: THEN
2962: -- {
2963: l_carrier_id := NULL;
2964: l_manifesting_enabled_flag := NULL;

Line 2977: IF(nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) = 'CMS')

2973: l_del_int_rec.carrier_id := l_carrier_id;
2974: -- }
2975: end if;
2976: --
2977: IF(nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) = 'CMS')
2978: THEN
2979: -- {
2980: -- For updates from CMS, need to check if the ship method code
2981: -- is the same. Error out if different.

Line 2987: IF ( nvl(l_del_int_rec.carrier_code, fnd_api.g_miss_char) = fnd_api.g_miss_char) THEN

2983: THEN
2984: -- {
2985: -- These changes are made to allow the manifesting system to send a changed
2986: -- combo of carrier, service level, and mode of transport.
2987: IF ( nvl(l_del_int_rec.carrier_code, fnd_api.g_miss_char) = fnd_api.g_miss_char) THEN
2988: --{
2989: IF l_debug_on THEN
2990: wsh_debug_sv.logmsg(l_module_name, 'Carrier is null');
2991: END IF;

Line 3014: AND nvl(l_del_int_rec.ship_method_code, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR

3010: --}
3011: END IF;
3012: IF (
3013: nvl(l_enforce_ship_method,'N') = 'Y'
3014: AND nvl(l_del_int_rec.ship_method_code, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR
3015: ) THEN
3016: --{
3017: IF l_debug_on THEN
3018: wsh_debug_sv.logmsg(l_module_name, 'Ship Method is enforced for the org and inbound Ship Method is NULL');

Line 3023: ELSIF nvl(l_del_int_rec.ship_method_code, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR

3019: END IF;
3020: l_loc_interface_error_rec.p_message_name := 'WSH_NULL_INB_SHIP_METHOD';
3021: l_log_error_flag := 'Y';
3022: --}
3023: ELSIF nvl(l_del_int_rec.ship_method_code, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
3024: THEN
3025: --{
3026: l_valid_shp_method_flag := NULL;
3027: open l_shp_method_org_csr(l_del_int_rec.ship_method_code, l_del_int_rec.organization_id);

Line 3056: RAISE FND_API.G_EXC_ERROR;

3052: p_api_name =>'Process_Interfaced_Deliveries, Action=UPDATE' ,
3053: x_return_status => l_return_status);
3054:
3055: l_log_error_flag := 'N';
3056: RAISE FND_API.G_EXC_ERROR;
3057: --}
3058: END IF;
3059: /*
3060: -- Commented this part of the code as we allow the

Line 3071: IF nvl(l_curr_ship_method,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR

3067: wsh_debug_sv.log (l_module_name,'Current ship method', l_curr_ship_method);
3068: wsh_debug_sv.log (l_module_name,'Incoming ship method', l_del_int_rec.ship_method_code);
3069: END IF;
3070:
3071: IF nvl(l_curr_ship_method,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
3072: THEN
3073: -- {
3074: IF(l_curr_ship_method <> nvl(l_del_int_rec.ship_method_code, FND_API.G_MISS_CHAR)) THEN
3075: raise invalid_ship_method;

Line 3074: IF(l_curr_ship_method <> nvl(l_del_int_rec.ship_method_code, FND_API.G_MISS_CHAR)) THEN

3070:
3071: IF nvl(l_curr_ship_method,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
3072: THEN
3073: -- {
3074: IF(l_curr_ship_method <> nvl(l_del_int_rec.ship_method_code, FND_API.G_MISS_CHAR)) THEN
3075: raise invalid_ship_method;
3076: END IF;
3077: -- }
3078: END IF;

Line 3083: l_dlvy_attr_tab(l_index).ship_method_code := FND_API.G_MISS_CHAR;

3079: -- Bug 2753330
3080: -- Since ship_method_code should not be updateable for CMS inbound,
3081: -- Need to send G_MISS_CHAR for code and name
3082: -- so that the database value will be used for ship method code
3083: l_dlvy_attr_tab(l_index).ship_method_code := FND_API.G_MISS_CHAR;
3084: */
3085: -- }
3086: END IF;
3087: l_dlvy_attr_tab(l_index).ship_method_name := FND_API.G_MISS_CHAR;

Line 3087: l_dlvy_attr_tab(l_index).ship_method_name := FND_API.G_MISS_CHAR;

3083: l_dlvy_attr_tab(l_index).ship_method_code := FND_API.G_MISS_CHAR;
3084: */
3085: -- }
3086: END IF;
3087: l_dlvy_attr_tab(l_index).ship_method_name := FND_API.G_MISS_CHAR;
3088: l_dlvy_attr_tab(l_index).SHIP_METHOD_CODE := nvl(l_del_int_rec.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR);
3089: ELSE
3090: -- Need to send ship method code only for non-cms cases.
3091: l_dlvy_attr_tab(l_index).SHIP_METHOD_CODE := nvl(l_del_int_rec.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR);

Line 3088: l_dlvy_attr_tab(l_index).SHIP_METHOD_CODE := nvl(l_del_int_rec.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR);

3084: */
3085: -- }
3086: END IF;
3087: l_dlvy_attr_tab(l_index).ship_method_name := FND_API.G_MISS_CHAR;
3088: l_dlvy_attr_tab(l_index).SHIP_METHOD_CODE := nvl(l_del_int_rec.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR);
3089: ELSE
3090: -- Need to send ship method code only for non-cms cases.
3091: l_dlvy_attr_tab(l_index).SHIP_METHOD_CODE := nvl(l_del_int_rec.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR);
3092: -- }

Line 3091: l_dlvy_attr_tab(l_index).SHIP_METHOD_CODE := nvl(l_del_int_rec.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR);

3087: l_dlvy_attr_tab(l_index).ship_method_name := FND_API.G_MISS_CHAR;
3088: l_dlvy_attr_tab(l_index).SHIP_METHOD_CODE := nvl(l_del_int_rec.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR);
3089: ELSE
3090: -- Need to send ship method code only for non-cms cases.
3091: l_dlvy_attr_tab(l_index).SHIP_METHOD_CODE := nvl(l_del_int_rec.SHIP_METHOD_CODE, FND_API.G_MISS_CHAR);
3092: -- }
3093: END IF;
3094:
3095:

Line 3096: l_dlvy_attr_tab(l_index).DELIVERY_TYPE := nvl(l_del_int_rec.delivery_type, FND_API.G_MISS_CHAR);

3092: -- }
3093: END IF;
3094:
3095:
3096: l_dlvy_attr_tab(l_index).DELIVERY_TYPE := nvl(l_del_int_rec.delivery_type, FND_API.G_MISS_CHAR);
3097: l_dlvy_attr_tab(l_index).LOADING_SEQUENCE := nvl(l_del_int_rec.loading_sequence, FND_API.G_MISS_NUM);
3098: l_dlvy_attr_tab(l_index).LOADING_ORDER_FLAG := nvl(l_del_int_rec.loading_order_flag, FND_API.G_MISS_CHAR);
3099: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_DATE := nvl(l_del_int_rec.initial_pickup_date, FND_API.G_MISS_DATE);
3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);

Line 3097: l_dlvy_attr_tab(l_index).LOADING_SEQUENCE := nvl(l_del_int_rec.loading_sequence, FND_API.G_MISS_NUM);

3093: END IF;
3094:
3095:
3096: l_dlvy_attr_tab(l_index).DELIVERY_TYPE := nvl(l_del_int_rec.delivery_type, FND_API.G_MISS_CHAR);
3097: l_dlvy_attr_tab(l_index).LOADING_SEQUENCE := nvl(l_del_int_rec.loading_sequence, FND_API.G_MISS_NUM);
3098: l_dlvy_attr_tab(l_index).LOADING_ORDER_FLAG := nvl(l_del_int_rec.loading_order_flag, FND_API.G_MISS_CHAR);
3099: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_DATE := nvl(l_del_int_rec.initial_pickup_date, FND_API.G_MISS_DATE);
3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);
3101: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_CODE := nvl(l_del_int_rec.initial_pickup_location_code, FND_API.G_MISS_CHAR);

Line 3098: l_dlvy_attr_tab(l_index).LOADING_ORDER_FLAG := nvl(l_del_int_rec.loading_order_flag, FND_API.G_MISS_CHAR);

3094:
3095:
3096: l_dlvy_attr_tab(l_index).DELIVERY_TYPE := nvl(l_del_int_rec.delivery_type, FND_API.G_MISS_CHAR);
3097: l_dlvy_attr_tab(l_index).LOADING_SEQUENCE := nvl(l_del_int_rec.loading_sequence, FND_API.G_MISS_NUM);
3098: l_dlvy_attr_tab(l_index).LOADING_ORDER_FLAG := nvl(l_del_int_rec.loading_order_flag, FND_API.G_MISS_CHAR);
3099: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_DATE := nvl(l_del_int_rec.initial_pickup_date, FND_API.G_MISS_DATE);
3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);
3101: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_CODE := nvl(l_del_int_rec.initial_pickup_location_code, FND_API.G_MISS_CHAR);
3102: l_dlvy_attr_tab(l_index).ORGANIZATION_ID := nvl(l_del_int_rec.organization_id, FND_API.G_MISS_NUM);

Line 3099: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_DATE := nvl(l_del_int_rec.initial_pickup_date, FND_API.G_MISS_DATE);

3095:
3096: l_dlvy_attr_tab(l_index).DELIVERY_TYPE := nvl(l_del_int_rec.delivery_type, FND_API.G_MISS_CHAR);
3097: l_dlvy_attr_tab(l_index).LOADING_SEQUENCE := nvl(l_del_int_rec.loading_sequence, FND_API.G_MISS_NUM);
3098: l_dlvy_attr_tab(l_index).LOADING_ORDER_FLAG := nvl(l_del_int_rec.loading_order_flag, FND_API.G_MISS_CHAR);
3099: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_DATE := nvl(l_del_int_rec.initial_pickup_date, FND_API.G_MISS_DATE);
3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);
3101: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_CODE := nvl(l_del_int_rec.initial_pickup_location_code, FND_API.G_MISS_CHAR);
3102: l_dlvy_attr_tab(l_index).ORGANIZATION_ID := nvl(l_del_int_rec.organization_id, FND_API.G_MISS_NUM);
3103: l_dlvy_attr_tab(l_index).ORGANIZATION_CODE := nvl(l_del_int_rec.organization_code, FND_API.G_MISS_CHAR);

Line 3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);

3096: l_dlvy_attr_tab(l_index).DELIVERY_TYPE := nvl(l_del_int_rec.delivery_type, FND_API.G_MISS_CHAR);
3097: l_dlvy_attr_tab(l_index).LOADING_SEQUENCE := nvl(l_del_int_rec.loading_sequence, FND_API.G_MISS_NUM);
3098: l_dlvy_attr_tab(l_index).LOADING_ORDER_FLAG := nvl(l_del_int_rec.loading_order_flag, FND_API.G_MISS_CHAR);
3099: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_DATE := nvl(l_del_int_rec.initial_pickup_date, FND_API.G_MISS_DATE);
3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);
3101: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_CODE := nvl(l_del_int_rec.initial_pickup_location_code, FND_API.G_MISS_CHAR);
3102: l_dlvy_attr_tab(l_index).ORGANIZATION_ID := nvl(l_del_int_rec.organization_id, FND_API.G_MISS_NUM);
3103: l_dlvy_attr_tab(l_index).ORGANIZATION_CODE := nvl(l_del_int_rec.organization_code, FND_API.G_MISS_CHAR);
3104: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_ID := nvl(l_del_int_rec.ultimate_dropoff_location_id, FND_API.G_MISS_NUM);

Line 3101: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_CODE := nvl(l_del_int_rec.initial_pickup_location_code, FND_API.G_MISS_CHAR);

3097: l_dlvy_attr_tab(l_index).LOADING_SEQUENCE := nvl(l_del_int_rec.loading_sequence, FND_API.G_MISS_NUM);
3098: l_dlvy_attr_tab(l_index).LOADING_ORDER_FLAG := nvl(l_del_int_rec.loading_order_flag, FND_API.G_MISS_CHAR);
3099: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_DATE := nvl(l_del_int_rec.initial_pickup_date, FND_API.G_MISS_DATE);
3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);
3101: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_CODE := nvl(l_del_int_rec.initial_pickup_location_code, FND_API.G_MISS_CHAR);
3102: l_dlvy_attr_tab(l_index).ORGANIZATION_ID := nvl(l_del_int_rec.organization_id, FND_API.G_MISS_NUM);
3103: l_dlvy_attr_tab(l_index).ORGANIZATION_CODE := nvl(l_del_int_rec.organization_code, FND_API.G_MISS_CHAR);
3104: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_ID := nvl(l_del_int_rec.ultimate_dropoff_location_id, FND_API.G_MISS_NUM);
3105: -- Since the location id has been derived already, we should send the code only when the id is null

Line 3102: l_dlvy_attr_tab(l_index).ORGANIZATION_ID := nvl(l_del_int_rec.organization_id, FND_API.G_MISS_NUM);

3098: l_dlvy_attr_tab(l_index).LOADING_ORDER_FLAG := nvl(l_del_int_rec.loading_order_flag, FND_API.G_MISS_CHAR);
3099: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_DATE := nvl(l_del_int_rec.initial_pickup_date, FND_API.G_MISS_DATE);
3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);
3101: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_CODE := nvl(l_del_int_rec.initial_pickup_location_code, FND_API.G_MISS_CHAR);
3102: l_dlvy_attr_tab(l_index).ORGANIZATION_ID := nvl(l_del_int_rec.organization_id, FND_API.G_MISS_NUM);
3103: l_dlvy_attr_tab(l_index).ORGANIZATION_CODE := nvl(l_del_int_rec.organization_code, FND_API.G_MISS_CHAR);
3104: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_ID := nvl(l_del_int_rec.ultimate_dropoff_location_id, FND_API.G_MISS_NUM);
3105: -- Since the location id has been derived already, we should send the code only when the id is null
3106: IF(l_del_int_rec.ultimate_dropoff_location_id IS NULL)

Line 3103: l_dlvy_attr_tab(l_index).ORGANIZATION_CODE := nvl(l_del_int_rec.organization_code, FND_API.G_MISS_CHAR);

3099: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_DATE := nvl(l_del_int_rec.initial_pickup_date, FND_API.G_MISS_DATE);
3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);
3101: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_CODE := nvl(l_del_int_rec.initial_pickup_location_code, FND_API.G_MISS_CHAR);
3102: l_dlvy_attr_tab(l_index).ORGANIZATION_ID := nvl(l_del_int_rec.organization_id, FND_API.G_MISS_NUM);
3103: l_dlvy_attr_tab(l_index).ORGANIZATION_CODE := nvl(l_del_int_rec.organization_code, FND_API.G_MISS_CHAR);
3104: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_ID := nvl(l_del_int_rec.ultimate_dropoff_location_id, FND_API.G_MISS_NUM);
3105: -- Since the location id has been derived already, we should send the code only when the id is null
3106: IF(l_del_int_rec.ultimate_dropoff_location_id IS NULL)
3107: THEN

Line 3104: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_ID := nvl(l_del_int_rec.ultimate_dropoff_location_id, FND_API.G_MISS_NUM);

3100: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_ID := nvl(l_del_int_rec.initial_pickup_location_id, FND_API.G_MISS_NUM);
3101: l_dlvy_attr_tab(l_index).INITIAL_PICKUP_LOCATION_CODE := nvl(l_del_int_rec.initial_pickup_location_code, FND_API.G_MISS_CHAR);
3102: l_dlvy_attr_tab(l_index).ORGANIZATION_ID := nvl(l_del_int_rec.organization_id, FND_API.G_MISS_NUM);
3103: l_dlvy_attr_tab(l_index).ORGANIZATION_CODE := nvl(l_del_int_rec.organization_code, FND_API.G_MISS_CHAR);
3104: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_ID := nvl(l_del_int_rec.ultimate_dropoff_location_id, FND_API.G_MISS_NUM);
3105: -- Since the location id has been derived already, we should send the code only when the id is null
3106: IF(l_del_int_rec.ultimate_dropoff_location_id IS NULL)
3107: THEN
3108: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_CODE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_LOCATION_CODE, FND_API.G_MISS_CHAR);

Line 3108: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_CODE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_LOCATION_CODE, FND_API.G_MISS_CHAR);

3104: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_ID := nvl(l_del_int_rec.ultimate_dropoff_location_id, FND_API.G_MISS_NUM);
3105: -- Since the location id has been derived already, we should send the code only when the id is null
3106: IF(l_del_int_rec.ultimate_dropoff_location_id IS NULL)
3107: THEN
3108: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_CODE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_LOCATION_CODE, FND_API.G_MISS_CHAR);
3109: END IF;
3110: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_DATE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_DATE, FND_API.G_MISS_DATE);
3111: l_dlvy_attr_tab(l_index).CUSTOMER_ID := nvl(l_del_int_rec.CUSTOMER_ID, FND_API.G_MISS_NUM);
3112: l_dlvy_attr_tab(l_index).CUSTOMER_NUMBER := nvl(l_del_int_rec.customer_number, FND_API.G_MISS_CHAR);

Line 3110: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_DATE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_DATE, FND_API.G_MISS_DATE);

3106: IF(l_del_int_rec.ultimate_dropoff_location_id IS NULL)
3107: THEN
3108: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_CODE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_LOCATION_CODE, FND_API.G_MISS_CHAR);
3109: END IF;
3110: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_DATE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_DATE, FND_API.G_MISS_DATE);
3111: l_dlvy_attr_tab(l_index).CUSTOMER_ID := nvl(l_del_int_rec.CUSTOMER_ID, FND_API.G_MISS_NUM);
3112: l_dlvy_attr_tab(l_index).CUSTOMER_NUMBER := nvl(l_del_int_rec.customer_number, FND_API.G_MISS_CHAR);
3113: l_dlvy_attr_tab(l_index).INTMED_SHIP_TO_LOCATION_ID := nvl(l_del_int_rec.INTMED_SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM);
3114:

Line 3111: l_dlvy_attr_tab(l_index).CUSTOMER_ID := nvl(l_del_int_rec.CUSTOMER_ID, FND_API.G_MISS_NUM);

3107: THEN
3108: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_CODE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_LOCATION_CODE, FND_API.G_MISS_CHAR);
3109: END IF;
3110: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_DATE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_DATE, FND_API.G_MISS_DATE);
3111: l_dlvy_attr_tab(l_index).CUSTOMER_ID := nvl(l_del_int_rec.CUSTOMER_ID, FND_API.G_MISS_NUM);
3112: l_dlvy_attr_tab(l_index).CUSTOMER_NUMBER := nvl(l_del_int_rec.customer_number, FND_API.G_MISS_CHAR);
3113: l_dlvy_attr_tab(l_index).INTMED_SHIP_TO_LOCATION_ID := nvl(l_del_int_rec.INTMED_SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM);
3114:
3115: -- Since the location id has been derived already, we should send the code only when the id is null

Line 3112: l_dlvy_attr_tab(l_index).CUSTOMER_NUMBER := nvl(l_del_int_rec.customer_number, FND_API.G_MISS_CHAR);

3108: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_LOCATION_CODE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_LOCATION_CODE, FND_API.G_MISS_CHAR);
3109: END IF;
3110: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_DATE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_DATE, FND_API.G_MISS_DATE);
3111: l_dlvy_attr_tab(l_index).CUSTOMER_ID := nvl(l_del_int_rec.CUSTOMER_ID, FND_API.G_MISS_NUM);
3112: l_dlvy_attr_tab(l_index).CUSTOMER_NUMBER := nvl(l_del_int_rec.customer_number, FND_API.G_MISS_CHAR);
3113: l_dlvy_attr_tab(l_index).INTMED_SHIP_TO_LOCATION_ID := nvl(l_del_int_rec.INTMED_SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM);
3114:
3115: -- Since the location id has been derived already, we should send the code only when the id is null
3116: IF(l_del_int_rec.INTMED_SHIP_TO_LOCATION_ID IS NULL)

Line 3113: l_dlvy_attr_tab(l_index).INTMED_SHIP_TO_LOCATION_ID := nvl(l_del_int_rec.INTMED_SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM);

3109: END IF;
3110: l_dlvy_attr_tab(l_index).ULTIMATE_DROPOFF_DATE := nvl(l_del_int_rec.ULTIMATE_DROPOFF_DATE, FND_API.G_MISS_DATE);
3111: l_dlvy_attr_tab(l_index).CUSTOMER_ID := nvl(l_del_int_rec.CUSTOMER_ID, FND_API.G_MISS_NUM);
3112: l_dlvy_attr_tab(l_index).CUSTOMER_NUMBER := nvl(l_del_int_rec.customer_number, FND_API.G_MISS_CHAR);
3113: l_dlvy_attr_tab(l_index).INTMED_SHIP_TO_LOCATION_ID := nvl(l_del_int_rec.INTMED_SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM);
3114:
3115: -- Since the location id has been derived already, we should send the code only when the id is null
3116: IF(l_del_int_rec.INTMED_SHIP_TO_LOCATION_ID IS NULL)
3117: THEN

Line 3118: l_dlvy_attr_tab(l_index).INTMED_SHIP_TO_LOCATION_CODE := nvl(l_del_int_rec.INTMED_SHIP_TO_LOCATION_CODE, FND_API.G_MISS_CHAR);

3114:
3115: -- Since the location id has been derived already, we should send the code only when the id is null
3116: IF(l_del_int_rec.INTMED_SHIP_TO_LOCATION_ID IS NULL)
3117: THEN
3118: l_dlvy_attr_tab(l_index).INTMED_SHIP_TO_LOCATION_CODE := nvl(l_del_int_rec.INTMED_SHIP_TO_LOCATION_CODE, FND_API.G_MISS_CHAR);
3119: END IF;
3120:
3121: l_dlvy_attr_tab(l_index).POOLED_SHIP_TO_LOCATION_ID := nvl(l_del_int_rec.POOLED_SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM);
3122: -- Send the code only when the id is null

Line 3121: l_dlvy_attr_tab(l_index).POOLED_SHIP_TO_LOCATION_ID := nvl(l_del_int_rec.POOLED_SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM);

3117: THEN
3118: l_dlvy_attr_tab(l_index).INTMED_SHIP_TO_LOCATION_CODE := nvl(l_del_int_rec.INTMED_SHIP_TO_LOCATION_CODE, FND_API.G_MISS_CHAR);
3119: END IF;
3120:
3121: l_dlvy_attr_tab(l_index).POOLED_SHIP_TO_LOCATION_ID := nvl(l_del_int_rec.POOLED_SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM);
3122: -- Send the code only when the id is null
3123: IF(l_del_int_rec.POOLED_SHIP_TO_LOCATION_ID IS NULL) THEN
3124: l_dlvy_attr_tab(l_index).POOLED_SHIP_TO_LOCATION_CODE := nvl(l_del_int_rec.POOLED_SHIP_TO_LOCATION_CODE, FND_API.G_MISS_CHAR);
3125: END IF;

Line 3124: l_dlvy_attr_tab(l_index).POOLED_SHIP_TO_LOCATION_CODE := nvl(l_del_int_rec.POOLED_SHIP_TO_LOCATION_CODE, FND_API.G_MISS_CHAR);

3120:
3121: l_dlvy_attr_tab(l_index).POOLED_SHIP_TO_LOCATION_ID := nvl(l_del_int_rec.POOLED_SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM);
3122: -- Send the code only when the id is null
3123: IF(l_del_int_rec.POOLED_SHIP_TO_LOCATION_ID IS NULL) THEN
3124: l_dlvy_attr_tab(l_index).POOLED_SHIP_TO_LOCATION_CODE := nvl(l_del_int_rec.POOLED_SHIP_TO_LOCATION_CODE, FND_API.G_MISS_CHAR);
3125: END IF;
3126:
3127: l_dlvy_attr_tab(l_index).FREIGHT_TERMS_CODE := nvl(l_del_int_rec.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR);
3128: l_dlvy_attr_tab(l_index).FOB_CODE := nvl(l_del_int_rec.FOB_CODE, FND_API.G_MISS_CHAR);

Line 3127: l_dlvy_attr_tab(l_index).FREIGHT_TERMS_CODE := nvl(l_del_int_rec.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR);

3123: IF(l_del_int_rec.POOLED_SHIP_TO_LOCATION_ID IS NULL) THEN
3124: l_dlvy_attr_tab(l_index).POOLED_SHIP_TO_LOCATION_CODE := nvl(l_del_int_rec.POOLED_SHIP_TO_LOCATION_CODE, FND_API.G_MISS_CHAR);
3125: END IF;
3126:
3127: l_dlvy_attr_tab(l_index).FREIGHT_TERMS_CODE := nvl(l_del_int_rec.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR);
3128: l_dlvy_attr_tab(l_index).FOB_CODE := nvl(l_del_int_rec.FOB_CODE, FND_API.G_MISS_CHAR);
3129: l_dlvy_attr_tab(l_index).FOB_LOCATION_ID := nvl(l_del_int_rec.FOB_LOCATION_ID, FND_API.G_MISS_NUM);
3130: l_dlvy_attr_tab(l_index).FOB_LOCATION_CODE := nvl(l_del_int_rec.FOB_LOCATION_CODE, FND_API.G_MISS_CHAR);
3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);

Line 3128: l_dlvy_attr_tab(l_index).FOB_CODE := nvl(l_del_int_rec.FOB_CODE, FND_API.G_MISS_CHAR);

3124: l_dlvy_attr_tab(l_index).POOLED_SHIP_TO_LOCATION_CODE := nvl(l_del_int_rec.POOLED_SHIP_TO_LOCATION_CODE, FND_API.G_MISS_CHAR);
3125: END IF;
3126:
3127: l_dlvy_attr_tab(l_index).FREIGHT_TERMS_CODE := nvl(l_del_int_rec.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR);
3128: l_dlvy_attr_tab(l_index).FOB_CODE := nvl(l_del_int_rec.FOB_CODE, FND_API.G_MISS_CHAR);
3129: l_dlvy_attr_tab(l_index).FOB_LOCATION_ID := nvl(l_del_int_rec.FOB_LOCATION_ID, FND_API.G_MISS_NUM);
3130: l_dlvy_attr_tab(l_index).FOB_LOCATION_CODE := nvl(l_del_int_rec.FOB_LOCATION_CODE, FND_API.G_MISS_CHAR);
3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);
3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);

Line 3129: l_dlvy_attr_tab(l_index).FOB_LOCATION_ID := nvl(l_del_int_rec.FOB_LOCATION_ID, FND_API.G_MISS_NUM);

3125: END IF;
3126:
3127: l_dlvy_attr_tab(l_index).FREIGHT_TERMS_CODE := nvl(l_del_int_rec.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR);
3128: l_dlvy_attr_tab(l_index).FOB_CODE := nvl(l_del_int_rec.FOB_CODE, FND_API.G_MISS_CHAR);
3129: l_dlvy_attr_tab(l_index).FOB_LOCATION_ID := nvl(l_del_int_rec.FOB_LOCATION_ID, FND_API.G_MISS_NUM);
3130: l_dlvy_attr_tab(l_index).FOB_LOCATION_CODE := nvl(l_del_int_rec.FOB_LOCATION_CODE, FND_API.G_MISS_CHAR);
3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);
3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);
3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);

Line 3130: l_dlvy_attr_tab(l_index).FOB_LOCATION_CODE := nvl(l_del_int_rec.FOB_LOCATION_CODE, FND_API.G_MISS_CHAR);

3126:
3127: l_dlvy_attr_tab(l_index).FREIGHT_TERMS_CODE := nvl(l_del_int_rec.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR);
3128: l_dlvy_attr_tab(l_index).FOB_CODE := nvl(l_del_int_rec.FOB_CODE, FND_API.G_MISS_CHAR);
3129: l_dlvy_attr_tab(l_index).FOB_LOCATION_ID := nvl(l_del_int_rec.FOB_LOCATION_ID, FND_API.G_MISS_NUM);
3130: l_dlvy_attr_tab(l_index).FOB_LOCATION_CODE := nvl(l_del_int_rec.FOB_LOCATION_CODE, FND_API.G_MISS_CHAR);
3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);
3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);
3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);
3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);

Line 3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);

3127: l_dlvy_attr_tab(l_index).FREIGHT_TERMS_CODE := nvl(l_del_int_rec.FREIGHT_TERMS_CODE, FND_API.G_MISS_CHAR);
3128: l_dlvy_attr_tab(l_index).FOB_CODE := nvl(l_del_int_rec.FOB_CODE, FND_API.G_MISS_CHAR);
3129: l_dlvy_attr_tab(l_index).FOB_LOCATION_ID := nvl(l_del_int_rec.FOB_LOCATION_ID, FND_API.G_MISS_NUM);
3130: l_dlvy_attr_tab(l_index).FOB_LOCATION_CODE := nvl(l_del_int_rec.FOB_LOCATION_CODE, FND_API.G_MISS_CHAR);
3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);
3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);
3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);
3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);
3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);

Line 3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);

3128: l_dlvy_attr_tab(l_index).FOB_CODE := nvl(l_del_int_rec.FOB_CODE, FND_API.G_MISS_CHAR);
3129: l_dlvy_attr_tab(l_index).FOB_LOCATION_ID := nvl(l_del_int_rec.FOB_LOCATION_ID, FND_API.G_MISS_NUM);
3130: l_dlvy_attr_tab(l_index).FOB_LOCATION_CODE := nvl(l_del_int_rec.FOB_LOCATION_CODE, FND_API.G_MISS_CHAR);
3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);
3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);
3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);
3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);
3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);
3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);

Line 3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);

3129: l_dlvy_attr_tab(l_index).FOB_LOCATION_ID := nvl(l_del_int_rec.FOB_LOCATION_ID, FND_API.G_MISS_NUM);
3130: l_dlvy_attr_tab(l_index).FOB_LOCATION_CODE := nvl(l_del_int_rec.FOB_LOCATION_CODE, FND_API.G_MISS_CHAR);
3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);
3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);
3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);
3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);
3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);
3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);
3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);

Line 3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);

3130: l_dlvy_attr_tab(l_index).FOB_LOCATION_CODE := nvl(l_del_int_rec.FOB_LOCATION_CODE, FND_API.G_MISS_CHAR);
3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);
3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);
3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);
3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);
3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);
3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);
3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);
3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);

Line 3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);

3131: l_dlvy_attr_tab(l_index).WAYBILL := nvl(l_del_int_rec.waybill, FND_API.G_MISS_CHAR);
3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);
3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);
3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);
3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);
3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);
3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);
3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);
3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);

Line 3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);

3132: l_dlvy_attr_tab(l_index).DOCK_CODE := nvl(l_del_int_rec.dock_code, FND_API.G_MISS_CHAR);
3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);
3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);
3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);
3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);
3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);
3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);
3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);
3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);

Line 3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);

3133: l_dlvy_attr_tab(l_index).ACCEPTANCE_FLAG := nvl(l_del_int_rec.acceptance_flag, FND_API.G_MISS_CHAR);
3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);
3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);
3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);
3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);
3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);
3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);
3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);
3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);

Line 3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);

3134: l_dlvy_attr_tab(l_index).ACCEPTED_BY := nvl(l_del_int_rec.accepted_by, FND_API.G_MISS_CHAR);
3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);
3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);
3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);
3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);
3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);
3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);
3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);
3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);

Line 3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);

3135: l_dlvy_attr_tab(l_index).ACCEPTED_DATE := nvl(l_del_int_rec.accepted_date, FND_API.G_MISS_DATE);
3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);
3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);
3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);
3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);
3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);
3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);
3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);
3143: l_dlvy_attr_tab(l_index).NET_WEIGHT := nvl(l_del_int_rec.NET_WEIGHT, FND_API.G_MISS_NUM);

Line 3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);

3136: l_dlvy_attr_tab(l_index).ACKNOWLEDGED_BY := nvl(l_del_int_rec.acknowledged_by, FND_API.G_MISS_CHAR);
3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);
3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);
3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);
3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);
3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);
3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);
3143: l_dlvy_attr_tab(l_index).NET_WEIGHT := nvl(l_del_int_rec.NET_WEIGHT, FND_API.G_MISS_NUM);
3144: l_dlvy_attr_tab(l_index).WEIGHT_UOM_CODE := nvl(l_del_int_rec.WEIGHT_UOM_CODE, FND_API.G_MISS_CHAR);

Line 3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);

3137: l_dlvy_attr_tab(l_index).CONFIRMED_BY := nvl(l_del_int_rec.CONFIRMED_BY, FND_API.G_MISS_CHAR);
3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);
3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);
3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);
3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);
3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);
3143: l_dlvy_attr_tab(l_index).NET_WEIGHT := nvl(l_del_int_rec.NET_WEIGHT, FND_API.G_MISS_NUM);
3144: l_dlvy_attr_tab(l_index).WEIGHT_UOM_CODE := nvl(l_del_int_rec.WEIGHT_UOM_CODE, FND_API.G_MISS_CHAR);
3145: l_dlvy_attr_tab(l_index).VOLUME := nvl(l_del_int_rec.VOLUME , FND_API.G_MISS_NUM);

Line 3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);

3138: l_dlvy_attr_tab(l_index).CONFIRM_DATE := nvl(l_del_int_rec.CONFIRM_DATE, FND_API.G_MISS_DATE);
3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);
3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);
3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);
3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);
3143: l_dlvy_attr_tab(l_index).NET_WEIGHT := nvl(l_del_int_rec.NET_WEIGHT, FND_API.G_MISS_NUM);
3144: l_dlvy_attr_tab(l_index).WEIGHT_UOM_CODE := nvl(l_del_int_rec.WEIGHT_UOM_CODE, FND_API.G_MISS_CHAR);
3145: l_dlvy_attr_tab(l_index).VOLUME := nvl(l_del_int_rec.VOLUME , FND_API.G_MISS_NUM);
3146: l_dlvy_attr_tab(l_index).VOLUME_UOM_CODE := nvl(l_del_int_rec.VOLUME_UOM_CODE, FND_API.G_MISS_CHAR);

Line 3143: l_dlvy_attr_tab(l_index).NET_WEIGHT := nvl(l_del_int_rec.NET_WEIGHT, FND_API.G_MISS_NUM);

3139: l_dlvy_attr_tab(l_index).ASN_DATE_SENT := nvl(l_del_int_rec.ASN_DATE_SENT, FND_API.G_MISS_DATE);
3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);
3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);
3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);
3143: l_dlvy_attr_tab(l_index).NET_WEIGHT := nvl(l_del_int_rec.NET_WEIGHT, FND_API.G_MISS_NUM);
3144: l_dlvy_attr_tab(l_index).WEIGHT_UOM_CODE := nvl(l_del_int_rec.WEIGHT_UOM_CODE, FND_API.G_MISS_CHAR);
3145: l_dlvy_attr_tab(l_index).VOLUME := nvl(l_del_int_rec.VOLUME , FND_API.G_MISS_NUM);
3146: l_dlvy_attr_tab(l_index).VOLUME_UOM_CODE := nvl(l_del_int_rec.VOLUME_UOM_CODE, FND_API.G_MISS_CHAR);
3147: -- J: W/V Changes

Line 3144: l_dlvy_attr_tab(l_index).WEIGHT_UOM_CODE := nvl(l_del_int_rec.WEIGHT_UOM_CODE, FND_API.G_MISS_CHAR);

3140: l_dlvy_attr_tab(l_index).ASN_STATUS_CODE := nvl(l_del_int_rec.ASN_STATUS_CODE, FND_API.G_MISS_CHAR);
3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);
3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);
3143: l_dlvy_attr_tab(l_index).NET_WEIGHT := nvl(l_del_int_rec.NET_WEIGHT, FND_API.G_MISS_NUM);
3144: l_dlvy_attr_tab(l_index).WEIGHT_UOM_CODE := nvl(l_del_int_rec.WEIGHT_UOM_CODE, FND_API.G_MISS_CHAR);
3145: l_dlvy_attr_tab(l_index).VOLUME := nvl(l_del_int_rec.VOLUME , FND_API.G_MISS_NUM);
3146: l_dlvy_attr_tab(l_index).VOLUME_UOM_CODE := nvl(l_del_int_rec.VOLUME_UOM_CODE, FND_API.G_MISS_CHAR);
3147: -- J: W/V Changes
3148: l_dlvy_attr_tab(l_index).WV_FROZEN_FLAG := l_del_int_rec.WV_FROZEN_FLAG;

Line 3145: l_dlvy_attr_tab(l_index).VOLUME := nvl(l_del_int_rec.VOLUME , FND_API.G_MISS_NUM);

3141: l_dlvy_attr_tab(l_index).ASN_SEQ_NUMBER := nvl(l_del_int_rec.ASN_SEQ_NUMBER, FND_API.G_MISS_NUM);
3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);
3143: l_dlvy_attr_tab(l_index).NET_WEIGHT := nvl(l_del_int_rec.NET_WEIGHT, FND_API.G_MISS_NUM);
3144: l_dlvy_attr_tab(l_index).WEIGHT_UOM_CODE := nvl(l_del_int_rec.WEIGHT_UOM_CODE, FND_API.G_MISS_CHAR);
3145: l_dlvy_attr_tab(l_index).VOLUME := nvl(l_del_int_rec.VOLUME , FND_API.G_MISS_NUM);
3146: l_dlvy_attr_tab(l_index).VOLUME_UOM_CODE := nvl(l_del_int_rec.VOLUME_UOM_CODE, FND_API.G_MISS_CHAR);
3147: -- J: W/V Changes
3148: l_dlvy_attr_tab(l_index).WV_FROZEN_FLAG := l_del_int_rec.WV_FROZEN_FLAG;
3149: l_dlvy_attr_tab(l_index).ADDITIONAL_SHIPMENT_INFO := nvl(l_del_int_rec.ADDITIONAL_SHIPMENT_INFO , FND_API.G_MISS_CHAR);

Line 3146: l_dlvy_attr_tab(l_index).VOLUME_UOM_CODE := nvl(l_del_int_rec.VOLUME_UOM_CODE, FND_API.G_MISS_CHAR);

3142: l_dlvy_attr_tab(l_index).GROSS_WEIGHT := nvl(l_del_int_rec.GROSS_WEIGHT, FND_API.G_MISS_NUM);
3143: l_dlvy_attr_tab(l_index).NET_WEIGHT := nvl(l_del_int_rec.NET_WEIGHT, FND_API.G_MISS_NUM);
3144: l_dlvy_attr_tab(l_index).WEIGHT_UOM_CODE := nvl(l_del_int_rec.WEIGHT_UOM_CODE, FND_API.G_MISS_CHAR);
3145: l_dlvy_attr_tab(l_index).VOLUME := nvl(l_del_int_rec.VOLUME , FND_API.G_MISS_NUM);
3146: l_dlvy_attr_tab(l_index).VOLUME_UOM_CODE := nvl(l_del_int_rec.VOLUME_UOM_CODE, FND_API.G_MISS_CHAR);
3147: -- J: W/V Changes
3148: l_dlvy_attr_tab(l_index).WV_FROZEN_FLAG := l_del_int_rec.WV_FROZEN_FLAG;
3149: l_dlvy_attr_tab(l_index).ADDITIONAL_SHIPMENT_INFO := nvl(l_del_int_rec.ADDITIONAL_SHIPMENT_INFO , FND_API.G_MISS_CHAR);
3150: l_dlvy_attr_tab(l_index).CURRENCY_CODE := nvl(l_del_int_rec.CURRENCY_CODE, FND_API.G_MISS_CHAR);

Line 3149: l_dlvy_attr_tab(l_index).ADDITIONAL_SHIPMENT_INFO := nvl(l_del_int_rec.ADDITIONAL_SHIPMENT_INFO , FND_API.G_MISS_CHAR);

3145: l_dlvy_attr_tab(l_index).VOLUME := nvl(l_del_int_rec.VOLUME , FND_API.G_MISS_NUM);
3146: l_dlvy_attr_tab(l_index).VOLUME_UOM_CODE := nvl(l_del_int_rec.VOLUME_UOM_CODE, FND_API.G_MISS_CHAR);
3147: -- J: W/V Changes
3148: l_dlvy_attr_tab(l_index).WV_FROZEN_FLAG := l_del_int_rec.WV_FROZEN_FLAG;
3149: l_dlvy_attr_tab(l_index).ADDITIONAL_SHIPMENT_INFO := nvl(l_del_int_rec.ADDITIONAL_SHIPMENT_INFO , FND_API.G_MISS_CHAR);
3150: l_dlvy_attr_tab(l_index).CURRENCY_CODE := nvl(l_del_int_rec.CURRENCY_CODE, FND_API.G_MISS_CHAR);
3151: l_dlvy_attr_tab(l_index).ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.ATTRIBUTE_CATEGORY , FND_API.G_MISS_CHAR);
3152: l_dlvy_attr_tab(l_index).ATTRIBUTE1 := nvl(l_del_int_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR);
3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);

Line 3150: l_dlvy_attr_tab(l_index).CURRENCY_CODE := nvl(l_del_int_rec.CURRENCY_CODE, FND_API.G_MISS_CHAR);

3146: l_dlvy_attr_tab(l_index).VOLUME_UOM_CODE := nvl(l_del_int_rec.VOLUME_UOM_CODE, FND_API.G_MISS_CHAR);
3147: -- J: W/V Changes
3148: l_dlvy_attr_tab(l_index).WV_FROZEN_FLAG := l_del_int_rec.WV_FROZEN_FLAG;
3149: l_dlvy_attr_tab(l_index).ADDITIONAL_SHIPMENT_INFO := nvl(l_del_int_rec.ADDITIONAL_SHIPMENT_INFO , FND_API.G_MISS_CHAR);
3150: l_dlvy_attr_tab(l_index).CURRENCY_CODE := nvl(l_del_int_rec.CURRENCY_CODE, FND_API.G_MISS_CHAR);
3151: l_dlvy_attr_tab(l_index).ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.ATTRIBUTE_CATEGORY , FND_API.G_MISS_CHAR);
3152: l_dlvy_attr_tab(l_index).ATTRIBUTE1 := nvl(l_del_int_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR);
3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);
3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);

Line 3151: l_dlvy_attr_tab(l_index).ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.ATTRIBUTE_CATEGORY , FND_API.G_MISS_CHAR);

3147: -- J: W/V Changes
3148: l_dlvy_attr_tab(l_index).WV_FROZEN_FLAG := l_del_int_rec.WV_FROZEN_FLAG;
3149: l_dlvy_attr_tab(l_index).ADDITIONAL_SHIPMENT_INFO := nvl(l_del_int_rec.ADDITIONAL_SHIPMENT_INFO , FND_API.G_MISS_CHAR);
3150: l_dlvy_attr_tab(l_index).CURRENCY_CODE := nvl(l_del_int_rec.CURRENCY_CODE, FND_API.G_MISS_CHAR);
3151: l_dlvy_attr_tab(l_index).ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.ATTRIBUTE_CATEGORY , FND_API.G_MISS_CHAR);
3152: l_dlvy_attr_tab(l_index).ATTRIBUTE1 := nvl(l_del_int_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR);
3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);
3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);
3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);

Line 3152: l_dlvy_attr_tab(l_index).ATTRIBUTE1 := nvl(l_del_int_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR);

3148: l_dlvy_attr_tab(l_index).WV_FROZEN_FLAG := l_del_int_rec.WV_FROZEN_FLAG;
3149: l_dlvy_attr_tab(l_index).ADDITIONAL_SHIPMENT_INFO := nvl(l_del_int_rec.ADDITIONAL_SHIPMENT_INFO , FND_API.G_MISS_CHAR);
3150: l_dlvy_attr_tab(l_index).CURRENCY_CODE := nvl(l_del_int_rec.CURRENCY_CODE, FND_API.G_MISS_CHAR);
3151: l_dlvy_attr_tab(l_index).ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.ATTRIBUTE_CATEGORY , FND_API.G_MISS_CHAR);
3152: l_dlvy_attr_tab(l_index).ATTRIBUTE1 := nvl(l_del_int_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR);
3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);
3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);
3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);
3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);

Line 3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);

3149: l_dlvy_attr_tab(l_index).ADDITIONAL_SHIPMENT_INFO := nvl(l_del_int_rec.ADDITIONAL_SHIPMENT_INFO , FND_API.G_MISS_CHAR);
3150: l_dlvy_attr_tab(l_index).CURRENCY_CODE := nvl(l_del_int_rec.CURRENCY_CODE, FND_API.G_MISS_CHAR);
3151: l_dlvy_attr_tab(l_index).ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.ATTRIBUTE_CATEGORY , FND_API.G_MISS_CHAR);
3152: l_dlvy_attr_tab(l_index).ATTRIBUTE1 := nvl(l_del_int_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR);
3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);
3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);
3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);
3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);
3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);

Line 3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);

3150: l_dlvy_attr_tab(l_index).CURRENCY_CODE := nvl(l_del_int_rec.CURRENCY_CODE, FND_API.G_MISS_CHAR);
3151: l_dlvy_attr_tab(l_index).ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.ATTRIBUTE_CATEGORY , FND_API.G_MISS_CHAR);
3152: l_dlvy_attr_tab(l_index).ATTRIBUTE1 := nvl(l_del_int_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR);
3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);
3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);
3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);
3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);
3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);
3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);

Line 3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);

3151: l_dlvy_attr_tab(l_index).ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.ATTRIBUTE_CATEGORY , FND_API.G_MISS_CHAR);
3152: l_dlvy_attr_tab(l_index).ATTRIBUTE1 := nvl(l_del_int_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR);
3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);
3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);
3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);
3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);
3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);
3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);
3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);

Line 3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);

3152: l_dlvy_attr_tab(l_index).ATTRIBUTE1 := nvl(l_del_int_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR);
3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);
3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);
3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);
3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);
3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);
3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);
3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);
3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);

Line 3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);

3153: l_dlvy_attr_tab(l_index).ATTRIBUTE2 := nvl(l_del_int_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR);
3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);
3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);
3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);
3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);
3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);
3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);
3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);
3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);

Line 3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);

3154: l_dlvy_attr_tab(l_index).ATTRIBUTE3 := nvl(l_del_int_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR);
3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);
3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);
3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);
3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);
3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);
3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);
3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);
3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);

Line 3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);

3155: l_dlvy_attr_tab(l_index).ATTRIBUTE4 := nvl(l_del_int_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR);
3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);
3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);
3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);
3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);
3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);
3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);
3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);
3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);

Line 3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);

3156: l_dlvy_attr_tab(l_index).ATTRIBUTE5 := nvl(l_del_int_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR);
3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);
3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);
3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);
3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);
3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);
3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);
3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);
3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);

Line 3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);

3157: l_dlvy_attr_tab(l_index).ATTRIBUTE6 := nvl(l_del_int_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR);
3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);
3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);
3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);
3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);
3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);
3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);
3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);
3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);

Line 3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);

3158: l_dlvy_attr_tab(l_index).ATTRIBUTE7 := nvl(l_del_int_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR);
3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);
3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);
3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);
3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);
3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);
3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);
3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);
3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);

Line 3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);

3159: l_dlvy_attr_tab(l_index).ATTRIBUTE8 := nvl(l_del_int_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR);
3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);
3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);
3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);
3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);
3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);
3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);
3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);
3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);

Line 3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);

3160: l_dlvy_attr_tab(l_index).ATTRIBUTE9 := nvl(l_del_int_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR);
3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);
3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);
3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);
3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);
3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);
3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);
3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);

Line 3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);

3161: l_dlvy_attr_tab(l_index).ATTRIBUTE10 := nvl(l_del_int_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR);
3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);
3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);
3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);
3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);
3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);
3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);
3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);

Line 3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);

3162: l_dlvy_attr_tab(l_index).ATTRIBUTE11 := nvl(l_del_int_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR);
3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);
3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);
3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);
3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);
3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);
3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);
3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);

Line 3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);

3163: l_dlvy_attr_tab(l_index).ATTRIBUTE12 := nvl(l_del_int_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR);
3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);
3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);
3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);
3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);
3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);
3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);
3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);

Line 3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);

3164: l_dlvy_attr_tab(l_index).ATTRIBUTE13 := nvl(l_del_int_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR);
3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);
3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);
3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);
3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);
3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);
3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);
3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);

Line 3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);

3165: l_dlvy_attr_tab(l_index).ATTRIBUTE14 := nvl(l_del_int_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR);
3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);
3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);
3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);
3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);
3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);
3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);
3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);

Line 3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);

3166: l_dlvy_attr_tab(l_index).ATTRIBUTE15 := nvl(l_del_int_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR);
3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);
3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);
3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);
3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);
3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);
3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);
3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);

Line 3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);

3167: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.TP_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);
3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);
3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);
3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);
3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);
3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);
3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);
3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);

Line 3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);

3168: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE1 := nvl(l_del_int_rec.TP_ATTRIBUTE1, FND_API.G_MISS_CHAR);
3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);
3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);
3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);
3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);
3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);
3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);
3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);
3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);

Line 3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);

3169: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE2 := nvl(l_del_int_rec.TP_ATTRIBUTE2, FND_API.G_MISS_CHAR);
3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);
3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);
3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);
3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);
3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);
3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);
3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);
3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);

Line 3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);

3170: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE3 := nvl(l_del_int_rec.TP_ATTRIBUTE3, FND_API.G_MISS_CHAR);
3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);
3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);
3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);
3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);
3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);
3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);
3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);

Line 3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);

3171: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE4 := nvl(l_del_int_rec.TP_ATTRIBUTE4, FND_API.G_MISS_CHAR);
3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);
3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);
3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);
3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);
3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);
3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);

Line 3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);

3172: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE5 := nvl(l_del_int_rec.TP_ATTRIBUTE5, FND_API.G_MISS_CHAR);
3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);
3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);
3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);
3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);
3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);

Line 3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);

3173: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE6 := nvl(l_del_int_rec.TP_ATTRIBUTE6, FND_API.G_MISS_CHAR);
3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);
3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);
3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);
3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);

Line 3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);

3174: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE7 := nvl(l_del_int_rec.TP_ATTRIBUTE7, FND_API.G_MISS_CHAR);
3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);
3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);
3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);

Line 3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);

3175: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE8 := nvl(l_del_int_rec.TP_ATTRIBUTE8, FND_API.G_MISS_CHAR);
3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);
3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);

Line 3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);

3176: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE9 := nvl(l_del_int_rec.TP_ATTRIBUTE9, FND_API.G_MISS_CHAR);
3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);

Line 3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);

3177: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE10 := nvl(l_del_int_rec.TP_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);
3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);

Line 3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);

3178: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE11 := nvl(l_del_int_rec.TP_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);
3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);
3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);

Line 3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);

3179: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE12 := nvl(l_del_int_rec.TP_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);
3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);
3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);
3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);

Line 3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);

3180: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE13 := nvl(l_del_int_rec.TP_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);
3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);
3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);
3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);
3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);

Line 3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);

3181: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE14 := nvl(l_del_int_rec.TP_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);
3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);
3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);
3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);
3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);
3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);

Line 3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);

3182: l_dlvy_attr_tab(l_index).TP_ATTRIBUTE15 := nvl(l_del_int_rec.TP_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);
3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);
3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);
3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);
3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);
3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);
3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);

Line 3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);

3183: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE_CATEGORY := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR);
3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);
3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);
3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);
3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);
3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);
3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);
3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);
3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);

Line 3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);

3184: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE1 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE1 , FND_API.G_MISS_CHAR);
3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);
3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);
3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);
3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);
3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);
3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);
3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);
3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);

Line 3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);

3185: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE2 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE2 , FND_API.G_MISS_CHAR);
3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);
3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);
3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);
3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);
3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);
3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);
3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);
3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);

Line 3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);

3186: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE3 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE3 , FND_API.G_MISS_CHAR);
3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);
3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);
3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);
3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);
3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);
3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);
3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);

Line 3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);

3187: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE4 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE4 , FND_API.G_MISS_CHAR);
3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);
3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);
3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);
3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);
3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);
3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);

Line 3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);

3188: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE5 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE5 , FND_API.G_MISS_CHAR);
3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);
3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);
3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);
3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);
3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);

Line 3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);

3189: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE6 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE6 , FND_API.G_MISS_CHAR);
3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);
3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);
3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);
3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);

Line 3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);

3190: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE7 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE7 , FND_API.G_MISS_CHAR);
3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);
3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);
3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);

Line 3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);

3191: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE8 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE8 , FND_API.G_MISS_CHAR);
3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);
3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);

Line 3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);

3192: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE9 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE9 , FND_API.G_MISS_CHAR);
3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);
3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);

Line 3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);

3193: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE10 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR);
3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);
3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);
3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);

Line 3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);

3194: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE11 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR);
3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);
3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);
3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);
3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);

Line 3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);

3195: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE12 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR);
3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);
3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);
3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);
3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);
3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);

Line 3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);

3196: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE13 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR);
3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);
3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);
3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);
3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);
3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);
3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);

Line 3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);

3197: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE14 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR);
3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);
3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);
3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);
3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);
3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);
3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);
3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);

Line 3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);

3198: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE15 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR);
3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);
3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);
3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);
3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);
3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);
3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);
3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);
3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);

Line 3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);

3199: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE16 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR);
3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);
3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);
3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);
3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);
3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);
3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);
3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);
3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);

Line 3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);

3200: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE17 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR);
3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);
3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);
3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);
3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);
3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);
3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);
3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);
3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);

Line 3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);

3201: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE18 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR);
3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);
3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);
3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);
3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);
3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);
3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);
3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);
3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);

Line 3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);

3202: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE19 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR);
3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);
3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);
3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);
3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);
3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);
3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);
3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);
3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);

Line 3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);

3203: l_dlvy_attr_tab(l_index).GLOBAL_ATTRIBUTE20 := nvl(l_del_int_rec.GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR);
3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);
3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);
3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);
3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);
3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);
3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);
3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);
3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);

Line 3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);

3204: l_dlvy_attr_tab(l_index).PROBLEM_CONTACT_REFERENCE := nvl(l_del_int_rec.PROBLEM_CONTACT_REFERENCE, FND_API.G_MISS_CHAR);
3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);
3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);
3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);
3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);
3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);
3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);
3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);
3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);

Line 3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);

3205: l_dlvy_attr_tab(l_index).COD_AMOUNT := nvl(l_del_int_rec.COD_AMOUNT, FND_API.G_MISS_NUM);
3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);
3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);
3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);
3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);
3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);
3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);
3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);
3213: l_dlvy_attr_tab(l_index).ENTRY_NUMBER := nvl(l_del_int_rec.ENTRY_NUMBER, FND_API.G_MISS_CHAR);

Line 3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);

3206: l_dlvy_attr_tab(l_index).COD_CURRENCY_CODE := nvl(l_del_int_rec.COD_CURRENCY_CODE , FND_API.G_MISS_CHAR);
3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);
3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);
3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);
3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);
3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);
3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);
3213: l_dlvy_attr_tab(l_index).ENTRY_NUMBER := nvl(l_del_int_rec.ENTRY_NUMBER, FND_API.G_MISS_CHAR);
3214: l_dlvy_attr_tab(l_index).ROUTING_INSTRUCTIONS := nvl(l_del_int_rec.ROUTING_INSTRUCTIONS , FND_API.G_MISS_CHAR);

Line 3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);

3207: l_dlvy_attr_tab(l_index).COD_REMIT_TO := nvl(l_del_int_rec.COD_REMIT_TO, FND_API.G_MISS_CHAR);
3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);
3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);
3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);
3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);
3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);
3213: l_dlvy_attr_tab(l_index).ENTRY_NUMBER := nvl(l_del_int_rec.ENTRY_NUMBER, FND_API.G_MISS_CHAR);
3214: l_dlvy_attr_tab(l_index).ROUTING_INSTRUCTIONS := nvl(l_del_int_rec.ROUTING_INSTRUCTIONS , FND_API.G_MISS_CHAR);
3215: l_dlvy_attr_tab(l_index).IN_BOND_CODE := nvl(l_del_int_rec.IN_BOND_CODE , FND_API.G_MISS_CHAR);

Line 3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);

3208: l_dlvy_attr_tab(l_index).COD_CHARGE_PAID_BY := nvl(l_del_int_rec.COD_CHARGE_PAID_BY , FND_API.G_MISS_CHAR);
3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);
3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);
3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);
3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);
3213: l_dlvy_attr_tab(l_index).ENTRY_NUMBER := nvl(l_del_int_rec.ENTRY_NUMBER, FND_API.G_MISS_CHAR);
3214: l_dlvy_attr_tab(l_index).ROUTING_INSTRUCTIONS := nvl(l_del_int_rec.ROUTING_INSTRUCTIONS , FND_API.G_MISS_CHAR);
3215: l_dlvy_attr_tab(l_index).IN_BOND_CODE := nvl(l_del_int_rec.IN_BOND_CODE , FND_API.G_MISS_CHAR);
3216: l_dlvy_attr_tab(l_index).SHIPPING_MARKS := nvl(l_del_int_rec.SHIPPING_MARKS, FND_API.G_MISS_CHAR);

Line 3213: l_dlvy_attr_tab(l_index).ENTRY_NUMBER := nvl(l_del_int_rec.ENTRY_NUMBER, FND_API.G_MISS_CHAR);

3209: l_dlvy_attr_tab(l_index).PORT_OF_LOADING := nvl(l_del_int_rec.PORT_OF_LOADING , FND_API.G_MISS_CHAR);
3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);
3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);
3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);
3213: l_dlvy_attr_tab(l_index).ENTRY_NUMBER := nvl(l_del_int_rec.ENTRY_NUMBER, FND_API.G_MISS_CHAR);
3214: l_dlvy_attr_tab(l_index).ROUTING_INSTRUCTIONS := nvl(l_del_int_rec.ROUTING_INSTRUCTIONS , FND_API.G_MISS_CHAR);
3215: l_dlvy_attr_tab(l_index).IN_BOND_CODE := nvl(l_del_int_rec.IN_BOND_CODE , FND_API.G_MISS_CHAR);
3216: l_dlvy_attr_tab(l_index).SHIPPING_MARKS := nvl(l_del_int_rec.SHIPPING_MARKS, FND_API.G_MISS_CHAR);
3217: l_txn_type := l_del_int_rec.INTERFACE_ACTION_CODE;

Line 3214: l_dlvy_attr_tab(l_index).ROUTING_INSTRUCTIONS := nvl(l_del_int_rec.ROUTING_INSTRUCTIONS , FND_API.G_MISS_CHAR);

3210: l_dlvy_attr_tab(l_index).PORT_OF_DISCHARGE := nvl(l_del_int_rec.PORT_OF_DISCHARGE , FND_API.G_MISS_CHAR);
3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);
3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);
3213: l_dlvy_attr_tab(l_index).ENTRY_NUMBER := nvl(l_del_int_rec.ENTRY_NUMBER, FND_API.G_MISS_CHAR);
3214: l_dlvy_attr_tab(l_index).ROUTING_INSTRUCTIONS := nvl(l_del_int_rec.ROUTING_INSTRUCTIONS , FND_API.G_MISS_CHAR);
3215: l_dlvy_attr_tab(l_index).IN_BOND_CODE := nvl(l_del_int_rec.IN_BOND_CODE , FND_API.G_MISS_CHAR);
3216: l_dlvy_attr_tab(l_index).SHIPPING_MARKS := nvl(l_del_int_rec.SHIPPING_MARKS, FND_API.G_MISS_CHAR);
3217: l_txn_type := l_del_int_rec.INTERFACE_ACTION_CODE;
3218: IF (nvl(l_txn_type,'!!!!') = '94X_INBOUND') THEN

Line 3215: l_dlvy_attr_tab(l_index).IN_BOND_CODE := nvl(l_del_int_rec.IN_BOND_CODE , FND_API.G_MISS_CHAR);

3211: l_dlvy_attr_tab(l_index).FTZ_NUMBER := nvl(l_del_int_rec.FTZ_NUMBER, FND_API.G_MISS_CHAR);
3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);
3213: l_dlvy_attr_tab(l_index).ENTRY_NUMBER := nvl(l_del_int_rec.ENTRY_NUMBER, FND_API.G_MISS_CHAR);
3214: l_dlvy_attr_tab(l_index).ROUTING_INSTRUCTIONS := nvl(l_del_int_rec.ROUTING_INSTRUCTIONS , FND_API.G_MISS_CHAR);
3215: l_dlvy_attr_tab(l_index).IN_BOND_CODE := nvl(l_del_int_rec.IN_BOND_CODE , FND_API.G_MISS_CHAR);
3216: l_dlvy_attr_tab(l_index).SHIPPING_MARKS := nvl(l_del_int_rec.SHIPPING_MARKS, FND_API.G_MISS_CHAR);
3217: l_txn_type := l_del_int_rec.INTERFACE_ACTION_CODE;
3218: IF (nvl(l_txn_type,'!!!!') = '94X_INBOUND') THEN
3219: l_dlvy_attr_tab(l_index).CARRIER_ID := l_del_int_rec.carrier_id;

Line 3216: l_dlvy_attr_tab(l_index).SHIPPING_MARKS := nvl(l_del_int_rec.SHIPPING_MARKS, FND_API.G_MISS_CHAR);

3212: l_dlvy_attr_tab(l_index).ROUTED_EXPORT_TXN := nvl(l_del_int_rec.ROUTED_EXPORT_TXN, FND_API.G_MISS_CHAR);
3213: l_dlvy_attr_tab(l_index).ENTRY_NUMBER := nvl(l_del_int_rec.ENTRY_NUMBER, FND_API.G_MISS_CHAR);
3214: l_dlvy_attr_tab(l_index).ROUTING_INSTRUCTIONS := nvl(l_del_int_rec.ROUTING_INSTRUCTIONS , FND_API.G_MISS_CHAR);
3215: l_dlvy_attr_tab(l_index).IN_BOND_CODE := nvl(l_del_int_rec.IN_BOND_CODE , FND_API.G_MISS_CHAR);
3216: l_dlvy_attr_tab(l_index).SHIPPING_MARKS := nvl(l_del_int_rec.SHIPPING_MARKS, FND_API.G_MISS_CHAR);
3217: l_txn_type := l_del_int_rec.INTERFACE_ACTION_CODE;
3218: IF (nvl(l_txn_type,'!!!!') = '94X_INBOUND') THEN
3219: l_dlvy_attr_tab(l_index).CARRIER_ID := l_del_int_rec.carrier_id;
3220: l_dlvy_attr_tab(l_index).CARRIER_CODE := l_del_int_rec.carrier_code;

Line 3224: l_dlvy_attr_tab(l_index).CARRIER_ID := nvl(l_del_int_rec.carrier_id, FND_API.G_MISS_NUM);

3220: l_dlvy_attr_tab(l_index).CARRIER_CODE := l_del_int_rec.carrier_code;
3221: l_dlvy_attr_tab(l_index).SERVICE_LEVEL := l_del_int_rec.SERVICE_LEVEL;
3222: l_dlvy_attr_tab(l_index).MODE_OF_TRANSPORT := l_del_int_rec.MODE_OF_TRANSPORT;
3223: ELSE
3224: l_dlvy_attr_tab(l_index).CARRIER_ID := nvl(l_del_int_rec.carrier_id, FND_API.G_MISS_NUM);
3225: l_dlvy_attr_tab(l_index).CARRIER_CODE := nvl(l_del_int_rec.carrier_code, FND_API.G_MISS_CHAR);
3226: l_dlvy_attr_tab(l_index).SERVICE_LEVEL := nvl(l_del_int_rec.SERVICE_LEVEL, FND_API.G_MISS_CHAR);
3227: l_dlvy_attr_tab(l_index).MODE_OF_TRANSPORT := nvl(l_del_int_rec.MODE_OF_TRANSPORT, FND_API.G_MISS_CHAR);
3228: END IF;

Line 3225: l_dlvy_attr_tab(l_index).CARRIER_CODE := nvl(l_del_int_rec.carrier_code, FND_API.G_MISS_CHAR);

3221: l_dlvy_attr_tab(l_index).SERVICE_LEVEL := l_del_int_rec.SERVICE_LEVEL;
3222: l_dlvy_attr_tab(l_index).MODE_OF_TRANSPORT := l_del_int_rec.MODE_OF_TRANSPORT;
3223: ELSE
3224: l_dlvy_attr_tab(l_index).CARRIER_ID := nvl(l_del_int_rec.carrier_id, FND_API.G_MISS_NUM);
3225: l_dlvy_attr_tab(l_index).CARRIER_CODE := nvl(l_del_int_rec.carrier_code, FND_API.G_MISS_CHAR);
3226: l_dlvy_attr_tab(l_index).SERVICE_LEVEL := nvl(l_del_int_rec.SERVICE_LEVEL, FND_API.G_MISS_CHAR);
3227: l_dlvy_attr_tab(l_index).MODE_OF_TRANSPORT := nvl(l_del_int_rec.MODE_OF_TRANSPORT, FND_API.G_MISS_CHAR);
3228: END IF;
3229: l_txn_type := null;

Line 3226: l_dlvy_attr_tab(l_index).SERVICE_LEVEL := nvl(l_del_int_rec.SERVICE_LEVEL, FND_API.G_MISS_CHAR);

3222: l_dlvy_attr_tab(l_index).MODE_OF_TRANSPORT := l_del_int_rec.MODE_OF_TRANSPORT;
3223: ELSE
3224: l_dlvy_attr_tab(l_index).CARRIER_ID := nvl(l_del_int_rec.carrier_id, FND_API.G_MISS_NUM);
3225: l_dlvy_attr_tab(l_index).CARRIER_CODE := nvl(l_del_int_rec.carrier_code, FND_API.G_MISS_CHAR);
3226: l_dlvy_attr_tab(l_index).SERVICE_LEVEL := nvl(l_del_int_rec.SERVICE_LEVEL, FND_API.G_MISS_CHAR);
3227: l_dlvy_attr_tab(l_index).MODE_OF_TRANSPORT := nvl(l_del_int_rec.MODE_OF_TRANSPORT, FND_API.G_MISS_CHAR);
3228: END IF;
3229: l_txn_type := null;
3230:

Line 3227: l_dlvy_attr_tab(l_index).MODE_OF_TRANSPORT := nvl(l_del_int_rec.MODE_OF_TRANSPORT, FND_API.G_MISS_CHAR);

3223: ELSE
3224: l_dlvy_attr_tab(l_index).CARRIER_ID := nvl(l_del_int_rec.carrier_id, FND_API.G_MISS_NUM);
3225: l_dlvy_attr_tab(l_index).CARRIER_CODE := nvl(l_del_int_rec.carrier_code, FND_API.G_MISS_CHAR);
3226: l_dlvy_attr_tab(l_index).SERVICE_LEVEL := nvl(l_del_int_rec.SERVICE_LEVEL, FND_API.G_MISS_CHAR);
3227: l_dlvy_attr_tab(l_index).MODE_OF_TRANSPORT := nvl(l_del_int_rec.MODE_OF_TRANSPORT, FND_API.G_MISS_CHAR);
3228: END IF;
3229: l_txn_type := null;
3230:
3231: IF l_debug_on THEN

Line 3264: p_init_msg_list => FND_API.G_FALSE,

3260: l_in_rec.action_code := p_action_code;
3261:
3262: wsh_interface_grp.Create_Update_Delivery(
3263: p_api_version_number => l_api_version_number,
3264: p_init_msg_list => FND_API.G_FALSE,
3265: p_commit => FND_API.G_FALSE,
3266: p_in_rec => l_in_rec,
3267: p_rec_attr_tab => l_dlvy_attr_tab,
3268: x_del_out_rec_tab => l_dlvy_out_rec_tab,

Line 3265: p_commit => FND_API.G_FALSE,

3261:
3262: wsh_interface_grp.Create_Update_Delivery(
3263: p_api_version_number => l_api_version_number,
3264: p_init_msg_list => FND_API.G_FALSE,
3265: p_commit => FND_API.G_FALSE,
3266: p_in_rec => l_in_rec,
3267: p_rec_attr_tab => l_dlvy_attr_tab,
3268: x_del_out_rec_tab => l_dlvy_out_rec_tab,
3269: x_return_status => l_return_status,

Line 3307: RAISE fnd_api.g_exc_error;

3303: FND_MESSAGE.SET_TOKEN('DEL_INT', p_delivery_interface_id);
3304: -- }
3305: END IF;
3306: --
3307: RAISE fnd_api.g_exc_error;
3308: -- }
3309: END IF;
3310:
3311: -- send the newly created delivery in the out parameter

Line 3369: WHEN fnd_api.g_exc_error THEN

3365: wsh_debug_sv.pop(l_module_name);
3366: END IF;
3367:
3368: EXCEPTION
3369: WHEN fnd_api.g_exc_error THEN
3370: x_return_status := fnd_api.g_ret_sts_error;
3371: --
3372: IF l_debug_on THEN
3373: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

Line 3370: x_return_status := fnd_api.g_ret_sts_error;

3366: END IF;
3367:
3368: EXCEPTION
3369: WHEN fnd_api.g_exc_error THEN
3370: x_return_status := fnd_api.g_ret_sts_error;
3371: --
3372: IF l_debug_on THEN
3373: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3374: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

Line 3373: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

3369: WHEN fnd_api.g_exc_error THEN
3370: x_return_status := fnd_api.g_ret_sts_error;
3371: --
3372: IF l_debug_on THEN
3373: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3374: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
3375: END IF;
3376: --
3377: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3374: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

3370: x_return_status := fnd_api.g_ret_sts_error;
3371: --
3372: IF l_debug_on THEN
3373: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3374: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
3375: END IF;
3376: --
3377: WHEN fnd_api.g_exc_unexpected_error THEN
3378: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3377: WHEN fnd_api.g_exc_unexpected_error THEN

3373: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3374: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
3375: END IF;
3376: --
3377: WHEN fnd_api.g_exc_unexpected_error THEN
3378: x_return_status := fnd_api.g_ret_sts_unexp_error;
3379: --
3380: IF l_debug_on THEN
3381: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

Line 3378: x_return_status := fnd_api.g_ret_sts_unexp_error;

3374: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
3375: END IF;
3376: --
3377: WHEN fnd_api.g_exc_unexpected_error THEN
3378: x_return_status := fnd_api.g_ret_sts_unexp_error;
3379: --
3380: IF l_debug_on THEN
3381: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3382: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 3381: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

3377: WHEN fnd_api.g_exc_unexpected_error THEN
3378: x_return_status := fnd_api.g_ret_sts_unexp_error;
3379: --
3380: IF l_debug_on THEN
3381: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3382: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3383: END IF;
3384: --
3385: WHEN wsh_util_core.g_exc_warning THEN

Line 3382: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3378: x_return_status := fnd_api.g_ret_sts_unexp_error;
3379: --
3380: IF l_debug_on THEN
3381: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
3382: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3383: END IF;
3384: --
3385: WHEN wsh_util_core.g_exc_warning THEN
3386: x_return_status := wsh_util_core.g_ret_sts_warning;

Line 4179: P_INIT_MSG_LIST => FND_API.G_FALSE,

4175: l_in_rec.phase := 1;
4176:
4177: wsh_delivery_Details_grp.create_update_delivery_detail(
4178: P_API_VERSION_NUMBER => 1.0,
4179: P_INIT_MSG_LIST => FND_API.G_FALSE,
4180: P_COMMIT => FND_API.G_FALSE,
4181: x_RETURN_STATUS => l_RETURN_STATUS,
4182: X_MSG_COUNT => l_MSG_COUNT,
4183: X_MSG_DATA => l_MSG_DATA,

Line 4180: P_COMMIT => FND_API.G_FALSE,

4176:
4177: wsh_delivery_Details_grp.create_update_delivery_detail(
4178: P_API_VERSION_NUMBER => 1.0,
4179: P_INIT_MSG_LIST => FND_API.G_FALSE,
4180: P_COMMIT => FND_API.G_FALSE,
4181: x_RETURN_STATUS => l_RETURN_STATUS,
4182: X_MSG_COUNT => l_MSG_COUNT,
4183: X_MSG_DATA => l_MSG_DATA,
4184: P_DETAIL_INFO_TAB => G_Update_Attributes_Tab,

Line 4274: p_init_msg_lst => FND_API.G_TRUE,

4270: -- 2. Return Status of Process_Reservation api will NOT be handled
4271: -- Documented the same in MED under Closed Issues
4272: INV_RSV_DETAIL_STAGE_PVT.Process_Reservation(
4273: p_api_version_number => 1.0,
4274: p_init_msg_lst => FND_API.G_TRUE,
4275: p_rsv_rec => l_rsv_rec,
4276: p_serial_number => l_serial_number_tbl,
4277: p_rsv_status => 'STAGE',
4278: x_return_status => l_return_status,

Line 4960: IF(nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) = 'CMS') AND (p_del_det_int_rec.container_flag = 'Y') THEN

4956: l_changed_attributes.preferred_grade := p_del_det_int_rec.preferred_grade;
4957:
4958: --bugfix 8841528
4959:
4960: IF(nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) = 'CMS') AND (p_del_det_int_rec.container_flag = 'Y') THEN
4961:
4962: OPEN inv_detail_cur;
4963: FETCH inv_detail_cur INTO l_delivery_detail_id,l_subinventory,l_locator_id;
4964: CLOSE inv_detail_cur;

Line 4998: l_changed_attributes.serial_number := nvl(p_del_det_int_rec.serial_number, FND_API.G_MISS_CHAR);

4994: -- HW OPMCONV - No need for sublot_number
4995: -- l_changed_attributes.sublot_number := p_del_det_int_rec.sublot_number;
4996: l_changed_attributes.customer_requested_lot_flag := p_del_det_int_rec.customer_requested_lot_flag;
4997: /* --kvenkate commenting the following line in patchset I
4998: l_changed_attributes.serial_number := nvl(p_del_det_int_rec.serial_number, FND_API.G_MISS_CHAR);
4999: */
5000: l_changed_attributes.serial_number := p_del_det_int_rec.serial_number;
5001: l_changed_attributes.master_container_item_id := p_del_det_int_rec.master_container_item_id;
5002: l_changed_attributes.detail_container_item_id := p_del_det_int_rec.detail_container_item_id;

Line 5044: AND (NVL(p_del_det_int_rec.container_name ,FND_API.G_MISS_CHAR) <>

5040: END IF;
5041:
5042: --Bugfix 11070825 removed concatenation of dd to container name in case of CMS org
5043: IF (p_del_det_int_rec.container_flag = 'Y' )
5044: AND (NVL(p_del_det_int_rec.container_name ,FND_API.G_MISS_CHAR) <>
5045: FND_API.G_MISS_CHAR)
5046: AND (NVL(p_del_det_int_rec.delivery_detail_id,FND_API.G_MISS_NUM) <>
5047: FND_API.G_MISS_NUM)
5048: AND (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) <> 'CMS')

Line 5045: FND_API.G_MISS_CHAR)

5041:
5042: --Bugfix 11070825 removed concatenation of dd to container name in case of CMS org
5043: IF (p_del_det_int_rec.container_flag = 'Y' )
5044: AND (NVL(p_del_det_int_rec.container_name ,FND_API.G_MISS_CHAR) <>
5045: FND_API.G_MISS_CHAR)
5046: AND (NVL(p_del_det_int_rec.delivery_detail_id,FND_API.G_MISS_NUM) <>
5047: FND_API.G_MISS_NUM)
5048: AND (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) <> 'CMS')
5049: THEN

Line 5046: AND (NVL(p_del_det_int_rec.delivery_detail_id,FND_API.G_MISS_NUM) <>

5042: --Bugfix 11070825 removed concatenation of dd to container name in case of CMS org
5043: IF (p_del_det_int_rec.container_flag = 'Y' )
5044: AND (NVL(p_del_det_int_rec.container_name ,FND_API.G_MISS_CHAR) <>
5045: FND_API.G_MISS_CHAR)
5046: AND (NVL(p_del_det_int_rec.delivery_detail_id,FND_API.G_MISS_NUM) <>
5047: FND_API.G_MISS_NUM)
5048: AND (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) <> 'CMS')
5049: THEN
5050: l_changed_attributes.container_name :=

Line 5047: FND_API.G_MISS_NUM)

5043: IF (p_del_det_int_rec.container_flag = 'Y' )
5044: AND (NVL(p_del_det_int_rec.container_name ,FND_API.G_MISS_CHAR) <>
5045: FND_API.G_MISS_CHAR)
5046: AND (NVL(p_del_det_int_rec.delivery_detail_id,FND_API.G_MISS_NUM) <>
5047: FND_API.G_MISS_NUM)
5048: AND (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) <> 'CMS')
5049: THEN
5050: l_changed_attributes.container_name :=
5051: SUBSTRB(p_del_det_int_rec.container_name ,1,30);

Line 5048: AND (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) <> 'CMS')

5044: AND (NVL(p_del_det_int_rec.container_name ,FND_API.G_MISS_CHAR) <>
5045: FND_API.G_MISS_CHAR)
5046: AND (NVL(p_del_det_int_rec.delivery_detail_id,FND_API.G_MISS_NUM) <>
5047: FND_API.G_MISS_NUM)
5048: AND (nvl(WSH_INBOUND_SHIP_ADVICE_PKG.G_WAREHOUSE_TYPE, FND_API.G_MISS_CHAR) <> 'CMS')
5049: THEN
5050: l_changed_attributes.container_name :=
5051: SUBSTRB(p_del_det_int_rec.container_name ,1,30);
5052: ELSE

Line 5054: nvl(p_del_det_int_rec.container_name,FND_API.G_MISS_CHAR);

5050: l_changed_attributes.container_name :=
5051: SUBSTRB(p_del_det_int_rec.container_name ,1,30);
5052: ELSE
5053: l_changed_attributes.container_name :=
5054: nvl(p_del_det_int_rec.container_name,FND_API.G_MISS_CHAR);
5055: END IF;
5056:
5057: IF l_debug_on THEN
5058: wsh_debug_sv.log(l_module_name,'New container name',

Line 5069: IF nvl(p_del_det_int_rec.shipped_quantity,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

5065: IF l_debug_on THEN
5066: wsh_debug_sv.log (l_module_name, 'Shipped Quantity ', p_del_det_int_rec.shipped_quantity);
5067: END IF;
5068:
5069: IF nvl(p_del_det_int_rec.shipped_quantity,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
5070: l_changed_attributes.shipped_quantity := 0;
5071: ELSE
5072: l_changed_attributes.shipped_quantity := p_del_det_int_rec.shipped_quantity;
5073: END IF;

Line 5552: RAISE FND_API.G_EXC_ERROR;

5548: IF p_qty_to_split IS NULL THEN
5549: fnd_message.set_name('WSH', 'WSH_REQUIRED_FIELD_NULL');
5550: fnd_message.set_token('FIELD_NAME', 'REQUESTED_QTY');
5551: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
5552: RAISE FND_API.G_EXC_ERROR;
5553: END IF;
5554:
5555: l_qty_to_split := p_qty_to_split;
5556: wsh_delivery_details_actions.split_delivery_details(

Line 5586: WHEN fnd_api.g_exc_error THEN

5582: IF l_debug_on THEN
5583: wsh_debug_sv.pop(l_module_name);
5584: END IF;
5585: EXCEPTION
5586: WHEN fnd_api.g_exc_error THEN
5587: x_return_status := fnd_api.g_ret_sts_error;
5588: --
5589: IF l_debug_on THEN
5590: wsh_debug_sv.logmsg(l_module_name,

Line 5587: x_return_status := fnd_api.g_ret_sts_error;

5583: wsh_debug_sv.pop(l_module_name);
5584: END IF;
5585: EXCEPTION
5586: WHEN fnd_api.g_exc_error THEN
5587: x_return_status := fnd_api.g_ret_sts_error;
5588: --
5589: IF l_debug_on THEN
5590: wsh_debug_sv.logmsg(l_module_name,
5591: 'FND_API.G_EXC_ERROR exception has occured.',

Line 5591: 'FND_API.G_EXC_ERROR exception has occured.',

5587: x_return_status := fnd_api.g_ret_sts_error;
5588: --
5589: IF l_debug_on THEN
5590: wsh_debug_sv.logmsg(l_module_name,
5591: 'FND_API.G_EXC_ERROR exception has occured.',
5592: wsh_debug_sv.c_excep_level);
5593: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
5594: END IF;
5595: --

Line 5593: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

5589: IF l_debug_on THEN
5590: wsh_debug_sv.logmsg(l_module_name,
5591: 'FND_API.G_EXC_ERROR exception has occured.',
5592: wsh_debug_sv.c_excep_level);
5593: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
5594: END IF;
5595: --
5596: WHEN fnd_api.g_exc_unexpected_error THEN
5597: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5596: WHEN fnd_api.g_exc_unexpected_error THEN

5592: wsh_debug_sv.c_excep_level);
5593: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
5594: END IF;
5595: --
5596: WHEN fnd_api.g_exc_unexpected_error THEN
5597: x_return_status := fnd_api.g_ret_sts_unexp_error;
5598: --
5599: IF l_debug_on THEN
5600: wsh_debug_sv.logmsg(l_module_name,

Line 5597: x_return_status := fnd_api.g_ret_sts_unexp_error;

5593: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
5594: END IF;
5595: --
5596: WHEN fnd_api.g_exc_unexpected_error THEN
5597: x_return_status := fnd_api.g_ret_sts_unexp_error;
5598: --
5599: IF l_debug_on THEN
5600: wsh_debug_sv.logmsg(l_module_name,
5601: 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

Line 5601: 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',

5597: x_return_status := fnd_api.g_ret_sts_unexp_error;
5598: --
5599: IF l_debug_on THEN
5600: wsh_debug_sv.logmsg(l_module_name,
5601: 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
5602: wsh_debug_sv.c_excep_level);
5603: wsh_debug_sv.pop(l_module_name,
5604: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5605: END IF;

Line 5604: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

5600: wsh_debug_sv.logmsg(l_module_name,
5601: 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
5602: wsh_debug_sv.c_excep_level);
5603: wsh_debug_sv.pop(l_module_name,
5604: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5605: END IF;
5606: --
5607: WHEN wsh_util_core.g_exc_warning THEN
5608: x_return_status := wsh_util_core.g_ret_sts_warning;

Line 5648: raise fnd_api.g_exc_error;

5644: l_index := p_serial_range_tab.next(l_index);
5645: end loop;
5646: EXCEPTION
5647: WHEN OTHERS THEN
5648: raise fnd_api.g_exc_error;
5649: END add_to_serial_table;
5650:
5651: END WSH_INTERFACE_COMMON_ACTIONS;