DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WSH_UTIL_VALIDATE

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

1203: RAISE update_failed;
1204: END IF;
1205: CLOSE get_org;
1206:
1207: IF (wsh_util_validate.Check_Wms_Org(l_org)='Y') THEN
1208: l_detail_in_rec.caller := 'WMS';
1209: ELSE
1210: l_detail_in_rec.caller := 'WSH_GRP';
1211: END IF;

Line 5034: WSH_UTIL_VALIDATE.Validate_Org (l_organization_id,

5030: l_organization_code := p_detail_IN_rec.organization_code;
5031: --
5032: IF l_verify_org_level = 1 THEN --{
5033: --
5034: WSH_UTIL_VALIDATE.Validate_Org (l_organization_id,
5035: l_organization_code,
5036: l_return_status);
5037: IF l_return_status NOT IN ( wsh_util_core.g_ret_sts_success ,WSH_UTIL_CORE.G_RET_STS_WARNING)
5038: THEN

Line 5089: WSH_UTIL_VALIDATE.Validate_Item

5085: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
5086: RAISE e_NO_INV_ITEM;
5087: ELSE --}{
5088: --
5089: WSH_UTIL_VALIDATE.Validate_Item
5090: (p_inventory_item_id => l_cont_item_id,
5091: p_inventory_item => l_cont_item_name,
5092: p_organization_id => l_organization_id,
5093: p_seg_array => l_cont_item_seg,

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

5857: -- Validate Item and see if this is container item
5858: -- Error out if this is a container item
5859:
5860: IF l_debug_on THEN
5861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.FIND_ITEM_TYPE',WSH_DEBUG_SV.C_PROC_LEVEL);
5862: END IF;
5863:
5864: WSH_UTIL_VALIDATE.Find_Item_Type
5865: (

Line 5864: WSH_UTIL_VALIDATE.Find_Item_Type

5860: IF l_debug_on THEN
5861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.FIND_ITEM_TYPE',WSH_DEBUG_SV.C_PROC_LEVEL);
5862: END IF;
5863:
5864: WSH_UTIL_VALIDATE.Find_Item_Type
5865: (
5866: p_inventory_item_id => p_detail_info_tab(l_index).inventory_item_id,
5867: p_organization_id => p_detail_info_tab(l_index).organization_id,
5868: x_item_type => l_item_type,

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

6369: l_required_field := 'SHIP_FROM_LOCATION_ID';
6370: raise e_required_field_null;
6371: ELSE
6372: IF l_debug_on THEN
6373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
6374: END IF;
6375: wsh_util_validate.validate_location(
6376: p_location_id => x_detail_info_tab(l_index).ship_from_location_id,
6377: x_return_status => l_return_status,

Line 6375: wsh_util_validate.validate_location(

6371: ELSE
6372: IF l_debug_on THEN
6373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
6374: END IF;
6375: wsh_util_validate.validate_location(
6376: p_location_id => x_detail_info_tab(l_index).ship_from_location_id,
6377: x_return_status => l_return_status,
6378: p_isWshLocation => l_isWshLocation);
6379:

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

6389: l_required_field := 'SHIP_TO_LOCATION_ID';
6390: raise e_required_field_null;
6391: ELSE
6392: IF l_debug_on THEN
6393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
6394: END IF;
6395: wsh_util_validate.validate_location(
6396: p_location_id => x_detail_info_tab(l_index).ship_to_location_id,
6397: x_return_status => l_return_status,

Line 6395: wsh_util_validate.validate_location(

6391: ELSE
6392: IF l_debug_on THEN
6393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
6394: END IF;
6395: wsh_util_validate.validate_location(
6396: p_location_id => x_detail_info_tab(l_index).ship_to_location_id,
6397: x_return_status => l_return_status,
6398: p_isWshLocation => l_isWshLocation);
6399:

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

7564:
7565: IF (p_validation_tab(wsh_actions_levels.c_tol_above_lvl) = 1) THEN
7566: IF l_debug_on THEN
7567: WSH_DEBUG_SV.log(l_module_name, 'Ship Tolerance Above', x_detail_rec.ship_tolerance_above);
7568: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',
7569: WSH_DEBUG_SV.c_proc_level);
7570: END IF;
7571:
7572: --Bug # 3266333

Line 7573: wsh_util_validate.validate_negative(

7569: WSH_DEBUG_SV.c_proc_level);
7570: END IF;
7571:
7572: --Bug # 3266333
7573: wsh_util_validate.validate_negative(
7574: p_value => x_detail_rec.ship_tolerance_above,
7575: p_field_name => 'ship_tolerance_above',
7576: x_return_status => l_return_status );
7577: --

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

7586:
7587: IF (p_validation_tab(wsh_actions_levels.c_tol_below_lvl) = 1) THEN
7588: IF l_debug_on THEN
7589: WSH_DEBUG_SV.log(l_module_name, 'Ship Tolerance Below', x_detail_rec.ship_tolerance_below);
7590: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.c_proc_level);
7591: END IF;
7592:
7593: --Bug # 3266333
7594: wsh_util_validate.validate_negative(

Line 7594: wsh_util_validate.validate_negative(

7590: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.c_proc_level);
7591: END IF;
7592:
7593: --Bug # 3266333
7594: wsh_util_validate.validate_negative(
7595: p_value => x_detail_rec.ship_tolerance_below,
7596: p_field_name => 'ship_tolerance_below',
7597: x_return_status => l_return_status );
7598: --

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

7966: IF (p_validation_tab(wsh_actions_levels.c_smc_lvl) = 1) THEN
7967: IF (x_detail_rec.ship_method_code <> fnd_api.g_miss_char) THEN
7968: IF l_debug_on THEN
7969: WSH_DEBUG_SV.log(l_module_name, 'Ship Method', x_detail_rec.ship_method_code);
7970: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD', WSH_DEBUG_SV.c_proc_level);
7971: END IF;
7972:
7973: --
7974: wsh_util_validate.validate_ship_method(

Line 7974: wsh_util_validate.validate_ship_method(

7970: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD', WSH_DEBUG_SV.c_proc_level);
7971: END IF;
7972:
7973: --
7974: wsh_util_validate.validate_ship_method(
7975: p_ship_method_code => x_detail_rec.ship_method_code,
7976: p_ship_method_name => l_ship_method_name,
7977: x_return_status => l_return_status);
7978: --

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

7988: IF (p_validation_tab(wsh_actions_levels.c_dep_plan_lvl) = 1) THEN
7989: IF (x_detail_rec.dep_plan_required_flag <> fnd_api.g_miss_char) THEN
7990: IF l_debug_on THEN
7991: WSH_DEBUG_SV.log(l_module_name, 'Departure Plan Flag', x_detail_rec.dep_plan_required_flag);
7992: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
7993: END IF;
7994:
7995: --
7996: wsh_util_validate.validate_boolean(

Line 7996: wsh_util_validate.validate_boolean(

7992: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
7993: END IF;
7994:
7995: --
7996: wsh_util_validate.validate_boolean(
7997: p_flag => x_detail_rec.dep_plan_required_flag,
7998: x_return_status => l_return_status);
7999: --
8000: wsh_util_core.api_post_call(

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

8009: IF (p_validation_tab(wsh_actions_levels.c_ship_mod_comp_lvl) = 1) THEN
8010: IF (x_detail_rec.ship_model_complete_flag <> fnd_api.g_miss_char) THEN
8011: IF l_debug_on THEN
8012: WSH_DEBUG_SV.log(l_module_name, 'Ship Model Complete Flag', x_detail_rec.ship_model_complete_flag);
8013: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
8014: END IF;
8015:
8016: --
8017: wsh_util_validate.validate_boolean(

Line 8017: wsh_util_validate.validate_boolean(

8013: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
8014: END IF;
8015:
8016: --
8017: wsh_util_validate.validate_boolean(
8018: p_flag => x_detail_rec.ship_model_complete_flag,
8019: x_return_status => l_return_status);
8020: --
8021: wsh_util_core.api_post_call(

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

8277: IF (p_validation_tab(wsh_actions_levels.c_sold_contact_lvl) = 1) THEN
8278: IF (x_detail_rec.sold_to_contact_id <> fnd_api.g_miss_num) THEN
8279: IF l_debug_on THEN
8280: WSH_DEBUG_SV.log(l_module_name, 'Sold to Contact', x_detail_rec.sold_to_contact_id);
8281: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8282: END IF;
8283:
8284: --
8285: wsh_util_validate.validate_contact(

Line 8285: wsh_util_validate.validate_contact(

8281: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8282: END IF;
8283:
8284: --
8285: wsh_util_validate.validate_contact(
8286: p_contact_id => x_detail_rec.sold_to_contact_id,
8287: x_return_status => l_return_status);
8288: wsh_util_core.api_post_call(
8289: p_return_status => l_return_status,

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

8297: IF (p_validation_tab(wsh_actions_levels.c_ship_contact_lvl) = 1) THEN
8298: IF (x_detail_rec.ship_to_contact_id <> fnd_api.g_miss_num) THEN
8299: IF l_debug_on THEN
8300: WSH_DEBUG_SV.log(l_module_name, 'Ship to Contact Id', x_detail_rec.ship_to_contact_id);
8301: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8302: END IF;
8303:
8304: --
8305: wsh_util_validate.validate_contact(

Line 8305: wsh_util_validate.validate_contact(

8301: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8302: END IF;
8303:
8304: --
8305: wsh_util_validate.validate_contact(
8306: p_contact_id => x_detail_rec.ship_to_contact_id,
8307: x_return_status => l_return_status);
8308: --
8309: wsh_util_core.api_post_call(

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

8318: IF (p_validation_tab(wsh_actions_levels.c_deliver_contact_lvl) = 1) THEN
8319: IF (x_detail_rec.deliver_to_contact_id <> fnd_api.g_miss_num) THEN
8320: IF l_debug_on THEN
8321: WSH_DEBUG_SV.log(l_module_name, 'Deliver To Contact', x_detail_rec.deliver_to_contact_id);
8322: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8323: END IF;
8324:
8325: --
8326: wsh_util_validate.validate_contact(

Line 8326: wsh_util_validate.validate_contact(

8322: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8323: END IF;
8324:
8325: --
8326: wsh_util_validate.validate_contact(
8327: p_contact_id => x_detail_rec.deliver_to_contact_id,
8328: x_return_status => l_return_status);
8329: --
8330: wsh_util_core.api_post_call(

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

8339: IF (p_validation_tab(wsh_actions_levels.c_intmed_ship_contact_lvl) = 1) THEN
8340: IF (x_detail_rec.intmed_ship_to_contact_id <> fnd_api.g_miss_num) THEN
8341: IF l_debug_on THEN
8342: WSH_DEBUG_SV.log(l_module_name, 'Intmed Ship To Contact', x_detail_rec.intmed_ship_to_contact_id);
8343: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8344: END IF;
8345:
8346: --
8347: wsh_util_validate.validate_contact(

Line 8347: wsh_util_validate.validate_contact(

8343: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8344: END IF;
8345:
8346: --
8347: wsh_util_validate.validate_contact(
8348: p_contact_id => x_detail_rec.intmed_ship_to_contact_id,
8349: x_return_status => l_return_status);
8350: --
8351: wsh_util_core.api_post_call(

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

8507: --bug 4365589
8508: IF p_in_rec.caller = 'WSH_PUB'
8509: AND l_inv_controls.serial_code IN (2,5)
8510: THEN --{
8511: IF (wsh_util_validate.Check_Wms_Org(l_org_id)='Y') THEN --{
8512: IF l_debug_on THEN
8513: WSH_DEBUG_SV.logmsg(l_module_name, 'Cannot modify the serial numbers for WMS organizationx ');
8514: END IF;
8515:

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

9302: --
9303: IF l_debug_on THEN
9304: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item Id', x_detail_rec.inventory_item_id);
9305: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', x_detail_rec.organization_id);
9306: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9307: END IF;
9308: --
9309: WSH_UTIL_VALIDATE.Validate_Item(
9310: p_inventory_item_id => x_detail_rec.inventory_item_id,

Line 9309: WSH_UTIL_VALIDATE.Validate_Item(

9305: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', x_detail_rec.organization_id);
9306: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9307: END IF;
9308: --
9309: WSH_UTIL_VALIDATE.Validate_Item(
9310: p_inventory_item_id => x_detail_rec.inventory_item_id,
9311: p_inventory_item => l_cont_item_name,
9312: p_organization_id => p_original_rec.organization_id,
9313: p_seg_array => l_cont_item_seg,

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

9514:
9515: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_GROSS_WEIGHT_LVL) = 1 ) THEN
9516: IF l_debug_on THEN
9517: WSH_DEBUG_SV.log(l_module_name, 'Gross Weight', x_detail_rec.gross_weight);
9518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9519: END IF;
9520: --Bug # 3266333
9521: wsh_util_validate.validate_negative(
9522: p_value => x_detail_rec.gross_weight,

Line 9521: wsh_util_validate.validate_negative(

9517: WSH_DEBUG_SV.log(l_module_name, 'Gross Weight', x_detail_rec.gross_weight);
9518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9519: END IF;
9520: --Bug # 3266333
9521: wsh_util_validate.validate_negative(
9522: p_value => x_detail_rec.gross_weight,
9523: p_field_name => 'gross_weight',
9524: x_return_status => l_return_status );
9525: --

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

9536: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_NET_WEIGHT_LVL) = 1 ) THEN
9537: --
9538: IF l_debug_on THEN
9539: WSH_DEBUG_SV.log(l_module_name, 'Net Weight', x_detail_rec.net_weight);
9540: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9541: END IF;
9542: --Bug # 3266333
9543: wsh_util_validate.validate_negative(
9544: p_value => x_detail_rec.net_weight,

Line 9543: wsh_util_validate.validate_negative(

9539: WSH_DEBUG_SV.log(l_module_name, 'Net Weight', x_detail_rec.net_weight);
9540: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9541: END IF;
9542: --Bug # 3266333
9543: wsh_util_validate.validate_negative(
9544: p_value => x_detail_rec.net_weight,
9545: p_field_name => 'net_weight',
9546: x_return_status => l_return_status );
9547: --

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

9559: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_VOLUME_LVL) = 1 ) THEN
9560: --
9561: IF l_debug_on THEN
9562: WSH_DEBUG_SV.log(l_module_name, 'Volume', x_detail_rec.volume);
9563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9564: END IF;
9565: --Bug # 3266333
9566: wsh_util_validate.validate_negative(
9567: p_value => x_detail_rec.volume,

Line 9566: wsh_util_validate.validate_negative(

9562: WSH_DEBUG_SV.log(l_module_name, 'Volume', x_detail_rec.volume);
9563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_NEGATIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
9564: END IF;
9565: --Bug # 3266333
9566: wsh_util_validate.validate_negative(
9567: p_value => x_detail_rec.volume,
9568: p_field_name => 'volume',
9569: x_return_status => l_return_status );
9570: --

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

9638: IF x_detail_rec.master_container_item_id IS NOT NULL THEN
9639:
9640: IF l_debug_on THEN
9641: WSH_DEBUG_SV.log(l_module_name, 'Master cont item id', x_detail_rec.master_container_item_id);
9642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9643: END IF;
9644:
9645: WSH_UTIL_VALIDATE.Validate_Item(
9646: p_inventory_item_id => x_detail_rec.master_container_item_id,

Line 9645: WSH_UTIL_VALIDATE.Validate_Item(

9641: WSH_DEBUG_SV.log(l_module_name, 'Master cont item id', x_detail_rec.master_container_item_id);
9642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9643: END IF;
9644:
9645: WSH_UTIL_VALIDATE.Validate_Item(
9646: p_inventory_item_id => x_detail_rec.master_container_item_id,
9647: p_inventory_item => l_cont_item_name,
9648: p_organization_id => p_original_rec.organization_id,
9649: p_seg_array => l_cont_item_seg,

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

9664: IF x_detail_rec.detail_container_item_id IS NOT NULL THEN
9665:
9666: IF l_debug_on THEN
9667: WSH_DEBUG_SV.log(l_module_name, 'Detail cont item id', x_detail_rec.Detail_container_item_id);
9668: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9669: END IF;
9670:
9671: WSH_UTIL_VALIDATE.Validate_Item(
9672: p_inventory_item_id => x_detail_rec.detail_container_item_id,

Line 9671: WSH_UTIL_VALIDATE.Validate_Item(

9667: WSH_DEBUG_SV.log(l_module_name, 'Detail cont item id', x_detail_rec.Detail_container_item_id);
9668: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ITEM',WSH_DEBUG_SV.C_PROC_LEVEL);
9669: END IF;
9670:
9671: WSH_UTIL_VALIDATE.Validate_Item(
9672: p_inventory_item_id => x_detail_rec.detail_container_item_id,
9673: p_inventory_item => l_cont_item_name,
9674: p_organization_id => p_original_rec.organization_id,
9675: p_seg_array => l_cont_item_seg,