1300: END IF;
1301:
1302: wsh_deliveries_grp.delivery_action(
1303: p_api_version_number => 1.0,
1304: p_init_msg_list => FND_API.G_FALSE,
1305: p_commit => FND_API.G_FALSE,
1306: p_action_prms => l_action_prms,
1307: p_rec_attr_tab => l_select_carrier_tbl,
1308: x_delivery_out_rec => l_delivery_out_rec,
1301:
1302: wsh_deliveries_grp.delivery_action(
1303: p_api_version_number => 1.0,
1304: p_init_msg_list => FND_API.G_FALSE,
1305: p_commit => FND_API.G_FALSE,
1306: p_action_prms => l_action_prms,
1307: p_rec_attr_tab => l_select_carrier_tbl,
1308: x_delivery_out_rec => l_delivery_out_rec,
1309: x_defaults_rec => l_defaults_rec,
1332: l_action_prms.ignore_ineligible_dels := 'Y';
1333:
1334: wsh_deliveries_grp.delivery_action(
1335: p_api_version_number => 1.0,
1336: p_init_msg_list => FND_API.G_FALSE,
1337: p_commit => FND_API.G_FALSE,
1338: p_action_prms => l_action_prms,
1339: p_rec_attr_tab => l_auto_rate_tbl,
1340: x_delivery_out_rec => l_delivery_out_rec,
1333:
1334: wsh_deliveries_grp.delivery_action(
1335: p_api_version_number => 1.0,
1336: p_init_msg_list => FND_API.G_FALSE,
1337: p_commit => FND_API.G_FALSE,
1338: p_action_prms => l_action_prms,
1339: p_rec_attr_tab => l_auto_rate_tbl,
1340: x_delivery_out_rec => l_delivery_out_rec,
1341: x_defaults_rec => l_defaults_rec,
3191: IF p_action_flag IS NULL
3192: OR p_action_flag NOT IN ('S', 'B', 'L', 'T', 'A', 'C', 'O') THEN
3193: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_SC_ACTION_FLAG');
3194: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
3195: RAISE FND_API.G_EXC_ERROR;
3196: END IF;
3197: -- bug 2778035
3198:
3199: -- Fix for Bug 3944151
5793: IF wsh_util_core.fte_is_installed='Y' THEN
5794:
5795: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(
5796: p_api_version_number => 1.0,
5797: p_init_msg_list => FND_API.G_FALSE,
5798: p_entity_type => 'D',
5799: p_target_id => l_target_trip_id,
5800: p_action_code => 'AUTOCREATE-TRIP',
5801: p_del_attr_tab => l_cc_del_attr_tab,
5941: IF l_trip_info_tab.COUNT>0 THEN
5942:
5943: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(
5944: p_api_version_number => 1.0,
5945: p_init_msg_list => FND_API.G_FALSE,
5946: p_entity_type => 'T',
5947: p_target_id => l_target_trip_id,
5948: p_action_code => 'UPDATE',
5949: p_del_attr_tab => l_cc_del_attr_tab,
6142: END IF;
6143:
6144: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(
6145: p_api_version_number => 1.0,
6146: p_init_msg_list => FND_API.G_FALSE,
6147: p_entity_type => 'T',
6148: p_target_id => l_target_trip_id,
6149: p_action_code => 'UPDATE',
6150: p_del_attr_tab => l_cc_del_attr_tab,
6552: -- WMS: pass warnings to WMS for processing:
6553: WMS_SHIPPING_MESSAGES.PROCESS_SHIPPING_WARNING_MSGS(x_return_status => l_return_status ,
6554: x_msg_count => l_msg_count ,
6555: x_msg_data => l_msg_data,
6556: p_commit => FND_API.g_false,
6557: x_shipping_msg_tab => l_msg_table);
6558:
6559: -- Check if there exists an 'E' message in the l_msg_table
6560: -- If there is then turn the message type to 'E' for the particular message name in
7309: WSH_DEBUG_SV.pop(l_module_name);
7310: END IF;
7311: --
7312: EXCEPTION
7313: WHEN FND_API.G_EXC_ERROR THEN
7314:
7315: IF (Get_Trip%ISOPEN) THEN
7316: CLOSE Get_Trip;
7317: END IF;
7322:
7323: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7324: --
7325: IF l_debug_on THEN
7326: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7327: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7328: END IF;
7329: --
7330: WHEN ship_confirm_error THEN
7323: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7324: --
7325: IF l_debug_on THEN
7326: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7327: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7328: END IF;
7329: --
7330: WHEN ship_confirm_error THEN
7331:
7684: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
7685: END IF;
7686: -- Only Handle Unexpected error
7687: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
7688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7689: END IF;
7690: -- End of Code for DBI Project
7691: --
7692: -- R12.1.1 STANDALONE PROJECT
7827: x_return_status := l_return_status;
7828: wsh_util_core.add_message(x_return_status);
7829: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7830: l_num_errors := l_num_errors + 1;
7831: RAISE FND_API.G_EXC_ERROR;
7832: ELSE
7833: l_num_warnings := l_num_warnings + 1 ;
7834: END IF;
7835: END IF;
7854: --
7855: --}
7856: EXCEPTION
7857: --{
7858: WHEN FND_API.G_EXC_ERROR THEN
7859:
7860: --ROLLBACK TO dlvy_setInTransit_begin_sp;
7861: --
7862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7861: --
7862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7863: --
7864: IF l_debug_on THEN
7865: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7866: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7867: END IF;
7868: --
7869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7863: --
7864: IF l_debug_on THEN
7865: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7866: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7867: END IF;
7868: --
7869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7870:
7865: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7866: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7867: END IF;
7868: --
7869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7870:
7871: --ROLLBACK TO dlvy_setInTransit_begin_sp;
7872: --
7873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
7873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
7874: --
7875: IF l_debug_on THEN
7876: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7877: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7878: END IF;
7879: --
7880: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7881: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8033: IF (SQL%NOTFOUND)
8034: THEN
8035: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
8036: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8037: RAISE FND_API.G_EXC_ERROR;
8038: END IF;
8039: --
8040:
8041:
8091: x_return_status := l_return_status;
8092: wsh_util_core.add_message(x_return_status);
8093: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
8094: l_num_errors := l_num_errors + 1;
8095: RAISE FND_API.G_EXC_ERROR;
8096: ELSE
8097: l_num_warnings := l_num_warnings + 1 ;
8098: END IF;
8099: END IF;
8172: --}
8173: EXCEPTION
8174: --{
8175: --
8176: WHEN FND_API.G_EXC_ERROR THEN
8177:
8178: --ROLLBACK TO dlvy_close_begin_sp;
8179: --
8180: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8179: --
8180: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8181: --
8182: IF l_debug_on THEN
8183: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8185: END IF;
8186: --
8187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8180: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8181: --
8182: IF l_debug_on THEN
8183: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8185: END IF;
8186: --
8187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8188:
8183: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8185: END IF;
8186: --
8187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8188:
8189: --ROLLBACK TO dlvy_close_begin_sp;
8190: --
8191: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8191: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8192: --
8193: IF l_debug_on THEN
8194: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
8195: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
8196: END IF;
8197: --
8198: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
8199: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
8346: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
8347: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8348: --CLOSE del_status;
8349: l_num_errors := l_num_errors + 1;
8350: RAISE FND_API.G_EXC_ERROR;
8351: END IF;
8352: -- J-IB-NPARIKH---}
8353: --
8354: --
8405: l_num_warnings := l_num_warnings + 1;
8406: RAISE wsh_util_core.g_exc_warning;
8407: ELSE
8408: l_num_errors := l_num_errors + 1;
8409: RAISE FND_API.G_EXC_ERROR;
8410: END IF;
8411: --
8412: --
8413: IF l_debug_on THEN
8483: l_num_warnings := l_num_warnings + 1;
8484: RAISE wsh_util_core.g_exc_warning;
8485: ELSE
8486: l_num_errors := l_num_errors + 1;
8487: RAISE FND_API.G_EXC_ERROR;
8488: END IF;
8489: --
8490: --
8491: IF l_debug_on THEN
8607: IF (SQL%NOTFOUND) THEN
8608: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');
8609: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
8610: l_num_errors := l_num_errors + 1;
8611: RAISE FND_API.G_EXC_ERROR;
8612: END IF;
8613:
8614: -- K: MDC:
8615: -- Reopen the consol delivery as well if it exists and is not open
8656: END IF;
8657: --}
8658: EXCEPTION
8659: --{
8660: WHEN FND_API.G_EXC_ERROR
8661: THEN
8662: --{
8663: ROLLBACK TO dlvy_chg_status_sp;
8664: --
8712: WSH_DEBUG_SV.pop(l_module_name);
8713: END IF;
8714: --
8715: EXCEPTION
8716: WHEN FND_API.G_EXC_ERROR THEN
8717: ROLLBACK TO dlvy_chg_status_begin_sp;
8718: --
8719: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8720: --
8718: --
8719: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8720: --
8721: IF l_debug_on THEN
8722: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8723: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8724: END IF;
8725: --
8726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8719: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8720: --
8721: IF l_debug_on THEN
8722: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8723: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8724: END IF;
8725: --
8726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8727:
8722: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
8723: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
8724: END IF;
8725: --
8726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8727:
8728: ROLLBACK TO dlvy_chg_status_begin_sp;
8729: --
8730: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8730: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8731: --
8732: IF l_debug_on THEN
8733: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
8734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
8735: END IF;
8736: --
8737: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
8738: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9660: -- Delivery id is mandatory input
9661: --
9662: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
9663: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'p_delivery_id');
9664: RAISE FND_API.G_EXC_ERROR;
9665: --}
9666: END IF;
9667: --
9668: --
9677: --
9678: -- Raise error for invalid Delivery id
9679: --
9680: fnd_message.SET_name('WSH', 'WSH_DET_INVALID_DEL');
9681: RAISE FND_API.G_EXC_ERROR;
9682: --}
9683: END IF;
9684: --
9685: CLOSE dlvy_Csr;
9872: THEN
9873: --{
9874: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9875: fnd_message.SET_name('WSH', 'WSH_DET_INVALID_DEL');
9876: RAISE FND_API.G_EXC_ERROR;
9877: --}
9878: END IF;
9879: --
9880: x_freight_terms_code := l_dlvy_freight_terms_code;
9918: IF l_debug_on
9919: THEN
9920: WSH_DEBUG_SV.pop(l_module_name);
9921: END IF;
9922: WHEN FND_API.G_EXC_ERROR THEN
9923: x_return_status := wsh_util_core.g_ret_sts_error;
9924: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
9925: --
9926: IF l_debug_on
9924: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
9925: --
9926: IF l_debug_on
9927: THEN
9928: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
9929: END IF;
9930: WHEN e_locked THEN
9931: x_return_status := wsh_util_core.g_ret_sts_error;
9932:
9938: THEN
9939: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:e_locked');
9940: END IF;
9941: WHEN OTHERS THEN
9942: x_return_status := fnd_api.g_ret_sts_unexp_error;
9943: wsh_util_core.default_handler('WSH_NEW_DELIVERY_ACTIONS.update_freight_terms',l_module_name);
9944: --
9945: IF l_debug_on THEN
9946: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
10069: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
10070: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'p_delivery_id');
10071: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
10072: --
10073: RAISE FND_API.G_EXC_ERROR;
10074: --}
10075: END IF;
10076: --
10077: --
10085: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_NOT_EXIST');
10086: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id);
10087: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
10088: --
10089: RAISE FND_API.G_EXC_ERROR;
10090: --}
10091: END IF;
10092: --
10093: --
10314: --}
10315: EXCEPTION
10316: --{
10317: --
10318: WHEN FND_API.G_EXC_ERROR THEN
10319:
10320: ROLLBACK TO update_ship_from_location_sp;
10321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10322: --
10320: ROLLBACK TO update_ship_from_location_sp;
10321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10322: --
10323: IF l_debug_on THEN
10324: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10325: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10326: END IF;
10327: --
10328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10322: --
10323: IF l_debug_on THEN
10324: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10325: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10326: END IF;
10327: --
10328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10329:
10324: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10325: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10326: END IF;
10327: --
10328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10329:
10330: ROLLBACK TO update_ship_from_location_sp;
10331: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10332: --
10331: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10332: --
10333: IF l_debug_on THEN
10334: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10336: END IF;
10337: --
10338: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10339: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10679: WSH_UTIL_CORE.default_handler('WSH_NEW_DELIVERY_ACTIONS.IS_DLVY_CONTENT');
10680: --
10681: IF l_debug_on THEN
10682: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10683: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10684: END IF;
10685:
10686: END IS_DLVY_CONTENT;
10687:
10813: --
10814:
10815: IF l_debug_on THEN
10816: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10817: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10818: END IF;
10819: --
10820: END GET_SHIP_TO_SITE;
10821:
10949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
10950: --
10951: IF l_debug_on THEN
10952: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10953: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10954: END IF;
10955: --
10956: END GET_SHIP_TO_CUSTOMER;
10957:
11230:
11231: IF l_debug_on THEN
11232:
11233: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
11234: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
11235:
11236: END IF;
11237:
11238: END SET_PICK_UP_DROP_OFF_DATES;
11350: fmc := fmc + 1;
11351: IF (p_cs_result_tab(fm).delivery_id is not null) THEN
11352:
11353: x_rec_attr_tab(fmc).DELIVERY_ID := p_cs_result_tab(fm).delivery_id;
11354: x_rec_attr_tab(fmc).NAME := FND_API.G_MISS_CHAR;
11355: x_rec_attr_tab(fmc).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11356: x_rec_attr_tab(fmc).STATUS_CODE := FND_API.G_MISS_CHAR;
11357: x_rec_attr_tab(fmc).DELIVERY_TYPE := FND_API.G_MISS_CHAR;
11358: x_rec_attr_tab(fmc).LOADING_SEQUENCE := FND_API.G_MISS_NUM;
11351: IF (p_cs_result_tab(fm).delivery_id is not null) THEN
11352:
11353: x_rec_attr_tab(fmc).DELIVERY_ID := p_cs_result_tab(fm).delivery_id;
11354: x_rec_attr_tab(fmc).NAME := FND_API.G_MISS_CHAR;
11355: x_rec_attr_tab(fmc).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11356: x_rec_attr_tab(fmc).STATUS_CODE := FND_API.G_MISS_CHAR;
11357: x_rec_attr_tab(fmc).DELIVERY_TYPE := FND_API.G_MISS_CHAR;
11358: x_rec_attr_tab(fmc).LOADING_SEQUENCE := FND_API.G_MISS_NUM;
11359: x_rec_attr_tab(fmc).LOADING_ORDER_FLAG := FND_API.G_MISS_CHAR;
11352:
11353: x_rec_attr_tab(fmc).DELIVERY_ID := p_cs_result_tab(fm).delivery_id;
11354: x_rec_attr_tab(fmc).NAME := FND_API.G_MISS_CHAR;
11355: x_rec_attr_tab(fmc).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11356: x_rec_attr_tab(fmc).STATUS_CODE := FND_API.G_MISS_CHAR;
11357: x_rec_attr_tab(fmc).DELIVERY_TYPE := FND_API.G_MISS_CHAR;
11358: x_rec_attr_tab(fmc).LOADING_SEQUENCE := FND_API.G_MISS_NUM;
11359: x_rec_attr_tab(fmc).LOADING_ORDER_FLAG := FND_API.G_MISS_CHAR;
11360: x_rec_attr_tab(fmc).INITIAL_PICKUP_DATE := FND_API.G_MISS_DATE;
11353: x_rec_attr_tab(fmc).DELIVERY_ID := p_cs_result_tab(fm).delivery_id;
11354: x_rec_attr_tab(fmc).NAME := FND_API.G_MISS_CHAR;
11355: x_rec_attr_tab(fmc).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11356: x_rec_attr_tab(fmc).STATUS_CODE := FND_API.G_MISS_CHAR;
11357: x_rec_attr_tab(fmc).DELIVERY_TYPE := FND_API.G_MISS_CHAR;
11358: x_rec_attr_tab(fmc).LOADING_SEQUENCE := FND_API.G_MISS_NUM;
11359: x_rec_attr_tab(fmc).LOADING_ORDER_FLAG := FND_API.G_MISS_CHAR;
11360: x_rec_attr_tab(fmc).INITIAL_PICKUP_DATE := FND_API.G_MISS_DATE;
11361: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_ID := FND_API.G_MISS_NUM;
11354: x_rec_attr_tab(fmc).NAME := FND_API.G_MISS_CHAR;
11355: x_rec_attr_tab(fmc).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11356: x_rec_attr_tab(fmc).STATUS_CODE := FND_API.G_MISS_CHAR;
11357: x_rec_attr_tab(fmc).DELIVERY_TYPE := FND_API.G_MISS_CHAR;
11358: x_rec_attr_tab(fmc).LOADING_SEQUENCE := FND_API.G_MISS_NUM;
11359: x_rec_attr_tab(fmc).LOADING_ORDER_FLAG := FND_API.G_MISS_CHAR;
11360: x_rec_attr_tab(fmc).INITIAL_PICKUP_DATE := FND_API.G_MISS_DATE;
11361: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_ID := FND_API.G_MISS_NUM;
11362: x_rec_attr_tab(fmc).ORGANIZATION_ID := FND_API.G_MISS_NUM;
11355: x_rec_attr_tab(fmc).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11356: x_rec_attr_tab(fmc).STATUS_CODE := FND_API.G_MISS_CHAR;
11357: x_rec_attr_tab(fmc).DELIVERY_TYPE := FND_API.G_MISS_CHAR;
11358: x_rec_attr_tab(fmc).LOADING_SEQUENCE := FND_API.G_MISS_NUM;
11359: x_rec_attr_tab(fmc).LOADING_ORDER_FLAG := FND_API.G_MISS_CHAR;
11360: x_rec_attr_tab(fmc).INITIAL_PICKUP_DATE := FND_API.G_MISS_DATE;
11361: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_ID := FND_API.G_MISS_NUM;
11362: x_rec_attr_tab(fmc).ORGANIZATION_ID := FND_API.G_MISS_NUM;
11363: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_ID := FND_API.G_MISS_NUM;
11356: x_rec_attr_tab(fmc).STATUS_CODE := FND_API.G_MISS_CHAR;
11357: x_rec_attr_tab(fmc).DELIVERY_TYPE := FND_API.G_MISS_CHAR;
11358: x_rec_attr_tab(fmc).LOADING_SEQUENCE := FND_API.G_MISS_NUM;
11359: x_rec_attr_tab(fmc).LOADING_ORDER_FLAG := FND_API.G_MISS_CHAR;
11360: x_rec_attr_tab(fmc).INITIAL_PICKUP_DATE := FND_API.G_MISS_DATE;
11361: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_ID := FND_API.G_MISS_NUM;
11362: x_rec_attr_tab(fmc).ORGANIZATION_ID := FND_API.G_MISS_NUM;
11363: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_ID := FND_API.G_MISS_NUM;
11364: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_DATE := FND_API.G_MISS_DATE;
11357: x_rec_attr_tab(fmc).DELIVERY_TYPE := FND_API.G_MISS_CHAR;
11358: x_rec_attr_tab(fmc).LOADING_SEQUENCE := FND_API.G_MISS_NUM;
11359: x_rec_attr_tab(fmc).LOADING_ORDER_FLAG := FND_API.G_MISS_CHAR;
11360: x_rec_attr_tab(fmc).INITIAL_PICKUP_DATE := FND_API.G_MISS_DATE;
11361: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_ID := FND_API.G_MISS_NUM;
11362: x_rec_attr_tab(fmc).ORGANIZATION_ID := FND_API.G_MISS_NUM;
11363: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_ID := FND_API.G_MISS_NUM;
11364: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_DATE := FND_API.G_MISS_DATE;
11365: x_rec_attr_tab(fmc).CUSTOMER_ID := FND_API.G_MISS_NUM;
11358: x_rec_attr_tab(fmc).LOADING_SEQUENCE := FND_API.G_MISS_NUM;
11359: x_rec_attr_tab(fmc).LOADING_ORDER_FLAG := FND_API.G_MISS_CHAR;
11360: x_rec_attr_tab(fmc).INITIAL_PICKUP_DATE := FND_API.G_MISS_DATE;
11361: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_ID := FND_API.G_MISS_NUM;
11362: x_rec_attr_tab(fmc).ORGANIZATION_ID := FND_API.G_MISS_NUM;
11363: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_ID := FND_API.G_MISS_NUM;
11364: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_DATE := FND_API.G_MISS_DATE;
11365: x_rec_attr_tab(fmc).CUSTOMER_ID := FND_API.G_MISS_NUM;
11366: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11359: x_rec_attr_tab(fmc).LOADING_ORDER_FLAG := FND_API.G_MISS_CHAR;
11360: x_rec_attr_tab(fmc).INITIAL_PICKUP_DATE := FND_API.G_MISS_DATE;
11361: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_ID := FND_API.G_MISS_NUM;
11362: x_rec_attr_tab(fmc).ORGANIZATION_ID := FND_API.G_MISS_NUM;
11363: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_ID := FND_API.G_MISS_NUM;
11364: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_DATE := FND_API.G_MISS_DATE;
11365: x_rec_attr_tab(fmc).CUSTOMER_ID := FND_API.G_MISS_NUM;
11366: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11367: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11360: x_rec_attr_tab(fmc).INITIAL_PICKUP_DATE := FND_API.G_MISS_DATE;
11361: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_ID := FND_API.G_MISS_NUM;
11362: x_rec_attr_tab(fmc).ORGANIZATION_ID := FND_API.G_MISS_NUM;
11363: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_ID := FND_API.G_MISS_NUM;
11364: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_DATE := FND_API.G_MISS_DATE;
11365: x_rec_attr_tab(fmc).CUSTOMER_ID := FND_API.G_MISS_NUM;
11366: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11367: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11368:
11361: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_ID := FND_API.G_MISS_NUM;
11362: x_rec_attr_tab(fmc).ORGANIZATION_ID := FND_API.G_MISS_NUM;
11363: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_ID := FND_API.G_MISS_NUM;
11364: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_DATE := FND_API.G_MISS_DATE;
11365: x_rec_attr_tab(fmc).CUSTOMER_ID := FND_API.G_MISS_NUM;
11366: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11367: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11368:
11369: -- Bug 4524023 (issue 1)
11362: x_rec_attr_tab(fmc).ORGANIZATION_ID := FND_API.G_MISS_NUM;
11363: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_ID := FND_API.G_MISS_NUM;
11364: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_DATE := FND_API.G_MISS_DATE;
11365: x_rec_attr_tab(fmc).CUSTOMER_ID := FND_API.G_MISS_NUM;
11366: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11367: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11368:
11369: -- Bug 4524023 (issue 1)
11370: /*IF (p_cs_result_tab(fm).carrier_id is null) THEN
11363: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_ID := FND_API.G_MISS_NUM;
11364: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_DATE := FND_API.G_MISS_DATE;
11365: x_rec_attr_tab(fmc).CUSTOMER_ID := FND_API.G_MISS_NUM;
11366: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11367: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11368:
11369: -- Bug 4524023 (issue 1)
11370: /*IF (p_cs_result_tab(fm).carrier_id is null) THEN
11371: x_rec_attr_tab(fmc).CARRIER_ID := FND_API.G_MISS_NUM;
11367: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_ID := FND_API.G_MISS_NUM;
11368:
11369: -- Bug 4524023 (issue 1)
11370: /*IF (p_cs_result_tab(fm).carrier_id is null) THEN
11371: x_rec_attr_tab(fmc).CARRIER_ID := FND_API.G_MISS_NUM;
11372: ELSE*/
11373: x_rec_attr_tab(fmc).CARRIER_ID := p_cs_result_tab(fm).carrier_id;
11374:
11375: --END IF;
11374:
11375: --END IF;
11376:
11377: /*IF (p_cs_result_tab(fm).ship_method_code is null) THEN
11378: x_rec_attr_tab(fmc).SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;
11379: ELSE*/
11380: x_rec_attr_tab(fmc).SHIP_METHOD_CODE := p_cs_result_tab(fm).ship_method_code;
11381: --END IF;
11382:
11380: x_rec_attr_tab(fmc).SHIP_METHOD_CODE := p_cs_result_tab(fm).ship_method_code;
11381: --END IF;
11382:
11383: IF (p_cs_result_tab(fm).freight_terms_code IS NULL) THEN
11384: x_rec_attr_tab(fmc).FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
11385: ELSE
11386: x_rec_attr_tab(fmc).FREIGHT_TERMS_CODE := p_cs_result_tab(fm).freight_terms_code;
11387: END IF;
11388:
11385: ELSE
11386: x_rec_attr_tab(fmc).FREIGHT_TERMS_CODE := p_cs_result_tab(fm).freight_terms_code;
11387: END IF;
11388:
11389: x_rec_attr_tab(fmc).FOB_CODE := FND_API.G_MISS_CHAR;
11390: x_rec_attr_tab(fmc).FOB_LOCATION_ID := FND_API.G_MISS_NUM;
11391: x_rec_attr_tab(fmc).WAYBILL := FND_API.G_MISS_CHAR;
11392: x_rec_attr_tab(fmc).DOCK_CODE := FND_API.G_MISS_CHAR;
11393: x_rec_attr_tab(fmc).ACCEPTANCE_FLAG := FND_API.G_MISS_CHAR;
11386: x_rec_attr_tab(fmc).FREIGHT_TERMS_CODE := p_cs_result_tab(fm).freight_terms_code;
11387: END IF;
11388:
11389: x_rec_attr_tab(fmc).FOB_CODE := FND_API.G_MISS_CHAR;
11390: x_rec_attr_tab(fmc).FOB_LOCATION_ID := FND_API.G_MISS_NUM;
11391: x_rec_attr_tab(fmc).WAYBILL := FND_API.G_MISS_CHAR;
11392: x_rec_attr_tab(fmc).DOCK_CODE := FND_API.G_MISS_CHAR;
11393: x_rec_attr_tab(fmc).ACCEPTANCE_FLAG := FND_API.G_MISS_CHAR;
11394: x_rec_attr_tab(fmc).ACCEPTED_BY := FND_API.G_MISS_CHAR;
11387: END IF;
11388:
11389: x_rec_attr_tab(fmc).FOB_CODE := FND_API.G_MISS_CHAR;
11390: x_rec_attr_tab(fmc).FOB_LOCATION_ID := FND_API.G_MISS_NUM;
11391: x_rec_attr_tab(fmc).WAYBILL := FND_API.G_MISS_CHAR;
11392: x_rec_attr_tab(fmc).DOCK_CODE := FND_API.G_MISS_CHAR;
11393: x_rec_attr_tab(fmc).ACCEPTANCE_FLAG := FND_API.G_MISS_CHAR;
11394: x_rec_attr_tab(fmc).ACCEPTED_BY := FND_API.G_MISS_CHAR;
11395: x_rec_attr_tab(fmc).ACCEPTED_DATE := FND_API.G_MISS_DATE;
11388:
11389: x_rec_attr_tab(fmc).FOB_CODE := FND_API.G_MISS_CHAR;
11390: x_rec_attr_tab(fmc).FOB_LOCATION_ID := FND_API.G_MISS_NUM;
11391: x_rec_attr_tab(fmc).WAYBILL := FND_API.G_MISS_CHAR;
11392: x_rec_attr_tab(fmc).DOCK_CODE := FND_API.G_MISS_CHAR;
11393: x_rec_attr_tab(fmc).ACCEPTANCE_FLAG := FND_API.G_MISS_CHAR;
11394: x_rec_attr_tab(fmc).ACCEPTED_BY := FND_API.G_MISS_CHAR;
11395: x_rec_attr_tab(fmc).ACCEPTED_DATE := FND_API.G_MISS_DATE;
11396: x_rec_attr_tab(fmc).ACKNOWLEDGED_BY := FND_API.G_MISS_CHAR;
11389: x_rec_attr_tab(fmc).FOB_CODE := FND_API.G_MISS_CHAR;
11390: x_rec_attr_tab(fmc).FOB_LOCATION_ID := FND_API.G_MISS_NUM;
11391: x_rec_attr_tab(fmc).WAYBILL := FND_API.G_MISS_CHAR;
11392: x_rec_attr_tab(fmc).DOCK_CODE := FND_API.G_MISS_CHAR;
11393: x_rec_attr_tab(fmc).ACCEPTANCE_FLAG := FND_API.G_MISS_CHAR;
11394: x_rec_attr_tab(fmc).ACCEPTED_BY := FND_API.G_MISS_CHAR;
11395: x_rec_attr_tab(fmc).ACCEPTED_DATE := FND_API.G_MISS_DATE;
11396: x_rec_attr_tab(fmc).ACKNOWLEDGED_BY := FND_API.G_MISS_CHAR;
11397: x_rec_attr_tab(fmc).CONFIRMED_BY := FND_API.G_MISS_CHAR;
11390: x_rec_attr_tab(fmc).FOB_LOCATION_ID := FND_API.G_MISS_NUM;
11391: x_rec_attr_tab(fmc).WAYBILL := FND_API.G_MISS_CHAR;
11392: x_rec_attr_tab(fmc).DOCK_CODE := FND_API.G_MISS_CHAR;
11393: x_rec_attr_tab(fmc).ACCEPTANCE_FLAG := FND_API.G_MISS_CHAR;
11394: x_rec_attr_tab(fmc).ACCEPTED_BY := FND_API.G_MISS_CHAR;
11395: x_rec_attr_tab(fmc).ACCEPTED_DATE := FND_API.G_MISS_DATE;
11396: x_rec_attr_tab(fmc).ACKNOWLEDGED_BY := FND_API.G_MISS_CHAR;
11397: x_rec_attr_tab(fmc).CONFIRMED_BY := FND_API.G_MISS_CHAR;
11398: x_rec_attr_tab(fmc).CONFIRM_DATE := FND_API.G_MISS_DATE;
11391: x_rec_attr_tab(fmc).WAYBILL := FND_API.G_MISS_CHAR;
11392: x_rec_attr_tab(fmc).DOCK_CODE := FND_API.G_MISS_CHAR;
11393: x_rec_attr_tab(fmc).ACCEPTANCE_FLAG := FND_API.G_MISS_CHAR;
11394: x_rec_attr_tab(fmc).ACCEPTED_BY := FND_API.G_MISS_CHAR;
11395: x_rec_attr_tab(fmc).ACCEPTED_DATE := FND_API.G_MISS_DATE;
11396: x_rec_attr_tab(fmc).ACKNOWLEDGED_BY := FND_API.G_MISS_CHAR;
11397: x_rec_attr_tab(fmc).CONFIRMED_BY := FND_API.G_MISS_CHAR;
11398: x_rec_attr_tab(fmc).CONFIRM_DATE := FND_API.G_MISS_DATE;
11399: x_rec_attr_tab(fmc).ASN_DATE_SENT := FND_API.G_MISS_DATE;
11392: x_rec_attr_tab(fmc).DOCK_CODE := FND_API.G_MISS_CHAR;
11393: x_rec_attr_tab(fmc).ACCEPTANCE_FLAG := FND_API.G_MISS_CHAR;
11394: x_rec_attr_tab(fmc).ACCEPTED_BY := FND_API.G_MISS_CHAR;
11395: x_rec_attr_tab(fmc).ACCEPTED_DATE := FND_API.G_MISS_DATE;
11396: x_rec_attr_tab(fmc).ACKNOWLEDGED_BY := FND_API.G_MISS_CHAR;
11397: x_rec_attr_tab(fmc).CONFIRMED_BY := FND_API.G_MISS_CHAR;
11398: x_rec_attr_tab(fmc).CONFIRM_DATE := FND_API.G_MISS_DATE;
11399: x_rec_attr_tab(fmc).ASN_DATE_SENT := FND_API.G_MISS_DATE;
11400: x_rec_attr_tab(fmc).ASN_STATUS_CODE := FND_API.G_MISS_CHAR;
11393: x_rec_attr_tab(fmc).ACCEPTANCE_FLAG := FND_API.G_MISS_CHAR;
11394: x_rec_attr_tab(fmc).ACCEPTED_BY := FND_API.G_MISS_CHAR;
11395: x_rec_attr_tab(fmc).ACCEPTED_DATE := FND_API.G_MISS_DATE;
11396: x_rec_attr_tab(fmc).ACKNOWLEDGED_BY := FND_API.G_MISS_CHAR;
11397: x_rec_attr_tab(fmc).CONFIRMED_BY := FND_API.G_MISS_CHAR;
11398: x_rec_attr_tab(fmc).CONFIRM_DATE := FND_API.G_MISS_DATE;
11399: x_rec_attr_tab(fmc).ASN_DATE_SENT := FND_API.G_MISS_DATE;
11400: x_rec_attr_tab(fmc).ASN_STATUS_CODE := FND_API.G_MISS_CHAR;
11401: x_rec_attr_tab(fmc).ASN_SEQ_NUMBER := FND_API.G_MISS_NUM;
11394: x_rec_attr_tab(fmc).ACCEPTED_BY := FND_API.G_MISS_CHAR;
11395: x_rec_attr_tab(fmc).ACCEPTED_DATE := FND_API.G_MISS_DATE;
11396: x_rec_attr_tab(fmc).ACKNOWLEDGED_BY := FND_API.G_MISS_CHAR;
11397: x_rec_attr_tab(fmc).CONFIRMED_BY := FND_API.G_MISS_CHAR;
11398: x_rec_attr_tab(fmc).CONFIRM_DATE := FND_API.G_MISS_DATE;
11399: x_rec_attr_tab(fmc).ASN_DATE_SENT := FND_API.G_MISS_DATE;
11400: x_rec_attr_tab(fmc).ASN_STATUS_CODE := FND_API.G_MISS_CHAR;
11401: x_rec_attr_tab(fmc).ASN_SEQ_NUMBER := FND_API.G_MISS_NUM;
11402: x_rec_attr_tab(fmc).GROSS_WEIGHT := FND_API.G_MISS_NUM;
11395: x_rec_attr_tab(fmc).ACCEPTED_DATE := FND_API.G_MISS_DATE;
11396: x_rec_attr_tab(fmc).ACKNOWLEDGED_BY := FND_API.G_MISS_CHAR;
11397: x_rec_attr_tab(fmc).CONFIRMED_BY := FND_API.G_MISS_CHAR;
11398: x_rec_attr_tab(fmc).CONFIRM_DATE := FND_API.G_MISS_DATE;
11399: x_rec_attr_tab(fmc).ASN_DATE_SENT := FND_API.G_MISS_DATE;
11400: x_rec_attr_tab(fmc).ASN_STATUS_CODE := FND_API.G_MISS_CHAR;
11401: x_rec_attr_tab(fmc).ASN_SEQ_NUMBER := FND_API.G_MISS_NUM;
11402: x_rec_attr_tab(fmc).GROSS_WEIGHT := FND_API.G_MISS_NUM;
11403: x_rec_attr_tab(fmc).NET_WEIGHT := FND_API.G_MISS_NUM;
11396: x_rec_attr_tab(fmc).ACKNOWLEDGED_BY := FND_API.G_MISS_CHAR;
11397: x_rec_attr_tab(fmc).CONFIRMED_BY := FND_API.G_MISS_CHAR;
11398: x_rec_attr_tab(fmc).CONFIRM_DATE := FND_API.G_MISS_DATE;
11399: x_rec_attr_tab(fmc).ASN_DATE_SENT := FND_API.G_MISS_DATE;
11400: x_rec_attr_tab(fmc).ASN_STATUS_CODE := FND_API.G_MISS_CHAR;
11401: x_rec_attr_tab(fmc).ASN_SEQ_NUMBER := FND_API.G_MISS_NUM;
11402: x_rec_attr_tab(fmc).GROSS_WEIGHT := FND_API.G_MISS_NUM;
11403: x_rec_attr_tab(fmc).NET_WEIGHT := FND_API.G_MISS_NUM;
11404: x_rec_attr_tab(fmc).WEIGHT_UOM_CODE := FND_API.G_MISS_CHAR;
11397: x_rec_attr_tab(fmc).CONFIRMED_BY := FND_API.G_MISS_CHAR;
11398: x_rec_attr_tab(fmc).CONFIRM_DATE := FND_API.G_MISS_DATE;
11399: x_rec_attr_tab(fmc).ASN_DATE_SENT := FND_API.G_MISS_DATE;
11400: x_rec_attr_tab(fmc).ASN_STATUS_CODE := FND_API.G_MISS_CHAR;
11401: x_rec_attr_tab(fmc).ASN_SEQ_NUMBER := FND_API.G_MISS_NUM;
11402: x_rec_attr_tab(fmc).GROSS_WEIGHT := FND_API.G_MISS_NUM;
11403: x_rec_attr_tab(fmc).NET_WEIGHT := FND_API.G_MISS_NUM;
11404: x_rec_attr_tab(fmc).WEIGHT_UOM_CODE := FND_API.G_MISS_CHAR;
11405: x_rec_attr_tab(fmc).VOLUME := FND_API.G_MISS_NUM;
11398: x_rec_attr_tab(fmc).CONFIRM_DATE := FND_API.G_MISS_DATE;
11399: x_rec_attr_tab(fmc).ASN_DATE_SENT := FND_API.G_MISS_DATE;
11400: x_rec_attr_tab(fmc).ASN_STATUS_CODE := FND_API.G_MISS_CHAR;
11401: x_rec_attr_tab(fmc).ASN_SEQ_NUMBER := FND_API.G_MISS_NUM;
11402: x_rec_attr_tab(fmc).GROSS_WEIGHT := FND_API.G_MISS_NUM;
11403: x_rec_attr_tab(fmc).NET_WEIGHT := FND_API.G_MISS_NUM;
11404: x_rec_attr_tab(fmc).WEIGHT_UOM_CODE := FND_API.G_MISS_CHAR;
11405: x_rec_attr_tab(fmc).VOLUME := FND_API.G_MISS_NUM;
11406: x_rec_attr_tab(fmc).VOLUME_UOM_CODE := FND_API.G_MISS_CHAR;
11399: x_rec_attr_tab(fmc).ASN_DATE_SENT := FND_API.G_MISS_DATE;
11400: x_rec_attr_tab(fmc).ASN_STATUS_CODE := FND_API.G_MISS_CHAR;
11401: x_rec_attr_tab(fmc).ASN_SEQ_NUMBER := FND_API.G_MISS_NUM;
11402: x_rec_attr_tab(fmc).GROSS_WEIGHT := FND_API.G_MISS_NUM;
11403: x_rec_attr_tab(fmc).NET_WEIGHT := FND_API.G_MISS_NUM;
11404: x_rec_attr_tab(fmc).WEIGHT_UOM_CODE := FND_API.G_MISS_CHAR;
11405: x_rec_attr_tab(fmc).VOLUME := FND_API.G_MISS_NUM;
11406: x_rec_attr_tab(fmc).VOLUME_UOM_CODE := FND_API.G_MISS_CHAR;
11407: x_rec_attr_tab(fmc).ADDITIONAL_SHIPMENT_INFO := FND_API.G_MISS_CHAR;
11400: x_rec_attr_tab(fmc).ASN_STATUS_CODE := FND_API.G_MISS_CHAR;
11401: x_rec_attr_tab(fmc).ASN_SEQ_NUMBER := FND_API.G_MISS_NUM;
11402: x_rec_attr_tab(fmc).GROSS_WEIGHT := FND_API.G_MISS_NUM;
11403: x_rec_attr_tab(fmc).NET_WEIGHT := FND_API.G_MISS_NUM;
11404: x_rec_attr_tab(fmc).WEIGHT_UOM_CODE := FND_API.G_MISS_CHAR;
11405: x_rec_attr_tab(fmc).VOLUME := FND_API.G_MISS_NUM;
11406: x_rec_attr_tab(fmc).VOLUME_UOM_CODE := FND_API.G_MISS_CHAR;
11407: x_rec_attr_tab(fmc).ADDITIONAL_SHIPMENT_INFO := FND_API.G_MISS_CHAR;
11408: x_rec_attr_tab(fmc).CURRENCY_CODE := FND_API.G_MISS_CHAR;
11401: x_rec_attr_tab(fmc).ASN_SEQ_NUMBER := FND_API.G_MISS_NUM;
11402: x_rec_attr_tab(fmc).GROSS_WEIGHT := FND_API.G_MISS_NUM;
11403: x_rec_attr_tab(fmc).NET_WEIGHT := FND_API.G_MISS_NUM;
11404: x_rec_attr_tab(fmc).WEIGHT_UOM_CODE := FND_API.G_MISS_CHAR;
11405: x_rec_attr_tab(fmc).VOLUME := FND_API.G_MISS_NUM;
11406: x_rec_attr_tab(fmc).VOLUME_UOM_CODE := FND_API.G_MISS_CHAR;
11407: x_rec_attr_tab(fmc).ADDITIONAL_SHIPMENT_INFO := FND_API.G_MISS_CHAR;
11408: x_rec_attr_tab(fmc).CURRENCY_CODE := FND_API.G_MISS_CHAR;
11409: x_rec_attr_tab(fmc).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11402: x_rec_attr_tab(fmc).GROSS_WEIGHT := FND_API.G_MISS_NUM;
11403: x_rec_attr_tab(fmc).NET_WEIGHT := FND_API.G_MISS_NUM;
11404: x_rec_attr_tab(fmc).WEIGHT_UOM_CODE := FND_API.G_MISS_CHAR;
11405: x_rec_attr_tab(fmc).VOLUME := FND_API.G_MISS_NUM;
11406: x_rec_attr_tab(fmc).VOLUME_UOM_CODE := FND_API.G_MISS_CHAR;
11407: x_rec_attr_tab(fmc).ADDITIONAL_SHIPMENT_INFO := FND_API.G_MISS_CHAR;
11408: x_rec_attr_tab(fmc).CURRENCY_CODE := FND_API.G_MISS_CHAR;
11409: x_rec_attr_tab(fmc).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11410: x_rec_attr_tab(fmc).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11403: x_rec_attr_tab(fmc).NET_WEIGHT := FND_API.G_MISS_NUM;
11404: x_rec_attr_tab(fmc).WEIGHT_UOM_CODE := FND_API.G_MISS_CHAR;
11405: x_rec_attr_tab(fmc).VOLUME := FND_API.G_MISS_NUM;
11406: x_rec_attr_tab(fmc).VOLUME_UOM_CODE := FND_API.G_MISS_CHAR;
11407: x_rec_attr_tab(fmc).ADDITIONAL_SHIPMENT_INFO := FND_API.G_MISS_CHAR;
11408: x_rec_attr_tab(fmc).CURRENCY_CODE := FND_API.G_MISS_CHAR;
11409: x_rec_attr_tab(fmc).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11410: x_rec_attr_tab(fmc).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11411: x_rec_attr_tab(fmc).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11404: x_rec_attr_tab(fmc).WEIGHT_UOM_CODE := FND_API.G_MISS_CHAR;
11405: x_rec_attr_tab(fmc).VOLUME := FND_API.G_MISS_NUM;
11406: x_rec_attr_tab(fmc).VOLUME_UOM_CODE := FND_API.G_MISS_CHAR;
11407: x_rec_attr_tab(fmc).ADDITIONAL_SHIPMENT_INFO := FND_API.G_MISS_CHAR;
11408: x_rec_attr_tab(fmc).CURRENCY_CODE := FND_API.G_MISS_CHAR;
11409: x_rec_attr_tab(fmc).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11410: x_rec_attr_tab(fmc).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11411: x_rec_attr_tab(fmc).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11412: x_rec_attr_tab(fmc).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11405: x_rec_attr_tab(fmc).VOLUME := FND_API.G_MISS_NUM;
11406: x_rec_attr_tab(fmc).VOLUME_UOM_CODE := FND_API.G_MISS_CHAR;
11407: x_rec_attr_tab(fmc).ADDITIONAL_SHIPMENT_INFO := FND_API.G_MISS_CHAR;
11408: x_rec_attr_tab(fmc).CURRENCY_CODE := FND_API.G_MISS_CHAR;
11409: x_rec_attr_tab(fmc).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11410: x_rec_attr_tab(fmc).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11411: x_rec_attr_tab(fmc).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11412: x_rec_attr_tab(fmc).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11413: x_rec_attr_tab(fmc).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11406: x_rec_attr_tab(fmc).VOLUME_UOM_CODE := FND_API.G_MISS_CHAR;
11407: x_rec_attr_tab(fmc).ADDITIONAL_SHIPMENT_INFO := FND_API.G_MISS_CHAR;
11408: x_rec_attr_tab(fmc).CURRENCY_CODE := FND_API.G_MISS_CHAR;
11409: x_rec_attr_tab(fmc).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11410: x_rec_attr_tab(fmc).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11411: x_rec_attr_tab(fmc).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11412: x_rec_attr_tab(fmc).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11413: x_rec_attr_tab(fmc).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11414: x_rec_attr_tab(fmc).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11407: x_rec_attr_tab(fmc).ADDITIONAL_SHIPMENT_INFO := FND_API.G_MISS_CHAR;
11408: x_rec_attr_tab(fmc).CURRENCY_CODE := FND_API.G_MISS_CHAR;
11409: x_rec_attr_tab(fmc).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11410: x_rec_attr_tab(fmc).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11411: x_rec_attr_tab(fmc).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11412: x_rec_attr_tab(fmc).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11413: x_rec_attr_tab(fmc).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11414: x_rec_attr_tab(fmc).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11415: x_rec_attr_tab(fmc).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11408: x_rec_attr_tab(fmc).CURRENCY_CODE := FND_API.G_MISS_CHAR;
11409: x_rec_attr_tab(fmc).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11410: x_rec_attr_tab(fmc).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11411: x_rec_attr_tab(fmc).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11412: x_rec_attr_tab(fmc).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11413: x_rec_attr_tab(fmc).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11414: x_rec_attr_tab(fmc).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11415: x_rec_attr_tab(fmc).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11416: x_rec_attr_tab(fmc).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11409: x_rec_attr_tab(fmc).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11410: x_rec_attr_tab(fmc).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11411: x_rec_attr_tab(fmc).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11412: x_rec_attr_tab(fmc).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11413: x_rec_attr_tab(fmc).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11414: x_rec_attr_tab(fmc).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11415: x_rec_attr_tab(fmc).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11416: x_rec_attr_tab(fmc).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11417: x_rec_attr_tab(fmc).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11410: x_rec_attr_tab(fmc).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11411: x_rec_attr_tab(fmc).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11412: x_rec_attr_tab(fmc).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11413: x_rec_attr_tab(fmc).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11414: x_rec_attr_tab(fmc).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11415: x_rec_attr_tab(fmc).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11416: x_rec_attr_tab(fmc).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11417: x_rec_attr_tab(fmc).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11418: x_rec_attr_tab(fmc).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11411: x_rec_attr_tab(fmc).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11412: x_rec_attr_tab(fmc).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11413: x_rec_attr_tab(fmc).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11414: x_rec_attr_tab(fmc).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11415: x_rec_attr_tab(fmc).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11416: x_rec_attr_tab(fmc).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11417: x_rec_attr_tab(fmc).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11418: x_rec_attr_tab(fmc).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11419: x_rec_attr_tab(fmc).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11412: x_rec_attr_tab(fmc).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11413: x_rec_attr_tab(fmc).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11414: x_rec_attr_tab(fmc).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11415: x_rec_attr_tab(fmc).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11416: x_rec_attr_tab(fmc).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11417: x_rec_attr_tab(fmc).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11418: x_rec_attr_tab(fmc).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11419: x_rec_attr_tab(fmc).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11420: x_rec_attr_tab(fmc).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11413: x_rec_attr_tab(fmc).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11414: x_rec_attr_tab(fmc).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11415: x_rec_attr_tab(fmc).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11416: x_rec_attr_tab(fmc).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11417: x_rec_attr_tab(fmc).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11418: x_rec_attr_tab(fmc).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11419: x_rec_attr_tab(fmc).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11420: x_rec_attr_tab(fmc).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11421: x_rec_attr_tab(fmc).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11414: x_rec_attr_tab(fmc).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11415: x_rec_attr_tab(fmc).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11416: x_rec_attr_tab(fmc).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11417: x_rec_attr_tab(fmc).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11418: x_rec_attr_tab(fmc).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11419: x_rec_attr_tab(fmc).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11420: x_rec_attr_tab(fmc).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11421: x_rec_attr_tab(fmc).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11422: x_rec_attr_tab(fmc).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11415: x_rec_attr_tab(fmc).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11416: x_rec_attr_tab(fmc).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11417: x_rec_attr_tab(fmc).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11418: x_rec_attr_tab(fmc).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11419: x_rec_attr_tab(fmc).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11420: x_rec_attr_tab(fmc).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11421: x_rec_attr_tab(fmc).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11422: x_rec_attr_tab(fmc).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11423: x_rec_attr_tab(fmc).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11416: x_rec_attr_tab(fmc).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11417: x_rec_attr_tab(fmc).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11418: x_rec_attr_tab(fmc).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11419: x_rec_attr_tab(fmc).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11420: x_rec_attr_tab(fmc).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11421: x_rec_attr_tab(fmc).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11422: x_rec_attr_tab(fmc).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11423: x_rec_attr_tab(fmc).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11424: x_rec_attr_tab(fmc).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11417: x_rec_attr_tab(fmc).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11418: x_rec_attr_tab(fmc).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11419: x_rec_attr_tab(fmc).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11420: x_rec_attr_tab(fmc).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11421: x_rec_attr_tab(fmc).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11422: x_rec_attr_tab(fmc).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11423: x_rec_attr_tab(fmc).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11424: x_rec_attr_tab(fmc).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11425: x_rec_attr_tab(fmc).TP_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11418: x_rec_attr_tab(fmc).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11419: x_rec_attr_tab(fmc).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11420: x_rec_attr_tab(fmc).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11421: x_rec_attr_tab(fmc).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11422: x_rec_attr_tab(fmc).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11423: x_rec_attr_tab(fmc).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11424: x_rec_attr_tab(fmc).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11425: x_rec_attr_tab(fmc).TP_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11426: x_rec_attr_tab(fmc).TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11419: x_rec_attr_tab(fmc).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11420: x_rec_attr_tab(fmc).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11421: x_rec_attr_tab(fmc).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11422: x_rec_attr_tab(fmc).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11423: x_rec_attr_tab(fmc).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11424: x_rec_attr_tab(fmc).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11425: x_rec_attr_tab(fmc).TP_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11426: x_rec_attr_tab(fmc).TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11427: x_rec_attr_tab(fmc).TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11420: x_rec_attr_tab(fmc).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11421: x_rec_attr_tab(fmc).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11422: x_rec_attr_tab(fmc).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11423: x_rec_attr_tab(fmc).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11424: x_rec_attr_tab(fmc).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11425: x_rec_attr_tab(fmc).TP_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11426: x_rec_attr_tab(fmc).TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11427: x_rec_attr_tab(fmc).TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11428: x_rec_attr_tab(fmc).TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11421: x_rec_attr_tab(fmc).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11422: x_rec_attr_tab(fmc).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11423: x_rec_attr_tab(fmc).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11424: x_rec_attr_tab(fmc).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11425: x_rec_attr_tab(fmc).TP_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11426: x_rec_attr_tab(fmc).TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11427: x_rec_attr_tab(fmc).TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11428: x_rec_attr_tab(fmc).TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11429: x_rec_attr_tab(fmc).TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11422: x_rec_attr_tab(fmc).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11423: x_rec_attr_tab(fmc).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11424: x_rec_attr_tab(fmc).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11425: x_rec_attr_tab(fmc).TP_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11426: x_rec_attr_tab(fmc).TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11427: x_rec_attr_tab(fmc).TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11428: x_rec_attr_tab(fmc).TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11429: x_rec_attr_tab(fmc).TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11430: x_rec_attr_tab(fmc).TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11423: x_rec_attr_tab(fmc).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11424: x_rec_attr_tab(fmc).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11425: x_rec_attr_tab(fmc).TP_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11426: x_rec_attr_tab(fmc).TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11427: x_rec_attr_tab(fmc).TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11428: x_rec_attr_tab(fmc).TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11429: x_rec_attr_tab(fmc).TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11430: x_rec_attr_tab(fmc).TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11431: x_rec_attr_tab(fmc).TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11424: x_rec_attr_tab(fmc).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11425: x_rec_attr_tab(fmc).TP_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11426: x_rec_attr_tab(fmc).TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11427: x_rec_attr_tab(fmc).TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11428: x_rec_attr_tab(fmc).TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11429: x_rec_attr_tab(fmc).TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11430: x_rec_attr_tab(fmc).TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11431: x_rec_attr_tab(fmc).TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11432: x_rec_attr_tab(fmc).TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11425: x_rec_attr_tab(fmc).TP_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11426: x_rec_attr_tab(fmc).TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11427: x_rec_attr_tab(fmc).TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11428: x_rec_attr_tab(fmc).TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11429: x_rec_attr_tab(fmc).TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11430: x_rec_attr_tab(fmc).TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11431: x_rec_attr_tab(fmc).TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11432: x_rec_attr_tab(fmc).TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11433: x_rec_attr_tab(fmc).TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11426: x_rec_attr_tab(fmc).TP_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11427: x_rec_attr_tab(fmc).TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11428: x_rec_attr_tab(fmc).TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11429: x_rec_attr_tab(fmc).TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11430: x_rec_attr_tab(fmc).TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11431: x_rec_attr_tab(fmc).TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11432: x_rec_attr_tab(fmc).TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11433: x_rec_attr_tab(fmc).TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11434: x_rec_attr_tab(fmc).TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11427: x_rec_attr_tab(fmc).TP_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11428: x_rec_attr_tab(fmc).TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11429: x_rec_attr_tab(fmc).TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11430: x_rec_attr_tab(fmc).TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11431: x_rec_attr_tab(fmc).TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11432: x_rec_attr_tab(fmc).TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11433: x_rec_attr_tab(fmc).TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11434: x_rec_attr_tab(fmc).TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11435: x_rec_attr_tab(fmc).TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11428: x_rec_attr_tab(fmc).TP_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11429: x_rec_attr_tab(fmc).TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11430: x_rec_attr_tab(fmc).TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11431: x_rec_attr_tab(fmc).TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11432: x_rec_attr_tab(fmc).TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11433: x_rec_attr_tab(fmc).TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11434: x_rec_attr_tab(fmc).TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11435: x_rec_attr_tab(fmc).TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11436: x_rec_attr_tab(fmc).TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11429: x_rec_attr_tab(fmc).TP_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11430: x_rec_attr_tab(fmc).TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11431: x_rec_attr_tab(fmc).TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11432: x_rec_attr_tab(fmc).TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11433: x_rec_attr_tab(fmc).TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11434: x_rec_attr_tab(fmc).TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11435: x_rec_attr_tab(fmc).TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11436: x_rec_attr_tab(fmc).TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11437: x_rec_attr_tab(fmc).TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11430: x_rec_attr_tab(fmc).TP_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11431: x_rec_attr_tab(fmc).TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11432: x_rec_attr_tab(fmc).TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11433: x_rec_attr_tab(fmc).TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11434: x_rec_attr_tab(fmc).TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11435: x_rec_attr_tab(fmc).TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11436: x_rec_attr_tab(fmc).TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11437: x_rec_attr_tab(fmc).TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11438: x_rec_attr_tab(fmc).TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11431: x_rec_attr_tab(fmc).TP_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11432: x_rec_attr_tab(fmc).TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11433: x_rec_attr_tab(fmc).TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11434: x_rec_attr_tab(fmc).TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11435: x_rec_attr_tab(fmc).TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11436: x_rec_attr_tab(fmc).TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11437: x_rec_attr_tab(fmc).TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11438: x_rec_attr_tab(fmc).TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11439: x_rec_attr_tab(fmc).TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11432: x_rec_attr_tab(fmc).TP_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11433: x_rec_attr_tab(fmc).TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11434: x_rec_attr_tab(fmc).TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11435: x_rec_attr_tab(fmc).TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11436: x_rec_attr_tab(fmc).TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11437: x_rec_attr_tab(fmc).TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11438: x_rec_attr_tab(fmc).TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11439: x_rec_attr_tab(fmc).TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11440: x_rec_attr_tab(fmc).TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11433: x_rec_attr_tab(fmc).TP_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11434: x_rec_attr_tab(fmc).TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11435: x_rec_attr_tab(fmc).TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11436: x_rec_attr_tab(fmc).TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11437: x_rec_attr_tab(fmc).TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11438: x_rec_attr_tab(fmc).TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11439: x_rec_attr_tab(fmc).TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11440: x_rec_attr_tab(fmc).TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11441: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11434: x_rec_attr_tab(fmc).TP_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11435: x_rec_attr_tab(fmc).TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11436: x_rec_attr_tab(fmc).TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11437: x_rec_attr_tab(fmc).TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11438: x_rec_attr_tab(fmc).TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11439: x_rec_attr_tab(fmc).TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11440: x_rec_attr_tab(fmc).TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11441: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11442: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11435: x_rec_attr_tab(fmc).TP_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11436: x_rec_attr_tab(fmc).TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11437: x_rec_attr_tab(fmc).TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11438: x_rec_attr_tab(fmc).TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11439: x_rec_attr_tab(fmc).TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11440: x_rec_attr_tab(fmc).TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11441: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11442: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11443: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11436: x_rec_attr_tab(fmc).TP_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11437: x_rec_attr_tab(fmc).TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11438: x_rec_attr_tab(fmc).TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11439: x_rec_attr_tab(fmc).TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11440: x_rec_attr_tab(fmc).TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11441: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11442: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11443: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11444: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11437: x_rec_attr_tab(fmc).TP_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11438: x_rec_attr_tab(fmc).TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11439: x_rec_attr_tab(fmc).TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11440: x_rec_attr_tab(fmc).TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11441: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11442: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11443: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11444: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11445: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11438: x_rec_attr_tab(fmc).TP_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11439: x_rec_attr_tab(fmc).TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11440: x_rec_attr_tab(fmc).TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11441: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11442: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11443: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11444: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11445: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11446: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11439: x_rec_attr_tab(fmc).TP_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11440: x_rec_attr_tab(fmc).TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11441: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11442: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11443: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11444: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11445: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11446: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11447: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11440: x_rec_attr_tab(fmc).TP_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11441: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11442: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11443: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11444: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11445: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11446: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11447: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11448: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11441: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11442: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11443: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11444: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11445: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11446: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11447: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11448: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11449: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11442: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11443: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11444: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11445: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11446: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11447: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11448: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11449: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11450: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11443: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11444: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11445: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11446: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11447: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11448: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11449: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11450: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11451: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11444: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11445: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11446: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11447: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11448: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11449: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11450: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11451: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11452: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11445: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11446: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11447: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11448: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11449: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11450: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11451: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11452: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11453: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11446: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11447: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11448: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11449: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11450: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11451: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11452: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11453: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11454: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11447: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11448: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11449: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11450: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11451: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11452: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11453: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11454: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11455: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11448: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11449: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11450: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11451: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11452: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11453: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11454: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11455: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11456: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11449: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11450: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11451: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11452: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11453: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11454: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11455: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11456: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11457: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
11450: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11451: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11452: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11453: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11454: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11455: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11456: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11457: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
11458: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
11451: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11452: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11453: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11454: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11455: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11456: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11457: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
11458: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
11459: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
11452: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11453: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11454: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11455: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11456: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11457: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
11458: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
11459: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
11460: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
11453: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11454: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11455: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11456: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11457: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
11458: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
11459: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
11460: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
11461: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
11454: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11455: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11456: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11457: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
11458: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
11459: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
11460: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
11461: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
11462: x_rec_attr_tab(fmc).CREATION_DATE := FND_API.G_MISS_DATE;
11455: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11456: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11457: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
11458: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
11459: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
11460: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
11461: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
11462: x_rec_attr_tab(fmc).CREATION_DATE := FND_API.G_MISS_DATE;
11463: x_rec_attr_tab(fmc).CREATED_BY := FND_API.G_MISS_NUM;
11456: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11457: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
11458: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
11459: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
11460: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
11461: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
11462: x_rec_attr_tab(fmc).CREATION_DATE := FND_API.G_MISS_DATE;
11463: x_rec_attr_tab(fmc).CREATED_BY := FND_API.G_MISS_NUM;
11464: x_rec_attr_tab(fmc).LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
11457: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
11458: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
11459: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
11460: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
11461: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
11462: x_rec_attr_tab(fmc).CREATION_DATE := FND_API.G_MISS_DATE;
11463: x_rec_attr_tab(fmc).CREATED_BY := FND_API.G_MISS_NUM;
11464: x_rec_attr_tab(fmc).LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
11465: x_rec_attr_tab(fmc).LAST_UPDATED_BY := FND_API.G_MISS_NUM;
11458: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
11459: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
11460: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
11461: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
11462: x_rec_attr_tab(fmc).CREATION_DATE := FND_API.G_MISS_DATE;
11463: x_rec_attr_tab(fmc).CREATED_BY := FND_API.G_MISS_NUM;
11464: x_rec_attr_tab(fmc).LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
11465: x_rec_attr_tab(fmc).LAST_UPDATED_BY := FND_API.G_MISS_NUM;
11466: x_rec_attr_tab(fmc).LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
11459: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
11460: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
11461: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
11462: x_rec_attr_tab(fmc).CREATION_DATE := FND_API.G_MISS_DATE;
11463: x_rec_attr_tab(fmc).CREATED_BY := FND_API.G_MISS_NUM;
11464: x_rec_attr_tab(fmc).LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
11465: x_rec_attr_tab(fmc).LAST_UPDATED_BY := FND_API.G_MISS_NUM;
11466: x_rec_attr_tab(fmc).LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
11467: x_rec_attr_tab(fmc).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11460: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
11461: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
11462: x_rec_attr_tab(fmc).CREATION_DATE := FND_API.G_MISS_DATE;
11463: x_rec_attr_tab(fmc).CREATED_BY := FND_API.G_MISS_NUM;
11464: x_rec_attr_tab(fmc).LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
11465: x_rec_attr_tab(fmc).LAST_UPDATED_BY := FND_API.G_MISS_NUM;
11466: x_rec_attr_tab(fmc).LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
11467: x_rec_attr_tab(fmc).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11468: x_rec_attr_tab(fmc).PROGRAM_ID := FND_API.G_MISS_NUM;
11461: x_rec_attr_tab(fmc).GLOBAL_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
11462: x_rec_attr_tab(fmc).CREATION_DATE := FND_API.G_MISS_DATE;
11463: x_rec_attr_tab(fmc).CREATED_BY := FND_API.G_MISS_NUM;
11464: x_rec_attr_tab(fmc).LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
11465: x_rec_attr_tab(fmc).LAST_UPDATED_BY := FND_API.G_MISS_NUM;
11466: x_rec_attr_tab(fmc).LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
11467: x_rec_attr_tab(fmc).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11468: x_rec_attr_tab(fmc).PROGRAM_ID := FND_API.G_MISS_NUM;
11469: x_rec_attr_tab(fmc).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11462: x_rec_attr_tab(fmc).CREATION_DATE := FND_API.G_MISS_DATE;
11463: x_rec_attr_tab(fmc).CREATED_BY := FND_API.G_MISS_NUM;
11464: x_rec_attr_tab(fmc).LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
11465: x_rec_attr_tab(fmc).LAST_UPDATED_BY := FND_API.G_MISS_NUM;
11466: x_rec_attr_tab(fmc).LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
11467: x_rec_attr_tab(fmc).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11468: x_rec_attr_tab(fmc).PROGRAM_ID := FND_API.G_MISS_NUM;
11469: x_rec_attr_tab(fmc).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11470: x_rec_attr_tab(fmc).REQUEST_ID := FND_API.G_MISS_NUM;
11463: x_rec_attr_tab(fmc).CREATED_BY := FND_API.G_MISS_NUM;
11464: x_rec_attr_tab(fmc).LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
11465: x_rec_attr_tab(fmc).LAST_UPDATED_BY := FND_API.G_MISS_NUM;
11466: x_rec_attr_tab(fmc).LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
11467: x_rec_attr_tab(fmc).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11468: x_rec_attr_tab(fmc).PROGRAM_ID := FND_API.G_MISS_NUM;
11469: x_rec_attr_tab(fmc).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11470: x_rec_attr_tab(fmc).REQUEST_ID := FND_API.G_MISS_NUM;
11471: x_rec_attr_tab(fmc).BATCH_ID := FND_API.G_MISS_NUM;
11464: x_rec_attr_tab(fmc).LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
11465: x_rec_attr_tab(fmc).LAST_UPDATED_BY := FND_API.G_MISS_NUM;
11466: x_rec_attr_tab(fmc).LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
11467: x_rec_attr_tab(fmc).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11468: x_rec_attr_tab(fmc).PROGRAM_ID := FND_API.G_MISS_NUM;
11469: x_rec_attr_tab(fmc).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11470: x_rec_attr_tab(fmc).REQUEST_ID := FND_API.G_MISS_NUM;
11471: x_rec_attr_tab(fmc).BATCH_ID := FND_API.G_MISS_NUM;
11472: x_rec_attr_tab(fmc).HASH_VALUE := FND_API.G_MISS_NUM;
11465: x_rec_attr_tab(fmc).LAST_UPDATED_BY := FND_API.G_MISS_NUM;
11466: x_rec_attr_tab(fmc).LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
11467: x_rec_attr_tab(fmc).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11468: x_rec_attr_tab(fmc).PROGRAM_ID := FND_API.G_MISS_NUM;
11469: x_rec_attr_tab(fmc).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11470: x_rec_attr_tab(fmc).REQUEST_ID := FND_API.G_MISS_NUM;
11471: x_rec_attr_tab(fmc).BATCH_ID := FND_API.G_MISS_NUM;
11472: x_rec_attr_tab(fmc).HASH_VALUE := FND_API.G_MISS_NUM;
11473: x_rec_attr_tab(fmc).SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
11466: x_rec_attr_tab(fmc).LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
11467: x_rec_attr_tab(fmc).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11468: x_rec_attr_tab(fmc).PROGRAM_ID := FND_API.G_MISS_NUM;
11469: x_rec_attr_tab(fmc).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11470: x_rec_attr_tab(fmc).REQUEST_ID := FND_API.G_MISS_NUM;
11471: x_rec_attr_tab(fmc).BATCH_ID := FND_API.G_MISS_NUM;
11472: x_rec_attr_tab(fmc).HASH_VALUE := FND_API.G_MISS_NUM;
11473: x_rec_attr_tab(fmc).SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
11474: x_rec_attr_tab(fmc).NUMBER_OF_LPN := FND_API.G_MISS_NUM;
11467: x_rec_attr_tab(fmc).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11468: x_rec_attr_tab(fmc).PROGRAM_ID := FND_API.G_MISS_NUM;
11469: x_rec_attr_tab(fmc).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11470: x_rec_attr_tab(fmc).REQUEST_ID := FND_API.G_MISS_NUM;
11471: x_rec_attr_tab(fmc).BATCH_ID := FND_API.G_MISS_NUM;
11472: x_rec_attr_tab(fmc).HASH_VALUE := FND_API.G_MISS_NUM;
11473: x_rec_attr_tab(fmc).SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
11474: x_rec_attr_tab(fmc).NUMBER_OF_LPN := FND_API.G_MISS_NUM;
11475: x_rec_attr_tab(fmc).COD_AMOUNT := FND_API.G_MISS_NUM;
11468: x_rec_attr_tab(fmc).PROGRAM_ID := FND_API.G_MISS_NUM;
11469: x_rec_attr_tab(fmc).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11470: x_rec_attr_tab(fmc).REQUEST_ID := FND_API.G_MISS_NUM;
11471: x_rec_attr_tab(fmc).BATCH_ID := FND_API.G_MISS_NUM;
11472: x_rec_attr_tab(fmc).HASH_VALUE := FND_API.G_MISS_NUM;
11473: x_rec_attr_tab(fmc).SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
11474: x_rec_attr_tab(fmc).NUMBER_OF_LPN := FND_API.G_MISS_NUM;
11475: x_rec_attr_tab(fmc).COD_AMOUNT := FND_API.G_MISS_NUM;
11476: x_rec_attr_tab(fmc).COD_CURRENCY_CODE := FND_API.G_MISS_CHAR;
11469: x_rec_attr_tab(fmc).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11470: x_rec_attr_tab(fmc).REQUEST_ID := FND_API.G_MISS_NUM;
11471: x_rec_attr_tab(fmc).BATCH_ID := FND_API.G_MISS_NUM;
11472: x_rec_attr_tab(fmc).HASH_VALUE := FND_API.G_MISS_NUM;
11473: x_rec_attr_tab(fmc).SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
11474: x_rec_attr_tab(fmc).NUMBER_OF_LPN := FND_API.G_MISS_NUM;
11475: x_rec_attr_tab(fmc).COD_AMOUNT := FND_API.G_MISS_NUM;
11476: x_rec_attr_tab(fmc).COD_CURRENCY_CODE := FND_API.G_MISS_CHAR;
11477: x_rec_attr_tab(fmc).COD_REMIT_TO := FND_API.G_MISS_CHAR;
11470: x_rec_attr_tab(fmc).REQUEST_ID := FND_API.G_MISS_NUM;
11471: x_rec_attr_tab(fmc).BATCH_ID := FND_API.G_MISS_NUM;
11472: x_rec_attr_tab(fmc).HASH_VALUE := FND_API.G_MISS_NUM;
11473: x_rec_attr_tab(fmc).SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
11474: x_rec_attr_tab(fmc).NUMBER_OF_LPN := FND_API.G_MISS_NUM;
11475: x_rec_attr_tab(fmc).COD_AMOUNT := FND_API.G_MISS_NUM;
11476: x_rec_attr_tab(fmc).COD_CURRENCY_CODE := FND_API.G_MISS_CHAR;
11477: x_rec_attr_tab(fmc).COD_REMIT_TO := FND_API.G_MISS_CHAR;
11478: x_rec_attr_tab(fmc).COD_CHARGE_PAID_BY := FND_API.G_MISS_CHAR;
11471: x_rec_attr_tab(fmc).BATCH_ID := FND_API.G_MISS_NUM;
11472: x_rec_attr_tab(fmc).HASH_VALUE := FND_API.G_MISS_NUM;
11473: x_rec_attr_tab(fmc).SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
11474: x_rec_attr_tab(fmc).NUMBER_OF_LPN := FND_API.G_MISS_NUM;
11475: x_rec_attr_tab(fmc).COD_AMOUNT := FND_API.G_MISS_NUM;
11476: x_rec_attr_tab(fmc).COD_CURRENCY_CODE := FND_API.G_MISS_CHAR;
11477: x_rec_attr_tab(fmc).COD_REMIT_TO := FND_API.G_MISS_CHAR;
11478: x_rec_attr_tab(fmc).COD_CHARGE_PAID_BY := FND_API.G_MISS_CHAR;
11479: x_rec_attr_tab(fmc).PROBLEM_CONTACT_REFERENCE := FND_API.G_MISS_CHAR;
11472: x_rec_attr_tab(fmc).HASH_VALUE := FND_API.G_MISS_NUM;
11473: x_rec_attr_tab(fmc).SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
11474: x_rec_attr_tab(fmc).NUMBER_OF_LPN := FND_API.G_MISS_NUM;
11475: x_rec_attr_tab(fmc).COD_AMOUNT := FND_API.G_MISS_NUM;
11476: x_rec_attr_tab(fmc).COD_CURRENCY_CODE := FND_API.G_MISS_CHAR;
11477: x_rec_attr_tab(fmc).COD_REMIT_TO := FND_API.G_MISS_CHAR;
11478: x_rec_attr_tab(fmc).COD_CHARGE_PAID_BY := FND_API.G_MISS_CHAR;
11479: x_rec_attr_tab(fmc).PROBLEM_CONTACT_REFERENCE := FND_API.G_MISS_CHAR;
11480: x_rec_attr_tab(fmc).PORT_OF_LOADING := FND_API.G_MISS_CHAR;
11473: x_rec_attr_tab(fmc).SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
11474: x_rec_attr_tab(fmc).NUMBER_OF_LPN := FND_API.G_MISS_NUM;
11475: x_rec_attr_tab(fmc).COD_AMOUNT := FND_API.G_MISS_NUM;
11476: x_rec_attr_tab(fmc).COD_CURRENCY_CODE := FND_API.G_MISS_CHAR;
11477: x_rec_attr_tab(fmc).COD_REMIT_TO := FND_API.G_MISS_CHAR;
11478: x_rec_attr_tab(fmc).COD_CHARGE_PAID_BY := FND_API.G_MISS_CHAR;
11479: x_rec_attr_tab(fmc).PROBLEM_CONTACT_REFERENCE := FND_API.G_MISS_CHAR;
11480: x_rec_attr_tab(fmc).PORT_OF_LOADING := FND_API.G_MISS_CHAR;
11481: x_rec_attr_tab(fmc).PORT_OF_DISCHARGE := FND_API.G_MISS_CHAR;
11474: x_rec_attr_tab(fmc).NUMBER_OF_LPN := FND_API.G_MISS_NUM;
11475: x_rec_attr_tab(fmc).COD_AMOUNT := FND_API.G_MISS_NUM;
11476: x_rec_attr_tab(fmc).COD_CURRENCY_CODE := FND_API.G_MISS_CHAR;
11477: x_rec_attr_tab(fmc).COD_REMIT_TO := FND_API.G_MISS_CHAR;
11478: x_rec_attr_tab(fmc).COD_CHARGE_PAID_BY := FND_API.G_MISS_CHAR;
11479: x_rec_attr_tab(fmc).PROBLEM_CONTACT_REFERENCE := FND_API.G_MISS_CHAR;
11480: x_rec_attr_tab(fmc).PORT_OF_LOADING := FND_API.G_MISS_CHAR;
11481: x_rec_attr_tab(fmc).PORT_OF_DISCHARGE := FND_API.G_MISS_CHAR;
11482: x_rec_attr_tab(fmc).FTZ_NUMBER := FND_API.G_MISS_CHAR;
11475: x_rec_attr_tab(fmc).COD_AMOUNT := FND_API.G_MISS_NUM;
11476: x_rec_attr_tab(fmc).COD_CURRENCY_CODE := FND_API.G_MISS_CHAR;
11477: x_rec_attr_tab(fmc).COD_REMIT_TO := FND_API.G_MISS_CHAR;
11478: x_rec_attr_tab(fmc).COD_CHARGE_PAID_BY := FND_API.G_MISS_CHAR;
11479: x_rec_attr_tab(fmc).PROBLEM_CONTACT_REFERENCE := FND_API.G_MISS_CHAR;
11480: x_rec_attr_tab(fmc).PORT_OF_LOADING := FND_API.G_MISS_CHAR;
11481: x_rec_attr_tab(fmc).PORT_OF_DISCHARGE := FND_API.G_MISS_CHAR;
11482: x_rec_attr_tab(fmc).FTZ_NUMBER := FND_API.G_MISS_CHAR;
11483: x_rec_attr_tab(fmc).ROUTED_EXPORT_TXN := FND_API.G_MISS_CHAR;
11476: x_rec_attr_tab(fmc).COD_CURRENCY_CODE := FND_API.G_MISS_CHAR;
11477: x_rec_attr_tab(fmc).COD_REMIT_TO := FND_API.G_MISS_CHAR;
11478: x_rec_attr_tab(fmc).COD_CHARGE_PAID_BY := FND_API.G_MISS_CHAR;
11479: x_rec_attr_tab(fmc).PROBLEM_CONTACT_REFERENCE := FND_API.G_MISS_CHAR;
11480: x_rec_attr_tab(fmc).PORT_OF_LOADING := FND_API.G_MISS_CHAR;
11481: x_rec_attr_tab(fmc).PORT_OF_DISCHARGE := FND_API.G_MISS_CHAR;
11482: x_rec_attr_tab(fmc).FTZ_NUMBER := FND_API.G_MISS_CHAR;
11483: x_rec_attr_tab(fmc).ROUTED_EXPORT_TXN := FND_API.G_MISS_CHAR;
11484: x_rec_attr_tab(fmc).ENTRY_NUMBER := FND_API.G_MISS_CHAR;
11477: x_rec_attr_tab(fmc).COD_REMIT_TO := FND_API.G_MISS_CHAR;
11478: x_rec_attr_tab(fmc).COD_CHARGE_PAID_BY := FND_API.G_MISS_CHAR;
11479: x_rec_attr_tab(fmc).PROBLEM_CONTACT_REFERENCE := FND_API.G_MISS_CHAR;
11480: x_rec_attr_tab(fmc).PORT_OF_LOADING := FND_API.G_MISS_CHAR;
11481: x_rec_attr_tab(fmc).PORT_OF_DISCHARGE := FND_API.G_MISS_CHAR;
11482: x_rec_attr_tab(fmc).FTZ_NUMBER := FND_API.G_MISS_CHAR;
11483: x_rec_attr_tab(fmc).ROUTED_EXPORT_TXN := FND_API.G_MISS_CHAR;
11484: x_rec_attr_tab(fmc).ENTRY_NUMBER := FND_API.G_MISS_CHAR;
11485: x_rec_attr_tab(fmc).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11478: x_rec_attr_tab(fmc).COD_CHARGE_PAID_BY := FND_API.G_MISS_CHAR;
11479: x_rec_attr_tab(fmc).PROBLEM_CONTACT_REFERENCE := FND_API.G_MISS_CHAR;
11480: x_rec_attr_tab(fmc).PORT_OF_LOADING := FND_API.G_MISS_CHAR;
11481: x_rec_attr_tab(fmc).PORT_OF_DISCHARGE := FND_API.G_MISS_CHAR;
11482: x_rec_attr_tab(fmc).FTZ_NUMBER := FND_API.G_MISS_CHAR;
11483: x_rec_attr_tab(fmc).ROUTED_EXPORT_TXN := FND_API.G_MISS_CHAR;
11484: x_rec_attr_tab(fmc).ENTRY_NUMBER := FND_API.G_MISS_CHAR;
11485: x_rec_attr_tab(fmc).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11486: x_rec_attr_tab(fmc).IN_BOND_CODE := FND_API.G_MISS_CHAR;
11479: x_rec_attr_tab(fmc).PROBLEM_CONTACT_REFERENCE := FND_API.G_MISS_CHAR;
11480: x_rec_attr_tab(fmc).PORT_OF_LOADING := FND_API.G_MISS_CHAR;
11481: x_rec_attr_tab(fmc).PORT_OF_DISCHARGE := FND_API.G_MISS_CHAR;
11482: x_rec_attr_tab(fmc).FTZ_NUMBER := FND_API.G_MISS_CHAR;
11483: x_rec_attr_tab(fmc).ROUTED_EXPORT_TXN := FND_API.G_MISS_CHAR;
11484: x_rec_attr_tab(fmc).ENTRY_NUMBER := FND_API.G_MISS_CHAR;
11485: x_rec_attr_tab(fmc).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11486: x_rec_attr_tab(fmc).IN_BOND_CODE := FND_API.G_MISS_CHAR;
11487: x_rec_attr_tab(fmc).SHIPPING_MARKS := FND_API.G_MISS_CHAR;
11480: x_rec_attr_tab(fmc).PORT_OF_LOADING := FND_API.G_MISS_CHAR;
11481: x_rec_attr_tab(fmc).PORT_OF_DISCHARGE := FND_API.G_MISS_CHAR;
11482: x_rec_attr_tab(fmc).FTZ_NUMBER := FND_API.G_MISS_CHAR;
11483: x_rec_attr_tab(fmc).ROUTED_EXPORT_TXN := FND_API.G_MISS_CHAR;
11484: x_rec_attr_tab(fmc).ENTRY_NUMBER := FND_API.G_MISS_CHAR;
11485: x_rec_attr_tab(fmc).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11486: x_rec_attr_tab(fmc).IN_BOND_CODE := FND_API.G_MISS_CHAR;
11487: x_rec_attr_tab(fmc).SHIPPING_MARKS := FND_API.G_MISS_CHAR;
11488:
11481: x_rec_attr_tab(fmc).PORT_OF_DISCHARGE := FND_API.G_MISS_CHAR;
11482: x_rec_attr_tab(fmc).FTZ_NUMBER := FND_API.G_MISS_CHAR;
11483: x_rec_attr_tab(fmc).ROUTED_EXPORT_TXN := FND_API.G_MISS_CHAR;
11484: x_rec_attr_tab(fmc).ENTRY_NUMBER := FND_API.G_MISS_CHAR;
11485: x_rec_attr_tab(fmc).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11486: x_rec_attr_tab(fmc).IN_BOND_CODE := FND_API.G_MISS_CHAR;
11487: x_rec_attr_tab(fmc).SHIPPING_MARKS := FND_API.G_MISS_CHAR;
11488:
11489: /*IF (p_cs_result_tab(fm).service_level is null) THEN
11482: x_rec_attr_tab(fmc).FTZ_NUMBER := FND_API.G_MISS_CHAR;
11483: x_rec_attr_tab(fmc).ROUTED_EXPORT_TXN := FND_API.G_MISS_CHAR;
11484: x_rec_attr_tab(fmc).ENTRY_NUMBER := FND_API.G_MISS_CHAR;
11485: x_rec_attr_tab(fmc).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11486: x_rec_attr_tab(fmc).IN_BOND_CODE := FND_API.G_MISS_CHAR;
11487: x_rec_attr_tab(fmc).SHIPPING_MARKS := FND_API.G_MISS_CHAR;
11488:
11489: /*IF (p_cs_result_tab(fm).service_level is null) THEN
11490: x_rec_attr_tab(fmc).SERVICE_LEVEL := FND_API.G_MISS_CHAR;
11483: x_rec_attr_tab(fmc).ROUTED_EXPORT_TXN := FND_API.G_MISS_CHAR;
11484: x_rec_attr_tab(fmc).ENTRY_NUMBER := FND_API.G_MISS_CHAR;
11485: x_rec_attr_tab(fmc).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11486: x_rec_attr_tab(fmc).IN_BOND_CODE := FND_API.G_MISS_CHAR;
11487: x_rec_attr_tab(fmc).SHIPPING_MARKS := FND_API.G_MISS_CHAR;
11488:
11489: /*IF (p_cs_result_tab(fm).service_level is null) THEN
11490: x_rec_attr_tab(fmc).SERVICE_LEVEL := FND_API.G_MISS_CHAR;
11491: ELSE*/
11486: x_rec_attr_tab(fmc).IN_BOND_CODE := FND_API.G_MISS_CHAR;
11487: x_rec_attr_tab(fmc).SHIPPING_MARKS := FND_API.G_MISS_CHAR;
11488:
11489: /*IF (p_cs_result_tab(fm).service_level is null) THEN
11490: x_rec_attr_tab(fmc).SERVICE_LEVEL := FND_API.G_MISS_CHAR;
11491: ELSE*/
11492: x_rec_attr_tab(fmc).SERVICE_LEVEL := p_cs_result_tab(fm).service_level;
11493: --END IF;
11494:
11492: x_rec_attr_tab(fmc).SERVICE_LEVEL := p_cs_result_tab(fm).service_level;
11493: --END IF;
11494:
11495: /*IF (p_cs_result_tab(fm).mode_of_transport is null) THEN
11496: x_rec_attr_tab(fmc).MODE_OF_TRANSPORT := FND_API.G_MISS_CHAR;
11497: ELSE*/
11498: x_rec_attr_tab(fmc).MODE_OF_TRANSPORT := p_cs_result_tab(fm).mode_of_transport;
11499: --END IF;
11500:
11497: ELSE*/
11498: x_rec_attr_tab(fmc).MODE_OF_TRANSPORT := p_cs_result_tab(fm).mode_of_transport;
11499: --END IF;
11500:
11501: x_rec_attr_tab(fmc).ASSIGNED_TO_FTE_TRIPS := FND_API.G_MISS_CHAR;
11502: x_rec_attr_tab(fmc).AUTO_SC_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11503: x_rec_attr_tab(fmc).AUTO_AP_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11504: x_rec_attr_tab(fmc).AP_BATCH_ID := FND_API.G_MISS_NUM;
11505:
11498: x_rec_attr_tab(fmc).MODE_OF_TRANSPORT := p_cs_result_tab(fm).mode_of_transport;
11499: --END IF;
11500:
11501: x_rec_attr_tab(fmc).ASSIGNED_TO_FTE_TRIPS := FND_API.G_MISS_CHAR;
11502: x_rec_attr_tab(fmc).AUTO_SC_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11503: x_rec_attr_tab(fmc).AUTO_AP_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11504: x_rec_attr_tab(fmc).AP_BATCH_ID := FND_API.G_MISS_NUM;
11505:
11506: -- x_rec_attr_tab(fmc).ROWID := FND_API.G_MISS_CHAR;
11499: --END IF;
11500:
11501: x_rec_attr_tab(fmc).ASSIGNED_TO_FTE_TRIPS := FND_API.G_MISS_CHAR;
11502: x_rec_attr_tab(fmc).AUTO_SC_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11503: x_rec_attr_tab(fmc).AUTO_AP_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11504: x_rec_attr_tab(fmc).AP_BATCH_ID := FND_API.G_MISS_NUM;
11505:
11506: -- x_rec_attr_tab(fmc).ROWID := FND_API.G_MISS_CHAR;
11507: x_rec_attr_tab(fmc).LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
11500:
11501: x_rec_attr_tab(fmc).ASSIGNED_TO_FTE_TRIPS := FND_API.G_MISS_CHAR;
11502: x_rec_attr_tab(fmc).AUTO_SC_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11503: x_rec_attr_tab(fmc).AUTO_AP_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11504: x_rec_attr_tab(fmc).AP_BATCH_ID := FND_API.G_MISS_NUM;
11505:
11506: -- x_rec_attr_tab(fmc).ROWID := FND_API.G_MISS_CHAR;
11507: x_rec_attr_tab(fmc).LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
11508: x_rec_attr_tab(fmc).ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11502: x_rec_attr_tab(fmc).AUTO_SC_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11503: x_rec_attr_tab(fmc).AUTO_AP_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11504: x_rec_attr_tab(fmc).AP_BATCH_ID := FND_API.G_MISS_NUM;
11505:
11506: -- x_rec_attr_tab(fmc).ROWID := FND_API.G_MISS_CHAR;
11507: x_rec_attr_tab(fmc).LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
11508: x_rec_attr_tab(fmc).ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11509: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_CODE:= FND_API.G_MISS_CHAR;
11510: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
11503: x_rec_attr_tab(fmc).AUTO_AP_EXCLUDE_FLAG := FND_API.G_MISS_CHAR;
11504: x_rec_attr_tab(fmc).AP_BATCH_ID := FND_API.G_MISS_NUM;
11505:
11506: -- x_rec_attr_tab(fmc).ROWID := FND_API.G_MISS_CHAR;
11507: x_rec_attr_tab(fmc).LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
11508: x_rec_attr_tab(fmc).ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11509: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_CODE:= FND_API.G_MISS_CHAR;
11510: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
11511: x_rec_attr_tab(fmc).CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
11504: x_rec_attr_tab(fmc).AP_BATCH_ID := FND_API.G_MISS_NUM;
11505:
11506: -- x_rec_attr_tab(fmc).ROWID := FND_API.G_MISS_CHAR;
11507: x_rec_attr_tab(fmc).LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
11508: x_rec_attr_tab(fmc).ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11509: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_CODE:= FND_API.G_MISS_CHAR;
11510: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
11511: x_rec_attr_tab(fmc).CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
11512: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11505:
11506: -- x_rec_attr_tab(fmc).ROWID := FND_API.G_MISS_CHAR;
11507: x_rec_attr_tab(fmc).LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
11508: x_rec_attr_tab(fmc).ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11509: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_CODE:= FND_API.G_MISS_CHAR;
11510: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
11511: x_rec_attr_tab(fmc).CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
11512: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11513: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11506: -- x_rec_attr_tab(fmc).ROWID := FND_API.G_MISS_CHAR;
11507: x_rec_attr_tab(fmc).LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
11508: x_rec_attr_tab(fmc).ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11509: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_CODE:= FND_API.G_MISS_CHAR;
11510: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
11511: x_rec_attr_tab(fmc).CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
11512: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11513: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11514: x_rec_attr_tab(fmc).CARRIER_CODE := FND_API.G_MISS_CHAR;
11507: x_rec_attr_tab(fmc).LOADING_ORDER_DESC := FND_API.G_MISS_CHAR;
11508: x_rec_attr_tab(fmc).ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11509: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_CODE:= FND_API.G_MISS_CHAR;
11510: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
11511: x_rec_attr_tab(fmc).CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
11512: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11513: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11514: x_rec_attr_tab(fmc).CARRIER_CODE := FND_API.G_MISS_CHAR;
11515: x_rec_attr_tab(fmc).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11508: x_rec_attr_tab(fmc).ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11509: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_CODE:= FND_API.G_MISS_CHAR;
11510: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
11511: x_rec_attr_tab(fmc).CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
11512: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11513: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11514: x_rec_attr_tab(fmc).CARRIER_CODE := FND_API.G_MISS_CHAR;
11515: x_rec_attr_tab(fmc).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11516: x_rec_attr_tab(fmc).FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
11509: x_rec_attr_tab(fmc).ULTIMATE_DROPOFF_LOCATION_CODE:= FND_API.G_MISS_CHAR;
11510: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
11511: x_rec_attr_tab(fmc).CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
11512: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11513: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11514: x_rec_attr_tab(fmc).CARRIER_CODE := FND_API.G_MISS_CHAR;
11515: x_rec_attr_tab(fmc).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11516: x_rec_attr_tab(fmc).FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
11517: x_rec_attr_tab(fmc).FOB_NAME := FND_API.G_MISS_CHAR;
11510: x_rec_attr_tab(fmc).INITIAL_PICKUP_LOCATION_CODE := FND_API.G_MISS_CHAR;
11511: x_rec_attr_tab(fmc).CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
11512: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11513: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11514: x_rec_attr_tab(fmc).CARRIER_CODE := FND_API.G_MISS_CHAR;
11515: x_rec_attr_tab(fmc).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11516: x_rec_attr_tab(fmc).FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
11517: x_rec_attr_tab(fmc).FOB_NAME := FND_API.G_MISS_CHAR;
11518: x_rec_attr_tab(fmc).FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
11511: x_rec_attr_tab(fmc).CUSTOMER_NUMBER := FND_API.G_MISS_CHAR;
11512: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11513: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11514: x_rec_attr_tab(fmc).CARRIER_CODE := FND_API.G_MISS_CHAR;
11515: x_rec_attr_tab(fmc).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11516: x_rec_attr_tab(fmc).FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
11517: x_rec_attr_tab(fmc).FOB_NAME := FND_API.G_MISS_CHAR;
11518: x_rec_attr_tab(fmc).FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
11519: x_rec_attr_tab(fmc).WEIGHT_UOM_DESC := FND_API.G_MISS_CHAR;
11512: x_rec_attr_tab(fmc).INTMED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11513: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11514: x_rec_attr_tab(fmc).CARRIER_CODE := FND_API.G_MISS_CHAR;
11515: x_rec_attr_tab(fmc).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11516: x_rec_attr_tab(fmc).FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
11517: x_rec_attr_tab(fmc).FOB_NAME := FND_API.G_MISS_CHAR;
11518: x_rec_attr_tab(fmc).FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
11519: x_rec_attr_tab(fmc).WEIGHT_UOM_DESC := FND_API.G_MISS_CHAR;
11520: x_rec_attr_tab(fmc).VOLUME_UOM_DESC := FND_API.G_MISS_CHAR;
11513: x_rec_attr_tab(fmc).POOLED_SHIP_TO_LOCATION_CODE := FND_API.G_MISS_CHAR;
11514: x_rec_attr_tab(fmc).CARRIER_CODE := FND_API.G_MISS_CHAR;
11515: x_rec_attr_tab(fmc).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11516: x_rec_attr_tab(fmc).FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
11517: x_rec_attr_tab(fmc).FOB_NAME := FND_API.G_MISS_CHAR;
11518: x_rec_attr_tab(fmc).FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
11519: x_rec_attr_tab(fmc).WEIGHT_UOM_DESC := FND_API.G_MISS_CHAR;
11520: x_rec_attr_tab(fmc).VOLUME_UOM_DESC := FND_API.G_MISS_CHAR;
11521: x_rec_attr_tab(fmc).CURRENCY_NAME := FND_API.G_MISS_CHAR;
11514: x_rec_attr_tab(fmc).CARRIER_CODE := FND_API.G_MISS_CHAR;
11515: x_rec_attr_tab(fmc).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11516: x_rec_attr_tab(fmc).FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
11517: x_rec_attr_tab(fmc).FOB_NAME := FND_API.G_MISS_CHAR;
11518: x_rec_attr_tab(fmc).FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
11519: x_rec_attr_tab(fmc).WEIGHT_UOM_DESC := FND_API.G_MISS_CHAR;
11520: x_rec_attr_tab(fmc).VOLUME_UOM_DESC := FND_API.G_MISS_CHAR;
11521: x_rec_attr_tab(fmc).CURRENCY_NAME := FND_API.G_MISS_CHAR;
11522: END IF;
11515: x_rec_attr_tab(fmc).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11516: x_rec_attr_tab(fmc).FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
11517: x_rec_attr_tab(fmc).FOB_NAME := FND_API.G_MISS_CHAR;
11518: x_rec_attr_tab(fmc).FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
11519: x_rec_attr_tab(fmc).WEIGHT_UOM_DESC := FND_API.G_MISS_CHAR;
11520: x_rec_attr_tab(fmc).VOLUME_UOM_DESC := FND_API.G_MISS_CHAR;
11521: x_rec_attr_tab(fmc).CURRENCY_NAME := FND_API.G_MISS_CHAR;
11522: END IF;
11523:
11516: x_rec_attr_tab(fmc).FREIGHT_TERMS_NAME := FND_API.G_MISS_CHAR;
11517: x_rec_attr_tab(fmc).FOB_NAME := FND_API.G_MISS_CHAR;
11518: x_rec_attr_tab(fmc).FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
11519: x_rec_attr_tab(fmc).WEIGHT_UOM_DESC := FND_API.G_MISS_CHAR;
11520: x_rec_attr_tab(fmc).VOLUME_UOM_DESC := FND_API.G_MISS_CHAR;
11521: x_rec_attr_tab(fmc).CURRENCY_NAME := FND_API.G_MISS_CHAR;
11522: END IF;
11523:
11524: ELSE
11517: x_rec_attr_tab(fmc).FOB_NAME := FND_API.G_MISS_CHAR;
11518: x_rec_attr_tab(fmc).FOB_LOCATION_CODE := FND_API.G_MISS_CHAR;
11519: x_rec_attr_tab(fmc).WEIGHT_UOM_DESC := FND_API.G_MISS_CHAR;
11520: x_rec_attr_tab(fmc).VOLUME_UOM_DESC := FND_API.G_MISS_CHAR;
11521: x_rec_attr_tab(fmc).CURRENCY_NAME := FND_API.G_MISS_CHAR;
11522: END IF;
11523:
11524: ELSE
11525:
11553: (p_caller = 'WSH_AUTO_CREATE_DEL_TRIP' AND l_skip_rtng_rule_ac_trip <> 'Y') THEN
11554: */ -- Hiding project
11555: x_trip_info_tab(fmct).TRIP_ID := p_cs_result_tab(fm).trip_id;
11556:
11557: x_trip_info_tab(fmct).NAME := FND_API.G_MISS_CHAR;
11558: --x_trip_info_tab(fmct).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11559: x_trip_info_tab(fmct).PLANNED_FLAG := 'N';
11560: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
11561: x_trip_info_tab(fmct).STATUS_CODE := 'OP';
11554: */ -- Hiding project
11555: x_trip_info_tab(fmct).TRIP_ID := p_cs_result_tab(fm).trip_id;
11556:
11557: x_trip_info_tab(fmct).NAME := FND_API.G_MISS_CHAR;
11558: --x_trip_info_tab(fmct).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11559: x_trip_info_tab(fmct).PLANNED_FLAG := 'N';
11560: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
11561: x_trip_info_tab(fmct).STATUS_CODE := 'OP';
11562: x_trip_info_tab(fmct).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
11556:
11557: x_trip_info_tab(fmct).NAME := FND_API.G_MISS_CHAR;
11558: --x_trip_info_tab(fmct).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11559: x_trip_info_tab(fmct).PLANNED_FLAG := 'N';
11560: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
11561: x_trip_info_tab(fmct).STATUS_CODE := 'OP';
11562: x_trip_info_tab(fmct).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
11563: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
11564: x_trip_info_tab(fmct).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
11558: --x_trip_info_tab(fmct).PLANNED_FLAG := FND_API.G_MISS_CHAR;
11559: x_trip_info_tab(fmct).PLANNED_FLAG := 'N';
11560: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
11561: x_trip_info_tab(fmct).STATUS_CODE := 'OP';
11562: x_trip_info_tab(fmct).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
11563: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
11564: x_trip_info_tab(fmct).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
11565: x_trip_info_tab(fmct).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
11566:
11559: x_trip_info_tab(fmct).PLANNED_FLAG := 'N';
11560: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
11561: x_trip_info_tab(fmct).STATUS_CODE := 'OP';
11562: x_trip_info_tab(fmct).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
11563: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
11564: x_trip_info_tab(fmct).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
11565: x_trip_info_tab(fmct).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
11566:
11567: /*IF (p_cs_result_tab(fm).carrier_id is null) THEN
11560: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_ID := FND_API.G_MISS_NUM;
11561: x_trip_info_tab(fmct).STATUS_CODE := 'OP';
11562: x_trip_info_tab(fmct).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
11563: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
11564: x_trip_info_tab(fmct).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
11565: x_trip_info_tab(fmct).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
11566:
11567: /*IF (p_cs_result_tab(fm).carrier_id is null) THEN
11568: x_trip_info_tab(fmct).CARRIER_ID := FND_API.G_MISS_NUM;
11561: x_trip_info_tab(fmct).STATUS_CODE := 'OP';
11562: x_trip_info_tab(fmct).VEHICLE_ITEM_ID := FND_API.G_MISS_NUM;
11563: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_ID := FND_API.G_MISS_NUM;
11564: x_trip_info_tab(fmct).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
11565: x_trip_info_tab(fmct).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
11566:
11567: /*IF (p_cs_result_tab(fm).carrier_id is null) THEN
11568: x_trip_info_tab(fmct).CARRIER_ID := FND_API.G_MISS_NUM;
11569: ELSE*/
11564: x_trip_info_tab(fmct).VEHICLE_NUMBER := FND_API.G_MISS_CHAR;
11565: x_trip_info_tab(fmct).VEHICLE_NUM_PREFIX := FND_API.G_MISS_CHAR;
11566:
11567: /*IF (p_cs_result_tab(fm).carrier_id is null) THEN
11568: x_trip_info_tab(fmct).CARRIER_ID := FND_API.G_MISS_NUM;
11569: ELSE*/
11570: x_trip_info_tab(fmct).CARRIER_ID := p_cs_result_tab(fm).carrier_id;
11571: --END IF;
11572:
11570: x_trip_info_tab(fmct).CARRIER_ID := p_cs_result_tab(fm).carrier_id;
11571: --END IF;
11572:
11573: /*IF (p_cs_result_tab(fm).ship_method_code is null) THEN
11574: x_trip_info_tab(fmct).SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;
11575: ELSE*/
11576: x_trip_info_tab(fmct).SHIP_METHOD_CODE := p_cs_result_tab(fm).ship_method_code;
11577: --END IF;
11578:
11577: --END IF;
11578:
11579:
11580: IF (p_cs_result_tab(fm).consignee_carrier_ac_no is null) THEN
11581: x_trip_info_tab(fmct).CONSIGNEE_CARRIER_AC_NO := FND_API.G_MISS_CHAR;
11582: ELSE
11583: x_trip_info_tab(fmct).CONSIGNEE_CARRIER_AC_NO := p_cs_result_tab(fm).consignee_carrier_ac_no;
11584: END IF;
11585:
11586: -- AG
11587: -- cs_result_tab.rank stores rank_sequence
11588: -- It is not same as trip's rank_id which has already been updated by FTE
11589: -- rank_list_action API
11590: x_trip_info_tab(fmct).RANK_ID := FND_API.G_MISS_NUM;
11591:
11592: IF (p_cs_result_tab(fm).append_flag is null) THEN
11593: x_trip_info_tab(fmct).APPEND_FLAG := FND_API.G_MISS_CHAR;
11594: ELSE
11589: -- rank_list_action API
11590: x_trip_info_tab(fmct).RANK_ID := FND_API.G_MISS_NUM;
11591:
11592: IF (p_cs_result_tab(fm).append_flag is null) THEN
11593: x_trip_info_tab(fmct).APPEND_FLAG := FND_API.G_MISS_CHAR;
11594: ELSE
11595: x_trip_info_tab(fmct).APPEND_FLAG := p_cs_result_tab(fm).append_flag;
11596: END IF;
11597:
11597:
11598: -- AG Use rule_id from p_cs_result_tab and not routing_rule_id
11599:
11600: IF (p_cs_result_tab(fm).rule_id is null) THEN
11601: x_trip_info_tab(fmct).ROUTING_RULE_ID := FND_API.G_MISS_NUM;
11602: ELSE
11603: x_trip_info_tab(fmct).ROUTING_RULE_ID := p_cs_result_tab(fm).rule_id ;
11604: END IF;
11605:
11602: ELSE
11603: x_trip_info_tab(fmct).ROUTING_RULE_ID := p_cs_result_tab(fm).rule_id ;
11604: END IF;
11605:
11606: x_trip_info_tab(fmct).ROUTE_ID := FND_API.G_MISS_NUM;
11607: x_trip_info_tab(fmct).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11608: x_trip_info_tab(fmct).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11609: x_trip_info_tab(fmct).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11610: x_trip_info_tab(fmct).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11603: x_trip_info_tab(fmct).ROUTING_RULE_ID := p_cs_result_tab(fm).rule_id ;
11604: END IF;
11605:
11606: x_trip_info_tab(fmct).ROUTE_ID := FND_API.G_MISS_NUM;
11607: x_trip_info_tab(fmct).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11608: x_trip_info_tab(fmct).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11609: x_trip_info_tab(fmct).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11610: x_trip_info_tab(fmct).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11611: x_trip_info_tab(fmct).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11604: END IF;
11605:
11606: x_trip_info_tab(fmct).ROUTE_ID := FND_API.G_MISS_NUM;
11607: x_trip_info_tab(fmct).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11608: x_trip_info_tab(fmct).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11609: x_trip_info_tab(fmct).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11610: x_trip_info_tab(fmct).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11611: x_trip_info_tab(fmct).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11612: x_trip_info_tab(fmct).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11605:
11606: x_trip_info_tab(fmct).ROUTE_ID := FND_API.G_MISS_NUM;
11607: x_trip_info_tab(fmct).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11608: x_trip_info_tab(fmct).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11609: x_trip_info_tab(fmct).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11610: x_trip_info_tab(fmct).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11611: x_trip_info_tab(fmct).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11612: x_trip_info_tab(fmct).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11613: x_trip_info_tab(fmct).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11606: x_trip_info_tab(fmct).ROUTE_ID := FND_API.G_MISS_NUM;
11607: x_trip_info_tab(fmct).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11608: x_trip_info_tab(fmct).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11609: x_trip_info_tab(fmct).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11610: x_trip_info_tab(fmct).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11611: x_trip_info_tab(fmct).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11612: x_trip_info_tab(fmct).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11613: x_trip_info_tab(fmct).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11614: x_trip_info_tab(fmct).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11607: x_trip_info_tab(fmct).ROUTING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
11608: x_trip_info_tab(fmct).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11609: x_trip_info_tab(fmct).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11610: x_trip_info_tab(fmct).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11611: x_trip_info_tab(fmct).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11612: x_trip_info_tab(fmct).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11613: x_trip_info_tab(fmct).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11614: x_trip_info_tab(fmct).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11615: x_trip_info_tab(fmct).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11608: x_trip_info_tab(fmct).ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
11609: x_trip_info_tab(fmct).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11610: x_trip_info_tab(fmct).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11611: x_trip_info_tab(fmct).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11612: x_trip_info_tab(fmct).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11613: x_trip_info_tab(fmct).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11614: x_trip_info_tab(fmct).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11615: x_trip_info_tab(fmct).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11616: x_trip_info_tab(fmct).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11609: x_trip_info_tab(fmct).ATTRIBUTE1 := FND_API.G_MISS_CHAR;
11610: x_trip_info_tab(fmct).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11611: x_trip_info_tab(fmct).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11612: x_trip_info_tab(fmct).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11613: x_trip_info_tab(fmct).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11614: x_trip_info_tab(fmct).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11615: x_trip_info_tab(fmct).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11616: x_trip_info_tab(fmct).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11617: x_trip_info_tab(fmct).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11610: x_trip_info_tab(fmct).ATTRIBUTE2 := FND_API.G_MISS_CHAR;
11611: x_trip_info_tab(fmct).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11612: x_trip_info_tab(fmct).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11613: x_trip_info_tab(fmct).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11614: x_trip_info_tab(fmct).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11615: x_trip_info_tab(fmct).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11616: x_trip_info_tab(fmct).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11617: x_trip_info_tab(fmct).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11618: x_trip_info_tab(fmct).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11611: x_trip_info_tab(fmct).ATTRIBUTE3 := FND_API.G_MISS_CHAR;
11612: x_trip_info_tab(fmct).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11613: x_trip_info_tab(fmct).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11614: x_trip_info_tab(fmct).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11615: x_trip_info_tab(fmct).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11616: x_trip_info_tab(fmct).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11617: x_trip_info_tab(fmct).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11618: x_trip_info_tab(fmct).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11619: x_trip_info_tab(fmct).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11612: x_trip_info_tab(fmct).ATTRIBUTE4 := FND_API.G_MISS_CHAR;
11613: x_trip_info_tab(fmct).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11614: x_trip_info_tab(fmct).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11615: x_trip_info_tab(fmct).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11616: x_trip_info_tab(fmct).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11617: x_trip_info_tab(fmct).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11618: x_trip_info_tab(fmct).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11619: x_trip_info_tab(fmct).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11620: x_trip_info_tab(fmct).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11613: x_trip_info_tab(fmct).ATTRIBUTE5 := FND_API.G_MISS_CHAR;
11614: x_trip_info_tab(fmct).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11615: x_trip_info_tab(fmct).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11616: x_trip_info_tab(fmct).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11617: x_trip_info_tab(fmct).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11618: x_trip_info_tab(fmct).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11619: x_trip_info_tab(fmct).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11620: x_trip_info_tab(fmct).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11621: x_trip_info_tab(fmct).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11614: x_trip_info_tab(fmct).ATTRIBUTE6 := FND_API.G_MISS_CHAR;
11615: x_trip_info_tab(fmct).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11616: x_trip_info_tab(fmct).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11617: x_trip_info_tab(fmct).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11618: x_trip_info_tab(fmct).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11619: x_trip_info_tab(fmct).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11620: x_trip_info_tab(fmct).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11621: x_trip_info_tab(fmct).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11622: x_trip_info_tab(fmct).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11615: x_trip_info_tab(fmct).ATTRIBUTE7 := FND_API.G_MISS_CHAR;
11616: x_trip_info_tab(fmct).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11617: x_trip_info_tab(fmct).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11618: x_trip_info_tab(fmct).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11619: x_trip_info_tab(fmct).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11620: x_trip_info_tab(fmct).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11621: x_trip_info_tab(fmct).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11622: x_trip_info_tab(fmct).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11623: x_trip_info_tab(fmct).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11616: x_trip_info_tab(fmct).ATTRIBUTE8 := FND_API.G_MISS_CHAR;
11617: x_trip_info_tab(fmct).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11618: x_trip_info_tab(fmct).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11619: x_trip_info_tab(fmct).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11620: x_trip_info_tab(fmct).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11621: x_trip_info_tab(fmct).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11622: x_trip_info_tab(fmct).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11623: x_trip_info_tab(fmct).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11624: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11617: x_trip_info_tab(fmct).ATTRIBUTE9 := FND_API.G_MISS_CHAR;
11618: x_trip_info_tab(fmct).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11619: x_trip_info_tab(fmct).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11620: x_trip_info_tab(fmct).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11621: x_trip_info_tab(fmct).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11622: x_trip_info_tab(fmct).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11623: x_trip_info_tab(fmct).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11624: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11625: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11618: x_trip_info_tab(fmct).ATTRIBUTE10 := FND_API.G_MISS_CHAR;
11619: x_trip_info_tab(fmct).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11620: x_trip_info_tab(fmct).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11621: x_trip_info_tab(fmct).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11622: x_trip_info_tab(fmct).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11623: x_trip_info_tab(fmct).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11624: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11625: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11626: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11619: x_trip_info_tab(fmct).ATTRIBUTE11 := FND_API.G_MISS_CHAR;
11620: x_trip_info_tab(fmct).ATTRIBUTE12 := FND_API.G_MISS_CHAR;
11621: x_trip_info_tab(fmct).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11622: x_trip_info_tab(fmct).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11623: x_trip_info_tab(fmct).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11624: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11625: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11626: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11627: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11625: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11626: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11627: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11628: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11629: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11630: x_trip_info_tab(fmct).PROGRAM_ID := FND_API.G_MISS_NUM;
11631: x_trip_info_tab(fmct).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11632: x_trip_info_tab(fmct).REQUEST_ID := FND_API.G_MISS_NUM;
11633:
11626: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11627: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11628: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11629: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11630: x_trip_info_tab(fmct).PROGRAM_ID := FND_API.G_MISS_NUM;
11631: x_trip_info_tab(fmct).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11632: x_trip_info_tab(fmct).REQUEST_ID := FND_API.G_MISS_NUM;
11633:
11634: /*IF (p_cs_result_tab(fm).service_level is null) THEN
11627: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11628: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11629: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11630: x_trip_info_tab(fmct).PROGRAM_ID := FND_API.G_MISS_NUM;
11631: x_trip_info_tab(fmct).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11632: x_trip_info_tab(fmct).REQUEST_ID := FND_API.G_MISS_NUM;
11633:
11634: /*IF (p_cs_result_tab(fm).service_level is null) THEN
11635: x_trip_info_tab(fmct).SERVICE_LEVEL := FND_API.G_MISS_CHAR;
11628: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11629: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11630: x_trip_info_tab(fmct).PROGRAM_ID := FND_API.G_MISS_NUM;
11631: x_trip_info_tab(fmct).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11632: x_trip_info_tab(fmct).REQUEST_ID := FND_API.G_MISS_NUM;
11633:
11634: /*IF (p_cs_result_tab(fm).service_level is null) THEN
11635: x_trip_info_tab(fmct).SERVICE_LEVEL := FND_API.G_MISS_CHAR;
11636: ELSE*/
11631: x_trip_info_tab(fmct).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11632: x_trip_info_tab(fmct).REQUEST_ID := FND_API.G_MISS_NUM;
11633:
11634: /*IF (p_cs_result_tab(fm).service_level is null) THEN
11635: x_trip_info_tab(fmct).SERVICE_LEVEL := FND_API.G_MISS_CHAR;
11636: ELSE*/
11637: x_trip_info_tab(fmct).SERVICE_LEVEL := p_cs_result_tab(fm).service_level;
11638: --END IF;
11639:
11637: x_trip_info_tab(fmct).SERVICE_LEVEL := p_cs_result_tab(fm).service_level;
11638: --END IF;
11639:
11640: /*IF (p_cs_result_tab(fm).mode_of_transport is null) THEN
11641: x_trip_info_tab(fmct).MODE_OF_TRANSPORT := FND_API.G_MISS_CHAR;
11642: ELSE*/
11643: x_trip_info_tab(fmct).MODE_OF_TRANSPORT := p_cs_result_tab(fm).mode_of_transport;
11644: --END IF;
11645:
11643: x_trip_info_tab(fmct).MODE_OF_TRANSPORT := p_cs_result_tab(fm).mode_of_transport;
11644: --END IF;
11645:
11646: IF (p_cs_result_tab(fm).freight_terms_code is null) THEN
11647: x_trip_info_tab(fmct).FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
11648: ELSE
11649: x_trip_info_tab(fmct).FREIGHT_TERMS_CODE := p_cs_result_tab(fm).freight_terms_code;
11650: END IF;
11651:
11648: ELSE
11649: x_trip_info_tab(fmct).FREIGHT_TERMS_CODE := p_cs_result_tab(fm).freight_terms_code;
11650: END IF;
11651:
11652: x_trip_info_tab(fmct).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
11653: x_trip_info_tab(fmct).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
11654: x_trip_info_tab(fmct).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
11655: x_trip_info_tab(fmct).LANE_ID := FND_API.G_MISS_NUM;
11656: x_trip_info_tab(fmct).SCHEDULE_ID := FND_API.G_MISS_NUM;
11649: x_trip_info_tab(fmct).FREIGHT_TERMS_CODE := p_cs_result_tab(fm).freight_terms_code;
11650: END IF;
11651:
11652: x_trip_info_tab(fmct).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
11653: x_trip_info_tab(fmct).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
11654: x_trip_info_tab(fmct).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
11655: x_trip_info_tab(fmct).LANE_ID := FND_API.G_MISS_NUM;
11656: x_trip_info_tab(fmct).SCHEDULE_ID := FND_API.G_MISS_NUM;
11657: x_trip_info_tab(fmct).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
11650: END IF;
11651:
11652: x_trip_info_tab(fmct).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
11653: x_trip_info_tab(fmct).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
11654: x_trip_info_tab(fmct).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
11655: x_trip_info_tab(fmct).LANE_ID := FND_API.G_MISS_NUM;
11656: x_trip_info_tab(fmct).SCHEDULE_ID := FND_API.G_MISS_NUM;
11657: x_trip_info_tab(fmct).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
11658: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
11651:
11652: x_trip_info_tab(fmct).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
11653: x_trip_info_tab(fmct).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
11654: x_trip_info_tab(fmct).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
11655: x_trip_info_tab(fmct).LANE_ID := FND_API.G_MISS_NUM;
11656: x_trip_info_tab(fmct).SCHEDULE_ID := FND_API.G_MISS_NUM;
11657: x_trip_info_tab(fmct).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
11658: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
11659: x_trip_info_tab(fmct).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11652: x_trip_info_tab(fmct).CONSOLIDATION_ALLOWED := FND_API.G_MISS_CHAR;
11653: x_trip_info_tab(fmct).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
11654: x_trip_info_tab(fmct).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
11655: x_trip_info_tab(fmct).LANE_ID := FND_API.G_MISS_NUM;
11656: x_trip_info_tab(fmct).SCHEDULE_ID := FND_API.G_MISS_NUM;
11657: x_trip_info_tab(fmct).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
11658: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
11659: x_trip_info_tab(fmct).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11660: x_trip_info_tab(fmct).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
11653: x_trip_info_tab(fmct).LOAD_TENDER_STATUS := FND_API.G_MISS_CHAR;
11654: x_trip_info_tab(fmct).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
11655: x_trip_info_tab(fmct).LANE_ID := FND_API.G_MISS_NUM;
11656: x_trip_info_tab(fmct).SCHEDULE_ID := FND_API.G_MISS_NUM;
11657: x_trip_info_tab(fmct).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
11658: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
11659: x_trip_info_tab(fmct).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11660: x_trip_info_tab(fmct).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
11661: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11654: x_trip_info_tab(fmct).ROUTE_LANE_ID := FND_API.G_MISS_NUM;
11655: x_trip_info_tab(fmct).LANE_ID := FND_API.G_MISS_NUM;
11656: x_trip_info_tab(fmct).SCHEDULE_ID := FND_API.G_MISS_NUM;
11657: x_trip_info_tab(fmct).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
11658: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
11659: x_trip_info_tab(fmct).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11660: x_trip_info_tab(fmct).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
11661: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11662:
11655: x_trip_info_tab(fmct).LANE_ID := FND_API.G_MISS_NUM;
11656: x_trip_info_tab(fmct).SCHEDULE_ID := FND_API.G_MISS_NUM;
11657: x_trip_info_tab(fmct).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
11658: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
11659: x_trip_info_tab(fmct).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11660: x_trip_info_tab(fmct).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
11661: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11662:
11663: --END IF; --Commented for bug 14768761
11656: x_trip_info_tab(fmct).SCHEDULE_ID := FND_API.G_MISS_NUM;
11657: x_trip_info_tab(fmct).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
11658: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
11659: x_trip_info_tab(fmct).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11660: x_trip_info_tab(fmct).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
11661: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11662:
11663: --END IF; --Commented for bug 14768761
11664: END IF;
11657: x_trip_info_tab(fmct).BOOKING_NUMBER := FND_API.G_MISS_CHAR;
11658: x_trip_info_tab(fmct).ARRIVE_AFTER_TRIP_NAME := FND_API.G_MISS_CHAR;
11659: x_trip_info_tab(fmct).SHIP_METHOD_NAME := FND_API.G_MISS_CHAR;
11660: x_trip_info_tab(fmct).VEHICLE_ITEM_DESC := FND_API.G_MISS_CHAR;
11661: x_trip_info_tab(fmct).VEHICLE_ORGANIZATION_CODE := FND_API.G_MISS_CHAR;
11662:
11663: --END IF; --Commented for bug 14768761
11664: END IF;
11665:
12498: x_return_status => l_return_status);
12499:
12500: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
12501: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
12502: raise FND_API.G_EXC_UNEXPECTED_ERROR;
12503: END IF;
12504: END IF;
12505:
12506: IF l_debug_on THEN
12629: END IF;
12630:
12631: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(
12632: --p_api_version_number => 1.0,
12633: --p_init_msg_list => FND_API.G_FALSE,
12634: x_return_status => l_return_status,
12635: x_msg_count => l_msg_count,
12636: x_msg_data => l_msg_data,
12637: p_action_code => 'REPLACE',
12640: p_rank_id => l_rank_id);
12641:
12642: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
12643: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
12644: raise FND_API.G_EXC_UNEXPECTED_ERROR;
12645: END IF;
12646: END IF;
12647: */ -- Hiding project
12648: l_ranked_list.DELETE;
12756: x_return_status => l_return_status);
12757:
12758: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
12759: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
12760: raise FND_API.G_EXC_UNEXPECTED_ERROR;
12761: END IF;
12762: END IF;
12763: l_cs_result_tab(j).trip_id := l_trip_id;
12764:
12784: --
12785:
12786: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(
12787: -- p_api_version_number => 1.0,
12788: -- p_init_msg_list => FND_API.G_FALSE,
12789: x_return_status => l_return_status,
12790: x_msg_count => l_msg_count,
12791: x_msg_data => l_msg_data,
12792: p_action_code => 'REPLACE',
12795: p_rank_id => l_rank_id);
12796:
12797: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
12798: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
12799: raise FND_API.G_EXC_UNEXPECTED_ERROR;
12800: END IF;
12801: END IF;
12802: l_ranked_list.DELETE;
12803: list_cnt := 1;
13580: wsh_debug_sv.pop(l_module_name);
13581: END IF;
13582:
13583: EXCEPTION
13584: WHEN FND_API.G_EXC_ERROR THEN
13585: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
13586: IF c_check_trips%ISOPEN THEN
13587: CLOSE c_check_trips;
13588: END IF;
13603: --
13604: -- Debug Statements
13605: --
13606: IF l_debug_on THEN
13607: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
13608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
13609: END IF;
13610:
13611: WHEN WSH_INVALID_TRIP THEN
13604: -- Debug Statements
13605: --
13606: IF l_debug_on THEN
13607: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
13608: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
13609: END IF;
13610:
13611: WHEN WSH_INVALID_TRIP THEN
13612: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14198: WSH_DEBUG_SV.pop(l_module_name);
14199: END IF;
14200:
14201: EXCEPTION
14202: WHEN FND_API.G_EXC_ERROR THEN
14203: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14204: --
14205: -- Debug Statements
14206: --
14204: --
14205: -- Debug Statements
14206: --
14207: IF l_debug_on THEN
14208: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
14209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
14210: END IF;
14211: --
14212:
14205: -- Debug Statements
14206: --
14207: IF l_debug_on THEN
14208: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
14209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
14210: END IF;
14211: --
14212:
14213: WHEN WSH_NO_OPEN_CHILD_DELIVERIES THEN
14392: WSH_DEBUG_SV.log(l_module_name,'l_return_status after calling validate_del_containers', l_return_status);
14393: END IF;
14394:
14395: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
14396: RAISE FND_API.G_EXC_ERROR;
14397: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
14398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14399: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
14400: l_num_warnings := l_num_warnings + 1;
14394:
14395: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
14396: RAISE FND_API.G_EXC_ERROR;
14397: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
14398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14399: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
14400: l_num_warnings := l_num_warnings + 1;
14401: END IF;
14402: --}
14447: IF (l_num_err >= l_u_consol_del_tab.count AND l_num_err > 0) THEN
14448: IF l_debug_on THEN
14449: WSH_DEBUG_SV.logmsg(l_module_name,'None of the Deliveries are eligible of Ship Confirm');
14450: END IF;
14451: RAISE FND_API.G_EXC_ERROR;
14452: END IF;
14453: -- bug 4505105
14454:
14455: BEGIN
14517: -- bug 4505105
14518:
14519: EXCEPTION
14520: -- bug 4505105
14521: WHEN FND_API.G_EXC_ERROR THEN
14522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14523: --
14524: IF l_debug_on THEN
14525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
14521: WHEN FND_API.G_EXC_ERROR THEN
14522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14523: --
14524: IF l_debug_on THEN
14525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
14526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
14527: END IF;
14528: --
14529: -- bug 4505105
14522: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14523: --
14524: IF l_debug_on THEN
14525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
14526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
14527: END IF;
14528: --
14529: -- bug 4505105
14530: WHEN OTHERS THEN
14649: l_trip_info_tab(1).service_level := del.service_level;
14650: l_trip_info_tab(1).mode_of_transport := del.mode_of_transport;
14651: l_trip_info_tab(1).carrier_id := del.carrier_id;
14652:
14653: l_commit := FND_API.g_false;
14654: IF l_debug_on THEN
14655: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
14656: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
14657: END IF;
14725: WSH_DEBUG_SV.pop(l_module_name);
14726: END IF;
14727:
14728: EXCEPTION
14729: WHEN FND_API.G_EXC_ERROR THEN
14730: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14731: --
14732: IF l_debug_on THEN
14733: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
14729: WHEN FND_API.G_EXC_ERROR THEN
14730: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14731: --
14732: IF l_debug_on THEN
14733: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
14734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
14735: END IF;
14736: --
14737: WHEN OTHERS THEN
14730: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
14731: --
14732: IF l_debug_on THEN
14733: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
14734: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
14735: END IF;
14736: --
14737: WHEN OTHERS THEN
14738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;