DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_DELIVERY_AUTOCREATE

Line 1661: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

1657: l_master_serial_number VARCHAR2(30);
1658: l_master_cont_id NUMBER;
1659: l_master_cont_name VARCHAR2(30);
1660:
1661: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1662: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1663: l_action_rec wsh_delivery_autocreate.action_rec_type;
1664: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1665: l_matched_entities wsh_util_core.id_tab_type;

Line 1662: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

1658: l_master_cont_id NUMBER;
1659: l_master_cont_name VARCHAR2(30);
1660:
1661: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1662: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1663: l_action_rec wsh_delivery_autocreate.action_rec_type;
1664: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1665: l_matched_entities wsh_util_core.id_tab_type;
1666: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 1663: l_action_rec wsh_delivery_autocreate.action_rec_type;

1659: l_master_cont_name VARCHAR2(30);
1660:
1661: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1662: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1663: l_action_rec wsh_delivery_autocreate.action_rec_type;
1664: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1665: l_matched_entities wsh_util_core.id_tab_type;
1666: l_out_rec wsh_delivery_autocreate.out_rec_type;
1667:

Line 1664: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

1660:
1661: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
1662: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1663: l_action_rec wsh_delivery_autocreate.action_rec_type;
1664: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1665: l_matched_entities wsh_util_core.id_tab_type;
1666: l_out_rec wsh_delivery_autocreate.out_rec_type;
1667:
1668:

Line 1666: l_out_rec wsh_delivery_autocreate.out_rec_type;

1662: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
1663: l_action_rec wsh_delivery_autocreate.action_rec_type;
1664: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
1665: l_matched_entities wsh_util_core.id_tab_type;
1666: l_out_rec wsh_delivery_autocreate.out_rec_type;
1667:
1668:
1669:
1670: --

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

1801: -- l_group_id_tab of type WSH_UTIL_CORE.id_tab_type;
1802:
1803: --
1804: IF l_debug_on THEN
1805: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
1806: END IF;
1807: --
1808: l_action_rec.action := 'MATCH_GROUPS';
1809:

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

1808: l_action_rec.action := 'MATCH_GROUPS';
1809:
1810:
1811:
1812: WSH_Delivery_AutoCreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,
1813: p_action_rec => l_action_rec,
1814: p_target_rec => l_target_rec,
1815: p_group_tab => l_group_tab,
1816: x_matched_entities => l_matched_entities,

Line 3626: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

3622: l_det_del_id NUMBER;
3623: l_par_del_id NUMBER;
3624: l_del_status VARCHAR2(10);
3625:
3626: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
3627: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3628: l_action_rec wsh_delivery_autocreate.action_rec_type;
3629: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3630: l_matched_entities wsh_util_core.id_tab_type;

Line 3627: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

3623: l_par_del_id NUMBER;
3624: l_del_status VARCHAR2(10);
3625:
3626: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
3627: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3628: l_action_rec wsh_delivery_autocreate.action_rec_type;
3629: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3630: l_matched_entities wsh_util_core.id_tab_type;
3631: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 3628: l_action_rec wsh_delivery_autocreate.action_rec_type;

3624: l_del_status VARCHAR2(10);
3625:
3626: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
3627: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3628: l_action_rec wsh_delivery_autocreate.action_rec_type;
3629: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3630: l_matched_entities wsh_util_core.id_tab_type;
3631: l_out_rec wsh_delivery_autocreate.out_rec_type;
3632:

Line 3629: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

3625:
3626: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
3627: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3628: l_action_rec wsh_delivery_autocreate.action_rec_type;
3629: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3630: l_matched_entities wsh_util_core.id_tab_type;
3631: l_out_rec wsh_delivery_autocreate.out_rec_type;
3632:
3633:

Line 3631: l_out_rec wsh_delivery_autocreate.out_rec_type;

3627: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
3628: l_action_rec wsh_delivery_autocreate.action_rec_type;
3629: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
3630: l_matched_entities wsh_util_core.id_tab_type;
3631: l_out_rec wsh_delivery_autocreate.out_rec_type;
3632:
3633:
3634: --
3635: l_debug_on BOOLEAN;

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

4214: l_attr_tab(2).entity_type := 'DELIVERY_DETAIL';
4215:
4216: --
4217: IF l_debug_on THEN
4218: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
4219: END IF;
4220:
4221: l_action_rec.action := 'MATCH_GROUPS';
4222: l_action_rec.check_single_grp := 'Y';

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

4221: l_action_rec.action := 'MATCH_GROUPS';
4222: l_action_rec.check_single_grp := 'Y';
4223:
4224:
4225: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,
4226: p_action_rec => l_action_rec,
4227: p_target_rec => l_target_rec,
4228: p_group_tab => l_group_tab,
4229: x_matched_entities => l_matched_entities,

Line 6434: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

6430: l_item_changed BOOLEAN;
6431: l_cont_item_changed BOOLEAN;
6432: l_prev_item NUMBER;
6433:
6434: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
6435: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6436: l_action_rec wsh_delivery_autocreate.action_rec_type;
6437: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6438: l_matched_entities wsh_util_core.id_tab_type;

Line 6435: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

6431: l_cont_item_changed BOOLEAN;
6432: l_prev_item NUMBER;
6433:
6434: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
6435: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6436: l_action_rec wsh_delivery_autocreate.action_rec_type;
6437: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6438: l_matched_entities wsh_util_core.id_tab_type;
6439: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 6436: l_action_rec wsh_delivery_autocreate.action_rec_type;

6432: l_prev_item NUMBER;
6433:
6434: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
6435: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6436: l_action_rec wsh_delivery_autocreate.action_rec_type;
6437: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6438: l_matched_entities wsh_util_core.id_tab_type;
6439: l_out_rec wsh_delivery_autocreate.out_rec_type;
6440:

Line 6437: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

6433:
6434: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
6435: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6436: l_action_rec wsh_delivery_autocreate.action_rec_type;
6437: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6438: l_matched_entities wsh_util_core.id_tab_type;
6439: l_out_rec wsh_delivery_autocreate.out_rec_type;
6440:
6441: mark_reprice_error EXCEPTION;

Line 6439: l_out_rec wsh_delivery_autocreate.out_rec_type;

6435: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
6436: l_action_rec wsh_delivery_autocreate.action_rec_type;
6437: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
6438: l_matched_entities wsh_util_core.id_tab_type;
6439: l_out_rec wsh_delivery_autocreate.out_rec_type;
6440:
6441: mark_reprice_error EXCEPTION;
6442:
6443: -- OTM R12 : assign delivery detail

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

6540:
6541: -- call autocreate delivery API with a check flag set to 'Y' and
6542: -- container flag set to 'Y' to fetch group id table for delivery lines
6543:
6544: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');
6545: --
6546: IF l_debug_on THEN
6547: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
6548: END IF;

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

6543:
6544: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');
6545: --
6546: IF l_debug_on THEN
6547: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
6548: END IF;
6549: --
6550:
6551: l_attr_tab.delete;

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

6560: l_action_rec.action := 'MATCH_GROUPS';
6561:
6562:
6563:
6564: WSH_Delivery_AutoCreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,
6565: p_action_rec => l_action_rec,
6566: p_target_rec => l_target_rec,
6567: p_group_tab => l_group_tab,
6568: x_matched_entities => l_matched_entities,

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

6573: WSH_DEBUG_SV.log(l_module_name,'return status -',l_return_status);
6574: END IF;
6575: IF (l_return_status = C_ERROR_STATUS) OR
6576: (l_return_status = C_UNEXP_ERROR_STATUS) THEN
6577: --dbms_output.put_line('***WSH_DELIVERY_AUTOCREATE.autocreate_deliveries returned '||l_return_status);
6578: FND_MESSAGE.SET_NAME('WSH','WSH_GROUP_DETAILS_ERROR');
6579: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
6580: x_return_status := l_return_status;
6581: --

Line 11050: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

11046: l_cont_fill_pc NUMBER;
11047: l_cont_name VARCHAR2(30);
11048:
11049:
11050: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
11051: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11052: l_action_rec wsh_delivery_autocreate.action_rec_type;
11053: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11054: l_matched_entities wsh_util_core.id_tab_type;

Line 11051: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

11047: l_cont_name VARCHAR2(30);
11048:
11049:
11050: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
11051: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11052: l_action_rec wsh_delivery_autocreate.action_rec_type;
11053: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11054: l_matched_entities wsh_util_core.id_tab_type;
11055: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 11052: l_action_rec wsh_delivery_autocreate.action_rec_type;

11048:
11049:
11050: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
11051: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11052: l_action_rec wsh_delivery_autocreate.action_rec_type;
11053: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11054: l_matched_entities wsh_util_core.id_tab_type;
11055: l_out_rec wsh_delivery_autocreate.out_rec_type;
11056:

Line 11053: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

11049:
11050: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
11051: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11052: l_action_rec wsh_delivery_autocreate.action_rec_type;
11053: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11054: l_matched_entities wsh_util_core.id_tab_type;
11055: l_out_rec wsh_delivery_autocreate.out_rec_type;
11056:
11057:

Line 11055: l_out_rec wsh_delivery_autocreate.out_rec_type;

11051: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
11052: l_action_rec wsh_delivery_autocreate.action_rec_type;
11053: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
11054: l_matched_entities wsh_util_core.id_tab_type;
11055: l_out_rec wsh_delivery_autocreate.out_rec_type;
11056:
11057:
11058: i NUMBER;
11059: cnt NUMBER;

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

11137:
11138: -- call autocreate delivery API with a check flag set to 'Y' and
11139: -- container flag set to 'Y' to fetch group id table for delivery lines
11140:
11141: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');
11142: --
11143: IF l_debug_on THEN
11144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
11145: END IF;

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

11140:
11141: --dbms_output.put_line('Calling WSH_DELIVERY_AUTOCREATE.autocreate_deliveries to generate group_ids');
11142: --
11143: IF l_debug_on THEN
11144: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
11145: END IF;
11146: --
11147: l_attr_tab.delete;
11148: FOR i in 1..p_cont_detail_tab.count LOOP

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

11155: l_action_rec.action := 'MATCH_GROUPS';
11156:
11157:
11158:
11159: WSH_Delivery_AutoCreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,
11160: p_action_rec => l_action_rec,
11161: p_target_rec => l_target_rec,
11162: p_group_tab => l_group_tab,
11163: x_matched_entities => l_matched_entities,

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

11170: WSH_DEBUG_SV.log(l_module_name,'return status', l_return_status);
11171: END IF;
11172: IF (l_return_status = C_ERROR_STATUS) OR
11173: (l_return_status = C_UNEXP_ERROR_STATUS) THEN
11174: --dbms_output.put_line('WSH_DELIVERY_AUTOCREATE.autocreate_deliveries returned '||l_return_status);
11175: FND_MESSAGE.SET_NAME('WSH','WSH_GROUP_DETAILS_ERROR');
11176: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
11177: x_return_status := l_return_status;
11178: --

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

13527: END LOOP;
13528:
13529:
13530: IF l_debug_on THEN
13531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Autocreate.Autocreate_Consol_Delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
13532: END IF;
13533: WSH_Delivery_Autocreate.Autocreate_Consol_Delivery(
13534: p_del_attributes_tab => l_del_info_tab,
13535: p_caller => p_caller,

Line 13533: WSH_Delivery_Autocreate.Autocreate_Consol_Delivery(

13529:
13530: IF l_debug_on THEN
13531: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_Delivery_Autocreate.Autocreate_Consol_Delivery',WSH_DEBUG_SV.C_PROC_LEVEL);
13532: END IF;
13533: WSH_Delivery_Autocreate.Autocreate_Consol_Delivery(
13534: p_del_attributes_tab => l_del_info_tab,
13535: p_caller => p_caller,
13536: x_parent_del_id => l_new_parent_delivery_id,
13537: x_parent_trip_id => l_trip_id,