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_DELIVERY_DETAILS_PUB dependencies on WSH_UTIL_CORE

Line 57: l_TabOfDelDets WSH_UTIL_CORE.ID_TAB_TYPE;

53:
54: l_return_status VARCHAR2(30) := NULL;
55: l_delivery_id number := NULL;
56: l_cont_ins_id number := NULL;
57: l_TabOfDelDets WSH_UTIL_CORE.ID_TAB_TYPE;
58: l_msg_summary varchar2(2000) := NULL;
59: l_msg_details varchar2(4000) := NULL;
60:
61: -- Harmonization Project

Line 66: l_dummy_ids wsh_util_core.id_tab_type;

62: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
63: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
64: l_dummy_qty NUMBER;
65: l_dummy_qty2 NUMBER;
66: l_dummy_ids wsh_util_core.id_tab_type;
67:
68: l_msg_count NUMBER;
69: l_msg_data VARCHAR2(32767);
70: l_number_of_errors NUMBER := 0;

Line 118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

114: IF FND_API.to_boolean(p_init_msg_list) THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
119:
120: if (p_TabOfDelDets.count = 0) then
121: raise WSH_NO_DEL_DET_TBL;
122: end if;

Line 156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

152: p_action_prms => l_action_prms ,
153: x_action_out_rec => l_action_out_rec);
154:
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
157: END IF;
158: --
159: wsh_util_core.api_post_call(
160: p_return_status => l_return_status,

Line 159: wsh_util_core.api_post_call(

155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
157: END IF;
158: --
159: wsh_util_core.api_post_call(
160: p_return_status => l_return_status,
161: x_num_warnings => l_number_of_warnings,
162: x_num_errors => l_number_of_errors,
163: p_msg_data => l_msg_data

Line 167: x_return_status := wsh_util_core.g_ret_sts_warning;

163: p_msg_data => l_msg_data
164: );
165:
166: IF l_number_of_warnings > 0 THEN
167: x_return_status := wsh_util_core.g_ret_sts_warning;
168: END IF;
169:
170:
171: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 191: wsh_util_core.add_message(x_return_status);

187: exception
188: WHEN FND_API.G_EXC_ERROR THEN
189: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
190: x_return_status := FND_API.G_RET_STS_ERROR ;
191: wsh_util_core.add_message(x_return_status);
192: FND_MSG_PUB.Count_And_Get
193: (
194: p_count => x_msg_count,
195: p_data => x_msg_data,

Line 206: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

202: END IF;
203: --
204: WHEN WSH_NO_DEL_DET_TBL then
205: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
207: fnd_message.set_name('WSH', 'WSH_PUB_NO_DEL_DET_TBL');
208: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
209: FND_MSG_PUB.Count_And_Get
210: (

Line 208: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

204: WHEN WSH_NO_DEL_DET_TBL then
205: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
207: fnd_message.set_name('WSH', 'WSH_PUB_NO_DEL_DET_TBL');
208: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
209: FND_MSG_PUB.Count_And_Get
210: (
211: p_count => x_msg_count,
212: p_data => x_msg_data,

Line 224: wsh_util_core.add_message(x_return_status, l_module_name);

220: --
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: wsh_util_core.add_message(x_return_status, l_module_name);
225: FND_MSG_PUB.Count_And_Get
226: (
227: p_count => x_msg_count,
228: p_data => x_msg_data,

Line 239: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY');

235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
236: END IF;
237: WHEN others then
238: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
239: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY');
240: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_And_Get
242: (
243: p_count => x_msg_count,

Line 240: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

236: END IF;
237: WHEN others then
238: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
239: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY');
240: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_And_Get
242: (
243: p_count => x_msg_count,
244: p_data => x_msg_data,

Line 292: l_dummy_ids wsh_util_core.id_tab_type;

288: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
289: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
290: l_dummy_qty NUMBER;
291: l_dummy_qty2 NUMBER;
292: l_dummy_ids wsh_util_core.id_tab_type;
293: l_detail_ids wsh_util_core.id_tab_type;
294: l_msg_count NUMBER;
295: l_msg_data VARCHAR2(32767);
296: l_number_of_errors NUMBER := 0;

Line 293: l_detail_ids wsh_util_core.id_tab_type;

289: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
290: l_dummy_qty NUMBER;
291: l_dummy_qty2 NUMBER;
292: l_dummy_ids wsh_util_core.id_tab_type;
293: l_detail_ids wsh_util_core.id_tab_type;
294: l_msg_count NUMBER;
295: l_msg_data VARCHAR2(32767);
296: l_number_of_errors NUMBER := 0;
297: l_number_of_warnings NUMBER := 0;

Line 345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

341: -- Check p_init_msg_list
342: IF FND_API.to_boolean(p_init_msg_list) THEN
343: FND_MSG_PUB.initialize;
344: END IF;
345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
346:
347:
348: l_detail_ids(1) := p_from_detail_id;
349: l_action_prms.caller := 'WSH_PUB';

Line 373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

369: p_action_prms => l_action_prms ,
370: x_action_out_rec => l_action_out_rec);
371:
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
374: END IF;
375: --
376: wsh_util_core.api_post_call(
377: p_return_status => l_return_status,

Line 376: wsh_util_core.api_post_call(

372: IF l_debug_on THEN
373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
374: END IF;
375: --
376: wsh_util_core.api_post_call(
377: p_return_status => l_return_status,
378: x_num_warnings => l_number_of_warnings,
379: x_num_errors => l_number_of_errors,
380: p_msg_data => l_msg_data

Line 389: x_return_status := wsh_util_core.g_ret_sts_warning;

385: l_index := l_action_out_rec.result_id_tab.first;
386: x_new_detail_id := l_action_out_rec.result_id_tab(l_index);
387:
388: IF l_number_of_warnings > 0 THEN
389: x_return_status := wsh_util_core.g_ret_sts_warning;
390: END IF;
391:
392: IF FND_API.TO_BOOLEAN(p_commit) THEN
393: -- dbms_output.put_line('commit');

Line 412: wsh_util_core.add_message(x_return_status);

408: exception
409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO SPLIT_LINE_PUB;
411: x_return_status := FND_API.G_RET_STS_ERROR ;
412: wsh_util_core.add_message(x_return_status);
413: FND_MSG_PUB.Count_And_Get
414: (
415: p_count => x_msg_count,
416: p_data => x_msg_data,

Line 428: wsh_util_core.add_message(x_return_status, l_module_name);

424: --
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: ROLLBACK TO SPLIT_LINE_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: wsh_util_core.add_message(x_return_status, l_module_name);
429: FND_MSG_PUB.Count_And_Get
430: (
431: p_count => x_msg_count,
432: p_data => x_msg_data,

Line 444: wsh_util_core.add_message(x_return_status, l_module_name);

440: END IF;
441: WHEN OTHERS THEN
442: ROLLBACK TO SPLIT_LINE_PUB;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: wsh_util_core.add_message(x_return_status, l_module_name);
445: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Split_Line');
446: FND_MSG_PUB.Count_And_Get
447: (
448: p_count => x_msg_count,

Line 445: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Split_Line');

441: WHEN OTHERS THEN
442: ROLLBACK TO SPLIT_LINE_PUB;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: wsh_util_core.add_message(x_return_status, l_module_name);
445: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Split_Line');
446: FND_MSG_PUB.Count_And_Get
447: (
448: p_count => x_msg_count,
449: p_data => x_msg_data,

Line 491: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

487: IF l_debug_on THEN
488: WSH_DEBUG_SV.push(l_module_name);
489: END IF;
490: --
491: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
492: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
493: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
494: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
495: p_init_rec.customer_number := FND_API.G_MISS_NUM;

Line 592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

588: END IF;
589: --
590: EXCEPTION
591: WHEN Others THEN
592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
593: WSH_UTIL_CORE.add_message (x_return_status);
594: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Init_Changed_Attribute_Rec');
595:
596:

Line 593: WSH_UTIL_CORE.add_message (x_return_status);

589: --
590: EXCEPTION
591: WHEN Others THEN
592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
593: WSH_UTIL_CORE.add_message (x_return_status);
594: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Init_Changed_Attribute_Rec');
595:
596:
597: --

Line 594: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Init_Changed_Attribute_Rec');

590: EXCEPTION
591: WHEN Others THEN
592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
593: WSH_UTIL_CORE.add_message (x_return_status);
594: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Init_Changed_Attribute_Rec');
595:
596:
597: --
598: -- Debug Statements

Line 662: l_lpn_ids wsh_util_core.id_Tab_type;

658:
659: -- Harmonization Project
660: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
661: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
662: l_lpn_ids wsh_util_core.id_Tab_type;
663: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
664: l_msg_count NUMBER;
665: l_msg_data VARCHAR2(32767);
666: l_number_of_errors NUMBER := 0;

Line 695: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

691: WSH_DEBUG_SV.log(l_module_name,'P_CONTAINER_FLAG',P_CONTAINER_FLAG);
692: END IF;
693: --
694:
695: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
696:
697: -- Standard call to check for call compatibility
698: IF NOT FND_API.Compatible_API_Call(
699: l_api_version_number,

Line 744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

740: p_IN_rec => l_in_rec,
741: x_OUT_rec => l_out_rec);
742:
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
745: END IF;
746: --
747: wsh_util_core.api_post_call(
748: p_return_status => l_return_status,

Line 747: wsh_util_core.api_post_call(

743: IF l_debug_on THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
745: END IF;
746: --
747: wsh_util_core.api_post_call(
748: p_return_status => l_return_status,
749: x_num_warnings => l_number_of_warnings,
750: x_num_errors => l_number_of_errors,
751: p_msg_data => l_msg_data

Line 756: x_return_status := wsh_util_core.g_ret_sts_warning;

752: );
753: --
754:
755: IF l_number_of_warnings > 0 THEN
756: x_return_status := wsh_util_core.g_ret_sts_warning;
757: END IF;
758:
759: -- report success
760: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 778: wsh_util_core.add_message(x_return_status);

774: EXCEPTION
775: WHEN FND_API.G_EXC_ERROR THEN
776: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
777: x_return_status := FND_API.G_RET_STS_ERROR ;
778: wsh_util_core.add_message(x_return_status);
779: FND_MSG_PUB.Count_And_Get
780: (
781: p_count => x_msg_count,
782: p_data => x_msg_data,

Line 794: wsh_util_core.add_message(x_return_status, l_module_name);

790: --
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
794: wsh_util_core.add_message(x_return_status, l_module_name);
795: FND_MSG_PUB.Count_And_Get
796: (
797: p_count => x_msg_count,
798: p_data => x_msg_data,

Line 813: WSH_UTIL_CORE.Add_Message(x_return_status);

809: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
812: FND_MESSAGE.SET_TOKEN('SOURCE_CODE',p_source_code );
813: WSH_UTIL_CORE.Add_Message(x_return_status);
814:
815: FND_MSG_PUB.Count_And_Get
816: (
817: p_count => x_msg_count,

Line 829: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

825: END IF;
826: --
827: WHEN Others THEN
828: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
829: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
830: WSH_UTIL_CORE.add_message (x_return_status);
831: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
832: ;
833:

Line 830: WSH_UTIL_CORE.add_message (x_return_status);

826: --
827: WHEN Others THEN
828: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
829: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
830: WSH_UTIL_CORE.add_message (x_return_status);
831: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
832: ;
833:
834: FND_MSG_PUB.Count_And_Get

Line 831: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')

827: WHEN Others THEN
828: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
829: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
830: WSH_UTIL_CORE.add_message (x_return_status);
831: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
832: ;
833:
834: FND_MSG_PUB.Count_And_Get
835: (

Line 905: l_lpn_ids wsh_util_core.id_Tab_type;

901:
902: -- Harmonization Project
903: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
904: l_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
905: l_lpn_ids wsh_util_core.id_Tab_type;
906: l_out_Rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
907: l_msg_count NUMBER;
908: l_msg_data VARCHAR2(32767);
909: l_number_of_errors NUMBER := 0;

Line 941: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

937:
938: END IF;
939: --
940:
941: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
942:
943: -- Standard call to check for call compatibility
944: IF NOT FND_API.Compatible_API_Call(
945: l_api_version_number,

Line 1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

999: p_serial_range_tab => l_serial_range_tab
1000: );
1001:
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005: --
1006: wsh_util_core.api_post_call(
1007: p_return_status => l_return_status,

Line 1006: wsh_util_core.api_post_call(

1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005: --
1006: wsh_util_core.api_post_call(
1007: p_return_status => l_return_status,
1008: x_num_warnings => l_number_of_warnings,
1009: x_num_errors => l_number_of_errors,
1010: p_msg_data => l_msg_data

Line 1015: x_return_status := wsh_util_core.g_ret_sts_warning;

1011: );
1012: --
1013:
1014: IF l_number_of_warnings > 0 THEN
1015: x_return_status := wsh_util_core.g_ret_sts_warning;
1016: END IF;
1017: -- report success
1018: IF FND_API.TO_BOOLEAN(p_commit) THEN
1019: COMMIT WORK;

Line 1036: wsh_util_core.add_message(x_return_status);

1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1035: x_return_status := FND_API.G_RET_STS_ERROR ;
1036: wsh_util_core.add_message(x_return_status);
1037: FND_MSG_PUB.Count_And_Get
1038: (
1039: p_count => x_msg_count,
1040: p_data => x_msg_data,

Line 1052: wsh_util_core.add_message(x_return_status, l_module_name);

1048: --
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1052: wsh_util_core.add_message(x_return_status, l_module_name);
1053: FND_MSG_PUB.Count_And_Get
1054: (
1055: p_count => x_msg_count,
1056: p_data => x_msg_data,

Line 1071: WSH_UTIL_CORE.Add_Message(x_return_status);

1067: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
1070: FND_MESSAGE.SET_TOKEN('SOURCE_CODE',p_source_code );
1071: WSH_UTIL_CORE.Add_Message(x_return_status);
1072:
1073: FND_MSG_PUB.Count_And_Get
1074: (
1075: p_count => x_msg_count,

Line 1087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1083: END IF;
1084: --
1085: WHEN Others THEN
1086: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1088: WSH_UTIL_CORE.add_message (x_return_status);
1089: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
1090: ;
1091:

Line 1088: WSH_UTIL_CORE.add_message (x_return_status);

1084: --
1085: WHEN Others THEN
1086: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1088: WSH_UTIL_CORE.add_message (x_return_status);
1089: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
1090: ;
1091:
1092: FND_MSG_PUB.Count_And_Get

Line 1089: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')

1085: WHEN Others THEN
1086: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1088: WSH_UTIL_CORE.add_message (x_return_status);
1089: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes')
1090: ;
1091:
1092: FND_MSG_PUB.Count_And_Get
1093: (

Line 1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1145: --
1146: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
1147: END IF;
1148: --
1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1150:
1151: -- get line status for delivery detail
1152: OPEN del_assign;
1153: FETCH del_assign INTO l_assign_rec;

Line 1174: wsh_util_core.default_handler('WSH_SHIP_CONFRIM_ACTIONS.SHIP_CONFIRM_A_TRIP_STOP');

1170:
1171: /*
1172: EXCEPTION
1173: when others then
1174: wsh_util_core.default_handler('WSH_SHIP_CONFRIM_ACTIONS.SHIP_CONFIRM_A_TRIP_STOP');
1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1176: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1177: if x_msg_count > 1 then
1178: x_msg_data := l_msg_summary || l_msg_details;

Line 1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1171: /*
1172: EXCEPTION
1173: when others then
1174: wsh_util_core.default_handler('WSH_SHIP_CONFRIM_ACTIONS.SHIP_CONFIRM_A_TRIP_STOP');
1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1176: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1177: if x_msg_count > 1 then
1178: x_msg_data := l_msg_summary || l_msg_details;
1179: else

Line 1176: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);

1172: EXCEPTION
1173: when others then
1174: wsh_util_core.default_handler('WSH_SHIP_CONFRIM_ACTIONS.SHIP_CONFIRM_A_TRIP_STOP');
1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1176: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1177: if x_msg_count > 1 then
1178: x_msg_data := l_msg_summary || l_msg_details;
1179: else
1180: x_msg_data := l_msg_summary;

Line 1200: , p_line_rows IN WSH_UTIL_CORE.id_tab_type

1196: , p_commit IN VARCHAR2
1197: , x_return_status OUT NOCOPY VARCHAR2
1198: , x_msg_count OUT NOCOPY NUMBER
1199: , x_msg_data OUT NOCOPY VARCHAR2
1200: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1201: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
1202: )
1203: IS
1204: l_dummy_rows WSH_UTIL_CORE.id_tab_type;

Line 1201: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type

1197: , x_return_status OUT NOCOPY VARCHAR2
1198: , x_msg_count OUT NOCOPY NUMBER
1199: , x_msg_data OUT NOCOPY VARCHAR2
1200: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1201: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
1202: )
1203: IS
1204: l_dummy_rows WSH_UTIL_CORE.id_tab_type;
1205: l_api_version_number NUMBER := 1.0;

Line 1204: l_dummy_rows WSH_UTIL_CORE.id_tab_type;

1200: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1201: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
1202: )
1203: IS
1204: l_dummy_rows WSH_UTIL_CORE.id_tab_type;
1205: l_api_version_number NUMBER := 1.0;
1206: l_api_name CONSTANT VARCHAR2(30):= 'Autocreate_Deliveries';
1207: l_return_status VARCHAR2(30);
1208: autocreate_delivery_failed EXCEPTION;

Line 1217: l_dummy_ids wsh_util_core.id_tab_type;

1213: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1214: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1215: l_dummy_qty NUMBER;
1216: l_dummy_qty2 NUMBER;
1217: l_dummy_ids wsh_util_core.id_tab_type;
1218: l_msg_count NUMBER;
1219: l_msg_data VARCHAR2(32767);
1220: l_number_of_errors NUMBER := 0;
1221: l_number_of_warnings NUMBER := 0;

Line 1261: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1257: -- Check p_init_msg_list
1258: IF FND_API.to_boolean(p_init_msg_list) THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;
1261: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1262:
1263: l_action_prms.caller := 'WSH_PUB';
1264: l_action_prms.action_code := 'AUTOCREATE-DEL';
1265:

Line 1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1281: p_action_prms => l_action_prms ,
1282: x_action_out_rec => l_action_out_rec);
1283:
1284: IF l_debug_on THEN
1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1286: END IF;
1287: --
1288: wsh_util_core.api_post_call(
1289: p_return_status => l_return_status,

Line 1288: wsh_util_core.api_post_call(

1284: IF l_debug_on THEN
1285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1286: END IF;
1287: --
1288: wsh_util_core.api_post_call(
1289: p_return_status => l_return_status,
1290: x_num_warnings => l_number_of_warnings,
1291: x_num_errors => l_number_of_errors,
1292: p_msg_data => l_msg_data

Line 1298: x_return_status := wsh_util_core.g_ret_sts_warning;

1294:
1295: x_del_rows := l_action_out_rec.delivery_id_tab;
1296:
1297: IF l_number_of_warnings > 0 THEN
1298: x_return_status := wsh_util_core.g_ret_sts_warning;
1299: END IF;
1300:
1301:
1302: FND_MSG_PUB.Count_And_Get

Line 1323: wsh_util_core.add_message(x_return_status);

1319: EXCEPTION
1320: WHEN FND_API.G_EXC_ERROR THEN
1321: ROLLBACK TO AUTOCREATE_DEL_PUB;
1322: x_return_status := FND_API.G_RET_STS_ERROR ;
1323: wsh_util_core.add_message(x_return_status);
1324: FND_MSG_PUB.Count_And_Get
1325: (
1326: p_count => x_msg_count,
1327: p_data => x_msg_data,

Line 1338: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1334: END IF;
1335:
1336: WHEN autocreate_delivery_failed THEN
1337: ROLLBACK TO AUTOCREATE_DEL_PUB;
1338: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1339: FND_MSG_PUB.Count_And_Get
1340: (
1341: p_count => x_msg_count,
1342: p_data => x_msg_data,

Line 1354: wsh_util_core.add_message(x_return_status, l_module_name);

1350:
1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1352: ROLLBACK TO AUTOCREATE_DEL_PUB;
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354: wsh_util_core.add_message(x_return_status, l_module_name);
1355: FND_MSG_PUB.Count_And_Get
1356: (
1357: p_count => x_msg_count,
1358: p_data => x_msg_data,

Line 1370: wsh_util_core.add_message(x_return_status, l_module_name);

1366: END IF;
1367: WHEN OTHERS THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: ROLLBACK TO AUTOCREATE_DEL_PUB;
1370: wsh_util_core.add_message(x_return_status, l_module_name);
1371: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries');
1372: FND_MSG_PUB.Count_And_Get
1373: (
1374: p_count => x_msg_count,

Line 1371: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries');

1367: WHEN OTHERS THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: ROLLBACK TO AUTOCREATE_DEL_PUB;
1370: wsh_util_core.add_message(x_return_status, l_module_name);
1371: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries');
1372: FND_MSG_PUB.Count_And_Get
1373: (
1374: p_count => x_msg_count,
1375: p_data => x_msg_data,

Line 1394: , p_line_rows IN WSH_UTIL_CORE.id_tab_type

1390: , p_commit IN VARCHAR2
1391: , x_return_status OUT NOCOPY VARCHAR2
1392: , x_msg_count OUT NOCOPY NUMBER
1393: , x_msg_data OUT NOCOPY VARCHAR2
1394: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1395: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
1396: , x_trip_id OUT NOCOPY NUMBER
1397: , x_trip_name OUT NOCOPY VARCHAR2
1398: )

Line 1395: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type

1391: , x_return_status OUT NOCOPY VARCHAR2
1392: , x_msg_count OUT NOCOPY NUMBER
1393: , x_msg_data OUT NOCOPY VARCHAR2
1394: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1395: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
1396: , x_trip_id OUT NOCOPY NUMBER
1397: , x_trip_name OUT NOCOPY VARCHAR2
1398: )
1399: IS

Line 1401: l_trip_rows WSH_UTIL_CORE.id_tab_type;

1397: , x_trip_name OUT NOCOPY VARCHAR2
1398: )
1399: IS
1400:
1401: l_trip_rows WSH_UTIL_CORE.id_tab_type;
1402: l_first NUMBER := 0;
1403: l_debug_on BOOLEAN;
1404: --
1405: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'AUTOCREATE_DEL_TRIP - single trip';

Line 1465: wsh_util_core.add_message(x_return_status, l_module_name);

1461: WHEN OTHERS THEN
1462:
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1465: wsh_util_core.add_message(x_return_status, l_module_name);
1466: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1467: FND_MSG_PUB.Count_And_Get
1468: (
1469: p_count => x_msg_count,

Line 1466: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');

1462:
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1465: wsh_util_core.add_message(x_return_status, l_module_name);
1466: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1467: FND_MSG_PUB.Count_And_Get
1468: (
1469: p_count => x_msg_count,
1470: p_data => x_msg_data,

Line 1490: , p_line_rows IN WSH_UTIL_CORE.id_tab_type

1486: , p_commit IN VARCHAR2
1487: , x_return_status OUT NOCOPY VARCHAR2
1488: , x_msg_count OUT NOCOPY NUMBER
1489: , x_msg_data OUT NOCOPY VARCHAR2
1490: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1491: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
1492: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
1493: )
1494: IS

Line 1491: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type

1487: , x_return_status OUT NOCOPY VARCHAR2
1488: , x_msg_count OUT NOCOPY NUMBER
1489: , x_msg_data OUT NOCOPY VARCHAR2
1490: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1491: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
1492: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
1493: )
1494: IS
1495: l_api_name CONSTANT VARCHAR2(30):= 'Autocreate_del_trip';

Line 1492: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type

1488: , x_msg_count OUT NOCOPY NUMBER
1489: , x_msg_data OUT NOCOPY VARCHAR2
1490: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1491: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
1492: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
1493: )
1494: IS
1495: l_api_name CONSTANT VARCHAR2(30):= 'Autocreate_del_trip';
1496: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1500: l_org_rows wsh_util_core.id_tab_type; -- bug 1668578

1496: l_api_version_number CONSTANT NUMBER := 1.0;
1497: l_return_status VARCHAR2(30);
1498: l_msg_summary varchar2(2000) := NULL;
1499: l_msg_details varchar2(4000) := NULL;
1500: l_org_rows wsh_util_core.id_tab_type; -- bug 1668578
1501: autocreate_trip_failed EXCEPTION;
1502:
1503: -- Harmonization Project
1504: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

Line 1508: l_del_rows wsh_util_core.id_tab_type;

1504: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
1505: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
1506: l_dummy_qty NUMBER;
1507: l_dummy_qty2 NUMBER;
1508: l_del_rows wsh_util_core.id_tab_type;
1509: l_msg_count NUMBER;
1510: l_msg_data VARCHAR2(32767);
1511: l_number_of_errors NUMBER := 0;
1512: l_number_of_warnings NUMBER := 0;

Line 1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1547: -- Check p_init_msg_list
1548: IF FND_API.to_boolean(p_init_msg_list) THEN
1549: FND_MSG_PUB.initialize;
1550: END IF;
1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1552:
1553: l_action_prms.caller := 'WSH_PUB';
1554: l_action_prms.action_code := 'AUTOCREATE-TRIP';
1555:

Line 1575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1571: p_action_prms => l_action_prms ,
1572: x_action_out_rec => l_action_out_rec);
1573:
1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1576: END IF;
1577: --
1578: wsh_util_core.api_post_call(
1579: p_return_status => l_return_status,

Line 1578: wsh_util_core.api_post_call(

1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1576: END IF;
1577: --
1578: wsh_util_core.api_post_call(
1579: p_return_status => l_return_status,
1580: x_num_warnings => l_number_of_warnings,
1581: x_num_errors => l_number_of_errors,
1582: p_msg_data => l_msg_data

Line 1589: x_return_status := wsh_util_core.g_ret_sts_warning;

1585: x_del_rows := l_action_out_rec.delivery_id_tab;
1586: x_trip_rows:= l_action_out_rec.result_id_tab;
1587:
1588: IF l_number_of_warnings > 0 THEN
1589: x_return_status := wsh_util_core.g_ret_sts_warning;
1590: END IF;
1591:
1592: IF FND_API.TO_BOOLEAN(p_commit) THEN
1593: COMMIT WORK;

Line 1612: wsh_util_core.add_message(x_return_status);

1608: EXCEPTION
1609: WHEN FND_API.G_EXC_ERROR THEN
1610: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1611: x_return_status := FND_API.G_RET_STS_ERROR ;
1612: wsh_util_core.add_message(x_return_status);
1613: FND_MSG_PUB.Count_And_Get
1614: (
1615: p_count => x_msg_count,
1616: p_data => x_msg_data,

Line 1628: wsh_util_core.add_message(x_return_status, l_module_name);

1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1628: wsh_util_core.add_message(x_return_status, l_module_name);
1629: FND_MSG_PUB.Count_And_Get
1630: (
1631: p_count => x_msg_count,
1632: p_data => x_msg_data,

Line 1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1641:
1642:
1643: WHEN autocreate_trip_failed THEN
1644: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1646: FND_MSG_PUB.Count_And_Get
1647: (
1648: p_count => x_msg_count,
1649: p_data => x_msg_data,

Line 1662: wsh_util_core.add_message(x_return_status, l_module_name);

1658: WHEN OTHERS THEN
1659:
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1662: wsh_util_core.add_message(x_return_status, l_module_name);
1663: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1664: FND_MSG_PUB.Count_And_Get
1665: (
1666: p_count => x_msg_count,

Line 1663: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');

1659:
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1662: wsh_util_core.add_message(x_return_status, l_module_name);
1663: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1664: FND_MSG_PUB.Count_And_Get
1665: (
1666: p_count => x_msg_count,
1667: p_data => x_msg_data,

Line 1909: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');

1905:
1906:
1907: WHEN OTHERS THEN
1908:
1909: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.UPDATE_ATTRIBUTES');
1910: IF l_debug_on THEN
1911: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1913: END IF;