DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_AUTOCREATE

Line 1688: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

1684: l_master_serial_number VARCHAR2(30);
1685: l_master_cont_id NUMBER;
1686: l_master_cont_name VARCHAR2(30);
1687:
1688: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1689: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1690: l_action_rec wsh_delivery_autocreate.action_rec_type;
1691: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1692: l_matched_entities wsh_util_core.id_tab_type;

Line 1689: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

1685: l_master_cont_id NUMBER;
1686: l_master_cont_name VARCHAR2(30);
1687:
1688: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1689: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1690: l_action_rec wsh_delivery_autocreate.action_rec_type;
1691: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1692: l_matched_entities wsh_util_core.id_tab_type;
1693: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 1690: l_action_rec wsh_delivery_autocreate.action_rec_type;

1686: l_master_cont_name VARCHAR2(30);
1687:
1688: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1689: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1690: l_action_rec wsh_delivery_autocreate.action_rec_type;
1691: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1692: l_matched_entities wsh_util_core.id_tab_type;
1693: l_out_rec wsh_delivery_autocreate.out_rec_type;
1694:

Line 1691: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

1687:
1688: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1689: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1690: l_action_rec wsh_delivery_autocreate.action_rec_type;
1691: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1692: l_matched_entities wsh_util_core.id_tab_type;
1693: l_out_rec wsh_delivery_autocreate.out_rec_type;
1694:
1695:

Line 1693: l_out_rec wsh_delivery_autocreate.out_rec_type;

1689: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1690: l_action_rec wsh_delivery_autocreate.action_rec_type;
1691: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1692: l_matched_entities wsh_util_core.id_tab_type;
1693: l_out_rec wsh_delivery_autocreate.out_rec_type;
1694:
1695:
1696:
1697: --

Line 1832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

1828: -- l_group_id_tab of type WSH_UTIL_CORE.id_tab_type;
1829:
1830: --
1831: IF l_debug_on THEN
1832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
1833: END IF;
1834: --
1835: l_action_rec.action := 'MATCH_GROUPS';
1836:

Line 1839: WSH_Delivery_AutoCreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,

1835: l_action_rec.action := 'MATCH_GROUPS';
1836:
1837:
1838:
1839: WSH_Delivery_AutoCreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,
1840: p_action_rec => l_action_rec,
1841: p_target_rec => l_target_rec,
1842: p_group_tab => l_group_tab,
1843: x_matched_entities => l_matched_entities,

Line 3680: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

3676: l_det_del_id NUMBER;
3677: l_par_del_id NUMBER;
3678: l_del_status VARCHAR2(10);
3679:
3680: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
3681: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3682: l_action_rec wsh_delivery_autocreate.action_rec_type;
3683: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3684: l_matched_entities wsh_util_core.id_tab_type;

Line 3681: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

3677: l_par_del_id NUMBER;
3678: l_del_status VARCHAR2(10);
3679:
3680: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
3681: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3682: l_action_rec wsh_delivery_autocreate.action_rec_type;
3683: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3684: l_matched_entities wsh_util_core.id_tab_type;
3685: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 3682: l_action_rec wsh_delivery_autocreate.action_rec_type;

3678: l_del_status VARCHAR2(10);
3679:
3680: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
3681: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3682: l_action_rec wsh_delivery_autocreate.action_rec_type;
3683: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3684: l_matched_entities wsh_util_core.id_tab_type;
3685: l_out_rec wsh_delivery_autocreate.out_rec_type;
3686:

Line 3683: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

3679:
3680: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
3681: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3682: l_action_rec wsh_delivery_autocreate.action_rec_type;
3683: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3684: l_matched_entities wsh_util_core.id_tab_type;
3685: l_out_rec wsh_delivery_autocreate.out_rec_type;
3686:
3687: --BUG#12904248

Line 3685: l_out_rec wsh_delivery_autocreate.out_rec_type;

3681: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3682: l_action_rec wsh_delivery_autocreate.action_rec_type;
3683: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3684: l_matched_entities wsh_util_core.id_tab_type;
3685: l_out_rec wsh_delivery_autocreate.out_rec_type;
3686:
3687: --BUG#12904248
3688: l_deliver_to_location_id NUMBER;
3689: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 4276: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

4272: l_attr_tab(2).entity_type := 'DELIVERY_DETAIL';
4273:
4274: --
4275: IF l_debug_on THEN
4276: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
4277: END IF;
4278:
4279: l_action_rec.action := 'MATCH_GROUPS';
4280: l_action_rec.check_single_grp := 'Y';

Line 4283: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,

4279: l_action_rec.action := 'MATCH_GROUPS';
4280: l_action_rec.check_single_grp := 'Y';
4281:
4282:
4283: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,
4284: p_action_rec => l_action_rec,
4285: p_target_rec => l_target_rec,
4286: p_group_tab => l_group_tab,
4287: x_matched_entities => l_matched_entities,

Line 6510: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

6506: l_item_changed BOOLEAN;
6507: l_cont_item_changed BOOLEAN;
6508: l_prev_item NUMBER;
6509:
6510: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
6511: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6512: l_action_rec wsh_delivery_autocreate.action_rec_type;
6513: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6514: l_matched_entities wsh_util_core.id_tab_type;

Line 6511: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

6507: l_cont_item_changed BOOLEAN;
6508: l_prev_item NUMBER;
6509:
6510: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
6511: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6512: l_action_rec wsh_delivery_autocreate.action_rec_type;
6513: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6514: l_matched_entities wsh_util_core.id_tab_type;
6515: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 6512: l_action_rec wsh_delivery_autocreate.action_rec_type;

6508: l_prev_item NUMBER;
6509:
6510: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
6511: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6512: l_action_rec wsh_delivery_autocreate.action_rec_type;
6513: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6514: l_matched_entities wsh_util_core.id_tab_type;
6515: l_out_rec wsh_delivery_autocreate.out_rec_type;
6516:

Line 6513: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

6509:
6510: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
6511: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6512: l_action_rec wsh_delivery_autocreate.action_rec_type;
6513: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6514: l_matched_entities wsh_util_core.id_tab_type;
6515: l_out_rec wsh_delivery_autocreate.out_rec_type;
6516:
6517: mark_reprice_error EXCEPTION;

Line 6515: l_out_rec wsh_delivery_autocreate.out_rec_type;

6511: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6512: l_action_rec wsh_delivery_autocreate.action_rec_type;
6513: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6514: l_matched_entities wsh_util_core.id_tab_type;
6515: l_out_rec wsh_delivery_autocreate.out_rec_type;
6516:
6517: mark_reprice_error EXCEPTION;
6518:
6519: -- OTM R12 : assign delivery detail

Line 6630: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');

6626:
6627: -- call autocreate delivery API with a check flag set to 'Y' and
6628: -- container flag set to 'Y' to fetch group id table for delivery lines
6629:
6630: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');
6631: --
6632: IF l_debug_on THEN
6633: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
6634: END IF;

Line 6633: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

6629:
6630: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');
6631: --
6632: IF l_debug_on THEN
6633: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
6634: END IF;
6635: --
6636:
6637: l_attr_tab.delete;

Line 6650: WSH_Delivery_AutoCreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,

6646: l_action_rec.action := 'MATCH_GROUPS';
6647:
6648:
6649:
6650: WSH_Delivery_AutoCreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,
6651: p_action_rec => l_action_rec,
6652: p_target_rec => l_target_rec,
6653: p_group_tab => l_group_tab,
6654: x_matched_entities => l_matched_entities,

Line 6663: --dbms_output.put_line('***WSH_DELIVERY_AUTOCREATE.autocreate_deliveries returned '||l_return_status);

6659: WSH_DEBUG_SV.log(l_module_name,'return status -',l_return_status);
6660: END IF;
6661: IF (l_return_status = C_ERROR_STATUS) OR
6662: (l_return_status = C_UNEXP_ERROR_STATUS) THEN
6663: --dbms_output.put_line('***WSH_DELIVERY_AUTOCREATE.autocreate_deliveries returned '||l_return_status);
6664: FND_MESSAGE.SET_NAME('WSH','WSH_GROUP_DETAILS_ERROR');
6665: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
6666: x_return_status := l_return_status;
6667: --

Line 11179: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

11175: l_cont_fill_pc NUMBER;
11176: l_cont_name VARCHAR2(30);
11177:
11178:
11179: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
11180: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11181: l_action_rec wsh_delivery_autocreate.action_rec_type;
11182: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11183: l_matched_entities wsh_util_core.id_tab_type;

Line 11180: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

11176: l_cont_name VARCHAR2(30);
11177:
11178:
11179: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
11180: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11181: l_action_rec wsh_delivery_autocreate.action_rec_type;
11182: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11183: l_matched_entities wsh_util_core.id_tab_type;
11184: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 11181: l_action_rec wsh_delivery_autocreate.action_rec_type;

11177:
11178:
11179: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
11180: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11181: l_action_rec wsh_delivery_autocreate.action_rec_type;
11182: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11183: l_matched_entities wsh_util_core.id_tab_type;
11184: l_out_rec wsh_delivery_autocreate.out_rec_type;
11185:

Line 11182: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

11178:
11179: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
11180: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11181: l_action_rec wsh_delivery_autocreate.action_rec_type;
11182: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11183: l_matched_entities wsh_util_core.id_tab_type;
11184: l_out_rec wsh_delivery_autocreate.out_rec_type;
11185:
11186:

Line 11184: l_out_rec wsh_delivery_autocreate.out_rec_type;

11180: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11181: l_action_rec wsh_delivery_autocreate.action_rec_type;
11182: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11183: l_matched_entities wsh_util_core.id_tab_type;
11184: l_out_rec wsh_delivery_autocreate.out_rec_type;
11185:
11186:
11187: i NUMBER;
11188: cnt NUMBER;

Line 11270: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');

11266:
11267: -- call autocreate delivery API with a check flag set to 'Y' and
11268: -- container flag set to 'Y' to fetch group id table for delivery lines
11269:
11270: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');
11271: --
11272: IF l_debug_on THEN
11273: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
11274: END IF;

Line 11273: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

11269:
11270: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');
11271: --
11272: IF l_debug_on THEN
11273: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
11274: END IF;
11275: --
11276: l_attr_tab.delete;
11277: FOR i in 1..p_cont_detail_tab.count LOOP

Line 11288: WSH_Delivery_AutoCreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,

11284: l_action_rec.action := 'MATCH_GROUPS';
11285:
11286:
11287:
11288: WSH_Delivery_AutoCreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,
11289: p_action_rec => l_action_rec,
11290: p_target_rec => l_target_rec,
11291: p_group_tab => l_group_tab,
11292: x_matched_entities => l_matched_entities,

Line 11303: --dbms_output.put_line('WSH_DELIVERY_AUTOCREATE.autocreate_deliveries returned '||l_return_status);

11299: WSH_DEBUG_SV.log(l_module_name,'return status', l_return_status);
11300: END IF;
11301: IF (l_return_status = C_ERROR_STATUS) OR
11302: (l_return_status = C_UNEXP_ERROR_STATUS) THEN
11303: --dbms_output.put_line('WSH_DELIVERY_AUTOCREATE.autocreate_deliveries returned '||l_return_status);
11304: FND_MESSAGE.SET_NAME('WSH','WSH_GROUP_DETAILS_ERROR');
11305: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
11306: x_return_status := l_return_status;
11307: --

Line 13681: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Autocreate.Autocreate_Consol_Delivery',WSH_DEBUG_SV.C_PROC_LEVEL);

13677: END LOOP;
13678:
13679:
13680: IF l_debug_on THEN
13681: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Autocreate.Autocreate_Consol_Delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
13682: END IF;
13683: WSH_Delivery_Autocreate.Autocreate_Consol_Delivery(
13684: p_del_attributes_tab => l_del_info_tab,
13685: p_caller => p_caller,

Line 13683: WSH_Delivery_Autocreate.Autocreate_Consol_Delivery(

13679:
13680: IF l_debug_on THEN
13681: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Autocreate.Autocreate_Consol_Delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
13682: END IF;
13683: WSH_Delivery_Autocreate.Autocreate_Consol_Delivery(
13684: p_del_attributes_tab => l_del_info_tab,
13685: p_caller => p_caller,
13686: x_parent_del_id => l_new_parent_delivery_id,
13687: x_parent_trip_id => l_trip_id,