APPS.WMS_TASK_MGMT_PUB dependencies on WMS_OP_PLAN_DETAILS

Line 574: FROM WMS_OP_PLAN_DETAILS

570: SELECT operation_plan_detail_id
571: , operation_sequence
572: , is_in_inventory
573: , operation_type
574: FROM WMS_OP_PLAN_DETAILS
575: WHERE operation_plan_id = v_operation_plan_id
576: AND operation_sequence = (SELECT MIN(operation_sequence)
577: FROM WMS_OP_PLAN_DETAILS
578: WHERE operation_plan_id=v_operation_plan_id);

Line 577: FROM WMS_OP_PLAN_DETAILS

573: , operation_type
574: FROM WMS_OP_PLAN_DETAILS
575: WHERE operation_plan_id = v_operation_plan_id
576: AND operation_sequence = (SELECT MIN(operation_sequence)
577: FROM WMS_OP_PLAN_DETAILS
578: WHERE operation_plan_id=v_operation_plan_id);
579:
580: CURSOR C_OP_PLANS_B(v_operation_plan_id NUMBER) IS
581: SELECT OPERATION_PLAN_ID,

Line 939: inv_trx_util_pub.trace('Records not found in WMS_OP_PLAN_DETAILS for given operation plan id');

935: FETCH c_plan_detail
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';

Line 943: l_msg := 'No of Records found in WMS_OP_PLAN_DETAILS for given operation plan id';

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
945: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
946: END IF;
947: p_output_task_rec.RESULT := 'E';