DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_UTIL_VALIDATE

Line 1211: IF (wsh_util_validate.Check_Wms_Org(l_org)='Y') THEN

1207: RAISE update_failed;
1208: END IF;
1209: CLOSE get_org;
1210:
1211: IF (wsh_util_validate.Check_Wms_Org(l_org)='Y') THEN
1212: l_detail_in_rec.caller := 'WMS';
1213: ELSE
1214: l_detail_in_rec.caller := 'WSH_GRP';
1215: END IF;

Line 5044: WSH_UTIL_VALIDATE.Validate_Org (l_organization_id,

5040: l_organization_code := p_detail_IN_rec.organization_code;
5041: --
5042: IF l_verify_org_level = 1 THEN --{
5043: --
5044: WSH_UTIL_VALIDATE.Validate_Org (l_organization_id,
5045: l_organization_code,
5046: l_return_status);
5047: IF l_return_status NOT IN ( wsh_util_core.g_ret_sts_success ,WSH_UTIL_CORE.G_RET_STS_WARNING)
5048: THEN

Line 5099: WSH_UTIL_VALIDATE.Validate_Item

5095: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
5096: RAISE e_NO_INV_ITEM;
5097: ELSE --}{
5098: --
5099: WSH_UTIL_VALIDATE.Validate_Item
5100: (p_inventory_item_id => l_cont_item_id,
5101: p_inventory_item => l_cont_item_name,
5102: p_organization_id => l_organization_id,
5103: p_seg_array => l_cont_item_seg,

Line 5871: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.FIND_ITEM_TYPE',WSH_DEBUG_SV.C_PROC_LEVEL);

5867: -- Validate Item and see if this is container item
5868: -- Error out if this is a container item
5869:
5870: IF l_debug_on THEN
5871: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.FIND_ITEM_TYPE',WSH_DEBUG_SV.C_PROC_LEVEL);
5872: END IF;
5873:
5874: WSH_UTIL_VALIDATE.Find_Item_Type
5875: (

Line 5874: WSH_UTIL_VALIDATE.Find_Item_Type

5870: IF l_debug_on THEN
5871: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.FIND_ITEM_TYPE',WSH_DEBUG_SV.C_PROC_LEVEL);
5872: END IF;
5873:
5874: WSH_UTIL_VALIDATE.Find_Item_Type
5875: (
5876: p_inventory_item_id => p_detail_info_tab(l_index).inventory_item_id,
5877: p_organization_id => p_detail_info_tab(l_index).organization_id,
5878: x_item_type => l_item_type,

Line 6413: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);

6409: l_required_field := 'SHIP_FROM_LOCATION_ID';
6410: raise e_required_field_null;
6411: ELSE
6412: IF l_debug_on THEN
6413: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
6414: END IF;
6415: wsh_util_validate.validate_location(
6416: p_location_id => x_detail_info_tab(l_index).ship_from_location_id,
6417: x_return_status => l_return_status,

Line 6415: wsh_util_validate.validate_location(

6411: ELSE
6412: IF l_debug_on THEN
6413: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
6414: END IF;
6415: wsh_util_validate.validate_location(
6416: p_location_id => x_detail_info_tab(l_index).ship_from_location_id,
6417: x_return_status => l_return_status,
6418: p_isWshLocation => l_isWshLocation);
6419:

Line 6433: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);

6429: l_required_field := 'SHIP_TO_LOCATION_ID';
6430: raise e_required_field_null;
6431: ELSE
6432: IF l_debug_on THEN
6433: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
6434: END IF;
6435: wsh_util_validate.validate_location(
6436: p_location_id => x_detail_info_tab(l_index).ship_to_location_id,
6437: x_return_status => l_return_status,

Line 6435: wsh_util_validate.validate_location(

6431: ELSE
6432: IF l_debug_on THEN
6433: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
6434: END IF;
6435: wsh_util_validate.validate_location(
6436: p_location_id => x_detail_info_tab(l_index).ship_to_location_id,
6437: x_return_status => l_return_status,
6438: p_isWshLocation => l_isWshLocation);
6439:

Line 7636: l_wms_installed := wsh_util_validate.Check_Wms_Org(x_detail_rec.organization_id);

7632: SAVEPOINT validate_det_line_grp;
7633:
7634: --bug 12597783
7635:
7636: l_wms_installed := wsh_util_validate.Check_Wms_Org(x_detail_rec.organization_id);
7637:
7638: IF (l_wms_installed = 'Y') THEN
7639: OPEN get_lpn_id;
7640: FETCH get_lpn_id INTO l_lpn_id;

Line 7685: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',

7681:
7682: IF (p_validation_tab(wsh_actions_levels.c_tol_above_lvl) = 1) THEN
7683: IF l_debug_on THEN
7684: WSH_DEBUG_SV.log(l_module_name, 'Ship Tolerance Above', x_detail_rec.ship_tolerance_above);
7685: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',
7686: WSH_DEBUG_SV.c_proc_level);
7687: END IF;
7688:
7689: --Bug # 3266333

Line 7690: wsh_util_validate.validate_negative(

7686: WSH_DEBUG_SV.c_proc_level);
7687: END IF;
7688:
7689: --Bug # 3266333
7690: wsh_util_validate.validate_negative(
7691: p_value => x_detail_rec.ship_tolerance_above,
7692: p_field_name => 'ship_tolerance_above',
7693: x_return_status => l_return_status );
7694: --

Line 7707: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.c_proc_level);

7703:
7704: IF (p_validation_tab(wsh_actions_levels.c_tol_below_lvl) = 1) THEN
7705: IF l_debug_on THEN
7706: WSH_DEBUG_SV.log(l_module_name, 'Ship Tolerance Below', x_detail_rec.ship_tolerance_below);
7707: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.c_proc_level);
7708: END IF;
7709:
7710: --Bug # 3266333
7711: wsh_util_validate.validate_negative(

Line 7711: wsh_util_validate.validate_negative(

7707: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.c_proc_level);
7708: END IF;
7709:
7710: --Bug # 3266333
7711: wsh_util_validate.validate_negative(
7712: p_value => x_detail_rec.ship_tolerance_below,
7713: p_field_name => 'ship_tolerance_below',
7714: x_return_status => l_return_status );
7715: --

Line 8087: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD', WSH_DEBUG_SV.c_proc_level);

8083: IF (p_validation_tab(wsh_actions_levels.c_smc_lvl) = 1) THEN
8084: IF (x_detail_rec.ship_method_code <> fnd_api.g_miss_char) THEN
8085: IF l_debug_on THEN
8086: WSH_DEBUG_SV.log(l_module_name, 'Ship Method', x_detail_rec.ship_method_code);
8087: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD', WSH_DEBUG_SV.c_proc_level);
8088: END IF;
8089:
8090: --
8091: wsh_util_validate.validate_ship_method(

Line 8091: wsh_util_validate.validate_ship_method(

8087: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD', WSH_DEBUG_SV.c_proc_level);
8088: END IF;
8089:
8090: --
8091: wsh_util_validate.validate_ship_method(
8092: p_ship_method_code => x_detail_rec.ship_method_code,
8093: p_ship_method_name => l_ship_method_name,
8094: x_return_status => l_return_status);
8095: --

Line 8109: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);

8105: IF (p_validation_tab(wsh_actions_levels.c_dep_plan_lvl) = 1) THEN
8106: IF (x_detail_rec.dep_plan_required_flag <> fnd_api.g_miss_char) THEN
8107: IF l_debug_on THEN
8108: WSH_DEBUG_SV.log(l_module_name, 'Departure Plan Flag', x_detail_rec.dep_plan_required_flag);
8109: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
8110: END IF;
8111:
8112: --
8113: wsh_util_validate.validate_boolean(

Line 8113: wsh_util_validate.validate_boolean(

8109: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
8110: END IF;
8111:
8112: --
8113: wsh_util_validate.validate_boolean(
8114: p_flag => x_detail_rec.dep_plan_required_flag,
8115: x_return_status => l_return_status);
8116: --
8117: wsh_util_core.api_post_call(

Line 8130: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);

8126: IF (p_validation_tab(wsh_actions_levels.c_ship_mod_comp_lvl) = 1) THEN
8127: IF (x_detail_rec.ship_model_complete_flag <> fnd_api.g_miss_char) THEN
8128: IF l_debug_on THEN
8129: WSH_DEBUG_SV.log(l_module_name, 'Ship Model Complete Flag', x_detail_rec.ship_model_complete_flag);
8130: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
8131: END IF;
8132:
8133: --
8134: wsh_util_validate.validate_boolean(

Line 8134: wsh_util_validate.validate_boolean(

8130: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
8131: END IF;
8132:
8133: --
8134: wsh_util_validate.validate_boolean(
8135: p_flag => x_detail_rec.ship_model_complete_flag,
8136: x_return_status => l_return_status);
8137: --
8138: wsh_util_core.api_post_call(

Line 8400: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

8396: IF (p_validation_tab(wsh_actions_levels.c_sold_contact_lvl) = 1) THEN
8397: IF (x_detail_rec.sold_to_contact_id <> fnd_api.g_miss_num) THEN
8398: IF l_debug_on THEN
8399: WSH_DEBUG_SV.log(l_module_name, 'Sold to Contact', x_detail_rec.sold_to_contact_id);
8400: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8401: END IF;
8402:
8403: --
8404: wsh_util_validate.validate_contact(

Line 8404: wsh_util_validate.validate_contact(

8400: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8401: END IF;
8402:
8403: --
8404: wsh_util_validate.validate_contact(
8405: p_contact_id => x_detail_rec.sold_to_contact_id,
8406: x_return_status => l_return_status);
8407: wsh_util_core.api_post_call(
8408: p_return_status => l_return_status,

Line 8420: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

8416: IF (p_validation_tab(wsh_actions_levels.c_ship_contact_lvl) = 1) THEN
8417: IF (x_detail_rec.ship_to_contact_id <> fnd_api.g_miss_num) THEN
8418: IF l_debug_on THEN
8419: WSH_DEBUG_SV.log(l_module_name, 'Ship to Contact Id', x_detail_rec.ship_to_contact_id);
8420: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8421: END IF;
8422:
8423: --
8424: wsh_util_validate.validate_contact(

Line 8424: wsh_util_validate.validate_contact(

8420: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8421: END IF;
8422:
8423: --
8424: wsh_util_validate.validate_contact(
8425: p_contact_id => x_detail_rec.ship_to_contact_id,
8426: x_return_status => l_return_status);
8427: --
8428: wsh_util_core.api_post_call(

Line 8441: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

8437: IF (p_validation_tab(wsh_actions_levels.c_deliver_contact_lvl) = 1) THEN
8438: IF (x_detail_rec.deliver_to_contact_id <> fnd_api.g_miss_num) THEN
8439: IF l_debug_on THEN
8440: WSH_DEBUG_SV.log(l_module_name, 'Deliver To Contact', x_detail_rec.deliver_to_contact_id);
8441: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8442: END IF;
8443:
8444: --
8445: wsh_util_validate.validate_contact(

Line 8445: wsh_util_validate.validate_contact(

8441: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8442: END IF;
8443:
8444: --
8445: wsh_util_validate.validate_contact(
8446: p_contact_id => x_detail_rec.deliver_to_contact_id,
8447: x_return_status => l_return_status);
8448: --
8449: wsh_util_core.api_post_call(

Line 8462: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);

8458: IF (p_validation_tab(wsh_actions_levels.c_intmed_ship_contact_lvl) = 1) THEN
8459: IF (x_detail_rec.intmed_ship_to_contact_id <> fnd_api.g_miss_num) THEN
8460: IF l_debug_on THEN
8461: WSH_DEBUG_SV.log(l_module_name, 'Intmed Ship To Contact', x_detail_rec.intmed_ship_to_contact_id);
8462: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8463: END IF;
8464:
8465: --
8466: wsh_util_validate.validate_contact(

Line 8466: wsh_util_validate.validate_contact(

8462: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8463: END IF;
8464:
8465: --
8466: wsh_util_validate.validate_contact(
8467: p_contact_id => x_detail_rec.intmed_ship_to_contact_id,
8468: x_return_status => l_return_status);
8469: --
8470: wsh_util_core.api_post_call(

Line 8630: IF (wsh_util_validate.Check_Wms_Org(l_org_id)='Y') THEN --{

8626: --bug 4365589
8627: IF p_in_rec.caller = 'WSH_PUB'
8628: AND l_inv_controls.serial_code IN (2,5)
8629: THEN --{
8630: IF (wsh_util_validate.Check_Wms_Org(l_org_id)='Y') THEN --{
8631: IF l_debug_on THEN
8632: WSH_DEBUG_SV.logmsg(l_module_name, 'Cannot modify the serial numbers for WMS organizationx ');
8633: END IF;
8634:

Line 9426: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);

9422: --
9423: IF l_debug_on THEN
9424: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item Id', x_detail_rec.inventory_item_id);
9425: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', x_detail_rec.organization_id);
9426: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9427: END IF;
9428: --
9429: WSH_UTIL_VALIDATE.Validate_Item(
9430: p_inventory_item_id => x_detail_rec.inventory_item_id,

Line 9429: WSH_UTIL_VALIDATE.Validate_Item(

9425: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', x_detail_rec.organization_id);
9426: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9427: END IF;
9428: --
9429: WSH_UTIL_VALIDATE.Validate_Item(
9430: p_inventory_item_id => x_detail_rec.inventory_item_id,
9431: p_inventory_item => l_cont_item_name,
9432: p_organization_id => p_original_rec.organization_id,
9433: p_seg_array => l_cont_item_seg,

Line 9638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);

9634:
9635: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_GROSS_WEIGHT_LVL) = 1 ) THEN
9636: IF l_debug_on THEN
9637: WSH_DEBUG_SV.log(l_module_name, 'Gross Weight', x_detail_rec.gross_weight);
9638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9639: END IF;
9640: --Bug # 3266333
9641: wsh_util_validate.validate_negative(
9642: p_value => x_detail_rec.gross_weight,

Line 9641: wsh_util_validate.validate_negative(

9637: WSH_DEBUG_SV.log(l_module_name, 'Gross Weight', x_detail_rec.gross_weight);
9638: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9639: END IF;
9640: --Bug # 3266333
9641: wsh_util_validate.validate_negative(
9642: p_value => x_detail_rec.gross_weight,
9643: p_field_name => 'gross_weight',
9644: x_return_status => l_return_status );
9645: --

Line 9660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);

9656: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_NET_WEIGHT_LVL) = 1 ) THEN
9657: --
9658: IF l_debug_on THEN
9659: WSH_DEBUG_SV.log(l_module_name, 'Net Weight', x_detail_rec.net_weight);
9660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9661: END IF;
9662: --Bug # 3266333
9663: wsh_util_validate.validate_negative(
9664: p_value => x_detail_rec.net_weight,

Line 9663: wsh_util_validate.validate_negative(

9659: WSH_DEBUG_SV.log(l_module_name, 'Net Weight', x_detail_rec.net_weight);
9660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9661: END IF;
9662: --Bug # 3266333
9663: wsh_util_validate.validate_negative(
9664: p_value => x_detail_rec.net_weight,
9665: p_field_name => 'net_weight',
9666: x_return_status => l_return_status );
9667: --

Line 9683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);

9679: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_VOLUME_LVL) = 1 ) THEN
9680: --
9681: IF l_debug_on THEN
9682: WSH_DEBUG_SV.log(l_module_name, 'Volume', x_detail_rec.volume);
9683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9684: END IF;
9685: --Bug # 3266333
9686: wsh_util_validate.validate_negative(
9687: p_value => x_detail_rec.volume,

Line 9686: wsh_util_validate.validate_negative(

9682: WSH_DEBUG_SV.log(l_module_name, 'Volume', x_detail_rec.volume);
9683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9684: END IF;
9685: --Bug # 3266333
9686: wsh_util_validate.validate_negative(
9687: p_value => x_detail_rec.volume,
9688: p_field_name => 'volume',
9689: x_return_status => l_return_status );
9690: --

Line 9762: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);

9758: IF x_detail_rec.master_container_item_id IS NOT NULL THEN
9759:
9760: IF l_debug_on THEN
9761: WSH_DEBUG_SV.log(l_module_name, 'Master cont item id', x_detail_rec.master_container_item_id);
9762: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9763: END IF;
9764:
9765: WSH_UTIL_VALIDATE.Validate_Item(
9766: p_inventory_item_id => x_detail_rec.master_container_item_id,

Line 9765: WSH_UTIL_VALIDATE.Validate_Item(

9761: WSH_DEBUG_SV.log(l_module_name, 'Master cont item id', x_detail_rec.master_container_item_id);
9762: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9763: END IF;
9764:
9765: WSH_UTIL_VALIDATE.Validate_Item(
9766: p_inventory_item_id => x_detail_rec.master_container_item_id,
9767: p_inventory_item => l_cont_item_name,
9768: p_organization_id => p_original_rec.organization_id,
9769: p_seg_array => l_cont_item_seg,

Line 9788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);

9784: IF x_detail_rec.detail_container_item_id IS NOT NULL THEN
9785:
9786: IF l_debug_on THEN
9787: WSH_DEBUG_SV.log(l_module_name, 'Detail cont item id', x_detail_rec.Detail_container_item_id);
9788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9789: END IF;
9790:
9791: WSH_UTIL_VALIDATE.Validate_Item(
9792: p_inventory_item_id => x_detail_rec.detail_container_item_id,

Line 9791: WSH_UTIL_VALIDATE.Validate_Item(

9787: WSH_DEBUG_SV.log(l_module_name, 'Detail cont item id', x_detail_rec.Detail_container_item_id);
9788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9789: END IF;
9790:
9791: WSH_UTIL_VALIDATE.Validate_Item(
9792: p_inventory_item_id => x_detail_rec.detail_container_item_id,
9793: p_inventory_item => l_cont_item_name,
9794: p_organization_id => p_original_rec.organization_id,
9795: p_seg_array => l_cont_item_seg,