[Home] [Help]
311: CLOSE carton_lpn_csr;
312: --if carton lpn is passed and is not valid then no need to proceed further
313: IF(l_carton_lpn_ctx NOT IN (5,8)) THEN
314: x_return_status := fnd_api.g_ret_sts_error;
315: fnd_message.set_name('WMS', 'WMS_CARTON_LPN_CTX_ERR');
316: fnd_msg_pub.ADD;
317: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
318: l_error_msg :='Invalid context for Carton LPN:'||p_new_carton_lpn_id;
319: IF(l_debug = 1) THEN
321: END IF;
322: RETURN;
323: ELSIF (l_carton_lpn_itm_id is NULL) THEN
324: x_return_status := fnd_api.g_ret_sts_error;
325: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
326: fnd_msg_pub.ADD;
327: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
328: l_error_msg :='Inventory item id is not present in carton LPN';
329: IF(l_debug = 1) THEN
362: FOR i IN 1..p_task_table.count
363: LOOP
364: IF (p_task_table(i).organization_id <> l_carton_lpn_org) THEN
365: x_return_status := fnd_api.g_ret_sts_error;
366: fnd_message.set_name('WMS', 'WMS_CARTON_LPN_ORG_ERR');
367: fnd_msg_pub.ADD;
368: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
369: l_error_msg :='Organization is not same for Carton LPN and Task';
370: IF(l_debug = 1) THEN
378: IF c_bulk_task%NOTFOUND THEN
379: CLOSE c_bulk_task;
380: ELSE
381: x_return_status := fnd_api.g_ret_sts_error;
382: fnd_message.set_name('WMS', 'WMS_CARTON_BULK_ERR');
383: fnd_msg_pub.ADD;
384: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => x_error_msg );
385: l_error_msg :='Bulk Tasks cannot be cartonized';
386: IF(l_debug = 1) THEN
407: l_temp_del_detail_id := NULL;
408: END;
409: IF (l_temp_del_detail_id IS NULL) THEN
410: x_return_status := fnd_api.g_ret_sts_error;
411: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
412: fnd_msg_pub.ADD;
413: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
414: l_error_msg :='Data not present in WDD for the corresponding task :'||p_task_table(i).transaction_number;
415: IF(l_debug = 1) THEN
460: -- check if all the values in l_grouping_rows are same.
461: FOR i in 1..l_grouping_rows.COUNT LOOP
462: IF (l_grouping_rows(1) <> l_grouping_rows(i)) THEN
463: x_return_status := fnd_api.g_ret_sts_error;
464: fnd_message.set_name('WMS', 'WMS_CARTON_DEL_GP_ERR');
465: fnd_msg_pub.ADD;
466: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
467: l_error_msg :='Delivery grouping mismatch,cartonization cannot be done';
468: IF(l_debug = 1) THEN
478: --check if the delivery_id's that are present in l_del_id_tab_new are all same.
479: FOR i in 1..l_del_id_tab_new.COUNT LOOP
480: IF (l_del_id_tab_new(1) <> l_del_id_tab_new(i)) THEN
481: x_return_status := fnd_api.g_ret_sts_error;
482: fnd_message.set_name('WMS', 'WMS_CARTON_DEL_ERR');
483: fnd_msg_pub.ADD;
484: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
485: l_error_msg :='Delivery mismatch,cartonization cannot be done';
486: IF(l_debug = 1) THEN
512: p_delivery_name => l_delivery_name,
513: p_action_prms => p_action_prms);
514:
515: IF l_return_status <> 'S' THEN
516: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
517: fnd_msg_pub.ADD;
518: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
519: l_error_msg :='Error returned from WSH API';
520: IF(l_debug = 1) THEN
634: p_output_task_rec.ERROR := l_err_msg;
635: RETURN;
636: END;
637: IF l_count > 0 THEN
638: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');--new message WMS_ATF_ACTIVE_TASK_EXP
639: fnd_msg_pub.ADD;
640: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
641: l_msg := 'Active task can be updated if tasks assigned to user is logged off the system';
642: IF(l_debug = 1) THEN
683: p_output_task_rec.ERROR := l_err_msg;
684: RETURN;
685: END;
686: IF (l_count > 0 ) THEN --ANY OF GROUP TASK IS active
687: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');--new message WMS_ATF_DISPATCH_TASK_EXP
688: fnd_msg_pub.ADD;
689: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
690: l_msg := 'Dispatcher task can be updated only if any of the task in group is not in Active status';
691: IF(l_debug = 1) THEN
703: IF (p_task_rec.status_id = 9 ) THEN
704: IF p_new_task_status in (1,8) THEN
705: p_output_task_rec.status_id := p_new_task_status;
706: ELSE
707: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
708: fnd_msg_pub.ADD;
709: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
710: l_msg := 'Active task can be moved only to Pending or Unreleased state';
711: IF(l_debug = 1) THEN
718: ELSIF (p_task_rec.status_id = 3 ) THEN
719: IF p_new_task_status in (1,8) THEN
720: p_output_task_rec.status_id := p_new_task_status;
721: ELSE
722: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
723: fnd_msg_pub.ADD;
724: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
725: l_msg := 'Dispatcher task can be moved only to Pending or Unreleased state';
726: IF(l_debug = 1) THEN
733: ELSIF (p_task_rec.status_id = 8 ) THEN
734: IF (p_new_task_status =1 OR (p_new_task_status = 2 AND p_task_rec.task_type_id <> 2 ))THEN
735: p_output_task_rec.status_id := p_new_task_status;
736: ELSE
737: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
738: fnd_msg_pub.ADD;
739: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
740: l_msg := 'Unreleased task can be moved only to Pending or Queued state';
741: IF(l_debug = 1) THEN
748: ELSIF (p_task_rec.status_id = 1 ) THEN
749: IF ( p_new_task_status = 2 AND p_task_rec.task_type_id <> 2 )THEN
750: p_output_task_rec.status_id := p_new_task_status;
751: ELSE
752: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
753: fnd_msg_pub.ADD;
754: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
755: l_msg := 'Pending task can be moved only to Queued state';
756: IF(l_debug = 1) THEN
760: p_output_task_rec.ERROR := l_err_msg;
761: RETURN;
762: END IF;
763: ELSE
764: fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
765: fnd_msg_pub.ADD;
766: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
767: l_msg := 'Invalid task status';
768: IF(l_debug = 1) THEN
778: IF (P_new_task_priority IS NOT NULL) THEN
779: IF (p_task_rec.task_type_id <> 2) THEN
780: p_output_task_rec.priority := p_new_task_priority;
781: ELSE
782: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
783: fnd_msg_pub.ADD;
784: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
785: l_msg := 'Inbound task priority cannot be updated';
786: IF(l_debug = 1) THEN
803: IF (P_new_task_type IS NOT NULL) THEN
804: OPEN c_usr_task_type(p_task_rec.task_type_id,p_new_task_type,p_task_rec.organization_id);
805: FETCH c_usr_task_type INTO l_usr_task_type_id;
806: IF c_usr_task_type%NOTFOUND THEN
807: fnd_message.set_name('WMS', 'WMS_INVALID_USER_TASK');--new message
808: fnd_msg_pub.ADD;
809: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
810: l_msg := 'Standard task type associated with the user task is different from the current standard task type';
811: IF(l_debug = 1) THEN
822: IF (p_new_operation_plan_id IS NOT NULL) THEN
823: IF (p_op_plan_rec.organization_id IS NOT NULL) THEN
824: IF (p_task_rec.organization_id <> p_op_plan_rec.organization_id) THEN
825: IF(p_op_plan_rec.common_to_all_org <> 'Y') THEN
826: fnd_message.set_name('WMS', 'WMS_OPER_PLAN_ORG_INVALID');--new message
827: fnd_msg_pub.ADD;
828: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
829: p_output_task_rec.RESULT := 'E';
830: p_output_task_rec.ERROR := l_err_msg;
852: ( p_op_plan_rec.plan_type_id = 1 AND l_operation_plan_type_id = 1) OR
853: ( p_op_plan_rec.plan_type_id = 2 AND l_operation_plan_type_id = 2 )) THEN
854: p_output_task_rec.operation_plan_id := p_new_operation_plan_id;
855: ELSE
856: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
857: fnd_msg_pub.ADD;
858: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
859: p_output_task_rec.RESULT := 'E';
860: p_output_task_rec.ERROR := l_err_msg;
865: END IF;
866: RETURN;
867: END IF;
868: ELSE
869: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
870: fnd_msg_pub.ADD;
871: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
872: p_output_task_rec.RESULT := 'E';
873: p_output_task_rec.ERROR := l_err_msg;
881:
882:
883: IF ( p_op_plan_rec.activity_type_id = 1) THEN --INBOUND CASE
884: IF(p_task_rec.task_type_id <> 2) THEN --putaway
885: fnd_message.set_name('WMS', 'WMS_INVALID_OP_PLAN_ACTIVITY');--new message
886: fnd_msg_pub.ADD;
887: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
888: p_output_task_rec.ERROR := l_err_msg;
889: p_output_task_rec.RESULT := 'E';
905: INTO l_op_plan_b_rec;
906: IF (C_OP_PLANS_B%NOTFOUND) THEN
907: IF (l_debug=1) THEN
908: inv_trx_util_pub.trace('Records not found in WMS_OP_PLANS_B for given p_new_operation_plan_id');
909: fnd_message.set_name('WMS', ' WMS_INVALID_TASK');--new message
910: fnd_msg_pub.ADD;
911: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
912: l_msg := 'No of Records found in WMS_OP_PLANS_B for given operation plan id';
913: IF(l_debug = 1) THEN
936: INTO l_operation_plan_detail_rec;
937: IF (c_plan_detail%NOTFOUND) THEN
938: IF (l_debug=1) THEN
939: inv_trx_util_pub.trace('Records not found in WMS_OP_PLAN_DETAILS for given operation plan id');
940: fnd_message.set_name('WMS', ' WMS_INVALID_TASK');--new message
941: fnd_msg_pub.ADD;
942: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
943: l_msg := 'No of Records found in WMS_OP_PLAN_DETAILS for given operation plan id';
944: IF(l_debug = 1) THEN
966: END IF;
967: END IF;
968:
969: ELSE
970: fnd_message.set_name('WMS', ' WMS_INVALID_TASK');--new message
971: fnd_msg_pub.ADD;
972: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
973: l_msg := 'STATUS in wms_op_plan_instances is not pending';
974: IF(l_debug = 1) THEN
1009: ELSE --outbound case
1010: --for outbound case wopi , wooi is not impacted as I could observe by creating records.
1011: --just updating the plan id should be enough.needs to be investigated further
1012: IF (p_task_rec.task_type_id <> 1) THEN --if not a pick task then error out
1013: fnd_message.set_name('WMS', 'WMS_INVALID_OP_PLAN_ACTIVITY');--new message
1014: fnd_msg_pub.ADD;
1015: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
1016: l_msg := 'Mismatch in the operation plan activity type and task type';
1017: IF(l_debug = 1) THEN
1095: l_task_type := 3 ; --cycle count.
1096: END IF ;
1097: IF (l_task_exists = 0 ) THEN
1098: --Still no task, this is invalid id.
1099: fnd_message.set_name('WMS', 'INVALID_TASK');
1100: fnd_msg_pub.ADD;
1101: x_validation_status:= 'E';
1102: END IF;
1103: --Need to check status in WDT .
1135: END IF;
1136: IF ( l_parent_line_id > 0 AND l_task_type = 1 ) THEN --This is nbulk pick
1137: IF (l_parent_line_id <> p_transaction_number ) THEN
1138: --The input is a child of bulk task.Fail validation.
1139: fnd_message.set_name('WMS', 'INVALID_TASK');
1140: fnd_msg_pub.ADD;
1141: x_validation_status:= 'E';
1142: END IF;
1143: END IF;
1143: END IF;
1144: -- 6850212 Start
1145: IF p_action = 'MODIFY' THEN
1146: IF (l_wdt_status NOT IN (0,2,3,9)) THEN
1147: --fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
1148: --fnd_msg_pub.ADD;
1149: x_validation_status:= 'E';
1150: END IF;
1151: ELSE
1149: x_validation_status:= 'E';
1150: END IF;
1151: ELSE
1152: IF( l_wdt_status NOT IN (0,2) ) THEN
1153: --fnd_message.set_name('WMS', 'WMS_ATF_INVALID_TASK_STATUS');
1154: --fnd_msg_pub.ADD;
1155: x_validation_status:= 'E';
1156: END IF;
1157: END IF;
1270: CLOSE carton_lpn_csr;
1271: --if carton lpn is passed and is not valid then no need to proceed further
1272: IF(l_carton_lpn_ctx NOT IN (5,8)) THEN
1273: x_return_status := fnd_api.g_ret_sts_error;
1274: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1275: fnd_msg_pub.ADD;
1276: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1277: l_error_msg :='Invalid context for Carton LPN:'||p_new_carton_lpn_id;
1278: IF(l_debug = 1) THEN
1302: FOR i IN 1..p_task_table.count
1303: LOOP
1304: IF (p_task_table(i).organization_id <> l_carton_lpn_org) THEN
1305: x_return_status := fnd_api.g_ret_sts_error;
1306: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1307: fnd_msg_pub.ADD;
1308: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1309: l_error_msg :='Organization is not same for Carton LPN and Task';
1310: IF(l_debug = 1) THEN
1318: IF c_bulk_task%NOTFOUND THEN
1319: CLOSE c_bulk_task;
1320: ELSE
1321: x_return_status := fnd_api.g_ret_sts_error;
1322: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1323: fnd_msg_pub.ADD;
1324: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1325: l_error_msg :='Bulk Tasks cannot be cartonized';
1326: IF(l_debug = 1) THEN
1347: l_temp_del_detail_id := NULL;
1348: END;
1349: IF (l_temp_del_detail_id IS NULL) THEN
1350: x_return_status := fnd_api.g_ret_sts_error;
1351: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1352: fnd_msg_pub.ADD;
1353: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1354: l_error_msg :='Data not present in WDD for the corresponding task :'||p_task_table(i).transaction_number;
1355: IF(l_debug = 1) THEN
1381: FOR i IN 1..l_del_id_tab.COUNT
1382: LOOP
1383: IF nvl(l_del_id_tab(1),-999) <> nvl(l_del_id_tab(i),-999) THEN
1384: x_return_status := fnd_api.g_ret_sts_error;
1385: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1386: fnd_msg_pub.ADD;
1387: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1388: l_error_msg :='Delivery mismatch,cartonization cannot be done';
1389: IF(l_debug = 1) THEN
1413: FOR i IN 1..l_carton_grp_id_tab.COUNT
1414: LOOP
1415: IF nvl(l_carton_grp_id_tab(1),-999) <> nvl(l_carton_grp_id_tab(i),-999) THEN
1416: x_return_status := fnd_api.g_ret_sts_error;
1417: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERR');
1418: fnd_msg_pub.ADD;
1419: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => x_error_msg );
1420: l_error_msg :='Carton group mismatch,cartonization cannot be done';
1421: IF(l_debug = 1) THEN
5099: IF l_debug = 1 THEN
5100: debug_print('The called program returned error' );
5101: END IF;
5102: --anjana
5103: FND_MESSAGE.SET_NAME('WMS', 'WMS_TASK_DELETE_ERROR');
5104: l_msg := fnd_message.get;
5105: x_msg_count := x_msg_count + 1;
5106: x_msg_data := x_msg_data || l_msg;
5107:
5100: debug_print('The called program returned error' );
5101: END IF;
5102: --anjana
5103: FND_MESSAGE.SET_NAME('WMS', 'WMS_TASK_DELETE_ERROR');
5104: l_msg := fnd_message.get;
5105: x_msg_count := x_msg_count + 1;
5106: x_msg_data := x_msg_data || l_msg;
5107:
5108: x_undeleted_tasks(undel_task).transaction_number:= x_task_rec.transaction_number;
5121: ELSE
5122: IF l_debug = 1 THEN
5123: debug_print('Validate_task returned error for this record' );
5124: END IF;
5125: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_TASK');
5126: --anjana
5127: l_msg := fnd_message.get;
5128: x_msg_count := x_msg_count + 1;
5129: x_msg_data := x_msg_data || l_msg;
5123: debug_print('Validate_task returned error for this record' );
5124: END IF;
5125: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_TASK');
5126: --anjana
5127: l_msg := fnd_message.get;
5128: x_msg_count := x_msg_count + 1;
5129: x_msg_data := x_msg_data || l_msg;
5130: -- FND_MSG_PUB.ADD;
5131: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5150: IF l_debug = 1 THEN
5151: debug_print('In the Unexpected Error of Delete_Tasks, Rolling back.' );
5152: END IF;
5153: x_return_status := l_g_ret_sts_unexp_error;
5154: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5155: FND_MSG_PUB.ADD;
5156: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5157: ROLLBACK TO deltask;
5158: WHEN OTHERS THEN
5159: IF l_debug = 1 THEN
5160: debug_print('In the When Others Exception of Delete_Tasks, Rolling back.' );
5161: END IF;
5162: x_return_status := l_g_ret_sts_unexp_error;
5163: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5164: FND_MSG_PUB.ADD;
5165: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5166: ROLLBACK TO deltask;
5167: END DELETE_TASKS;
6141: END IF;
6142: EXCEPTION
6143: WHEN NO_DATA_FOUND THEN
6144: inv_trx_util_pub.trace('in the exception block of outbond/manufacturing/warehousing complete tasks');
6145: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
6146: fnd_msg_pub.ADD;
6147: x_return_status := fnd_api.g_ret_sts_unexp_error;
6148: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6149: l_err_msg := 'Failed to fetch data from MMTT,MCCE,MMT or WDTH tables for transaction number '||p_transaction_number;
6180: WHERE query_name = p_query_name
6181: ORDER BY 1;
6182: EXCEPTION
6183: WHEN OTHERS THEN
6184: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6185: fnd_msg_pub.ADD;
6186: l_err_msg := substr(SQLERRM,1,1000);
6187: RAISE l_qry_fail;
6188: END;
6237: l_execute_qry := TRUE;
6238: ELSE
6239: l_execute_qry := FALSE;
6240: l_err_msg := 'Invalid query criteria';
6241: fnd_message.set_name('WMS', 'WMS_NO_SOURCE_ENTERED');
6242: fnd_msg_pub.ADD;
6243: RAISE l_qry_fail;
6244: END IF;
6245: END IF;
6270: AND (g_main_tab(93).field_value = FND_API.G_FALSE))
6271: THEN
6272: l_execute_qry := FALSE;
6273: l_err_msg := 'Invalid query criteria';
6274: fnd_message.set_name('WMS', 'WMS_NO_SOURCE_ENTERED');
6275: fnd_msg_pub.ADD;
6276: RAISE l_qry_fail;
6277: END IF;
6278:
6283: FROM wms_saved_queries
6284: WHERE query_name = p_query_name;
6285: EXCEPTION
6286: WHEN OTHERS THEN
6287: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
6288: fnd_msg_pub.ADD;
6289: l_err_msg := concat('Invalid Org: ',substr(SQLERRM,1,1000));
6290: RAISE l_invalid_org;
6291: NULL;
6555: END IF; --- if l_execute_qry then
6556:
6557: ELSE
6558: x_return_status := fnd_api.g_ret_sts_unexp_error;
6559: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6560: fnd_msg_pub.ADD;
6561: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6562: inv_trx_util_pub.trace(l_api_name||': '||'Invalid Parameters Passed');
6563: END IF; ----if p_transaction_number is not null
7031: l_new_tasks_tbl ,
7032: l_return_status ,
7033: l_msg_count ,
7034: l_msg_data );
7035: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7036: fnd_msg_pub.ADD;
7037: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7038:
7039: IF l_new_tasks_tbl.COUNT > 0 THEN
7055: l_new_tasks_tbl ,
7056: l_return_status ,
7057: l_msg_count ,
7058: l_msg_data );
7059: fnd_message.set_name('INV', 'INV_LOT_INDIVISIBLE');
7060: fnd_msg_pub.ADD;
7061: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7062:
7063: IF l_new_tasks_tbl.COUNT > 0 THEN
7076: l_new_tasks_tbl ,
7077: l_return_status ,
7078: l_msg_count ,
7079: l_msg_data );
7080: fnd_message.set_name('WMS', 'WMS_INVALID_SPLIT_QUANTITY');
7081: fnd_msg_pub.ADD;
7082: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7083:
7084: IF l_new_tasks_tbl.COUNT > 0 THEN
7100: l_new_tasks_tbl ,
7101: l_return_status ,
7102: l_msg_count ,
7103: l_msg_data );
7104: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');
7105: fnd_msg_pub.ADD;
7106: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7107:
7108: IF l_new_tasks_tbl.COUNT > 0 THEN
7118: print_msg(l_procedure_name,'EXCEPTION BLOCK : Unexpected error has occured, ROLLING BACK THE TRANSACTIONS');
7119: END IF;
7120: x_return_status := 'E';
7121: ROLLBACK TO wms_split_task;
7122: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7123: fnd_msg_pub.ADD;
7124: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7125: WHEN OTHERS THEN
7126: IF g_debug = 1 THEN
7127: print_msg(l_procedure_name,'EXCEPTION BLOCK : Unexpected error has occured, ROLLING BACK THE TRANSACTIONS');
7128: END IF;
7129: x_return_status := 'E';
7130: ROLLBACK TO wms_split_task;
7131: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7132: fnd_msg_pub.ADD;
7133: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7134: x_return_status := 'E';
7135: IF g_debug = 1 THEN
7302: IF (p_new_task_status IS NOT NULL) THEN
7303: IF(p_new_task_status NOT IN (1,2,8)) THEN
7304: --6850212:Return status should not be set to error.
7305: --x_return_status := fnd_api.g_ret_sts_error;
7306: fnd_message.set_name('WMS', 'WMS_INVALID_TASK_STATUS');--new message
7307: fnd_msg_pub.ADD;
7308: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7309: x_msg_data := l_msg;
7310: x_msg_count := l_msg_count;
7328: l_op_plan_rec.plan_type_id;
7329: IF (l_op_plan_rec.eabled_flag <> 'Y') THEN--op_plan passed is not enabled
7330: --6850212:Return status should not be set to error.
7331: --x_return_status := fnd_api.g_ret_sts_error;
7332: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
7333: fnd_msg_pub.ADD;
7334: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7335: x_msg_data := l_msg;
7336: x_msg_count := l_msg_count;
7369: x_msg_data => p_msg_data);
7370:
7371: --if quey was not successfull then populate output table with passed values with error
7372: IF ((p_return_sts <> fnd_api.g_ret_sts_success) OR ( temp_task_tab.count = 0)) THEN
7373: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');--new message
7374: -- fnd_msg_pub.ADD;
7375: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg);
7376: --anjana
7377: l_msg := fnd_message.get;
7373: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');--new message
7374: -- fnd_msg_pub.ADD;
7375: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg);
7376: --anjana
7377: l_msg := fnd_message.get;
7378: x_msg_data := x_msg_data || l_msg;
7379: x_msg_count := x_msg_count + 1;
7380:
7381: l_err_msg :='Error in querying task from Query_task API for transaction_number :'||p_task_table(i).transaction_number ||'This task will be skipped';
7389: ELSE --if query success
7390: x_updated_tasks(i) := temp_task_tab(1);--assigning the queried results to output table
7391: END IF;
7392: ELSE
7393: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7394: -- fnd_msg_pub.ADD;
7395: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7396: --anjana
7397: l_msg := fnd_message.get;
7393: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7394: -- fnd_msg_pub.ADD;
7395: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7396: --anjana
7397: l_msg := fnd_message.get;
7398: x_msg_data := x_msg_data || l_msg;
7399: x_msg_count := x_msg_count + 1;
7400:
7401: x_updated_tasks(i) := l_updated_tasks(i);
7405: END IF;
7406: END LOOP;--Loop ends
7407: ELSE
7408: x_return_status := fnd_api.g_ret_sts_unexp_error;
7409: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7410: fnd_msg_pub.ADD;
7411: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7412: x_msg_data := l_msg;
7413: x_msg_count := l_msg_count;
7428: IF (l_updated_tasks.count = l_valid_task_counter)THEN
7429: FOR i in 1..l_updated_tasks.count
7430: LOOP
7431: IF ((l_updated_tasks(1).task_type_id <> 1) OR (l_updated_tasks(i).task_type_id <> l_updated_tasks(1).task_type_id )) THEN
7432: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7433: fnd_msg_pub.ADD;
7434: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7435: l_err_msg :='Cartonization can be done only on Outbound tasks(Sales order/WIP)';
7436: x_msg_data := l_msg;
7461: RETURN;
7462: END IF;
7463: ELSE
7464: x_return_status := fnd_api.g_ret_sts_error;
7465: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7466: fnd_msg_pub.ADD;
7467: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7468: l_err_msg := 'Some tasks have failed validation,cartonization cannot be done';
7469: IF(l_debug = 1) THEN
7762: inv_trx_util_pub.trace('cancel_task CANCEL_TASK: x_return_status: ' || x_return_status);
7763: END IF;
7764:
7765: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
7766: FND_MESSAGE.SET_NAME('WMS', 'WMS_CANCEL_FAILED');
7767: l_msg := fnd_message.get;
7768: x_msg_count := x_msg_count + 1;
7769: x_msg_data := x_msg_data || l_msg;
7770:
7763: END IF;
7764:
7765: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
7766: FND_MESSAGE.SET_NAME('WMS', 'WMS_CANCEL_FAILED');
7767: l_msg := fnd_message.get;
7768: x_msg_count := x_msg_count + 1;
7769: x_msg_data := x_msg_data || l_msg;
7770:
7771: x_unprocessed_crossdock_tasks(l_unprocessed_crossdock_count).transaction_number := l_transaction_number;
7774: l_unprocessed_crossdock_count :=l_unprocessed_crossdock_count+1;
7775: ROLLBACK TO SAVEPOINT1;
7776: END IF;
7777: ELSE
7778: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_TASK');
7779: l_msg := fnd_message.get;
7780: x_msg_count := x_msg_count + 1;
7781: x_msg_data := x_msg_data || l_msg;
7782: IF l_debug = 1 THEN
7775: ROLLBACK TO SAVEPOINT1;
7776: END IF;
7777: ELSE
7778: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_TASK');
7779: l_msg := fnd_message.get;
7780: x_msg_count := x_msg_count + 1;
7781: x_msg_data := x_msg_data || l_msg;
7782: IF l_debug = 1 THEN
7783: inv_trx_util_pub.trace('Validate_task returned error for this record');