[Home] [Help]
274:
275: --
276: l_adjust_planned_del_tab.delete;
277:
278: IF NOT fnd_api.compatible_api_call(
279: l_api_version,
280: p_api_version,
281: l_api_name,
282: g_pkg_name
280: p_api_version,
281: l_api_name,
282: g_pkg_name
283: ) THEN
284: RAISE fnd_api.g_exc_unexpected_error;
285: END IF;
286:
287: -- Check p_init_msg_list
288: IF fnd_api.to_boolean(p_init_msg_list) THEN
284: RAISE fnd_api.g_exc_unexpected_error;
285: END IF;
286:
287: -- Check p_init_msg_list
288: IF fnd_api.to_boolean(p_init_msg_list) THEN
289: fnd_msg_pub.initialize;
290: END IF;
291:
292: x_return_status := wsh_util_core.g_ret_sts_success;
316:
317: IF UPPER(NVL(p_action, 'N')) = 'ASSIGN' THEN
318: IF (
319: (p_delivery_id IS NOT NULL)
320: AND (p_delivery_id <> fnd_api.g_miss_num)
321: OR (p_delivery_name IS NOT NULL)
322: AND (p_delivery_name <> fnd_api.g_miss_char)
323: ) THEN
324: IF (p_delivery_id IS NULL OR p_delivery_id = fnd_api.g_miss_num) THEN
318: IF (
319: (p_delivery_id IS NOT NULL)
320: AND (p_delivery_id <> fnd_api.g_miss_num)
321: OR (p_delivery_name IS NOT NULL)
322: AND (p_delivery_name <> fnd_api.g_miss_char)
323: ) THEN
324: IF (p_delivery_id IS NULL OR p_delivery_id = fnd_api.g_miss_num) THEN
325: /* convert delivery_name to delivery_id */
326: OPEN c_delivery_record;
320: AND (p_delivery_id <> fnd_api.g_miss_num)
321: OR (p_delivery_name IS NOT NULL)
322: AND (p_delivery_name <> fnd_api.g_miss_char)
323: ) THEN
324: IF (p_delivery_id IS NULL OR p_delivery_id = fnd_api.g_miss_num) THEN
325: /* convert delivery_name to delivery_id */
326: OPEN c_delivery_record;
327: FETCH c_delivery_record INTO l_delivery_id;
328:
484:
485: fnd_msg_pub.count_and_get(
486: p_count => x_msg_count,
487: p_data => x_msg_data,
488: p_encoded => fnd_api.g_false);
489:
490: IF fnd_api.to_boolean(p_commit) THEN
491: -- dbms_output.put_line('commit');
492: COMMIT WORK;
486: p_count => x_msg_count,
487: p_data => x_msg_data,
488: p_encoded => fnd_api.g_false);
489:
490: IF fnd_api.to_boolean(p_commit) THEN
491: -- dbms_output.put_line('commit');
492: COMMIT WORK;
493: END IF;
494:
496: wsh_debug_sv.pop(l_module_name);
497: END IF;
498: --
499: EXCEPTION
500: WHEN fnd_api.g_exc_error THEN
501: ROLLBACK TO detail_to_delivery_grp;
502: x_return_status := fnd_api.g_ret_sts_error;
503: fnd_msg_pub.count_and_get(
504: p_count => x_msg_count,
498: --
499: EXCEPTION
500: WHEN fnd_api.g_exc_error THEN
501: ROLLBACK TO detail_to_delivery_grp;
502: x_return_status := fnd_api.g_ret_sts_error;
503: fnd_msg_pub.count_and_get(
504: p_count => x_msg_count,
505: p_data => x_msg_data,
506: p_encoded => fnd_api.g_false);
502: x_return_status := fnd_api.g_ret_sts_error;
503: fnd_msg_pub.count_and_get(
504: p_count => x_msg_count,
505: p_data => x_msg_data,
506: p_encoded => fnd_api.g_false);
507:
508: --
509: IF l_debug_on THEN
510: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
506: p_encoded => fnd_api.g_false);
507:
508: --
509: IF l_debug_on THEN
510: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
511: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
512: END IF;
513: --
514: WHEN fnd_api.g_exc_unexpected_error THEN
507:
508: --
509: IF l_debug_on THEN
510: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
511: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
512: END IF;
513: --
514: WHEN fnd_api.g_exc_unexpected_error THEN
515: ROLLBACK TO detail_to_delivery_grp;
510: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
511: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
512: END IF;
513: --
514: WHEN fnd_api.g_exc_unexpected_error THEN
515: ROLLBACK TO detail_to_delivery_grp;
516: x_return_status := fnd_api.g_ret_sts_unexp_error;
517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
518: p_encoded => fnd_api.g_false);
512: END IF;
513: --
514: WHEN fnd_api.g_exc_unexpected_error THEN
515: ROLLBACK TO detail_to_delivery_grp;
516: x_return_status := fnd_api.g_ret_sts_unexp_error;
517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
518: p_encoded => fnd_api.g_false);
519:
520: --
514: WHEN fnd_api.g_exc_unexpected_error THEN
515: ROLLBACK TO detail_to_delivery_grp;
516: x_return_status := fnd_api.g_ret_sts_unexp_error;
517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
518: p_encoded => fnd_api.g_false);
519:
520: --
521: IF l_debug_on THEN
522: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
518: p_encoded => fnd_api.g_false);
519:
520: --
521: IF l_debug_on THEN
522: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
523: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
524: END IF;
525: --
526: WHEN wsh_util_core.g_exc_warning THEN
519:
520: --
521: IF l_debug_on THEN
522: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
523: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
524: END IF;
525: --
526: WHEN wsh_util_core.g_exc_warning THEN
527: x_return_status := wsh_util_core.g_ret_sts_warning;
525: --
526: WHEN wsh_util_core.g_exc_warning THEN
527: x_return_status := wsh_util_core.g_ret_sts_warning;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
529: p_encoded => fnd_api.g_false);
530:
531: --
532: IF l_debug_on THEN
533: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
539: x_return_status := wsh_util_core.g_ret_sts_error;
540: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
541: wsh_util_core.add_message(x_return_status);
542: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
543: p_encoded => fnd_api.g_false);
544:
545: IF l_debug_on THEN
546: wsh_debug_sv.logmsg(l_module_name, 'WSH_INVALID_ACTION exception has occured.', wsh_debug_sv.c_excep_level);
547: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_INVALID_ACTION');
552: x_return_status := wsh_util_core.g_ret_sts_error;
553: fnd_message.set_name('WSH', 'WSH_PUB_NO_DEL_DET_TBL');
554: wsh_util_core.add_message(x_return_status);
555: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
556: p_encoded => fnd_api.g_false);
557:
558: IF l_debug_on THEN
559: wsh_debug_sv.logmsg(l_module_name, 'WSH_NO_DEL_DET_TBL exception has occured.', wsh_debug_sv.c_excep_level);
560: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_NO_DEL_DET_TBL');
565: x_return_status := wsh_util_core.g_ret_sts_error;
566: fnd_message.set_name('WSH', 'WSH_PUB_NO_DELIVERY');
567: wsh_util_core.add_message(x_return_status);
568: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
569: p_encoded => fnd_api.g_false);
570:
571: IF l_debug_on THEN
572: wsh_debug_sv.logmsg(l_module_name, 'WSH_NO_DELIVERY_ID exception has occured.', wsh_debug_sv.c_excep_level);
573: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_NO_DELIVERY_ID');
582: fnd_message.set_name('WSH', 'WSH_DELIVERY_NOT_EXIST');
583: fnd_message.set_token('DELIVERY_NAME', p_delivery_name);
584: wsh_util_core.add_message(x_return_status);
585: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
586: p_encoded => fnd_api.g_false);
587:
588: IF l_debug_on THEN
589: wsh_debug_sv.logmsg(l_module_name, 'WSH_NO_DELIVERY exception has occured.', wsh_debug_sv.c_excep_level);
590: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_NO_DELIVERY');
596: fnd_message.set_name('WSH', 'WSH_INVALID_DELIVERY');
597: fnd_message.set_token('DELIVERY', p_delivery_id);
598: wsh_util_core.add_message(x_return_status);
599: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
600: p_encoded => fnd_api.g_false);
601:
602: IF l_debug_on THEN
603: wsh_debug_sv.logmsg(l_module_name, 'WSH_INVALID_DELIVERY_ID exception has occured.', wsh_debug_sv.c_excep_level);
604: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_INVALID_DELIVERY_ID');
611: ROLLBACK TO detail_to_delivery_grp;
612: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
613: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
614: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
615: p_encoded => fnd_api.g_false);
616:
617: IF l_debug_on THEN
618: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);
619: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
699: WHEN OTHERS THEN
700: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
701: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.DETAIL_TO_DELIVERY');
702: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
703: p_encoded => fnd_api.g_false);
704:
705: IF l_debug_on THEN
706: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
707: END IF;
810: END IF;
811:
812: --
813:
814: IF NOT fnd_api.compatible_api_call(
815: l_api_version,
816: p_api_version,
817: l_api_name,
818: g_pkg_name
816: p_api_version,
817: l_api_name,
818: g_pkg_name
819: ) THEN
820: RAISE fnd_api.g_exc_unexpected_error;
821: END IF;
822:
823: -- Check p_init_msg_list
824: IF fnd_api.to_boolean(p_init_msg_list) THEN
820: RAISE fnd_api.g_exc_unexpected_error;
821: END IF;
822:
823: -- Check p_init_msg_list
824: IF fnd_api.to_boolean(p_init_msg_list) THEN
825: fnd_msg_pub.initialize;
826: END IF;
827:
828: x_return_status := wsh_util_core.g_ret_sts_success;
903: END IF;
904:
905: -- UT Bug fix 2650839
906: --IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
907: -- RAISE fnd_api.g_exc_error;
908: --END IF;
909: -- Reverting the fix made in 2650839 as we need to return warning instead of
910: -- error to public API users.
911: wsh_util_core.api_post_call(
945:
946: fnd_msg_pub.count_and_get(
947: p_count => x_msg_count,
948: p_data => x_msg_data,
949: p_encoded => fnd_api.g_false);
950:
951: IF l_debug_on THEN
952: wsh_debug_sv.LOG(l_module_name, 'X_NEW_DETAIL_ID', x_new_detail_id);
953: wsh_debug_sv.LOG(l_module_name, 'X_SPLIT_QUANTITY', x_split_quantity);
954: wsh_debug_sv.pop(l_module_name);
955: END IF;
956: --
957: EXCEPTION
958: WHEN fnd_api.g_exc_error THEN
959: ROLLBACK TO split_line_grp;
960: x_return_status := fnd_api.g_ret_sts_error;
961: fnd_msg_pub.count_and_get(
962: p_count => x_msg_count,
956: --
957: EXCEPTION
958: WHEN fnd_api.g_exc_error THEN
959: ROLLBACK TO split_line_grp;
960: x_return_status := fnd_api.g_ret_sts_error;
961: fnd_msg_pub.count_and_get(
962: p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => fnd_api.g_false);
960: x_return_status := fnd_api.g_ret_sts_error;
961: fnd_msg_pub.count_and_get(
962: p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => fnd_api.g_false);
965:
966: --
967: IF l_debug_on THEN
968: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
964: p_encoded => fnd_api.g_false);
965:
966: --
967: IF l_debug_on THEN
968: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
969: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
970: END IF;
971: --
972: WHEN fnd_api.g_exc_unexpected_error THEN
965:
966: --
967: IF l_debug_on THEN
968: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
969: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
970: END IF;
971: --
972: WHEN fnd_api.g_exc_unexpected_error THEN
973: ROLLBACK TO split_line_grp;
968: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
969: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
970: END IF;
971: --
972: WHEN fnd_api.g_exc_unexpected_error THEN
973: ROLLBACK TO split_line_grp;
974: x_return_status := fnd_api.g_ret_sts_unexp_error;
975: fnd_msg_pub.count_and_get(
976: p_count => x_msg_count,
970: END IF;
971: --
972: WHEN fnd_api.g_exc_unexpected_error THEN
973: ROLLBACK TO split_line_grp;
974: x_return_status := fnd_api.g_ret_sts_unexp_error;
975: fnd_msg_pub.count_and_get(
976: p_count => x_msg_count,
977: p_data => x_msg_data,
978: p_encoded => fnd_api.g_false);
974: x_return_status := fnd_api.g_ret_sts_unexp_error;
975: fnd_msg_pub.count_and_get(
976: p_count => x_msg_count,
977: p_data => x_msg_data,
978: p_encoded => fnd_api.g_false);
979:
980: --
981: IF l_debug_on THEN
982: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
978: p_encoded => fnd_api.g_false);
979:
980: --
981: IF l_debug_on THEN
982: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
983: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
984: END IF;
985: --
986: WHEN wsh_util_core.g_exc_warning THEN
979:
980: --
981: IF l_debug_on THEN
982: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
983: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
984: END IF;
985: --
986: WHEN wsh_util_core.g_exc_warning THEN
987: x_return_status := wsh_util_core.g_ret_sts_warning;
987: x_return_status := wsh_util_core.g_ret_sts_warning;
988: fnd_msg_pub.count_and_get(
989: p_count => x_msg_count,
990: p_data => x_msg_data,
991: p_encoded => fnd_api.g_false);
992:
993: --
994: IF l_debug_on THEN
995: wsh_debug_sv.logmsg(l_module_name, 'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ', wsh_debug_sv.c_excep_level);
1008:
1009: fnd_msg_pub.count_and_get(
1010: p_count => x_msg_count,
1011: p_data => x_msg_data,
1012: p_encoded => fnd_api.g_false);
1013:
1014: IF l_debug_on THEN
1015: wsh_debug_sv.logmsg(l_module_name, 'WSH_INALID_DETAIL_ID exception has occured.', wsh_debug_sv.c_excep_level);
1016: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_INALID_DETAIL_ID');
1024:
1025: fnd_msg_pub.count_and_get(
1026: p_count => x_msg_count,
1027: p_data => x_msg_data,
1028: p_encoded => fnd_api.g_false);
1029:
1030: IF l_debug_on THEN
1031: wsh_debug_sv.logmsg(l_module_name, 'WSH_INVALID_SPLIT_QTY exception has occured.', wsh_debug_sv.c_excep_level);
1032: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_INVALID_SPLIT_QTY');
1040:
1041: fnd_msg_pub.count_and_get(
1042: p_count => x_msg_count,
1043: p_data => x_msg_data,
1044: p_encoded => fnd_api.g_false);
1045:
1046: IF l_debug_on THEN
1047: wsh_debug_sv.logmsg(l_module_name, 'WSH_INVALID_SPLIT_QTY2 exception has occured.', wsh_debug_sv.c_excep_level);
1048: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_INVALID_SPLIT_QTY2');
1049: END IF;
1050: --
1051: WHEN OTHERS THEN
1052: ROLLBACK TO split_line_grp;
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: wsh_util_core.add_message(x_return_status, l_module_name);
1055: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Split_Line');
1056:
1057: fnd_msg_pub.count_and_get(
1056:
1057: fnd_msg_pub.count_and_get(
1058: p_count => x_msg_count,
1059: p_data => x_msg_data,
1060: p_encoded => fnd_api.g_false);
1061: --
1062: IF l_debug_on THEN
1063: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM, wsh_debug_sv.c_unexpec_err_level);
1064: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
1175: --
1176: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1177:
1178: -- Standard call to check for call compatibility
1179: IF NOT FND_API.Compatible_API_Call(
1180: l_api_version_number,
1181: p_api_version_number,
1182: l_api_name,
1183: G_PKG_NAME) THEN
1180: l_api_version_number,
1181: p_api_version_number,
1182: l_api_name,
1183: G_PKG_NAME) THEN
1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1185: END IF;
1186:
1187: -- Initialize message stack if required
1188: IF FND_API.to_Boolean(p_init_msg_list) THEN
1184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1185: END IF;
1186:
1187: -- Initialize message stack if required
1188: IF FND_API.to_Boolean(p_init_msg_list) THEN
1189: FND_MSG_PUB.initialize;
1190: END IF;
1191:
1192: -- sperera source_code has to be 'OE' or 'WSH'
1189: FND_MSG_PUB.initialize;
1190: END IF;
1191:
1192: -- sperera source_code has to be 'OE' or 'WSH'
1193: IF (NVL(p_source_code, FND_API.G_MISS_CHAR)) NOT IN ('WSH', 'OE') THEN
1194: RAISE invalid_source_code;
1195: END IF;
1196:
1197: -- Patchset I : Harmonization Project.
1351: l_detail_info_tab(l_index).tp_attribute8 := p_changed_attributes(l_index).tp_attribute8;
1352: l_detail_info_tab(l_index).tp_attribute9 := p_changed_attributes(l_index).tp_attribute9;
1353: l_detail_info_tab(l_index).tracking_number := p_changed_attributes(l_index).tracking_number;
1354:
1355: -- jckwok Bug 3579965: must check whether transaction_temp_id <> FND_API.G_MISS_NUM also
1356: if (p_changed_attributes(l_index).transaction_temp_id is not null
1357: AND p_changed_attributes(l_index).transaction_temp_id <> FND_API.G_MISS_NUM) then
1358: l_detail_info_tab(l_index).transaction_temp_id := p_changed_attributes(l_index).transaction_temp_id;
1359: else
1353: l_detail_info_tab(l_index).tracking_number := p_changed_attributes(l_index).tracking_number;
1354:
1355: -- jckwok Bug 3579965: must check whether transaction_temp_id <> FND_API.G_MISS_NUM also
1356: if (p_changed_attributes(l_index).transaction_temp_id is not null
1357: AND p_changed_attributes(l_index).transaction_temp_id <> FND_API.G_MISS_NUM) then
1358: l_detail_info_tab(l_index).transaction_temp_id := p_changed_attributes(l_index).transaction_temp_id;
1359: else
1360: l_detail_info_tab(l_index).serial_number := p_changed_attributes(l_index).serial_number;
1361: end if;
1375:
1376: wsh_interface_grp.Create_Update_Delivery_Detail
1377: (
1378: p_api_version_number => l_api_version_number,
1379: p_init_msg_list => FND_API.G_FALSE,
1380: p_commit => FND_API.G_FALSE,
1381: x_return_status => l_return_status,
1382: x_msg_count => l_msg_count,
1383: x_msg_data => l_msg_data,
1376: wsh_interface_grp.Create_Update_Delivery_Detail
1377: (
1378: p_api_version_number => l_api_version_number,
1379: p_init_msg_list => FND_API.G_FALSE,
1380: p_commit => FND_API.G_FALSE,
1381: x_return_status => l_return_status,
1382: x_msg_count => l_msg_count,
1383: x_msg_data => l_msg_data,
1384: p_detail_info_tab => l_detail_info_tab,
1398: );
1399:
1400:
1401: -- report success
1402: IF FND_API.TO_BOOLEAN(p_commit) THEN
1403: COMMIT WORK;
1404: END IF;
1405:
1406: x_return_status := FND_API.G_RET_STS_SUCCESS;
1402: IF FND_API.TO_BOOLEAN(p_commit) THEN
1403: COMMIT WORK;
1404: END IF;
1405:
1406: x_return_status := FND_API.G_RET_STS_SUCCESS;
1407: FND_MSG_PUB.Count_And_Get
1408: ( p_count => x_msg_count,
1409: p_data => x_msg_data,
1410: p_encoded => FND_API.G_FALSE
1406: x_return_status := FND_API.G_RET_STS_SUCCESS;
1407: FND_MSG_PUB.Count_And_Get
1408: ( p_count => x_msg_count,
1409: p_data => x_msg_data,
1410: p_encoded => FND_API.G_FALSE
1411: );
1412: --
1413: -- Debug Statements
1414: --
1424: WSH_UTIL_CORE.add_message (x_return_status);
1425: FND_MSG_PUB.Count_And_Get
1426: ( p_count => x_msg_count,
1427: p_data => x_msg_data,
1428: p_encoded => FND_API.G_FALSE
1429: );
1430: --
1431: -- Debug Statements
1432: --
1436: END IF;
1437: --
1438: WHEN invalid_source_code THEN
1439: ROLLBACK TO UPDATE_SHIPPING_ATTR_GRP;
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
1442: WSH_UTIL_CORE.Add_Message(x_return_status);
1443: FND_MSG_PUB.Count_And_Get
1444: ( p_count => x_msg_count,
1442: WSH_UTIL_CORE.Add_Message(x_return_status);
1443: FND_MSG_PUB.Count_And_Get
1444: ( p_count => x_msg_count,
1445: p_data => x_msg_data,
1446: p_encoded => FND_API.G_FALSE
1447: );
1448: --
1449: -- Debug Statements
1450: --
1463: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1464: FND_MSG_PUB.Count_And_Get
1465: ( p_count => x_msg_count,
1466: p_data => x_msg_data,
1467: p_encoded => FND_API.G_FALSE
1468: );
1469:
1470: -- Bug fix 2154602
1471: IF l_debug_on THEN
1479: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1480: FND_MSG_PUB.Count_And_Get
1481: ( p_count => x_msg_count,
1482: p_data => x_msg_data,
1483: p_encoded => FND_API.G_FALSE
1484: );
1485: -- End of Bug fix 2154602
1486:
1487: IF l_debug_on THEN
1499: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Shipping_Attributes');
1500: FND_MSG_PUB.Count_And_Get
1501: ( p_count => x_msg_count,
1502: p_data => x_msg_data,
1503: p_encoded => FND_API.G_FALSE
1504: );
1505: IF l_debug_on THEN
1506: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1507: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1662: WSH_DEBUG_SV.log(l_module_name,'P_LINE_ROWS.COUNT',P_LINE_ROWS.COUNT);
1663: END IF;
1664: --
1665:
1666: IF NOT FND_API.compatible_api_call(
1667: l_api_version_number,
1668: p_api_version_number,
1669: l_api_name,
1670: G_PKG_NAME) THEN
1667: l_api_version_number,
1668: p_api_version_number,
1669: l_api_name,
1670: G_PKG_NAME) THEN
1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1672: END IF;
1673:
1674: -- Check p_init_msg_list
1675: IF FND_API.to_boolean(p_init_msg_list) THEN
1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1672: END IF;
1673:
1674: -- Check p_init_msg_list
1675: IF FND_API.to_boolean(p_init_msg_list) THEN
1676: FND_MSG_PUB.initialize;
1677: END IF;
1678: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1679:
1707: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1708: END IF;
1709:
1710:
1711: IF FND_API.TO_BOOLEAN(p_commit) THEN
1712: --
1713: -- Start code for Bugfix 4070732
1714: --
1715: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1725: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1726: END IF;
1727:
1728: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1729: RAISE FND_API.G_EXC_ERROR;
1730: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1732: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1733: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1727:
1728: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1729: RAISE FND_API.G_EXC_ERROR;
1730: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1732: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1733: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1734: END IF;
1735:
1747: --{
1748: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1749: --{
1750:
1751: IF FND_API.TO_BOOLEAN(p_commit) THEN
1752:
1753: IF l_debug_on THEN
1754: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1755: END IF;
1775: x_return_status := l_return_status;
1776:
1777: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1778: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1779: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
1780: ROLLBACK TO AUTOCREATE_DEL_GRP;
1781: end if;
1782: END IF;
1783: END IF;
1791: FND_MSG_PUB.Count_And_Get
1792: (
1793: p_count => x_msg_count,
1794: p_data => x_msg_data,
1795: p_encoded => FND_API.G_FALSE
1796: );
1797:
1798:
1799: IF l_debug_on THEN
1801: WSH_DEBUG_SV.pop(l_module_name);
1802: END IF;
1803: --
1804: EXCEPTION
1805: WHEN FND_API.G_EXC_ERROR THEN
1806: ROLLBACK TO AUTOCREATE_DEL_GRP;
1807: x_return_status := FND_API.G_RET_STS_ERROR ;
1808: --
1809: -- Start code for Bugfix 4070732
1803: --
1804: EXCEPTION
1805: WHEN FND_API.G_EXC_ERROR THEN
1806: ROLLBACK TO AUTOCREATE_DEL_GRP;
1807: x_return_status := FND_API.G_RET_STS_ERROR ;
1808: --
1809: -- Start code for Bugfix 4070732
1810: --
1811: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1837: FND_MSG_PUB.Count_And_Get
1838: (
1839: p_count => x_msg_count,
1840: p_data => x_msg_data,
1841: p_encoded => FND_API.G_FALSE
1842: );
1843:
1844:
1845: IF l_debug_on THEN
1842: );
1843:
1844:
1845: IF l_debug_on THEN
1846: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1847: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1848: END IF;
1849: --
1850:
1843:
1844:
1845: IF l_debug_on THEN
1846: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1847: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1848: END IF;
1849: --
1850:
1851: WHEN autocreate_delivery_failed THEN
1885: FND_MSG_PUB.Count_And_Get
1886: (
1887: p_count => x_msg_count,
1888: p_data => x_msg_data,
1889: p_encoded => FND_API.G_FALSE
1890: );
1891:
1892:
1893: IF l_debug_on THEN
1933: FND_MSG_PUB.Count_And_Get
1934: (
1935: p_count => x_msg_count,
1936: p_data => x_msg_data,
1937: p_encoded => FND_API.G_FALSE
1938: );
1939:
1940:
1941: IF l_debug_on THEN
1942: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1943: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1944: END IF;
1945: --
1946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1947: ROLLBACK TO AUTOCREATE_DEL_GRP;
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1949: --
1950: -- Start of code for Bugfix 4070732
1944: END IF;
1945: --
1946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1947: ROLLBACK TO AUTOCREATE_DEL_GRP;
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1949: --
1950: -- Start of code for Bugfix 4070732
1951: --
1952: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1971: FND_MSG_PUB.Count_And_Get
1972: (
1973: p_count => x_msg_count,
1974: p_data => x_msg_data,
1975: p_encoded => FND_API.G_FALSE
1976: );
1977: --
1978: IF l_debug_on THEN
1979: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1975: p_encoded => FND_API.G_FALSE
1976: );
1977: --
1978: IF l_debug_on THEN
1979: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1981: END IF;
1982: --
1983: WHEN OTHERS THEN
1976: );
1977: --
1978: IF l_debug_on THEN
1979: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1981: END IF;
1982: --
1983: WHEN OTHERS THEN
1984: ROLLBACK TO AUTOCREATE_DEL_GRP;
1981: END IF;
1982: --
1983: WHEN OTHERS THEN
1984: ROLLBACK TO AUTOCREATE_DEL_GRP;
1985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1986: wsh_util_core.add_message(x_return_status, l_module_name);
1987: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries');
1988: --
1989: -- Start of code for Bugfix 4070732
2010: FND_MSG_PUB.Count_And_Get
2011: (
2012: p_count => x_msg_count,
2013: p_data => x_msg_data,
2014: p_encoded => FND_API.G_FALSE
2015: );
2016: --
2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2070: WSH_DEBUG_SV.log(l_module_name,'P_LINE_ROWS.COUNT',P_LINE_ROWS.COUNT);
2071: END IF;
2072: --
2073:
2074: IF NOT FND_API.compatible_api_call(
2075: l_api_version_number,
2076: p_api_version_number,
2077: l_api_name,
2078: G_PKG_NAME) THEN
2075: l_api_version_number,
2076: p_api_version_number,
2077: l_api_name,
2078: G_PKG_NAME) THEN
2079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2080: END IF;
2081:
2082: -- Check p_init_msg_list
2083: IF FND_API.to_boolean(p_init_msg_list) THEN
2079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2080: END IF;
2081:
2082: -- Check p_init_msg_list
2083: IF FND_API.to_boolean(p_init_msg_list) THEN
2084: FND_MSG_PUB.initialize;
2085: END IF;
2086: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2087:
2115: FND_MSG_PUB.Count_And_Get
2116: (
2117: p_count => x_msg_count,
2118: p_data => x_msg_data,
2119: p_encoded => FND_API.G_FALSE
2120: );
2121:
2122: IF FND_API.TO_BOOLEAN(p_commit) THEN
2123: COMMIT WORK;
2118: p_data => x_msg_data,
2119: p_encoded => FND_API.G_FALSE
2120: );
2121:
2122: IF FND_API.TO_BOOLEAN(p_commit) THEN
2123: COMMIT WORK;
2124: END IF;
2125:
2126: IF l_debug_on THEN
2129: WSH_DEBUG_SV.pop(l_module_name);
2130: END IF;
2131: --
2132: EXCEPTION
2133: WHEN FND_API.G_EXC_ERROR THEN
2134: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2135: x_return_status := FND_API.G_RET_STS_ERROR ;
2136: FND_MSG_PUB.Count_And_Get
2137: (
2131: --
2132: EXCEPTION
2133: WHEN FND_API.G_EXC_ERROR THEN
2134: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2135: x_return_status := FND_API.G_RET_STS_ERROR ;
2136: FND_MSG_PUB.Count_And_Get
2137: (
2138: p_count => x_msg_count,
2139: p_data => x_msg_data,
2136: FND_MSG_PUB.Count_And_Get
2137: (
2138: p_count => x_msg_count,
2139: p_data => x_msg_data,
2140: p_encoded => FND_API.G_FALSE
2141: );
2142:
2143: IF l_debug_on THEN
2144: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2140: p_encoded => FND_API.G_FALSE
2141: );
2142:
2143: IF l_debug_on THEN
2144: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2146: END IF;
2147: --
2148: WHEN autocreate_trip_failed THEN
2141: );
2142:
2143: IF l_debug_on THEN
2144: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2146: END IF;
2147: --
2148: WHEN autocreate_trip_failed THEN
2149: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2152: FND_MSG_PUB.Count_And_Get
2153: (
2154: p_count => x_msg_count,
2155: p_data => x_msg_data,
2156: p_encoded => FND_API.G_FALSE
2157: );
2158: IF l_debug_on THEN
2159: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_TRIP_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2160: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_TRIP_FAILED');
2165: FND_MSG_PUB.Count_And_Get
2166: (
2167: p_count => x_msg_count,
2168: p_data => x_msg_data,
2169: p_encoded => FND_API.G_FALSE
2170: );
2171: --
2172: IF l_debug_on THEN
2173: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2173: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2174: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2175: END IF;
2176: --
2177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2178: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2180: FND_MSG_PUB.Count_And_Get
2181: (
2175: END IF;
2176: --
2177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2178: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2180: FND_MSG_PUB.Count_And_Get
2181: (
2182: p_count => x_msg_count,
2183: p_data => x_msg_data,
2180: FND_MSG_PUB.Count_And_Get
2181: (
2182: p_count => x_msg_count,
2183: p_data => x_msg_data,
2184: p_encoded => FND_API.G_FALSE
2185: );
2186: --
2187:
2188: IF l_debug_on THEN
2185: );
2186: --
2187:
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2191: END IF;
2192: --
2193: WHEN OTHERS THEN
2186: --
2187:
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2191: END IF;
2192: --
2193: WHEN OTHERS THEN
2194: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2191: END IF;
2192: --
2193: WHEN OTHERS THEN
2194: ROLLBACK TO AUTOCREATE_TRIP_GRP;
2195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2196: wsh_util_core.add_message(x_return_status, l_module_name);
2197: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Autocreate_Del_Trip');
2198: FND_MSG_PUB.Count_And_Get
2199: (
2198: FND_MSG_PUB.Count_And_Get
2199: (
2200: p_count => x_msg_count,
2201: p_data => x_msg_data,
2202: p_encoded => FND_API.G_FALSE
2203: );
2204: --
2205: IF l_debug_on THEN
2206: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2513: END IF;
2514: --
2515: -- Initialize message list if p_init_msg_list is set to TRUE.
2516: --
2517: IF FND_API.to_Boolean( p_init_msg_list )
2518: THEN
2519: FND_MSG_PUB.initialize;
2520: ELSE
2521: IF nvl(l_check_dcp, -99) IN (1,2) THEN
2538: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2539: IF l_debug_on THEN
2540: wsh_debug_sv.logmsg(l_module_name,'Null Caller');
2541: END IF;
2542: RAISE FND_API.G_EXC_ERROR;
2543: ELSIF(p_action_prms.action_code IS NULL) THEN
2544: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2545: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'ACTION_CODE');
2546: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2546: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2547: IF l_debug_on THEN
2548: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
2549: END IF;
2550: RAISE FND_API.G_EXC_ERROR;
2551: END IF;
2552:
2553: IF(p_rec_attr_tab.count = 0) THEN
2554: IF l_debug_on THEN
2553: IF(p_rec_attr_tab.count = 0) THEN
2554: IF l_debug_on THEN
2555: wsh_debug_sv.logmsg(l_module_name,'Table count zero');
2556: END IF;
2557: RAISE FND_API.G_EXC_ERROR;
2558: END IF;
2559: --
2560: -- bug 2788946
2561: -- This condition is added so that we treat these actions
2580: --
2581: Delivery_Detail_Action
2582: (
2583: p_api_version_number => p_api_version_number,
2584: p_init_msg_list => FND_API.G_FALSE,
2585: p_commit => FND_API.G_FALSE,
2586: x_return_status => l_return_status,
2587: x_msg_count => l_msg_count,
2588: x_msg_data => l_msg_data,
2581: Delivery_Detail_Action
2582: (
2583: p_api_version_number => p_api_version_number,
2584: p_init_msg_list => FND_API.G_FALSE,
2585: p_commit => FND_API.G_FALSE,
2586: x_return_status => l_return_status,
2587: x_msg_count => l_msg_count,
2588: x_msg_data => l_msg_data,
2589: p_rec_attr_tab => p_rec_attr_tab,
2615: --
2616: Delivery_Detail_Action
2617: (
2618: p_api_version_number => p_api_version_number,
2619: p_init_msg_list => FND_API.G_FALSE,
2620: p_commit => FND_API.G_FALSE,
2621: x_return_status => l_return_status,
2622: x_msg_count => l_msg_count,
2623: x_msg_data => l_msg_data,
2616: Delivery_Detail_Action
2617: (
2618: p_api_version_number => p_api_version_number,
2619: p_init_msg_list => FND_API.G_FALSE,
2620: p_commit => FND_API.G_FALSE,
2621: x_return_status => l_return_status,
2622: x_msg_count => l_msg_count,
2623: x_msg_data => l_msg_data,
2624: p_rec_attr_tab => p_rec_attr_tab,
2746: IF l_debug_on THEN
2747: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION');
2748: END IF;
2749: --
2750: raise FND_API.G_EXC_ERROR;
2751: --}
2752: END IF;
2753:
2754: IF( l_validation_level_tab(wsh_actions_levels.C_DLVY_ACTION_ENABLED_LVL) = 1) THEN
2770: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2771: IF l_debug_on THEN
2772: wsh_debug_sv.logmsg(l_module_name, 'Delivery does not exist');
2773: END IF;
2774: RAISE FND_API.G_EXC_ERROR;
2775: END IF;
2776: CLOSE del_cur;
2777: ELSE
2778: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
2780: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2781: IF l_debug_on THEN
2782: wsh_debug_sv.logmsg(l_module_name, 'Null Delivery Id');
2783: END IF;
2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;
2786:
2787: l_dlvy_rec_tab(1).delivery_id := p_action_prms.delivery_id;
2788: l_dlvy_rec_tab(1).organization_id := l_dlvy_organization_id;
2867: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
2868: IF l_debug_on THEN
2869: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION');
2870: END IF;
2871: RAISE FND_API.G_EXC_ERROR;
2872: END IF;
2873: --
2874: IF l_number_of_warnings > 0 THEN
2875:
2885: ELSE
2886: IF l_debug_on THEN
2887: wsh_debug_sv.log(l_module_name,'Number of warnings', l_number_of_warnings);
2888: END IF;
2889: RAISE FND_API.G_EXC_ERROR;
2890: END IF;
2891: END IF;
2892:
2893:
2902: IF wsh_util_core.fte_is_installed = 'Y' THEN
2903:
2904: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(
2905: p_api_version_number => 1.0,
2906: p_init_msg_list => FND_API.G_FALSE,
2907: p_entity_type => 'L',
2908: p_target_id => p_action_prms.DELIVERY_ID,
2909: p_action_code => p_action_prms.action_code,
2910: p_del_attr_tab => l_cc_del_attr_tab,
3047: FND_MESSAGE.SET_NAME('WSH', 'WSH_OPM_LOT_INDIVISIBLE');
3048: IF p_action_prms.caller = 'WSH_FSTRX' THEN
3049: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3050: END IF;
3051: RAISE FND_API.G_EXC_ERROR;
3052: END IF;
3053: END IF; -- Added for bug 15885718
3054: END IF;
3055:
3077: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3078: IF l_debug_on THEN
3079: wsh_debug_sv.logmsg(l_module_name,'WSH_UI_MULTI_SELECTION');
3080: END IF;
3081: RAISE FND_API.G_EXC_ERROR;
3082: END IF;
3083: END IF;
3084:
3085: IF l_debug_on THEN
3155: END IF;
3156: --
3157: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(
3158: p_api_version => l_api_version,
3159: p_init_msg_list => FND_API.G_FALSE,
3160: p_commit => FND_API.G_FALSE,
3161: p_validation_level => l_validation_level,
3162: x_return_status => l_return_status,
3163: x_msg_count => l_msg_count,
3156: --
3157: WSH_DELIVERY_DETAILS_GRP.detail_to_delivery(
3158: p_api_version => l_api_version,
3159: p_init_msg_list => FND_API.G_FALSE,
3160: p_commit => FND_API.G_FALSE,
3161: p_validation_level => l_validation_level,
3162: x_return_status => l_return_status,
3163: x_msg_count => l_msg_count,
3164: x_msg_data => l_msg_data,
3210: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3211: IF l_debug_on THEN
3212: wsh_debug_sv.logmsg(l_module_name,'Zero or Null split quantity');
3213: END IF;
3214: RAISE FND_API.G_EXC_ERROR;
3215: END IF;
3216:
3217: --
3218: IF l_debug_on THEN
3234:
3235: -- HW OPMCONV - 1) No need to check for process_org
3236: -- - 2) check for value of UOM2 before calling the validation
3237: IF ( l_requested_quantity_uom2 IS NOT NULL
3238: AND l_requested_quantity_uom2 <> FND_API.G_MISS_CHAR) THEN
3239:
3240: --{
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.validate_secondary_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
3288: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.SPLIT_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
3289: END IF;
3290: WSH_DELIVERY_DETAILS_GRP.split_line(
3291: p_api_version => l_api_version,
3292: p_init_msg_list => FND_API.G_FALSE,
3293: p_commit => FND_API.G_FALSE,
3294: p_validation_level => l_validation_level,
3295: x_return_status => l_return_status,
3296: x_msg_count => l_msg_count,
3289: END IF;
3290: WSH_DELIVERY_DETAILS_GRP.split_line(
3291: p_api_version => l_api_version,
3292: p_init_msg_list => FND_API.G_FALSE,
3293: p_commit => FND_API.G_FALSE,
3294: p_validation_level => l_validation_level,
3295: x_return_status => l_return_status,
3296: x_msg_count => l_msg_count,
3297: x_msg_data => l_msg_data,
3357: END IF;
3358:
3359: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3360: p_api_version_number => l_api_version,
3361: p_init_msg_list => FND_API.G_FALSE,
3362: p_commit => FND_API.G_FALSE,
3363: p_caller => p_action_prms.caller,
3364: x_return_status => l_return_status ,
3365: x_msg_count => l_msg_count,
3358:
3359: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3360: p_api_version_number => l_api_version,
3361: p_init_msg_list => FND_API.G_FALSE,
3362: p_commit => FND_API.G_FALSE,
3363: p_caller => p_action_prms.caller,
3364: x_return_status => l_return_status ,
3365: x_msg_count => l_msg_count,
3366: x_msg_data => l_msg_data,
3448: ELSE
3449:
3450: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3451: p_api_version_number => l_api_version,
3452: p_init_msg_list => FND_API.G_FALSE,
3453: p_commit => FND_API.G_FALSE,
3454: p_caller => p_action_prms.caller,
3455: x_return_status => l_return_status ,
3456: x_msg_count => l_msg_count,
3449:
3450: WSH_DELIVERY_DETAILS_GRP.Autocreate_Deliveries(
3451: p_api_version_number => l_api_version,
3452: p_init_msg_list => FND_API.G_FALSE,
3453: p_commit => FND_API.G_FALSE,
3454: p_caller => p_action_prms.caller,
3455: x_return_status => l_return_status ,
3456: x_msg_count => l_msg_count,
3457: x_msg_data => l_msg_data,
3497: END IF;
3498: --
3499: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(
3500: p_api_version_number => l_api_version,
3501: p_init_msg_list => FND_API.G_FALSE,
3502: p_commit => FND_API.G_FALSE,
3503: x_return_status => l_return_status,
3504: x_msg_count => l_msg_count,
3505: x_msg_data => l_msg_data,
3498: --
3499: WSH_DELIVERY_DETAILS_GRP.Autocreate_del_trip(
3500: p_api_version_number => l_api_version,
3501: p_init_msg_list => FND_API.G_FALSE,
3502: p_commit => FND_API.G_FALSE,
3503: x_return_status => l_return_status,
3504: x_msg_count => l_msg_count,
3505: x_msg_data => l_msg_data,
3506: p_line_rows => l_id_tab,
3670: END IF;
3671:
3672: wsh_container_grp.Container_Actions(
3673: p_api_version => l_api_version,
3674: p_init_msg_list => FND_API.G_FALSE,
3675: p_commit => FND_API.G_FALSE,
3676: p_validation_level => wsh_container_grp.C_DELIVERY_DETAIL_CALL,
3677: x_return_status => l_return_status,
3678: x_msg_count => l_msg_count,
3671:
3672: wsh_container_grp.Container_Actions(
3673: p_api_version => l_api_version,
3674: p_init_msg_list => FND_API.G_FALSE,
3675: p_commit => FND_API.G_FALSE,
3676: p_validation_level => wsh_container_grp.C_DELIVERY_DETAIL_CALL,
3677: x_return_status => l_return_status,
3678: x_msg_count => l_msg_count,
3679: x_msg_data => l_msg_data,
3751: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_GRP.AUTO_PACK',WSH_DEBUG_SV.C_PROC_LEVEL);
3752: END IF;
3753: wsh_container_grp.Auto_Pack (
3754: p_api_version => l_api_version,
3755: p_init_msg_list => FND_API.G_FALSE,
3756: p_commit => FND_API.G_FALSE,
3757: p_validation_level => l_validation_level,
3758: x_return_status => l_return_status,
3759: x_msg_count => l_msg_count,
3752: END IF;
3753: wsh_container_grp.Auto_Pack (
3754: p_api_version => l_api_version,
3755: p_init_msg_list => FND_API.G_FALSE,
3756: p_commit => FND_API.G_FALSE,
3757: p_validation_level => l_validation_level,
3758: x_return_status => l_return_status,
3759: x_msg_count => l_msg_count,
3760: x_msg_data => l_msg_data,
3784: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_GRP.AUTO_PACK',WSH_DEBUG_SV.C_PROC_LEVEL);
3785: END IF;
3786: wsh_container_grp.Auto_Pack (
3787: p_api_version => p_api_version_number,
3788: p_init_msg_list => FND_API.G_FALSE,
3789: p_commit => FND_API.G_FALSE,
3790: p_validation_level => l_validation_level,
3791: x_return_status => l_return_status,
3792: x_msg_count => l_msg_count,
3785: END IF;
3786: wsh_container_grp.Auto_Pack (
3787: p_api_version => p_api_version_number,
3788: p_init_msg_list => FND_API.G_FALSE,
3789: p_commit => FND_API.G_FALSE,
3790: p_validation_level => l_validation_level,
3791: x_return_status => l_return_status,
3792: x_msg_count => l_msg_count,
3793: x_msg_data => l_msg_data ,
3845: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_GRP.CONTAINER_ACTIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
3846: END IF;
3847: wsh_container_grp.Container_Actions(
3848: p_api_version => l_api_version,
3849: p_init_msg_list => FND_API.G_FALSE,
3850: p_commit => FND_API.G_FALSE,
3851: p_validation_level => wsh_container_grp.C_DELIVERY_DETAIL_CALL,
3852: x_return_status => l_return_status,
3853: x_msg_count => l_msg_count,
3846: END IF;
3847: wsh_container_grp.Container_Actions(
3848: p_api_version => l_api_version,
3849: p_init_msg_list => FND_API.G_FALSE,
3850: p_commit => FND_API.G_FALSE,
3851: p_validation_level => wsh_container_grp.C_DELIVERY_DETAIL_CALL,
3852: x_return_status => l_return_status,
3853: x_msg_count => l_msg_count,
3854: x_msg_data => l_msg_data ,
3912: CLOSE cycle_count_cur;
3913: IF l_debug_on THEN
3914: wsh_debug_sv.logmsg(l_module_name,'Detail not found');
3915: END IF;
3916: RAISE FND_API.G_EXC_ERROR;
3917: END IF;
3918:
3919: CLOSE cycle_count_cur;
3920: --
3926: wsh_debug_sv.logmsg(l_module_name,'Incorrect Released status or incorrect quantities');
3927: END IF;
3928: fnd_message.set_name('WSH', 'WSH_CC_RSV_INSUFF');
3929: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3930: raise FND_API.G_EXC_ERROR;
3931: END IF;
3932: --
3933: --
3934:
3952:
3953: IF p_action_prms.caller = 'WSH_FSTRX' THEN
3954: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3955: END IF;
3956: RAISE FND_API.G_EXC_ERROR;
3957: END IF;
3958:
3959: -- HW end of 2677054
3960:
3985: wsh_debug_sv.logmsg(l_module_name,'Incorrect quantities');
3986: END IF;
3987: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_SPLIT_EXCEED');
3988: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3989: raise FND_API.G_EXC_ERROR;
3990:
3991: END IF;
3992:
3993: -- Calculate the quantities to be passed to backorder API
4043: END IF;
4044: --
4045:
4046: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
4047: raise FND_API.G_EXC_ERROR;
4048: END IF;
4049:
4050: --
4051: END IF;
4160: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4161: IF l_debug_on THEN
4162: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
4163: END IF;
4164: RAISE FND_API.G_EXC_ERROR;
4165: --
4166: END IF;
4167: --
4168: --
4268: l1_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4269: END IF;
4270: --
4271: -- Standard check of p_commit.
4272: IF FND_API.To_Boolean( p_commit ) THEN
4273: IF(l_debug_on) THEN
4274: wsh_debug_sv.logmsg(l_module_name, 'Commit Work');
4275: END IF;
4276: --
4307: --{
4308: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
4309: --{
4310:
4311: IF FND_API.To_Boolean( p_commit ) THEN
4312: IF l_debug_on THEN
4313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
4314: END IF;
4315:
4352: FND_MSG_PUB.Count_And_Get
4353: (
4354: p_count => x_msg_count,
4355: p_data => x_msg_data,
4356: p_encoded => FND_API.G_FALSE
4357: );
4358:
4359:
4360: IF l_debug_on THEN
4360: IF l_debug_on THEN
4361: WSH_DEBUG_SV.pop(l_module_name);
4362: END IF;
4363: --
4364: WHEN FND_API.G_EXC_ERROR THEN
4365: -- ROLLBACK TO DELIVERY_DETAIL_ACTION_GRP;
4366: x_return_status := FND_API.G_RET_STS_ERROR ;
4367: --
4368: IF del_cur%ISOPEN THEN
4362: END IF;
4363: --
4364: WHEN FND_API.G_EXC_ERROR THEN
4365: -- ROLLBACK TO DELIVERY_DETAIL_ACTION_GRP;
4366: x_return_status := FND_API.G_RET_STS_ERROR ;
4367: --
4368: IF del_cur%ISOPEN THEN
4369: CLOSE del_cur;
4370: END IF;
4431: FND_MSG_PUB.Count_And_Get
4432: (
4433: p_count => x_msg_count,
4434: p_data => x_msg_data,
4435: p_encoded => FND_API.G_FALSE
4436: );
4437:
4438:
4439: IF l_debug_on THEN
4436: );
4437:
4438:
4439: IF l_debug_on THEN
4440: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4442: END IF;
4443: --
4444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4437:
4438:
4439: IF l_debug_on THEN
4440: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4442: END IF;
4443: --
4444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4445: -- ROLLBACK TO DELIVERY_DETAIL_ACTION_GRP;
4440: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4442: END IF;
4443: --
4444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4445: -- ROLLBACK TO DELIVERY_DETAIL_ACTION_GRP;
4446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4447:
4448: IF del_cur%ISOPEN THEN
4442: END IF;
4443: --
4444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4445: -- ROLLBACK TO DELIVERY_DETAIL_ACTION_GRP;
4446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4447:
4448: IF del_cur%ISOPEN THEN
4449: CLOSE del_cur;
4450: END IF;
4505: FND_MSG_PUB.Count_And_Get
4506: (
4507: p_count => x_msg_count,
4508: p_data => x_msg_data,
4509: p_encoded => FND_API.G_FALSE
4510: );
4511:
4512:
4513: IF l_debug_on THEN
4510: );
4511:
4512:
4513: IF l_debug_on THEN
4514: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4515: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4516: END IF;
4517: --
4518: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4511:
4512:
4513: IF l_debug_on THEN
4514: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4515: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4516: END IF;
4517: --
4518: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4519: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4586: FND_MSG_PUB.Count_And_Get
4587: (
4588: p_count => x_msg_count,
4589: p_data => x_msg_data,
4590: p_encoded => FND_API.G_FALSE
4591: );
4592:
4593: IF l_debug_on THEN
4594: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4600: CLOSE del_cur;
4601: END IF;
4602:
4603: -- ROLLBACK TO DELIVERY_DETAIL_ACTION_GRP;
4604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4605: IF cycle_count_cur%ISOPEN THEN
4606: Close cycle_count_cur;
4607: END IF;
4608: wsh_util_core.add_message(x_return_status, l_module_name);
4663: FND_MSG_PUB.Count_And_Get
4664: (
4665: p_count => x_msg_count,
4666: p_data => x_msg_data,
4667: p_encoded => FND_API.G_FALSE
4668: );
4669: --
4670:
4671: IF l_debug_on THEN
4771: END IF;
4772: --
4773:
4774: -- Initialize message list if p_init_msg_list is set to TRUE.
4775: IF FND_API.to_Boolean( p_init_msg_list )
4776: THEN
4777: FND_MSG_PUB.initialize;
4778: END IF;
4779:
4785: /* Call the New Overloaded API */
4786:
4787: create_update_delivery_detail(
4788: p_api_version_number => p_api_version_number,
4789: p_init_msg_list => FND_API.G_FALSE,
4790: p_commit => FND_API.G_FALSE,
4791: x_return_status => l_return_status,
4792: x_msg_count => l_msg_count,
4793: x_msg_data => l_msg_data,
4786:
4787: create_update_delivery_detail(
4788: p_api_version_number => p_api_version_number,
4789: p_init_msg_list => FND_API.G_FALSE,
4790: p_commit => FND_API.G_FALSE,
4791: x_return_status => l_return_status,
4792: x_msg_count => l_msg_count,
4793: x_msg_data => l_msg_data,
4794: p_detail_info_tab => p_detail_info_tab,
4810: END IF;
4811:
4812:
4813: -- Standard check of p_commit.
4814: IF FND_API.To_Boolean( p_commit ) THEN
4815: IF(l_debug_on) THEN
4816: wsh_debug_sv.logmsg(l_module_name, 'Commit Work');
4817: END IF;
4818: COMMIT WORK;
4821: FND_MSG_PUB.Count_And_Get
4822: (
4823: p_count => x_msg_count,
4824: p_data => x_msg_data,
4825: p_encoded => FND_API.G_FALSE
4826: );
4827:
4828: IF l_debug_on THEN
4829: WSH_DEBUG_SV.pop(l_module_name);
4829: WSH_DEBUG_SV.pop(l_module_name);
4830: END IF;
4831: --
4832: EXCEPTION
4833: WHEN FND_API.G_EXC_ERROR THEN
4834: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4835: x_return_status := FND_API.G_RET_STS_ERROR ;
4836: FND_MSG_PUB.Count_And_Get
4837: (
4831: --
4832: EXCEPTION
4833: WHEN FND_API.G_EXC_ERROR THEN
4834: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4835: x_return_status := FND_API.G_RET_STS_ERROR ;
4836: FND_MSG_PUB.Count_And_Get
4837: (
4838: p_count => x_msg_count,
4839: p_data => x_msg_data,
4836: FND_MSG_PUB.Count_And_Get
4837: (
4838: p_count => x_msg_count,
4839: p_data => x_msg_data,
4840: p_encoded => FND_API.G_FALSE
4841: );
4842: --
4843: IF l_debug_on THEN
4844: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4840: p_encoded => FND_API.G_FALSE
4841: );
4842: --
4843: IF l_debug_on THEN
4844: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4845: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4846: END IF;
4847: --
4848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4841: );
4842: --
4843: IF l_debug_on THEN
4844: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4845: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4846: END IF;
4847: --
4848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4849: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4844: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4845: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4846: END IF;
4847: --
4848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4849: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4851: FND_MSG_PUB.Count_And_Get
4852: (
4846: END IF;
4847: --
4848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4849: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4851: FND_MSG_PUB.Count_And_Get
4852: (
4853: p_count => x_msg_count,
4854: p_data => x_msg_data,
4851: FND_MSG_PUB.Count_And_Get
4852: (
4853: p_count => x_msg_count,
4854: p_data => x_msg_data,
4855: p_encoded => FND_API.G_FALSE
4856: );
4857:
4858: --
4859: IF l_debug_on THEN
4856: );
4857:
4858: --
4859: IF l_debug_on THEN
4860: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4861: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4862: END IF;
4863: --
4864: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4857:
4858: --
4859: IF l_debug_on THEN
4860: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4861: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4862: END IF;
4863: --
4864: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4865: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4866: FND_MSG_PUB.Count_And_Get
4867: (
4868: p_count => x_msg_count,
4869: p_data => x_msg_data,
4870: p_encoded => FND_API.G_FALSE
4871: );
4872: --
4873: IF l_debug_on THEN
4874: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4882: FND_MSG_PUB.Count_And_Get
4883: (
4884: p_count => x_msg_count,
4885: p_data => x_msg_data,
4886: p_encoded => FND_API.G_FALSE
4887: );
4888: --
4889:
4890: --
4894: END IF;
4895: --
4896: WHEN OTHERS THEN
4897: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP;
4898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4899: wsh_util_core.add_message(x_return_status, l_module_name);
4900: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
4901: FND_MSG_PUB.Count_And_Get
4902: (
4901: FND_MSG_PUB.Count_And_Get
4902: (
4903: p_count => x_msg_count,
4904: p_data => x_msg_data,
4905: p_encoded => FND_API.G_FALSE
4906: );
4907: --
4908:
4909: IF l_debug_on THEN
5020: IF l_debug_on THEN
5021: WSH_DEBUG_SV.log(l_module_name,
5022: 'Invalid quantity', p_detail_IN_rec.quantity);
5023: END IF;
5024: raise fnd_api.g_exc_error;
5025: ELSE
5026: l_generate := TRUE;
5027: END IF;
5028:
5117: ELSE --}{
5118: fnd_message.set_name('WSH', 'WSH_INCORRECT_ORG');
5119: fnd_message.set_token('ORG_CODE', l_organization_code);
5120: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5121: RAISE FND_API.G_EXC_ERROR;
5122: END IF; -- wms_enabled }
5123: END IF; -- verify item}
5124: --
5125:
5135: 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);
5136: END IF;
5137: FND_MESSAGE.SET_NAME('WSH', 'WSH_UCC128_ERROR'); --bmso new
5138: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5139: RAISE FND_API.G_EXC_ERROR;
5140: END IF;
5141:
5142: IF p_detail_IN_rec.ucc_128_suffix_flag = 1 THEN
5143: l_suffix_length := 1;
5202: + GREATEST(p_detail_IN_rec.num_digits,NVL(LENGTH(l_base_number_dummy),0));
5203: END IF;
5204:
5205:
5206: l_total_length := NVL(l_total_length,FND_API.G_MISS_NUM);
5207: l_name_prefix := NVL(p_detail_IN_rec.name_prefix,FND_API.G_MISS_CHAR);
5208: l_name_suffix := NVL(p_detail_IN_rec.name_suffix,FND_API.G_MISS_CHAR);
5209:
5210: l_gen_lpn_rec.container_item_id := l_cont_item_id;
5203: END IF;
5204:
5205:
5206: l_total_length := NVL(l_total_length,FND_API.G_MISS_NUM);
5207: l_name_prefix := NVL(p_detail_IN_rec.name_prefix,FND_API.G_MISS_CHAR);
5208: l_name_suffix := NVL(p_detail_IN_rec.name_suffix,FND_API.G_MISS_CHAR);
5209:
5210: l_gen_lpn_rec.container_item_id := l_cont_item_id;
5211: l_gen_lpn_rec.organization_id := l_organization_id;
5204:
5205:
5206: l_total_length := NVL(l_total_length,FND_API.G_MISS_NUM);
5207: l_name_prefix := NVL(p_detail_IN_rec.name_prefix,FND_API.G_MISS_CHAR);
5208: l_name_suffix := NVL(p_detail_IN_rec.name_suffix,FND_API.G_MISS_CHAR);
5209:
5210: l_gen_lpn_rec.container_item_id := l_cont_item_id;
5211: l_gen_lpn_rec.organization_id := l_organization_id;
5212: l_gen_lpn_rec.lpn_prefix:= l_name_prefix;
5212: l_gen_lpn_rec.lpn_prefix:= l_name_prefix;
5213: l_gen_lpn_rec.lpn_suffix := l_name_suffix;
5214: l_gen_lpn_rec.starting_num := p_detail_IN_rec.base_number;
5215: IF p_detail_IN_rec.base_number IS NOT NULL THEN --{
5216: IF p_detail_IN_rec.base_number <> FND_API.G_MISS_NUM THEN
5217: IF l_lpn_starting_num = p_detail_IN_rec.base_number THEN
5218: l_gen_lpn_rec.starting_num := NULL;
5219: END IF;
5220: END IF;
5231: wsh_debug_sv.logmsg(l_module_name, 'Calling wms_container_grp.Auto_Create_LPNs');
5232: END IF;
5233: wms_container_grp.Auto_Create_LPNs (
5234: p_api_version => 1.0
5235: , p_init_msg_list => fnd_api.g_false
5236: , p_commit => fnd_api.g_false
5237: , x_return_status => l_return_status
5238: , x_msg_count => l_wms_msg_count
5239: , x_msg_data => l_wms_msg_data
5232: END IF;
5233: wms_container_grp.Auto_Create_LPNs (
5234: p_api_version => 1.0
5235: , p_init_msg_list => fnd_api.g_false
5236: , p_commit => fnd_api.g_false
5237: , x_return_status => l_return_status
5238: , x_msg_count => l_wms_msg_count
5239: , x_msg_data => l_wms_msg_data
5240: , p_caller => 'WSH_GENERATE'
5272: IF l_container_info_rec.lpn_ids(j) IS NULL THEN
5273: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5274: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5275: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5276: RAISE FND_API.G_EXC_ERROR;
5277:
5278: ELSIF l_container_info_rec.container_names(j) IS NULL THEN
5279: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5280: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5278: ELSIF l_container_info_rec.container_names(j) IS NULL THEN
5279: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5280: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5281: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5282: RAISE FND_API.G_EXC_ERROR;
5283:
5284: END IF;
5285:
5286: i := l_lpn_out_tab.NEXT(i);
5356: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
5357:
5358: wms_container_grp.create_lpns(
5359: p_api_version => 1.0,
5360: p_init_msg_list => fnd_api.g_false,
5361: p_commit => fnd_api.g_false,
5362: x_return_status => l_return_status,
5363: x_msg_count => l_wms_msg_count,
5364: x_msg_data => l_wms_msg_data,
5357:
5358: wms_container_grp.create_lpns(
5359: p_api_version => 1.0,
5360: p_init_msg_list => fnd_api.g_false,
5361: p_commit => fnd_api.g_false,
5362: x_return_status => l_return_status,
5363: x_msg_count => l_wms_msg_count,
5364: x_msg_data => l_wms_msg_data,
5365: p_caller => 'WSH_CREATE',
5380: IF l_container_info_rec.lpn_ids(1) IS NULL THEN
5381: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5382: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5383: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5384: RAISE FND_API.G_EXC_ERROR;
5385:
5386: ELSIF l_container_info_rec.container_names(1) IS NULL THEN
5387: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5388: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5386: ELSIF l_container_info_rec.container_names(1) IS NULL THEN
5387: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5388: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5389: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5390: RAISE FND_API.G_EXC_ERROR;
5391:
5392: END IF;
5393:
5394: l_container_rec.weight_uom_code :=
5459: END IF;
5460: --
5461: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5462: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5463: RAISE FND_API.G_EXC_ERROR;
5464: END IF;
5465:
5466: IF l_debug_on THEN
5467: WSH_DEBUG_SV.log(l_module_name,'COUNT OF WDD RECORDS',
5491: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5492: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5493: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5494: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5495: RAISE FND_API.G_EXC_ERROR;
5496: END IF;
5497:
5498:
5499: wsh_util_core.api_post_call(
5513: IF l_debug_on THEN
5514: wsh_debug_sv.log(l_module_name,'ERROR organization id is null for', p_detail_info_tab(i).lpn_id);
5515: END IF;
5516:
5517: raise FND_API.G_EXC_ERROR;
5518:
5519: END IF; --}
5520: IF p_detail_info_tab(i).lpn_id IS NULL THEN
5521: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5520: IF p_detail_info_tab(i).lpn_id IS NULL THEN
5521: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5522: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'LPN_ID');
5523: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5524: RAISE FND_API.G_EXC_ERROR;
5525:
5526: ELSIF p_detail_info_tab(i).container_name IS NULL THEN
5527: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5528: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5526: ELSIF p_detail_info_tab(i).container_name IS NULL THEN
5527: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5528: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'CONTAINER_NAME');
5529: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5530: RAISE FND_API.G_EXC_ERROR;
5531:
5532: END IF;
5533:
5534: l_container_info_rec.lpn_ids(1) := p_detail_info_tab(i).lpn_id;
5541: IF l_debug_on THEN
5542: WSH_DEBUG_SV.logmsg(l_module_name,
5543: 'organization is not passed');
5544: END IF;
5545: RAISE FND_API.G_EXC_ERROR;
5546: END IF; */
5547:
5548: wsh_container_actions.default_container_attr(l_container_rec,
5549: l_additional_cont_attr,
5571: END IF;
5572: --
5573: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5574: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5575: RAISE FND_API.G_EXC_ERROR;
5576: END IF;
5577:
5578: IF l_debug_on THEN
5579: WSH_DEBUG_SV.log(l_module_name,'COUNT OF WDD RECORDS',
5603: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5604: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
5605: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CREATE_ERROR');
5606: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
5607: RAISE FND_API.G_EXC_ERROR;
5608: END IF;
5609: --
5610: wsh_util_core.api_post_call(
5611: p_return_status => l_return_status,
5657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_lpn_count_invalid');
5658: END IF;
5659: --
5660:
5661: WHEN FND_API.G_EXC_ERROR THEN
5662: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5663: WSH_WMS_LPN_GRP.g_update_to_container := l_update_container_orig;
5664:
5665: rollback to s_create_containers_DDGPB;
5662: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5663: WSH_WMS_LPN_GRP.g_update_to_container := l_update_container_orig;
5664:
5665: rollback to s_create_containers_DDGPB;
5666: x_return_status := FND_API.G_RET_STS_ERROR ;
5667: IF l_debug_on THEN
5668: WSH_DEBUG_SV.logmsg(l_module_name,
5669: 'FND_API.G_EXC_ERROR exception has occured.',
5670: WSH_DEBUG_SV.C_EXCEP_LEVEL);
5665: rollback to s_create_containers_DDGPB;
5666: x_return_status := FND_API.G_RET_STS_ERROR ;
5667: IF l_debug_on THEN
5668: WSH_DEBUG_SV.logmsg(l_module_name,
5669: 'FND_API.G_EXC_ERROR exception has occured.',
5670: WSH_DEBUG_SV.C_EXCEP_LEVEL);
5671: WSH_DEBUG_SV.pop(l_module_name,
5672: 'EXCEPTION:FND_API.G_EXC_ERROR');
5673: END IF;
5668: WSH_DEBUG_SV.logmsg(l_module_name,
5669: 'FND_API.G_EXC_ERROR exception has occured.',
5670: WSH_DEBUG_SV.C_EXCEP_LEVEL);
5671: WSH_DEBUG_SV.pop(l_module_name,
5672: 'EXCEPTION:FND_API.G_EXC_ERROR');
5673: END IF;
5674: --
5675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5676: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5671: WSH_DEBUG_SV.pop(l_module_name,
5672: 'EXCEPTION:FND_API.G_EXC_ERROR');
5673: END IF;
5674: --
5675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5676: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5677: rollback to s_create_containers_DDGPB;
5678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5679:
5674: --
5675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5676: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5677: rollback to s_create_containers_DDGPB;
5678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5679:
5680: IF l_debug_on THEN
5681: WSH_DEBUG_SV.logmsg(l_module_name
5682: ,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.'
5678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5679:
5680: IF l_debug_on THEN
5681: WSH_DEBUG_SV.logmsg(l_module_name
5682: ,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.'
5683: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
5684: WSH_DEBUG_SV.pop(l_module_name
5685: ,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5686: END IF;
5681: WSH_DEBUG_SV.logmsg(l_module_name
5682: ,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.'
5683: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
5684: WSH_DEBUG_SV.pop(l_module_name
5685: ,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5686: END IF;
5687: --
5688: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5689: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5699: END IF;
5700: WHEN OTHERS THEN
5701: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
5702: rollback to s_create_containers_DDGPB;
5703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5704: wsh_util_core.add_message(x_return_status, l_module_name);
5705: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_containers');
5706: IF l_debug_on THEN
5707: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
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 Organization');
5827: END IF;
5828: raise FND_API.G_EXC_ERROR;
5829: ELSIF(p_detail_IN_rec.container_item_id IS NULL
5830: AND p_detail_IN_rec.container_item_name IS NULL
5831: AND p_detail_IN_rec.container_item_seg.count = 0) THEN
5832: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
5835: IF l_debug_on THEN
5836: wsh_debug_sv.logmsg(l_module_name,'Null Container item');
5837: END IF;
5838:
5839: raise FND_API.G_EXC_ERROR;
5840:
5841: END IF;
5842: END IF; --}
5843:
5859: IF(p_detail_info_tab(l_index).container_flag in ('Y', 'C')) THEN
5860: IF l_debug_on THEN
5861: wsh_debug_sv.logmsg(l_module_name,'Container Flag Yes ');
5862: END IF;
5863: RAISE FND_API.G_EXC_ERROR;
5864: END IF;
5865:
5866: IF p_detail_info_tab(l_index).inventory_item_id IS NOT NULL THEN --{
5867: -- Validate Item and see if this is container item
5889: x_num_errors => l_number_of_errors,
5890: p_msg_data => l_msg_data
5891: );
5892:
5893: IF(nvl(l_item_type, 'FND_API.G_MISS_CHAR') = 'CONT_ITEM') THEN
5894: IF l_debug_on THEN
5895: wsh_debug_sv.logmsg(l_module_name,'Container Item');
5896: END IF;
5897: RAISE FND_API.G_EXC_ERROR;
5893: IF(nvl(l_item_type, 'FND_API.G_MISS_CHAR') = 'CONT_ITEM') THEN
5894: IF l_debug_on THEN
5895: wsh_debug_sv.logmsg(l_module_name,'Container Item');
5896: END IF;
5897: RAISE FND_API.G_EXC_ERROR;
5898: END IF;
5899: END IF; --}
5900:
5901:
5924: --
5925: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5926: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_CREATE_DET_FAILED');
5927: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5928: RAISE FND_API.G_EXC_ERROR;
5929: END IF;
5930: l_delivery_assignments_info.delivery_id := NULL;
5931: l_delivery_assignments_info.parent_delivery_id := NULL;
5932: l_delivery_assignments_info.delivery_detail_id := l_new_detail_id;
5955:
5956: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
5957: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_CREATE_AS_FAILED');
5958: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
5959: RAISE FND_API.G_EXC_ERROR;
5960: END IF;
5961:
5962: --OTM R12, calling delivery detail splitter
5963: IF (l_gc3_is_installed = 'Y') THEN
6027: FND_MSG_PUB.Count_And_Get
6028: (
6029: p_count => x_msg_count,
6030: p_data => x_msg_data,
6031: p_encoded => FND_API.G_FALSE
6032: );
6033:
6034: -- Debug Statements
6035: --
6037: WSH_DEBUG_SV.pop(l_module_name);
6038: END IF;
6039: --
6040: EXCEPTION
6041: WHEN FND_API.G_EXC_ERROR THEN
6042: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6043: x_return_status := FND_API.G_RET_STS_ERROR ;
6044: FND_MSG_PUB.Count_And_Get
6045: (
6039: --
6040: EXCEPTION
6041: WHEN FND_API.G_EXC_ERROR THEN
6042: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6043: x_return_status := FND_API.G_RET_STS_ERROR ;
6044: FND_MSG_PUB.Count_And_Get
6045: (
6046: p_count => x_msg_count,
6047: p_data => x_msg_data,
6044: FND_MSG_PUB.Count_And_Get
6045: (
6046: p_count => x_msg_count,
6047: p_data => x_msg_data,
6048: p_encoded => FND_API.G_FALSE
6049: );
6050:
6051: IF l_debug_on THEN
6052: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6048: p_encoded => FND_API.G_FALSE
6049: );
6050:
6051: IF l_debug_on THEN
6052: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6053: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6054: END IF;
6055: --
6056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6049: );
6050:
6051: IF l_debug_on THEN
6052: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6053: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6054: END IF;
6055: --
6056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6057: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6052: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6053: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6054: END IF;
6055: --
6056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6057: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6059: FND_MSG_PUB.Count_And_Get
6060: (
6054: END IF;
6055: --
6056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6057: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6059: FND_MSG_PUB.Count_And_Get
6060: (
6061: p_count => x_msg_count,
6062: p_data => x_msg_data,
6059: FND_MSG_PUB.Count_And_Get
6060: (
6061: p_count => x_msg_count,
6062: p_data => x_msg_data,
6063: p_encoded => FND_API.G_FALSE
6064: );
6065:
6066: IF l_debug_on THEN
6067: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6063: p_encoded => FND_API.G_FALSE
6064: );
6065:
6066: IF l_debug_on THEN
6067: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6068: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6069: END IF;
6070: --
6071: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6064: );
6065:
6066: IF l_debug_on THEN
6067: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6068: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6069: END IF;
6070: --
6071: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6072: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6073: FND_MSG_PUB.Count_And_Get
6074: (
6075: p_count => x_msg_count,
6076: p_data => x_msg_data,
6077: p_encoded => FND_API.G_FALSE
6078: );
6079: --
6080: IF l_debug_on THEN
6081: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6084: --
6085: WHEN OTHERS THEN
6086:
6087: ROLLBACK to CREATE_DEL_DETAIL_GRP;
6088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6089: wsh_util_core.add_message(x_return_status, l_module_name);
6090: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Delivery_Detail');
6091: FND_MSG_PUB.Count_And_Get
6092: (
6091: FND_MSG_PUB.Count_And_Get
6092: (
6093: p_count => x_msg_count,
6094: p_data => x_msg_data,
6095: p_encoded => FND_API.G_FALSE
6096: );
6097:
6098: IF l_debug_on THEN
6099: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6360: /* you need to either have inventory_item_id or item_description */
6361: if (x_detail_info_tab(l_index).item_description is not NULL) then
6362:
6363: -- bug 2398865
6364: IF ( nvl(x_detail_info_tab(l_index).requested_quantity,fnd_api.g_miss_num) = fnd_api.g_miss_num ) THEN
6365: x_detail_info_tab(l_index).requested_quantity_uom := x_detail_info_tab(l_index).src_requested_quantity_uom;
6366: x_detail_info_tab(l_index).requested_quantity := x_detail_info_tab(l_index).src_requested_quantity;
6367: END IF;
6368: -- bug 2398865
6462: end if;
6463:
6464: -- bug 2398865
6465: --
6466: IF ( nvl(x_detail_info_tab(l_index).requested_quantity,fnd_api.g_miss_num) = fnd_api.g_miss_num ) THEN
6467:
6468: IF l_debug_on THEN
6469: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6470: END IF;
6522: l_number_of_errors := l_number_of_errors + 1;
6523: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_INVALID_DETAIL');
6524: FND_MESSAGE.SET_TOKEN('DETAIL_ID', x_detail_info_tab(l_index).delivery_detail_id);
6525: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
6526: RAISE FND_API.G_EXC_ERROR;
6527: END IF;
6528:
6529: CLOSE c_original_detail_cur;
6530:
6701: -- anxsharm , end of code for Load Tender
6702: -- moved code for vlaidating secondary quantity inside the ELSIF p_action = 'UPDATE' block
6703: -- PK Bug 3055126 Begin OPM Changes for validation of quantities
6704: IF ( p_caller = 'WSH_PUB') THEN
6705: IF (nvl(x_detail_info_tab(l_index).shipped_quantity,fnd_api.g_miss_num) <> fnd_api.g_miss_num OR
6706: nvl(x_detail_info_tab(l_index).shipped_quantity2,fnd_api.g_miss_num) <> fnd_api.g_miss_num) THEN
6707:
6708: -- HW OPMCONV - Use this API instead of GMI_RESERVATION_UTIL.validate_opm_quantities
6709:
6702: -- moved code for vlaidating secondary quantity inside the ELSIF p_action = 'UPDATE' block
6703: -- PK Bug 3055126 Begin OPM Changes for validation of quantities
6704: IF ( p_caller = 'WSH_PUB') THEN
6705: IF (nvl(x_detail_info_tab(l_index).shipped_quantity,fnd_api.g_miss_num) <> fnd_api.g_miss_num OR
6706: nvl(x_detail_info_tab(l_index).shipped_quantity2,fnd_api.g_miss_num) <> fnd_api.g_miss_num) THEN
6707:
6708: -- HW OPMCONV - Use this API instead of GMI_RESERVATION_UTIL.validate_opm_quantities
6709:
6710: WSH_DETAILS_VALIDATIONS.validate_secondary_quantity
6729: END IF;
6730:
6731: -- HW OPMCONV - Needed to add check for "0". Some cases cycle_count values
6732: -- had values of zeroes due to initialization issues
6733: IF ( ( nvl(x_detail_info_tab(l_index).cycle_count_quantity,fnd_api.g_miss_num) <> fnd_api.g_miss_num
6734: OR nvl(x_detail_info_tab(l_index).cycle_count_quantity2,fnd_api.g_miss_num) <> fnd_api.g_miss_num )
6735: AND ( x_detail_info_tab(l_index).cycle_count_quantity <> 0
6736: OR x_detail_info_tab(l_index).cycle_count_quantity2 <> 0) )
6737: THEN
6730:
6731: -- HW OPMCONV - Needed to add check for "0". Some cases cycle_count values
6732: -- had values of zeroes due to initialization issues
6733: IF ( ( nvl(x_detail_info_tab(l_index).cycle_count_quantity,fnd_api.g_miss_num) <> fnd_api.g_miss_num
6734: OR nvl(x_detail_info_tab(l_index).cycle_count_quantity2,fnd_api.g_miss_num) <> fnd_api.g_miss_num )
6735: AND ( x_detail_info_tab(l_index).cycle_count_quantity <> 0
6736: OR x_detail_info_tab(l_index).cycle_count_quantity2 <> 0) )
6737: THEN
6738:
6775: x_valid_index_tab(l_index) := l_index;
6776:
6777: --
6778: EXCEPTION -- for the local begin
6779: WHEN FND_API.G_EXC_ERROR THEN
6780: ROLLBACK TO validate_det_loop_grp;
6781: IF l_debug_on THEN
6782: wsh_debug_sv.log(l_module_name, 'Validation failure for detail', x_detail_info_tab(l_index).delivery_detail_id);
6783: END IF;
6781: IF l_debug_on THEN
6782: wsh_debug_sv.log(l_module_name, 'Validation failure for detail', x_detail_info_tab(l_index).delivery_detail_id);
6783: END IF;
6784:
6785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6786: ROLLBACK TO validate_det_loop_grp;
6787: IF l_debug_on THEN
6788: wsh_debug_sv.logmsg(l_module_name, 'Unexpected error within loop');
6789: END IF;
6819: ROLLBACK TO validate_det_loop_grp;
6820: IF l_debug_on THEN
6821: wsh_debug_sv.logmsg(l_module_name, 'Others exception within loop');
6822: END IF;
6823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6824: END; -- for the local begin
6825:
6826: -- Commented for bug 4399278, 4418754
6827: --x_valid_index_tab(l_index) := l_index;
6860: END IF;
6861:
6862: IF x_detail_info_tab.count > 0 THEN
6863: IF l_number_of_errors >= x_detail_info_tab.count THEN
6864: RAISE FND_API.G_EXC_ERROR;
6865: ELSIF l_number_of_errors >0 THEN
6866: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6867: ELSIF l_number_of_warnings > 0 THEN
6868: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
6872: FND_MSG_PUB.Count_And_Get
6873: (
6874: p_count => x_msg_count,
6875: p_data => x_msg_data,
6876: p_encoded => FND_API.G_FALSE
6877: );
6878:
6879: IF l_debug_on THEN
6880: WSH_DEBUG_SV.pop(l_module_name);
6880: WSH_DEBUG_SV.pop(l_module_name);
6881: END IF;
6882: --
6883: EXCEPTION
6884: WHEN FND_API.G_EXC_ERROR THEN
6885: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6886: x_return_status := FND_API.G_RET_STS_ERROR ;
6887: FND_MSG_PUB.Count_And_Get
6888: (
6882: --
6883: EXCEPTION
6884: WHEN FND_API.G_EXC_ERROR THEN
6885: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6886: x_return_status := FND_API.G_RET_STS_ERROR ;
6887: FND_MSG_PUB.Count_And_Get
6888: (
6889: p_count => x_msg_count,
6890: p_data => x_msg_data,
6887: FND_MSG_PUB.Count_And_Get
6888: (
6889: p_count => x_msg_count,
6890: p_data => x_msg_data,
6891: p_encoded => FND_API.G_FALSE
6892: );
6893: --
6894: IF l_debug_on THEN
6895: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6891: p_encoded => FND_API.G_FALSE
6892: );
6893: --
6894: IF l_debug_on THEN
6895: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6896: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6897: END IF;
6898: --
6899: --
6892: );
6893: --
6894: IF l_debug_on THEN
6895: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6896: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6897: END IF;
6898: --
6899: --
6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6896: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6897: END IF;
6898: --
6899: --
6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6901: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6903: FND_MSG_PUB.Count_And_Get
6904: (
6898: --
6899: --
6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6901: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6903: FND_MSG_PUB.Count_And_Get
6904: (
6905: p_count => x_msg_count,
6906: p_data => x_msg_data,
6903: FND_MSG_PUB.Count_And_Get
6904: (
6905: p_count => x_msg_count,
6906: p_data => x_msg_data,
6907: p_encoded => FND_API.G_FALSE
6908: );
6909: --
6910: IF l_debug_on THEN
6911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6907: p_encoded => FND_API.G_FALSE
6908: );
6909: --
6910: IF l_debug_on THEN
6911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6913: END IF;
6914: --
6915: --
6908: );
6909: --
6910: IF l_debug_on THEN
6911: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6912: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6913: END IF;
6914: --
6915: --
6916: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
6918: FND_MSG_PUB.Count_And_Get
6919: (
6920: p_count => x_msg_count,
6921: p_data => x_msg_data,
6922: p_encoded => FND_API.G_FALSE
6923: );
6924: --
6925: IF l_debug_on THEN
6926: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6931:
6932: WHEN OTHERS THEN
6933:
6934: ROLLBACK to VALIDATE_DEL_DETAIL_GRP;
6935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6936: wsh_util_core.add_message(x_return_status, l_module_name);
6937: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Delivery_Detail');
6938:
6939: FND_MSG_PUB.Count_And_Get
6939: FND_MSG_PUB.Count_And_Get
6940: (
6941: p_count => x_msg_count,
6942: p_data => x_msg_data,
6943: p_encoded => FND_API.G_FALSE
6944: );
6945: --
6946: IF l_debug_on THEN
6947: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7101: FND_MSG_PUB.Count_And_Get
7102: (
7103: p_count => x_msg_count,
7104: p_data => x_msg_data,
7105: p_encoded => FND_API.G_FALSE
7106: );
7107:
7108: --
7109: IF l_debug_on THEN
7110: WSH_DEBUG_SV.pop(l_module_name);
7111: END IF;
7112: --
7113: EXCEPTION
7114: WHEN FND_API.G_EXC_ERROR THEN
7115: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7116: x_return_status := FND_API.G_RET_STS_ERROR ;
7117: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7118: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7112: --
7113: EXCEPTION
7114: WHEN FND_API.G_EXC_ERROR THEN
7115: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7116: x_return_status := FND_API.G_RET_STS_ERROR ;
7117: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7118: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7119: FND_MSG_PUB.Count_And_Get
7120: (
7119: FND_MSG_PUB.Count_And_Get
7120: (
7121: p_count => x_msg_count,
7122: p_data => x_msg_data,
7123: p_encoded => FND_API.G_FALSE
7124: );
7125: --
7126:
7127: IF l_debug_on THEN
7124: );
7125: --
7126:
7127: IF l_debug_on THEN
7128: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7129: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7130: END IF;
7131: --
7132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7125: --
7126:
7127: IF l_debug_on THEN
7128: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7129: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7130: END IF;
7131: --
7132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7133: IF lock_delivery_details%isopen THEN
7128: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7129: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7130: END IF;
7131: --
7132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7133: IF lock_delivery_details%isopen THEN
7134: CLOSE lock_delivery_details;
7135: END IF;
7136: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7133: IF lock_delivery_details%isopen THEN
7134: CLOSE lock_delivery_details;
7135: END IF;
7136: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7138: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7139: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7140: FND_MSG_PUB.Count_And_Get
7141: (
7140: FND_MSG_PUB.Count_And_Get
7141: (
7142: p_count => x_msg_count,
7143: p_data => x_msg_data,
7144: p_encoded => FND_API.G_FALSE
7145: );
7146: --
7147: --
7148: IF l_debug_on THEN
7145: );
7146: --
7147: --
7148: IF l_debug_on THEN
7149: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7151: END IF;
7152: --
7153: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7146: --
7147: --
7148: IF l_debug_on THEN
7149: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7151: END IF;
7152: --
7153: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7154: IF lock_delivery_details%isopen THEN
7192: FND_MSG_PUB.Count_And_Get
7193: (
7194: p_count => x_msg_count,
7195: p_data => x_msg_data,
7196: p_encoded => FND_API.G_FALSE
7197: );
7198: --
7199: IF l_debug_on THEN
7200: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7251: CLOSE lock_delivery_details;
7252: END IF;
7253:
7254: ROLLBACK to UPDATE_DEL_DETAIL_GRP;
7255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7256: WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED := 'Y';
7257: WSH_WMS_LPN_GRP.g_update_to_container := 'N';
7258: wsh_util_core.add_message(x_return_status, l_module_name);
7259: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Update_Delivery_Detail');
7261: FND_MSG_PUB.Count_And_Get
7262: (
7263: p_count => x_msg_count,
7264: p_data => x_msg_data,
7265: p_encoded => FND_API.G_FALSE
7266: );
7267:
7268: IF l_debug_on THEN
7269: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7401: FND_MSG_PUB.Count_And_Get
7402: (
7403: p_count => x_msg_count,
7404: p_data => x_msg_data,
7405: p_encoded => FND_API.G_FALSE
7406: );
7407:
7408: --
7409: IF l_debug_on THEN
7414:
7415:
7416: --
7417: EXCEPTION
7418: WHEN FND_API.G_EXC_ERROR THEN
7419: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7420: x_return_status := FND_API.G_RET_STS_ERROR ;
7421: FND_MSG_PUB.Count_And_Get
7422: (
7416: --
7417: EXCEPTION
7418: WHEN FND_API.G_EXC_ERROR THEN
7419: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7420: x_return_status := FND_API.G_RET_STS_ERROR ;
7421: FND_MSG_PUB.Count_And_Get
7422: (
7423: p_count => x_msg_count,
7424: p_data => x_msg_data,
7421: FND_MSG_PUB.Count_And_Get
7422: (
7423: p_count => x_msg_count,
7424: p_data => x_msg_data,
7425: p_encoded => FND_API.G_FALSE
7426: );
7427:
7428: IF l_debug_on THEN
7429: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7425: p_encoded => FND_API.G_FALSE
7426: );
7427:
7428: IF l_debug_on THEN
7429: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7431: END IF;
7432: --
7433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7426: );
7427:
7428: IF l_debug_on THEN
7429: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7431: END IF;
7432: --
7433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7434: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7429: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
7431: END IF;
7432: --
7433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7434: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7436: FND_MSG_PUB.Count_And_Get
7437: (
7431: END IF;
7432: --
7433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7434: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7436: FND_MSG_PUB.Count_And_Get
7437: (
7438: p_count => x_msg_count,
7439: p_data => x_msg_data,
7436: FND_MSG_PUB.Count_And_Get
7437: (
7438: p_count => x_msg_count,
7439: p_data => x_msg_data,
7440: p_encoded => FND_API.G_FALSE
7441: );
7442:
7443: IF l_debug_on THEN
7444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7440: p_encoded => FND_API.G_FALSE
7441: );
7442:
7443: IF l_debug_on THEN
7444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7446: END IF;
7447: --
7448: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7441: );
7442:
7443: IF l_debug_on THEN
7444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
7446: END IF;
7447: --
7448: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
7449: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7450: FND_MSG_PUB.Count_And_Get
7451: (
7452: p_count => x_msg_count,
7453: p_data => x_msg_data,
7454: p_encoded => FND_API.G_FALSE
7455: );
7456: --
7457: IF l_debug_on THEN
7458: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
7461: --
7462: WHEN OTHERS THEN
7463:
7464: ROLLBACK to CANCEL_DEL_DETAIL_GRP;
7465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7466: wsh_util_core.add_message(x_return_status, l_module_name);
7467: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Delete_Delivery_Detail');
7468: FND_MSG_PUB.Count_And_Get
7469: (
7468: FND_MSG_PUB.Count_And_Get
7469: (
7470: p_count => x_msg_count,
7471: p_data => x_msg_data,
7472: p_encoded => FND_API.G_FALSE
7473: );
7474:
7475: IF l_debug_on THEN
7476: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7745: x_num_errors => l_number_of_errors,
7746: p_msg_data => l_msg_data);
7747: /***************Material Status Impact***********/
7748:
7749: IF x_detail_rec.locator_id <> fnd_api.g_miss_num THEN
7750: l_locator := x_detail_rec.locator_id;
7751: -- Modified Else condition for bug 4399278, 4418754
7752: ELSIF ( x_detail_rec.subinventory = p_original_rec.subinventory ) THEN
7753: l_locator := p_original_rec.locator_id;
7752: ELSIF ( x_detail_rec.subinventory = p_original_rec.subinventory ) THEN
7753: l_locator := p_original_rec.locator_id;
7754: END IF;
7755:
7756: IF x_detail_rec.revision <> fnd_api.g_miss_char THEN
7757: l_revision := x_detail_rec.revision;
7758: ELSE
7759: l_revision := p_original_rec.revision;
7760: END IF;
7758: ELSE
7759: l_revision := p_original_rec.revision;
7760: END IF;
7761:
7762: IF x_detail_rec.subinventory <> fnd_api.g_miss_char THEN
7763: l_subinventory := x_detail_rec.subinventory;
7764: ELSE
7765: l_subinventory := p_original_rec.subinventory;
7766: END IF;
7764: ELSE
7765: l_subinventory := p_original_rec.subinventory;
7766: END IF;
7767:
7768: IF x_detail_rec.lot_number <> fnd_api.g_miss_char THEN
7769: l_lot := x_detail_rec.lot_number;
7770: ELSE
7771: l_lot := p_original_rec.lot_number;
7772: END IF;
7823: IF l_debug_on THEN
7824: WSH_DEBUG_SV.log(l_module_name, 'Shipped Qty', x_detail_rec.shipped_quantity);
7825: WSH_DEBUG_SV.log(l_module_name, 'Existing Shipped Qty', p_original_rec.shipped_quantity);
7826: END IF;
7827: -- BugFix 4519867: Validate shipped qty only when it's not equal to fnd_api.g_miss_num.
7828: IF ((p_in_detail_rec.shipped_quantity IS NULL )
7829: OR (p_in_detail_rec.shipped_quantity <> fnd_api.g_miss_num))
7830: THEN
7831: l_det_qty_rec.delivery_detail_id := x_detail_rec.delivery_detail_id;
7825: WSH_DEBUG_SV.log(l_module_name, 'Existing Shipped Qty', p_original_rec.shipped_quantity);
7826: END IF;
7827: -- BugFix 4519867: Validate shipped qty only when it's not equal to fnd_api.g_miss_num.
7828: IF ((p_in_detail_rec.shipped_quantity IS NULL )
7829: OR (p_in_detail_rec.shipped_quantity <> fnd_api.g_miss_num))
7830: THEN
7831: l_det_qty_rec.delivery_detail_id := x_detail_rec.delivery_detail_id;
7832: l_det_qty_rec.requested_quantity := x_detail_rec.requested_quantity;
7833: l_det_qty_rec.requested_quantity2 := x_detail_rec.requested_quantity2;
7882: -- x_detail_rec.cycle_count_quantity := l_det_qty_rec.cycle_count_quantity;
7883:
7884: -- Bug 5466481: First consider the passed cycle count qty,
7885: -- If it is not passed then take the system calculated value.
7886: IF (p_in_detail_rec.cycle_count_quantity = fnd_api.g_miss_num) THEN
7887: --{
7888: x_detail_rec.cycle_count_quantity := l_det_qty_rec.cycle_count_quantity;
7889: ELSE
7890: x_detail_rec.cycle_count_quantity := p_in_detail_rec.cycle_count_quantity;
7904: -- HW Harmonization project for OPM.
7905: -- HW OPMCONV - Removed checking for process_flag
7906:
7907: IF (p_validation_tab(wsh_actions_levels.c_ship_qty2_lvl) = 1) THEN
7908: IF (x_detail_rec.shipped_quantity2 <> fnd_api.g_miss_num) THEN
7909: l_det_qty_rec.delivery_detail_id :=
7910: x_detail_rec.delivery_detail_id;
7911: l_det_qty_rec.requested_quantity :=
7912: x_detail_rec.requested_quantity;
7967: IF l_debug_on THEN
7968: WSH_DEBUG_SV.log(l_module_name, 'Cycle_Count Qty', x_detail_rec.cycle_count_quantity);
7969: WSH_DEBUG_SV.log(l_module_name, 'Existing Cycle_Count Qty', p_original_rec.cycle_count_quantity);
7970: END IF;
7971: -- BugFix 4519867: Validate cycle count qty only when it's not equal to fnd_api.g_miss_num.
7972: IF ( (p_in_detail_rec.cycle_count_quantity IS NULL)
7973: OR (p_in_detail_rec.cycle_count_quantity <> fnd_api.g_miss_num))
7974: THEN
7975: l_det_qty_rec.delivery_detail_id := x_detail_rec.delivery_detail_id;
7969: WSH_DEBUG_SV.log(l_module_name, 'Existing Cycle_Count Qty', p_original_rec.cycle_count_quantity);
7970: END IF;
7971: -- BugFix 4519867: Validate cycle count qty only when it's not equal to fnd_api.g_miss_num.
7972: IF ( (p_in_detail_rec.cycle_count_quantity IS NULL)
7973: OR (p_in_detail_rec.cycle_count_quantity <> fnd_api.g_miss_num))
7974: THEN
7975: l_det_qty_rec.delivery_detail_id := x_detail_rec.delivery_detail_id;
7976: l_det_qty_rec.requested_quantity := x_detail_rec.requested_quantity;
7977: l_det_qty_rec.requested_quantity2 := x_detail_rec.requested_quantity2;
8023: -- HW Harmonization project for OPM. Added cycle_count_qty2
8024: -- HW OPMCONV - Removed checking for process_flag
8025:
8026: IF (p_validation_tab(wsh_actions_levels.c_cc_qty2_lvl) = 1) THEN
8027: IF (x_detail_rec.cycle_count_quantity2 <> fnd_api.g_miss_num) THEN
8028: l_det_qty_rec.delivery_detail_id :=
8029: x_detail_rec.delivery_detail_id;
8030: l_det_qty_rec.requested_quantity :=
8031: x_detail_rec.requested_quantity;
8080:
8081: -- HW OPM end of changes
8082:
8083: IF (p_validation_tab(wsh_actions_levels.c_smc_lvl) = 1) THEN
8084: IF (x_detail_rec.ship_method_code <> fnd_api.g_miss_char) THEN
8085: IF l_debug_on THEN
8086: WSH_DEBUG_SV.log(l_module_name, 'Ship Method', x_detail_rec.ship_method_code);
8087: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD', WSH_DEBUG_SV.c_proc_level);
8088: END IF;
8102: END IF;
8103: END IF;
8104:
8105: IF (p_validation_tab(wsh_actions_levels.c_dep_plan_lvl) = 1) THEN
8106: IF (x_detail_rec.dep_plan_required_flag <> fnd_api.g_miss_char) THEN
8107: IF l_debug_on THEN
8108: WSH_DEBUG_SV.log(l_module_name, 'Departure Plan Flag', x_detail_rec.dep_plan_required_flag);
8109: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
8110: END IF;
8123: END IF;
8124: END IF;
8125:
8126: IF (p_validation_tab(wsh_actions_levels.c_ship_mod_comp_lvl) = 1) THEN
8127: IF (x_detail_rec.ship_model_complete_flag <> fnd_api.g_miss_char) THEN
8128: IF l_debug_on THEN
8129: WSH_DEBUG_SV.log(l_module_name, 'Ship Model Complete Flag', x_detail_rec.ship_model_complete_flag);
8130: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_BOOLEAN', WSH_DEBUG_SV.c_proc_level);
8131: END IF;
8144: END IF;
8145: END IF;
8146:
8147: IF (p_validation_tab(wsh_actions_levels.c_sub_inv_lvl) = 1) THEN
8148: IF (x_detail_rec.subinventory <> fnd_api.g_miss_char) THEN
8149: IF l_debug_on THEN
8150: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', x_detail_rec.subinventory);
8151: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);
8152: END IF;
8187:
8188: IF (p_validation_tab(wsh_actions_levels.c_revision_lvl) = 1)
8189: THEN
8190: -- {
8191: IF (x_detail_rec.revision <> fnd_api.g_miss_char)
8192: THEN
8193: -- {
8194: -- UT bug fix 2657367
8195: IF l_debug_on THEN
8203: IF l_inv_controls.rev_flag = 'N'
8204: AND x_detail_rec.revision IS NOT NULL
8205: THEN
8206: l_number_of_errors := l_number_of_errors + 1;
8207: RAISE FND_API.G_EXC_ERROR;
8208: END IF;
8209: ELSE
8210: IF l_debug_on THEN
8211: WSH_DEBUG_SV.log(l_module_name, 'Revision', x_detail_rec.revision);
8230: IF l_debug_on THEN
8231: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Revision');
8232: END IF;
8233:
8234: RAISE fnd_api.g_exc_error;
8235: END IF;
8236:
8237: wsh_util_core.api_post_call(
8238: p_return_status => l_return_status,
8247: -- }
8248: END IF;
8249:
8250: IF (p_validation_tab(wsh_actions_levels.c_locator_lvl) = 1) THEN
8251: IF (x_detail_rec.locator_id <> fnd_api.g_miss_num)
8252: THEN
8253: -- {
8254: -- UT bug fix 2657367
8255: IF l_debug_on THEN
8263: IF l_inv_controls.loc_flag = 'N'
8264: AND x_detail_rec.locator_id IS NOT NULL
8265: THEN
8266: l_number_of_errors := l_number_of_errors + 1;
8267: RAISE FND_API.G_EXC_ERROR;
8268: END IF;
8269: ELSE
8270:
8271: IF l_debug_on THEN
8293: IF l_debug_on THEN
8294: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Locator');
8295: END IF;
8296:
8297: RAISE fnd_api.g_exc_error;
8298: END IF;
8299:
8300: --
8301: wsh_util_core.api_post_call(
8311: END IF;
8312:
8313: IF (p_validation_tab(wsh_actions_levels.c_lot_number_lvl) = 1) AND
8314: p_original_rec.inv_interfaced_flag NOT IN ('Y','X') THEN -- Added for bug 13574503
8315: IF (x_detail_rec.lot_number <> fnd_api.g_miss_char) THEN
8316: -- HW Harmonization project for OPM. Need to branch
8317: -- HW OPMCONV - Removed branching
8318:
8319: -- UT bug fix 2657367
8330: AND x_detail_rec.lot_number IS NOT NULL
8331: THEN
8332: -- For non-transactable items, lot number cannot be updated if item is not under lot control
8333: l_number_of_errors := l_number_of_errors + 1;
8334: RAISE FND_API.G_EXC_ERROR;
8335: END IF;
8336: ELSE
8337: -- bug 4766908 get the reservable_flag
8338: IF p_original_rec.released_status = 'Y' THEN
8370: IF l_debug_on THEN
8371: WSH_DEBUG_SV.logmsg(l_module_name, 'Invalid Lot Number');
8372: END IF;
8373:
8374: RAISE fnd_api.g_exc_error;
8375: END IF;
8376: END IF;
8377: -- }
8378: END IF;
8393: /* Since we are updating by delivery_detail, make sure source_line_id is populated */
8394: x_detail_rec.source_line_id := p_original_rec.source_line_id;
8395:
8396: IF (p_validation_tab(wsh_actions_levels.c_sold_contact_lvl) = 1) THEN
8397: IF (x_detail_rec.sold_to_contact_id <> fnd_api.g_miss_num) THEN
8398: IF l_debug_on THEN
8399: WSH_DEBUG_SV.log(l_module_name, 'Sold to Contact', x_detail_rec.sold_to_contact_id);
8400: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8401: END IF;
8413: END IF;
8414: END IF;
8415:
8416: IF (p_validation_tab(wsh_actions_levels.c_ship_contact_lvl) = 1) THEN
8417: IF (x_detail_rec.ship_to_contact_id <> fnd_api.g_miss_num) THEN
8418: IF l_debug_on THEN
8419: WSH_DEBUG_SV.log(l_module_name, 'Ship to Contact Id', x_detail_rec.ship_to_contact_id);
8420: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8421: END IF;
8434: END IF;
8435: END IF;
8436:
8437: IF (p_validation_tab(wsh_actions_levels.c_deliver_contact_lvl) = 1) THEN
8438: IF (x_detail_rec.deliver_to_contact_id <> fnd_api.g_miss_num) THEN
8439: IF l_debug_on THEN
8440: WSH_DEBUG_SV.log(l_module_name, 'Deliver To Contact', x_detail_rec.deliver_to_contact_id);
8441: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8442: END IF;
8455: END IF;
8456: END IF;
8457:
8458: IF (p_validation_tab(wsh_actions_levels.c_intmed_ship_contact_lvl) = 1) THEN
8459: IF (x_detail_rec.intmed_ship_to_contact_id <> fnd_api.g_miss_num) THEN
8460: IF l_debug_on THEN
8461: WSH_DEBUG_SV.log(l_module_name, 'Intmed Ship To Contact', x_detail_rec.intmed_ship_to_contact_id);
8462: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CONTACT', WSH_DEBUG_SV.c_proc_level);
8463: END IF;
8496: -- If to_serial_number is null or is g_miss_char,
8497: -- then default it to from_serial_number
8498: IF ( p_serial_range_tab(l_index).to_serial_number IS NULL ) OR
8499: ( p_serial_range_tab(l_index).to_serial_number =
8500: fnd_api.g_miss_char ) THEN
8501: l_det_ser_range_tab(l_det_index).to_serial_number
8502: := p_serial_range_tab(l_index).from_serial_number;
8503: ELSE
8504: l_det_ser_range_tab(l_det_index).to_serial_number
8552: END IF;
8553:
8554: IF (
8555: p_in_detail_rec.serial_number IS NOT NULL
8556: AND p_in_detail_rec.serial_number <> fnd_api.g_miss_char
8557: )
8558: OR (
8559: p_in_detail_rec.to_serial_number IS NOT NULL
8560: AND p_in_detail_rec.to_serial_number <> fnd_api.g_miss_char
8556: AND p_in_detail_rec.serial_number <> fnd_api.g_miss_char
8557: )
8558: OR (
8559: p_in_detail_rec.to_serial_number IS NOT NULL
8560: AND p_in_detail_rec.to_serial_number <> fnd_api.g_miss_char
8561: )
8562: THEN
8563: -- (
8564: -- Error case. Inputs should be mutually exclusive
8565: IF l_debug_on THEN
8566: WSH_DEBUG_SV.logmsg(l_module_name, 'Serial number input not mutually exclusive');
8567: END IF;
8568:
8569: RAISE fnd_api.g_exc_error;
8570: -- )
8571: END IF;
8572: ELSIF l_detail_ser_count = 0
8573: THEN
8571: END IF;
8572: ELSIF l_detail_ser_count = 0
8573: THEN
8574: IF p_in_detail_rec.serial_number IS NOT NULL
8575: AND p_in_detail_rec.serial_number <> fnd_api.g_miss_char
8576: THEN
8577: -- (
8578: l_det_ser_range_tab(1).delivery_detail_id := x_detail_rec.delivery_detail_id;
8579: l_det_ser_range_tab(1).from_serial_number := p_in_detail_rec.serial_number;
8577: -- (
8578: l_det_ser_range_tab(1).delivery_detail_id := x_detail_rec.delivery_detail_id;
8579: l_det_ser_range_tab(1).from_serial_number := p_in_detail_rec.serial_number;
8580:
8581: IF p_in_detail_rec.to_serial_number <> fnd_api.g_miss_char
8582: THEN
8583: -- (
8584: l_det_ser_range_tab(1).to_serial_number := p_in_detail_rec.to_serial_number;
8585: -- )
8602: END IF;
8603:
8604: ELSE
8605: IF p_in_detail_rec.to_serial_number IS NOT NULL
8606: AND p_in_detail_rec.to_serial_number <> fnd_api.g_miss_char
8607: THEN
8608: -- (
8609: -- To serial number cannot exist with a from serial number
8610: IF l_debug_on THEN
8610: IF l_debug_on THEN
8611: WSH_DEBUG_SV.logmsg(l_module_name, 'From serial number is null');
8612: END IF;
8613:
8614: RAISE fnd_api.g_exc_error;
8615: -- )
8616: END IF;
8617: -- )
8618: END IF;
8631: IF l_debug_on THEN
8632: WSH_DEBUG_SV.logmsg(l_module_name, 'Cannot modify the serial numbers for WMS organizationx ');
8633: END IF;
8634:
8635: RAISE fnd_api.g_exc_error;
8636: END IF; --}
8637: END IF;--}
8638:
8639: -- Check 1: When serial number is input, Released Status should be Y or X
8643: IF l_debug_on THEN
8644: WSH_DEBUG_SV.logmsg(l_module_name, 'Released Status Not in X,Y');
8645: END IF;
8646:
8647: RAISE fnd_api.g_exc_error;
8648: -- )
8649: END IF;
8650:
8651: -- Check 2: When serial number is input, Shipped Qty should not be null or Zero. Bug 2652300
8655: -- Bug 2652300. Cannot update serial number if shipped qty is null or zero
8656: IF l_debug_on THEN
8657: WSH_DEBUG_SV.logmsg(l_module_name, 'Shipped qty zero or null. Not null serial number');
8658: END IF;
8659: raise FND_API.G_EXC_ERROR;
8660: ELSIF nvl(x_detail_rec.shipped_quantity, nvl(p_original_rec.shipped_quantity,0)) > 1
8661: THEN
8662: -- Check 3: If shipped qty is greater than one,
8663: -- if table count is one, then to_serial_number should exist. Bug 2652319
8667: -- (
8668: IF l_debug_on THEN
8669: WSH_DEBUG_SV.logmsg(l_module_name, 'Shipped qty greater than one. No to_serial_number');
8670: END IF;
8671: raise FND_API.G_EXC_ERROR;
8672: -- )
8673: END IF;
8674: -- )
8675: END IF;
8682: -- Error case.
8683: IF l_debug_on THEN
8684: WSH_DEBUG_SV.logmsg(l_module_name, 'Serial table qty greater than shipped qty');
8685: END IF;
8686: RAISE fnd_api.g_exc_error;
8687: ELSIF l_detail_ser_qty = 1
8688: THEN
8689: IF l_debug_on THEN
8690: WSH_DEBUG_SV.log(l_module_name, 'table from serial num', l_det_ser_range_tab(1).from_serial_number);
8700: IF l_debug_on THEN
8701: WSH_DEBUG_SV.logmsg(l_module_name, 'From serial number is null');
8702: END IF;
8703:
8704: RAISE fnd_api.g_exc_error;
8705: -- )
8706: END IF;
8707: ELSIF l_detail_ser_qty > 1
8708: THEN
8769:
8770: -- HW OPMCONV - Removed checking for l_process_flag
8771: IF (
8772: (
8773: (x_detail_rec.serial_number <> fnd_api.g_miss_char)
8774: OR x_detail_rec.serial_number IS NULL
8775: OR l_detail_ser_count > 0
8776: )
8777: -- AND l_process_flag = '0'
8802: l_return_status := wsh_util_core.g_ret_sts_error;
8803: fnd_message.set_name('WSH', 'WSH_INV_INVALID');
8804: fnd_message.set_token('INV_ATTRIBUTE', 'Serial Number Code');
8805: wsh_util_core.add_message(l_return_status);
8806: RAISE fnd_api.g_exc_error;
8807: -- )
8808: END IF;
8809: -- )
8810: END IF;
8821: -- Serial Number is being modified from Not null to Null/Not Null value,
8822: -- Unmark using serial number
8823: IF p_original_rec.serial_number IS NOT NULL AND
8824: l_detail_ser_qty = 1 AND l_update_attributes = FALSE AND
8825: x_detail_rec.serial_number <> fnd_api.g_miss_char
8826: -- AND (x_detail_rec.serial_number IS NULL OR
8827: -- x_detail_rec.serial_number <> p_original_rec.serial_number)
8828: THEN
8829:
8843: wsh_debug_sv.log(l_module_name, 'Return status after Unmark ', l_return_status);
8844: END IF;
8845:
8846: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
8847: RAISE fnd_api.g_exc_error;
8848: END IF;
8849:
8850: -- Transaction temp id exists in WDD,now 1 serial number is being
8851: -- specified, unmark using transaction temp id
8849:
8850: -- Transaction temp id exists in WDD,now 1 serial number is being
8851: -- specified, unmark using transaction temp id
8852: ELSIF (p_original_rec.transaction_temp_id IS NOT NULL AND
8853: x_detail_rec.serial_number <> fnd_api.g_miss_char AND
8854: l_detail_ser_qty = 1 AND l_update_attributes = FALSE)
8855: OR
8856: (p_original_rec.transaction_temp_id IS NOT NULL AND
8857: l_det_ser_range_tab.count > 0 AND
8876: wsh_debug_sv.log(l_module_name, 'Return status after Unmark ', l_return_status);
8877: END IF;
8878:
8879: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
8880: RAISE fnd_api.g_exc_error;
8881: END IF;
8882:
8883: END IF;
8884: END IF;
8981: END IF;
8982:
8983: IF (
8984: l_det_ser_range_tab(l_det_index).to_serial_number <>
8985: fnd_api.g_miss_char
8986: )
8987: AND l_det_ser_range_tab(l_det_index).to_serial_number IS NOT NULL THEN -- bug 1578114 condition added
8988: IF l_debug_on THEN
8989: WSH_DEBUG_SV.log(l_module_name, 'Transaction id created', l_transaction_id);
9196: x_num_errors => l_number_of_errors,
9197: p_msg_data => l_msg_data
9198: );
9199: ELSIF p_in_detail_rec.serial_number IS NOT NULL
9200: AND p_in_detail_rec.serial_number <> FND_API.G_MISS_CHAR
9201: THEN
9202: --
9203: IF l_debug_on THEN
9204: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.MARK_SERIAL_NUMBER', WSH_DEBUG_SV.c_proc_level);
9245: wsh_debug_sv.log(l_module_name, 'Return status after Update_Marked_Serial ', l_return_status);
9246: END IF;
9247: --
9248: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
9249: RAISE fnd_api.g_exc_error;
9250: END IF;
9251: --}
9252: END IF; -- l_update_attributes;
9253: -- )
9283:
9284: fnd_msg_pub.count_and_get(
9285: p_count => x_msg_count,
9286: p_data => x_msg_data,
9287: p_encoded => fnd_api.g_false);
9288:
9289: IF l_debug_on THEN
9290: WSH_DEBUG_SV.pop(l_module_name);
9291: END IF;
9290: WSH_DEBUG_SV.pop(l_module_name);
9291: END IF;
9292: --
9293: EXCEPTION
9294: WHEN fnd_api.g_exc_error THEN
9295: ROLLBACK TO validate_det_line_grp;
9296: x_return_status := fnd_api.g_ret_sts_error;
9297: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
9298: p_encoded => fnd_api.g_false);
9292: --
9293: EXCEPTION
9294: WHEN fnd_api.g_exc_error THEN
9295: ROLLBACK TO validate_det_line_grp;
9296: x_return_status := fnd_api.g_ret_sts_error;
9297: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
9298: p_encoded => fnd_api.g_false);
9299:
9300: --
9294: WHEN fnd_api.g_exc_error THEN
9295: ROLLBACK TO validate_det_line_grp;
9296: x_return_status := fnd_api.g_ret_sts_error;
9297: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data,
9298: p_encoded => fnd_api.g_false);
9299:
9300: --
9301: IF l_debug_on THEN
9302: WSH_DEBUG_SV.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', WSH_DEBUG_SV.c_excep_level);
9298: p_encoded => fnd_api.g_false);
9299:
9300: --
9301: IF l_debug_on THEN
9302: WSH_DEBUG_SV.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', WSH_DEBUG_SV.c_excep_level);
9303: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
9304: END IF;
9305: --
9306: WHEN fnd_api.g_exc_unexpected_error THEN
9299:
9300: --
9301: IF l_debug_on THEN
9302: WSH_DEBUG_SV.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', WSH_DEBUG_SV.c_excep_level);
9303: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
9304: END IF;
9305: --
9306: WHEN fnd_api.g_exc_unexpected_error THEN
9307: ROLLBACK TO validate_det_line_grp;
9302: WSH_DEBUG_SV.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', WSH_DEBUG_SV.c_excep_level);
9303: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
9304: END IF;
9305: --
9306: WHEN fnd_api.g_exc_unexpected_error THEN
9307: ROLLBACK TO validate_det_line_grp;
9308: x_return_status := fnd_api.g_ret_sts_unexp_error;
9309: fnd_msg_pub.count_and_get(
9310: p_count => x_msg_count,
9304: END IF;
9305: --
9306: WHEN fnd_api.g_exc_unexpected_error THEN
9307: ROLLBACK TO validate_det_line_grp;
9308: x_return_status := fnd_api.g_ret_sts_unexp_error;
9309: fnd_msg_pub.count_and_get(
9310: p_count => x_msg_count,
9311: p_data => x_msg_data,
9312: p_encoded => fnd_api.g_false);
9308: x_return_status := fnd_api.g_ret_sts_unexp_error;
9309: fnd_msg_pub.count_and_get(
9310: p_count => x_msg_count,
9311: p_data => x_msg_data,
9312: p_encoded => fnd_api.g_false);
9313:
9314: --
9315: IF l_debug_on THEN
9316: WSH_DEBUG_SV.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', WSH_DEBUG_SV.c_excep_level);
9312: p_encoded => fnd_api.g_false);
9313:
9314: --
9315: IF l_debug_on THEN
9316: WSH_DEBUG_SV.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', WSH_DEBUG_SV.c_excep_level);
9317: WSH_DEBUG_SV.pop(l_module_name,
9318: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9319: END IF;
9320: --
9314: --
9315: IF l_debug_on THEN
9316: WSH_DEBUG_SV.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', WSH_DEBUG_SV.c_excep_level);
9317: WSH_DEBUG_SV.pop(l_module_name,
9318: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9319: END IF;
9320: --
9321: WHEN wsh_util_core.g_exc_warning THEN
9322: x_return_status := wsh_util_core.g_ret_sts_warning;
9322: x_return_status := wsh_util_core.g_ret_sts_warning;
9323: fnd_msg_pub.count_and_get(
9324: p_count => x_msg_count,
9325: p_data => x_msg_data,
9326: p_encoded => fnd_api.g_false);
9327:
9328: --
9329: IF l_debug_on THEN
9330: WSH_DEBUG_SV.logmsg(l_module_name,
9335: END IF;
9336: --
9337: WHEN OTHERS THEN
9338: ROLLBACK TO validate_det_line_grp;
9339: x_return_status := fnd_api.g_ret_sts_unexp_error;
9340: wsh_util_core.add_message(x_return_status, l_module_name);
9341: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');
9342: fnd_msg_pub.count_and_get(
9343: p_count => x_msg_count,
9341: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Line');
9342: fnd_msg_pub.count_and_get(
9343: p_count => x_msg_count,
9344: p_data => x_msg_data,
9345: p_encoded => fnd_api.g_false);
9346:
9347: --
9348:
9349: IF l_debug_on THEN
9417: l_number_of_errors := 0;
9418: l_number_of_warnings := 0;
9419:
9420: IF(p_validation_tab(WSH_ACTIONS_LEVELS.C_CONT_ITEM_LVL) = 1 ) THEN
9421: IF (x_detail_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
9422: --
9423: IF l_debug_on THEN
9424: WSH_DEBUG_SV.log(l_module_name, 'Inventory Item Id', x_detail_rec.inventory_item_id);
9425: WSH_DEBUG_SV.log(l_module_name, 'Organization Id', x_detail_rec.organization_id);
9445: END IF;
9446: END IF;
9447: --
9448: --lpn CONV.. samanna
9449: IF (x_detail_rec.delivered_quantity <> FND_API.G_MISS_NUM) THEN
9450: IF p_original_rec.shipped_quantity IS NOT NULL THEN
9451: IF x_detail_rec.delivered_quantity > p_original_rec.shipped_quantity THEN
9452: RAISE e_invalid_delivered_qty;
9453: END IF;
9469: FND_MSG_PUB.Count_And_Get
9470: (
9471: p_count => x_msg_count,
9472: p_data => x_msg_data,
9473: p_encoded => FND_API.G_FALSE
9474: );
9475:
9476: IF l_debug_on THEN
9477: WSH_DEBUG_SV.pop(l_module_name);
9479:
9480: EXCEPTION
9481: WHEN e_invalid_delivered_qty THEN
9482: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9483: x_return_status := FND_API.G_RET_STS_ERROR ;
9484: FND_MESSAGE.SET_NAME('WSH', 'WSH_INVALID_DELIVERED_QTY');
9485: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
9486: FND_MSG_PUB.Count_And_Get
9487: (
9486: FND_MSG_PUB.Count_And_Get
9487: (
9488: p_count => x_msg_count,
9489: p_data => x_msg_data,
9490: p_encoded => FND_API.G_FALSE
9491: );
9492: IF l_debug_on THEN
9493: WSH_DEBUG_SV.logmsg(l_module_name,'E_INVALID_DELIVERED_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9494: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: E_INVALID_DELIVERED_QTY');
9494: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION: E_INVALID_DELIVERED_QTY');
9495: END IF;
9496:
9497:
9498: WHEN FND_API.G_EXC_ERROR THEN
9499: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9500: x_return_status := FND_API.G_RET_STS_ERROR ;
9501: FND_MSG_PUB.Count_And_Get
9502: (
9496:
9497:
9498: WHEN FND_API.G_EXC_ERROR THEN
9499: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9500: x_return_status := FND_API.G_RET_STS_ERROR ;
9501: FND_MSG_PUB.Count_And_Get
9502: (
9503: p_count => x_msg_count,
9504: p_data => x_msg_data,
9501: FND_MSG_PUB.Count_And_Get
9502: (
9503: p_count => x_msg_count,
9504: p_data => x_msg_data,
9505: p_encoded => FND_API.G_FALSE
9506: );
9507: --
9508:
9509: IF l_debug_on THEN
9506: );
9507: --
9508:
9509: IF l_debug_on THEN
9510: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9511: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9512: END IF;
9513:
9514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9507: --
9508:
9509: IF l_debug_on THEN
9510: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9511: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9512: END IF;
9513:
9514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9515: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9510: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9511: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9512: END IF;
9513:
9514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9515: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9517: FND_MSG_PUB.Count_And_Get
9518: (
9512: END IF;
9513:
9514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9515: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9517: FND_MSG_PUB.Count_And_Get
9518: (
9519: p_count => x_msg_count,
9520: p_data => x_msg_data,
9517: FND_MSG_PUB.Count_And_Get
9518: (
9519: p_count => x_msg_count,
9520: p_data => x_msg_data,
9521: p_encoded => FND_API.G_FALSE
9522: );
9523: --
9524:
9525: IF l_debug_on THEN
9522: );
9523: --
9524:
9525: IF l_debug_on THEN
9526: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9527: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9528: END IF;
9529: --
9530: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9523: --
9524:
9525: IF l_debug_on THEN
9526: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9527: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9528: END IF;
9529: --
9530: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9531: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9532: FND_MSG_PUB.Count_And_Get
9533: (
9534: p_count => x_msg_count,
9535: p_data => x_msg_data,
9536: p_encoded => FND_API.G_FALSE
9537: );
9538: --
9539: IF l_debug_on THEN
9540: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9542: END IF;
9543: --
9544: WHEN OTHERS THEN
9545: ROLLBACK TO VALIDATE_DET_CONTAINER_GRP;
9546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9547: wsh_util_core.add_message(x_return_status, l_module_name);
9548: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Container');
9549: FND_MSG_PUB.Count_And_Get
9550: (
9549: FND_MSG_PUB.Count_And_Get
9550: (
9551: p_count => x_msg_count,
9552: p_data => x_msg_data,
9553: p_encoded => FND_API.G_FALSE
9554: );
9555:
9556: IF l_debug_on THEN
9557: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
9810: END IF;
9811: -- HW OPMCONV - Removed branching
9812:
9813: --{
9814: IF (nvl(x_detail_rec.delivered_quantity, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
9815: --{
9816: x_detail_rec.delivered_quantity := round(x_detail_rec.delivered_quantity,wsh_util_core.c_max_decimal_digits_inv);
9817: --}
9818: END IF;
9823: FND_MSG_PUB.Count_And_Get
9824: (
9825: p_count => x_msg_count,
9826: p_data => x_msg_data,
9827: p_encoded => FND_API.G_FALSE
9828: );
9829:
9830: IF l_debug_on THEN
9831: WSH_DEBUG_SV.pop(l_module_name);
9831: WSH_DEBUG_SV.pop(l_module_name);
9832: END IF;
9833:
9834: EXCEPTION
9835: WHEN FND_API.G_EXC_ERROR THEN
9836: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9837: x_return_status := FND_API.G_RET_STS_ERROR ;
9838: FND_MSG_PUB.Count_And_Get
9839: (
9833:
9834: EXCEPTION
9835: WHEN FND_API.G_EXC_ERROR THEN
9836: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9837: x_return_status := FND_API.G_RET_STS_ERROR ;
9838: FND_MSG_PUB.Count_And_Get
9839: (
9840: p_count => x_msg_count,
9841: p_data => x_msg_data,
9838: FND_MSG_PUB.Count_And_Get
9839: (
9840: p_count => x_msg_count,
9841: p_data => x_msg_data,
9842: p_encoded => FND_API.G_FALSE
9843: );
9844: --
9845: IF l_debug_on THEN
9846: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9842: p_encoded => FND_API.G_FALSE
9843: );
9844: --
9845: IF l_debug_on THEN
9846: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9847: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9848: END IF;
9849:
9850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9843: );
9844: --
9845: IF l_debug_on THEN
9846: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9847: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9848: END IF;
9849:
9850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9851: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9846: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9847: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9848: END IF;
9849:
9850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9851: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9853: FND_MSG_PUB.Count_And_Get
9854: (
9848: END IF;
9849:
9850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9851: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9853: FND_MSG_PUB.Count_And_Get
9854: (
9855: p_count => x_msg_count,
9856: p_data => x_msg_data,
9853: FND_MSG_PUB.Count_And_Get
9854: (
9855: p_count => x_msg_count,
9856: p_data => x_msg_data,
9857: p_encoded => FND_API.G_FALSE
9858: );
9859: --
9860:
9861: IF l_debug_on THEN
9858: );
9859: --
9860:
9861: IF l_debug_on THEN
9862: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9864: END IF;
9865:
9866: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9859: --
9860:
9861: IF l_debug_on THEN
9862: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9864: END IF;
9865:
9866: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9868: FND_MSG_PUB.Count_And_Get
9869: (
9870: p_count => x_msg_count,
9871: p_data => x_msg_data,
9872: p_encoded => FND_API.G_FALSE
9873: );
9874: --
9875: IF l_debug_on THEN
9876: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9878: END IF;
9879:
9880: WHEN OTHERS THEN
9881: ROLLBACK TO VALIDATE_DET_COMMON_GRP;
9882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9883: wsh_util_core.add_message(x_return_status, l_module_name);
9884: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Validate_Detail_Common');
9885: FND_MSG_PUB.Count_And_Get
9886: (
9885: FND_MSG_PUB.Count_And_Get
9886: (
9887: p_count => x_msg_count,
9888: p_data => x_msg_data,
9889: p_encoded => FND_API.G_FALSE
9890: );
9891: --
9892:
9893: IF l_debug_on THEN
9972: END IF;
9973:
9974:
9975: EXCEPTION
9976: WHEN FND_API.G_EXC_ERROR THEN
9977: x_return_status := FND_API.G_RET_STS_ERROR ;
9978: IF l_debug_on THEN
9979: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9973:
9974:
9975: EXCEPTION
9976: WHEN FND_API.G_EXC_ERROR THEN
9977: x_return_status := FND_API.G_RET_STS_ERROR ;
9978: IF l_debug_on THEN
9979: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9981: END IF;
9975: EXCEPTION
9976: WHEN FND_API.G_EXC_ERROR THEN
9977: x_return_status := FND_API.G_RET_STS_ERROR ;
9978: IF l_debug_on THEN
9979: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9981: END IF;
9982:
9983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9976: WHEN FND_API.G_EXC_ERROR THEN
9977: x_return_status := FND_API.G_RET_STS_ERROR ;
9978: IF l_debug_on THEN
9979: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9981: END IF;
9982:
9983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9979: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9981: END IF;
9982:
9983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9985: IF l_debug_on THEN
9986: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9981: END IF;
9982:
9983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9985: IF l_debug_on THEN
9986: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9988: END IF;
9982:
9983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9985: IF l_debug_on THEN
9986: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9988: END IF;
9989:
9990: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9985: IF l_debug_on THEN
9986: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
9988: END IF;
9989:
9990: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
9991: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9994: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
9995: END IF;
9996:
9997: WHEN OTHERS THEN
9998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9999: wsh_util_core.add_message(x_return_status, l_module_name);
10000: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Serial_Quantity');
10001: --
10002:
10121:
10122: -- Initialize message list if p_init_msg_list is set to TRUE.
10123: --
10124: --
10125: IF FND_API.to_Boolean( p_init_msg_list )
10126: THEN
10127: FND_MSG_PUB.initialize;
10128: END IF;
10129: --
10140: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10141: IF l_debug_on THEN
10142: wsh_debug_sv.logmsg(l_module_name,'Null Caller');
10143: END IF;
10144: RAISE FND_API.G_EXC_ERROR;
10145: END IF;
10146:
10147: IF p_In_rec.action_code IS NULL THEN
10148: FND_MESSAGE.SET_NAME('WSH', 'WSH_REQUIRED_FIELD_NULL');
10150: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10151: IF l_debug_on THEN
10152: wsh_debug_sv.logmsg(l_module_name,'Null Action Code');
10153: END IF;
10154: RAISE FND_API.G_EXC_ERROR;
10155: ELSIF(p_In_rec.action_code NOT IN('CREATE', 'UPDATE', 'CANCEL')
10156: OR (p_In_rec.action_code = 'CANCEL' AND p_In_rec.caller <> 'WSH_INBOUND')) THEN
10157: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
10158: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_In_rec.action_code );
10159: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
10160: IF l_debug_on THEN
10161: wsh_debug_sv.logmsg(l_module_name,'WSH_INVALID_ACTION_CODE');
10162: END IF;
10163: RAISE FND_API.G_EXC_ERROR;
10164: END IF;
10165:
10166: -- Set Validation Level
10167:
10246: AND l_delivery_detail_rec.container_flag in ('Y', 'C')
10247: THEN
10248: IF l_weight_uom_code <>
10249: l_delivery_detail_rec.weight_uom_code
10250: AND l_weight_uom_code <> FND_API.G_MISS_CHAR
10251: THEN
10252: l_delivery_detail_rec.gross_weight :=
10253: WSH_WV_UTILS.Convert_Uom_core (
10254: from_uom => l_weight_uom_code,
10289:
10290: END IF;
10291: IF l_volume_uom_code <>
10292: l_delivery_detail_rec.volume_uom_code
10293: AND l_volume_uom_code <> FND_API.G_MISS_CHAR
10294: THEN
10295:
10296: l_delivery_detail_rec.volume :=
10297: WSH_WV_UTILS.Convert_Uom_core (
10333:
10334: END IF;
10335: l_detail_info_tab(l_index) := l_delivery_detail_rec;
10336: EXCEPTION
10337: WHEN FND_API.G_EXC_ERROR THEN
10338: ROLLBACK TO before_det_disabled_grp;
10339: IF l_debug_on THEN
10340: wsh_debug_sv.logmsg(l_module_name, 'g exc error');
10341: END IF;
10338: ROLLBACK TO before_det_disabled_grp;
10339: IF l_debug_on THEN
10340: wsh_debug_sv.logmsg(l_module_name, 'g exc error');
10341: END IF;
10342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10343: ROLLBACK TO before_det_disabled_grp;
10344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10345: WHEN OTHERS THEN
10346: ROLLBACK TO before_det_disabled_grp;
10340: wsh_debug_sv.logmsg(l_module_name, 'g exc error');
10341: END IF;
10342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10343: ROLLBACK TO before_det_disabled_grp;
10344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10345: WHEN OTHERS THEN
10346: ROLLBACK TO before_det_disabled_grp;
10347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10348:
10343: ROLLBACK TO before_det_disabled_grp;
10344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10345: WHEN OTHERS THEN
10346: ROLLBACK TO before_det_disabled_grp;
10347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10348:
10349: END;
10350: l_weight_uom_code := NULL;
10351: l_volume_uom_code := NULL;
10364: IF l_loop_num_error = p_detail_info_tab.count THEN
10365: IF l_debug_on THEN
10366: wsh_debug_sv.logmsg(l_module_name, 'get disabled list fail all records');
10367: END IF;
10368: RAISE FND_API.G_EXC_ERROR;
10369: ELSE
10370: l_number_of_warnings := l_loop_num_error;
10371: END IF;
10372: END IF;
10386: -- Should not proceed further
10387: IF l_debug_on THEN
10388: wsh_debug_sv.logmsg(l_module_name,'Table Count Zero');
10389: END IF;
10390: RAISE FND_API.G_EXC_ERROR;
10391: END IF;
10392:
10393: -- anxsharm for Load Tender
10394: IF(l_validation_tab(WSH_ACTIONS_LEVELS.C_WMS_CONTAINERS_LVL) = 1) THEN--{ lpn conv
10474: WSH_DEBUG_SV.log(l_module_name,'total count',l_detail_info_tab.COUNT);
10475: --
10476: END IF;
10477: --
10478: RAISE FND_API.G_EXC_ERROR;
10479: --
10480: END IF;
10481: --
10482: END IF; --}
10523: RAISE wsh_util_core.g_exc_warning;
10524: END IF;
10525:
10526: -- Standard check of p_commit.
10527: IF FND_API.To_Boolean( p_commit ) THEN
10528: IF(l_debug_on) THEN
10529: wsh_debug_sv.logmsg(l_module_name, 'Commit Work');
10530: END IF;
10531: --
10545: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
10546: END IF;
10547:
10548: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
10549: RAISE FND_API.G_EXC_ERROR;
10550: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10552: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10553: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
10547:
10548: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
10549: RAISE FND_API.G_EXC_ERROR;
10550: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
10551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10552: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
10553: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
10554: END IF;
10555:
10566: --{
10567: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
10568: --{
10569:
10570: IF FND_API.TO_BOOLEAN(p_commit) THEN
10571:
10572: IF l_debug_on THEN
10573: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
10574: END IF;
10595:
10596: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
10597: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
10598: THEN
10599: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
10600: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10601: END IF;
10602: END IF;
10603: END IF;
10610: FND_MSG_PUB.Count_And_Get
10611: (
10612: p_count => x_msg_count,
10613: p_data => x_msg_data,
10614: p_encoded => FND_API.G_FALSE
10615: );
10616:
10617:
10618: IF l_debug_on THEN
10619: WSH_DEBUG_SV.pop(l_module_name);
10620: END IF;
10621: --
10622: EXCEPTION
10623: WHEN FND_API.G_EXC_ERROR THEN
10624: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10625: x_return_status := FND_API.G_RET_STS_ERROR ;
10626: --
10627: -- Start code for Bugfix 4070732
10621: --
10622: EXCEPTION
10623: WHEN FND_API.G_EXC_ERROR THEN
10624: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10625: x_return_status := FND_API.G_RET_STS_ERROR ;
10626: --
10627: -- Start code for Bugfix 4070732
10628: --
10629: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10655: FND_MSG_PUB.Count_And_Get
10656: (
10657: p_count => x_msg_count,
10658: p_data => x_msg_data,
10659: p_encoded => FND_API.G_FALSE
10660: );
10661:
10662:
10663:
10662:
10663:
10664: --
10665: IF l_debug_on THEN
10666: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10668: END IF;
10669: --
10670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10663:
10664: --
10665: IF l_debug_on THEN
10666: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10668: END IF;
10669: --
10670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10671: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10666: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10668: END IF;
10669: --
10670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10671: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10673: --
10674: -- Start code for Bugfix 4070732
10668: END IF;
10669: --
10670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10671: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10673: --
10674: -- Start code for Bugfix 4070732
10675: --
10676: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
10698: FND_MSG_PUB.Count_And_Get
10699: (
10700: p_count => x_msg_count,
10701: p_data => x_msg_data,
10702: p_encoded => FND_API.G_FALSE
10703: );
10704:
10705:
10706:
10705:
10706:
10707: --
10708: IF l_debug_on THEN
10709: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10710: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10711: END IF;
10712: --
10713: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10706:
10707: --
10708: IF l_debug_on THEN
10709: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10710: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10711: END IF;
10712: --
10713: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10714: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10746: FND_MSG_PUB.Count_And_Get
10747: (
10748: p_count => x_msg_count,
10749: p_data => x_msg_data,
10750: p_encoded => FND_API.G_FALSE
10751: );
10752:
10753:
10754:
10805: FND_MSG_PUB.Count_And_Get
10806: (
10807: p_count => x_msg_count,
10808: p_data => x_msg_data,
10809: p_encoded => FND_API.G_FALSE
10810: );
10811: --
10812:
10813: --
10817: END IF;
10818: --
10819: WHEN OTHERS THEN
10820: ROLLBACK TO CREATE_UPDATE_DEL_DETAIL_GRP2;
10821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10822: wsh_util_core.add_message(x_return_status, l_module_name);
10823: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Create_Update_Delivery_Detail');
10824: --
10825: -- Start code for Bugfix 4070732
10849: FND_MSG_PUB.Count_And_Get
10850: (
10851: p_count => x_msg_count,
10852: p_data => x_msg_data,
10853: p_encoded => FND_API.G_FALSE
10854: );
10855: --
10856:
10857:
10905: WSH_DEBUG_SV.push(l_module_name);
10906: WSH_DEBUG_SV.LOG(l_module_name, 'Count of p_line_rows-', p_line_rows.count);
10907: END IF;
10908: --
10909: x_return_status := FND_API.G_RET_STS_SUCCESS;
10910:
10911: FOR i in 1..p_line_rows.count
10912: LOOP
10913: l_attr_tab(i).entity_id := p_line_rows(i);
10967: WSH_DEBUG_SV.pop(l_module_name);
10968: END IF;
10969:
10970: EXCEPTION
10971: WHEN FND_API.G_EXC_ERROR THEN
10972: x_return_status := FND_API.G_RET_STS_ERROR ;
10973: IF l_debug_on THEN
10974: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10975: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10968: END IF;
10969:
10970: EXCEPTION
10971: WHEN FND_API.G_EXC_ERROR THEN
10972: x_return_status := FND_API.G_RET_STS_ERROR ;
10973: IF l_debug_on THEN
10974: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10975: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10976: END IF;
10970: EXCEPTION
10971: WHEN FND_API.G_EXC_ERROR THEN
10972: x_return_status := FND_API.G_RET_STS_ERROR ;
10973: IF l_debug_on THEN
10974: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10975: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10976: END IF;
10977:
10978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10971: WHEN FND_API.G_EXC_ERROR THEN
10972: x_return_status := FND_API.G_RET_STS_ERROR ;
10973: IF l_debug_on THEN
10974: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10975: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10976: END IF;
10977:
10978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10974: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10975: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10976: END IF;
10977:
10978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10980: IF l_debug_on THEN
10981: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10982: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10975: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
10976: END IF;
10977:
10978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10980: IF l_debug_on THEN
10981: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10982: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10983: END IF;
10977:
10978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10980: IF l_debug_on THEN
10981: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10982: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10983: END IF;
10984:
10985: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10980: IF l_debug_on THEN
10981: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
10982: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10983: END IF;
10984:
10985: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
10986: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
10989: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
10990: END IF;
10991:
10992: WHEN OTHERS THEN
10993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10994: wsh_util_core.add_message(x_return_status, l_module_name);
10995: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping');
10996: --
10997: IF l_debug_on THEN