[Home] [Help]
52: -- Forward Declarations for local procedures
53: PROCEDURE Create_Delivery_Detail(
54: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
55: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
56: p_valid_index_tab IN wsh_util_core.id_tab_type,
57: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2
63: PROCEDURE Validate_Delivery_Detail(
64: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
65: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
66: p_action IN VARCHAR2,
67: p_validation_tab IN wsh_util_core.Id_Tab_Type,
68: p_caller IN varchar2,
69: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
70: x_details_marked OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
71: x_detail_tender_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
65: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
66: p_action IN VARCHAR2,
67: p_validation_tab IN wsh_util_core.Id_Tab_Type,
68: p_caller IN varchar2,
69: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
70: x_details_marked OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
71: x_detail_tender_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
66: p_action IN VARCHAR2,
67: p_validation_tab IN wsh_util_core.Id_Tab_Type,
68: p_caller IN varchar2,
69: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
70: x_details_marked OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
71: x_detail_tender_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
67: p_validation_tab IN wsh_util_core.Id_Tab_Type,
68: p_caller IN varchar2,
69: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
70: x_details_marked OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
71: x_detail_tender_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
77: );
78:
79: PROCEDURE Update_Delivery_Detail(
80: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
81: p_valid_index_tab IN wsh_util_core.id_tab_type,
82: x_return_status OUT NOCOPY varchar2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_caller IN VARCHAR2 DEFAULT NULL
107: PROCEDURE Validate_Detail_Line(
108: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
109: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
110: p_original_rec IN c_original_detail_cur%ROWTYPE,
111: p_validation_tab IN WSH_UTIL_CORE.id_tab_type,
112: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
119:
120: PROCEDURE Validate_Detail_Container(
121: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
122: p_original_rec IN c_original_detail_cur%ROWTYPE,
123: p_validation_tab IN WSH_UTIL_CORE.id_tab_type,
124: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2
129:
130: PROCEDURE Validate_Detail_Common(
131: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
132: p_original_rec IN c_original_detail_cur%ROWTYPE,
133: p_validation_tab IN wsh_util_core.id_tab_type,
134: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: -- procedure specific parameters
176: p_tabofdeldets IN WSH_UTIL_CORE.id_tab_type,
177: p_action IN VARCHAR2,
178: p_delivery_id IN NUMBER,
179: p_delivery_name IN VARCHAR2,
180: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH
184: l_api_name CONSTANT VARCHAR2(30) := 'delivery_detail_to_delivery';
185: l_return_status VARCHAR2(30) := NULL;
186: l_delivery_id NUMBER := NULL;
187: l_cont_ins_id NUMBER := NULL;
188: l_tabofdeldets wsh_util_core.id_tab_type;
189: l_msg_summary VARCHAR2(2000) := NULL;
190: l_msg_details VARCHAR2(4000) := NULL;
191: l_del_params wsh_delivery_autocreate.grp_attr_tab_type;
192: wsh_no_del_det_tbl EXCEPTION;
224: l_pack_status_dummy VARCHAR2(100);
225: l_msg_data VARCHAR2(32767);
226:
227: -- anxsharm for Load Tender
228: l_trip_id_tab wsh_util_core.id_tab_type;
229: l_det_tab wsh_util_core.id_tab_type;
230: l_number_of_errors NUMBER := 0;
231: l_number_of_warnings NUMBER := 0;
232: --
225: l_msg_data VARCHAR2(32767);
226:
227: -- anxsharm for Load Tender
228: l_trip_id_tab wsh_util_core.id_tab_type;
229: l_det_tab wsh_util_core.id_tab_type;
230: l_number_of_errors NUMBER := 0;
231: l_number_of_warnings NUMBER := 0;
232: --
233: l_cnt NUMBER;
233: l_cnt NUMBER;
234: i number;
235:
236: -- deliveryMerge
237: l_adjust_planned_del_tab wsh_util_core.id_tab_type;
238: l_delivery_already_included boolean;
239: --LPN Convergence
240: e_invalid_quantity EXCEPTION;
241:
284: IF fnd_api.to_boolean(p_init_msg_list) THEN
285: fnd_msg_pub.initialize;
286: END IF;
287:
288: x_return_status := wsh_util_core.g_ret_sts_success;
289:
290: IF (p_tabofdeldets.COUNT = 0) THEN
291: RAISE wsh_no_del_det_tbl;
292: END IF;
357: p_delivery_id => p_delivery_id,
358: x_pack_status => l_pack_status_dummy,
359: x_return_status => l_return_status
360: );
361: wsh_util_core.api_post_call(
362: p_return_status => l_return_status,
363: x_num_warnings => l_number_of_warnings,
364: x_num_errors => l_number_of_errors);
365: /* Patchset I : Harmonization Project End */
368: p_entity => 'DLVY',
369: p_entity_ids =>l_det_tab,
370: x_return_status => x_return_status);
371:
372: wsh_util_core.api_post_call(
373: p_return_status => l_return_status,
374: x_num_warnings => l_number_of_warnings,
375: x_num_errors => l_number_of_errors);
376:
394: wsh_details_validations.check_unassign_from_delivery(
395: p_detail_rows => l_tabofdeldets,
396: x_return_status => l_return_status);
397:
398: wsh_util_core.api_post_call(
399: p_return_status => l_return_status,
400: x_num_warnings => l_number_of_warnings,
401: x_num_errors => l_number_of_errors);
402:
443: p_delivery_flag => 'Y',
444: x_return_status => l_return_status,
445: p_action_prms => p_action_prms
446: );
447: wsh_util_core.api_post_call(
448: p_return_status => l_return_status,
449: x_num_warnings => l_number_of_warnings,
450: x_num_errors => l_number_of_errors);
451: /* Patchset I : Harmonization Project End */
462: IF l_debug_on THEN
463: WSH_DEBUG_SV.log(l_module_name,'Adjust_Planned_Flag returns ',l_return_status);
464: END IF;
465:
466: wsh_util_core.api_post_call(
467: p_return_status => l_return_status,
468: x_num_warnings => l_number_of_warnings,
469: x_num_errors => l_number_of_errors);
470:
474: IF l_debug_on THEN
475: wsh_debug_sv.log(l_module_name, 'Number of warnings', l_number_of_warnings);
476: END IF;
477:
478: RAISE wsh_util_core.g_exc_warning;
479: END IF;
480:
481: fnd_msg_pub.count_and_get(
482: p_count => x_msg_count,
518: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
519: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
520: END IF;
521: --
522: WHEN wsh_util_core.g_exc_warning THEN
523: x_return_status := wsh_util_core.g_ret_sts_warning;
524: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
525: p_encoded => fnd_api.g_false);
526:
519: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
520: END IF;
521: --
522: WHEN wsh_util_core.g_exc_warning THEN
523: x_return_status := wsh_util_core.g_ret_sts_warning;
524: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
525: p_encoded => fnd_api.g_false);
526:
527: --
525: p_encoded => fnd_api.g_false);
526:
527: --
528: IF l_debug_on THEN
529: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
530: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
531: END IF;
532:
533: WHEN wsh_invalid_action THEN
526:
527: --
528: IF l_debug_on THEN
529: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
530: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
531: END IF;
532:
533: WHEN wsh_invalid_action THEN
534: ROLLBACK TO detail_to_delivery_grp;
531: END IF;
532:
533: WHEN wsh_invalid_action THEN
534: ROLLBACK TO detail_to_delivery_grp;
535: x_return_status := wsh_util_core.g_ret_sts_error;
536: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
537: wsh_util_core.add_message(x_return_status);
538: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
539: p_encoded => fnd_api.g_false);
533: WHEN wsh_invalid_action THEN
534: ROLLBACK TO detail_to_delivery_grp;
535: x_return_status := wsh_util_core.g_ret_sts_error;
536: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
537: wsh_util_core.add_message(x_return_status);
538: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
539: p_encoded => fnd_api.g_false);
540:
541: IF l_debug_on THEN
544: END IF;
545:
546: WHEN wsh_no_del_det_tbl THEN
547: ROLLBACK TO detail_to_delivery_grp;
548: x_return_status := wsh_util_core.g_ret_sts_error;
549: fnd_message.set_name('WSH', 'WSH_PUB_NO_DEL_DET_TBL');
550: wsh_util_core.add_message(x_return_status);
551: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
552: p_encoded => fnd_api.g_false);
546: WHEN wsh_no_del_det_tbl THEN
547: ROLLBACK TO detail_to_delivery_grp;
548: x_return_status := wsh_util_core.g_ret_sts_error;
549: fnd_message.set_name('WSH', 'WSH_PUB_NO_DEL_DET_TBL');
550: wsh_util_core.add_message(x_return_status);
551: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
552: p_encoded => fnd_api.g_false);
553:
554: IF l_debug_on THEN
557: END IF;
558: --
559: WHEN wsh_no_delivery_id THEN
560: ROLLBACK TO detail_to_delivery_grp;
561: x_return_status := wsh_util_core.g_ret_sts_error;
562: fnd_message.set_name('WSH', 'WSH_PUB_NO_DELIVERY');
563: wsh_util_core.add_message(x_return_status);
564: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
565: p_encoded => fnd_api.g_false);
559: WHEN wsh_no_delivery_id THEN
560: ROLLBACK TO detail_to_delivery_grp;
561: x_return_status := wsh_util_core.g_ret_sts_error;
562: fnd_message.set_name('WSH', 'WSH_PUB_NO_DELIVERY');
563: wsh_util_core.add_message(x_return_status);
564: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
565: p_encoded => fnd_api.g_false);
566:
567: IF l_debug_on THEN
573: /*Start of 2777869*/
574:
575: WHEN wsh_no_delivery THEN
576: ROLLBACK TO detail_to_delivery_grp;
577: x_return_status := wsh_util_core.g_ret_sts_error;
578: fnd_message.set_name('WSH', 'WSH_DELIVERY_NOT_EXIST');
579: fnd_message.set_token('DELIVERY_NAME', p_delivery_name);
580: wsh_util_core.add_message(x_return_status);
581: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
576: ROLLBACK TO detail_to_delivery_grp;
577: x_return_status := wsh_util_core.g_ret_sts_error;
578: fnd_message.set_name('WSH', 'WSH_DELIVERY_NOT_EXIST');
579: fnd_message.set_token('DELIVERY_NAME', p_delivery_name);
580: wsh_util_core.add_message(x_return_status);
581: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
582: p_encoded => fnd_api.g_false);
583:
584: IF l_debug_on THEN
587: END IF;
588: --
589: WHEN wsh_invalid_delivery_id THEN
590: ROLLBACK TO detail_to_delivery_grp;
591: x_return_status := wsh_util_core.g_ret_sts_error;
592: fnd_message.set_name('WSH', 'WSH_INVALID_DELIVERY');
593: fnd_message.set_token('DELIVERY', p_delivery_id);
594: wsh_util_core.add_message(x_return_status);
595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
590: ROLLBACK TO detail_to_delivery_grp;
591: x_return_status := wsh_util_core.g_ret_sts_error;
592: fnd_message.set_name('WSH', 'WSH_INVALID_DELIVERY');
593: fnd_message.set_token('DELIVERY', p_delivery_id);
594: wsh_util_core.add_message(x_return_status);
595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
596: p_encoded => fnd_api.g_false);
597:
598: IF l_debug_on THEN
604: --
605:
606: WHEN OTHERS THEN
607: ROLLBACK TO detail_to_delivery_grp;
608: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
609: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
610: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
611: p_encoded => fnd_api.g_false);
612:
605:
606: WHEN OTHERS THEN
607: ROLLBACK TO detail_to_delivery_grp;
608: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
609: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
610: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
611: p_encoded => fnd_api.g_false);
612:
613: IF l_debug_on THEN
628: x_return_status OUT NOCOPY VARCHAR2,
629: x_msg_count OUT NOCOPY NUMBER,
630: x_msg_data OUT NOCOPY VARCHAR2,
631: -- procedure specific parameters
632: p_tabofdeldets IN WSH_UTIL_CORE.id_tab_type,
633: p_action IN VARCHAR2,
634: p_delivery_id IN NUMBER,
635: p_delivery_name IN VARCHAR2
636: ) IS
692: --
693: EXCEPTION
694:
695: WHEN OTHERS THEN
696: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
697: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
698: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
699: p_encoded => fnd_api.g_false);
700:
693: EXCEPTION
694:
695: WHEN OTHERS THEN
696: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
697: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
698: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
699: p_encoded => fnd_api.g_false);
700:
701: IF l_debug_on THEN
769: l_organization_id NUMBER;
770: l_requested_quantity_uom VARCHAR2(32767);
771: l_return_status VARCHAR2(32767);
772: l_output_quantity NUMBER;
773: l_validation_level_tab wsh_util_core.id_tab_type;
774:
775: -- bug 3524851
776: l_top_model_line_id NUMBER;
777:
820: IF fnd_api.to_boolean(p_init_msg_list) THEN
821: fnd_msg_pub.initialize;
822: END IF;
823:
824: x_return_status := wsh_util_core.g_ret_sts_success;
825: --
826: /* Patchset I : Harmonization Project */
827: l_validation_level_tab := wsh_actions_levels.g_validation_level_tab;
828: /* OPM changes NC - added l_requested_quantity2 */
898: wsh_debug_sv.LOG(l_module_name, 'Output qty after check decimal', l_output_quantity);
899: END IF;
900:
901: -- UT Bug fix 2650839
902: --IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
903: -- RAISE fnd_api.g_exc_error;
904: --END IF;
905: -- Reverting the fix made in 2650839 as we need to return warning instead of
906: -- error to public API users.
903: -- RAISE fnd_api.g_exc_error;
904: --END IF;
905: -- Reverting the fix made in 2650839 as we need to return warning instead of
906: -- error to public API users.
907: wsh_util_core.api_post_call(
908: p_return_status => l_return_status,
909: x_num_warnings => l_number_of_warnings,
910: x_num_errors => l_number_of_errors);
911:
925: p_converted_flag => p_converted_flag,
926: x_new_detail_id => x_new_detail_id,
927: x_return_status => l_return_status
928: );
929: wsh_util_core.api_post_call(
930: p_return_status => l_return_status,
931: x_num_warnings => l_number_of_warnings,
932: x_num_errors => l_number_of_errors);
933:
935: IF l_debug_on THEN
936: wsh_debug_sv.log(l_module_name, 'Number of warnings', l_number_of_warnings);
937: END IF;
938:
939: RAISE wsh_util_core.g_exc_warning;
940: END IF;
941:
942: fnd_msg_pub.count_and_get(
943: p_count => x_msg_count,
978: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
979: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
980: END IF;
981: --
982: WHEN wsh_util_core.g_exc_warning THEN
983: x_return_status := wsh_util_core.g_ret_sts_warning;
984: fnd_msg_pub.count_and_get(
985: p_count => x_msg_count,
986: p_data => x_msg_data,
979: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
980: END IF;
981: --
982: WHEN wsh_util_core.g_exc_warning THEN
983: x_return_status := wsh_util_core.g_ret_sts_warning;
984: fnd_msg_pub.count_and_get(
985: p_count => x_msg_count,
986: p_data => x_msg_data,
987: p_encoded => fnd_api.g_false);
987: p_encoded => fnd_api.g_false);
988:
989: --
990: IF l_debug_on THEN
991: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
992: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
993: END IF;
994: WHEN wsh_inalid_detail_id THEN
995: ROLLBACK TO split_line_grp;
988:
989: --
990: IF l_debug_on THEN
991: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
992: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
993: END IF;
994: WHEN wsh_inalid_detail_id THEN
995: ROLLBACK TO split_line_grp;
996: x_return_status := wsh_util_core.g_ret_sts_error;
992: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
993: END IF;
994: WHEN wsh_inalid_detail_id THEN
995: ROLLBACK TO split_line_grp;
996: x_return_status := wsh_util_core.g_ret_sts_error;
997:
998: /* Bug 2777869 : Instead of message "WSH_PUB_INALID_DETAIL_ID",now we are using
999: "WSH_DET_INVALID_DETAIL".*/
1000:
999: "WSH_DET_INVALID_DETAIL".*/
1000:
1001: fnd_message.set_name('WSH', 'WSH_DET_INVALID_DETAIL');
1002: fnd_message.set_token('DETAIL_ID',p_from_detail_id);
1003: wsh_util_core.add_message(x_return_status);
1004:
1005: fnd_msg_pub.count_and_get(
1006: p_count => x_msg_count,
1007: p_data => x_msg_data,
1013: END IF;
1014: --
1015: WHEN wsh_invalid_split_qty THEN
1016: ROLLBACK TO split_line_grp;
1017: x_return_status := wsh_util_core.g_ret_sts_error;
1018: fnd_message.set_name('WSH', 'WSH_DET_SPLIT_EXCEED');
1019: wsh_util_core.add_message(x_return_status);
1020:
1021: fnd_msg_pub.count_and_get(
1015: WHEN wsh_invalid_split_qty THEN
1016: ROLLBACK TO split_line_grp;
1017: x_return_status := wsh_util_core.g_ret_sts_error;
1018: fnd_message.set_name('WSH', 'WSH_DET_SPLIT_EXCEED');
1019: wsh_util_core.add_message(x_return_status);
1020:
1021: fnd_msg_pub.count_and_get(
1022: p_count => x_msg_count,
1023: p_data => x_msg_data,
1029: END IF;
1030: --
1031: WHEN wsh_invalid_split_qty2 THEN /* OPM changes. NC - Added */
1032: ROLLBACK TO split_line_grp;
1033: x_return_status := wsh_util_core.g_ret_sts_error;
1034: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_SPLIT_QTY');
1035: wsh_util_core.add_message(x_return_status);
1036:
1037: fnd_msg_pub.count_and_get(
1031: WHEN wsh_invalid_split_qty2 THEN /* OPM changes. NC - Added */
1032: ROLLBACK TO split_line_grp;
1033: x_return_status := wsh_util_core.g_ret_sts_error;
1034: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_SPLIT_QTY');
1035: wsh_util_core.add_message(x_return_status);
1036:
1037: fnd_msg_pub.count_and_get(
1038: p_count => x_msg_count,
1039: p_data => x_msg_data,
1046: --
1047: WHEN OTHERS THEN
1048: ROLLBACK TO split_line_grp;
1049: x_return_status := fnd_api.g_ret_sts_unexp_error;
1050: wsh_util_core.add_message(x_return_status, l_module_name);
1051: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Split_Line');
1052:
1053: fnd_msg_pub.count_and_get(
1054: p_count => x_msg_count,
1047: WHEN OTHERS THEN
1048: ROLLBACK TO split_line_grp;
1049: x_return_status := fnd_api.g_ret_sts_unexp_error;
1050: wsh_util_core.add_message(x_return_status, l_module_name);
1051: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Split_Line');
1052:
1053: fnd_msg_pub.count_and_get(
1054: p_count => x_msg_count,
1055: p_data => x_msg_data,
1122: l_msg_data VARCHAR2(32767);
1123: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
1124: l_detail_in_rec WSH_GLBL_VAR_STRCT_GRP.detailInRecType;
1125: l_detail_out_rec WSH_GLBL_VAR_STRCT_GRP.detailOutRecType;
1126: l_dummy_ids wsh_util_core.id_Tab_type;
1127: invalid_source_code exception;
1128: mark_reprice_error exception;
1129: update_failed exception;
1130: detail_no_found EXCEPTION;
1168: WSH_DEBUG_SV.log(l_module_name,'Table Count',p_changed_attributes.COUNT);
1169:
1170: END IF;
1171: --
1172: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1173:
1174: -- Standard call to check for call compatibility
1175: IF NOT FND_API.Compatible_API_Call(
1176: l_api_version_number,
1382: x_OUT_rec => l_detail_out_rec
1383: );
1384:
1385: IF l_debug_on THEN
1386: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1387: END IF;
1388: --
1389: wsh_util_core.api_post_call(
1390: p_return_status => l_return_status,
1385: IF l_debug_on THEN
1386: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1387: END IF;
1388: --
1389: wsh_util_core.api_post_call(
1390: p_return_status => l_return_status,
1391: x_num_warnings => l_number_of_warnings,
1392: x_num_errors => l_number_of_errors,
1393: p_msg_data => l_msg_data
1416: WHEN mark_reprice_error then
1417: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1418: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
1419: x_return_status := l_return_status;
1420: WSH_UTIL_CORE.add_message (x_return_status);
1421: FND_MSG_PUB.Count_And_Get
1422: ( p_count => x_msg_count,
1423: p_data => x_msg_data,
1424: p_encoded => FND_API.G_FALSE
1434: WHEN invalid_source_code THEN
1435: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
1438: WSH_UTIL_CORE.Add_Message(x_return_status);
1439: FND_MSG_PUB.Count_And_Get
1440: ( p_count => x_msg_count,
1441: p_data => x_msg_data,
1442: p_encoded => FND_API.G_FALSE
1450: END IF;
1451: --
1452: WHEN update_failed THEN
1453: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1455: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_VALIDATION_FAILED');
1456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', l_error_attribute);
1457: FND_MESSAGE.SET_TOKEN('ATTRB_VALUE', l_error_attribute_value);
1458: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', l_error_detail_id);
1455: FND_MESSAGE.SET_NAME('WSH', 'WSH_DETAIL_VALIDATION_FAILED');
1456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', l_error_attribute);
1457: FND_MESSAGE.SET_TOKEN('ATTRB_VALUE', l_error_attribute_value);
1458: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL', l_error_detail_id);
1459: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1460: FND_MSG_PUB.Count_And_Get
1461: ( p_count => x_msg_count,
1462: p_data => x_msg_data,
1463: p_encoded => FND_API.G_FALSE
1470: END IF;
1471: --
1472: WHEN invalid_released_status THEN
1473: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1475: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1476: FND_MSG_PUB.Count_And_Get
1477: ( p_count => x_msg_count,
1478: p_data => x_msg_data,
1471: --
1472: WHEN invalid_released_status THEN
1473: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1475: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1476: FND_MSG_PUB.Count_And_Get
1477: ( p_count => x_msg_count,
1478: p_data => x_msg_data,
1479: p_encoded => FND_API.G_FALSE
1489: IF get_org%isopen THEN
1490: close get_org;
1491: END IF;
1492: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1493: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1494: WSH_UTIL_CORE.add_message (x_return_status);
1495: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Shipping_Attributes');
1496: FND_MSG_PUB.Count_And_Get
1497: ( p_count => x_msg_count,
1490: close get_org;
1491: END IF;
1492: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1493: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1494: WSH_UTIL_CORE.add_message (x_return_status);
1495: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Shipping_Attributes');
1496: FND_MSG_PUB.Count_And_Get
1497: ( p_count => x_msg_count,
1498: p_data => x_msg_data,
1491: END IF;
1492: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1493: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1494: WSH_UTIL_CORE.add_message (x_return_status);
1495: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Shipping_Attributes');
1496: FND_MSG_PUB.Count_And_Get
1497: ( p_count => x_msg_count,
1498: p_data => x_msg_data,
1499: p_encoded => FND_API.G_FALSE
1547: --
1548: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_DETAIL_ID',P_DELIVERY_DETAIL_ID);
1549: END IF;
1550: --
1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1552:
1553: -- get line status for delivery detail
1554: OPEN del_assign;
1555: FETCH del_assign INTO l_assign_rec;
1572:
1573: /*
1574: EXCEPTION
1575: WHEN others then
1576: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Detail_Status');
1577: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1578: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1579: if x_msg_count > 1 then
1580: x_msg_data := l_msg_summary || l_msg_details;
1573: /*
1574: EXCEPTION
1575: WHEN others then
1576: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Detail_Status');
1577: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1578: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1579: if x_msg_count > 1 then
1580: x_msg_data := l_msg_summary || l_msg_details;
1581: else
1574: EXCEPTION
1575: WHEN others then
1576: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Detail_Status');
1577: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1578: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, x_msg_count);
1579: if x_msg_count > 1 then
1580: x_msg_data := l_msg_summary || l_msg_details;
1581: else
1582: x_msg_data := l_msg_summary;
1603: , p_caller IN VARCHAR2 DEFAULT NULL
1604: , x_return_status OUT NOCOPY VARCHAR2
1605: , x_msg_count OUT NOCOPY NUMBER
1606: , x_msg_data OUT NOCOPY VARCHAR2
1607: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1608: , p_group_by_header_flag IN VARCHAR2
1609: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
1610: )
1611: IS
1605: , x_msg_count OUT NOCOPY NUMBER
1606: , x_msg_data OUT NOCOPY VARCHAR2
1607: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
1608: , p_group_by_header_flag IN VARCHAR2
1609: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
1610: )
1611: IS
1612: l_dummy_rows WSH_UTIL_CORE.id_tab_type;
1613: l_api_version_number NUMBER := 1.0;
1608: , p_group_by_header_flag IN VARCHAR2
1609: , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
1610: )
1611: IS
1612: l_dummy_rows WSH_UTIL_CORE.id_tab_type;
1613: l_api_version_number NUMBER := 1.0;
1614: l_api_name CONSTANT VARCHAR2(30):= 'Autocreate_Deliveries';
1615: l_return_status VARCHAR2(30);
1616: autocreate_delivery_failed EXCEPTION;
1631: l_reset_flags BOOLEAN;
1632: --
1633: BEGIN
1634: -- Bugfix 4070732
1635: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
1636: THEN
1637: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1638: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1639: END IF;
1633: BEGIN
1634: -- Bugfix 4070732
1635: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
1636: THEN
1637: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1638: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1639: END IF;
1640: -- End of Code Bugfix 4070732
1641: --
1634: -- Bugfix 4070732
1635: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
1636: THEN
1637: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1638: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1639: END IF;
1640: -- End of Code Bugfix 4070732
1641: --
1642: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1670: -- Check p_init_msg_list
1671: IF FND_API.to_boolean(p_init_msg_list) THEN
1672: FND_MSG_PUB.initialize;
1673: END IF;
1674: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1675:
1676: IF l_debug_on THEN
1677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DEL_ACROSS_ORGS',WSH_DEBUG_SV.C_PROC_LEVEL);
1678: END IF;
1688: x_del_rows => x_del_rows,
1689: x_grouping_rows => l_dummy_rows,
1690: x_return_status => l_return_status);
1691:
1692: wsh_util_core.api_post_call(
1693: p_return_status => l_return_status,
1694: x_num_warnings => l_number_of_warnings,
1695: x_num_errors => l_number_of_errors,
1696: p_msg_data => l_msg_data
1699: IF l_number_of_warnings > 0 THEN
1700: IF l_debug_on THEN
1701: wsh_debug_sv.log(l_module_name,'Number of warnings', l_number_of_warnings);
1702: END IF;
1703: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1704: END IF;
1705:
1706:
1707: IF FND_API.TO_BOOLEAN(p_commit) THEN
1707: IF FND_API.TO_BOOLEAN(p_commit) THEN
1708: --
1709: -- Start code for Bugfix 4070732
1710: --
1711: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1712: IF l_debug_on THEN
1713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1714: END IF;
1715: l_reset_flags := FALSE;
1709: -- Start code for Bugfix 4070732
1710: --
1711: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1712: IF l_debug_on THEN
1713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1714: END IF;
1715: l_reset_flags := FALSE;
1716:
1717: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
1713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1714: END IF;
1715: l_reset_flags := FALSE;
1716:
1717: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
1718: x_return_status => l_return_status);
1719:
1720: IF l_debug_on THEN
1721: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1720: IF l_debug_on THEN
1721: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1722: END IF;
1723:
1724: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1725: RAISE FND_API.G_EXC_ERROR;
1726: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1722: END IF;
1723:
1724: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1725: RAISE FND_API.G_EXC_ERROR;
1726: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1729: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1730: END IF;
1724: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1725: RAISE FND_API.G_EXC_ERROR;
1726: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1729: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1730: END IF;
1731:
1732: END IF;
1725: RAISE FND_API.G_EXC_ERROR;
1726: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1729: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1730: END IF;
1731:
1732: END IF;
1733: --
1738:
1739:
1740: --bug 4070732
1741: --End of the API handling of calls to process_stops_for_load_tender
1742: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1743: --{
1744: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1745: --{
1746:
1740: --bug 4070732
1741: --End of the API handling of calls to process_stops_for_load_tender
1742: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1743: --{
1744: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1745: --{
1746:
1747: IF FND_API.TO_BOOLEAN(p_commit) THEN
1748:
1746:
1747: IF FND_API.TO_BOOLEAN(p_commit) THEN
1748:
1749: IF l_debug_on THEN
1750: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1751: END IF;
1752:
1753: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,
1754: x_return_status => l_return_status);
1749: IF l_debug_on THEN
1750: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1751: END IF;
1752:
1753: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,
1754: x_return_status => l_return_status);
1755:
1756: ELSE
1757:
1755:
1756: ELSE
1757:
1758: IF l_debug_on THEN
1759: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1760: END IF;
1761:
1762: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1763: x_return_status => l_return_status);
1758: IF l_debug_on THEN
1759: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1760: END IF;
1761:
1762: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1763: x_return_status => l_return_status);
1764: END IF;
1765:
1766: IF l_debug_on THEN
1766: IF l_debug_on THEN
1767: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1768: END IF;
1769:
1770: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1771: x_return_status := l_return_status;
1772:
1773: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1774: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1769:
1770: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1771: x_return_status := l_return_status;
1772:
1773: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1774: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1775: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
1776: ROLLBACK TO AUTOCREATE_DEL_GRP;
1777: end if;
1770: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1771: x_return_status := l_return_status;
1772:
1773: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1774: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1775: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
1776: ROLLBACK TO AUTOCREATE_DEL_GRP;
1777: end if;
1778: END IF;
1803: x_return_status := FND_API.G_RET_STS_ERROR ;
1804: --
1805: -- Start code for Bugfix 4070732
1806: --
1807: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1808: THEN
1809: --{
1810: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1811: --{
1806: --
1807: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1808: THEN
1809: --{
1810: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1811: --{
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1814: END IF;
1809: --{
1810: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1811: --{
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1814: END IF;
1815:
1816: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1817: x_return_status => l_return_status);
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1814: END IF;
1815:
1816: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1817: x_return_status => l_return_status);
1818:
1819: IF l_debug_on THEN
1820: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1819: IF l_debug_on THEN
1820: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1821: END IF;
1822:
1823: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1824: x_return_status := l_return_status;
1825: END IF;
1826: --}
1827: END IF;
1845: --
1846:
1847: WHEN autocreate_delivery_failed THEN
1848: ROLLBACK TO AUTOCREATE_DEL_GRP;
1849: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1850: wsh_util_core.add_message(x_return_status, l_module_name);
1851: --
1852: -- Start code for Bugfix 4070732
1853: --
1846:
1847: WHEN autocreate_delivery_failed THEN
1848: ROLLBACK TO AUTOCREATE_DEL_GRP;
1849: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1850: wsh_util_core.add_message(x_return_status, l_module_name);
1851: --
1852: -- Start code for Bugfix 4070732
1853: --
1854: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1850: wsh_util_core.add_message(x_return_status, l_module_name);
1851: --
1852: -- Start code for Bugfix 4070732
1853: --
1854: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1855: THEN
1856: --{
1857: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1858: --{
1853: --
1854: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1855: THEN
1856: --{
1857: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1858: --{
1859: IF l_debug_on THEN
1860: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1861: END IF;
1856: --{
1857: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1858: --{
1859: IF l_debug_on THEN
1860: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1861: END IF;
1862:
1863: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1864: x_return_status => l_return_status);
1859: IF l_debug_on THEN
1860: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1861: END IF;
1862:
1863: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1864: x_return_status => l_return_status);
1865:
1866: IF l_debug_on THEN
1867: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1866: IF l_debug_on THEN
1867: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1868: END IF;
1869:
1870: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1871: x_return_status := l_return_status;
1872: END IF;
1873: --}
1874: END IF;
1890: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');
1892: END IF;
1893:
1894: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1895: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1896: --
1897: -- Start code for Bugfix 4070732
1898: --
1891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');
1892: END IF;
1893:
1894: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1895: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1896: --
1897: -- Start code for Bugfix 4070732
1898: --
1899: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1895: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1896: --
1897: -- Start code for Bugfix 4070732
1898: --
1899: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1900: THEN
1901: --{
1902: IF NOT (WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API)
1903: THEN
1898: --
1899: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1900: THEN
1901: --{
1902: IF NOT (WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API)
1903: THEN
1904: --{
1905:
1906: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1902: IF NOT (WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API)
1903: THEN
1904: --{
1905:
1906: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1907: x_return_status => l_return_status);
1908:
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1911: END IF;
1912:
1913: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1914: x_return_status := l_return_status;
1915:
1916: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1917: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1912:
1913: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1914: x_return_status := l_return_status;
1915:
1916: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1917: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1918: ROLLBACK TO AUTOCREATE_DEL_GRP;
1919: END IF;
1920: END IF;
1913: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1914: x_return_status := l_return_status;
1915:
1916: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1917: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1918: ROLLBACK TO AUTOCREATE_DEL_GRP;
1919: END IF;
1920: END IF;
1921: --}
1934: );
1935:
1936:
1937: IF l_debug_on THEN
1938: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1940: END IF;
1941: --
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1935:
1936:
1937: IF l_debug_on THEN
1938: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1940: END IF;
1941: --
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943: ROLLBACK TO AUTOCREATE_DEL_GRP;
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1945: --
1946: -- Start of code for Bugfix 4070732
1947: --
1948: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1949: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1950: IF l_debug_on THEN
1951: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1952: END IF;
1945: --
1946: -- Start of code for Bugfix 4070732
1947: --
1948: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1949: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1950: IF l_debug_on THEN
1951: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1952: END IF;
1953:
1947: --
1948: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1949: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1950: IF l_debug_on THEN
1951: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1952: END IF;
1953:
1954: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1955: x_return_status => l_return_status);
1950: IF l_debug_on THEN
1951: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1952: END IF;
1953:
1954: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1955: x_return_status => l_return_status);
1956:
1957:
1958: IF l_debug_on THEN
1978: --
1979: WHEN OTHERS THEN
1980: ROLLBACK TO AUTOCREATE_DEL_GRP;
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: wsh_util_core.add_message(x_return_status, l_module_name);
1983: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries');
1984: --
1985: -- Start of code for Bugfix 4070732
1986: --
1979: WHEN OTHERS THEN
1980: ROLLBACK TO AUTOCREATE_DEL_GRP;
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: wsh_util_core.add_message(x_return_status, l_module_name);
1983: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries');
1984: --
1985: -- Start of code for Bugfix 4070732
1986: --
1987: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1983: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries');
1984: --
1985: -- Start of code for Bugfix 4070732
1986: --
1987: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1988: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1989: IF l_debug_on THEN
1990: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1991: END IF;
1984: --
1985: -- Start of code for Bugfix 4070732
1986: --
1987: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1988: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1989: IF l_debug_on THEN
1990: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1991: END IF;
1992:
1986: --
1987: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1988: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1989: IF l_debug_on THEN
1990: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1991: END IF;
1992:
1993: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1994: x_return_status => l_return_status);
1989: IF l_debug_on THEN
1990: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1991: END IF;
1992:
1993: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1994: x_return_status => l_return_status);
1995:
1996:
1997: IF l_debug_on THEN
2024: , p_commit IN VARCHAR2
2025: , x_return_status OUT NOCOPY VARCHAR2
2026: , x_msg_count OUT NOCOPY NUMBER
2027: , x_msg_data OUT NOCOPY VARCHAR2
2028: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
2029: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
2030: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
2031: )
2032: IS
2025: , x_return_status OUT NOCOPY VARCHAR2
2026: , x_msg_count OUT NOCOPY NUMBER
2027: , x_msg_data OUT NOCOPY VARCHAR2
2028: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
2029: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
2030: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
2031: )
2032: IS
2033: l_api_name CONSTANT VARCHAR2(30):= 'Autocreate_del_trip';
2026: , x_msg_count OUT NOCOPY NUMBER
2027: , x_msg_data OUT NOCOPY VARCHAR2
2028: , p_line_rows IN WSH_UTIL_CORE.id_tab_type
2029: , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
2030: , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
2031: )
2032: IS
2033: l_api_name CONSTANT VARCHAR2(30):= 'Autocreate_del_trip';
2034: l_api_version_number CONSTANT NUMBER := 1.0;
2035: l_return_status VARCHAR2(30);
2036: autocreate_trip_failed EXCEPTION;
2037: l_msg_summary varchar2(2000) := NULL;
2038: l_msg_details varchar2(4000) := NULL;
2039: l_org_rows wsh_util_core.id_tab_type; -- bug 1668578
2040: l_number_of_errors NUMBER := 0;
2041: l_number_of_warnings NUMBER := 0;
2042: l_msg_data VARCHAR2(32767);
2043: --
2078: -- Check p_init_msg_list
2079: IF FND_API.to_boolean(p_init_msg_list) THEN
2080: FND_MSG_PUB.initialize;
2081: END IF;
2082: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2083:
2084: IF l_debug_on THEN
2085: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_DEL_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
2086: END IF;
2091: x_del_rows => x_del_rows,
2092: x_trip_rows => x_trip_rows,
2093: x_return_status => l_return_status);
2094:
2095: wsh_util_core.api_post_call(
2096: p_return_status => l_return_status,
2097: x_num_warnings => l_number_of_warnings,
2098: x_num_errors => l_number_of_errors,
2099: p_msg_data => l_msg_data
2103: IF l_number_of_warnings > 0 THEN
2104: IF l_debug_on THEN
2105: wsh_debug_sv.log(l_module_name,'Number of warnings', l_number_of_warnings);
2106: END IF;
2107: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2108: END IF;
2109:
2110:
2111: FND_MSG_PUB.Count_And_Get
2142: END IF;
2143: --
2144: WHEN autocreate_trip_failed THEN
2145: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2147: wsh_util_core.add_message(x_return_status);
2148: FND_MSG_PUB.Count_And_Get
2149: (
2150: p_count => x_msg_count,
2143: --
2144: WHEN autocreate_trip_failed THEN
2145: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2147: wsh_util_core.add_message(x_return_status);
2148: FND_MSG_PUB.Count_And_Get
2149: (
2150: p_count => x_msg_count,
2151: p_data => x_msg_data,
2155: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_TRIP_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2156: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_TRIP_FAILED');
2157: END IF;
2158: --
2159: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2160: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2161: FND_MSG_PUB.Count_And_Get
2162: (
2163: p_count => x_msg_count,
2156: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_TRIP_FAILED');
2157: END IF;
2158: --
2159: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2160: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2161: FND_MSG_PUB.Count_And_Get
2162: (
2163: p_count => x_msg_count,
2164: p_data => x_msg_data,
2165: p_encoded => FND_API.G_FALSE
2166: );
2167: --
2168: IF l_debug_on THEN
2169: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2170: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2171: END IF;
2172: --
2173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2166: );
2167: --
2168: IF l_debug_on THEN
2169: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2170: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2171: END IF;
2172: --
2173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2174: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2188: --
2189: WHEN OTHERS THEN
2190: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2192: wsh_util_core.add_message(x_return_status, l_module_name);
2193: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Del_Trip');
2194: FND_MSG_PUB.Count_And_Get
2195: (
2196: p_count => x_msg_count,
2189: WHEN OTHERS THEN
2190: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2192: wsh_util_core.add_message(x_return_status, l_module_name);
2193: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Del_Trip');
2194: FND_MSG_PUB.Count_And_Get
2195: (
2196: p_count => x_msg_count,
2197: p_data => x_msg_data,
2253: l_index NUMBER;
2254: check_status NUMBER;
2255:
2256: -- Variables for pack, unpack, auto-pack
2257: l_group_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2258: l_entity_type VARCHAR2(32767);
2259: l_cont_flag VARCHAR2(32767);
2260: l_container_name VARCHAR2(32767);
2261: l_delivery_flag VARCHAR2(32767);
2262: l_cont_instance_id NUMBER;
2263:
2264:
2265: -- Variables for cycle_count
2266: l_bo_rows WSH_UTIL_CORE.Id_Tab_Type;
2267: l_bo_qtys WSH_UTIL_CORE.Id_Tab_Type;
2268: l_req_qtys WSH_UTIL_CORE.Id_Tab_Type;
2269: l_bo_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2270: l_overpick_qtys WSH_UTIL_CORE.Id_Tab_Type;
2263:
2264:
2265: -- Variables for cycle_count
2266: l_bo_rows WSH_UTIL_CORE.Id_Tab_Type;
2267: l_bo_qtys WSH_UTIL_CORE.Id_Tab_Type;
2268: l_req_qtys WSH_UTIL_CORE.Id_Tab_Type;
2269: l_bo_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2270: l_overpick_qtys WSH_UTIL_CORE.Id_Tab_Type;
2271: l_overpick_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2264:
2265: -- Variables for cycle_count
2266: l_bo_rows WSH_UTIL_CORE.Id_Tab_Type;
2267: l_bo_qtys WSH_UTIL_CORE.Id_Tab_Type;
2268: l_req_qtys WSH_UTIL_CORE.Id_Tab_Type;
2269: l_bo_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2270: l_overpick_qtys WSH_UTIL_CORE.Id_Tab_Type;
2271: l_overpick_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2272:
2265: -- Variables for cycle_count
2266: l_bo_rows WSH_UTIL_CORE.Id_Tab_Type;
2267: l_bo_qtys WSH_UTIL_CORE.Id_Tab_Type;
2268: l_req_qtys WSH_UTIL_CORE.Id_Tab_Type;
2269: l_bo_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2270: l_overpick_qtys WSH_UTIL_CORE.Id_Tab_Type;
2271: l_overpick_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2272:
2273: --
2266: l_bo_rows WSH_UTIL_CORE.Id_Tab_Type;
2267: l_bo_qtys WSH_UTIL_CORE.Id_Tab_Type;
2268: l_req_qtys WSH_UTIL_CORE.Id_Tab_Type;
2269: l_bo_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2270: l_overpick_qtys WSH_UTIL_CORE.Id_Tab_Type;
2271: l_overpick_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2272:
2273: --
2274: l_released_status VARCHAR2(32767);
2267: l_bo_qtys WSH_UTIL_CORE.Id_Tab_Type;
2268: l_req_qtys WSH_UTIL_CORE.Id_Tab_Type;
2269: l_bo_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2270: l_overpick_qtys WSH_UTIL_CORE.Id_Tab_Type;
2271: l_overpick_qtys2 WSH_UTIL_CORE.Id_Tab_Type;
2272:
2273: --
2274: l_released_status VARCHAR2(32767);
2275: l_line_direction VARCHAR2(32767);
2291: l_manual_split VARCHAR2(1);
2292: l_converted_flag VARCHAR2(1); -- HW OPM
2293:
2294: --
2295: l_validation_level_tab WSH_UTIL_CORE.Id_Tab_Type;
2296: l_id_tab WSH_UTIL_CORE.Id_Tab_Type;
2297: l_dummy_ids WSH_UTIL_CORE.Id_Tab_Type;
2298: l_request_ids WSH_UTIL_CORE.Id_Tab_Type;
2299: l_valid_ids WSH_UTIL_CORE.Id_Tab_Type;
2292: l_converted_flag VARCHAR2(1); -- HW OPM
2293:
2294: --
2295: l_validation_level_tab WSH_UTIL_CORE.Id_Tab_Type;
2296: l_id_tab WSH_UTIL_CORE.Id_Tab_Type;
2297: l_dummy_ids WSH_UTIL_CORE.Id_Tab_Type;
2298: l_request_ids WSH_UTIL_CORE.Id_Tab_Type;
2299: l_valid_ids WSH_UTIL_CORE.Id_Tab_Type;
2300: l_error_ids WSH_UTIL_CORE.Id_Tab_Type;
2293:
2294: --
2295: l_validation_level_tab WSH_UTIL_CORE.Id_Tab_Type;
2296: l_id_tab WSH_UTIL_CORE.Id_Tab_Type;
2297: l_dummy_ids WSH_UTIL_CORE.Id_Tab_Type;
2298: l_request_ids WSH_UTIL_CORE.Id_Tab_Type;
2299: l_valid_ids WSH_UTIL_CORE.Id_Tab_Type;
2300: l_error_ids WSH_UTIL_CORE.Id_Tab_Type;
2301: l_valid_index_tab WSH_UTIL_CORE.Id_Tab_Type;
2294: --
2295: l_validation_level_tab WSH_UTIL_CORE.Id_Tab_Type;
2296: l_id_tab WSH_UTIL_CORE.Id_Tab_Type;
2297: l_dummy_ids WSH_UTIL_CORE.Id_Tab_Type;
2298: l_request_ids WSH_UTIL_CORE.Id_Tab_Type;
2299: l_valid_ids WSH_UTIL_CORE.Id_Tab_Type;
2300: l_error_ids WSH_UTIL_CORE.Id_Tab_Type;
2301: l_valid_index_tab WSH_UTIL_CORE.Id_Tab_Type;
2302: l_valid_ids_tab WSH_UTIL_CORE.Id_Tab_Type;
2295: l_validation_level_tab WSH_UTIL_CORE.Id_Tab_Type;
2296: l_id_tab WSH_UTIL_CORE.Id_Tab_Type;
2297: l_dummy_ids WSH_UTIL_CORE.Id_Tab_Type;
2298: l_request_ids WSH_UTIL_CORE.Id_Tab_Type;
2299: l_valid_ids WSH_UTIL_CORE.Id_Tab_Type;
2300: l_error_ids WSH_UTIL_CORE.Id_Tab_Type;
2301: l_valid_index_tab WSH_UTIL_CORE.Id_Tab_Type;
2302: l_valid_ids_tab WSH_UTIL_CORE.Id_Tab_Type;
2303: --
2296: l_id_tab WSH_UTIL_CORE.Id_Tab_Type;
2297: l_dummy_ids WSH_UTIL_CORE.Id_Tab_Type;
2298: l_request_ids WSH_UTIL_CORE.Id_Tab_Type;
2299: l_valid_ids WSH_UTIL_CORE.Id_Tab_Type;
2300: l_error_ids WSH_UTIL_CORE.Id_Tab_Type;
2301: l_valid_index_tab WSH_UTIL_CORE.Id_Tab_Type;
2302: l_valid_ids_tab WSH_UTIL_CORE.Id_Tab_Type;
2303: --
2304: --anxsharm for load tender
2297: l_dummy_ids WSH_UTIL_CORE.Id_Tab_Type;
2298: l_request_ids WSH_UTIL_CORE.Id_Tab_Type;
2299: l_valid_ids WSH_UTIL_CORE.Id_Tab_Type;
2300: l_error_ids WSH_UTIL_CORE.Id_Tab_Type;
2301: l_valid_index_tab WSH_UTIL_CORE.Id_Tab_Type;
2302: l_valid_ids_tab WSH_UTIL_CORE.Id_Tab_Type;
2303: --
2304: --anxsharm for load tender
2305: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
2298: l_request_ids WSH_UTIL_CORE.Id_Tab_Type;
2299: l_valid_ids WSH_UTIL_CORE.Id_Tab_Type;
2300: l_error_ids WSH_UTIL_CORE.Id_Tab_Type;
2301: l_valid_index_tab WSH_UTIL_CORE.Id_Tab_Type;
2302: l_valid_ids_tab WSH_UTIL_CORE.Id_Tab_Type;
2303: --
2304: --anxsharm for load tender
2305: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
2306:
2301: l_valid_index_tab WSH_UTIL_CORE.Id_Tab_Type;
2302: l_valid_ids_tab WSH_UTIL_CORE.Id_Tab_Type;
2303: --
2304: --anxsharm for load tender
2305: l_trip_id_tab WSH_UTIL_CORE.Id_Tab_Type;
2306:
2307: l_dlvy_organization_id NUMBER;
2308: l_dlvy_status_code VARCHAR2(32767);
2309: l_dlvy_planned_flag VARCHAR2(32767);
2310: l_dlvy_shipment_direction VARCHAR2(30);
2311: --
2312: l_detail_rec_tab WSH_DETAILS_VALIDATIONS.detail_rec_tab_type;
2313: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
2314: l_det_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2315: l_detail_group_params wsh_delivery_autocreate.grp_attr_rec_type;
2316:
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2317: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2318: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2319: l_action_rec wsh_delivery_autocreate.action_rec_type;
2320: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2323:
2324: -- Consolidation of BO Delivery details project
2325: l_line_ids WSH_UTIL_CORE.Id_Tab_Type;
2321: l_matched_entities wsh_util_core.id_tab_type;
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2323:
2324: -- Consolidation of BO Delivery details project
2325: l_line_ids WSH_UTIL_CORE.Id_Tab_Type;
2326: l_cons_flags WSH_UTIL_CORE.Column_Tab_Type;
2327: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2328:
2329: CURSOR det_cur(p_del_det_id NUMBER) IS
2322: l_out_rec wsh_delivery_autocreate.out_rec_type;
2323:
2324: -- Consolidation of BO Delivery details project
2325: l_line_ids WSH_UTIL_CORE.Id_Tab_Type;
2326: l_cons_flags WSH_UTIL_CORE.Column_Tab_Type;
2327: l_global_param_rec WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2328:
2329: CURSOR det_cur(p_del_det_id NUMBER) IS
2330: SELECT inventory_item_id
2388:
2389:
2390: b_cc_linefailed boolean;
2391: b_cc_groupidexists boolean;
2392: l_id_tab_temp wsh_util_core.id_tab_type;
2393: l_id_tab_t wsh_util_core.id_tab_type;
2394: l_cc_count_success NUMBER;
2395: l_cc_count_group_ids NUMBER;
2396: l_cc_count_rec NUMBER;
2389:
2390: b_cc_linefailed boolean;
2391: b_cc_groupidexists boolean;
2392: l_id_tab_temp wsh_util_core.id_tab_type;
2393: l_id_tab_t wsh_util_core.id_tab_type;
2394: l_cc_count_success NUMBER;
2395: l_cc_count_group_ids NUMBER;
2396: l_cc_count_rec NUMBER;
2397: l_cc_group_ids wsh_util_core.id_tab_type;
2393: l_id_tab_t wsh_util_core.id_tab_type;
2394: l_cc_count_success NUMBER;
2395: l_cc_count_group_ids NUMBER;
2396: l_cc_count_rec NUMBER;
2397: l_cc_group_ids wsh_util_core.id_tab_type;
2398:
2399: l_cc_upd_dlvy_intmed_ship_to VARCHAR2(1);
2400: l_cc_upd_dlvy_ship_method VARCHAR2(1);
2401: l_cc_dlvy_intmed_ship_to NUMBER;
2402: l_cc_dlvy_ship_method VARCHAR2(30);
2403:
2404: l_cc_count_del_rows NUMBER;
2405: l_num_errors NUMBER;
2406: l_cc_del_rows wsh_util_core.id_tab_type;
2407: l_cc_grouping_rows wsh_util_core.id_tab_type;
2408: l_cc_return_status VARCHAR2(1);
2409: l_trip_id NUMBER;
2410:
2403:
2404: l_cc_count_del_rows NUMBER;
2405: l_num_errors NUMBER;
2406: l_cc_del_rows wsh_util_core.id_tab_type;
2407: l_cc_grouping_rows wsh_util_core.id_tab_type;
2408: l_cc_return_status VARCHAR2(1);
2409: l_trip_id NUMBER;
2410:
2411: --dummy tables for calling validate_constraint_mainper
2412: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;
2417: l_cc_fail_ids wsh_util_core.id_tab_type;
2418:
2419: l_delivery_detail_id NUMBER;
2420:
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;
2417: l_cc_fail_ids wsh_util_core.id_tab_type;
2418:
2419: l_delivery_detail_id NUMBER;
2420:
2421: CURSOR c_delcur(p_dlvy_id NUMBER) IS
2427:
2428: l_action_code VARCHAR2(32767);
2429: --
2430: -- deliveryMerge
2431: l_delivery_ids wsh_util_core.id_tab_type;
2432: l_delivery_id NUMBER;
2433: l_delivery_already_included boolean;
2434: --
2435: --
2436: l_cnt NUMBER;
2437: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
2438: --
2439:
2440: l_dummy_line_ids WSH_UTIL_CORE.Id_Tab_Type;
2441:
2442: e_end_of_api EXCEPTION;
2443: --dcp
2444: l_check_dcp NUMBER;
2466: --dcp
2467: <
2468:
2469: -- Bugfix 4070732
2470: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
2471: THEN
2472: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
2473: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
2474: END IF;
2468:
2469: -- Bugfix 4070732
2470: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
2471: THEN
2472: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
2473: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
2474: END IF;
2475: -- End of Code Bugfix 4070732
2476:
2469: -- Bugfix 4070732
2470: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
2471: THEN
2472: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
2473: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
2474: END IF;
2475: -- End of Code Bugfix 4070732
2476:
2477: -- Standard Start of API savepoint
2517: END IF;
2518: END IF;
2519: --
2520: -- Initialize API return status to success
2521: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2522: l_number_of_errors := 0;
2523: l_number_of_warnings := 0;
2524:
2525: -- deliveryMerge
2528: -- Mandatory parameters check
2529: IF( p_action_prms.caller IS NULL) THEN
2530: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2531: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CALLER');
2532: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2533: IF l_debug_on THEN
2534: wsh_debug_sv.logmsg(l_module_name,'Null Caller');
2535: END IF;
2536: RAISE FND_API.G_EXC_ERROR;
2536: RAISE FND_API.G_EXC_ERROR;
2537: ELSIF(p_action_prms.action_code IS NULL) THEN
2538: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2539: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ACTION_CODE');
2540: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2541: IF l_debug_on THEN
2542: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
2543: END IF;
2544: RAISE FND_API.G_EXC_ERROR;
2568: THEN
2569: --{
2570: l_action_prms := p_action_prms;
2571: --
2572: l_action_prms.caller := p_action_prms.caller || WSH_UTIL_CORE.C_SPLIT_DLVY_SUFFIX;
2573: l_action_prms.action_code := 'UNASSIGN';
2574: --
2575: Delivery_Detail_Action
2576: (
2586: x_action_out_rec => x_action_out_rec
2587: );
2588: --
2589: --
2590: wsh_util_core.api_post_call
2591: (
2592: p_return_status => l_return_status,
2593: x_num_warnings => l_number_of_warnings,
2594: x_num_errors => l_number_of_errors,
2595: p_msg_data => l_msg_data
2596: );
2597: --
2598: --
2599: l_action_prms.caller := p_action_prms.caller || WSH_UTIL_CORE.C_SPLIT_DLVY_SUFFIX;
2600: --
2601: --
2602: IF p_action_prms.delivery_id IS NULL
2603: AND p_action_prms.delivery_name IS NULL
2621: x_action_out_rec => x_action_out_rec
2622: );
2623: --
2624: --
2625: wsh_util_core.api_post_call
2626: (
2627: p_return_status => l_return_status,
2628: x_num_warnings => l_number_of_warnings,
2629: x_num_errors => l_number_of_errors,
2653: );
2654:
2655: --
2656: IF l_debug_on THEN
2657: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2658: END IF;
2659: --
2660: wsh_util_core.api_post_call(
2661: p_return_status => l_return_status,
2656: IF l_debug_on THEN
2657: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2658: END IF;
2659: --
2660: wsh_util_core.api_post_call(
2661: p_return_status => l_return_status,
2662: x_num_warnings => l_number_of_warnings,
2663: x_num_errors => l_number_of_errors,
2664: p_msg_data => l_msg_data
2720: wsh_debug_sv.log(l_module_name,'Is_Action_Enabled returns',
2721: l_return_status);
2722: END IF;
2723: --
2724: wsh_util_core.api_post_call(
2725: p_return_status => l_return_status,
2726: x_num_warnings => l_number_of_warnings,
2727: x_num_errors => l_number_of_errors,
2728: p_msg_data => l_msg_data,
2733: IF(l_number_of_errors >0 ) THEN
2734: --{
2735: IF p_action_prms.caller = 'WSH_FSTRX' THEN
2736: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION');
2737: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2738: END IF;
2739: --
2740: IF l_debug_on THEN
2741: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION');
2760: IF del_cur%NOTFOUND THEN
2761: CLOSE del_cur;
2762: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERY');
2763: FND_MESSAGE.SET_TOKEN('DELIVERY', p_action_prms.delivery_id);
2764: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2765: IF l_debug_on THEN
2766: wsh_debug_sv.logmsg(l_module_name, 'Delivery does not exist');
2767: END IF;
2768: RAISE FND_API.G_EXC_ERROR;
2770: CLOSE del_cur;
2771: ELSE
2772: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2773: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'DELIVERY_ID');
2774: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2775: IF l_debug_on THEN
2776: wsh_debug_sv.logmsg(l_module_name, 'Null Delivery Id');
2777: END IF;
2778: RAISE FND_API.G_EXC_ERROR;
2806: x_error_ids => l_error_ids,
2807: x_valid_index_tab => l_valid_index_tab
2808: );
2809: --
2810: wsh_util_core.api_post_call(
2811: p_return_status => l_return_status,
2812: x_num_warnings => l_number_of_warnings,
2813: x_num_errors => l_number_of_errors,
2814: p_msg_data => l_msg_data,
2844:
2845: x_action_out_rec.valid_id_tab := l_valid_ids_tab;
2846:
2847: --
2848: wsh_util_core.api_post_call(
2849: p_return_status => l_return_status,
2850: x_num_warnings => l_number_of_warnings,
2851: x_num_errors => l_number_of_errors,
2852: p_msg_data => l_msg_data,
2857:
2858: --
2859: IF(l_number_of_errors >0 ) THEN
2860: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION');
2861: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2862: IF l_debug_on THEN
2863: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION');
2864: END IF;
2865: RAISE FND_API.G_EXC_ERROR;
2867: --
2868: IF l_number_of_warnings > 0 THEN
2869:
2870: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION_WARN');
2871: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2872: IF l_debug_on THEN
2873: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION_WARN');
2874: END IF;
2875:
2874: END IF;
2875:
2876: IF(p_action_prms.caller = 'WSH_FSTRX') THEN
2877: x_action_out_rec.selection_issue_flag := 'Y';
2878: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2879: ELSE
2880: IF l_debug_on THEN
2881: wsh_debug_sv.log(l_module_name,'Number of warnings', l_number_of_warnings);
2882: END IF;
2892: -- Autocreate trip calls autocreate del and then autocreate trip so the constraint validation
2893: -- will be done at that point (in private API)
2894: -- actions PACK, AUTO-PACK, AUTO-PACK-MASTER only post-I (constraints for these have not been implemented yet)
2895:
2896: IF wsh_util_core.fte_is_installed = 'Y' THEN
2897:
2898: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(
2899: p_api_version_number => 1.0,
2900: p_init_msg_list => FND_API.G_FALSE,
2925: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_main',l_cc_group_info.COUNT);
2926: END IF;
2927: --
2928:
2929: IF l_return_status=wsh_util_core.g_ret_sts_error THEN
2930: --fix p_rec_attr_tab to have only successful records
2931: l_cc_count_success:=1;
2932:
2933: IF l_debug_on THEN
2937: IF l_cc_failed_records.COUNT>0 AND p_rec_attr_tab.COUNT>0 THEN
2938:
2939: --set return_status as warning
2940: IF l_cc_failed_records.COUNT<>p_rec_attr_tab.COUNT THEN
2941: l_return_status:=wsh_util_core.g_ret_sts_warning;
2942: END IF;
2943:
2944: FOR i in p_rec_attr_tab.FIRST..p_rec_attr_tab.LAST LOOP
2945: b_cc_linefailed:=FALSE;
2947: IF (p_rec_attr_tab(i).delivery_detail_id=l_cc_failed_records(j).entity_line_id) THEN
2948: b_cc_linefailed:=TRUE;
2949: FND_MESSAGE.SET_NAME('WSH','WSH_DELDET_COMP_FAILED');
2950: FND_MESSAGE.SET_TOKEN('DELDET_ID',l_cc_failed_records(j).entity_line_id);
2951: wsh_util_core.add_message(l_return_status);
2952: END IF;
2953: END LOOP;
2954: IF (NOT(b_cc_linefailed)) THEN
2955: l_id_tab_t(l_cc_count_success):=p_rec_attr_tab(i).delivery_detail_id;
2960: --bsadri for assign, if one line fails, then fail all lines {
2961: IF l_action_code = 'ASSIGN'
2962: AND l_cc_failed_records.COUNT > 0 THEN
2963: l_id_tab_t.DELETE;
2964: l_return_status := wsh_util_core.g_ret_sts_error;
2965: END IF;
2966: --}
2967:
2968: IF l_id_tab_t.COUNT>0 THEN
2970: ELSE
2971: IF l_debug_on THEN
2972: wsh_debug_sv.logmsg(l_module_name,'all lines errored in compatibility check');
2973: END IF;
2974: wsh_util_core.api_post_call(
2975: p_return_status => l_return_status,
2976: x_num_warnings => l_number_of_warnings,
2977: x_num_errors => l_num_errors,
2978: p_msg_data => l_msg_data);
2983: END IF;
2984:
2985: END IF;
2986:
2987: ELSIF l_return_status=wsh_util_core.g_ret_sts_unexp_error THEN
2988: wsh_util_core.api_post_call(
2989: p_return_status => l_return_status,
2990: x_num_warnings => l_number_of_warnings,
2991: x_num_errors => l_num_errors,
2984:
2985: END IF;
2986:
2987: ELSIF l_return_status=wsh_util_core.g_ret_sts_unexp_error THEN
2988: wsh_util_core.api_post_call(
2989: p_return_status => l_return_status,
2990: x_num_warnings => l_number_of_warnings,
2991: x_num_errors => l_num_errors,
2992: p_msg_data => l_msg_data);
2991: x_num_errors => l_num_errors,
2992: p_msg_data => l_msg_data);
2993: END IF;
2994:
2995: wsh_util_core.api_post_call(
2996: p_return_status => l_return_status,
2997: x_num_warnings => l_number_of_warnings,
2998: x_num_errors => l_num_errors,
2999: p_msg_data => l_msg_data,
3039: p_released_status => l_released_status)
3040: ) THEN
3041: FND_MESSAGE.SET_NAME('WSH', 'WSH_OPM_LOT_INDIVISIBLE');
3042: IF p_action_prms.caller = 'WSH_FSTRX' THEN
3043: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3044: END IF;
3045: RAISE FND_API.G_EXC_ERROR;
3046: END IF;
3047: END IF;
3066:
3067: IF p_action_prms.action_code IN('SPLIT-LINE', 'CYCLE-COUNT', 'PICK-RELEASE-UI', 'RESOLVE-EXCEPTIONS-UI') THEN
3068: IF(p_rec_attr_tab.count > 1) THEN
3069: FND_MESSAGE.SET_NAME('WSH','WSH_UI_MULTI_SELECTION');
3070: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3071: IF l_debug_on THEN
3072: wsh_debug_sv.logmsg(l_module_name,'WSH_UI_MULTI_SELECTION');
3073: END IF;
3074: RAISE FND_API.G_EXC_ERROR;
3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.log(l_module_name, 'return status after calling check_assign_del_multi', l_return_status);
3098: WSH_DEBUG_SV.log(l_module_name, 'group id', l_detail_group_params.group_id);
3099: END IF;
3100: wsh_util_core.api_post_call(
3101: p_return_status => l_return_status,
3102: x_num_warnings => l_number_of_warnings,
3103: x_num_errors => l_number_of_errors,
3104: p_msg_data => l_msg_data
3122: x_matched_entities => l_matched_entities,
3123: x_out_rec => l_out_rec,
3124: x_return_status => l_return_status);
3125:
3126: wsh_util_core.api_post_call(
3127: p_return_status => l_return_status,
3128: x_num_warnings => l_number_of_warnings,
3129: x_num_errors => l_number_of_errors,
3130: p_msg_data => l_msg_data
3162: p_action_prms => p_action_prms);
3163:
3164:
3165: --
3166: wsh_util_core.api_post_call(
3167: p_return_status => l_return_status,
3168: x_num_warnings => l_number_of_warnings,
3169: x_num_errors => l_number_of_errors,
3170: p_msg_data => l_msg_data
3169: x_num_errors => l_number_of_errors,
3170: p_msg_data => l_msg_data
3171: );
3172:
3173: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)
3174: AND p_action_prms.action_code = 'ASSIGN' ) THEN
3175: IF l_debug_on THEN
3176: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERY_ACTIONS.ASSIGN_DELIVERY_UPDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
3177: END IF;
3180: p_delivery_id => p_action_prms.delivery_id,
3181: p_del_params => l_detail_group_params,
3182: x_return_status => l_return_status);
3183:
3184: wsh_util_core.api_post_call(
3185: p_return_status => l_return_status,
3186: x_num_warnings => l_number_of_warnings,
3187: x_num_errors => l_number_of_errors,
3188: p_msg_data => l_msg_data
3199: --
3200: --
3201: IF(nvl(p_action_prms.split_quantity,0) =0) THEN
3202: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ZERO_NUM');
3203: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3204: IF l_debug_on THEN
3205: wsh_debug_sv.logmsg(l_module_name,'Zero or Null split quantity');
3206: END IF;
3207: RAISE FND_API.G_EXC_ERROR;
3254: x_msg_count => l_msg_count,
3255: x_msg_data => l_msg_data
3256: );
3257: --
3258: wsh_util_core.api_post_call(
3259: p_return_status => l_return_status,
3260: x_num_warnings => l_number_of_warnings,
3261: x_num_errors => l_number_of_errors,
3262: p_msg_data => l_msg_data
3298: x_action_out_rec.split_quantity := l_split_quantity;
3299: x_action_out_rec.split_quantity2 := l_split_quantity2;
3300:
3301: --
3302: wsh_util_core.api_post_call(
3303: p_return_status => l_return_status,
3304: x_num_warnings => l_number_of_warnings,
3305: x_num_errors => l_number_of_errors,
3306: p_msg_data => l_msg_data
3313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
3314: END IF;
3315: --
3316: --Compatibility Changes
3317: IF wsh_util_core.fte_is_installed = 'Y' AND l_cc_line_groups.COUNT>0 THEN
3318:
3319: --1. get the group ids by which the constraints API has grouped the lines
3320: l_cc_count_group_ids:=1;
3321: FOR i in l_cc_line_groups.FIRST..l_cc_line_groups.LAST LOOP
3421: END LOOP;
3422: END IF;
3423: END IF;
3424:
3425: IF (l_cc_return_status is not null AND l_cc_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3426: l_return_status:=l_cc_return_status;
3427: ELSIF (l_cc_return_status is not null AND l_cc_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING AND l_return_status=WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3428: l_return_status:=l_cc_return_status;
3429: ELSE
3423: END IF;
3424:
3425: IF (l_cc_return_status is not null AND l_cc_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3426: l_return_status:=l_cc_return_status;
3427: ELSIF (l_cc_return_status is not null AND l_cc_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING AND l_return_status=WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3428: l_return_status:=l_cc_return_status;
3429: ELSE
3430: l_cc_return_status:=l_return_status;
3431: END IF;
3460: wsh_debug_sv.log(l_module_name,'Return Status After Calling Autocreate_Deliveries',l_return_status);
3461: END IF;
3462:
3463: --
3464: wsh_util_core.api_post_call(
3465: p_return_status => l_return_status,
3466: x_num_warnings => l_number_of_warnings,
3467: x_num_errors => l_number_of_errors,
3468: p_msg_data => l_msg_data
3475: p_force_appending_limit => 'N',
3476: p_call_lcss => 'Y',
3477: x_return_status => l_return_status);
3478:
3479: wsh_util_core.api_post_call(
3480: p_return_status => l_return_status,
3481: x_num_warnings => l_number_of_warnings,
3482: x_num_errors => l_number_of_errors,
3483: p_msg_data => l_msg_data
3500: x_del_rows => x_action_out_rec.delivery_id_tab,
3501: x_trip_rows => x_action_out_rec.result_id_tab);
3502:
3503: --
3504: wsh_util_core.api_post_call(
3505: p_return_status => l_return_status,
3506: x_num_warnings => l_number_of_warnings,
3507: x_num_errors => l_number_of_errors,
3508: p_msg_data => l_msg_data
3518: IF l_debug_on THEN
3519: wsh_debug_sv.log(l_module_name,'Return Status After Calling change_ignoreplan_status ',l_return_status);
3520: END IF;
3521: --
3522: wsh_util_core.api_post_call(
3523: p_return_status => l_return_status,
3524: x_num_warnings => l_number_of_warnings,
3525: x_num_errors => l_number_of_errors);
3526: --
3545: x_request_ids => l_request_ids,
3546: x_return_status => l_return_status);
3547:
3548: --
3549: wsh_util_core.api_post_call(
3550: p_return_status => l_return_status,
3551: x_num_warnings => l_number_of_warnings,
3552: x_num_errors => l_number_of_errors,
3553: p_msg_data => l_msg_data
3572: x_return_status => l_return_status,
3573: p_auto_pack_ship => 'PS');
3574:
3575: --
3576: wsh_util_core.api_post_call(
3577: p_return_status => l_return_status,
3578: x_num_warnings => l_number_of_warnings,
3579: x_num_errors => l_number_of_errors,
3580: p_msg_data => l_msg_data
3599: x_return_status => l_return_status,
3600: p_auto_pack_ship => 'SC');
3601:
3602: --
3603: wsh_util_core.api_post_call(
3604: p_return_status => l_return_status,
3605: x_num_warnings => l_number_of_warnings,
3606: x_num_errors => l_number_of_errors,
3607: p_msg_data => l_msg_data
3614: -- This change was introduced to mark the G_RESET_WV flag
3615: -- before calling detail_weight_volume so the procedure will know
3616: -- to invoke update tms_interface_flag process.
3617:
3618: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
3619: IF l_gc3_is_installed IS NULL THEN
3620: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
3621: END IF;
3622:
3616: -- to invoke update tms_interface_flag process.
3617:
3618: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
3619: IF l_gc3_is_installed IS NULL THEN
3620: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
3621: END IF;
3622:
3623: IF l_gc3_is_installed = 'Y' THEN
3624: WSH_WV_UTILS.G_RESET_WV := 'Y'; -- set to Y to enable the update
3634: p_override_flag => 'Y', -- Need to see if we can Use p_action_prms.wv_override_flag
3635: x_return_status => l_return_status);
3636:
3637: --
3638: wsh_util_core.api_post_call(
3639: p_return_status => l_return_status,
3640: x_num_warnings => l_number_of_warnings,
3641: x_num_errors => l_number_of_errors,
3642: p_msg_data => l_msg_data
3678: p_action_code => 'PACK',
3679: p_caller => p_action_prms.caller);
3680:
3681: --
3682: wsh_util_core.api_post_call(
3683: p_return_status => l_return_status,
3684: x_num_warnings => l_number_of_warnings,
3685: x_num_errors => l_number_of_errors,
3686: p_msg_data => l_msg_data
3726: WSH_DEBUG_SV.log(l_module_name,'Adjust_Planned_Flag returns ',l_return_status);
3727: END IF;
3728: END IF;
3729:
3730: wsh_util_core.api_post_call(
3731: p_return_status => l_return_status,
3732: x_num_warnings => l_number_of_warnings,
3733: x_num_errors => l_number_of_errors,
3734: p_msg_data => l_msg_data
3757: p_pack_cont_flag => 'N' ,
3758: x_cont_inst_tab => x_action_out_rec.result_id_tab);
3759:
3760: --
3761: wsh_util_core.api_post_call(
3762: p_return_status => l_return_status,
3763: x_num_warnings => l_number_of_warnings,
3764: x_num_errors => l_number_of_errors,
3765: p_msg_data => l_msg_data
3791: x_cont_inst_tab => x_action_out_rec.result_id_tab);
3792:
3793: -- Handle return status
3794: --
3795: wsh_util_core.api_post_call(
3796: p_return_status => l_return_status,
3797: x_num_warnings => l_number_of_warnings,
3798: x_num_errors => l_number_of_errors,
3799: p_msg_data => l_msg_data
3853: p_action_code => 'UNPACK',
3854: p_caller => p_action_prms.caller);
3855:
3856: --
3857: wsh_util_core.api_post_call(
3858: p_return_status => l_return_status,
3859: x_num_warnings => l_number_of_warnings,
3860: x_num_errors => l_number_of_errors,
3861: p_msg_data => l_msg_data
3874: WSH_DEBUG_SV.log(l_module_name,'Adjust_Planned_Flag returns ',l_return_status);
3875: END IF;
3876: END IF;
3877:
3878: wsh_util_core.api_post_call(
3879: p_return_status => l_return_status,
3880: x_num_warnings => l_number_of_warnings,
3881: x_num_errors => l_number_of_errors,
3882: p_msg_data => l_msg_data);
3917: IF l_debug_on THEN
3918: wsh_debug_sv.logmsg(l_module_name,'Incorrect Released status or incorrect quantities');
3919: END IF;
3920: fnd_message.set_name('WSH', 'WSH_CC_RSV_INSUFF');
3921: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3922: raise FND_API.G_EXC_ERROR;
3923: END IF;
3924: --
3925: --
3942: ) THEN
3943: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_PARTIAL_CYCLE_COUNT');
3944:
3945: IF p_action_prms.caller = 'WSH_FSTRX' THEN
3946: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3947: END IF;
3948: RAISE FND_API.G_EXC_ERROR;
3949: END IF;
3950:
3976: IF l_debug_on THEN
3977: wsh_debug_sv.logmsg(l_module_name,'Incorrect quantities');
3978: END IF;
3979: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_SPLIT_EXCEED');
3980: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3981: raise FND_API.G_EXC_ERROR;
3982:
3983: END IF;
3984:
4029: x_output_quantity => l_output_quantity,
4030: x_return_status => l_return_status);
4031:
4032: IF l_debug_on THEN
4033: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4034: END IF;
4035: --
4036:
4037: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
4033: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
4034: END IF;
4035: --
4036:
4037: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
4038: raise FND_API.G_EXC_ERROR;
4039: END IF;
4040:
4041: --
4063: x_return_status => l_return_status);
4064:
4065: -- Handle return status
4066: -- set message if necessary
4067: wsh_util_core.api_post_call(
4068: p_return_status => l_return_status,
4069: x_num_warnings => l_number_of_warnings,
4070: x_num_errors => l_number_of_errors,
4071: p_msg_data => l_msg_data
4087: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(l_global_param_rec, l_return_status);
4088:
4089: -- Handle return status
4090: -- set message if necessary
4091: wsh_util_core.api_post_call(
4092: p_return_status => l_return_status,
4093: x_num_warnings => l_number_of_warnings,
4094: x_num_errors => l_number_of_errors,
4095: p_msg_data => l_msg_data
4120: ELSIF p_action_prms.action_code = 'DELETE' THEN
4121: --{
4122: IF l_debug_on THEN
4123: --{
4124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Delete',WSH_DEBUG_SV.C_PROC_LEVEL);
4125: --}
4126: END IF;
4127: --
4128: WSH_UTIL_CORE.Delete(
4124: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Delete',WSH_DEBUG_SV.C_PROC_LEVEL);
4125: --}
4126: END IF;
4127: --
4128: WSH_UTIL_CORE.Delete(
4129: p_type => 'DLVB',
4130: p_rows => l_id_tab,
4131: x_return_status => l_return_status);
4132: --
4135: wsh_debug_sv.log(l_module_name,'Return Status After Calling Delete',l_return_status);
4136: --}
4137: END IF;
4138: --
4139: wsh_util_core.api_post_call(
4140: p_return_status => l_return_status,
4141: x_num_warnings => l_number_of_warnings,
4142: x_num_errors => l_number_of_errors);
4143:
4146: ELSE
4147: --
4148: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
4149: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code );
4150: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4151: IF l_debug_on THEN
4152: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
4153: END IF;
4154: RAISE FND_API.G_EXC_ERROR;
4234: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
4235: END IF;
4236: --
4237: --
4238: WSH_UTIL_CORE.API_POST_CALL
4239: (
4240: p_return_status => l_return_status,
4241: x_num_warnings => l_number_of_warnings,
4242: x_num_errors => l_number_of_errors,
4251: IF l_number_of_warnings > 0 THEN
4252: IF l_debug_on THEN
4253: wsh_debug_sv.log (l_module_name,'Number of warnings', l_number_of_warnings);
4254: END IF;
4255: -- RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4256: l1_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4257: ELSE
4258: l1_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4259: END IF;
4252: IF l_debug_on THEN
4253: wsh_debug_sv.log (l_module_name,'Number of warnings', l_number_of_warnings);
4254: END IF;
4255: -- RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4256: l1_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4257: ELSE
4258: l1_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4259: END IF;
4260: --
4254: END IF;
4255: -- RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4256: l1_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4257: ELSE
4258: l1_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4259: END IF;
4260: --
4261: -- Standard check of p_commit.
4262: IF FND_API.To_Boolean( p_commit ) THEN
4265: END IF;
4266: --
4267: -- Start code for Bugfix 4070732
4268: --
4269: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4270: IF l_debug_on THEN
4271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4272: END IF;
4273:
4267: -- Start code for Bugfix 4070732
4268: --
4269: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4270: IF l_debug_on THEN
4271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4272: END IF;
4273:
4274: l_reset_flags := FALSE;
4275: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
4271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4272: END IF;
4273:
4274: l_reset_flags := FALSE;
4275: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
4276: x_return_status => l_return_status);
4277:
4278: IF l_debug_on THEN
4279: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4278: IF l_debug_on THEN
4279: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4280: END IF;
4281:
4282: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4283: l1_return_status := l_return_status;
4284: END IF;
4285:
4286: END IF;
4292: END IF;
4293:
4294: --bug 4070732
4295: --End of the API handling of calls to process_stops_for_load_tender
4296: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
4297: --{
4298: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4299: --{
4300:
4294: --bug 4070732
4295: --End of the API handling of calls to process_stops_for_load_tender
4296: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
4297: --{
4298: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4299: --{
4300:
4301: IF FND_API.To_Boolean( p_commit ) THEN
4302: IF l_debug_on THEN
4299: --{
4300:
4301: IF FND_API.To_Boolean( p_commit ) THEN
4302: IF l_debug_on THEN
4303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4304: END IF;
4305:
4306: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,
4307: x_return_status => l_return_status);
4302: IF l_debug_on THEN
4303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4304: END IF;
4305:
4306: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,
4307: x_return_status => l_return_status);
4308:
4309: ELSE
4310: IF l_debug_on THEN
4307: x_return_status => l_return_status);
4308:
4309: ELSE
4310: IF l_debug_on THEN
4311: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4312: END IF;
4313:
4314: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
4315: x_return_status => l_return_status);
4310: IF l_debug_on THEN
4311: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4312: END IF;
4313:
4314: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
4315: x_return_status => l_return_status);
4316:
4317: END IF;
4318:
4319: IF l_debug_on THEN
4320: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4321: END IF;
4322:
4323: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4324: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4325: IF l1_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4326: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4327: l1_return_status := l_return_status;
4320: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4321: END IF;
4322:
4323: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4324: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4325: IF l1_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4326: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4327: l1_return_status := l_return_status;
4328: END IF;
4321: END IF;
4322:
4323: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4324: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4325: IF l1_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4326: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4327: l1_return_status := l_return_status;
4328: END IF;
4329: ELSE
4322:
4323: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4324: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4325: IF l1_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4326: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4327: l1_return_status := l_return_status;
4328: END IF;
4329: ELSE
4330: l1_return_status := l_return_status;
4379: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
4380: END IF;
4381: --
4382: --
4383: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4384: x_return_status := l_return_status;
4385: END IF;
4386: --
4387: --}
4391: --
4392: --
4393: -- Start code for Bugfix 4070732
4394: --
4395: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
4396: THEN
4397: --{
4398: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4399: --{
4394: --
4395: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
4396: THEN
4397: --{
4398: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4399: --{
4400: IF l_debug_on THEN
4401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4402: END IF;
4397: --{
4398: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4399: --{
4400: IF l_debug_on THEN
4401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4402: END IF;
4403:
4404: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
4405: x_return_status => l_return_status);
4400: IF l_debug_on THEN
4401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4402: END IF;
4403:
4404: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
4405: x_return_status => l_return_status);
4406:
4407: IF l_debug_on THEN
4408: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4407: IF l_debug_on THEN
4408: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4409: END IF;
4410:
4411: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4412: x_return_status := l_return_status;
4413: END IF;
4414: --}
4415: END IF;
4469: --
4470: --
4471: -- Start code for Bugfix 4070732
4472: --
4473: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
4474: THEN
4475: --{
4476: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4477: --{
4472: --
4473: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
4474: THEN
4475: --{
4476: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4477: --{
4478: IF l_debug_on THEN
4479: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4480: END IF;
4475: --{
4476: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4477: --{
4478: IF l_debug_on THEN
4479: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4480: END IF;
4481:
4482: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
4483: x_return_status => l_return_status);
4478: IF l_debug_on THEN
4479: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4480: END IF;
4481:
4482: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
4483: x_return_status => l_return_status);
4484:
4485: IF l_debug_on THEN
4486: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4504: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4506: END IF;
4507: --
4508: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4509: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4510: IF del_cur%ISOPEN THEN
4511: CLOSE del_cur;
4512: END IF;
4505: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4506: END IF;
4507: --
4508: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4509: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4510: IF del_cur%ISOPEN THEN
4511: CLOSE del_cur;
4512: END IF;
4513:
4533: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
4534: END IF;
4535: --
4536: --
4537: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4538: x_return_status := l_return_status;
4539: END IF;
4540: --
4541: --}
4545: --
4546: --
4547: -- Start code for Bugfix 4070732
4548: --
4549: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
4550: THEN
4551: --{
4552: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API)
4553: THEN
4548: --
4549: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
4550: THEN
4551: --{
4552: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API)
4553: THEN
4554: --{
4555: IF l_debug_on THEN
4556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4552: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API)
4553: THEN
4554: --{
4555: IF l_debug_on THEN
4556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4557: END IF;
4558:
4559: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
4560: x_return_status => l_return_status);
4555: IF l_debug_on THEN
4556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4557: END IF;
4558:
4559: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
4560: x_return_status => l_return_status);
4561:
4562: IF l_debug_on THEN
4563: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4562: IF l_debug_on THEN
4563: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4564: END IF;
4565:
4566: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4567: x_return_status := l_return_status;
4568: END IF;
4569: --}
4570: END IF;
4580: p_encoded => FND_API.G_FALSE
4581: );
4582:
4583: IF l_debug_on THEN
4584: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4585: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4586: END IF;
4587: --
4588: WHEN OTHERS THEN
4581: );
4582:
4583: IF l_debug_on THEN
4584: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4585: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4586: END IF;
4587: --
4588: WHEN OTHERS THEN
4589: IF del_cur%ISOPEN THEN
4594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4595: IF cycle_count_cur%ISOPEN THEN
4596: Close cycle_count_cur;
4597: END IF;
4598: wsh_util_core.add_message(x_return_status, l_module_name);
4599: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action');
4600: --
4601: -- K LPN CONV. rv
4602: --
4595: IF cycle_count_cur%ISOPEN THEN
4596: Close cycle_count_cur;
4597: END IF;
4598: wsh_util_core.add_message(x_return_status, l_module_name);
4599: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action');
4600: --
4601: -- K LPN CONV. rv
4602: --
4603: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
4627: --
4628: --
4629: -- Start code for Bugfix 4070732
4630: --
4631: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
4632: THEN
4633: --{
4634: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4635: --{
4630: --
4631: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
4632: THEN
4633: --{
4634: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4635: --{
4636: IF l_debug_on THEN
4637: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4638: END IF;
4633: --{
4634: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4635: --{
4636: IF l_debug_on THEN
4637: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4638: END IF;
4639:
4640: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
4641: x_return_status => l_return_status);
4636: IF l_debug_on THEN
4637: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4638: END IF;
4639:
4640: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
4641: x_return_status => l_return_status);
4642:
4643: IF l_debug_on THEN
4644: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4708: l_counter NUMBER := 0;
4709: l_index NUMBER;
4710:
4711: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4712: l_valid_index_tab wsh_util_core.id_tab_type;
4713: l_delivery_id NUMBER;
4714: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4715: l_validation_tab wsh_util_core.id_tab_type;
4716: --
4711: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
4712: l_valid_index_tab wsh_util_core.id_tab_type;
4713: l_delivery_id NUMBER;
4714: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4715: l_validation_tab wsh_util_core.id_tab_type;
4716: --
4717: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
4718: l_dummy_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
4719: mark_reprice_error EXCEPTION;
4713: l_delivery_id NUMBER;
4714: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4715: l_validation_tab wsh_util_core.id_tab_type;
4716: --
4717: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
4718: l_dummy_ser_range_tab WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType;
4719: mark_reprice_error EXCEPTION;
4720:
4721: --
4724: FROM wsh_delivery_assignments_v wda
4725: WHERE wda.delivery_detail_id = p_detail_id;
4726:
4727: -- anxsharm for Load Tender
4728: l_detail_tender_tab wsh_util_core.id_tab_type;
4729: l_trip_id_tab wsh_util_core.id_tab_type;
4730:
4731: --
4732: l_debug_on BOOLEAN;
4725: WHERE wda.delivery_detail_id = p_detail_id;
4726:
4727: -- anxsharm for Load Tender
4728: l_detail_tender_tab wsh_util_core.id_tab_type;
4729: l_trip_id_tab wsh_util_core.id_tab_type;
4730:
4731: --
4732: l_debug_on BOOLEAN;
4733: --
4767: FND_MSG_PUB.initialize;
4768: END IF;
4769:
4770: -- Initialize API return status to success
4771: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4772: l_number_of_errors := 0;
4773: l_number_of_warnings := 0;
4774:
4775: /* Call the New Overloaded API */
4786: x_OUT_rec => x_out_rec,
4787: p_serial_range_tab => l_dummy_ser_range_tab
4788: );
4789:
4790: wsh_util_core.api_post_call(
4791: p_return_status =>l_return_status,
4792: x_num_warnings =>l_number_of_warnings,
4793: x_num_errors =>l_number_of_errors);
4794:
4795: IF l_number_of_warnings > 0 THEN
4796: IF l_debug_on THEN
4797: wsh_debug_sv.log(l_module_name,'Number of warnings', l_number_of_warnings);
4798: END IF;
4799: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
4800: END IF;
4801:
4802:
4803: -- Standard check of p_commit.
4850: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4852: END IF;
4853: --
4854: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4856: FND_MSG_PUB.Count_And_Get
4857: (
4858: p_count => x_msg_count,
4851: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4852: END IF;
4853: --
4854: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4856: FND_MSG_PUB.Count_And_Get
4857: (
4858: p_count => x_msg_count,
4859: p_data => x_msg_data,
4860: p_encoded => FND_API.G_FALSE
4861: );
4862: --
4863: IF l_debug_on THEN
4864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4866: END IF;
4867: --
4868: WHEN mark_reprice_error then
4861: );
4862: --
4863: IF l_debug_on THEN
4864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4866: END IF;
4867: --
4868: WHEN mark_reprice_error then
4869: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
4866: END IF;
4867: --
4868: WHEN mark_reprice_error then
4869: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
4870: wsh_util_core.add_message(x_return_status, l_module_name);
4871: x_return_status := l_return_status;
4872: FND_MSG_PUB.Count_And_Get
4873: (
4874: p_count => x_msg_count,
4885: --
4886: WHEN OTHERS THEN
4887: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4889: wsh_util_core.add_message(x_return_status, l_module_name);
4890: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
4891: FND_MSG_PUB.Count_And_Get
4892: (
4893: p_count => x_msg_count,
4886: WHEN OTHERS THEN
4887: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4889: wsh_util_core.add_message(x_return_status, l_module_name);
4890: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
4891: FND_MSG_PUB.Count_And_Get
4892: (
4893: p_count => x_msg_count,
4894: p_data => x_msg_data,
4910: -- lpn conv
4911: PROCEDURE Create_containers(
4912: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
4913: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
4914: x_container_ids OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4915: x_return_status OUT NOCOPY varchar2
4916: )
4917: IS
4918: l_debug_on BOOLEAN;
4940: l_name_suffix VARCHAR2(30);
4941: l_base_number NUMBER;
4942: l_base_number_dummy NUMBER;
4943: l_container_names WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type;
4944: l_lpn_ids wsh_util_core.id_tab_type;
4945: i NUMBER;
4946: j NUMBER;
4947: l_orig_value varchar2(2);
4948: l_update_container_orig VARCHAR2(2) := WSH_WMS_LPN_GRP.g_update_to_container;
4949: -- bmso
4950: l_lpn_table WMS_Data_Type_Definitions_pub.LPNTableType;
4951: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
4952: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4953: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
4954: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4955: l_assignment_dummy_tab WSH_UTIL_CORE.id_tab_type;
4956: l_wms_enabled BOOLEAN;
4957: l_return_status VARCHAR2(2);
4951: l_container_info_rec WSH_GLBL_VAR_STRCT_GRP.ContInfoRectype;
4952: l_container_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
4953: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;
4954: l_del_assg_rec WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_Type;
4955: l_assignment_dummy_tab WSH_UTIL_CORE.id_tab_type;
4956: l_wms_enabled BOOLEAN;
4957: l_return_status VARCHAR2(2);
4958: l_number_of_warnings NUMBER := 0;
4959: l_number_of_errors NUMBER := 0;
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
5039: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ORG');
5040: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5041: END IF;
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
5039: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ORG');
5040: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5041: END IF;
5042:
5043: wsh_util_core.api_post_call(
5044: p_return_status => l_return_status,
5039: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ORG');
5040: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5041: END IF;
5042:
5043: wsh_util_core.api_post_call(
5044: p_return_status => l_return_status,
5045: x_num_warnings => l_number_of_warnings,
5046: x_num_errors => l_number_of_errors
5047: );
5066: l_wms_msg_count,
5067: l_wms_msg_data,
5068: l_organization_id);
5069:
5070: wsh_util_core.api_post_call(
5071: p_return_status => l_wms_return_status,
5072: x_num_warnings => l_number_of_warnings,
5073: x_num_errors => l_number_of_errors
5074: );
5081: IF (l_cont_item_id IS NULL
5082: AND l_cont_item_name IS NULL
5083: AND l_cont_item_seg.count = 0) then --{
5084: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_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
5092: p_organization_id => l_organization_id,
5093: p_seg_array => l_cont_item_seg,
5094: x_return_status => l_return_status,
5095: p_item_type => 'CONT_ITEM');
5096: IF l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)
5097: THEN
5098: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_ITEM');
5099: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
5100: wsh_util_core.api_post_call(
5095: p_item_type => 'CONT_ITEM');
5096: IF l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)
5097: THEN
5098: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_ITEM');
5099: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
5100: wsh_util_core.api_post_call(
5101: p_return_status => l_return_status,
5102: x_num_warnings => l_number_of_warnings,
5103: x_num_errors => l_number_of_errors
5096: IF l_return_status NOT IN ( WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)
5097: THEN
5098: fnd_message.set_name('WSH', 'WSH_CONT_INVALID_ITEM');
5099: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
5100: wsh_util_core.api_post_call(
5101: p_return_status => l_return_status,
5102: x_num_warnings => l_number_of_warnings,
5103: x_num_errors => l_number_of_errors
5104: );
5106: END IF; --}
5107: ELSE --}{
5108: fnd_message.set_name('WSH', 'WSH_INCORRECT_ORG');
5109: fnd_message.set_token('ORG_CODE', l_organization_code);
5110: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5111: RAISE FND_API.G_EXC_ERROR;
5112: END IF; -- wms_enabled }
5113: END IF; -- verify item}
5114: --
5124: IF l_debug_on THEN
5125: wsh_debug_sv.log(l_module_name, 'Error ucc_128_suffix_flag is set to 1 and name_suffix is set to ',p_detail_IN_rec.name_suffix);
5126: END IF;
5127: FND_MESSAGE.SET_NAME('WSH', 'WSH_UCC128_ERROR'); --bmso new
5128: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5129: RAISE FND_API.G_EXC_ERROR;
5130: END IF;
5131:
5132: IF p_detail_IN_rec.ucc_128_suffix_flag = 1 THEN
5137: <> NVL(p_detail_IN_rec.name_prefix,0)
5138: OR TRUNC(NVL(p_detail_IN_rec.name_prefix,0)) < 0
5139: THEN
5140: FND_MESSAGE.SET_NAME('WSH', 'WSH_UCC128_PREFIX_ERR'); --bmso new
5141: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5142:
5143: END IF;
5144: EXCEPTION
5145: WHEN OTHERS THEN
5143: END IF;
5144: EXCEPTION
5145: WHEN OTHERS THEN
5146: FND_MESSAGE.SET_NAME('WSH', 'WSH_UCC128_PREFIX_ERR'); --bmso new
5147: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5148: END;
5149: ELSE
5150: l_suffix_length := NVL(LENGTH(p_detail_IN_rec.name_suffix),0);
5151: END IF;
5234:
5235: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5236: WSH_WMS_LPN_GRP.g_update_to_container := l_update_container_orig;
5237:
5238: wsh_util_core.api_post_call(
5239: p_return_status => l_return_status,
5240: x_num_warnings => l_number_of_warnings,
5241: x_num_errors => l_number_of_errors,
5242: p_msg_data => l_wms_msg_data
5261:
5262: IF l_container_info_rec.lpn_ids(j) IS NULL THEN
5263: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5264: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5265: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5266: RAISE FND_API.G_EXC_ERROR;
5267:
5268: ELSIF l_container_info_rec.container_names(j) IS NULL THEN
5269: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5267:
5268: ELSIF l_container_info_rec.container_names(j) IS NULL THEN
5269: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5270: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5271: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5272: RAISE FND_API.G_EXC_ERROR;
5273:
5274: END IF;
5275:
5310: p_quantity => p_detail_IN_rec.quantity,
5311: x_cont_names => l_container_info_rec.container_names,
5312: x_return_status => l_return_status
5313: );
5314: wsh_util_core.api_post_call(
5315: p_return_status => l_return_status,
5316: x_num_warnings => l_number_of_warnings,
5317: x_num_errors => l_number_of_errors
5318: );
5357: );
5358: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5359: WSH_WMS_LPN_GRP.g_update_to_container := l_update_container_orig;
5360:
5361: wsh_util_core.api_post_call(
5362: p_return_status => l_return_status,
5363: x_num_warnings => l_number_of_warnings,
5364: x_num_errors => l_number_of_errors,
5365: p_msg_data => l_wms_msg_data
5369:
5370: IF l_container_info_rec.lpn_ids(1) IS NULL THEN
5371: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5372: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5373: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5374: RAISE FND_API.G_EXC_ERROR;
5375:
5376: ELSIF l_container_info_rec.container_names(1) IS NULL THEN
5377: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5375:
5376: ELSIF l_container_info_rec.container_names(1) IS NULL THEN
5377: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5378: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5379: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5380: RAISE FND_API.G_EXC_ERROR;
5381:
5382: END IF;
5383:
5412: p_quantity => p_detail_IN_rec.quantity,
5413: x_cont_names => l_container_info_rec.container_names,
5414: x_return_status => l_return_status
5415: );
5416: wsh_util_core.api_post_call(
5417: p_return_status => l_return_status,
5418: x_num_warnings => l_number_of_warnings,
5419: x_num_errors => l_number_of_errors
5420: );
5426: wsh_container_actions.default_container_attr(l_container_rec,
5427: l_additional_cont_attr,
5428: p_detail_IN_rec.caller,
5429: l_return_status);
5430: wsh_util_core.api_post_call(
5431: p_return_status => l_return_status,
5432: x_num_warnings => l_number_of_warnings,
5433: x_num_errors => l_number_of_errors
5434: );
5440: x_dd_id_tab => l_cont_dummy_tab
5441: );
5442:
5443: IF l_return_status IN
5444: (WSH_UTIL_CORE.G_RET_STS_ERROR,
5445: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
5446: --
5447: IF l_debug_on THEN
5448: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR CREATING CONTAINER');
5441: );
5442:
5443: IF l_return_status IN
5444: (WSH_UTIL_CORE.G_RET_STS_ERROR,
5445: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
5446: --
5447: IF l_debug_on THEN
5448: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR CREATING CONTAINER');
5449: END IF;
5448: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR CREATING CONTAINER');
5449: END IF;
5450: --
5451: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5452: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5453: RAISE FND_API.G_EXC_ERROR;
5454: END IF;
5455:
5456: IF l_debug_on THEN
5457: WSH_DEBUG_SV.log(l_module_name,'COUNT OF WDD RECORDS',
5458: l_cont_dummy_tab.count);
5459: END IF;
5460:
5461: wsh_util_core.api_post_call(
5462: p_return_status => l_return_status,
5463: x_num_warnings => l_number_of_warnings,
5464: x_num_errors => l_number_of_errors
5465: );
5477: l_assignment_dummy_tab.count);
5478: WSH_DEBUG_SV.log(l_module_name,'Return Status',l_return_status);
5479: END IF;
5480:
5481: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5482: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5483: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5484: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5485: RAISE FND_API.G_EXC_ERROR;
5478: WSH_DEBUG_SV.log(l_module_name,'Return Status',l_return_status);
5479: END IF;
5480:
5481: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5482: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5483: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5484: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5485: RAISE FND_API.G_EXC_ERROR;
5486: END IF;
5480:
5481: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5482: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5483: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5484: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5485: RAISE FND_API.G_EXC_ERROR;
5486: END IF;
5487:
5488:
5485: RAISE FND_API.G_EXC_ERROR;
5486: END IF;
5487:
5488:
5489: wsh_util_core.api_post_call(
5490: p_return_status => l_return_status,
5491: x_num_warnings => l_number_of_warnings,
5492: x_num_errors => l_number_of_errors
5493: );
5498: WHILE i IS NOT NULL LOOP --{
5499: IF p_detail_info_tab(i).organization_id IS NULL THEN --{
5500: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5501: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ORGANIZATION_ID');
5502: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5503: IF l_debug_on THEN
5504: wsh_debug_sv.log(l_module_name,'ERROR organization id is null for', p_detail_info_tab(i).lpn_id);
5505: END IF;
5506:
5509: END IF; --}
5510: IF p_detail_info_tab(i).lpn_id IS NULL THEN
5511: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5512: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5513: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5514: RAISE FND_API.G_EXC_ERROR;
5515:
5516: ELSIF p_detail_info_tab(i).container_name IS NULL THEN
5517: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5515:
5516: ELSIF p_detail_info_tab(i).container_name IS NULL THEN
5517: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5518: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5519: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5520: RAISE FND_API.G_EXC_ERROR;
5521:
5522: END IF;
5523:
5538: wsh_container_actions.default_container_attr(l_container_rec,
5539: l_additional_cont_attr,
5540: p_detail_IN_rec.caller,
5541: l_return_status);
5542: wsh_util_core.api_post_call(
5543: p_return_status => l_return_status,
5544: x_num_warnings => l_number_of_warnings,
5545: x_num_errors => l_number_of_errors
5546: );
5552: x_dd_id_tab => l_cont_dummy_tab
5553: );
5554:
5555: IF l_return_status IN
5556: (WSH_UTIL_CORE.G_RET_STS_ERROR,
5557: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
5558: --
5559: IF l_debug_on THEN
5560: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR CREATING CONTAINER');
5553: );
5554:
5555: IF l_return_status IN
5556: (WSH_UTIL_CORE.G_RET_STS_ERROR,
5557: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN
5558: --
5559: IF l_debug_on THEN
5560: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR CREATING CONTAINER');
5561: END IF;
5560: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR CREATING CONTAINER');
5561: END IF;
5562: --
5563: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5564: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5565: RAISE FND_API.G_EXC_ERROR;
5566: END IF;
5567:
5568: IF l_debug_on THEN
5569: WSH_DEBUG_SV.log(l_module_name,'COUNT OF WDD RECORDS',
5570: l_cont_dummy_tab.count);
5571: END IF;
5572:
5573: wsh_util_core.api_post_call(
5574: p_return_status => l_return_status,
5575: x_num_warnings => l_number_of_warnings,
5576: x_num_errors => l_number_of_errors
5577: );
5589: l_assignment_dummy_tab.count);
5590: WSH_DEBUG_SV.log(l_module_name,'Return Status',l_return_status);
5591: END IF;
5592:
5593: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5594: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5595: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5596: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5597: RAISE FND_API.G_EXC_ERROR;
5590: WSH_DEBUG_SV.log(l_module_name,'Return Status',l_return_status);
5591: END IF;
5592:
5593: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5594: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5595: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5596: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5597: RAISE FND_API.G_EXC_ERROR;
5598: END IF;
5592:
5593: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5594: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5595: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5596: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5597: RAISE FND_API.G_EXC_ERROR;
5598: END IF;
5599: --
5600: wsh_util_core.api_post_call(
5596: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5597: RAISE FND_API.G_EXC_ERROR;
5598: END IF;
5599: --
5600: wsh_util_core.api_post_call(
5601: p_return_status => l_return_status,
5602: x_num_warnings => l_number_of_warnings,
5603: x_num_errors => l_number_of_errors
5604: );
5612: x_container_ids := l_cont_dummy_tab;
5613:
5614: IF l_number_of_errors > 0
5615: THEN
5616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5617: ELSIF l_number_of_warnings > 0
5618: THEN
5619: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5620: ELSE
5615: THEN
5616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5617: ELSIF l_number_of_warnings > 0
5618: THEN
5619: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5620: ELSE
5621: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5622: END IF;
5623:
5617: ELSIF l_number_of_warnings > 0
5618: THEN
5619: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5620: ELSE
5621: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5622: END IF;
5623:
5624: IF l_debug_on THEN
5625: WSH_DEBUG_SV.pop(l_module_name);
5630: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5631: WSH_WMS_LPN_GRP.g_update_to_container := l_update_container_orig;
5632:
5633: rollback to s_create_containers_DDGPB;
5634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5635: IF l_debug_on THEN
5636: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_NO_INV_ITEM');
5637: END IF;
5638: WHEN e_lpn_count_invalid then
5639: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5640: WSH_WMS_LPN_GRP.g_update_to_container := l_update_container_orig;
5641:
5642: rollback to s_create_containers_DDGPB;
5643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5644: fnd_message.set_name('WSH', 'WSH_LPN_COUNT_INVALID');
5645: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
5646: IF l_debug_on THEN
5647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_lpn_count_invalid');
5641:
5642: rollback to s_create_containers_DDGPB;
5643: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5644: fnd_message.set_name('WSH', 'WSH_LPN_COUNT_INVALID');
5645: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
5646: IF l_debug_on THEN
5647: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_lpn_count_invalid');
5648: END IF;
5649: --
5674: WSH_DEBUG_SV.pop(l_module_name
5675: ,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5676: END IF;
5677: --
5678: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5679: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5680: WSH_WMS_LPN_GRP.g_update_to_container := l_update_container_orig;
5681:
5682: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5678: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5679: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5680: WSH_WMS_LPN_GRP.g_update_to_container := l_update_container_orig;
5681:
5682: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5683: IF l_debug_on THEN
5684: WSH_DEBUG_SV.logmsg(l_module_name
5685: ,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured '
5686: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
5681:
5682: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5683: IF l_debug_on THEN
5684: WSH_DEBUG_SV.logmsg(l_module_name
5685: ,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured '
5686: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
5687: WSH_DEBUG_SV.pop(l_module_name
5688: ,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5689: END IF;
5684: WSH_DEBUG_SV.logmsg(l_module_name
5685: ,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured '
5686: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
5687: WSH_DEBUG_SV.pop(l_module_name
5688: ,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5689: END IF;
5690: WHEN OTHERS THEN
5691: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5692: rollback to s_create_containers_DDGPB;
5690: WHEN OTHERS THEN
5691: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5692: rollback to s_create_containers_DDGPB;
5693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5694: wsh_util_core.add_message(x_return_status, l_module_name);
5695: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_containers');
5696: IF l_debug_on THEN
5697: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5698: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5691: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5692: rollback to s_create_containers_DDGPB;
5693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5694: wsh_util_core.add_message(x_return_status, l_module_name);
5695: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_containers');
5696: IF l_debug_on THEN
5697: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5698: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5699: END IF;
5711:
5712: PROCEDURE Create_Delivery_Detail(
5713: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
5714: p_detail_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
5715: p_valid_index_tab IN wsh_util_core.id_tab_type,
5716: x_detail_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
5717: x_return_status OUT NOCOPY varchar2,
5718: x_msg_count OUT NOCOPY NUMBER,
5719: x_msg_data OUT NOCOPY VARCHAR2)
5745:
5746: --OTM R12
5747: l_delivery_detail_tab WSH_ENTITY_INFO_TAB;
5748: l_delivery_detail_rec WSH_ENTITY_INFO_REC;
5749: l_item_quantity_uom_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
5750: l_gc3_is_installed VARCHAR2(1);
5751: l_counter NUMBER;
5752: --
5753:
5785: END IF;
5786: --
5787:
5788: -- Initialize API return status to success
5789: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5790: l_number_of_errors := 0;
5791: l_number_of_warnings := 0;
5792:
5793: --OTM R12 initialize
5790: l_number_of_errors := 0;
5791: l_number_of_warnings := 0;
5792:
5793: --OTM R12 initialize
5794: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
5795:
5796: IF (l_gc3_is_installed IS NULL) THEN
5797: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
5798: END IF;
5793: --OTM R12 initialize
5794: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
5795:
5796: IF (l_gc3_is_installed IS NULL) THEN
5797: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
5798: END IF;
5799:
5800: IF (l_gc3_is_installed = 'Y') THEN
5801: l_delivery_detail_tab := WSH_ENTITY_INFO_TAB();
5810: -- logic for creating containers
5811: IF nvl(WSH_WMS_LPN_GRP.g_caller,'WSH') NOT LIKE 'WMS%' THEN --{
5812: IF( p_detail_IN_rec.organization_id IS NULL and p_detail_IN_rec.organization_code IS NULL) THEN
5813: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_ORG_NULL');
5814: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5815: IF l_debug_on THEN
5816: wsh_debug_sv.logmsg(l_module_name,'Null Organization');
5817: END IF;
5818: raise FND_API.G_EXC_ERROR;
5820: AND p_detail_IN_rec.container_item_name IS NULL
5821: AND p_detail_IN_rec.container_item_seg.count = 0) THEN
5822: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5823: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_ITEM');
5824: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5825: IF l_debug_on THEN
5826: wsh_debug_sv.logmsg(l_module_name,'Null Container item');
5827: END IF;
5828:
5836: p_detail_IN_rec => p_detail_IN_rec,
5837: x_container_ids => x_detail_out_rec.detail_ids,
5838: x_return_status => l_return_status
5839: );
5840: wsh_util_core.api_post_call(
5841: p_return_status => l_return_status,
5842: x_num_warnings => l_number_of_warnings,
5843: x_num_errors => l_number_of_errors
5844: );
5872: IF l_debug_on THEN
5873: wsh_debug_sv.log(l_module_name, 'Item Type', l_item_type);
5874: END IF;
5875: --
5876: wsh_util_core.api_post_call(
5877: p_return_status => l_return_status,
5878: x_num_warnings => l_number_of_warnings,
5879: x_num_errors => l_number_of_errors,
5880: p_msg_data => l_msg_data
5903: wsh_debug_sv.log(l_module_name, 'New Detail Created', l_new_detail_id);
5904: END IF;
5905:
5906: --
5907: wsh_util_core.api_post_call(
5908: p_return_status => l_return_status,
5909: x_num_warnings => l_number_of_warnings,
5910: x_num_errors => l_number_of_errors,
5911: p_msg_data => l_msg_data,
5911: p_msg_data => l_msg_data,
5912: p_raise_error_flag => FALSE
5913: );
5914: --
5915: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5916: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_CREATE_DET_FAILED');
5917: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5918: RAISE FND_API.G_EXC_ERROR;
5919: END IF;
5913: );
5914: --
5915: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5916: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_CREATE_DET_FAILED');
5917: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5918: RAISE FND_API.G_EXC_ERROR;
5919: END IF;
5920: l_delivery_assignments_info.delivery_id := NULL;
5921: l_delivery_assignments_info.parent_delivery_id := NULL;
5934: x_return_status => l_return_status);
5935:
5936: x_detail_out_Rec.detail_ids(l_index) := l_new_detail_id;
5937:
5938: wsh_util_core.api_post_call(
5939: p_return_status => l_return_status,
5940: x_num_warnings => l_number_of_warnings,
5941: x_num_errors => l_number_of_errors,
5942: p_msg_data => l_msg_data,
5942: p_msg_data => l_msg_data,
5943: p_raise_error_flag => FALSE
5944: );
5945:
5946: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5947: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_CREATE_AS_FAILED');
5948: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5949: RAISE FND_API.G_EXC_ERROR;
5950: END IF;
5944: );
5945:
5946: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5947: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_CREATE_AS_FAILED');
5948: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5949: RAISE FND_API.G_EXC_ERROR;
5950: END IF;
5951:
5952: --OTM R12, calling delivery detail splitter
6005: -- we will not fail based on l_return_status here because
6006: -- we do not want to stop the flow
6007: -- if the detail doesn't split, it will be caught later in
6008: -- delivery splitting and will have exception on the detail
6009: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6010: IF l_debug_on THEN
6011: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery detail split failed for ' || l_new_detail_id );
6012: END IF;
6013: END IF;
6057: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6058: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6059: END IF;
6060: --
6061: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6062: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6063: FND_MSG_PUB.Count_And_Get
6064: (
6065: p_count => x_msg_count,
6058: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6059: END IF;
6060: --
6061: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6062: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6063: FND_MSG_PUB.Count_And_Get
6064: (
6065: p_count => x_msg_count,
6066: p_data => x_msg_data,
6067: p_encoded => FND_API.G_FALSE
6068: );
6069: --
6070: IF l_debug_on THEN
6071: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6072: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
6073: END IF;
6074: --
6075: WHEN OTHERS THEN
6068: );
6069: --
6070: IF l_debug_on THEN
6071: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6072: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
6073: END IF;
6074: --
6075: WHEN OTHERS THEN
6076:
6075: WHEN OTHERS THEN
6076:
6077: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6079: wsh_util_core.add_message(x_return_status, l_module_name);
6080: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Delivery_Detail');
6081: FND_MSG_PUB.Count_And_Get
6082: (
6083: p_count => x_msg_count,
6076:
6077: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6079: wsh_util_core.add_message(x_return_status, l_module_name);
6080: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Delivery_Detail');
6081: FND_MSG_PUB.Count_And_Get
6082: (
6083: p_count => x_msg_count,
6084: p_data => x_msg_data,
6122: PROCEDURE Validate_Delivery_Detail(
6123: x_detail_info_tab IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6124: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6125: p_action IN VARCHAR2,
6126: p_validation_tab IN wsh_util_core.id_tab_type,
6127: p_caller IN VARCHAR2,
6128: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
6129: x_details_marked OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
6130: x_detail_tender_tab OUT NOCOPY wsh_util_core.id_tab_type,
6124: p_in_detail_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
6125: p_action IN VARCHAR2,
6126: p_validation_tab IN wsh_util_core.id_tab_type,
6127: p_caller IN VARCHAR2,
6128: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
6129: x_details_marked OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
6130: x_detail_tender_tab OUT NOCOPY wsh_util_core.id_tab_type,
6131: x_return_status OUT NOCOPY VARCHAR2,
6132: x_msg_count OUT NOCOPY NUMBER,
6125: p_action IN VARCHAR2,
6126: p_validation_tab IN wsh_util_core.id_tab_type,
6127: p_caller IN VARCHAR2,
6128: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
6129: x_details_marked OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
6130: x_detail_tender_tab OUT NOCOPY wsh_util_core.id_tab_type,
6131: x_return_status OUT NOCOPY VARCHAR2,
6132: x_msg_count OUT NOCOPY NUMBER,
6133: x_msg_data OUT NOCOPY VARCHAR2,
6126: p_validation_tab IN wsh_util_core.id_tab_type,
6127: p_caller IN VARCHAR2,
6128: x_valid_index_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
6129: x_details_marked OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
6130: x_detail_tender_tab OUT NOCOPY wsh_util_core.id_tab_type,
6131: x_return_status OUT NOCOPY VARCHAR2,
6132: x_msg_count OUT NOCOPY NUMBER,
6133: x_msg_data OUT NOCOPY VARCHAR2,
6134: p_in_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
6165:
6166: /* H projects: pricing integration csun */
6167: l_mark_reprice_flag VARCHAR2(1) := 'N';
6168: m NUMBER := 0;
6169: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
6170: mark_reprice_error EXCEPTION;
6171:
6172: l_original_detail_rec c_original_detail_cur%ROWTYPE;
6173: --
6246: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
6247: END IF;
6248: --
6249: -- Initialize API return status to success
6250: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6251: l_number_of_errors := 0;
6252: l_number_of_warnings := 0;
6253:
6254: IF p_caller IN ( 'WSH_FSTRX' , 'WSH_TPW_INBOUND')
6257: END IF;
6258:
6259: l_index := x_detail_info_tab.FIRST;
6260:
6261: IF wsh_util_core.fte_is_installed = 'Y' THEN
6262: l_fte_installed := 'Y';
6263: END IF;
6264:
6265: --
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:
6380: wsh_util_core.api_post_call(
6381: p_return_status => l_return_status,
6382: x_num_warnings => l_number_of_warnings,
6383: x_num_errors => l_number_of_errors,
6384: p_msg_data => l_msg_data
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:
6400: wsh_util_core.api_post_call(
6401: p_return_status => l_return_status,
6402: x_num_warnings => l_number_of_warnings,
6403: x_num_errors => l_number_of_errors,
6404: p_msg_data => l_msg_data
6434: l_inventory_item_info.primary_uom_code,
6435: x_detail_info_tab(l_index).src_requested_quantity,
6436: x_detail_info_tab(l_index).inventory_item_id);
6437:
6438: wsh_util_core.api_post_call(
6439: p_return_status => l_return_status,
6440: x_num_warnings => l_number_of_warnings,
6441: x_num_errors => l_number_of_errors,
6442: p_msg_data => l_msg_data
6481: END IF;
6482: l_number_of_errors := l_number_of_errors + 1;
6483: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
6484: FND_MESSAGE.SET_TOKEN('DETAIL_ID', x_detail_info_tab(l_index).delivery_detail_id);
6485: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
6486: RAISE FND_API.G_EXC_ERROR;
6487: END IF;
6488:
6489: CLOSE c_original_detail_cur;
6507: x_msg_data => l_msg_data
6508: );
6509:
6510: IF l_debug_on THEN
6511: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6512: END IF;
6513: --
6514: wsh_util_core.api_post_call(
6515: p_return_status => l_return_status,
6510: IF l_debug_on THEN
6511: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6512: END IF;
6513: --
6514: wsh_util_core.api_post_call(
6515: p_return_status => l_return_status,
6516: x_num_warnings => l_number_of_warnings,
6517: x_num_errors => l_number_of_errors,
6518: p_msg_data => l_msg_data
6530: x_msg_data => l_msg_data
6531: );
6532:
6533: IF l_debug_on THEN
6534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6535: END IF;
6536: --
6537: wsh_util_core.api_post_call(
6538: p_return_status => l_return_status,
6533: IF l_debug_on THEN
6534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6535: END IF;
6536: --
6537: wsh_util_core.api_post_call(
6538: p_return_status => l_return_status,
6539: x_num_warnings => l_number_of_warnings,
6540: x_num_errors => l_number_of_errors,
6541: p_msg_data => l_msg_data
6556: p_serial_range_tab => p_serial_range_tab
6557: );
6558:
6559: IF l_debug_on THEN
6560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6561: END IF;
6562: --
6563: wsh_util_core.api_post_call(
6564: p_return_status => l_return_status,
6559: IF l_debug_on THEN
6560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6561: END IF;
6562: --
6563: wsh_util_core.api_post_call(
6564: p_return_status => l_return_status,
6565: x_num_warnings => l_number_of_warnings,
6566: x_num_errors => l_number_of_errors,
6567: p_msg_data => l_msg_data
6634: x_msg_count => l_msg_count,
6635: x_msg_data => l_msg_data
6636: );
6637: --
6638: wsh_util_core.api_post_call(
6639: p_return_status => l_return_status,
6640: x_num_warnings => l_number_of_warnings,
6641: x_num_errors => l_number_of_errors,
6642: p_msg_data => l_msg_data
6671: x_msg_data => l_msg_data
6672: );
6673:
6674:
6675: wsh_util_core.api_post_call(
6676: p_return_status => l_return_status,
6677: x_num_warnings => l_number_of_warnings,
6678: x_num_errors => l_number_of_errors,
6679: p_msg_data => l_msg_data
6704: ROLLBACK TO validate_det_loop_grp;
6705: l_number_of_errors := l_number_of_errors + 1;
6706: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
6707: FND_MESSAGE.SET_TOKEN('FIELD_NAME', l_required_field);
6708: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
6709: IF l_debug_on THEN
6710: WSH_DEBUG_SV.logmsg(l_module_name,'E_REQUIRED_FIELD_NULL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6711: END IF;
6712: -- J-IB-NPARIKH-{
6713: WHEN e_ib_create_error THEN
6714: ROLLBACK TO validate_det_loop_grp;
6715: l_number_of_errors := l_number_of_errors + 1;
6716: FND_MESSAGE.SET_NAME('WSH', 'WSH_IB_CREATE_LINE_ERROR');
6717: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
6718: IF l_debug_on THEN
6719: WSH_DEBUG_SV.logmsg(l_module_name,'e_ib_create_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6720: END IF;
6721: -- J-IB-NPARIKH-}
6721: -- J-IB-NPARIKH-}
6722:
6723: when uom_conversion_failed then
6724: FND_MESSAGE.SEt_NAME('WSH','UOM_CONVERSION_FAILED');
6725: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
6726:
6727: IF l_debug_on THEN
6728: WSH_DEBUG_SV.logmsg(l_module_name,'UOM_CONVERSION_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6729: END IF;
6756: p_caller => 'WSH',
6757: x_changed_id_tab => x_detail_tender_tab,
6758: x_return_status => l_return_status
6759: );
6760: wsh_util_core.api_post_call(
6761: p_return_status => l_return_status,
6762: x_num_warnings => l_number_of_warnings,
6763: x_num_errors => l_number_of_errors,
6764: p_msg_data => l_msg_data
6775: IF x_detail_info_tab.count > 0 THEN
6776: IF l_number_of_errors >= x_detail_info_tab.count THEN
6777: RAISE FND_API.G_EXC_ERROR;
6778: ELSIF l_number_of_errors >0 THEN
6779: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6780: ELSIF l_number_of_warnings > 0 THEN
6781: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6782: END IF;
6783: END IF;
6777: RAISE FND_API.G_EXC_ERROR;
6778: ELSIF l_number_of_errors >0 THEN
6779: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6780: ELSIF l_number_of_warnings > 0 THEN
6781: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6782: END IF;
6783: END IF;
6784:
6785: FND_MSG_PUB.Count_And_Get
6825: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6826: END IF;
6827: --
6828: --
6829: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6830: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6831: FND_MSG_PUB.Count_And_Get
6832: (
6833: p_count => x_msg_count,
6826: END IF;
6827: --
6828: --
6829: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6830: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6831: FND_MSG_PUB.Count_And_Get
6832: (
6833: p_count => x_msg_count,
6834: p_data => x_msg_data,
6835: p_encoded => FND_API.G_FALSE
6836: );
6837: --
6838: IF l_debug_on THEN
6839: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6840: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
6841: END IF;
6842: --
6843:
6836: );
6837: --
6838: IF l_debug_on THEN
6839: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6840: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
6841: END IF;
6842: --
6843:
6844:
6845: WHEN OTHERS THEN
6846:
6847: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6849: wsh_util_core.add_message(x_return_status, l_module_name);
6850: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Delivery_Detail');
6851:
6852: FND_MSG_PUB.Count_And_Get
6853: (
6846:
6847: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6849: wsh_util_core.add_message(x_return_status, l_module_name);
6850: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Delivery_Detail');
6851:
6852: FND_MSG_PUB.Count_And_Get
6853: (
6854: p_count => x_msg_count,
6873: -- -----------------------------------------------------------------------
6874:
6875: PROCEDURE Update_Delivery_Detail(
6876: p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type ,
6877: p_valid_index_tab IN wsh_util_core.id_tab_type,
6878: x_return_status OUT NOCOPY VARCHAR2,
6879: x_msg_count OUT NOCOPY NUMBER,
6880: x_msg_data OUT NOCOPY VARCHAR2,
6881: p_caller IN VARCHAR2 DEFAULT NULL)
6933: END IF;
6934: --
6935:
6936: -- Initialize API return status to success
6937: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6938: l_number_of_errors := 0;
6939: l_number_of_warnings := 0;
6940:
6941: l_index := p_valid_index_tab.FIRST;
6969: x_return_status => l_return_status);
6970:
6971: --
6972: IF l_debug_on THEN
6973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6974: END IF;
6975: --
6976: wsh_util_core.api_post_call(
6977: p_return_status => l_return_status,
6972: IF l_debug_on THEN
6973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
6974: END IF;
6975: --
6976: wsh_util_core.api_post_call(
6977: p_return_status => l_return_status,
6978: x_num_warnings => l_number_of_warnings,
6979: x_num_errors => l_number_of_errors,
6980: p_msg_data => l_msg_data
6998: x_return_status => l_return_status,
6999: x_out_rec => l_out_rec
7000: );
7001:
7002: wsh_util_core.api_post_call(
7003: p_return_status => l_return_status,
7004: x_num_warnings => l_number_of_warnings,
7005: x_num_errors => l_number_of_errors
7006: );
7062: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7063: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7064: END IF;
7065: --
7066: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7067: IF lock_delivery_details%isopen THEN
7068: CLOSE lock_delivery_details;
7069: END IF;
7070: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7066: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7067: IF lock_delivery_details%isopen THEN
7068: CLOSE lock_delivery_details;
7069: END IF;
7070: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7071: --
7072: -- K LPN CONV. rv
7073: --
7074: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
7090: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
7091: END IF;
7092: --
7093: --
7094: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7095: x_return_status := l_return_status;
7096: END IF;
7097: --
7098: --}
7109: p_encoded => FND_API.G_FALSE
7110: );
7111: --
7112: IF l_debug_on THEN
7113: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7114: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7115: END IF;
7116: --
7117: WHEN delivery_detail_locked THEN
7110: );
7111: --
7112: IF l_debug_on THEN
7113: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7114: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7115: END IF;
7116: --
7117: WHEN delivery_detail_locked THEN
7118: IF lock_delivery_details%isopen THEN
7140: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
7141: END IF;
7142: --
7143: --
7144: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) and x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7145: x_return_status := l_return_status;
7146: END IF;
7147: --
7148: --}
7151: -- K LPN CONV. rv
7152: --
7153: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7154: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7155: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7156: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
7157: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
7158: IF l_debug_on THEN
7159: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:delivery_detail_locked');
7153: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7154: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7155: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7156: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
7157: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
7158: IF l_debug_on THEN
7159: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:delivery_detail_locked');
7160: END IF;
7161:
7167: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7169: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7170: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7171: wsh_util_core.add_message(x_return_status, l_module_name);
7172: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Delivery_Detail');
7173:
7174: FND_MSG_PUB.Count_And_Get
7175: (
7168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7169: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7170: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7171: wsh_util_core.add_message(x_return_status, l_module_name);
7172: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Delivery_Detail');
7173:
7174: FND_MSG_PUB.Count_And_Get
7175: (
7176: p_count => x_msg_count,
7245: END IF;
7246: --
7247:
7248: -- Initialize API return status to success
7249: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7250: l_number_of_errors := 0;
7251: l_number_of_warnings := 0;
7252:
7253:
7287: );
7288:
7289: --
7290: IF l_debug_on THEN
7291: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7292: END IF;
7293: --
7294: --
7295: wsh_util_core.api_post_call(
7291: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
7292: END IF;
7293: --
7294: --
7295: wsh_util_core.api_post_call(
7296: p_return_status => l_return_status,
7297: x_num_warnings => l_number_of_warnings,
7298: x_num_errors => l_number_of_errors,
7299: p_msg_data => l_msg_data
7305: IF l_debug_on THEN
7306: wsh_debug_sv.log(l_module_name, 'Number of warnings', l_number_of_warnings);
7307: END IF;
7308:
7309: RAISE wsh_util_core.g_exc_warning;
7310: END IF;
7311:
7312:
7313:
7357: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7358: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7359: END IF;
7360: --
7361: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7362: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7363: FND_MSG_PUB.Count_And_Get
7364: (
7365: p_count => x_msg_count,
7358: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7359: END IF;
7360: --
7361: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7362: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7363: FND_MSG_PUB.Count_And_Get
7364: (
7365: p_count => x_msg_count,
7366: p_data => x_msg_data,
7367: p_encoded => FND_API.G_FALSE
7368: );
7369: --
7370: IF l_debug_on THEN
7371: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7372: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7373: END IF;
7374: --
7375: WHEN OTHERS THEN
7368: );
7369: --
7370: IF l_debug_on THEN
7371: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7372: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7373: END IF;
7374: --
7375: WHEN OTHERS THEN
7376:
7375: WHEN OTHERS THEN
7376:
7377: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7379: wsh_util_core.add_message(x_return_status, l_module_name);
7380: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delete_Delivery_Detail');
7381: FND_MSG_PUB.Count_And_Get
7382: (
7383: p_count => x_msg_count,
7376:
7377: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7379: wsh_util_core.add_message(x_return_status, l_module_name);
7380: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delete_Delivery_Detail');
7381: FND_MSG_PUB.Count_And_Get
7382: (
7383: p_count => x_msg_count,
7384: p_data => x_msg_data,
7419: PROCEDURE validate_detail_line(
7420: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7421: p_in_detail_rec IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
7422: p_original_rec IN c_original_detail_cur%ROWTYPE,
7423: p_validation_tab IN wsh_util_core.id_tab_type,
7424: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
7425: x_return_status OUT NOCOPY VARCHAR2,
7426: x_msg_count OUT NOCOPY NUMBER,
7427: x_msg_data OUT NOCOPY VARCHAR2,
7535: WSH_DEBUG_SV.LOG(l_module_name, 'SQ', x_detail_rec.shipped_quantity);
7536: END IF;
7537:
7538: -- Initialize API return status to success --
7539: x_return_status := wsh_util_core.g_ret_sts_success;
7540: l_number_of_errors := 0;
7541: l_number_of_warnings := 0;
7542:
7543: --
7575: p_field_name => 'ship_tolerance_above',
7576: x_return_status => l_return_status );
7577: --
7578:
7579: wsh_util_core.api_post_call(
7580: p_return_status => l_return_status,
7581: x_num_warnings => l_number_of_warnings,
7582: x_num_errors => l_number_of_errors,
7583: p_msg_data => l_msg_data
7596: p_field_name => 'ship_tolerance_below',
7597: x_return_status => l_return_status );
7598: --
7599:
7600: wsh_util_core.api_post_call(
7601: p_return_status => l_return_status,
7602: x_num_warnings => l_number_of_warnings,
7603: x_num_errors => l_number_of_errors,
7604: p_msg_data => l_msg_data
7621: p_source_code => p_in_detail_rec.source_code,
7622: x_transaction_type_id => l_trx_type_id,
7623: x_return_status => l_return_status);
7624: --
7625: wsh_util_core.api_post_call(
7626: p_return_status => l_return_status,
7627: x_num_warnings => l_number_of_warnings,
7628: x_num_errors => l_number_of_errors,
7629: p_msg_data => l_msg_data);
7690: WSH_DEBUG_SV.log(l_module_name, 'Locator Flag', l_inv_controls.loc_flag);
7691: WSH_DEBUG_SV.log(l_module_name, 'Serial Control Code', l_inv_controls.serial_code);
7692: END IF;
7693:
7694: wsh_util_core.api_post_call(
7695: p_return_status => l_return_status,
7696: x_num_warnings => l_number_of_warnings,
7697: x_num_errors => l_number_of_errors,
7698: p_msg_data => l_msg_data
7774: --}
7775: END IF;
7776:
7777: --
7778: wsh_util_core.api_post_call(
7779: p_return_status => l_return_status,
7780: x_num_warnings => l_number_of_warnings,
7781: x_num_errors => l_number_of_errors,
7782: p_msg_data => l_msg_data
7834: x_detail_rec.shipped_quantity2 := l_det_qty_rec.shipped_quantity2;
7835: --PK added for Bug 3055126 Next line.
7836: x_detail_rec.cycle_count_quantity2 := l_det_qty_rec.cycle_count_quantity2;
7837: --
7838: wsh_util_core.api_post_call(
7839: p_return_status => l_return_status,
7840: x_num_warnings => l_number_of_warnings,
7841: x_num_errors => l_number_of_errors,
7842: p_msg_data => l_msg_data
7893: );
7894: x_detail_rec.cycle_count_quantity := l_det_qty_rec.cycle_count_quantity;
7895:
7896: --
7897: wsh_util_core.api_post_call(
7898: p_return_status => l_return_status,
7899: x_num_warnings => l_number_of_warnings,
7900: x_num_errors => l_number_of_errors,
7901: p_msg_data => l_msg_data
7951: );
7952: x_detail_rec.cycle_count_quantity2 :=
7953: l_det_qty_rec.cycle_count_quantity2;
7954: --
7955: wsh_util_core.api_post_call(
7956: p_return_status => l_return_status,
7957: x_num_warnings => l_number_of_warnings,
7958: x_num_errors => l_number_of_errors,
7959: p_msg_data => l_msg_data
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: --
7979: wsh_util_core.api_post_call(
7980: p_return_status => l_return_status,
7981: x_num_warnings => l_number_of_warnings,
7982: x_num_errors => l_number_of_errors,
7983: p_msg_data => l_msg_data
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(
8001: p_return_status => l_return_status,
8002: x_num_warnings => l_number_of_warnings,
8003: x_num_errors => l_number_of_errors,
8004: p_msg_data => l_msg_data
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(
8022: p_return_status => l_return_status,
8023: x_num_warnings => l_number_of_warnings,
8024: x_num_errors => l_number_of_errors,
8025: p_msg_data => l_msg_data
8054: IF l_debug_on THEN
8055: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid subinventory');
8056: END IF;
8057:
8058: l_return_status := wsh_util_core.g_ret_sts_error;
8059: END IF;
8060:
8061: wsh_util_core.api_post_call(
8062: p_return_status => l_return_status,
8057:
8058: l_return_status := wsh_util_core.g_ret_sts_error;
8059: END IF;
8060:
8061: wsh_util_core.api_post_call(
8062: p_return_status => l_return_status,
8063: x_num_warnings => l_number_of_warnings,
8064: x_num_errors => l_number_of_errors,
8065: p_msg_data => l_msg_data
8116:
8117: RAISE fnd_api.g_exc_error;
8118: END IF;
8119:
8120: wsh_util_core.api_post_call(
8121: p_return_status => l_return_status,
8122: x_num_warnings => l_number_of_warnings,
8123: x_num_errors => l_number_of_errors,
8124: p_msg_data => l_msg_data
8180: RAISE fnd_api.g_exc_error;
8181: END IF;
8182:
8183: --
8184: wsh_util_core.api_post_call(
8185: p_return_status => l_return_status,
8186: x_num_warnings => l_number_of_warnings,
8187: x_num_errors => l_number_of_errors,
8188: p_msg_data => l_msg_data
8261:
8262: -- HW OPM end of changes
8263:
8264: --
8265: wsh_util_core.api_post_call(
8266: p_return_status => l_return_status,
8267: x_num_warnings => l_number_of_warnings,
8268: x_num_errors => l_number_of_errors,
8269: p_msg_data => l_msg_data
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,
8290: x_num_warnings => l_number_of_warnings,
8291: x_num_errors => l_number_of_errors,
8292: p_msg_data => l_msg_data
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(
8310: p_return_status => l_return_status,
8311: x_num_warnings => l_number_of_warnings,
8312: x_num_errors => l_number_of_errors,
8313: p_msg_data => l_msg_data
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(
8331: p_return_status => l_return_status,
8332: x_num_warnings => l_number_of_warnings,
8333: x_num_errors => l_number_of_errors,
8334: p_msg_data => l_msg_data
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(
8352: p_return_status => l_return_status,
8353: x_num_warnings => l_number_of_warnings,
8354: x_num_errors => l_number_of_errors,
8355: p_msg_data => l_msg_data
8679: -- (
8680: IF l_inv_controls.ser_flag = 'N'
8681: THEN
8682: -- (
8683: l_return_status := wsh_util_core.g_ret_sts_error;
8684: fnd_message.set_name('WSH', 'WSH_INV_INVALID');
8685: fnd_message.set_token('INV_ATTRIBUTE', 'Serial Number Code');
8686: wsh_util_core.add_message(l_return_status);
8687: RAISE fnd_api.g_exc_error;
8682: -- (
8683: l_return_status := wsh_util_core.g_ret_sts_error;
8684: fnd_message.set_name('WSH', 'WSH_INV_INVALID');
8685: fnd_message.set_token('INV_ATTRIBUTE', 'Serial Number Code');
8686: wsh_util_core.add_message(l_return_status);
8687: RAISE fnd_api.g_exc_error;
8688: -- )
8689: END IF;
8690: -- )
8723: IF l_debug_on THEN
8724: wsh_debug_sv.log(l_module_name, 'Return status after Unmark ', l_return_status);
8725: END IF;
8726:
8727: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
8728: RAISE fnd_api.g_exc_error;
8729: END IF;
8730:
8731: -- Transaction temp id exists in WDD,now 1 serial number is being
8756: IF l_debug_on THEN
8757: wsh_debug_sv.log(l_module_name, 'Return status after Unmark ', l_return_status);
8758: END IF;
8759:
8760: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
8761: RAISE fnd_api.g_exc_error;
8762: END IF;
8763:
8764: END IF;
8808: WSH_DEBUG_SV.log(l_module_name, 'Return Status',l_return_status);
8809: END IF;
8810:
8811: IF NOT l_result THEN
8812: l_return_status := wsh_util_core.g_ret_sts_error;
8813: END IF;
8814:
8815: wsh_util_core.api_post_call(
8816: p_return_status => l_return_status,
8811: IF NOT l_result THEN
8812: l_return_status := wsh_util_core.g_ret_sts_error;
8813: END IF;
8814:
8815: wsh_util_core.api_post_call(
8816: p_return_status => l_return_status,
8817: x_num_warnings => l_number_of_warnings,
8818: x_num_errors => l_number_of_errors,
8819: p_msg_data => l_msg_data
8843: WSH_DEBUG_SV.log(l_module_name, 'Return Status',l_return_status);
8844: END IF;
8845: --
8846: IF NOT l_result THEN
8847: l_return_status := wsh_util_core.g_ret_sts_error;
8848: END IF;
8849: --
8850: wsh_util_core.api_post_call(
8851: p_return_status => l_return_status,
8846: IF NOT l_result THEN
8847: l_return_status := wsh_util_core.g_ret_sts_error;
8848: END IF;
8849: --
8850: wsh_util_core.api_post_call(
8851: p_return_status => l_return_status,
8852: x_num_warnings => l_number_of_warnings,
8853: x_num_errors => l_number_of_errors,
8854: p_msg_data => l_msg_data
8889: x_prefix => l_prefix,
8890: x_return_status => l_return_status
8891: );
8892: --
8893: wsh_util_core.api_post_call(
8894: p_return_status => l_return_status,
8895: x_num_warnings => l_number_of_warnings,
8896: x_num_errors => l_number_of_errors,
8897: p_msg_data => l_msg_data
8915: p_locator_id => l_locator,
8916: x_return_status => l_return_status
8917: );
8918: --
8919: wsh_util_core.api_post_call(
8920: p_return_status => l_return_status,
8921: x_num_warnings => l_number_of_warnings,
8922: x_num_errors => l_number_of_errors,
8923: p_msg_data => l_msg_data
9070: p_serial_number => NULL,
9071: p_transaction_temp_id => l_transaction_id,
9072: x_return_status => l_return_status
9073: );
9074: wsh_util_core.api_post_call(
9075: p_return_status => l_return_status,
9076: x_num_warnings => l_number_of_warnings,
9077: x_num_errors => l_number_of_errors,
9078: p_msg_data => l_msg_data
9091: p_serial_number => p_in_detail_rec.serial_number,
9092: p_transaction_temp_id => l_transaction_id,
9093: x_return_status => l_return_status
9094: );
9095: wsh_util_core.api_post_call(
9096: p_return_status => l_return_status,
9097: x_num_warnings => l_number_of_warnings,
9098: x_num_errors => l_number_of_errors,
9099: p_msg_data => l_msg_data
9124: IF l_debug_on THEN
9125: wsh_debug_sv.log(l_module_name, 'Return status after Update_Marked_Serial ', l_return_status);
9126: END IF;
9127: --
9128: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
9129: RAISE fnd_api.g_exc_error;
9130: END IF;
9131: --}
9132: END IF; -- l_update_attributes;
9197: WSH_DEBUG_SV.pop(l_module_name,
9198: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9199: END IF;
9200: --
9201: WHEN wsh_util_core.g_exc_warning THEN
9202: x_return_status := wsh_util_core.g_ret_sts_warning;
9203: fnd_msg_pub.count_and_get(
9204: p_count => x_msg_count,
9205: p_data => x_msg_data,
9198: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9199: END IF;
9200: --
9201: WHEN wsh_util_core.g_exc_warning THEN
9202: x_return_status := wsh_util_core.g_ret_sts_warning;
9203: fnd_msg_pub.count_and_get(
9204: p_count => x_msg_count,
9205: p_data => x_msg_data,
9206: p_encoded => fnd_api.g_false);
9207:
9208: --
9209: IF l_debug_on THEN
9210: WSH_DEBUG_SV.logmsg(l_module_name,
9211: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
9212: WSH_DEBUG_SV.c_excep_level);
9213: WSH_DEBUG_SV.pop(l_module_name,
9214: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9215: END IF;
9210: WSH_DEBUG_SV.logmsg(l_module_name,
9211: 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',
9212: WSH_DEBUG_SV.c_excep_level);
9213: WSH_DEBUG_SV.pop(l_module_name,
9214: 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9215: END IF;
9216: --
9217: WHEN OTHERS THEN
9218: ROLLBACK TO validate_det_line_grp;
9216: --
9217: WHEN OTHERS THEN
9218: ROLLBACK TO validate_det_line_grp;
9219: x_return_status := fnd_api.g_ret_sts_unexp_error;
9220: wsh_util_core.add_message(x_return_status, l_module_name);
9221: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');
9222: fnd_msg_pub.count_and_get(
9223: p_count => x_msg_count,
9224: p_data => x_msg_data,
9217: WHEN OTHERS THEN
9218: ROLLBACK TO validate_det_line_grp;
9219: x_return_status := fnd_api.g_ret_sts_unexp_error;
9220: wsh_util_core.add_message(x_return_status, l_module_name);
9221: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');
9222: fnd_msg_pub.count_and_get(
9223: p_count => x_msg_count,
9224: p_data => x_msg_data,
9225: p_encoded => fnd_api.g_false);
9247: -- -----------------------------------------------------------------------
9248: PROCEDURE Validate_Detail_Container(
9249: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
9250: p_original_rec IN c_original_detail_cur%ROWTYPE,
9251: p_validation_tab IN wsh_util_core.id_tab_type,
9252: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
9253: x_return_status OUT NOCOPY VARCHAR2,
9254: x_msg_count OUT NOCOPY NUMBER,
9255: x_msg_data OUT NOCOPY VARCHAR2
9292: WSH_DEBUG_SV.push(l_module_name);
9293: WSH_DEBUG_SV.log(l_module_name, 'Delivery Detail Id', x_detail_rec.delivery_detail_id);
9294: END IF;
9295: -- Initialize API return status to success
9296: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
9297: l_number_of_errors := 0;
9298: l_number_of_warnings := 0;
9299:
9300: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL) = 1 ) THEN
9314: p_item_type => 'CONT_ITEM',
9315: x_return_status => l_return_status);
9316:
9317: --
9318: wsh_util_core.api_post_call(
9319: p_return_status => l_return_status,
9320: x_num_warnings => l_number_of_warnings,
9321: x_num_errors => l_number_of_errors,
9322: p_msg_data => l_msg_data
9361: WHEN e_invalid_delivered_qty THEN
9362: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9363: x_return_status := FND_API.G_RET_STS_ERROR ;
9364: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERED_QTY');
9365: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
9366: FND_MSG_PUB.Count_And_Get
9367: (
9368: p_count => x_msg_count,
9369: p_data => x_msg_data,
9406: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9407: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9408: END IF;
9409: --
9410: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9411: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9412: FND_MSG_PUB.Count_And_Get
9413: (
9414: p_count => x_msg_count,
9407: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9408: END IF;
9409: --
9410: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9411: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9412: FND_MSG_PUB.Count_And_Get
9413: (
9414: p_count => x_msg_count,
9415: p_data => x_msg_data,
9416: p_encoded => FND_API.G_FALSE
9417: );
9418: --
9419: IF l_debug_on THEN
9420: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9422: END IF;
9423: --
9424: WHEN OTHERS THEN
9417: );
9418: --
9419: IF l_debug_on THEN
9420: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9422: END IF;
9423: --
9424: WHEN OTHERS THEN
9425: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9423: --
9424: WHEN OTHERS THEN
9425: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9427: wsh_util_core.add_message(x_return_status, l_module_name);
9428: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Container');
9429: FND_MSG_PUB.Count_And_Get
9430: (
9431: p_count => x_msg_count,
9424: WHEN OTHERS THEN
9425: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9427: wsh_util_core.add_message(x_return_status, l_module_name);
9428: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Container');
9429: FND_MSG_PUB.Count_And_Get
9430: (
9431: p_count => x_msg_count,
9432: p_data => x_msg_data,
9453:
9454: PROCEDURE Validate_Detail_Common(
9455: x_detail_rec IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type,
9456: p_original_rec IN c_original_detail_cur%ROWTYPE,
9457: p_validation_tab IN wsh_util_core.id_tab_type,
9458: x_mark_reprice_flag OUT NOCOPY VARCHAR2,
9459: x_return_status OUT NOCOPY VARCHAR2,
9460: x_msg_count OUT NOCOPY NUMBER,
9461: x_msg_data OUT NOCOPY VARCHAR2
9505: END IF;
9506: --
9507:
9508: -- Initialize API return status to success
9509: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
9510: l_number_of_errors := 0;
9511: l_number_of_warnings := 0;
9512:
9513: --HW OPMCONV - Removed checking for process org
9522: p_value => x_detail_rec.gross_weight,
9523: p_field_name => 'gross_weight',
9524: x_return_status => l_return_status );
9525: --
9526: wsh_util_core.api_post_call(
9527: p_return_status => l_return_status,
9528: x_num_warnings => l_number_of_warnings,
9529: x_num_errors => l_number_of_errors,
9530: p_msg_data => l_msg_data
9544: p_value => x_detail_rec.net_weight,
9545: p_field_name => 'net_weight',
9546: x_return_status => l_return_status );
9547: --
9548: wsh_util_core.api_post_call(
9549: p_return_status => l_return_status,
9550: x_num_warnings => l_number_of_warnings,
9551: x_num_errors => l_number_of_errors,
9552: p_msg_data => l_msg_data
9567: p_value => x_detail_rec.volume,
9568: p_field_name => 'volume',
9569: x_return_status => l_return_status );
9570: --
9571: wsh_util_core.api_post_call(
9572: p_return_status => l_return_status,
9573: x_num_warnings => l_number_of_warnings,
9574: x_num_errors => l_number_of_errors,
9575: p_msg_data => l_msg_data
9600:
9601: IF(l_parent_detail_id IS NOT NULL) THEN
9602: x_detail_rec.master_serial_number := p_original_rec.master_serial_number;
9603: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_MASTER_SERIAL');
9604: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning, l_module_name);
9605: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9606: END IF;
9607: ELSIF (p_original_rec.container_flag = 'N') THEN -- R12 MDC
9608: x_detail_rec.master_serial_number := p_original_rec.master_serial_number;
9601: IF(l_parent_detail_id IS NOT NULL) THEN
9602: x_detail_rec.master_serial_number := p_original_rec.master_serial_number;
9603: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_MASTER_SERIAL');
9604: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning, l_module_name);
9605: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9606: END IF;
9607: ELSIF (p_original_rec.container_flag = 'N') THEN -- R12 MDC
9608: x_detail_rec.master_serial_number := p_original_rec.master_serial_number;
9609: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_MASTER_SERIAL');
9606: END IF;
9607: ELSIF (p_original_rec.container_flag = 'N') THEN -- R12 MDC
9608: x_detail_rec.master_serial_number := p_original_rec.master_serial_number;
9609: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_MASTER_SERIAL');
9610: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning, l_module_name);
9611: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9612: END IF;
9613: END IF;
9614:
9607: ELSIF (p_original_rec.container_flag = 'N') THEN -- R12 MDC
9608: x_detail_rec.master_serial_number := p_original_rec.master_serial_number;
9609: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_MASTER_SERIAL');
9610: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning, l_module_name);
9611: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9612: END IF;
9613: END IF;
9614:
9615: END IF;
9625:
9626: IF(x_detail_rec.inspection_flag = 'N' AND p_original_rec.inspection_flag IN ('I', 'R')) THEN
9627: x_detail_rec.inspection_flag := p_original_rec.inspection_flag;
9628: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_INSPECT_FLAG');
9629: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning, l_module_name);
9630: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9631: END IF;
9632:
9633: END IF;
9626: IF(x_detail_rec.inspection_flag = 'N' AND p_original_rec.inspection_flag IN ('I', 'R')) THEN
9627: x_detail_rec.inspection_flag := p_original_rec.inspection_flag;
9628: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_INSPECT_FLAG');
9629: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning, l_module_name);
9630: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
9631: END IF;
9632:
9633: END IF;
9634:
9650: p_item_type => 'CONT_ITEM',
9651: x_return_status => l_return_status);
9652:
9653: --
9654: wsh_util_core.api_post_call(
9655: p_return_status => l_return_status,
9656: x_num_warnings => l_number_of_warnings,
9657: x_num_errors => l_number_of_errors,
9658: p_msg_data => l_msg_data
9676: p_item_type => 'CONT_ITEM',
9677: x_return_status => l_return_status);
9678:
9679: --
9680: wsh_util_core.api_post_call(
9681: p_return_status => l_return_status,
9682: x_num_warnings => l_number_of_warnings,
9683: x_num_errors => l_number_of_errors,
9684: p_msg_data => l_msg_data
9692:
9693: --{
9694: IF (nvl(x_detail_rec.delivered_quantity, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
9695: --{
9696: x_detail_rec.delivered_quantity := round(x_detail_rec.delivered_quantity,wsh_util_core.c_max_decimal_digits_inv);
9697: --}
9698: END IF;
9699: --}
9700:
9742: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9744: END IF;
9745:
9746: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9747: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9748: FND_MSG_PUB.Count_And_Get
9749: (
9750: p_count => x_msg_count,
9743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9744: END IF;
9745:
9746: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9747: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9748: FND_MSG_PUB.Count_And_Get
9749: (
9750: p_count => x_msg_count,
9751: p_data => x_msg_data,
9752: p_encoded => FND_API.G_FALSE
9753: );
9754: --
9755: IF l_debug_on THEN
9756: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9758: END IF;
9759:
9760: WHEN OTHERS THEN
9753: );
9754: --
9755: IF l_debug_on THEN
9756: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9758: END IF;
9759:
9760: WHEN OTHERS THEN
9761: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9759:
9760: WHEN OTHERS THEN
9761: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9763: wsh_util_core.add_message(x_return_status, l_module_name);
9764: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Common');
9765: FND_MSG_PUB.Count_And_Get
9766: (
9767: p_count => x_msg_count,
9760: WHEN OTHERS THEN
9761: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9763: wsh_util_core.add_message(x_return_status, l_module_name);
9764: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Common');
9765: FND_MSG_PUB.Count_And_Get
9766: (
9767: p_count => x_msg_count,
9768: p_data => x_msg_data,
9825: WSH_DEBUG_SV.log(l_module_name, 'Shipped Qty', p_shipped_quantity);
9826: END IF;
9827: --
9828:
9829: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
9830:
9831: if p_transaction_temp_id is not null then
9832:
9833: open c_serial_qty(p_transaction_temp_id);
9866: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9868: END IF;
9869:
9870: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9871: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9872: IF l_debug_on THEN
9873: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9874: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9868: END IF;
9869:
9870: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9871: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9872: IF l_debug_on THEN
9873: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9874: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9875: END IF;
9869:
9870: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9871: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9872: IF l_debug_on THEN
9873: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9874: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9875: END IF;
9876:
9877: WHEN OTHERS THEN
9870: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9871: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9872: IF l_debug_on THEN
9873: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9874: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9875: END IF;
9876:
9877: WHEN OTHERS THEN
9878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9875: END IF;
9876:
9877: WHEN OTHERS THEN
9878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9879: wsh_util_core.add_message(x_return_status, l_module_name);
9880: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Serial_Quantity');
9881: --
9882:
9883: IF l_debug_on THEN
9876:
9877: WHEN OTHERS THEN
9878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9879: wsh_util_core.add_message(x_return_status, l_module_name);
9880: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Serial_Quantity');
9881: --
9882:
9883: IF l_debug_on THEN
9884: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
9934: l_counter NUMBER := 0;
9935: l_index NUMBER;
9936:
9937: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
9938: l_valid_index_tab wsh_util_core.id_tab_type;
9939: l_delivery_id NUMBER;
9940: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9941: l_validation_tab wsh_util_core.id_tab_type;
9942: --
9937: l_detail_info_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
9938: l_valid_index_tab wsh_util_core.id_tab_type;
9939: l_delivery_id NUMBER;
9940: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9941: l_validation_tab wsh_util_core.id_tab_type;
9942: --
9943: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
9944: mark_reprice_error EXCEPTION;
9945:
9939: l_delivery_id NUMBER;
9940: l_delivery_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
9941: l_validation_tab wsh_util_core.id_tab_type;
9942: --
9943: l_details_marked WSH_UTIL_CORE.Id_Tab_Type;
9944: mark_reprice_error EXCEPTION;
9945:
9946: --
9947: CURSOR det_to_del_cur(p_detail_id NUMBER) IS
9949: FROM wsh_delivery_assignments_v wda
9950: WHERE wda.delivery_detail_id = p_detail_id;
9951:
9952: -- anxsharm for Load Tender
9953: l_detail_tender_tab wsh_util_core.id_tab_type;
9954: l_trip_id_tab wsh_util_core.id_tab_type;
9955:
9956: --
9957: l_weight_uom_code VARCHAR2(10);
9950: WHERE wda.delivery_detail_id = p_detail_id;
9951:
9952: -- anxsharm for Load Tender
9953: l_detail_tender_tab wsh_util_core.id_tab_type;
9954: l_trip_id_tab wsh_util_core.id_tab_type;
9955:
9956: --
9957: l_weight_uom_code VARCHAR2(10);
9958: l_volume_uom_code VARCHAR2(10);
9965: l_reset_flags BOOLEAN;
9966: --
9967: BEGIN
9968: -- Bugfix 4070732
9969: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
9970: THEN
9971: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
9972: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
9973: END IF;
9967: BEGIN
9968: -- Bugfix 4070732
9969: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
9970: THEN
9971: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
9972: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
9973: END IF;
9974: -- End of Code Bugfix 4070732
9975:
9968: -- Bugfix 4070732
9969: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
9970: THEN
9971: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
9972: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
9973: END IF;
9974: -- End of Code Bugfix 4070732
9975:
9976: -- Standard Start of API savepoint
10008: END IF;
10009: --
10010: --
10011: -- Initialize API return status to success
10012: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
10013: l_number_of_errors := 0;
10014: l_number_of_warnings := 0;
10015:
10016: -- Check for generic mandatory parameters
10016: -- Check for generic mandatory parameters
10017: IF p_In_rec.caller IS NULL THEN
10018: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
10019: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CALLER');
10020: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10021: IF l_debug_on THEN
10022: wsh_debug_sv.logmsg(l_module_name,'Null Caller');
10023: END IF;
10024: RAISE FND_API.G_EXC_ERROR;
10026:
10027: IF p_In_rec.action_code IS NULL THEN
10028: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
10029: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ACTION_CODE');
10030: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10031: IF l_debug_on THEN
10032: wsh_debug_sv.logmsg(l_module_name,'Null Action Code');
10033: END IF;
10034: RAISE FND_API.G_EXC_ERROR;
10035: ELSIF(p_In_rec.action_code NOT IN('CREATE', 'UPDATE', 'CANCEL')
10036: OR (p_In_rec.action_code = 'CANCEL' AND p_In_rec.caller <> 'WSH_INBOUND')) THEN
10037: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
10038: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_In_rec.action_code );
10039: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10040: IF l_debug_on THEN
10041: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
10042: END IF;
10043: RAISE FND_API.G_EXC_ERROR;
10057: x_return_status => l_return_status
10058: );
10059:
10060: --
10061: wsh_util_core.api_post_call(
10062: p_return_status => l_return_status,
10063: x_num_warnings => l_number_of_warnings,
10064: x_num_errors => l_number_of_errors,
10065: p_msg_data => l_msg_data
10111: );
10112:
10113:
10114: --
10115: wsh_util_core.api_post_call(
10116: p_return_status => l_return_status,
10117: x_num_warnings => l_loop_num_warn,
10118: x_num_errors => l_loop_num_error,
10119: p_msg_data => l_msg_data
10136: quantity => l_delivery_detail_rec.gross_weight,
10137: item_id => l_delivery_detail_rec.inventory_item_id,
10138: x_return_status => l_return_status );
10139:
10140: wsh_util_core.api_post_call(
10141: p_return_status => l_return_status,
10142: x_num_warnings => l_loop_num_warn,
10143: x_num_errors => l_loop_num_error
10144: );
10150: quantity => l_delivery_detail_rec.net_weight,
10151: item_id => l_delivery_detail_rec.inventory_item_id,
10152: x_return_status => l_return_status);
10153:
10154: wsh_util_core.api_post_call(
10155: p_return_status => l_return_status,
10156: x_num_warnings => l_loop_num_warn,
10157: x_num_errors => l_loop_num_error
10158: );
10180: quantity => l_delivery_detail_rec.volume,
10181: item_id => l_delivery_detail_rec.inventory_item_id,
10182: x_return_status => l_return_status);
10183:
10184: wsh_util_core.api_post_call(
10185: p_return_status => l_return_status,
10186: x_num_warnings => l_loop_num_warn,
10187: x_num_errors => l_loop_num_error
10188: );
10193: to_uom => l_delivery_detail_rec.volume_uom_code,
10194: quantity => l_delivery_detail_rec.filled_volume,
10195: item_id => l_delivery_detail_rec.inventory_item_id,
10196: x_return_status => l_return_status);
10197: wsh_util_core.api_post_call(
10198: p_return_status => l_return_status,
10199: x_num_warnings => l_loop_num_warn,
10200: x_num_errors => l_loop_num_error
10201: );
10287: p_in_rec => p_in_rec,
10288: p_serial_range_tab => p_serial_range_tab);
10289:
10290: --
10291: wsh_util_core.api_post_call(
10292: p_return_status => l_return_status,
10293: x_num_warnings => l_number_of_warnings,
10294: x_num_errors => l_number_of_errors,
10295: p_msg_data => l_msg_data
10306: x_msg_count => l_msg_count,
10307: x_msg_data => l_msg_data);
10308:
10309: --
10310: wsh_util_core.api_post_call(
10311: p_return_status => l_return_status,
10312: x_num_warnings => l_number_of_warnings,
10313: x_num_errors => l_number_of_errors,
10314: p_msg_data => l_msg_data
10316:
10317:
10318: ELSIF(p_In_rec.action_code = 'UPDATE') THEN
10319:
10320: IF( WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
10321: IF l_details_marked.count > 0 THEN
10322: --
10323: IF l_debug_on THEN
10324: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
10329: p_entity_ids => l_details_marked,
10330: x_return_status => l_return_status);
10331:
10332: --
10333: wsh_util_core.api_post_call(
10334: p_return_status => l_return_status,
10335: x_num_warnings => l_number_of_warnings,
10336: x_num_errors => l_number_of_errors,
10337: p_msg_data => l_msg_data
10336: x_num_errors => l_number_of_errors,
10337: p_msg_data => l_msg_data
10338: );
10339:
10340: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10341: raise mark_reprice_error;
10342: END IF;
10343: END IF;
10344: END IF;
10369: x_msg_data => l_msg_data,
10370: p_caller => p_in_rec.caller);
10371:
10372: --
10373: wsh_util_core.api_post_call(
10374: p_return_status => l_return_status,
10375: x_num_warnings => l_number_of_warnings,
10376: x_num_errors => l_number_of_errors,
10377: p_msg_data => l_msg_data
10386: x_msg_count => l_msg_count,
10387: x_msg_data => l_msg_data,
10388: p_caller => p_in_rec.caller);
10389:
10390: wsh_util_core.api_post_call(p_return_status =>l_return_status,
10391: x_num_warnings =>l_number_of_warnings,
10392: x_num_errors =>l_number_of_errors);
10393:
10394: -- jckwok
10399: IF l_debug_on THEN
10400: wsh_debug_sv.log(l_module_name, 'Number of warnings', l_number_of_warnings);
10401: END IF;
10402:
10403: RAISE wsh_util_core.g_exc_warning;
10404: END IF;
10405:
10406: -- Standard check of p_commit.
10407: IF FND_API.To_Boolean( p_commit ) THEN
10410: END IF;
10411: --
10412: -- Start code for Bugfix 4070732
10413: --
10414: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10415: IF l_debug_on THEN
10416: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10417: END IF;
10418:
10412: -- Start code for Bugfix 4070732
10413: --
10414: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10415: IF l_debug_on THEN
10416: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10417: END IF;
10418:
10419: l_reset_flags := FALSE;
10420:
10417: END IF;
10418:
10419: l_reset_flags := FALSE;
10420:
10421: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
10422: x_return_status => l_return_status);
10423:
10424: IF l_debug_on THEN
10425: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10424: IF l_debug_on THEN
10425: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10426: END IF;
10427:
10428: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
10429: RAISE FND_API.G_EXC_ERROR;
10430: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10432: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10426: END IF;
10427:
10428: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
10429: RAISE FND_API.G_EXC_ERROR;
10430: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10432: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10433: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
10434: END IF;
10428: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
10429: RAISE FND_API.G_EXC_ERROR;
10430: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10432: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10433: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
10434: END IF;
10435:
10436: END IF;
10429: RAISE FND_API.G_EXC_ERROR;
10430: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10432: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10433: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
10434: END IF;
10435:
10436: END IF;
10437: --
10441: END IF;
10442:
10443: --bug 4070732
10444: --End of the API handling of calls to process_stops_for_load_tender
10445: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
10446: --{
10447: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10448: --{
10449:
10443: --bug 4070732
10444: --End of the API handling of calls to process_stops_for_load_tender
10445: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
10446: --{
10447: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10448: --{
10449:
10450: IF FND_API.TO_BOOLEAN(p_commit) THEN
10451:
10449:
10450: IF FND_API.TO_BOOLEAN(p_commit) THEN
10451:
10452: IF l_debug_on THEN
10453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10454: END IF;
10455:
10456: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,
10457: x_return_status => l_return_status);
10452: IF l_debug_on THEN
10453: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10454: END IF;
10455:
10456: WSH_UTIL_CORE.reset_stops_for_load_tender(p_reset_flags => TRUE,
10457: x_return_status => l_return_status);
10458: ELSE
10459:
10460: IF l_debug_on THEN
10457: x_return_status => l_return_status);
10458: ELSE
10459:
10460: IF l_debug_on THEN
10461: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10462: END IF;
10463:
10464: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
10465: x_return_status => l_return_status);
10460: IF l_debug_on THEN
10461: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10462: END IF;
10463:
10464: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
10465: x_return_status => l_return_status);
10466: END IF;
10467:
10468: IF l_debug_on THEN
10469: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10470: END IF;
10471:
10472:
10473: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10474: x_return_status := l_return_status;
10475:
10476: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
10477: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
10472:
10473: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10474: x_return_status := l_return_status;
10475:
10476: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
10477: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
10478: THEN
10479: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
10480: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10473: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10474: x_return_status := l_return_status;
10475:
10476: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
10477: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
10478: THEN
10479: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
10480: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10481: END IF;
10505: x_return_status := FND_API.G_RET_STS_ERROR ;
10506: --
10507: -- Start code for Bugfix 4070732
10508: --
10509: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10510: THEN
10511: --{
10512: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10513: --{
10508: --
10509: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10510: THEN
10511: --{
10512: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10513: --{
10514: IF l_debug_on THEN
10515: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10516: END IF;
10511: --{
10512: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10513: --{
10514: IF l_debug_on THEN
10515: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10516: END IF;
10517:
10518: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
10519: x_return_status => l_return_status);
10514: IF l_debug_on THEN
10515: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10516: END IF;
10517:
10518: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
10519: x_return_status => l_return_status);
10520:
10521: IF l_debug_on THEN
10522: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10521: IF l_debug_on THEN
10522: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10523: END IF;
10524:
10525: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
10526: x_return_status := l_return_status;
10527: END IF;
10528: --}
10529: END IF;
10552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10553: --
10554: -- Start code for Bugfix 4070732
10555: --
10556: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10557: THEN
10558: --{
10559: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10560: --{
10555: --
10556: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10557: THEN
10558: --{
10559: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10560: --{
10561: IF l_debug_on THEN
10562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10563: END IF;
10558: --{
10559: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10560: --{
10561: IF l_debug_on THEN
10562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10563: END IF;
10564:
10565: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
10566: x_return_status => l_return_status);
10561: IF l_debug_on THEN
10562: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10563: END IF;
10564:
10565: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
10566: x_return_status => l_return_status);
10567:
10568: IF l_debug_on THEN
10569: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10589: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10591: END IF;
10592: --
10593: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10595: --
10596: -- Start code for Bugfix 4070732
10597: --
10590: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10591: END IF;
10592: --
10593: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10595: --
10596: -- Start code for Bugfix 4070732
10597: --
10598: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
10594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10595: --
10596: -- Start code for Bugfix 4070732
10597: --
10598: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
10599: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10600: IF l_debug_on THEN
10601: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10602: END IF;
10595: --
10596: -- Start code for Bugfix 4070732
10597: --
10598: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
10599: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10600: IF l_debug_on THEN
10601: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10602: END IF;
10603:
10597: --
10598: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
10599: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10600: IF l_debug_on THEN
10601: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10602: END IF;
10603:
10604: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
10605: x_return_status => l_return_status);
10600: IF l_debug_on THEN
10601: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10602: END IF;
10603:
10604: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
10605: x_return_status => l_return_status);
10606:
10607: IF l_debug_on THEN
10608: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10607: IF l_debug_on THEN
10608: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10609: END IF;
10610:
10611: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10612: x_return_status := l_return_status;
10613:
10614: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
10615: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
10610:
10611: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10612: x_return_status := l_return_status;
10613:
10614: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
10615: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
10616: THEN
10617: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10618: END IF;
10611: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10612: x_return_status := l_return_status;
10613:
10614: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
10615: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
10616: THEN
10617: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10618: END IF;
10619: END IF;
10633:
10634:
10635: --
10636: IF l_debug_on THEN
10637: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
10639: END IF;
10640: --
10641: WHEN mark_reprice_error then
10634:
10635: --
10636: IF l_debug_on THEN
10637: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
10639: END IF;
10640: --
10641: WHEN mark_reprice_error then
10642: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
10639: END IF;
10640: --
10641: WHEN mark_reprice_error then
10642: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
10643: wsh_util_core.add_message(x_return_status, l_module_name);
10644: x_return_status := l_return_status;
10645: --
10646: -- Start code for Bugfix 4070732
10647: --
10644: x_return_status := l_return_status;
10645: --
10646: -- Start code for Bugfix 4070732
10647: --
10648: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
10649: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10650: IF l_debug_on THEN
10651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10652: END IF;
10645: --
10646: -- Start code for Bugfix 4070732
10647: --
10648: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
10649: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10650: IF l_debug_on THEN
10651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10652: END IF;
10653:
10647: --
10648: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
10649: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10650: IF l_debug_on THEN
10651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10652: END IF;
10653:
10654: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
10655: x_return_status => l1_return_status);
10650: IF l_debug_on THEN
10651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10652: END IF;
10653:
10654: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
10655: x_return_status => l1_return_status);
10656:
10657: IF l_debug_on THEN
10658: WSH_DEBUG_SV.log(l_module_name,'l1_return_status',l1_return_status);
10657: IF l_debug_on THEN
10658: WSH_DEBUG_SV.log(l_module_name,'l1_return_status',l1_return_status);
10659: END IF;
10660:
10661: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10662: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10663: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
10664: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10665: l_return_status := l1_return_status;
10658: WSH_DEBUG_SV.log(l_module_name,'l1_return_status',l1_return_status);
10659: END IF;
10660:
10661: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10662: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10663: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
10664: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10665: l_return_status := l1_return_status;
10666: END IF;
10659: END IF;
10660:
10661: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10662: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10663: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
10664: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10665: l_return_status := l1_return_status;
10666: END IF;
10667: ELSE
10660:
10661: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10662: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
10663: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
10664: IF l1_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10665: l_return_status := l1_return_status;
10666: END IF;
10667: ELSE
10668: l_return_status := l1_return_status;
10670: END IF;
10671: END IF;
10672:
10673: x_return_status := l_return_status;
10674: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
10675: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
10676: THEN
10677: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10678: END IF;
10671: END IF;
10672:
10673: x_return_status := l_return_status;
10674: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
10675: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
10676: THEN
10677: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10678: END IF;
10679:
10698: --
10699: WHEN OTHERS THEN
10700: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10702: wsh_util_core.add_message(x_return_status, l_module_name);
10703: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
10704: --
10705: -- Start code for Bugfix 4070732
10706: --
10699: WHEN OTHERS THEN
10700: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10702: wsh_util_core.add_message(x_return_status, l_module_name);
10703: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
10704: --
10705: -- Start code for Bugfix 4070732
10706: --
10707: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10703: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
10704: --
10705: -- Start code for Bugfix 4070732
10706: --
10707: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10708: THEN
10709: --{
10710: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10711: --{
10706: --
10707: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10708: THEN
10709: --{
10710: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10711: --{
10712: IF l_debug_on THEN
10713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10714: END IF;
10709: --{
10710: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10711: --{
10712: IF l_debug_on THEN
10713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10714: END IF;
10715:
10716: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
10717: x_return_status => l_return_status);
10712: IF l_debug_on THEN
10713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10714: END IF;
10715:
10716: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
10717: x_return_status => l_return_status);
10718:
10719: IF l_debug_on THEN
10720: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10752: -- Bug 6790938 :
10753: -- Calling Find_Matching_Groups api instead of calling Autocreate_deliveries
10754: -- -----------------------------------------------------------------------
10755: -- Added for Bug 4295161
10756: PROCEDURE Get_Carton_Grouping (p_line_rows IN WSH_UTIL_CORE.id_tab_type,
10757: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
10758: x_return_status OUT NOCOPY VARCHAR2) IS
10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10753: -- Calling Find_Matching_Groups api instead of calling Autocreate_deliveries
10754: -- -----------------------------------------------------------------------
10755: -- Added for Bug 4295161
10756: PROCEDURE Get_Carton_Grouping (p_line_rows IN WSH_UTIL_CORE.id_tab_type,
10757: x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
10758: x_return_status OUT NOCOPY VARCHAR2) IS
10759:
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10760: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
10761: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
10762: l_action_rec wsh_delivery_autocreate.action_rec_type;
10763: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
10764: l_matched_entities wsh_util_core.id_tab_type;
10765: l_out_rec wsh_delivery_autocreate.out_rec_type;
10766:
10767: l_debug_on Boolean;
10768:
10861: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10863: END IF;
10864:
10865: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10866: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10867: IF l_debug_on THEN
10868: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
10862: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10863: END IF;
10864:
10865: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10866: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10867: IF l_debug_on THEN
10868: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
10870: END IF;
10864:
10865: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10866: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10867: IF l_debug_on THEN
10868: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
10870: END IF;
10871:
10872: WHEN OTHERS THEN
10865: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10866: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10867: IF l_debug_on THEN
10868: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
10870: END IF;
10871:
10872: WHEN OTHERS THEN
10873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10870: END IF;
10871:
10872: WHEN OTHERS THEN
10873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10874: wsh_util_core.add_message(x_return_status, l_module_name);
10875: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping');
10876: --
10877: IF l_debug_on THEN
10878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10871:
10872: WHEN OTHERS THEN
10873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10874: wsh_util_core.add_message(x_return_status, l_module_name);
10875: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping');
10876: --
10877: IF l_debug_on THEN
10878: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');