[Home] [Help]
147: -- Bug 8446283 (Added wt/vol UOM codes on shipping parameters forms)
148: WEIGHT_UOM_CODE,
149: VOLUME_UOM_CODE
150: -- Bug 8446283 : end
151: FROM WSH_SHIPPING_PARAMETERS
152: WHERE ORGANIZATION_ID = v_organization_id;
153:
154: l_found BOOLEAN := FALSE;
155: l_param_info Parameter_Rec_Typ;
958: End If;
959:
960: Begin
961: --bug# 6689448 (replenishment project): added the field dynamic_replenishment_flag
962: Insert into wsh_shipping_parameters (
963: goods_dispatched_account,
964: location_id,
965: organization_id,
966: weight_uom_class,
1139: );
1140: Exception
1141: When others then
1142: If l_debug_on then
1143: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);
1144: End If;
1145: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1146: fnd_message.set_token('PACKAGE',l_module_name);
1147: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1148: fnd_message.set_token('ORA_TEXT',SQLERRM);
1149: raise handle_exception;
1150: End;
1151: If l_debug_on then
1152: wsh_debug_sv.log(l_module_name,'After insert into WSH_SHIPPING_PARAMETERS SQLERRM : ',sqlerrm);
1153: End If;
1154:
1155:
1156: If p_ship_par_val_rec.class_code.count > 0 then /* Start of Main If logic */
1376: If l_debug_on then
1377: wsh_debug_sv.push(l_module_name);
1378: End If;
1379: Begin
1380: UPDATE wsh_shipping_parameters set
1381: goods_dispatched_account = p_ship_par_rec.goods_dispatched_account,
1382: location_id = p_ship_par_rec.location_id,
1383: organization_id = p_ship_par_rec.organization_id,
1384: weight_uom_class = p_ship_par_rec.weight_uom_class,
1464: -- Bug 8446283 : end
1465: WHERE organization_id = p_ship_par_rec.organization_id;
1466:
1467: If l_debug_on then
1468: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameters table : ',sqlerrm);
1469: End If;
1470:
1471: Exception
1472: When others then
1470:
1471: Exception
1472: When others then
1473: If l_debug_on then
1474: wsh_debug_sv.log(l_module_name,'After update of values in wsh_shipping_parameters table : ',sqlerrm);
1475: End If;
1476: fnd_message.set_name('WSH','WSH_UNEXP_ERROR');
1477: fnd_message.set_token('PACKAGE',l_module_name);
1478: fnd_message.set_token('ORA_ERROR',to_char(sqlcode));
1711: x_return_status OUT NOCOPY VARCHAR2) is
1712:
1713: Cursor get_last_update_date_csr is
1714: select last_update_date
1715: from wsh_shipping_parameters
1716: where organization_id = p_organization_id;
1717:
1718: Cursor l_lock_csr is
1719: select 1
1716: where organization_id = p_organization_id;
1717:
1718: Cursor l_lock_csr is
1719: select 1
1720: from wsh_shipping_parameters
1721: where organization_id = p_organization_id
1722: for update nowait;
1723:
1724: l_id number :=0;
1880: wsh_debug_sv.log(l_module_name,'P_ORGANIZATION_ID',p_organization_id);
1881: END IF;
1882:
1883: ------------------------------------------------------------------------
1884: -- Get values from wsh_shipping_parameters table . -
1885: ------------------------------------------------------------------------
1886: get(p_organization_id => p_organization_id
1887: ,x_param_info => l_param_info
1888: ,x_return_status => l_return_status);
2350:
2351: Begin
2352:
2353: x_return_status := fnd_api.g_ret_sts_success;
2354: If p_print_info = 'WSH_SHIPPING_PARAMETERS' OR p_print_info = 'ALL' then
2355: wsh_debug_sv.log(p_module_name,'x_param_info.ship_confirm_rule_id',x_param_info.ship_confirm_rule_id);
2356: wsh_debug_sv.log(p_module_name,'x_param_info.autopack_level',x_param_info.autopack_level);
2357: wsh_debug_sv.log(p_module_name,'x_param_info.task_planning_flag',x_param_info.task_planning_flag);
2358: wsh_debug_sv.log(p_module_name,'x_param_info.export_screening_flag',x_param_info.export_screening_flag);