[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
5188: IF l_debug = 1 THEN
5189: debug_print('The called program returned error' );
5190: END IF;
5191: --anjana
5192: FND_MESSAGE.SET_NAME('WMS', 'WMS_TASK_DELETE_ERROR');
5193: l_msg := fnd_message.get;
5194: x_msg_count := x_msg_count + 1;
5195: x_msg_data := x_msg_data || l_msg;
5196:
5189: debug_print('The called program returned error' );
5190: END IF;
5191: --anjana
5192: FND_MESSAGE.SET_NAME('WMS', 'WMS_TASK_DELETE_ERROR');
5193: l_msg := fnd_message.get;
5194: x_msg_count := x_msg_count + 1;
5195: x_msg_data := x_msg_data || l_msg;
5196:
5197: x_undeleted_tasks(undel_task).transaction_number:= x_task_rec.transaction_number;
5210: ELSE
5211: IF l_debug = 1 THEN
5212: debug_print('Validate_task returned error for this record' );
5213: END IF;
5214: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_TASK');
5215: --anjana
5216: l_msg := fnd_message.get;
5217: x_msg_count := x_msg_count + 1;
5218: x_msg_data := x_msg_data || l_msg;
5212: debug_print('Validate_task returned error for this record' );
5213: END IF;
5214: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_TASK');
5215: --anjana
5216: l_msg := fnd_message.get;
5217: x_msg_count := x_msg_count + 1;
5218: x_msg_data := x_msg_data || l_msg;
5219: -- FND_MSG_PUB.ADD;
5220: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5239: IF l_debug = 1 THEN
5240: debug_print('In the Unexpected Error of Delete_Tasks, Rolling back.' );
5241: END IF;
5242: x_return_status := l_g_ret_sts_unexp_error;
5243: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5244: FND_MSG_PUB.ADD;
5245: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5246: ROLLBACK TO deltask;
5247: WHEN OTHERS THEN
5248: IF l_debug = 1 THEN
5249: debug_print('In the When Others Exception of Delete_Tasks, Rolling back.' );
5250: END IF;
5251: x_return_status := l_g_ret_sts_unexp_error;
5252: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERROR');
5253: FND_MSG_PUB.ADD;
5254: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
5255: ROLLBACK TO deltask;
5256: END DELETE_TASKS;
6236: END IF;
6237: EXCEPTION
6238: WHEN NO_DATA_FOUND THEN
6239: inv_trx_util_pub.trace('in the exception block of outbond/manufacturing/warehousing complete tasks');
6240: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
6241: fnd_msg_pub.ADD;
6242: x_return_status := fnd_api.g_ret_sts_unexp_error;
6243: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6244: l_err_msg := 'Failed to fetch data from MMTT,MCCE,MMT or WDTH tables for transaction number '||p_transaction_number;
6275: WHERE query_name = p_query_name
6276: ORDER BY 1;
6277: EXCEPTION
6278: WHEN OTHERS THEN
6279: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6280: fnd_msg_pub.ADD;
6281: l_err_msg := substr(SQLERRM,1,1000);
6282: RAISE l_qry_fail;
6283: END;
6332: l_execute_qry := TRUE;
6333: ELSE
6334: l_execute_qry := FALSE;
6335: l_err_msg := 'Invalid query criteria';
6336: fnd_message.set_name('WMS', 'WMS_NO_SOURCE_ENTERED');
6337: fnd_msg_pub.ADD;
6338: RAISE l_qry_fail;
6339: END IF;
6340: END IF;
6365: AND (g_main_tab(93).field_value = FND_API.G_FALSE))
6366: THEN
6367: l_execute_qry := FALSE;
6368: l_err_msg := 'Invalid query criteria';
6369: fnd_message.set_name('WMS', 'WMS_NO_SOURCE_ENTERED');
6370: fnd_msg_pub.ADD;
6371: RAISE l_qry_fail;
6372: END IF;
6373:
6378: FROM wms_saved_queries
6379: WHERE query_name = p_query_name;
6380: EXCEPTION
6381: WHEN OTHERS THEN
6382: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');
6383: fnd_msg_pub.ADD;
6384: l_err_msg := concat('Invalid Org: ',substr(SQLERRM,1,1000));
6385: RAISE l_invalid_org;
6386: NULL;
6650: END IF; --- if l_execute_qry then
6651:
6652: ELSE
6653: x_return_status := fnd_api.g_ret_sts_unexp_error;
6654: fnd_message.set_name('WMS', 'WMS_INVALID_VALUE');
6655: fnd_msg_pub.ADD;
6656: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
6657: inv_trx_util_pub.trace(l_api_name||': '||'Invalid Parameters Passed');
6658: END IF; ----if p_transaction_number is not null
7130: l_new_tasks_tbl ,
7131: l_return_status ,
7132: l_msg_count ,
7133: l_msg_data );
7134: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7135: fnd_msg_pub.ADD;
7136: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7137:
7138: IF l_new_tasks_tbl.COUNT > 0 THEN
7154: l_new_tasks_tbl ,
7155: l_return_status ,
7156: l_msg_count ,
7157: l_msg_data );
7158: fnd_message.set_name('INV', 'INV_LOT_INDIVISIBLE');
7159: fnd_msg_pub.ADD;
7160: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7161:
7162: IF l_new_tasks_tbl.COUNT > 0 THEN
7175: l_new_tasks_tbl ,
7176: l_return_status ,
7177: l_msg_count ,
7178: l_msg_data );
7179: fnd_message.set_name('WMS', 'WMS_INVALID_SPLIT_QUANTITY');
7180: fnd_msg_pub.ADD;
7181: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7182:
7183: IF l_new_tasks_tbl.COUNT > 0 THEN
7199: l_new_tasks_tbl ,
7200: l_return_status ,
7201: l_msg_count ,
7202: l_msg_data );
7203: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');
7204: fnd_msg_pub.ADD;
7205: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7206:
7207: IF l_new_tasks_tbl.COUNT > 0 THEN
7217: print_msg(l_procedure_name,'EXCEPTION BLOCK : Unexpected error has occured, ROLLING BACK THE TRANSACTIONS');
7218: END IF;
7219: x_return_status := 'E';
7220: ROLLBACK TO wms_split_task;
7221: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7222: fnd_msg_pub.ADD;
7223: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7224: WHEN OTHERS THEN
7225: IF g_debug = 1 THEN
7226: print_msg(l_procedure_name,'EXCEPTION BLOCK : Unexpected error has occured, ROLLING BACK THE TRANSACTIONS');
7227: END IF;
7228: x_return_status := 'E';
7229: ROLLBACK TO wms_split_task;
7230: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7231: fnd_msg_pub.ADD;
7232: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7233: x_return_status := 'E';
7234: IF g_debug = 1 THEN
7401: IF (p_new_task_status IS NOT NULL) THEN
7402: IF(p_new_task_status NOT IN (1,2,8)) THEN
7403: --6850212:Return status should not be set to error.
7404: --x_return_status := fnd_api.g_ret_sts_error;
7405: fnd_message.set_name('WMS', 'WMS_INVALID_TASK_STATUS');--new message
7406: fnd_msg_pub.ADD;
7407: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7408: x_msg_data := l_msg;
7409: x_msg_count := l_msg_count;
7427: l_op_plan_rec.plan_type_id;
7428: IF (l_op_plan_rec.eabled_flag <> 'Y') THEN--op_plan passed is not enabled
7429: --6850212:Return status should not be set to error.
7430: --x_return_status := fnd_api.g_ret_sts_error;
7431: fnd_message.set_name('WMS', 'WMS_OPERTN_PLAN_ID_INVALID');--new message
7432: fnd_msg_pub.ADD;
7433: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7434: x_msg_data := l_msg;
7435: x_msg_count := l_msg_count;
7468: x_msg_data => p_msg_data);
7469:
7470: --if quey was not successfull then populate output table with passed values with error
7471: IF ((p_return_sts <> fnd_api.g_ret_sts_success) OR ( temp_task_tab.count = 0)) THEN
7472: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');--new message
7473: -- fnd_msg_pub.ADD;
7474: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg);
7475: --anjana
7476: l_msg := fnd_message.get;
7472: fnd_message.set_name('WMS', 'WMS_QUERY_ELIG_MATRL');--new message
7473: -- fnd_msg_pub.ADD;
7474: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg);
7475: --anjana
7476: l_msg := fnd_message.get;
7477: x_msg_data := x_msg_data || l_msg;
7478: x_msg_count := x_msg_count + 1;
7479:
7480: 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';
7488: ELSE --if query success
7489: x_updated_tasks(i) := temp_task_tab(1);--assigning the queried results to output table
7490: END IF;
7491: ELSE
7492: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7493: -- fnd_msg_pub.ADD;
7494: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7495: --anjana
7496: l_msg := fnd_message.get;
7492: fnd_message.set_name('WMS', 'WMS_INVALID_TASK');
7493: -- fnd_msg_pub.ADD;
7494: -- fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7495: --anjana
7496: l_msg := fnd_message.get;
7497: x_msg_data := x_msg_data || l_msg;
7498: x_msg_count := x_msg_count + 1;
7499:
7500: x_updated_tasks(i) := l_updated_tasks(i);
7504: END IF;
7505: END LOOP;--Loop ends
7506: ELSE
7507: x_return_status := fnd_api.g_ret_sts_unexp_error;
7508: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
7509: fnd_msg_pub.ADD;
7510: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7511: x_msg_data := l_msg;
7512: x_msg_count := l_msg_count;
7527: IF (l_updated_tasks.count = l_valid_task_counter)THEN
7528: FOR i in 1..l_updated_tasks.count
7529: LOOP
7530: 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
7531: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7532: fnd_msg_pub.ADD;
7533: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_msg );
7534: l_err_msg :='Cartonization can be done only on Outbound tasks(Sales order/WIP)';
7535: x_msg_data := l_msg;
7560: RETURN;
7561: END IF;
7562: ELSE
7563: x_return_status := fnd_api.g_ret_sts_error;
7564: fnd_message.set_name('WMS', 'WMS_CARTONIZATION_ERROR');--new message
7565: fnd_msg_pub.ADD;
7566: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data );
7567: l_err_msg := 'Some tasks have failed validation,cartonization cannot be done';
7568: IF(l_debug = 1) THEN
7861: inv_trx_util_pub.trace('cancel_task CANCEL_TASK: x_return_status: ' || x_return_status);
7862: END IF;
7863:
7864: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
7865: FND_MESSAGE.SET_NAME('WMS', 'WMS_CANCEL_FAILED');
7866: l_msg := fnd_message.get;
7867: x_msg_count := x_msg_count + 1;
7868: x_msg_data := x_msg_data || l_msg;
7869:
7862: END IF;
7863:
7864: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
7865: FND_MESSAGE.SET_NAME('WMS', 'WMS_CANCEL_FAILED');
7866: l_msg := fnd_message.get;
7867: x_msg_count := x_msg_count + 1;
7868: x_msg_data := x_msg_data || l_msg;
7869:
7870: x_unprocessed_crossdock_tasks(l_unprocessed_crossdock_count).transaction_number := l_transaction_number;
7873: l_unprocessed_crossdock_count :=l_unprocessed_crossdock_count+1;
7874: ROLLBACK TO SAVEPOINT1;
7875: END IF;
7876: ELSE
7877: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_TASK');
7878: l_msg := fnd_message.get;
7879: x_msg_count := x_msg_count + 1;
7880: x_msg_data := x_msg_data || l_msg;
7881: IF l_debug = 1 THEN
7874: ROLLBACK TO SAVEPOINT1;
7875: END IF;
7876: ELSE
7877: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_TASK');
7878: l_msg := fnd_message.get;
7879: x_msg_count := x_msg_count + 1;
7880: x_msg_data := x_msg_data || l_msg;
7881: IF l_debug = 1 THEN
7882: inv_trx_util_pub.trace('Validate_task returned error for this record');