eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CONTAINER_PUB dependencies on WSH_UTIL_CORE

Line 56: x_container_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

52: p_quantity IN NUMBER,
53: p_container_name IN VARCHAR2,
54:
55: -- program specific out parameters
56: x_container_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
57: p_ucc_128_suffix_flag IN NUMBER
58: ) IS
59:
60:

Line 71: l_lpn_ids WSH_UTIL_CORE.Id_Tab_Type;

67: l_msg_details VARCHAR2(32000) := NULL;
68: l_detail_rec wsh_glbl_var_strct_grp.detailInRecType;
69: l_detail_tab wsh_glbl_var_strct_grp.delivery_details_attr_tbl_type;
70: l_out_rec wsh_glbl_var_strct_grp.detailOutRecType;
71: l_lpn_ids WSH_UTIL_CORE.Id_Tab_Type;
72:
73: --
74: l_num_errors NUMBER := 0;
75: l_num_warning NUMBER := 0;

Line 139: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

135: IF FND_API.to_boolean(p_init_msg_list) THEN
136: FND_MSG_PUB.initialize;
137: END IF;
138:
139: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
140:
141: -- validate quantity
142:
143: IF p_quantity <= 0 THEN

Line 177: wsh_util_core.api_post_call(

173: p_IN_rec => l_detail_rec,
174: x_OUT_rec => l_out_rec);
175:
176:
177: wsh_util_core.api_post_call(
178: p_return_status =>x_return_status,
179: x_num_warnings =>l_num_warning,
180: x_num_errors =>l_num_errors,
181: p_msg_data =>x_msg_data,

Line 184: IF x_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.G_RET_STS_UNEXP_ERROR ) THEN

180: x_num_errors =>l_num_errors,
181: p_msg_data =>x_msg_data,
182: p_raise_error_flag => FALSE);
183:
184: IF x_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.G_RET_STS_UNEXP_ERROR ) THEN
185: raise WSH_FAIL_CONT_CREATION;
186: END IF;
187:
188: IF l_out_rec.detail_ids.COUNT > 0 THEN

Line 214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

210: EXCEPTION
211:
212: WHEN WSH_INVALID_QTY then
213: rollback to Create_Containers_SP;
214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
215: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_QTY');
216: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
217: --
218: FND_MSG_PUB.Count_And_Get

Line 216: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

212: WHEN WSH_INVALID_QTY then
213: rollback to Create_Containers_SP;
214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
215: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_QTY');
216: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
217: --
218: FND_MSG_PUB.Count_And_Get
219: (
220: p_count => x_msg_count,

Line 231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

227: END IF;
228:
229: WHEN WSH_FAIL_CONT_CREATION then
230: rollback to Create_Containers_SP;
231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
232: fnd_message.set_name('WSH', 'WSH_CONT_CREATE_ERROR');
233: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
234: --
235: FND_MSG_PUB.Count_And_Get

Line 233: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

229: WHEN WSH_FAIL_CONT_CREATION then
230: rollback to Create_Containers_SP;
231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
232: fnd_message.set_name('WSH', 'WSH_CONT_CREATE_ERROR');
233: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
234: --
235: FND_MSG_PUB.Count_And_Get
236: (
237: p_count => x_msg_count,

Line 249: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Create_Containers',l_module_name);

245: END IF;
246:
247: WHEN OTHERS then
248: rollback to Create_Containers_SP;
249: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Create_Containers',l_module_name);
250: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
251:
252: --
253: FND_MSG_PUB.Count_And_Get

Line 250: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

246:
247: WHEN OTHERS then
248: rollback to Create_Containers_SP;
249: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Create_Containers',l_module_name);
250: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
251:
252: --
253: FND_MSG_PUB.Count_And_Get
254: (

Line 469: wsh_util_core.default_handler('WSH_CONTAINER_PUB.populate_record',l_module_name) ;

465:
466: EXCEPTION
467:
468: WHEN OTHERS THEN
469: wsh_util_core.default_handler('WSH_CONTAINER_PUB.populate_record',l_module_name) ;
470: IF l_debug_on THEN
471: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
473:

Line 522: l_lpn_ids WSH_UTIL_CORE.Id_Tab_Type;

518: l_detail_rec wsh_glbl_var_strct_grp.detailInRecType;
519: l_detail_info_tab wsh_glbl_var_strct_grp.delivery_details_attr_tbl_type;
520: l_detail_info_rec wsh_glbl_var_strct_grp.Delivery_Details_Rec_Type;
521: l_out_rec wsh_glbl_var_strct_grp.detailOutRecType;
522: l_lpn_ids WSH_UTIL_CORE.Id_Tab_Type;
523:
524: --
525: l_num_errors NUMBER := 0;
526: l_num_warning NUMBER := 0;

Line 574: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

570: IF FND_API.to_boolean(p_init_msg_list) THEN
571: FND_MSG_PUB.initialize;
572: END IF;
573:
574: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
575:
576: -- check to make sure that the container record being input for update
577: -- does not have null delivery detail ids or container name or the
578: -- container flag is null or 'N'

Line 602: wsh_util_core.api_post_call(

598: p_detail_info_tab => l_detail_info_tab,
599: p_IN_rec => l_detail_rec,
600: x_OUT_rec => l_out_rec);
601:
602: wsh_util_core.api_post_call(
603: p_return_status =>x_return_status,
604: x_num_warnings =>l_num_warning,
605: x_num_errors =>l_num_errors,
606: p_msg_data =>x_msg_data,

Line 609: IF x_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.G_RET_STS_UNEXP_ERROR ) THEN

605: x_num_errors =>l_num_errors,
606: p_msg_data =>x_msg_data,
607: p_raise_error_flag => FALSE);
608:
609: IF x_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.G_RET_STS_UNEXP_ERROR ) THEN
610: raise WSH_FAIL_CONT_UPDATE;
611: END IF;
612:
613: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 637: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

633: EXCEPTION
634:
635: WHEN WSH_INVALID_CONT_UPDATE then
636: rollback to Update_Containers_SP;
637: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
638: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_UPDATE');
639: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
640: --
641: FND_MSG_PUB.Count_And_Get

Line 639: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

635: WHEN WSH_INVALID_CONT_UPDATE then
636: rollback to Update_Containers_SP;
637: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
638: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_UPDATE');
639: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
640: --
641: FND_MSG_PUB.Count_And_Get
642: (
643: p_count => x_msg_count,

Line 655: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

651: END IF;
652:
653: WHEN WSH_FAIL_CONT_UPDATE then
654: rollback to Update_Containers_SP;
655: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
656: fnd_message.set_name('WSH', 'WSH_CONT_UPDATE_ERROR');
657: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
658: --
659: FND_MSG_PUB.Count_And_Get

Line 657: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

653: WHEN WSH_FAIL_CONT_UPDATE then
654: rollback to Update_Containers_SP;
655: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
656: fnd_message.set_name('WSH', 'WSH_CONT_UPDATE_ERROR');
657: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
658: --
659: FND_MSG_PUB.Count_And_Get
660: (
661: p_count => x_msg_count,

Line 672: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Update_Container',l_module_name);

668: END IF;
669:
670: WHEN OTHERS then
671: rollback to Update_Containers_SP;
672: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Update_Container',l_module_name);
673: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
674: --
675: FND_MSG_PUB.Count_And_Get
676: (

Line 673: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

669:
670: WHEN OTHERS then
671: rollback to Update_Containers_SP;
672: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Update_Container',l_module_name);
673: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
674: --
675: FND_MSG_PUB.Count_And_Get
676: (
677: p_count => x_msg_count,

Line 735: p_entity_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,

731: x_msg_count OUT NOCOPY NUMBER,
732: x_msg_data OUT NOCOPY VARCHAR2,
733:
734: -- program specific parameters
735: p_entity_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
736: p_entity_type IN VARCHAR2,
737: p_group_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
738: p_pack_cont_flag IN VARCHAR2,
739:

Line 737: p_group_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,

733:
734: -- program specific parameters
735: p_entity_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
736: p_entity_type IN VARCHAR2,
737: p_group_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
738: p_pack_cont_flag IN VARCHAR2,
739:
740: -- program specific out parameters
741: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE

Line 741: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE

737: p_group_id_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
738: p_pack_cont_flag IN VARCHAR2,
739:
740: -- program specific out parameters
741: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
742:
743: ) IS
744:
745: -- Standard call to check for call compatibility

Line 749: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

745: -- Standard call to check for call compatibility
746: l_api_version CONSTANT NUMBER := 1.0;
747: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
748:
749: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
750:
751: l_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE;
752:
753: l_det_cnt NUMBER := 0;

Line 751: l_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE;

747: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
748:
749: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
750:
751: l_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE;
752:
753: l_det_cnt NUMBER := 0;
754: l_count NUMBER;
755:

Line 815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

811: IF FND_API.to_boolean(p_init_msg_list) THEN
812: FND_MSG_PUB.initialize;
813: END IF;
814:
815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
816:
817: -- first decide which entity it is by checking entity type..
818: -- based on entity type validate all the entity ids..
819:

Line 827: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

823: IF p_entity_tab(i) IS NOT NULL THEN
824: l_det_cnt := l_det_cnt + 1;
825: l_entity_tab(l_det_cnt) := p_entity_tab(i);
826: ELSE
827: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
828: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
829: --bms what is the use of this l_return_status?
830: END IF;
831: END IF;

Line 828: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

824: l_det_cnt := l_det_cnt + 1;
825: l_entity_tab(l_det_cnt) := p_entity_tab(i);
826: ELSE
827: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
828: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
829: --bms what is the use of this l_return_status?
830: END IF;
831: END IF;
832:

Line 857: wsh_util_core.api_post_call(

853: p_detail_id_tab =>l_entity_tab,
854: p_action_prms =>l_action_prms,
855: x_action_out_rec => l_action_out_rec);
856:
857: wsh_util_core.api_post_call(
858: p_return_status =>x_return_status,
859: x_num_warnings =>l_num_warning,
860: x_num_errors =>l_num_errors,
861: p_msg_data =>x_msg_data,

Line 864: IF x_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.G_RET_STS_UNEXP_ERROR ) THEN

860: x_num_errors =>l_num_errors,
861: p_msg_data =>x_msg_data,
862: p_raise_error_flag => FALSE);
863:
864: IF x_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.G_RET_STS_UNEXP_ERROR ) THEN
865: raise WSH_FAIL_AUTOPACK;
866: END IF;
867:
868: x_cont_inst_tab := l_action_out_rec.result_id_tab;

Line 897: wsh_util_core.api_post_call(

893: x_msg_count => x_msg_count,
894: x_msg_data => x_msg_data
895: );
896:
897: wsh_util_core.api_post_call(
898: p_return_status =>x_return_status,
899: x_num_warnings =>l_num_warning,
900: x_num_errors =>l_num_errors,
901: p_msg_data =>x_msg_data,

Line 904: IF x_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.G_RET_STS_UNEXP_ERROR ) THEN

900: x_num_errors =>l_num_errors,
901: p_msg_data =>x_msg_data,
902: p_raise_error_flag => FALSE);
903:
904: IF x_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.G_RET_STS_UNEXP_ERROR ) THEN
905: raise WSH_FAIL_AUTOPACK;
906: END IF;
907:
908: x_cont_inst_tab := l_delivery_out_rec.result_id_tab;

Line 937: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

933: EXCEPTION
934:
935: WHEN WSH_INVALID_DETAIL then
936: rollback to Autopack_SP;
937: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
938: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
939: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
940: --
941: FND_MSG_PUB.Count_And_Get

Line 939: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

935: WHEN WSH_INVALID_DETAIL then
936: rollback to Autopack_SP;
937: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
938: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
939: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
940: --
941: FND_MSG_PUB.Count_And_Get
942: (
943: p_count => x_msg_count,

Line 954: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

950: END IF;
951:
952: WHEN WSH_INVALID_DELIVERY then
953: rollback to Autopack_SP;
954: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
955: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
956: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
957: --
958: FND_MSG_PUB.Count_And_Get

Line 956: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

952: WHEN WSH_INVALID_DELIVERY then
953: rollback to Autopack_SP;
954: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
955: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DEL');
956: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
957: --
958: FND_MSG_PUB.Count_And_Get
959: (
960: p_count => x_msg_count,

Line 971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');
968: END IF;
969: WHEN WSH_FAIL_AUTOPACK then
970: rollback to Autopack_SP;
971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
972: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
973: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
974: --
975: FND_MSG_PUB.Count_And_Get

Line 973: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

969: WHEN WSH_FAIL_AUTOPACK then
970: rollback to Autopack_SP;
971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
972: fnd_message.set_name('WSH', 'WSH_AUTOPACK_ERROR');
973: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
974: --
975: FND_MSG_PUB.Count_And_Get
976: (
977: p_count => x_msg_count,

Line 988: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

984: END IF;
985:
986: WHEN WSH_INVALID_ENTITY_TYPE then
987: rollback to Autopack_SP;
988: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
989: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
990: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
991: --
992: FND_MSG_PUB.Count_And_Get

Line 990: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

986: WHEN WSH_INVALID_ENTITY_TYPE then
987: rollback to Autopack_SP;
988: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
989: fnd_message.set_name('WSH', 'WSH_PUB_CONT_TYPE_ERR');
990: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
991: --
992: FND_MSG_PUB.Count_And_Get
993: (
994: p_count => x_msg_count,

Line 1005: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Auto_Pack',l_module_name);

1001: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
1002: END IF;
1003: WHEN OTHERS then
1004: rollback to Autopack_SP;
1005: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Auto_Pack',l_module_name);
1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1007:
1008: --
1009: FND_MSG_PUB.Count_And_Get

Line 1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1002: END IF;
1003: WHEN OTHERS then
1004: rollback to Autopack_SP;
1005: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Auto_Pack',l_module_name);
1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1007:
1008: --
1009: FND_MSG_PUB.Count_And_Get
1010: (

Line 1064: p_detail_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,

1060: x_msg_count OUT NOCOPY NUMBER,
1061: x_msg_data OUT NOCOPY VARCHAR2,
1062:
1063: -- program specific parameters
1064: p_detail_tab IN WSH_UTIL_CORE.ID_TAB_TYPE,
1065: p_container_name IN VARCHAR2 DEFAULT NULL,
1066: p_cont_instance_id IN NUMBER DEFAULT NULL,
1067: p_container_flag IN VARCHAR2 DEFAULT 'N',
1068: p_delivery_flag IN VARCHAR2 DEFAULT 'N',

Line 1087: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1083: l_num_errors NUMBER := 0;
1084: l_num_warning NUMBER := 0;
1085: l_action_out_rec wsh_glbl_var_strct_grp.dd_action_out_rec_type;
1086:
1087: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1088: l_debug_on BOOLEAN;
1089: --
1090: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' ||
1091: 'Container_Actions';

Line 1138: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1134: IF FND_API.to_boolean(p_init_msg_list) THEN
1135: FND_MSG_PUB.initialize;
1136: END IF;
1137:
1138: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1139:
1140: -- first decide which action to perform by checking action type..
1141: -- based on entity type validate all the entity ids..
1142:

Line 1170: wsh_util_core.api_post_call(p_return_status =>l_return_status,

1166: x_action_out_rec => l_action_out_rec);
1167:
1168:
1169:
1170: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1171: x_num_warnings =>l_num_warning,
1172: x_num_errors =>l_num_errors);
1173:
1174: x_return_status := l_return_status;

Line 1197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1193: EXCEPTION
1194:
1195: WHEN WSH_INVALID_DETAIL then
1196: rollback to Container_Action_SP;
1197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1198: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1199: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1200: --
1201: FND_MSG_PUB.Count_And_Get

Line 1199: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);

1195: WHEN WSH_INVALID_DETAIL then
1196: rollback to Container_Action_SP;
1197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1198: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1199: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1200: --
1201: FND_MSG_PUB.Count_And_Get
1202: (
1203: p_count => x_msg_count,

Line 1216: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1212: END IF;
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: rollback to Container_Action_SP;
1216: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1217:
1218: --
1219: FND_MSG_PUB.Count_And_Get
1220: (

Line 1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1232:
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235: rollback to Container_Action_SP;
1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1237: --
1238: FND_MSG_PUB.Count_And_Get
1239: (
1240: p_count => x_msg_count,

Line 1250: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

1246: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');
1247: WSH_DEBUG_SV.pop(l_module_name);
1248: END IF;
1249:
1250: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1251: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1252: --
1253: FND_MSG_PUB.Count_And_Get
1254: (

Line 1251: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1247: WSH_DEBUG_SV.pop(l_module_name);
1248: END IF;
1249:
1250: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1251: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1252: --
1253: FND_MSG_PUB.Count_And_Get
1254: (
1255: p_count => x_msg_count,

Line 1268: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Container_Actions');

1264: END IF;
1265:
1266: WHEN OTHERS then
1267: rollback to Container_Action_SP;
1268: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Container_Actions');
1269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1270: --
1271: FND_MSG_PUB.Count_And_Get
1272: (

Line 1269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1265:
1266: WHEN OTHERS then
1267: rollback to Container_Action_SP;
1268: wsh_util_core.default_handler('WSH_CONTAINER_PUB.Container_Actions');
1269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1270: --
1271: FND_MSG_PUB.Count_And_Get
1272: (
1273: p_count => x_msg_count,